示例#1
0
        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();
        }
示例#2
0
        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();
        }