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