private void GetGiftCardsInvoice(string OrederNo, string empID, DateTime sdate, DateTime edate)
{
string ONO = OrederNo;
string empid = empID;
GiftCardsInvoiceDAL GCIDAL = new GiftCardsInvoiceDAL();
GCIDAL.ConnectionString = ConfigurationManager.ConnectionStrings["MySQLConn"].ToString();
List <Gift_Cards_Invoice> GCIList = GCIDAL.GetGiftCardsInvoice(ONO, empid, sdate, edate);
gvGCI.DataSource = GCIList;
gvGCI.DataBind();
}
protected void BtnExport_Click(object sender, EventArgs e)
{
//DateTime sdate = Convert.ToDateTime(tbSDate.Text);
//DateTime edate = Convert.ToDateTime(tbEDate.Text);
ClientsInvoicesDAL clientInvoice = new ClientsInvoicesDAL();
GiftCardsInvoiceDAL GCIDAL = new GiftCardsInvoiceDAL();
GCIDAL.ConnectionString = ConfigurationManager.ConnectionStrings["MySQLConn"].ToString();
List <Gift_Cards_Invoice> GCList = GCIDAL.GetGiftCardsInvoice(null, null, sdate, edate);
List <Gift_Cards_Invoice> TotalInvoicesList = GCIDAL.GetGCTotal(sdate, edate);
foreach (var val in TotalInvoicesList)
{
TotalLocalCost = Convert.ToDouble(val.TotalLocalCost);
TotalUSDCost = Convert.ToDouble(val.TotalUSDCost);
}
var mem = new MemoryStream();
var writer = new StreamWriter(mem, Encoding.UTF8, 1024, true);
var csvWriter = new CsvWriter(writer);
csvWriter.Configuration.Delimiter = ",";
csvWriter.WriteField("OrderId");
csvWriter.WriteField("EmployeeID");
csvWriter.WriteField("LineNumber");
csvWriter.WriteField("RewardName");
csvWriter.WriteField("OrderDate");
csvWriter.WriteField("Quantity");
csvWriter.WriteField("LocalCost");
csvWriter.WriteField("USDCost");
csvWriter.WriteField("TotalUSDCost");
csvWriter.WriteField("TotalLocalCost");
csvWriter.NextRecord();
int lenght = GCList.Count - 1;
for (int i = 0; i <= lenght; i++)
{
csvWriter.WriteField(GCList[i].OrderId);
csvWriter.WriteField(GCList[i].EmployeeID);
csvWriter.WriteField(GCList[i].LineNumber);
csvWriter.WriteField(GCList[i].RewardName);
csvWriter.WriteField(GCList[i].OrderDate);
csvWriter.WriteField(GCList[i].Quantity);
csvWriter.WriteField(GCList[i].LocalCost);
csvWriter.WriteField(GCList[i].USDCost);
csvWriter.WriteField(TotalUSDCost);
csvWriter.WriteField(TotalLocalCost);
csvWriter.NextRecord();
}
writer.Flush();
var data = Encoding.UTF8.GetString(mem.ToArray());
Response.Clear();
Response.AddHeader("content-disposition", "attachment; filename=GiftCardsInvoice.csv");
Response.Charset = "";
Response.ContentType = "text/csv";
Response.Write(data.ToString());
Response.End();
}