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 gvDailyorders_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "DeleteOrders") { DailyOrdersDAL ONSODAL = new DailyOrdersDAL(); ONSODAL.ConnectionString = ConfigurationManager.ConnectionStrings["MySQLConn"].ToString(); //ONSODAL.DeleteOldOrders(e.CommandArgument.ToString()); GetOrders(null); } }
private void ReadWriteCSVFile() { string date = System.DateTime.Now.ToString("ddMMyyhhmmss"); if (File.Exists(Server.MapPath(uppathCI))) { StreamReader sr = new StreamReader(Server.MapPath(uppathCI)); StreamWriter write = new StreamWriter(Server.MapPath(output)); CsvReader csvread = new CsvReader(sr); CsvWriter csw = new CsvWriter(write); csvread.Configuration.PrepareHeaderForMatch = header => header.Replace(" ", "").Replace("/", string.Empty).Replace("#", string.Empty).Replace(".", string.Empty); IEnumerable <ClientsDailyOrders> record = csvread.GetRecords <ClientsDailyOrders>(); foreach (var rec in record) // Each record will be fetched and printed on the screen { csw.WriteRecord <ClientsDailyOrders>(rec); csw.NextRecord(); DailyOrdersDAL ONSODAL = new DailyOrdersDAL(); ONSODAL.ConnectionString = ConfigurationManager.ConnectionStrings["MySQLConn"].ToString(); ONSODAL.InsertDCL(rec); } sr.Close(); write.Close();//close file streams if (File.Exists(Server.MapPath(uppathCI))) { File.Delete(Server.MapPath(uppathCI)); } } else if (File.Exists(Server.MapPath(uppathGC))) { StreamReader sr = new StreamReader(Server.MapPath(uppathGC)); StreamWriter write = new StreamWriter(Server.MapPath(output)); CsvReader csvread = new CsvReader(sr); CsvWriter csw = new CsvWriter(write); csvread.Configuration.PrepareHeaderForMatch = header => header.Replace(" ", "").Replace("/", string.Empty).Replace("#", string.Empty).Replace(".", string.Empty); IEnumerable <GRSDailyOrders> record = csvread.GetRecords <GRSDailyOrders>(); foreach (var rec in record) // Each record will be fetched and printed on the screen { csw.WriteRecord <GRSDailyOrders>(rec); csw.NextRecord(); DailyOrdersDAL ONSODAL = new DailyOrdersDAL(); ONSODAL.ConnectionString = ConfigurationManager.ConnectionStrings["MySQLConn"].ToString(); ONSODAL.InsertDGC(rec); } sr.Close(); write.Close();//close file streams if (File.Exists(Server.MapPath(uppathCI))) { File.Delete(Server.MapPath(uppathCI)); } } }
protected void ButtonSearch_Click(object sender, EventArgs e) { DailyOrdersDAL ONSODAL = new DailyOrdersDAL(); ONSODAL.ConnectionString = ConfigurationManager.ConnectionStrings["MySQLConn"].ToString(); if (tbSearchOrderNo.Text != "") { string search = tbSearchOrderNo.Text; GetOrders(search); } else { GetOrders(null); } }
protected void gvDailyorders_RowUpdating(object sender, GridViewUpdateEventArgs e) { DailyOrdersDAL ONSODAL = new DailyOrdersDAL(); ONSODAL.ConnectionString = ConfigurationManager.ConnectionStrings["MySQLConn"].ToString(); DailyOrders DO = new DailyOrders(); string name = (gvDailyorders.Rows[e.RowIndex].FindControl("lblName") as Label).Text; DO.ID = (gvDailyorders.Rows[e.RowIndex].FindControl("lblID") as Label).Text; DO.RewardName = (gvDailyorders.Rows[e.RowIndex].FindControl("lblRName") as Label).Text; DO.Quantity = Convert.ToInt32((gvDailyorders.Rows[e.RowIndex].FindControl("lblQuantity") as Label).Text); DO.FirstName = name.Split(' ')[0]; DO.LastName = name.Split(' ')[1];; DO.OrderStatus = (gvDailyorders.Rows[e.RowIndex].FindControl("lblStatus") as Label).Text; DO.OrderDate = Convert.ToDateTime((gvDailyorders.Rows[e.RowIndex].FindControl("lblODate") as Label).Text); DO.P2MOrderNumber = (gvDailyorders.Rows[e.RowIndex].FindControl("lblP2M") as Label).Text; DO.Note = (gvDailyorders.Rows[e.RowIndex].FindControl("tbNote") as TextBox).Text; }
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(); }