private void GetOrders(string OrderNO)
{
DailyOrdersDAL ONSODAL = new DailyOrdersDAL();
ONSODAL.ConnectionString = ConfigurationManager.ConnectionStrings["MySQLConn"].ToString();
List <DailyOrders> ClientInvoiceList = ONSODAL.GetOrders(OrderNO);
gvDailyorders.DataSource = ClientInvoiceList;
gvDailyorders.DataBind();
}
protected void BtnExport_Click(object sender, EventArgs e)
{
DailyOrdersDAL ONSODAL = new DailyOrdersDAL();
ONSODAL.ConnectionString = ConfigurationManager.ConnectionStrings["MySQLConn"].ToString();
List <DailyOrders> DailyOredsList = ONSODAL.GetOrders(null);
var mem = new MemoryStream();
var writer = new StreamWriter(mem, Encoding.UTF8, 1024, true);
var csvWriter = new CsvWriter(writer);
csvWriter.Configuration.Delimiter = ",";
csvWriter.WriteField("ID");
csvWriter.WriteField("PIN");
csvWriter.WriteField("EmployeeID");
csvWriter.WriteField("FirstName");
csvWriter.WriteField("LastName");
csvWriter.WriteField("CatalogName");
csvWriter.WriteField("Quantity");
csvWriter.WriteField("OrderDate");
csvWriter.WriteField("P2MOrderNumber");
csvWriter.WriteField("GRSOrderNum");
csvWriter.WriteField("ItemNumber");
csvWriter.WriteField("JobTitle");
csvWriter.WriteField("OrderStatus");
csvWriter.WriteField("ProductCost");
csvWriter.WriteField("RewardName");
csvWriter.NextRecord();
int lenght = DailyOredsList.Count - 1;
for (int i = 0; i <= lenght; i++)
{
csvWriter.WriteField(DailyOredsList[i].ID);
csvWriter.WriteField(DailyOredsList[i].PIN);
csvWriter.WriteField(DailyOredsList[i].EmployeeID);
csvWriter.WriteField(DailyOredsList[i].FirstName);
csvWriter.WriteField(DailyOredsList[i].LastName);
csvWriter.WriteField(DailyOredsList[i].CatalogName);
csvWriter.WriteField(DailyOredsList[i].Quantity);
csvWriter.WriteField(DailyOredsList[i].OrderDate);
csvWriter.WriteField(DailyOredsList[i].P2MOrderNumber);
csvWriter.WriteField(DailyOredsList[i].GRSOrderNum);
csvWriter.WriteField(DailyOredsList[i].PartnerSystemOrderNum);
csvWriter.WriteField(DailyOredsList[i].ItemNumber);
csvWriter.WriteField(DailyOredsList[i].JobTitle);
csvWriter.WriteField(DailyOredsList[i].OrderStatus);
csvWriter.WriteField(DailyOredsList[i].ProductCost);
csvWriter.WriteField(DailyOredsList[i].RewardName);
csvWriter.NextRecord();
}
writer.Flush();
var data = Encoding.UTF8.GetString(mem.ToArray());
Response.Clear();
Response.AddHeader("content-disposition", "attachment; filename=DailyOrders.csv");
Response.Charset = "";
Response.ContentType = "text/csv";
Response.Write(data.ToString());
Response.End();
}
