protected void btnGetPreviousOrder_Click(object sender, EventArgs e)
{
DataSet DS = new DataSet();
Bulk b = new Bulk();
DbBulk dbBulk = new DbBulk();
b.RouteId = Convert.ToInt32(dpRoute.SelectedItem.Value);
b.OrderDate = (Convert.ToDateTime(txtDate.Text)).ToString("dd-MM-yyyy");
b.Type = Convert.ToInt32(dpType.SelectedItem.Value);
DS = dbBulk.GetPreviousOrders(b);
if (!Comman.Comman.IsDataSetEmpty(DS))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "1", "<script type='text/javascript'> $('#MainContent_dpRoute').attr('disabled', 'disabled'); </script>", false);
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "2", "<script type='text/javascript'> $('#MainContent_dpType').attr('disabled', 'disabled'); </script>", false);
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "3", "<script type='text/javascript'> $('#MainContent_txtDate').attr('disabled', 'disabled'); </script>", false);
string nm = GlobalInfo.UserName.ToString();
DS.WriteXml(Server.MapPath("~/Tabs/Dispatch/Bulk" + nm + ".xml"));
btnRefresh.Visible = true;
btnGetPreviousOrder.Visible = false;
btnSubmit.Visible = true;
rpAgentOrderdetails.Visible = true;
BindRepeaterCart();
date = txtDate.Text.ToString();
routenam = dpRoute.SelectedItem.Text;
routeid = dpRoute.SelectedItem.Value;
typename = dpType.SelectedItem.Text;
typeid = dpType.SelectedItem.Value;
}
else
{
DataTable dt = new DataTable();
this.BindRepeater(dt);
rpAgentOrderdetails.Visible = true;
upMain.Update();
date = txtDate.Text.ToString();
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
DataSet DS = new DataSet();
string nm = GlobalInfo.UserName.ToString();
DS.ReadXml(Server.MapPath("~/Tabs/Dispatch/Bulk" + nm + ".xml"));
DS.Tables[0].Columns.Add("NewDate", typeof(string));
string orderDate = (Convert.ToDateTime(txtDate.Text)).ToString("dd-MM-yyyy");
for (int i = 0; i <= DS.Tables[0].Rows.Count - 1; i++)
{
DS.Tables[0].Rows[i]["NewDate"] = orderDate;
}
DS.Tables[0].Columns.Add("NewCreatedDate", typeof(string));
string createdDate = DateTime.Now.ToString("dd-MM-yyyy");
for (int i = 0; i <= DS.Tables[0].Rows.Count - 1; i++)
{
DS.Tables[0].Rows[i]["NewCreatedDate"] = createdDate;
}
DS.Tables[0].Columns.Add("Userid", typeof(int));
int createdby = GlobalInfo.Userid;
for (int i = 0; i <= DS.Tables[0].Rows.Count - 1; i++)
{
DS.Tables[0].Rows[i]["Userid"] = createdby;
}
DS.Tables[0].Columns.Add("NewOrderType", typeof(int));
int OrderType = Convert.ToInt32(dpType.SelectedItem.Value);
for (int i = 0; i <= DS.Tables[0].Rows.Count - 1; i++)
{
DS.Tables[0].Rows[i]["NewOrderType"] = OrderType;
}
DS.Tables[0].Columns.Add("Tokan", typeof(string));
string tokan = hftokanno.Value;
for (int i = 0; i <= DS.Tables[0].Rows.Count - 1; i++)
{
DS.Tables[0].Rows[i]["Tokan"] = tokan;
}
string consString = ConfigurationManager.ConnectionStrings["projectConnection"].ConnectionString;
using (SqlConnection con = new SqlConnection(consString))
{
using (SqlBulkCopy sqlBulkCopy = new SqlBulkCopy(con))
{
//Set the database table name
sqlBulkCopy.DestinationTableName = "TempBulkOrder";
//[OPTIONAL]: Map the DataTable columns with that of the database table
sqlBulkCopy.ColumnMappings.Add("Userid", "UserId");
sqlBulkCopy.ColumnMappings.Add("Tokan", "Tokan");
sqlBulkCopy.ColumnMappings.Add("TypeId", "TypeId");
sqlBulkCopy.ColumnMappings.Add("ProductId", "ProductId");
sqlBulkCopy.ColumnMappings.Add("Qty", "Qty");
sqlBulkCopy.ColumnMappings.Add("UnitCost", "UnitCost");
sqlBulkCopy.ColumnMappings.Add("Total", "Total");
sqlBulkCopy.ColumnMappings.Add("TotalBill", "TotalBill");
sqlBulkCopy.ColumnMappings.Add("RouteID", "RouteID");
if (dpType.SelectedItem.Value == "1")
{
sqlBulkCopy.ColumnMappings.Add("AgentID", "AgentID");
}
if (dpType.SelectedItem.Value == "2")
{
sqlBulkCopy.ColumnMappings.Add("EmployeeID", "EmployeeID");
}
sqlBulkCopy.ColumnMappings.Add("OrderID", "OrderId");
sqlBulkCopy.ColumnMappings.Add("NewDate", "OrderDate");
sqlBulkCopy.ColumnMappings.Add("NewCreatedDate", "CreatedDate");
sqlBulkCopy.ColumnMappings.Add("NewOrderType", "OrderType");
con.Open();
sqlBulkCopy.WriteToServer(DS.Tables[0]);
con.Close();
}
}
//asdf
Bulk b = new Bulk();
DbBulk dbBulk = new DbBulk();
b.Tokan = hftokanno.Value.ToString();
b.UserId = GlobalInfo.Userid;
if (dpType.SelectedItem.Value == "1")
{
b.Flag = "Agent";
}
if (dpType.SelectedItem.Value == "2")
{
b.Flag = "Employee";
}
int result = dbBulk.SubmitBulkOrders(b);
if (result > 0)
{
btnSubmit.Visible = false;
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "Orders Placed Successfully";
DataTable dt = new DataTable();
rpAgentOrderdetails.DataSource = dt;
rpAgentOrderdetails.DataBind();
pnlError.Update();
upMain.Update();
}
else
{
btnSubmit.Visible = false;
divDanger.Visible = true;
divwarning.Visible = false;
divSusccess.Visible = false;
lbldanger.Text = "Something went wrong.. Please Contact Admin";
DataTable dt = new DataTable();
rpAgentOrderdetails.DataSource = dt;
rpAgentOrderdetails.DataBind();
pnlError.Update();
upMain.Update();
}
}
