CRUD Operations In ASP.NET Core 1.0 MVC Application - Part Eight

Add CsvOutputFormatter in WebApplicationCore.NetCore

• Now, add a new class CsvOutputFormatter.cs in Common folder in WebApplicationCore.NetCore.
  
  
• Open "Add New Item" screen through Solution Context Menu of Common folder >> Add >> Class >> Installed >> .NET Core >> Class.
• Name it CsvOutputFormatter.cs.
• Click OK button.
• It will add a new class CsvOutputFormatter.cs in Common folder.
  
  
• Implement Custom Output Formatter in CsvOutputFormatter class to generate response in CSV format using CsvWriter. To create a new Custom Output Formatter we can use one of following approaches
  
  
• Inherent existing output formatter base class TextOutputFormatter, OutputFormatter or StreamOutputFormatter as per requirement. For example, JsonOutputFormatter and XmlSerializerOutputFormatter inherit TextOutputFormatter. Although, this approach provides many features out of box due to base class, yet it makes formatter little heavier.
• Alternatively, Implement IOutputFormatter interface and we just have to implement two methods: CanWriteResult and WriteAsync. Where CanWriteResult is used to check if this formatter can be used to process response or not, while WriteAsync method performs actual processing on response. We have used this approach as it is simple and efficient.
  
• ASP.NET Core provisions us to implement Custom Response Formatter and Custom Request Formatter separately. In this way, we can use any kind of Response and Request formatter as per requirements. We will discuss Custom Response and Request Formatter in detail in future sessions.
  
  
• We also need to register CsvOutputFormatter, for this purpose, we register it in ConfigureServices method of Startup class with MVC service as Setup Action. Simply put, we have to add CsvOutputFormatter in collection of OutputFormatters of MVC Service.
  
  
  
  1. public class CsvOutputFormatter: IOutputFormatter {
  2. public bool CanWriteResult(OutputFormatterCanWriteContext context) {
  3. if (context == null) {
  4. throw new ArgumentNullException(nameof(context));
  5. }
  7. if (context.ContentType == null || context.ContentType.ToString() == "text/csv") {
  8. return true;
  9. } else {
  10. return false;
  11. }
  12. }
  14. publicasync Task WriteAsync(OutputFormatterWriteContext context) {
  15. if (context == null) {
  16. throw new ArgumentNullException(nameof(context));
  17. }
  19. var response = context.HttpContext.Response;
  20. response.ContentType = "text/csv";
  22. using(var writer = context.WriterFactory(response.Body, Encoding.UTF8)) {
  23. IListlst = context.Object as IList;
  24. CsvWritercsvWriter = new CsvWriter();
  26. string csv = csvWriter.Write(lst, true);
  28. writer.Write(csv);
  30. awaitwriter.FlushAsync();
  31. }
  32. }
  33. }
  1. public void ConfigureServices(IServiceCollection services) {
  2. // Add framework services.
  3. services.AddMvc(options => options.OutputFormatters.Add(new CsvOutputFormatter()));
  5. services.AddSingleton < IConfigurationRoot > (sp => {
  6. return this.Configuration;
  7. });
  8. services.AddScoped < IContactDataAccess, ContactDataAccess > ();
  9. services.AddScoped < IContactBusinessLogic, ContactBusinessLogic > ();
  10. }

GetCsv Action Method and Get CSV Link

• Now, add a new action method GetCsv in WebApplicationCore.NetCore.ContactController class. It is similar to Index Action Method with the exception that it returns List<ContactListVM> and has [Produces("text/csv")] attribute to mark content type to enforce ustilizationof CsvOutputFormatter. We are explicitly checking content type == "text/csv" in CanWriteResult.
  
  
• Add Get CSV link in Contract\Index.cshtml for GetCsv action method.
  
  
  
  1. [Produces("text/csv")]
  2. public List < ContactListVM > GetCsv() {
  3. List < Contact > contacts = this.ContactBusinessLogic.GetContacts();
  4. List < ContactListVM > contactVMs = new List < ContactListVM > ();
  5. ContactListVMcontactVM;
  7. foreach(Contact contact in contacts) {
  8. contactVM = new ContactListVM {
  9. ContactId = contact.ContactId,
  10. ContactNumber = contact.ContactNumber,
  11. Email = contact.Email,
  12. Name = contact.Name,
  13. WebSite = contact.WebSite
  14. };
  15. contactVMs.Add(contactVM);
  16. }
  18. returncontactVMs;
  19. }
  21. <
  22. th >
  23. <
  24. a asp - controller = "Contact"
  25. asp - action = "GetCsv" > Get CSV < /a> <
  26. /th>

Run Application in Debug Mode

• Press F5 or Debug Menu >> Start Debugging or press IIS Express button on Toolbar to start application in debugging mode.
• It will show Home Page in browser.
• Click Contact List Menu Open to open Contact List Page.
• Click Get CSV link it will show open save dialog.
• Save response as CSV.
• Open file, it will open CSV file in default program, most probably in Excel or Notepad.
  
  
  

Sample Source Code

I have placed sample code for this session in "CRUD operations in ASP.NET Core 1.0 MVC Application Part 8_Code.zip" in CodePlex repository.