protected void Page_Load(object sender, EventArgs e) { TransitionLogic tl = new TransitionLogic(); DataTable dt = tl.SelectForProductReport(); Repeater1.DataSource = dt; Repeater1.DataBind(); }
public PassiveStateMachine <TState, TEvent> CreatePassiveStateMachine(string name) { var stateContainer = new StateContainer <TState, TEvent>(name); foreach (var stateIdAndLastActiveState in this.initiallyLastActiveStates) { stateContainer.SetLastActiveStateFor(stateIdAndLastActiveState.Key, stateIdAndLastActiveState.Value); } var transitionLogic = new TransitionLogic <TState, TEvent>(stateContainer); var stateLogic = new StateLogic <TState, TEvent>(transitionLogic, stateContainer); transitionLogic.SetStateLogic(stateLogic); var standardFactory = new StandardFactory <TState, TEvent>(); var stateMachine = new StateMachine <TState, TEvent>(standardFactory, stateLogic); return(new PassiveStateMachine <TState, TEvent>(stateMachine, stateContainer, this.stateDefinitions, this.initialState)); }
protected void Page_Load(object sender, EventArgs e) { TransitionLogic ol = new TransitionLogic(); Repeater9.DataSource = ol.SelectProductStatus1(DateTime.Today); Repeater9.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { Label2.Text = DateTime.Today.ToString("dd/MM/yyyy"); TransitionLogic ol = new TransitionLogic(); DataTable dt1 = ol.SelectProductStatus("Product Created", DateTime.Today); DataTable dt2 = ol.SelectProductStatus("Product Designed", DateTime.Today); DataTable dt3 = ol.SelectProductStatus("Product Sent for client design approval", DateTime.Today); DataTable dt4 = ol.SelectProductStatus("Design approved bt client", DateTime.Today); DataTable dt5 = ol.SelectProductStatus("Trial product prepared", DateTime.Today); DataTable dt6 = ol.SelectProductStatus("Trial product sent for client approval", DateTime.Today); DataTable dt7 = ol.SelectProductStatus("Trial product approved by client", DateTime.Today); DataTable dt8 = ol.SelectProductStatusApproved("product approved", DateTime.Today); int[] arr = { dt1.Rows.Count, dt2.Rows.Count, dt3.Rows.Count, dt4.Rows.Count, dt5.Rows.Count, dt6.Rows.Count, dt7.Rows.Count, dt8.Rows.Count }; int max = findMax(dt1.Rows.Count, dt2.Rows.Count, dt3.Rows.Count, dt4.Rows.Count, dt5.Rows.Count, dt6.Rows.Count, dt7.Rows.Count, dt8.Rows.Count); if (dt1.Rows.Count < max) { for (int i = dt1.Rows.Count; i < max; i++) { dt1.Rows.Add("-"); } } if (dt2.Rows.Count < max) { for (int i = dt2.Rows.Count; i < max; i++) { dt2.Rows.Add("-"); } } if (dt3.Rows.Count < max) { for (int i = dt3.Rows.Count; i < max; i++) { dt3.Rows.Add("-"); } } if (dt4.Rows.Count < max) { for (int i = dt4.Rows.Count; i < max; i++) { dt4.Rows.Add("-"); } } if (dt5.Rows.Count < max) { for (int i = dt5.Rows.Count; i < max; i++) { dt5.Rows.Add("-"); } } if (dt6.Rows.Count < max) { for (int i = dt6.Rows.Count; i < max; i++) { dt6.Rows.Add("-"); } } if (dt7.Rows.Count < max) { for (int i = dt7.Rows.Count; i < max; i++) { dt7.Rows.Add("-"); } } if (dt8.Rows.Count < max) { for (int i = dt8.Rows.Count; i < max; i++) { dt8.Rows.Add("-"); } } Repeater1.DataSource = dt1; Repeater2.DataSource = dt2; Repeater3.DataSource = dt3; Repeater4.DataSource = dt4; Repeater5.DataSource = dt5; Repeater6.DataSource = dt6; Repeater7.DataSource = dt7; Repeater8.DataSource = dt8; Repeater1.DataBind(); Repeater2.DataBind(); Repeater3.DataBind(); Repeater4.DataBind(); Repeater5.DataBind(); Repeater6.DataBind(); Repeater7.DataBind(); Repeater8.DataBind(); }
protected void Button1_Click(object sender, EventArgs e) { if (Convert.ToInt32(Request.QueryString["ID"]) > 0) { //edit mode if (Convert.ToInt32(TextBox1.Text) > 0) { OrderLogic ol = new OrderLogic(); Order o1 = ol.SelectByID(Convert.ToInt32(Request.QueryString["id"])); ProductLogic pl = new ProductLogic(); Product p1 = pl.SelectByProductID(o1.ProductID); // = Convert.ToInt32(DropDownList1.SelectedValue) o1.ProductID = Convert.ToInt32(DropDownList1.SelectedItem.Value); o1.QuotationID = Convert.ToInt32(TextBox1.Text.ToString()); o1.Quantity = Convert.ToInt32(TextBox2.Text); o1.Rate = Convert.ToInt32(TextBox3.Text); DateTime d1 = new DateTime(); if (!DateTime.TryParseExact(TextBox4.Text, "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out d1)) { d1 = DateTime.Today; } o1.PODate = d1; o1.PONumber = Convert.ToInt32(TextBox5.Text); DateTime d2 = new DateTime(); if (!DateTime.TryParseExact(TextBox6.Text, "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out d2)) { d2 = DateTime.Today; } if (d2.ToShortDateString().Equals(DateTime.Today.ToShortDateString())) { o1.CreateDate = DateTime.Now; } else { o1.CreateDate = d2; } if (o1.Status.Equals(DropDownList2.SelectedItem.Text)) { o1.Status = DropDownList2.SelectedItem.Text; } else { TransitionLogic tl = new TransitionLogic(); Transition t1 = new Transition(); t1.KeyID = o1.OrderID; t1.KeyType = "Ord"; t1.TranDate = DateTime.Now; t1.NewStatus = DropDownList2.SelectedItem.Text; t1.Remarks = ""; tl.Insert(t1); o1.Status = DropDownList2.SelectedItem.Text; } o1.StatusRemarks = TextBox8.Text; o1.DeliveryAddress = TextArea2.Text; DateTime d3 = new DateTime(); if (!DateTime.TryParseExact(TextBox9.Text, "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out d3)) { d3 = DateTime.Today; } o1.DeliveryDate = d3; String po = ""; string ticks = DateTime.Now.Ticks.ToString(); if (FileUpload1.HasFile) { FileUpload1.SaveAs(Server.MapPath("Images/" + ticks + FileUpload1.FileName)); po = "Images/" + ticks + FileUpload1.FileName; o1.AttachPO = po; } ol.Update(o1); Response.Redirect("OrderList.aspx"); } else { Label2.Visible = true; } } else { //Insert mode if (Convert.ToInt32(TextBox1.Text) > 0) { OrderLogic ol = new OrderLogic(); Order o1 = new Order(); ProductLogic pl = new ProductLogic(); o1.ProductID = Convert.ToInt32(DropDownList1.SelectedItem.Value); o1.QuotationID = Convert.ToInt32(TextBox1.Text); o1.Quantity = Convert.ToInt32(TextBox2.Text); o1.Rate = Convert.ToInt32(TextBox3.Text); DateTime d1 = new DateTime(); if (!DateTime.TryParseExact(TextBox4.Text, "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out d1)) { d1 = DateTime.Today; } o1.PODate = d1; o1.JobPath = ""; o1.PONumber = Convert.ToInt32(TextBox5.Text); DateTime d2 = new DateTime(); if (!DateTime.TryParseExact(TextBox6.Text, "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out d2)) { d2 = DateTime.Today; } if (d2.ToShortDateString().Equals(DateTime.Today.ToShortDateString())) { o1.CreateDate = DateTime.Now; } else { o1.CreateDate = d2; } o1.Status = DropDownList2.SelectedItem.Text; o1.StatusRemarks = TextBox8.Text; o1.DeliveryAddress = TextArea2.Text; DateTime d3 = new DateTime(); if (!DateTime.TryParseExact(TextBox9.Text, "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out d3)) { d3 = DateTime.Today; } o1.DeliveryDate = d3; String po = ""; string ticks = DateTime.Now.Ticks.ToString(); if (FileUpload1.HasFile) { FileUpload1.SaveAs(Server.MapPath("Images/" + ticks + FileUpload1.FileName)); po = "Images/" + ticks + FileUpload1.FileName; } o1.AttachPO = po; ol.Insert(o1); Response.Redirect("OrderList.aspx"); } else { Label2.Visible = true; } } }
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e) { EmployeeLogic el = new EmployeeLogic(); Employee e2 = el.SelectByID(Convert.ToInt32(Session["EmployeeID"])); if (!(e2.Designation.Equals("STOCK MANAGER") || e2.Designation.Equals("STOCK EMPLOYEE") || e2.Designation.Equals("ACCOUNTATANT") || e2.Designation.Equals("EMPLOYEE") || e2.Designation.Equals("HR MANAGER") || e2.Designation.Equals("HR EMPLOYEE"))) { if (e.CommandName.Equals("Product Designed")) { ProductLogic pl = new ProductLogic(); Product p1 = pl.SelectByProductID(Convert.ToInt32(e.CommandArgument)); p1.Status = "Product Designed"; pl.Update(p1); DataTable dt = pl.SelectAllJoined(); Repeater1.DataSource = dt; Repeater1.DataBind(); if (dt.Rows.Count == 0) { Table1.Visible = false; Label1.Visible = true; } else { Table1.Visible = true; Label1.Visible = false; } TransitionLogic tl = new TransitionLogic(); Transition t1 = new Transition(); t1.KeyID = p1.ProductID; t1.KeyType = "Prod"; t1.TranDate = DateTime.Now; t1.NewStatus = "Product Designed"; t1.Remarks = ((TextBox)e.Item.FindControl("TextBox2")).Text; tl.Insert(t1); } else if (e.CommandName.Equals("Product Sent for client design approval")) { ProductLogic pl = new ProductLogic(); Product p1 = pl.SelectByProductID(Convert.ToInt32(e.CommandArgument)); p1.Status = "Product Sent for client design approval"; pl.Update(p1); DataTable dt = pl.SelectAllJoined(); Repeater1.DataSource = dt; Repeater1.DataBind(); if (dt.Rows.Count == 0) { Table1.Visible = false; Label1.Visible = true; } else { Table1.Visible = true; Label1.Visible = false; } TransitionLogic tl = new TransitionLogic(); Transition t1 = new Transition(); t1.KeyID = p1.ProductID; t1.KeyType = "Prod"; t1.TranDate = DateTime.Now; t1.NewStatus = "Product Sent for client design approval"; t1.Remarks = ((TextBox)e.Item.FindControl("TextBox2")).Text; tl.Insert(t1); } else if (e.CommandName.Equals("Design approved by client")) { ProductLogic pl = new ProductLogic(); Product p1 = pl.SelectByProductID(Convert.ToInt32(e.CommandArgument)); p1.Status = "Design approved by client"; pl.Update(p1); DataTable dt = pl.SelectAllJoined(); Repeater1.DataSource = dt; Repeater1.DataBind(); if (dt.Rows.Count == 0) { Table1.Visible = false; Label1.Visible = true; } else { Table1.Visible = true; Label1.Visible = false; } TransitionLogic tl = new TransitionLogic(); Transition t1 = new Transition(); t1.KeyID = p1.ProductID; t1.KeyType = "Prod"; t1.TranDate = DateTime.Now; t1.NewStatus = "Design approved by client"; t1.Remarks = ((TextBox)e.Item.FindControl("TextBox2")).Text; tl.Insert(t1); } else if (e.CommandName.Equals("Trial product prepared")) { ProductLogic pl = new ProductLogic(); Product p1 = pl.SelectByProductID(Convert.ToInt32(e.CommandArgument)); p1.Status = "Trial product prepared"; pl.Update(p1); DataTable dt = pl.SelectAllJoined(); Repeater1.DataSource = dt; Repeater1.DataBind(); if (dt.Rows.Count == 0) { Table1.Visible = false; Label1.Visible = true; } else { Table1.Visible = true; Label1.Visible = false; } TransitionLogic tl = new TransitionLogic(); Transition t1 = new Transition(); t1.KeyID = p1.ProductID; t1.KeyType = "Prod"; t1.TranDate = DateTime.Now; t1.NewStatus = "Trial product prepared"; t1.Remarks = ((TextBox)e.Item.FindControl("TextBox2")).Text; tl.Insert(t1); } else if (e.CommandName.Equals("Trial product sent for client approval")) { ProductLogic pl = new ProductLogic(); Product p1 = pl.SelectByProductID(Convert.ToInt32(e.CommandArgument)); p1.Status = "Trial product sent for client approval"; pl.Update(p1); DataTable dt = pl.SelectAllJoined(); Repeater1.DataSource = dt; Repeater1.DataBind(); if (dt.Rows.Count == 0) { Table1.Visible = false; Label1.Visible = true; } else { Table1.Visible = true; Label1.Visible = false; } TransitionLogic tl = new TransitionLogic(); Transition t1 = new Transition(); t1.KeyID = p1.ProductID; t1.KeyType = "Prod"; t1.TranDate = DateTime.Now; t1.NewStatus = "Trial product sent for client approval"; t1.Remarks = ((TextBox)e.Item.FindControl("TextBox2")).Text; tl.Insert(t1); } else if (e.CommandName.Equals("Trial product approved by client")) { ProductLogic pl = new ProductLogic(); Product p1 = pl.SelectByProductID(Convert.ToInt32(e.CommandArgument)); p1.Status = "Trial product approved by client"; pl.Update(p1); DataTable dt = pl.SelectAllJoined(); Repeater1.DataSource = dt; Repeater1.DataBind(); if (dt.Rows.Count == 0) { Table1.Visible = false; Label1.Visible = true; } else { Table1.Visible = true; Label1.Visible = false; } TransitionLogic tl = new TransitionLogic(); Transition t1 = new Transition(); t1.KeyID = p1.ProductID; t1.KeyType = "Prod"; t1.TranDate = DateTime.Now; t1.NewStatus = "Trial product approved by client"; t1.Remarks = ((TextBox)e.Item.FindControl("TextBox2")).Text; tl.Insert(t1); } else if (e.CommandName.Equals("product approved")) { ProductLogic pl = new ProductLogic(); Product p1 = pl.SelectByProductID(Convert.ToInt32(e.CommandArgument)); p1.Status = "product approved"; pl.Update(p1); DataTable dt = pl.SelectAllJoined(); Repeater1.DataSource = dt; Repeater1.DataBind(); if (dt.Rows.Count == 0) { Table1.Visible = false; Label1.Visible = true; } else { Table1.Visible = true; Label1.Visible = false; } TransitionLogic tl = new TransitionLogic(); Transition t1 = new Transition(); t1.KeyID = p1.ProductID; t1.KeyType = "Prod"; t1.TranDate = DateTime.Now; t1.NewStatus = "product approved"; t1.Remarks = ((TextBox)e.Item.FindControl("TextBox2")).Text; tl.Insert(t1); } } else { Response.Redirect("Access.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { Label2.Text = DateTime.Today.ToString("dd/MM/yyyy"); TransitionLogic ol = new TransitionLogic(); DataTable dt1 = ol.SelectOrderStatus("Order Created", DateTime.Today); DataTable dt2 = ol.SelectOrderStatus("Performa invoice generated", DateTime.Today); DataTable dt3 = ol.SelectOrderStatus("Performa invoice approved", DateTime.Today); DataTable dt4 = ol.SelectOrderStatus("Cylinder requested", DateTime.Today); DataTable dt5 = ol.SelectOrderStatus("Cylinder received", DateTime.Today); DataTable dt6 = ol.SelectOrderStatus("Print pending", DateTime.Today); DataTable dt7 = ol.SelectOrderStatus("Converting", DateTime.Today); DataTable dt8 = ol.SelectOrderStatus("Ready", DateTime.Today); DataTable dt9 = ol.SelectOrderStatus("Dispached", DateTime.Today); DataTable dt10 = ol.SelectOrderStatusClosed("Closed", DateTime.Today); int max = findMax(dt1.Rows.Count, dt2.Rows.Count, dt3.Rows.Count, dt4.Rows.Count, dt5.Rows.Count, dt6.Rows.Count, dt7.Rows.Count, dt8.Rows.Count, dt9.Rows.Count, dt10.Rows.Count); if (dt1.Rows.Count < max) { for (int i = dt1.Rows.Count; i < max; i++) { dt1.Rows.Add("-"); } } if (dt2.Rows.Count < max) { for (int i = dt2.Rows.Count; i < max; i++) { dt2.Rows.Add("-"); } } if (dt3.Rows.Count < max) { for (int i = dt3.Rows.Count; i < max; i++) { dt3.Rows.Add("-"); } } if (dt4.Rows.Count < max) { for (int i = dt4.Rows.Count; i < max; i++) { dt4.Rows.Add("-"); } } if (dt5.Rows.Count < max) { for (int i = dt5.Rows.Count; i < max; i++) { dt5.Rows.Add("-"); } } if (dt6.Rows.Count < max) { for (int i = dt6.Rows.Count; i < max; i++) { dt6.Rows.Add("-"); } } if (dt7.Rows.Count < max) { for (int i = dt7.Rows.Count; i < max; i++) { dt7.Rows.Add("-"); } } if (dt8.Rows.Count < max) { for (int i = dt8.Rows.Count; i < max; i++) { dt8.Rows.Add("-"); } } if (dt9.Rows.Count < max) { for (int i = dt9.Rows.Count; i < max; i++) { dt9.Rows.Add("-"); } } if (dt10.Rows.Count < max) { for (int i = dt10.Rows.Count; i < max; i++) { dt10.Rows.Add("-"); } } Repeater1.DataSource = dt1; Repeater2.DataSource = dt2; Repeater3.DataSource = dt3; Repeater4.DataSource = dt4; Repeater5.DataSource = dt5; Repeater6.DataSource = dt6; Repeater7.DataSource = dt7; Repeater8.DataSource = dt8; Repeater9.DataSource = dt9; Repeater10.DataSource = dt10; Repeater1.DataBind(); Repeater2.DataBind(); Repeater3.DataBind(); Repeater4.DataBind(); Repeater5.DataBind(); Repeater6.DataBind(); Repeater7.DataBind(); Repeater8.DataBind(); Repeater9.DataBind(); Repeater10.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { Label2.Text = DateTime.Today.ToString("dd/MM/yyyy"); TransitionLogic ol = new TransitionLogic(); DataTable dt1 = ol.SelectOrderStatus("Order Created",DateTime.Today); DataTable dt2 = ol.SelectOrderStatus("Performa invoice generated", DateTime.Today); DataTable dt3 = ol.SelectOrderStatus("Performa invoice approved", DateTime.Today); DataTable dt4 = ol.SelectOrderStatus("Cylinder requested", DateTime.Today); DataTable dt5 = ol.SelectOrderStatus("Cylinder received", DateTime.Today); DataTable dt6 = ol.SelectOrderStatus("Print pending", DateTime.Today); DataTable dt7 = ol.SelectOrderStatus("Converting", DateTime.Today); DataTable dt8 = ol.SelectOrderStatus("Ready", DateTime.Today); DataTable dt9 = ol.SelectOrderStatus("Dispached", DateTime.Today); DataTable dt10 = ol.SelectOrderStatusClosed("Closed", DateTime.Today); int max = findMax(dt1.Rows.Count, dt2.Rows.Count, dt3.Rows.Count, dt4.Rows.Count, dt5.Rows.Count, dt6.Rows.Count, dt7.Rows.Count, dt8.Rows.Count, dt9.Rows.Count, dt10.Rows.Count); if (dt1.Rows.Count < max) { for (int i = dt1.Rows.Count; i < max; i++) { dt1.Rows.Add("-"); } } if (dt2.Rows.Count < max) { for (int i = dt2.Rows.Count; i < max; i++) { dt2.Rows.Add("-"); } } if (dt3.Rows.Count < max) { for (int i = dt3.Rows.Count; i < max; i++) { dt3.Rows.Add("-"); } } if (dt4.Rows.Count < max) { for (int i = dt4.Rows.Count; i < max; i++) { dt4.Rows.Add("-"); } } if (dt5.Rows.Count < max) { for (int i = dt5.Rows.Count; i < max; i++) { dt5.Rows.Add("-"); } } if (dt6.Rows.Count < max) { for (int i = dt6.Rows.Count; i < max; i++) { dt6.Rows.Add("-"); } } if (dt7.Rows.Count < max) { for (int i = dt7.Rows.Count; i < max; i++) { dt7.Rows.Add("-"); } } if (dt8.Rows.Count < max) { for (int i = dt8.Rows.Count; i < max; i++) { dt8.Rows.Add("-"); } } if (dt9.Rows.Count < max) { for (int i = dt9.Rows.Count; i < max; i++) { dt9.Rows.Add("-"); } } if (dt10.Rows.Count < max) { for (int i = dt10.Rows.Count; i < max; i++) { dt10.Rows.Add("-"); } } Repeater1.DataSource = dt1; Repeater2.DataSource = dt2; Repeater3.DataSource = dt3; Repeater4.DataSource = dt4; Repeater5.DataSource = dt5; Repeater6.DataSource = dt6; Repeater7.DataSource = dt7; Repeater8.DataSource = dt8; Repeater9.DataSource = dt9; Repeater10.DataSource = dt10; Repeater1.DataBind(); Repeater2.DataBind(); Repeater3.DataBind(); Repeater4.DataBind(); Repeater5.DataBind(); Repeater6.DataBind(); Repeater7.DataBind(); Repeater8.DataBind(); Repeater9.DataBind(); Repeater10.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { Label2.Text = DateTime.Today.ToString("dd/MM/yyyy"); TransitionLogic ol = new TransitionLogic(); DataTable dt1 = ol.SelectProductStatus("Product Created",DateTime.Today); DataTable dt2 = ol.SelectProductStatus("Product Designed",DateTime.Today); DataTable dt3 = ol.SelectProductStatus("Product Sent for client design approval",DateTime.Today); DataTable dt4 = ol.SelectProductStatus("Design approved bt client",DateTime.Today); DataTable dt5 = ol.SelectProductStatus("Trial product prepared",DateTime.Today); DataTable dt6 = ol.SelectProductStatus("Trial product sent for client approval",DateTime.Today); DataTable dt7 = ol.SelectProductStatus("Trial product approved by client",DateTime.Today); DataTable dt8 = ol.SelectProductStatusApproved("product approved",DateTime.Today); int[] arr = { dt1.Rows.Count, dt2.Rows.Count, dt3.Rows.Count, dt4.Rows.Count, dt5.Rows.Count, dt6.Rows.Count, dt7.Rows.Count, dt8.Rows.Count}; int max = findMax(dt1.Rows.Count, dt2.Rows.Count, dt3.Rows.Count, dt4.Rows.Count, dt5.Rows.Count, dt6.Rows.Count, dt7.Rows.Count, dt8.Rows.Count); if (dt1.Rows.Count < max) { for (int i = dt1.Rows.Count; i < max; i++) { dt1.Rows.Add("-"); } } if (dt2.Rows.Count < max) { for (int i = dt2.Rows.Count; i < max; i++) { dt2.Rows.Add("-"); } } if (dt3.Rows.Count < max) { for (int i = dt3.Rows.Count; i < max; i++) { dt3.Rows.Add("-"); } } if (dt4.Rows.Count < max) { for (int i = dt4.Rows.Count; i < max; i++) { dt4.Rows.Add("-"); } } if (dt5.Rows.Count < max) { for (int i = dt5.Rows.Count; i < max; i++) { dt5.Rows.Add("-"); } } if (dt6.Rows.Count < max) { for (int i = dt6.Rows.Count; i < max; i++) { dt6.Rows.Add("-"); } } if (dt7.Rows.Count < max) { for (int i = dt7.Rows.Count; i < max; i++) { dt7.Rows.Add("-"); } } if (dt8.Rows.Count < max) { for (int i = dt8.Rows.Count; i < max; i++) { dt8.Rows.Add("-"); } } Repeater1.DataSource = dt1; Repeater2.DataSource = dt2; Repeater3.DataSource = dt3; Repeater4.DataSource = dt4; Repeater5.DataSource = dt5; Repeater6.DataSource = dt6; Repeater7.DataSource = dt7; Repeater8.DataSource = dt8; Repeater1.DataBind(); Repeater2.DataBind(); Repeater3.DataBind(); Repeater4.DataBind(); Repeater5.DataBind(); Repeater6.DataBind(); Repeater7.DataBind(); Repeater8.DataBind(); }
protected void Button1_Click(object sender, EventArgs e) { if (Convert.ToInt32(Request.QueryString["ID"]) > 0) { //edit mode ProductLogic PL = new ProductLogic(); Product objPro = PL.SelectByProductID(Convert.ToInt32(Request.QueryString["ID"])); objPro.Name = TextBox1.Text; if (objPro.Status.Equals(DropDownList3.SelectedItem.Text)) { objPro.Status = DropDownList3.SelectedItem.Text; } else { TransitionLogic tl = new TransitionLogic(); Transition t1 = new Transition(); t1.KeyID = objPro.ProductID; t1.KeyType = "Prod"; t1.TranDate = DateTime.Now; t1.NewStatus = DropDownList3.SelectedItem.Text; t1.Remarks = ""; tl.Insert(t1); objPro.Status = DropDownList3.SelectedItem.Text; } objPro.Description = TextArea1.Text; objPro.Size = TextBox4.Text; objPro.Colors = TextBox5.Text; objPro.Type = DropDownList1.SelectedItem.Text; objPro.CustomerID = Convert.ToInt32(DropDownList2.SelectedItem.Value); DateTime d1 = new DateTime(); if (!DateTime.TryParseExact(TextBox2.Text, "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out d1)) { objPro.CreateDate = DateTime.Now; } if (d1.ToShortDateString().Equals(DateTime.Today.ToShortDateString())) { objPro.CreateDate = DateTime.Now; } else { objPro.CreateDate = d1; } String path = objPro.DesignFiles; string ticks = DateTime.Now.Ticks.ToString(); if (FileUpload1.HasFile) { FileUpload1.SaveAs(Server.MapPath("Images/" + ticks + FileUpload1.FileName)); path += "Images/" + ticks + FileUpload1.FileName + "#,#"; } if (FileUpload2.HasFile) { FileUpload2.SaveAs(Server.MapPath("Images/" + ticks + FileUpload2.FileName)); path += "Images/" + ticks + FileUpload2.FileName + "#,#"; } if (FileUpload3.HasFile) { FileUpload3.SaveAs(Server.MapPath("Images/" + ticks + FileUpload3.FileName)); path += "Images/" + ticks + FileUpload3.FileName + "#,#"; } if (FileUpload4.HasFile) { FileUpload4.SaveAs(Server.MapPath("Images/" + ticks + FileUpload4.FileName)); path += "Images/" + ticks + FileUpload4.FileName + "#,#"; } if (FileUpload5.HasFile) { FileUpload5.SaveAs(Server.MapPath("Images/" + ticks + FileUpload5.FileName)); path += "Images/" + ticks + FileUpload5.FileName + "#,#"; } objPro.DesignFiles = path; objPro.ProductID = Convert.ToInt32(Request.QueryString["id"]); PL.Update(objPro); Response.Redirect("ProdList.aspx"); } else { // insert mode Product objPro = new Product(); objPro.Name = TextBox1.Text; objPro.Status =DropDownList3.SelectedItem.Text; objPro.Description = TextArea1.Text; objPro.Size = TextBox4.Text; objPro.Colors = TextBox5.Text; objPro.Type = DropDownList1.Text; objPro.CustomerID = Convert.ToInt32(DropDownList2.SelectedItem.Value); DateTime d1 = new DateTime(); if (!DateTime.TryParseExact(TextBox2.Text, "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out d1)) { objPro.CreateDate = DateTime.Now; } if (d1.ToShortDateString().Equals(DateTime.Today.ToShortDateString())) { objPro.CreateDate = DateTime.Now; } else { objPro.CreateDate = d1; } String path = ""; string ticks = DateTime.Now.Ticks.ToString(); if (FileUpload1.HasFile) { FileUpload1.SaveAs(Server.MapPath("Images/" + ticks + FileUpload1.FileName)); path += "Images/" + ticks + FileUpload1.FileName + "#,#"; } if (FileUpload2.HasFile) { FileUpload2.SaveAs(Server.MapPath("Images/" + ticks + FileUpload2.FileName)); path += "Images/" + ticks + FileUpload2.FileName + "#,#"; } if (FileUpload3.HasFile) { FileUpload3.SaveAs(Server.MapPath("Images/" + ticks + FileUpload3.FileName)); path += "Images/" + ticks + FileUpload3.FileName + "#,#"; } if (FileUpload4.HasFile) { FileUpload4.SaveAs(Server.MapPath("Images/" + ticks + FileUpload4.FileName)); path += "Images/" + ticks + FileUpload4.FileName + "#,#"; } if (FileUpload5.HasFile) { FileUpload5.SaveAs(Server.MapPath("Images/" + ticks + FileUpload5.FileName)); path += "Images/" + ticks + FileUpload5.FileName + "#,#"; } objPro.DesignFiles = path; ProductLogic PL = new ProductLogic(); PL.Insert(objPro); Response.Redirect("ProdList.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { DataTable dt = new AttendanceLogic().SelectForAttendanceReport(DateTime.Today); int present = Convert.ToInt32(dt.Rows[0][1]); int absent = Convert.ToInt32(dt.Rows[1][1]); lblPResentPerc.Text = ((float)present * 100) / ((float)present + absent) + ""; lblPResentPerc.Attributes.Add("Present", present.ToString()); lblPResentPerc.Attributes.Add("Absent", absent.ToString()); DataTable dt1 = new InvoiceLogic().SelectForBestOrder(); bestOrd.Text = dt1.Rows[0]["ProductName"].ToString(); totalAmt.Text = dt1.Rows[0]["GrandTotal"].ToString(); txtCustomer.Text = dt1.Rows[0]["CustomerName"].ToString(); string dp = dt1.Rows[0]["ProductImage"].ToString(); String[] arr = dp.Split(new String[] { "#,#" }, StringSplitOptions.RemoveEmptyEntries); proimg.Src = arr[arr.Length - 1]; DataTable dt2 = new InvoiceLogic().SelectForRevenue(); txtTotIncome.Text = dt2.Rows[0]["TotalIncome"].ToString(); DataTable dt4 = new InvoiceLogic().SelectIndividualInvoiceAmount(); string s = ""; for (int i = 0; i < dt4.Rows.Count; i++) { s += dt4.Rows[i]["GrandTotal"] + ","; } s = "[" + s.TrimEnd(',') + "]"; individualInvoiceAmount.Attributes.Add("data-data", s); DataTable dt3 = new ProductLogic().SelectBestProduct(); OrderNumber.Text = dt3.Rows[0]["Total"].ToString() + " Orders"; string dp1 = dt3.Rows[0]["DesignFiles"].ToString(); String[] arr1 = dp1.Split(new String[] { "#,#" }, StringSplitOptions.RemoveEmptyEntries); topProimg.Src = arr1[arr1.Length - 1]; ProName.Text = dt3.Rows[0]["Name"].ToString(); DataTable dt5 = new InvoiceLogic().SelectTotalSale2(); Repeater2.DataSource = dt5; Repeater2.DataBind(); DataTable dt6 = new InventoryLogic().SelectRawStock(); Repeater1.DataSource = dt6; Repeater1.DataBind(); CustomerLogic CL = new CustomerLogic(); Repeater3.DataSource = CL.SelectForReport1(); Repeater3.DataBind(); TransitionLogic ol = new TransitionLogic(); Repeater9.DataSource = ol.SelectProductStatus1(DateTime.Today); Repeater9.DataBind(); TransitionLogic ol2 = new TransitionLogic(); Repeater4.DataSource = ol2.SelectOrderStatus1(DateTime.Today); Repeater4.DataBind(); }
protected void Button2_click(object sender, EventArgs e) { DateTime d1 = new DateTime(); // d1 = Convert.ToDateTime(TextBox1.Text); if (!DateTime.TryParseExact(TextBox1.Text, "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out d1)) { } Label2.Text = d1.ToString("dd/MM/yyyy"); TransitionLogic ol = new TransitionLogic(); DataTable dt1 = ol.SelectOrderStatus("Order Created", d1); DataTable dt2 = ol.SelectOrderStatus("Performa invoice generated", d1); DataTable dt3 = ol.SelectOrderStatus("Performa invoice approved", d1); DataTable dt4 = ol.SelectOrderStatus("Cylinder requested", d1); DataTable dt5 = ol.SelectOrderStatus("Cylinder received", d1); DataTable dt6 = ol.SelectOrderStatus("Print pending", d1); DataTable dt7 = ol.SelectOrderStatus("Converting", d1); DataTable dt8 = ol.SelectOrderStatus("Ready", d1); DataTable dt9 = ol.SelectOrderStatus("Dispached", d1); DataTable dt10 = ol.SelectOrderStatus("Closed", d1); int max = findMax(dt1.Rows.Count, dt2.Rows.Count, dt3.Rows.Count, dt4.Rows.Count, dt5.Rows.Count, dt6.Rows.Count, dt7.Rows.Count, dt8.Rows.Count, dt9.Rows.Count, dt10.Rows.Count); if (dt1.Rows.Count < max) { for (int i = dt1.Rows.Count; i < max; i++) { dt1.Rows.Add("-"); } } if (dt2.Rows.Count < max) { for (int i = dt2.Rows.Count; i < max; i++) { dt2.Rows.Add("-"); } } if (dt3.Rows.Count < max) { for (int i = dt3.Rows.Count; i < max; i++) { dt3.Rows.Add("-"); } } if (dt4.Rows.Count < max) { for (int i = dt4.Rows.Count; i < max; i++) { dt4.Rows.Add("-"); } } if (dt5.Rows.Count < max) { for (int i = dt5.Rows.Count; i < max; i++) { dt5.Rows.Add("-"); } } if (dt6.Rows.Count < max) { for (int i = dt6.Rows.Count; i < max; i++) { dt6.Rows.Add("-"); } } if (dt7.Rows.Count < max) { for (int i = dt7.Rows.Count; i < max; i++) { dt7.Rows.Add("-"); } } if (dt8.Rows.Count < max) { for (int i = dt8.Rows.Count; i < max; i++) { dt8.Rows.Add("-"); } } if (dt9.Rows.Count < max) { for (int i = dt9.Rows.Count; i < max; i++) { dt9.Rows.Add("-"); } } if (dt10.Rows.Count < max) { for (int i = dt10.Rows.Count; i < max; i++) { dt10.Rows.Add("-"); } } Repeater1.DataSource = dt1; Repeater2.DataSource = dt2; Repeater3.DataSource = dt3; Repeater4.DataSource = dt4; Repeater5.DataSource = dt5; Repeater6.DataSource = dt6; Repeater7.DataSource = dt7; Repeater8.DataSource = dt8; Repeater9.DataSource = dt9; Repeater10.DataSource = dt10; Repeater1.DataBind(); Repeater2.DataBind(); Repeater3.DataBind(); Repeater4.DataBind(); Repeater5.DataBind(); Repeater6.DataBind(); Repeater7.DataBind(); Repeater8.DataBind(); Repeater9.DataBind(); Repeater10.DataBind(); }
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e) { EmployeeLogic el = new EmployeeLogic(); Employee e2 = el.SelectByID(Convert.ToInt32(Session["EmployeeID"])); if (!(e2.Designation.Equals("STOCK MANAGER") || e2.Designation.Equals("STOCK EMPLOYEE") || e2.Designation.Equals("ACCOUNTATANT") || e2.Designation.Equals("EMPLOYEE") || e2.Designation.Equals("HR MANAGER") || e2.Designation.Equals("HR EMPLOYEE"))) { if(e.CommandName.Equals("Product Designed")){ ProductLogic pl = new ProductLogic(); Product p1 = pl.SelectByProductID(Convert.ToInt32(e.CommandArgument)); p1.Status = "Product Designed"; pl.Update(p1); DataTable dt = pl.SelectAllJoined(); Repeater1.DataSource = dt; Repeater1.DataBind(); if (dt.Rows.Count == 0) { Table1.Visible = false; Label1.Visible = true; } else { Table1.Visible = true; Label1.Visible = false; } TransitionLogic tl = new TransitionLogic(); Transition t1 = new Transition(); t1.KeyID = p1.ProductID; t1.KeyType = "Prod"; t1.TranDate = DateTime.Now; t1.NewStatus = "Product Designed"; t1.Remarks = ((TextBox)e.Item.FindControl("TextBox2")).Text; tl.Insert(t1); }else if(e.CommandName.Equals("Product Sent for client design approval")){ ProductLogic pl = new ProductLogic(); Product p1 = pl.SelectByProductID(Convert.ToInt32(e.CommandArgument)); p1.Status = "Product Sent for client design approval"; pl.Update(p1); DataTable dt = pl.SelectAllJoined(); Repeater1.DataSource = dt; Repeater1.DataBind(); if (dt.Rows.Count == 0) { Table1.Visible = false; Label1.Visible = true; } else { Table1.Visible = true; Label1.Visible = false; } TransitionLogic tl = new TransitionLogic(); Transition t1 = new Transition(); t1.KeyID = p1.ProductID; t1.KeyType = "Prod"; t1.TranDate = DateTime.Now; t1.NewStatus = "Product Sent for client design approval"; t1.Remarks = ((TextBox)e.Item.FindControl("TextBox2")).Text; tl.Insert(t1); }else if(e.CommandName.Equals("Design approved by client")){ ProductLogic pl = new ProductLogic(); Product p1 = pl.SelectByProductID(Convert.ToInt32(e.CommandArgument)); p1.Status = "Design approved by client"; pl.Update(p1); DataTable dt = pl.SelectAllJoined(); Repeater1.DataSource = dt; Repeater1.DataBind(); if (dt.Rows.Count == 0) { Table1.Visible = false; Label1.Visible = true; } else { Table1.Visible = true; Label1.Visible = false; } TransitionLogic tl = new TransitionLogic(); Transition t1 = new Transition(); t1.KeyID = p1.ProductID; t1.KeyType = "Prod"; t1.TranDate = DateTime.Now; t1.NewStatus = "Design approved by client"; t1.Remarks = ((TextBox)e.Item.FindControl("TextBox2")).Text; tl.Insert(t1); }else if(e.CommandName.Equals("Trial product prepared")){ ProductLogic pl = new ProductLogic(); Product p1 = pl.SelectByProductID(Convert.ToInt32(e.CommandArgument)); p1.Status = "Trial product prepared"; pl.Update(p1); DataTable dt = pl.SelectAllJoined(); Repeater1.DataSource = dt; Repeater1.DataBind(); if (dt.Rows.Count == 0) { Table1.Visible = false; Label1.Visible = true; } else { Table1.Visible = true; Label1.Visible = false; } TransitionLogic tl = new TransitionLogic(); Transition t1 = new Transition(); t1.KeyID = p1.ProductID; t1.KeyType = "Prod"; t1.TranDate = DateTime.Now; t1.NewStatus = "Trial product prepared"; t1.Remarks = ((TextBox)e.Item.FindControl("TextBox2")).Text; tl.Insert(t1); }else if(e.CommandName.Equals("Trial product sent for client approval")){ ProductLogic pl = new ProductLogic(); Product p1 = pl.SelectByProductID(Convert.ToInt32(e.CommandArgument)); p1.Status = "Trial product sent for client approval"; pl.Update(p1); DataTable dt = pl.SelectAllJoined(); Repeater1.DataSource = dt; Repeater1.DataBind(); if (dt.Rows.Count == 0) { Table1.Visible = false; Label1.Visible = true; } else { Table1.Visible = true; Label1.Visible = false; } TransitionLogic tl = new TransitionLogic(); Transition t1 = new Transition(); t1.KeyID = p1.ProductID; t1.KeyType = "Prod"; t1.TranDate = DateTime.Now; t1.NewStatus = "Trial product sent for client approval"; t1.Remarks = ((TextBox)e.Item.FindControl("TextBox2")).Text; tl.Insert(t1); }else if(e.CommandName.Equals("Trial product approved by client")){ ProductLogic pl = new ProductLogic(); Product p1 = pl.SelectByProductID(Convert.ToInt32(e.CommandArgument)); p1.Status = "Trial product approved by client"; pl.Update(p1); DataTable dt = pl.SelectAllJoined(); Repeater1.DataSource = dt; Repeater1.DataBind(); if (dt.Rows.Count == 0) { Table1.Visible = false; Label1.Visible = true; } else { Table1.Visible = true; Label1.Visible = false; } TransitionLogic tl = new TransitionLogic(); Transition t1 = new Transition(); t1.KeyID = p1.ProductID; t1.KeyType = "Prod"; t1.TranDate = DateTime.Now; t1.NewStatus = "Trial product approved by client"; t1.Remarks = ((TextBox)e.Item.FindControl("TextBox2")).Text; tl.Insert(t1); }else if(e.CommandName.Equals("product approved")){ ProductLogic pl = new ProductLogic(); Product p1 = pl.SelectByProductID(Convert.ToInt32(e.CommandArgument)); p1.Status = "product approved"; pl.Update(p1); DataTable dt = pl.SelectAllJoined(); Repeater1.DataSource = dt; Repeater1.DataBind(); if (dt.Rows.Count == 0) { Table1.Visible = false; Label1.Visible = true; } else { Table1.Visible = true; Label1.Visible = false; } TransitionLogic tl = new TransitionLogic(); Transition t1 = new Transition(); t1.KeyID = p1.ProductID; t1.KeyType = "Prod"; t1.TranDate = DateTime.Now; t1.NewStatus = "product approved"; t1.Remarks = ((TextBox)e.Item.FindControl("TextBox2")).Text; tl.Insert(t1); } } else { Response.Redirect("Access.aspx"); } }
protected void Button2_click(object sender, EventArgs e) { DateTime d1 = new DateTime(); // d1 = Convert.ToDateTime(TextBox1.Text); if (!DateTime.TryParseExact(TextBox1.Text, "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out d1)) { } Label2.Text = d1.ToString("dd/MM/yyyy"); TransitionLogic ol = new TransitionLogic(); DataTable dt1 = ol.SelectProductStatus("Product Created",d1); DataTable dt2 = ol.SelectProductStatus("Product Designed",d1); DataTable dt3 = ol.SelectProductStatus("Product Sent for client design approval",d1); DataTable dt4 = ol.SelectProductStatus("Design approved bt client",d1); DataTable dt5 = ol.SelectProductStatus("Trial product prepared",d1); DataTable dt6 = ol.SelectProductStatus("Trial product sent for client approval",d1); DataTable dt7 = ol.SelectProductStatus("Trial product approved by client",d1); DataTable dt8 = ol.SelectProductStatus("product approved",d1); int max = findMax(dt1.Rows.Count, dt2.Rows.Count, dt3.Rows.Count, dt4.Rows.Count, dt5.Rows.Count, dt6.Rows.Count, dt7.Rows.Count, dt8.Rows.Count); if (dt1.Rows.Count < max) { for (int i = dt1.Rows.Count; i < max; i++) { dt1.Rows.Add("-"); } } if (dt2.Rows.Count < max) { for (int i = dt2.Rows.Count; i < max; i++) { dt2.Rows.Add("-"); } } if (dt3.Rows.Count < max) { for (int i = dt3.Rows.Count; i < max; i++) { dt3.Rows.Add("-"); } } if (dt4.Rows.Count < max) { for (int i = dt4.Rows.Count; i < max; i++) { dt4.Rows.Add("-"); } } if (dt5.Rows.Count < max) { for (int i = dt5.Rows.Count; i < max; i++) { dt5.Rows.Add("-"); } } if (dt6.Rows.Count < max) { for (int i = dt6.Rows.Count; i < max; i++) { dt6.Rows.Add("-"); } } if (dt7.Rows.Count < max) { for (int i = dt7.Rows.Count; i < max; i++) { dt7.Rows.Add("-"); } } if (dt8.Rows.Count < max) { for (int i = dt8.Rows.Count; i < max; i++) { dt8.Rows.Add("-"); } } Repeater1.DataSource = dt1; Repeater2.DataSource = dt2; Repeater3.DataSource = dt3; Repeater4.DataSource = dt4; Repeater5.DataSource = dt5; Repeater6.DataSource = dt6; Repeater7.DataSource = dt7; Repeater8.DataSource = dt8; Repeater1.DataBind(); Repeater2.DataBind(); Repeater3.DataBind(); Repeater4.DataBind(); Repeater5.DataBind(); Repeater6.DataBind(); Repeater7.DataBind(); Repeater8.DataBind(); }
/* protected void ImageButton1_Command(object sender, CommandEventArgs e) { OrderLogic ol = new OrderLogic(); Order o1 = ol.SelectByID(Convert.ToInt32(e.CommandArgument)); o1.Status = "Performa invoice generated"; ol.Update(o1); } protected void ImageButton2_Command(object sender, CommandEventArgs e) { OrderLogic ol = new OrderLogic(); Order o1 = ol.SelectByID(Convert.ToInt32(e.CommandArgument)); o1.Status = "Performa invoice approved"; ol.Update(o1); } protected void ImageButton3_Command(object sender, CommandEventArgs e) { OrderLogic ol = new OrderLogic(); Order o1 = ol.SelectByID(Convert.ToInt32(e.CommandArgument)); o1.Status = "Cylinder requested"; ol.Update(o1); } protected void ImageButton4_Command(object sender, CommandEventArgs e) { OrderLogic ol = new OrderLogic(); Order o1 = ol.SelectByID(Convert.ToInt32(e.CommandArgument)); o1.Status = "Cylinder received"; ol.Update(o1); } protected void ImageButton5_Command(object sender, CommandEventArgs e) { OrderLogic ol = new OrderLogic(); Order o1 = ol.SelectByID(Convert.ToInt32(e.CommandArgument)); o1.Status = "Print pending"; ol.Update(o1); } protected void ImageButton6_Command(object sender, CommandEventArgs e) { OrderLogic ol = new OrderLogic(); Order o1 = ol.SelectByID(Convert.ToInt32(e.CommandArgument)); o1.Status = "Converting"; ol.Update(o1); } protected void ImageButton7_Command(object sender, CommandEventArgs e) { OrderLogic ol = new OrderLogic(); Order o1 = ol.SelectByID(Convert.ToInt32(e.CommandArgument)); o1.Status = "Ready"; ol.Update(o1); } protected void ImageButton8_Command(object sender, CommandEventArgs e) { OrderLogic ol = new OrderLogic(); Order o1 = ol.SelectByID(Convert.ToInt32(e.CommandArgument)); o1.Status = "Dispached"; ol.Update(o1); } protected void ImageButton9_Command(object sender, CommandEventArgs e) { OrderLogic ol = new OrderLogic(); Order o1 = ol.SelectByID(Convert.ToInt32(e.CommandArgument)); o1.Status = "Closed"; ol.Update(o1); }*/ protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e) { EmployeeLogic el = new EmployeeLogic(); Employee e2 = el.SelectByID(Convert.ToInt32(Session["EmployeeID"])); if (!(e2.Designation.Equals("ACCOUNTATANT") || e2.Designation.Equals("HR MANAGER") || e2.Designation.Equals("HR EMPLOYEE"))) { if(e.CommandName.Equals("Performa invoice generated")){ OrderLogic ol = new OrderLogic(); Order o1 = ol.SelectByID(Convert.ToInt32(e.CommandArgument)); o1.Status = "Performa invoice generated"; ol.Update(o1); DataTable dt = ol.SelectAllJoined(); Repeater1.DataSource = dt; Repeater1.DataBind(); if (dt.Rows.Count == 0) { Table1.Visible = false; Label1.Visible = true; } else { Table1.Visible = true; Label1.Visible = false; } TransitionLogic tl = new TransitionLogic(); Transition t1 = new Transition(); t1.KeyID = o1.OrderID; t1.KeyType = "Ord"; t1.TranDate = DateTime.Now; t1.NewStatus = "Performa invoice generated"; t1.Remarks = ((TextBox)e.Item.FindControl("TextBox3")).Text; tl.Insert(t1); }else if(e.CommandName.Equals("Performa invoice approved")){ OrderLogic ol = new OrderLogic(); Order o1 = ol.SelectByID(Convert.ToInt32(e.CommandArgument)); o1.Status = "Performa invoice approved"; ol.Update(o1); DataTable dt = ol.SelectAllJoined(); Repeater1.DataSource = dt; Repeater1.DataBind(); if (dt.Rows.Count == 0) { Table1.Visible = false; Label1.Visible = true; } else { Table1.Visible = true; Label1.Visible = false; } TransitionLogic tl = new TransitionLogic(); Transition t1 = new Transition(); t1.KeyID = o1.OrderID; t1.KeyType = "Ord"; t1.TranDate = DateTime.Now; t1.NewStatus = "Performa invoice approved"; t1.Remarks = ((TextBox)e.Item.FindControl("TextBox3")).Text; tl.Insert(t1); }else if(e.CommandName.Equals("Cylinder requested")){ OrderLogic ol = new OrderLogic(); Order o1 = ol.SelectByID(Convert.ToInt32(e.CommandArgument)); o1.Status = "Cylinder requested"; ol.Update(o1); DataTable dt = ol.SelectAllJoined(); Repeater1.DataSource = dt; Repeater1.DataBind(); if (dt.Rows.Count == 0) { Table1.Visible = false; Label1.Visible = true; } else { Table1.Visible = true; Label1.Visible = false; } TransitionLogic tl = new TransitionLogic(); Transition t1 = new Transition(); t1.KeyID = o1.OrderID; t1.KeyType = "Ord"; t1.TranDate = DateTime.Now; t1.NewStatus = "Cylinder requested"; t1.Remarks = ((TextBox)e.Item.FindControl("TextBox3")).Text; tl.Insert(t1); }else if(e.CommandName.Equals("Cylinder received")){ OrderLogic ol = new OrderLogic(); Order o1 = ol.SelectByID(Convert.ToInt32(e.CommandArgument)); o1.Status = "Cylinder received"; ol.Update(o1); DataTable dt = ol.SelectAllJoined(); Repeater1.DataSource = dt; Repeater1.DataBind(); if (dt.Rows.Count == 0) { Table1.Visible = false; Label1.Visible = true; } else { Table1.Visible = true; Label1.Visible = false; } TransitionLogic tl = new TransitionLogic(); Transition t1 = new Transition(); t1.KeyID = o1.OrderID; t1.KeyType = "Ord"; t1.TranDate = DateTime.Now; t1.NewStatus = "Cylinder received"; t1.Remarks = ((TextBox)e.Item.FindControl("TextBox3")).Text; tl.Insert(t1); }else if(e.CommandName.Equals("Print pending")){ OrderLogic ol = new OrderLogic(); Order o1 = ol.SelectByID(Convert.ToInt32(e.CommandArgument)); o1.Status = "Print pending"; ol.Update(o1); DataTable dt = ol.SelectAllJoined(); Repeater1.DataSource = dt; Repeater1.DataBind(); if (dt.Rows.Count == 0) { Table1.Visible = false; Label1.Visible = true; } else { Table1.Visible = true; Label1.Visible = false; } TransitionLogic tl = new TransitionLogic(); Transition t1 = new Transition(); t1.KeyID = o1.OrderID; t1.KeyType = "Ord"; t1.TranDate = DateTime.Now; t1.NewStatus = "Print pending"; t1.Remarks = ((TextBox)e.Item.FindControl("TextBox3")).Text; tl.Insert(t1); }else if(e.CommandName.Equals("Converting")){ OrderLogic ol = new OrderLogic(); Order o1 = ol.SelectByID(Convert.ToInt32(e.CommandArgument)); o1.Status = "Converting"; ol.Update(o1); DataTable dt = ol.SelectAllJoined(); Repeater1.DataSource = dt; Repeater1.DataBind(); if (dt.Rows.Count == 0) { Table1.Visible = false; Label1.Visible = true; } else { Table1.Visible = true; Label1.Visible = false; } TransitionLogic tl = new TransitionLogic(); Transition t1 = new Transition(); t1.KeyID = o1.OrderID; t1.KeyType = "Ord"; t1.TranDate = DateTime.Now; t1.NewStatus = "Converting"; t1.Remarks = ((TextBox)e.Item.FindControl("TextBox3")).Text; tl.Insert(t1); }else if(e.CommandName.Equals("Ready")){ OrderLogic ol = new OrderLogic(); Order o1 = ol.SelectByID(Convert.ToInt32(e.CommandArgument)); o1.Status = "Ready"; ol.Update(o1); DataTable dt = ol.SelectAllJoined(); Repeater1.DataSource = dt; Repeater1.DataBind(); TransitionLogic tl = new TransitionLogic(); Transition t1 = new Transition(); t1.KeyID = o1.OrderID; t1.KeyType = "Ord"; t1.TranDate = DateTime.Now; t1.NewStatus = "Ready"; t1.Remarks = ((TextBox)e.Item.FindControl("TextBox3")).Text; tl.Insert(t1); }else if(e.CommandName.Equals("Dispached")){ OrderLogic ol = new OrderLogic(); Order o1 = ol.SelectByID(Convert.ToInt32(e.CommandArgument)); o1.Status = "Dispached"; ol.Update(o1); DataTable dt = ol.SelectAllJoined(); Repeater1.DataSource = dt; Repeater1.DataBind(); if (dt.Rows.Count == 0) { Table1.Visible = false; Label1.Visible = true; } else { Table1.Visible = true; Label1.Visible = false; } TransitionLogic tl = new TransitionLogic(); Transition t1 = new Transition(); t1.KeyID = o1.OrderID; t1.KeyType = "Ord"; t1.TranDate = DateTime.Now; t1.NewStatus = "Dispached"; t1.Remarks = ((TextBox)e.Item.FindControl("TextBox3")).Text; tl.Insert(t1); }else if(e.CommandName.Equals("Closed")){ OrderLogic ol = new OrderLogic(); Order o1 = ol.SelectByID(Convert.ToInt32(e.CommandArgument)); o1.Status = "Closed"; ol.Update(o1); DataTable dt = ol.SelectAllJoined(); Repeater1.DataSource = dt; Repeater1.DataBind(); if (dt.Rows.Count == 0) { Table1.Visible = false; Label1.Visible = true; } else { Table1.Visible = true; Label1.Visible = false; } TransitionLogic tl = new TransitionLogic(); Transition t1 = new Transition(); t1.KeyID = o1.OrderID; t1.KeyType = "Ord"; t1.TranDate = DateTime.Now; t1.NewStatus = "Closed"; t1.Remarks = ((TextBox)e.Item.FindControl("TextBox3")).Text; tl.Insert(t1); } } else { Response.Redirect("Access.aspx"); } }
protected void Button2_click(object sender, EventArgs e) { DateTime d1 = new DateTime(); // d1 = Convert.ToDateTime(TextBox1.Text); if (!DateTime.TryParseExact(TextBox1.Text, "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out d1)) { } Label2.Text = d1.ToString("dd/MM/yyyy"); TransitionLogic ol = new TransitionLogic(); DataTable dt1 = ol.SelectOrderStatus("Order Created",d1); DataTable dt2 = ol.SelectOrderStatus("Performa invoice generated", d1); DataTable dt3 = ol.SelectOrderStatus("Performa invoice approved", d1); DataTable dt4 = ol.SelectOrderStatus("Cylinder requested", d1); DataTable dt5 = ol.SelectOrderStatus("Cylinder received", d1); DataTable dt6 = ol.SelectOrderStatus("Print pending", d1); DataTable dt7 = ol.SelectOrderStatus("Converting", d1); DataTable dt8 = ol.SelectOrderStatus("Ready", d1); DataTable dt9 = ol.SelectOrderStatus("Dispached", d1); DataTable dt10 = ol.SelectOrderStatus("Closed", d1); int max = findMax(dt1.Rows.Count, dt2.Rows.Count, dt3.Rows.Count, dt4.Rows.Count, dt5.Rows.Count, dt6.Rows.Count, dt7.Rows.Count, dt8.Rows.Count,dt9.Rows.Count, dt10.Rows.Count); if (dt1.Rows.Count < max) { for (int i = dt1.Rows.Count; i < max; i++) { dt1.Rows.Add("-"); } } if (dt2.Rows.Count < max) { for (int i = dt2.Rows.Count; i < max; i++) { dt2.Rows.Add("-"); } } if (dt3.Rows.Count < max) { for (int i = dt3.Rows.Count; i < max; i++) { dt3.Rows.Add("-"); } } if (dt4.Rows.Count < max) { for (int i = dt4.Rows.Count; i < max; i++) { dt4.Rows.Add("-"); } } if (dt5.Rows.Count < max) { for (int i = dt5.Rows.Count; i < max; i++) { dt5.Rows.Add("-"); } } if (dt6.Rows.Count < max) { for (int i = dt6.Rows.Count; i < max; i++) { dt6.Rows.Add("-"); } } if (dt7.Rows.Count < max) { for (int i = dt7.Rows.Count; i < max; i++) { dt7.Rows.Add("-"); } } if (dt8.Rows.Count < max) { for (int i = dt8.Rows.Count; i < max; i++) { dt8.Rows.Add("-"); } } if (dt9.Rows.Count < max) { for (int i = dt9.Rows.Count; i < max; i++) { dt9.Rows.Add("-"); } } if (dt10.Rows.Count < max) { for (int i = dt10.Rows.Count; i < max; i++) { dt10.Rows.Add("-"); } } Repeater1.DataSource = dt1; Repeater2.DataSource = dt2; Repeater3.DataSource = dt3; Repeater4.DataSource = dt4; Repeater5.DataSource = dt5; Repeater6.DataSource = dt6; Repeater7.DataSource = dt7; Repeater8.DataSource = dt8; Repeater9.DataSource = dt9; Repeater10.DataSource = dt10; Repeater1.DataBind(); Repeater2.DataBind(); Repeater3.DataBind(); Repeater4.DataBind(); Repeater5.DataBind(); Repeater6.DataBind(); Repeater7.DataBind(); Repeater8.DataBind(); Repeater9.DataBind(); Repeater10.DataBind(); }
protected void Button1_Click(object sender, EventArgs e) { if (Convert.ToInt32(Request.QueryString["ID"]) > 0) { //edit mode ProductLogic PL = new ProductLogic(); Product objPro = PL.SelectByProductID(Convert.ToInt32(Request.QueryString["ID"])); objPro.Name = TextBox1.Text; if (objPro.Status.Equals(DropDownList3.SelectedItem.Text)) { objPro.Status = DropDownList3.SelectedItem.Text; } else { TransitionLogic tl = new TransitionLogic(); Transition t1 = new Transition(); t1.KeyID = objPro.ProductID; t1.KeyType = "Prod"; t1.TranDate = DateTime.Now; t1.NewStatus = DropDownList3.SelectedItem.Text; t1.Remarks = ""; tl.Insert(t1); objPro.Status = DropDownList3.SelectedItem.Text; } objPro.Description = TextArea1.Text; objPro.Size = TextBox4.Text; objPro.Colors = TextBox5.Text; objPro.Type = DropDownList1.SelectedItem.Text; objPro.CustomerID = Convert.ToInt32(DropDownList2.SelectedItem.Value); DateTime d1 = new DateTime(); if (!DateTime.TryParseExact(TextBox2.Text, "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out d1)) { objPro.CreateDate = DateTime.Now; } if (d1.ToShortDateString().Equals(DateTime.Today.ToShortDateString())) { objPro.CreateDate = DateTime.Now; } else { objPro.CreateDate = d1; } String path = objPro.DesignFiles; string ticks = DateTime.Now.Ticks.ToString(); if (FileUpload1.HasFile) { FileUpload1.SaveAs(Server.MapPath("Images/" + ticks + FileUpload1.FileName)); path += "Images/" + ticks + FileUpload1.FileName + "#,#"; } if (FileUpload2.HasFile) { FileUpload2.SaveAs(Server.MapPath("Images/" + ticks + FileUpload2.FileName)); path += "Images/" + ticks + FileUpload2.FileName + "#,#"; } if (FileUpload3.HasFile) { FileUpload3.SaveAs(Server.MapPath("Images/" + ticks + FileUpload3.FileName)); path += "Images/" + ticks + FileUpload3.FileName + "#,#"; } if (FileUpload4.HasFile) { FileUpload4.SaveAs(Server.MapPath("Images/" + ticks + FileUpload4.FileName)); path += "Images/" + ticks + FileUpload4.FileName + "#,#"; } if (FileUpload5.HasFile) { FileUpload5.SaveAs(Server.MapPath("Images/" + ticks + FileUpload5.FileName)); path += "Images/" + ticks + FileUpload5.FileName + "#,#"; } objPro.DesignFiles = path; objPro.ProductID = Convert.ToInt32(Request.QueryString["id"]); PL.Update(objPro); Response.Redirect("ProdList.aspx"); } else { // insert mode Product objPro = new Product(); objPro.Name = TextBox1.Text; objPro.Status = DropDownList3.SelectedItem.Text; objPro.Description = TextArea1.Text; objPro.Size = TextBox4.Text; objPro.Colors = TextBox5.Text; objPro.Type = DropDownList1.Text; objPro.CustomerID = Convert.ToInt32(DropDownList2.SelectedItem.Value); DateTime d1 = new DateTime(); if (!DateTime.TryParseExact(TextBox2.Text, "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out d1)) { objPro.CreateDate = DateTime.Now; } if (d1.ToShortDateString().Equals(DateTime.Today.ToShortDateString())) { objPro.CreateDate = DateTime.Now; } else { objPro.CreateDate = d1; } String path = ""; string ticks = DateTime.Now.Ticks.ToString(); if (FileUpload1.HasFile) { FileUpload1.SaveAs(Server.MapPath("Images/" + ticks + FileUpload1.FileName)); path += "Images/" + ticks + FileUpload1.FileName + "#,#"; } if (FileUpload2.HasFile) { FileUpload2.SaveAs(Server.MapPath("Images/" + ticks + FileUpload2.FileName)); path += "Images/" + ticks + FileUpload2.FileName + "#,#"; } if (FileUpload3.HasFile) { FileUpload3.SaveAs(Server.MapPath("Images/" + ticks + FileUpload3.FileName)); path += "Images/" + ticks + FileUpload3.FileName + "#,#"; } if (FileUpload4.HasFile) { FileUpload4.SaveAs(Server.MapPath("Images/" + ticks + FileUpload4.FileName)); path += "Images/" + ticks + FileUpload4.FileName + "#,#"; } if (FileUpload5.HasFile) { FileUpload5.SaveAs(Server.MapPath("Images/" + ticks + FileUpload5.FileName)); path += "Images/" + ticks + FileUpload5.FileName + "#,#"; } objPro.DesignFiles = path; ProductLogic PL = new ProductLogic(); PL.Insert(objPro); Response.Redirect("ProdList.aspx"); } }