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();
}
