protected void btnReject_Click(object sender, EventArgs e) { purchaseOrderBL = new PurchaseOrderBL(); poId = Request.QueryString["poId"]; string status = "Rejected"; string supervisorComment = tbSupervisorComments.Text; EmployeeBO ebo = (EmployeeBO)Session["employee"]; string approverId = ebo.EmployeeId; Boolean flag = purchaseOrderBL.updateStatusByPoId(poId, status, supervisorComment, approverId); int value = 2; if (flag) { SendEmailApproveReject(poId, value); } else { string script = "alert('There is some issue in sending email. We apologize for this!');"; ClientScript.RegisterClientScriptBlock(this.GetType(), "Alert", script, true); } Response.Redirect("~/Store/POList.aspx"); gvPurchaseOrderList.DataSource = purchaseOrderBL.getPurchaseOrderListAll(); gvPurchaseOrderList.DataBind(); footableSettings(); }
protected void btnResubmit_Click(object sender, EventArgs e) { purchaseOrderBL = new PurchaseOrderBL(); poId = Request.QueryString["poId"]; string clerkComment = tbClerkComments.Text; EmployeeBO ebo = (EmployeeBO)Session["employee"]; string empId = ebo.EmployeeId; Boolean flag = purchaseOrderBL.resubmitPO(poId, clerkComment); if (flag) { SendEmailResubmit(poId); } else { string script = "alert('There is some issue in sending email. We apologize for this!');"; ClientScript.RegisterClientScriptBlock(this.GetType(), "Alert", script, true); } Response.Redirect("~/Store/POList.aspx"); gvPurchaseOrderList.DataSource = purchaseOrderBL.getPurchaseOrderList(empId); gvPurchaseOrderList.DataBind(); footableSettings(); }
int IPurchaseOrderRepository.AddUpdateOrder(PurchaseOrderForm quotationData) { IPurchaseOrderBL poBL = new PurchaseOrderBL(); int i = poBL.AddUpdateOrder(quotationData); return(i); }
protected void gvPurchaseOrderList_RowDeleting(object sender, GridViewDeleteEventArgs e) { string confirmValue = Request.Form["confirm_value"]; GridViewRow row = gvPurchaseOrderList.Rows[e.RowIndex]; poId = Request.QueryString["poId"]; string supplier = (row.FindControl("lblSupplier") as Label).Text; purchaseOrderBL = new PurchaseOrderBL(); if (confirmValue == "Yes") { int id = purchaseOrderBL.deletePurchaseOrderDetails(poId, supplier); if (id == 1) { Response.Redirect("~/Store/POList.aspx"); } else { gvPurchaseOrderList.DataSource = purchaseOrderBL.getPurchaseOrderDetailsList(poId); gvPurchaseOrderList.EditIndex = -1; gvPurchaseOrderList.DataBind(); footableSettings(); } } else { gvPurchaseOrderList.DataSource = purchaseOrderBL.getPurchaseOrderDetailsList(poId); gvPurchaseOrderList.EditIndex = -1; gvPurchaseOrderList.DataBind(); footableSettings(); } }
protected void btnAdd_Click(object sender, EventArgs e) { Session["count"] = 1; AddNewRecordRowToGrid(); string supplierName = (String)Session["ddlValue"]; purchaseOrderBL = new PurchaseOrderBL(); List <InventoryStockBO> list = purchaseOrderBL.getCategoryBySupplier(supplierName); List <String> l1 = purchaseOrderBL.getCategoryList(list); HashSet <String> hs = new HashSet <string>(l1); ddlCategory.DataSource = hs; ddlCategory.DataBind(); ListItem liCategory = new ListItem("Select Category", "-1"); ddlCategory.Items.Insert(0, liCategory); ddlCategory.SelectedIndex = 0; ddlItemName.Enabled = false; ddlItemName.SelectedIndex = 0; ddlSupplier.Enabled = false; ddlSupplier.SelectedItem.Text = (String)Session["ddlValue"]; tbUOM.Text = ""; tbPrice.Text = ""; tbQuantity.Text = ""; }
protected void Page_Load(object sender, EventArgs e) { int count = Convert.ToInt32(Session["count"]); if (!IsPostBack) { Page.DataBind(); purchaseOrderBL = new PurchaseOrderBL(); ddlCategory.DataSource = purchaseOrderBL.getCategoryList(); ddlCategory.DataBind(); ListItem liCategory = new ListItem("Select Category", "-1"); ddlCategory.Items.Insert(0, liCategory); ListItem liItemName = new ListItem("Select Item Name", "-1"); ddlItemName.Items.Insert(0, liItemName); ListItem liSupplier = new ListItem("Select Supplier", "-1"); ddlSupplier.Items.Insert(0, liSupplier); ddlItemName.Enabled = false; ddlSupplier.Enabled = false; AddDefaultFirstRecord(); } }
public void doProcess() { if (Session["employee"] != null) { EmployeeBO ebo = (EmployeeBO)Session["employee"]; string title = ebo.EmployeeTitle; int delegateValue = ebo.Delegate; poId = Request.QueryString["poId"]; lblPOID.Text = poId; lblName.Text = ebo.EmployeeName; purchaseOrderBL = new PurchaseOrderBL(); PurchaseOrderBO pbo = purchaseOrderBL.getStatusAndOrderDateDetails(poId); lblOrderDate.Text = String.Format("{0:dd/MMM/yyyy}", pbo.DateOfOrder); lblStatus.Text = pbo.Status; tbClerkComments.Text = pbo.CommentByClerk; tbSupervisorComments.Text = pbo.CommentBySupervisor; if (title.Equals("Supervisor") && (lblStatus.Text.Equals("Pending"))) { btnResubmit.Visible = false; this.gvPurchaseOrderList.Columns[7].Visible = false; tbClerkComments.Enabled = false; } else if (title.Equals("Manager") && (lblStatus.Text.Equals("Pending")) && delegateValue == 1) { btnResubmit.Visible = false; this.gvPurchaseOrderList.Columns[7].Visible = false; tbClerkComments.Enabled = false; } else if (title.Equals("Clerk") && lblStatus.Text.Equals("Pending")) { btnResubmit.Enabled = true; tbSupervisorComments.Enabled = false; this.gvPurchaseOrderList.Columns[7].Visible = true; btnApprove.Visible = false; btnReject.Visible = false; } else { this.gvPurchaseOrderList.Columns[7].Visible = false; tbClerkComments.Enabled = false; tbSupervisorComments.Enabled = false; btnResubmit.Visible = false; btnApprove.Visible = false; btnReject.Visible = false; } List <PurchaseOrderDetailsJoinBO> poDetailList = purchaseOrderBL.getPurchaseOrderDetailsList(poId); if (poDetailList.Count != 0) { gvPurchaseOrderList.DataSource = poDetailList; gvPurchaseOrderList.DataBind(); footableSettings(); } } else { Console.WriteLine("Something is wrong!!!!!!"); } }
public void SendEmailApproveReject(string poId, int value) { purchaseOrderBL = new PurchaseOrderBL(); PurchaseOrderBO po = purchaseOrderBL.getStatusAndOrderDateDetails(poId); string requestorId = po.RequestorId; EmployeeBO emp = purchaseOrderBL.getRequestorName(requestorId); SendEmail se = new SendEmail(); string subject = ""; string body = ""; if (value == 1) { subject = "Purchase Order Approved"; body = "Dear " + emp.EmployeeName + ", \n" + "\n" + "The Purchase Order with ID: " + poId + " requested by you has been approved." + "\n" + "(This is an auto-generated email, please do not reply.)" + "\n\n\n" + "Regards," + "\n" + "Admin"; } else { subject = "Purchase Order Rejected"; body = "Dear " + emp.EmployeeName + ", \n" + "\n" + "The Purchase Order with ID: " + poId + " requested by you has been rejected. Please contact your supervisor for further information" + "\n" + "(This is an auto-generated email, please do not reply.)" + "\n\n\n" + "Regards," + "\n" + "Admin"; } se.sendCPEmail(subject, body, emp.EmployeeEmail); }
protected void ddlItemName_SelectedIndexChanged(object sender, EventArgs e) { int count = Convert.ToInt32(Session["count"]); if (ddlItemName.SelectedIndex == 0 && count == 0) { ddlSupplier.Enabled = false; ddlSupplier.SelectedIndex = 0; tbUOM.Text = ""; tbPrice.Text = ""; tbQuantity.Text = ""; } else if (ddlItemName.SelectedIndex != 0 && count > 0) { purchaseOrderBL = new PurchaseOrderBL(); string itemName = ddlItemName.SelectedItem.Text; InventoryStockBO ins = new InventoryStockBO(); ins = purchaseOrderBL.getUOMByItem(itemName); tbUOM.Text = ins.ItemUOM.ToString(); ddlSupplier.Enabled = false; string supplier = (String)Session["ddlValue"]; ddlSupplier.SelectedItem.Text = supplier; PurchaseOrderDetailsJoinBO pod = new PurchaseOrderDetailsJoinBO(); pod = purchaseOrderBL.getPriceBySupplier(itemName, supplier); tbPrice.Text = pod.Price.ToString(); tbQuantity.Text = ""; } else { purchaseOrderBL = new PurchaseOrderBL(); string itemName = ddlItemName.SelectedItem.Text; InventoryStockBO ins = new InventoryStockBO(); ins = purchaseOrderBL.getUOMByItem(itemName); tbUOM.Text = ins.ItemUOM.ToString(); ddlSupplier.Enabled = true; List <String> supplierList = new List <string>(); InventoryStockBO bo = new InventoryStockBO(); bo = purchaseOrderBL.getSupplierByItem(itemName); supplierList.Add(bo.Supplier1); supplierList.Add(bo.Supplier2); supplierList.Add(bo.Supplier3); ddlSupplier.DataSource = supplierList; ddlSupplier.DataBind(); ListItem liSupplier = new ListItem("Select Supplier", "-1"); ddlSupplier.Items.Insert(0, liSupplier); tbPrice.Text = ""; tbQuantity.Text = ""; } }
protected void ddlSupplier_SelectedIndexChanged(object sender, EventArgs e) { int count = Convert.ToInt32(Session["count"]); purchaseOrderBL = new PurchaseOrderBL(); PurchaseOrderDetailsJoinBO ins = new PurchaseOrderDetailsJoinBO(); string itemName = ddlItemName.SelectedItem.Text; string supplier = ddlSupplier.SelectedItem.Text; ins = purchaseOrderBL.getPriceBySupplier(itemName, supplier); tbPrice.Text = ins.Price.ToString(); Session["ddlValue"] = ddlSupplier.SelectedItem.Text; }
protected void gvPurchaseOrderList_RowUpdating(object sender, GridViewUpdateEventArgs e) { GridViewRow row = gvPurchaseOrderList.Rows[e.RowIndex]; poId = Request.QueryString["poId"]; string itemNumber = (row.FindControl("lblItemNumber") as Label).Text; string quantity = (row.FindControl("txtQuantity") as TextBox).Text; int quan = Convert.ToInt32(quantity); purchaseOrderBL = new PurchaseOrderBL(); purchaseOrderBL.updateQuantity(poId, quan, itemNumber); gvPurchaseOrderList.DataSource = purchaseOrderBL.getPurchaseOrderDetailsList(poId); gvPurchaseOrderList.EditIndex = -1; gvPurchaseOrderList.DataBind(); footableSettings(); }
public void doProcess() { if (Session["employee"] != null) { EmployeeBO ebo = (EmployeeBO)Session["employee"]; string empId = ebo.EmployeeId; string title = ebo.EmployeeTitle; purchaseOrderBL = new PurchaseOrderBL(); if (title.Equals("Manager") || title.Equals("Supervisor")) { List <PurchaseOrderBO> polst = purchaseOrderBL.getPurchaseOrderListAll(); if (polst.Count != 0) { gvPurchaseOrderList.DataSource = polst; gvPurchaseOrderList.DataBind(); footableSettings(); } else { lblNoPOList.Text = "No Purchase Order List"; } } else { List <PurchaseOrderBO> polst = purchaseOrderBL.getPurchaseOrderList(empId); gvPurchaseOrderList.DataSource = polst; gvPurchaseOrderList.DataBind(); if (polst.Count != 0) { gvPurchaseOrderList.DataSource = polst; gvPurchaseOrderList.DataBind(); footableSettings(); } else { lblNoPOList.Text = "No Purchase Order List"; } } } else { Console.WriteLine("Something is wrong!!!!!!"); } }
/// <summary> /// Gets all purchase orders. /// </summary> /// <returns>Get All Purchase Orders</returns> public IEnumerable <PurchaseOrderEntity> GetAllPurchaseOrders() { IList <PurchaseOrderEntity> result = new List <PurchaseOrderEntity>(); IPurchaseOrderBL purchaseOrderBL = new PurchaseOrderBL(); List <PurchaseOrder> purchaseOrderList = purchaseOrderBL.GetAllPurchaseOrder(); foreach (PurchaseOrder source in purchaseOrderList) { PurchaseOrderEntity target = new PurchaseOrderEntity(); target.PurchaseOrderID = source.PurchaseOrderID; target.Vendor = source.Vendor; target.TotalPurchase = source.Total_Purchase; target.AveragePurchase = source.Average_Purchase; target.MinimumPurchase = source.Minimum_Purchase; target.MaximumPurchase = source.Maximum_Purchase; result.Add(target); } return(result); }
public PurchaseOrderForm GetPrintPurchaseOrder(string piNo) { IPurchaseOrderBL piBL = new PurchaseOrderBL(); return(piBL.GetPrintPurchaseOrder(piNo)); }
public string GetCategoryContent(string catType) { IPurchaseOrderBL poBL = new PurchaseOrderBL(); return(poBL.GetCategoryContent(catType)); }
//public int ConvertToPurchaseOrder(PurchaseOrderForm poForm) //{ // IPurchaseOrderBL poBL = new PurchaseOrderBL(); // return poBL.ConvertToPurchaseOrder(poForm); //} public int ConvertToPurchaseInvoice(PurchaseOrderForm quotationData) { IPurchaseOrderBL poBL = new PurchaseOrderBL(); return(poBL.ConvertToPurchaseInvoice(quotationData)); }
public int UpdationOrder(PurchaseOrderForm quotationData) { IPurchaseOrderBL poBL = new PurchaseOrderBL(); return(poBL.UpdationOrder(quotationData)); }
public PurchaseOrderForm GetPurchaseOrder(string poNo) { IPurchaseOrderBL poBL = new PurchaseOrderBL(); return(poBL.GetPurchaseOrder(poNo)); }
public bool CanDeleteOrder(int poID) { IPurchaseOrderBL poBL = new PurchaseOrderBL(); return(poBL.CanDeleteOrder(poID)); }
public bool DeleteOrder(int purchaseQuotID) { IPurchaseOrderBL poBL = new PurchaseOrderBL(); return(poBL.DeleteOrder(purchaseQuotID)); }
protected void btnSubmit_Click(object sender, EventArgs e) { DataTable datatbl = new DataTable(); if (Session["createPO"] != null && Convert.ToInt32(Session["gvCount"]) == 0) { ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Please select item's criteria first');window.location ='CreatePO.aspx';", true); Session["count"] = 0; } else { EmployeeBO ebo = (EmployeeBO)Session["employee"]; datatbl = (DataTable)Session["createPO"]; purchaseOrderBL = new PurchaseOrderBL(); PurchaseOrderBO poLastValue = new PurchaseOrderBO(); PurchaseOrderBO pobo = new PurchaseOrderBO(); poLastValue = purchaseOrderBL.countTotalPO(); string idSeperator = poLastValue.PoId.ToString().Substring(2);//gets the last PurchaseOrder ID from database int valuePod = Convert.ToInt32(idSeperator); if (valuePod < 100) { valuePod = valuePod + 1; poCountStr = "PO0" + valuePod; } else { valuePod = valuePod + 1; poCountStr = "PO" + valuePod; } pobo.PoId = poCountStr; string date = tbDeliveryDate.Text; DateTime dt = DateTime.Parse(tbDeliveryDate.Text); pobo.DeliveryDate = dt; pobo.DateOfOrder = DateTime.Today; string eId = ebo.EmployeeId; pobo.RequestorId = eId; pobo.CommentByClerk = Request.Form["tbClerkComments"]; EmployeeBO empBo = purchaseOrderBL.getSupervisorId();//get supervisor ID of the logged in employee pobo.ApproverId = empBo.EmployeeId; pobo.Status = "Pending"; Boolean flagPO = purchaseOrderBL.createPurchaseOrder(pobo); Boolean flagPOD = false; foreach (DataRow dr in datatbl.Rows) { PurchaseOrderDetailsBO pod = new PurchaseOrderDetailsBO(); pod.PoId = poCountStr; PurchaseOrderDetailsBO podLastValue = new PurchaseOrderDetailsBO(); podLastValue = purchaseOrderBL.countTotalPODId(); string idSeperate = podLastValue.PoDetailsId.ToString().Substring(2);//gets the last PurchaseOrderDetails ID from database int valuePoId = Convert.ToInt32(idSeperate); if (valuePoId < 100) { valuePoId = valuePoId + 1; podIdCountStr = "PD0" + valuePoId; } else { valuePoId = valuePoId + 1; podIdCountStr = "PD" + valuePoId; } pod.PoDetailsId = podIdCountStr; pod.SupplierId = ddlSupplier.SelectedItem.Text; string itemName = purchaseOrderBL.getItemNumberByName(dr["ItemName"].ToString()); pod.ItemNumber = itemName; pod.Quantity = Convert.ToInt32(dr["Quantity"]); flagPOD = purchaseOrderBL.createPurchaseOrderDetails(pod); } if (flagPO && flagPOD)//checks if both PurchaseOrder and PurchaseOrderDetails are updated to database. if so, send an email to the supervisor { SendEmailSubmit(poCountStr); } else { string script = "alert('There is some issue in sending email. We apologize for this!');"; ClientScript.RegisterClientScriptBlock(this.GetType(), "Alert", script, true); } Response.Redirect("~/Store/POList.aspx"); } }
public int GetLatestOrderNo() { IPurchaseOrderBL poBL = new PurchaseOrderBL(); return(poBL.GetLatestOrderNo()); }
public List <PurchaseOrderEntity> GetAllPurchaseOrders() { IPurchaseOrderBL poBL = new PurchaseOrderBL(); return(poBL.GetAllPurchaseOrders()); }
protected void ddlCategory_SelectedIndexChanged(object sender, EventArgs e) { int count = Convert.ToInt32(Session["count"]); if (ddlCategory.SelectedIndex == 0 && count == 0) { ddlItemName.Enabled = false; ddlItemName.SelectedIndex = 0; ddlSupplier.Enabled = false; ddlSupplier.SelectedIndex = 0; tbUOM.Text = ""; tbPrice.Text = ""; tbQuantity.Text = ""; } else if (ddlCategory.SelectedIndex == 0 && count > 0) { ddlItemName.Enabled = false; ddlItemName.SelectedIndex = 0; ddlSupplier.Enabled = false; ddlSupplier.SelectedItem.Text = (String)Session["ddlValue"]; tbUOM.Text = ""; tbPrice.Text = ""; tbQuantity.Text = ""; } else if (ddlCategory.SelectedIndex != 0 && count > 0) { ddlItemName.Enabled = true; purchaseOrderBL = new PurchaseOrderBL(); string category = ddlCategory.SelectedItem.Text; string supplier = (String)Session["ddlValue"]; List <InventoryStockBO> list = purchaseOrderBL.getItemListByCategoryAndSupplier(category, supplier); List <String> l1 = purchaseOrderBL.getItemNameList(list); ddlItemName.DataSource = l1; ddlItemName.DataBind(); ListItem liItemName = new ListItem("Select Item Name", "-1"); ddlItemName.Items.Insert(0, liItemName); ddlSupplier.Enabled = false; ddlSupplier.SelectedItem.Text = (String)Session["ddlValue"]; tbUOM.Text = ""; tbPrice.Text = ""; tbQuantity.Text = ""; } else { ddlItemName.Enabled = true; purchaseOrderBL = new PurchaseOrderBL(); string category = ddlCategory.SelectedItem.Text; List <InventoryStockBO> list = purchaseOrderBL.getItemListByCategory(category); List <String> l1 = purchaseOrderBL.getItemNameList(list); ddlItemName.DataSource = l1; ddlItemName.DataBind(); ListItem liItemName = new ListItem("Select Item Name", "-1"); ddlItemName.Items.Insert(0, liItemName); ddlSupplier.SelectedIndex = 0; ddlSupplier.Enabled = false; tbUOM.Text = ""; tbPrice.Text = ""; tbQuantity.Text = ""; } }