private void PopulateOrdersBySearch(string FieldName, string Value) { PCSN.InvoiceSystem.BusinessLogicLayer.Order Order = new PCSN.InvoiceSystem.BusinessLogicLayer.Order(); if (FieldName == "ToAndFromDate") { string[] ToandFrom = Value.Split('#'); string toDate = ""; string fromDate = ""; for (int i = 0; i < ToandFrom.Length; i++) { toDate = ToandFrom[i].ToString(); fromDate = ToandFrom[i + 1].ToString(); break; } dtOrderDG = Order.GetAllOrdersByToAndFromDate(toDate.ToString(), fromDate.ToString()); } if (FieldName == "OrderByMonth") { dtOrderDG = Order.GetAllOrdersByMonthAndYear(Value.ToString()); } dgOrders.DataSource = dtOrderDG; dgOrders.DataBind(); }
private void PopulateOrders() { PCSN.InvoiceSystem.BusinessLogicLayer.Order Order = new PCSN.InvoiceSystem.BusinessLogicLayer.Order(); dtOrderDG = Order.GetAllOrders(); dgOrders.DataSource = dtOrderDG; dgOrders.DataBind(); }
private void PopulateOrders(long OrderMasterID) { PCSN.InvoiceSystem.BusinessLogicLayer.Order Order = new PCSN.InvoiceSystem.BusinessLogicLayer.Order(); dtOrderDG = Order.GetOrderByID(OrderMasterID); dgOrders.DataSource = dtOrderDG; dgOrders.DataBind(); }
private void dgOrders_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { if (e.CommandName == "DeleteOrder") { string argsID = e.CommandArgument.ToString(); long OrderID = Convert.ToInt32(argsID); if (OrderID > 0) { PCSN.InvoiceSystem.BusinessLogicLayer.Order Order = new PCSN.InvoiceSystem.BusinessLogicLayer.Order(); Order.DeleteOrder(OrderID); lblErrorMessage.Text = "Order Deleted Successfuly."; PopulateOrders(); } } }
private void PopulateOrdersBySearch(string FieldName, string Value) { PCSN.InvoiceSystem.BusinessLogicLayer.Order Order = new PCSN.InvoiceSystem.BusinessLogicLayer.Order(); if (FieldName == "IsPending") { dtOrderDG = Order.GetAllOrdersBySearch(Convert.ToInt16(Value)); } if (FieldName == "OrderNumber") { dtOrderDG = Order.GetAllOrdersByOrderNumber(Convert.ToInt32(Value)); } if (FieldName == "OrderDate") { dtOrderDG = Order.GetAllOrdersByOrderDate(Value); } dgOrders.DataSource = dtOrderDG; dgOrders.DataBind(); }
protected void btnprintOrder_Click(object sender, EventArgs e) { PCSN.InvoiceSystem.BusinessLogicLayer.Order Order = new PCSN.InvoiceSystem.BusinessLogicLayer.Order(); bool checkBoxChecked = false; foreach (DataGridItem dg in dgOrders.Items) { CheckBox chk = (CheckBox)dg.FindControl("chkSelected"); if (chk.Checked) { checkBoxChecked = true; break; } } if (!checkBoxChecked) { lblErrorMessage.Text = "No Order selected."; return; } long OrderID = 0; foreach (DataGridItem dg in dgOrders.Items) { CheckBox chk = (CheckBox)dg.FindControl("chkSelected"); if (chk.Checked) { Label lbl = (Label)dg.FindControl("lblHidden"); OrderID = Convert.ToInt32(lbl.Text); Order.UpdateOrderMasterForPending(OrderID); } } lblErrorMessage.Text = "Pending Info saved successfully."; PopulateOrders(); }
private void dgOrders_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { if (e.CommandName == "DeleteOrder") { string argsID = e.CommandArgument.ToString(); string[] idSpliter = argsID.Split('/'); long OrderMasterID = 0; long OrderDetailID = 0; for (int i = 0; i < idSpliter.Length; i++) { OrderMasterID = Convert.ToInt32(idSpliter[i].ToString()); OrderDetailID = Convert.ToInt32(idSpliter[i + 1].ToString()); break; } if (OrderMasterID > 0 && OrderDetailID > 0) { PCSN.InvoiceSystem.BusinessLogicLayer.Order Order = new PCSN.InvoiceSystem.BusinessLogicLayer.Order(); Order.DeleteOrderItem(OrderMasterID, OrderDetailID); lblErrorMessage.Text = "Item Deleted Successfuly."; PopulateOrders(OrderMasterID); } } }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["OrderMasterID"] != null && Request.QueryString["OrderMasterID"].ToString() != "") { // This is for Showing Full Invoice long OrdermasterID = Convert.ToInt32(Request.QueryString["OrderMasterID"].ToString()); //long OrderDetailID = 0; PCSN.InvoiceSystem.BusinessLogicLayer.Order Order = new PCSN.InvoiceSystem.BusinessLogicLayer.Order(); if (Request.QueryString["Title"] == null || Request.QueryString["Title"].ToString() == "") { lblMainTitle.Text = "Order Slip"; } else { lblMainTitle.Text = Request.QueryString["Title"].ToString(); } lblDetailTitle.Text = "Order Details"; dtOrderEdit = Order.GetOrderByID(OrdermasterID); if (dtOrderEdit.Rows.Count > 0) { lblOrderDate.Text = Convert.ToDateTime(dtOrderEdit.Rows[0]["OrderDate"].ToString()).ToShortDateString(); lblOrderNumber.Text = dtOrderEdit.Rows[0]["OrderNumber"].ToString(); try { lblDueDate.Text = Convert.ToDateTime(dtOrderEdit.Rows[0]["DueDate"].ToString()).ToShortDateString(); } catch { lblDueDate.Text = ""; } lblClientName.Text = dtOrderEdit.Rows[0]["ClientName"].ToString() + Environment.NewLine; lblClientCompanyName.Text = dtOrderEdit.Rows[0]["ClientCompanyName"].ToString() + Environment.NewLine; lblClientAddress.Text = dtOrderEdit.Rows[0]["ClientCompanyAddress"].ToString() + Environment.NewLine; PCSN.InvoiceSystem.BusinessLogicLayer.OurCompany ourCompany = new PCSN.InvoiceSystem.BusinessLogicLayer.OurCompany(); DataTable dtOurCompany = new DataTable(); dtOurCompany = ourCompany.GetOurCompanyByID(Convert.ToInt32("1")); if (dtOurCompany.Rows.Count > 0) { //txtOurCompanyID.Text = dtOurCompany.Rows[0]["ID"].ToString(); lblCompanyName.Text = dtOurCompany.Rows[0]["CompanyName"].ToString() + Environment.NewLine; lblAddress.Text = dtOurCompany.Rows[0]["CompanyAddress"].ToString() + Environment.NewLine; } else { lblCompanyName.Text = "Power Protection System"; } for (int a = 0; a < dtOrderEdit.Rows.Count; a++) { GenerateHTML += "<tr>" + Environment.NewLine; GenerateHTML += "<td>" + Environment.NewLine; //GenerateHTML += dtOrderEdit.Rows[a]["Item"].ToString() + Environment.NewLine; GenerateHTML += "</td>" + Environment.NewLine; GenerateHTML += "<td>" + Environment.NewLine; GenerateHTML += dtOrderEdit.Rows[a]["Item"].ToString() + Environment.NewLine; GenerateHTML += "</td>" + Environment.NewLine; GenerateHTML += "<td align=\"justify\">" + Environment.NewLine; GenerateHTML += dtOrderEdit.Rows[a]["Description"].ToString() + Environment.NewLine; GenerateHTML += "</td>" + Environment.NewLine; GenerateHTML += "<td id=\"quantity\">" + Environment.NewLine; GenerateHTML += dtOrderEdit.Rows[a]["Quantity"].ToString() + Environment.NewLine; GenerateHTML += "</td>" + Environment.NewLine; GenerateHTML += "<td id=\"rate\">" + Environment.NewLine; GenerateHTML += dtOrderEdit.Rows[a]["UnitPrice"].ToString() + Environment.NewLine; GenerateHTML += "</td>" + Environment.NewLine; GenerateHTML += "<td id=\"amount\">" + Environment.NewLine; GenerateHTML += dtOrderEdit.Rows[a]["ItemAmount"].ToString() + Environment.NewLine; GenerateHTML += "</td>" + Environment.NewLine; GenerateHTML += "</tr>" + Environment.NewLine; } lblGrandTotdal.Text = dtOrderEdit.Rows[0]["TotalAmount"].ToString(); } } }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["OrderMasterID"] != null && Request.QueryString["OrderMasterID"].ToString() != "" && Request.QueryString["OrderDetailID"] != null && Request.QueryString["OrderDetailID"].ToString() != "" && !Page.IsPostBack) { // This is for Updating and ITEM in Order long OrdermasterID = Convert.ToInt32(Request.QueryString["OrderMasterID"].ToString()); PCSN.InvoiceSystem.BusinessLogicLayer.Order Order = new PCSN.InvoiceSystem.BusinessLogicLayer.Order(); txtOrderMasterID.Text = Request.QueryString["OrderMasterID"].ToString(); lblTotalAmount.Text = "0"; dtOrderEdit = Order.GetOrderByID(OrdermasterID); for (int a = 0; a < dtOrderEdit.Rows.Count; a++) { if (dtOrderEdit.Rows[a]["OrderDetailID"].ToString() == Request.QueryString["OrderDetailID"].ToString()) { lblDetailDate.Text = Convert.ToDateTime(dtOrderEdit.Rows[a]["OrderDate"].ToString()).ToShortDateString(); txtItem.Text = dtOrderEdit.Rows[a]["Item"].ToString(); txtItemID.Text = dtOrderEdit.Rows[a]["OrderDetailID"].ToString(); txtDescription.Text = dtOrderEdit.Rows[a]["Description"].ToString(); txtQuantity.Text = dtOrderEdit.Rows[a]["Quantity"].ToString(); txtUnitPrice.Text = dtOrderEdit.Rows[a]["UnitPrice"].ToString(); txtItemAmount.Text = dtOrderEdit.Rows[a]["ItemAmount"].ToString(); cboClientList.SelectedValue = dtOrderEdit.Rows[a]["ClientID"].ToString(); txtDueDate.Text = Convert.ToDateTime(dtOrderEdit.Rows[a]["DueDate"].ToString()).ToShortDateString(); //lblTotalAmount.Text = dtOrderEdit.Rows[a]["TotalAmount"].ToString(); if (dtOrderEdit.Rows[a]["ID"].ToString() != "") { PopulateOrders(Convert.ToInt32(dtOrderEdit.Rows[a]["ID"].ToString())); } } lblTotalAmount.Text = Convert.ToString(Convert.ToInt32(lblTotalAmount.Text) + Convert.ToInt32(dtOrderEdit.Rows[a]["ItemAmount"].ToString())); } } if (!Page.IsPostBack) { if (Request.QueryString["OrderMasterIDEdit"] != null && Request.QueryString["OrderMasterIDEdit"].ToString() != "") { txtOrderMasterID.Text = Request.QueryString["OrderMasterIDEdit"].ToString(); } // txtOrderMasterID.Text = "16"; if (txtOrderMasterID.Text == "") { // This is when a Fresh Order is About to GeneUnitPrice txtClient.Text = "Please Select a Client from Above List"; PCSN.InvoiceSystem.BusinessLogicLayer.OurCompany ourCompany = new PCSN.InvoiceSystem.BusinessLogicLayer.OurCompany(); dtOurCompany = ourCompany.GetOurCompanyByID(Convert.ToInt32("1")); if (dtOurCompany.Rows.Count <= 0) { txtOurCompany.Text = "PC.Solutions.NET"; } else { txtOurCompanyID.Text = dtOurCompany.Rows[0]["ID"].ToString(); txtOurCompany.Text = dtOurCompany.Rows[0]["CompanyName"].ToString() + Environment.NewLine; txtOurCompany.Text = txtOurCompany.Text + dtOurCompany.Rows[0]["CompanyAddress"].ToString() + Environment.NewLine; } lblHeaderDate.Text = Convert.ToString(DateTime.Now.ToShortDateString()); lblDetailDate.Text = Convert.ToString(DateTime.Now.ToShortDateString()); PCSN.InvoiceSystem.BusinessLogicLayer.Order Order = new PCSN.InvoiceSystem.BusinessLogicLayer.Order(); dtOrder = Order.GetAllOrderMAX(); if (dtOrder.Rows.Count == 0 || dtOrder.Rows[0]["ID"].ToString() == "") { lblOrderNumber.Text = "1"; } else { lblOrderNumber.Text = Convert.ToInt32(Convert.ToInt32(dtOrder.Rows[0]["ID"].ToString()) + 1).ToString(); } if (txtOrderMasterID.Text != "") { PopulateOrders(Convert.ToInt32(txtOrderMasterID.Text)); } PopulateClients(); } else { // This is when the Order ID is getting from somewhere // Like from Query Strings long OrdermasterID = Convert.ToInt32(txtOrderMasterID.Text.ToString()); lblOrderNumber.Text = OrdermasterID.ToString(); PopulateClients(); PopulateOrders(OrdermasterID); PCSN.InvoiceSystem.BusinessLogicLayer.Order Order = new PCSN.InvoiceSystem.BusinessLogicLayer.Order(); lblTotalAmount.Text = "0"; dtOrderEdit = Order.GetOrderByID(OrdermasterID); for (int a = 0; a < dtOrderEdit.Rows.Count; a++) { if (dtOrderEdit.Rows[a]["ItemAmount"].ToString() == null || dtOrderEdit.Rows[a]["ItemAmount"].ToString() == "") { } else { lblTotalAmount.Text = Convert.ToString(Convert.ToInt32(lblTotalAmount.Text) + Convert.ToInt32(dtOrderEdit.Rows[a]["ItemAmount"].ToString())); } } if (dtOrderEdit.Rows.Count > 0) { //PopulateOrders(Convert.ToInt32(dtOrderEdit.Rows[0]["ID"].ToString())); PCSN.InvoiceSystem.BusinessLogicLayer.Client client = new PCSN.InvoiceSystem.BusinessLogicLayer.Client(); dtClient = client.GetClientByID(Convert.ToInt32(dtOrderEdit.Rows[0]["ClientID"].ToString())); if (dtClient.Rows.Count <= 0) { txtClient.Text = "Our Client"; } else { cboClientList.SelectedValue = dtClient.Rows[0]["ID"].ToString(); txtClientID.Text = dtClient.Rows[0]["ID"].ToString(); txtClient.Text = dtClient.Rows[0]["ClientName"].ToString() + Environment.NewLine; txtClient.Text = txtClient.Text + dtClient.Rows[0]["CompanyName"].ToString() + Environment.NewLine; txtClient.Text = txtClient.Text + dtClient.Rows[0]["Address"].ToString() + Environment.NewLine; } txtOurCompanyID.Text = "1"; txtOurCompany.Text = "Power Protection Services" + Environment.NewLine; txtOurCompany.Text = txtOurCompany.Text + "XYZ Address" + Environment.NewLine; lblHeaderDate.Text = Convert.ToString(Convert.ToDateTime(dtOrderEdit.Rows[0]["OrderDate"].ToString()).ToShortDateString()); txtDueDate.Text = Convert.ToString(Convert.ToDateTime(dtOrderEdit.Rows[0]["DueDate"].ToString()).ToShortDateString()); lblDetailDate.Text = Convert.ToString(Convert.ToDateTime(dtOrderEdit.Rows[0]["OrderDate"].ToString()).ToShortDateString()); } } } }
protected void btnSaveOrder_Click(object sender, EventArgs e) { PCSN.InvoiceSystem.BusinessLogicLayer.Order Order = new PCSN.InvoiceSystem.BusinessLogicLayer.Order(); long OrderMasterID = 0; long OrderDetailID = 0; if (txtItemID.Text == "") { // This runs When a new Order is Created or New Item Add in a Order if (txtOrderMasterID.Text != "") { OrderMasterID = Convert.ToInt32(txtOrderMasterID.Text); } if (ValidateClientSide()) { if (txtOrderMasterID.Text == "") { OrderMasterID = Order.InsertOrderMaster(Convert.ToInt32(lblOrderNumber.Text), lblHeaderDate.Text.ToString(), txtDueDate.Text.ToString(), Convert.ToInt32(txtClientID.Text), lblTotalAmount.Text.ToString()); txtOrderMasterID.Text = OrderMasterID.ToString(); } else { OrderMasterID = Convert.ToInt32(txtOrderMasterID.Text); } if (OrderMasterID > 0) { txtOrderMasterID.Text = OrderMasterID.ToString(); OrderDetailID = Order.InsertOrderDetail(OrderMasterID, txtItem.Text.ToString(), txtDescription.Text.ToString(), Convert.ToInt32(txtQuantity.Text), Convert.ToInt32(txtUnitPrice.Text), Convert.ToInt32(txtItemAmount.Text)); dtOrderEdit = Order.GetOrderByID(OrderMasterID); lblTotalAmount.Text = "0"; for (int a = 0; a < dtOrderEdit.Rows.Count; a++) { if (dtOrderEdit.Rows[a]["ItemAmount"].ToString() == null || dtOrderEdit.Rows[a]["ItemAmount"].ToString() == "") { } else { lblTotalAmount.Text = Convert.ToString(Convert.ToInt32(lblTotalAmount.Text) + Convert.ToInt32(dtOrderEdit.Rows[a]["ItemAmount"].ToString())); } } Order.UpdateOrderMaster(Convert.ToInt32(txtOrderMasterID.Text.ToString()), Convert.ToInt32(lblOrderNumber.Text.ToString()), lblHeaderDate.Text.ToString(), txtDueDate.Text.ToString(), Convert.ToInt32(txtClientID.Text.ToString()), lblTotalAmount.Text.ToString()); } if (OrderMasterID > 0) { lblErrorMessage.Text = "This Item has been saved."; if (lblTotalAmount.Text == "") { lblTotalAmount.Text = "0"; } lblTotalAmount.Text = Convert.ToString(Convert.ToInt32(lblTotalAmount.Text) + Convert.ToInt32(txtItemAmount.Text)); ClearControlDetail(); } } } else { // This runs when an Item is being Edited if (ValidateClientSide()) { if (txtOrderMasterID.Text != "") { OrderMasterID = Convert.ToInt32(txtOrderMasterID.Text); Order.UpdateOrderDetail(Convert.ToInt32(txtItemID.Text), Convert.ToInt32(txtOrderMasterID.Text), txtItem.Text.ToString(), txtDescription.Text.ToString(), Convert.ToInt32(txtQuantity.Text), Convert.ToInt32(txtUnitPrice.Text), Convert.ToInt32(txtItemAmount.Text)); dtOrderEdit = Order.GetOrderByID(OrderMasterID); lblTotalAmount.Text = "0"; for (int a = 0; a < dtOrderEdit.Rows.Count; a++) { if (dtOrderEdit.Rows[a]["ItemAmount"].ToString() == null || dtOrderEdit.Rows[a]["ItemAmount"].ToString() == "") { } else { lblTotalAmount.Text = Convert.ToString(Convert.ToInt32(lblTotalAmount.Text) + Convert.ToInt32(dtOrderEdit.Rows[a]["ItemAmount"].ToString())); } } Order.UpdateOrderMaster(Convert.ToInt32(txtOrderMasterID.Text.ToString()), Convert.ToInt32(lblOrderNumber.Text.ToString()), lblHeaderDate.Text.ToString(), txtDueDate.Text.ToString(), Convert.ToInt32(txtClientID.Text.ToString()), lblTotalAmount.Text.ToString()); } lblErrorMessage.Text = "This Item has been Updated."; ClearControlDetail(); } } if (OrderMasterID != 0) { PopulateOrders(OrderMasterID); lblTotalAmount.Text = "0"; dtOrderEdit = Order.GetOrderByID(OrderMasterID); for (int a = 0; a < dtOrderEdit.Rows.Count; a++) { if (dtOrderEdit.Rows[a]["ItemAmount"].ToString() == null || dtOrderEdit.Rows[a]["ItemAmount"].ToString() == "") { } else { lblTotalAmount.Text = Convert.ToString(Convert.ToInt32(lblTotalAmount.Text) + Convert.ToInt32(dtOrderEdit.Rows[a]["ItemAmount"].ToString())); } } } }