BearCommon.DonationsExport.ExportCsv C# (CSharp) Метод

ExportCsv() публичный Метод

public ExportCsv ( ) : void
Результат void
        public void ExportCsv()
        {
            bearcampEntities db = new bearcampEntities();

            var donations = from n in db.Donations
                            select new DonationsModel
                                {
                                    DonationsID = n.DonationsID,
                                   DonorID = n.DonorID,
                                   DonationAmount = n.DonationAmount,
                                   DonationsDate = n.DonataionDate,
                                   Comments = n.Comments
                                   //DonationType = n.DonationTypeID
                                };

            var csv = donations.ToCsv();

            const string attachment = "attachment; filename=output.csv";
            HttpContext.Current.Response.Clear();
            HttpContext.Current.Response.ClearHeaders();
            HttpContext.Current.Response.ClearContent();
            HttpContext.Current.Response.AddHeader("content-disposition", attachment);
            HttpContext.Current.Response.ContentType = "text/csv";
            HttpContext.Current.Response.AddHeader("Pragma", "public");
            HttpContext.Current.Response.Write(csv);
            HttpContext.Current.Response.End();
        }

Usage Example

        public ActionResult ExportDonations()
        {
            if (ModelState.IsValid)
            {
                var export = new DonationsExport();
                //string sConn = ConfigurationManager.ConnectionStrings["export2csvConn"].ToString();

                export.ExportCsv();

                //db.Users.Add(user);
                //db.SaveChanges();
                //return RedirectToAction("Index");
            }

            return Redirect("/Donors"); //View(db.Users.ToList());
        }
DonationsExport