protected void GetPurchaseRequisitionsApprovalListByWarehouse(string warehouseId) { PurchaseRequisitionBLL purchaseRequisition = new PurchaseRequisitionBLL(); try { DataTable dt = purchaseRequisition.GetPurchaseRequisitionsApprovalListByWarehouse(warehouseId); purchaseRequisitionApprovalListGridView.DataSource = dt; purchaseRequisitionApprovalListGridView.DataBind(); if (purchaseRequisitionApprovalListGridView.Rows.Count > 0) { purchaseRequisitionApprovalListGridView.UseAccessibleHeader = true; purchaseRequisitionApprovalListGridView.HeaderRow.TableSection = TableRowSection.TableHeader; } else { msgbox.Visible = true; msgTitleLabel.Text = "Data Not Found!!!"; msgDetailLabel.Text = ""; } } catch (Exception ex) { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = ex.Message; } finally { purchaseRequisition = null; } }
protected void GetPurchaseRequisitionById(string purchaseRequisitionId) { PurchaseRequisitionBLL purchaseRequisition = new PurchaseRequisitionBLL(); try { DataTable dt = purchaseRequisition.GetPurchaseRequisitionById(purchaseRequisitionId); if (dt.Rows.Count > 0) { requisitionDateLabel.Text = dt.Rows[0]["RequisitionDate"].ToString(); warehouseIdLabel.Text = dt.Rows[0]["WarehouseId"].ToString(); warehouseNameLabel.Text = dt.Rows[0]["WarehouseName"].ToString(); narrationLabel.Text = dt.Rows[0]["Narration"].ToString(); statusLabel.Text = dt.Rows[0]["Status"].ToString(); lblCreatedBy.Text = dt.Rows[0]["CreatedBy"].ToString(); lblCreatedDate.Text = dt.Rows[0]["CreatedDate"].ToString(); } else { msgbox.Visible = true; msgTitleLabel.Text = "Data Not Found!!!"; msgDetailLabel.Text = ""; } } catch (Exception ex) { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = ex.Message; } finally { purchaseRequisition = null; } }
protected void GetPurchaseRequisitionProductListById(string purchaseRequisitionId) { PurchaseRequisitionBLL purchaseRequisition = new PurchaseRequisitionBLL(); try { DataTable dt = purchaseRequisition.GetPurchaseRequisitionProductListById(purchaseRequisitionId); if (dt.Rows.Count > 0) { purchaseRequisitionProductListGridView.DataSource = dt; purchaseRequisitionProductListGridView.DataBind(); if (purchaseRequisitionProductListGridView.Rows.Count > 0) { approveButton.Enabled = true; purchaseRequisitionProductListGridView.UseAccessibleHeader = true; purchaseRequisitionProductListGridView.HeaderRow.TableSection = TableRowSection.TableHeader; TextBox approveQuantityTextBox; TextBox unitPriceTextBox; DropDownList vendorDropDownList; VendorBLL vendor = new VendorBLL(); DataTable dtVendor=new DataTable(); for (int i = 0; i < purchaseRequisitionProductListGridView.Rows.Count; i++) { approveQuantityTextBox = (TextBox)purchaseRequisitionProductListGridView.Rows[i].FindControl("approveQuantityTextBox"); //approveQuantityTextBox.Text = purchaseRequisitionProductListGridView.Rows[i].Cells[3].Text.ToString(); approveQuantityTextBox.Text = dt.Rows[i][3].ToString(); unitPriceTextBox = (TextBox)purchaseRequisitionProductListGridView.Rows[i].FindControl("unitPriceTextBox"); unitPriceTextBox.Text = dt.Rows[i]["UnitPrice"].ToString(); dtVendor = vendor.GetProductVendorsByProductId(purchaseRequisitionProductListGridView.Rows[i].Cells[0].Text.ToString()); vendorDropDownList = (DropDownList)purchaseRequisitionProductListGridView.Rows[i].FindControl("vendorDropDownList"); vendorDropDownList.DataSource = dtVendor; vendorDropDownList.DataValueField = "VendorId"; vendorDropDownList.DataTextField = "VendorName"; vendorDropDownList.DataBind(); vendorDropDownList.Items.Insert(0, ""); vendorDropDownList.SelectedIndex = 0; vendorDropDownList.Items.Insert(dtVendor.Rows.Count+1, "Select Others."); } } else { approveButton.Enabled = false; } } else { msgbox.Visible = true; msgTitleLabel.Text = "Data Not Found!!!"; msgDetailLabel.Text = ""; } } catch (Exception ex) { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = ex.Message; } finally { purchaseRequisition = null; } }
protected void approveButton_Click(object sender, EventArgs e) { try { if (purchaseRequisitionProductListGridView.Rows.Count > 0) { TextBox approveQuantityTextBox; decimal num; bool isApproveQuantityNum; DropDownList vendorDropDownList; DropDownList statusDropDownList; TextBox narrationTextBox; TextBox unitPriceTextBox; DataTable dt = new DataTable(); DataRow dr = null; dt.Columns.Add(new DataColumn("ProductId")); dt.Columns.Add(new DataColumn("ApprovedQuantity")); dt.Columns.Add(new DataColumn("unitPriceTextBox")); dt.Columns.Add(new DataColumn("VendorId")); dt.Columns.Add(new DataColumn("Status")); dt.Columns.Add(new DataColumn("Narration")); for (int i = 0; i < purchaseRequisitionProductListGridView.Rows.Count; i++) { approveQuantityTextBox = (TextBox)purchaseRequisitionProductListGridView.Rows[i].FindControl("approveQuantityTextBox"); isApproveQuantityNum = decimal.TryParse(approveQuantityTextBox.Text.Trim(), out num); vendorDropDownList = (DropDownList)purchaseRequisitionProductListGridView.Rows[i].FindControl("vendorDropDownList"); statusDropDownList = (DropDownList)purchaseRequisitionProductListGridView.Rows[i].FindControl("statusDropDownList"); narrationTextBox = (TextBox)purchaseRequisitionProductListGridView.Rows[i].FindControl("narrationTextBox"); unitPriceTextBox = (TextBox)purchaseRequisitionProductListGridView.Rows[i].FindControl("unitPriceTextBox"); if (statusDropDownList.SelectedValue == "") { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Product ID [" + purchaseRequisitionProductListGridView.Rows[i].Cells[0].Text.ToString() + "] has no status selected."; return; } else if (statusDropDownList.SelectedValue == "A") { if (string.IsNullOrEmpty(approveQuantityTextBox.Text.Trim()) || !isApproveQuantityNum) { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Product ID [" + purchaseRequisitionProductListGridView.Rows[i].Cells[0].Text.ToString() + "] has no valid approved quantity."; return; } else if (vendorDropDownList.SelectedValue == "") { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Product ID [" + purchaseRequisitionProductListGridView.Rows[i].Cells[0].Text.ToString() + "] has no vendor selected."; return; } } dr = dt.NewRow(); dr["ProductId"] = purchaseRequisitionProductListGridView.Rows[i].Cells[0].Text.ToString(); dr["ApprovedQuantity"] = approveQuantityTextBox.Text.Trim(); dr["unitPriceTextBox"] = unitPriceTextBox.Text.Trim(); dr["VendorId"] = vendorDropDownList.SelectedValue.Trim(); dr["Status"] = statusDropDownList.SelectedValue.Trim(); dr["Narration"] = narrationTextBox.Text.Trim(); dt.Rows.Add(dr); } if (dt.Rows.Count == purchaseRequisitionProductListGridView.Rows.Count) { PurchaseRequisitionBLL purchaseRequisition = new PurchaseRequisitionBLL(); string msg = purchaseRequisition.ApprovePurchaseRequisitionAndCreatePurchaseOrder(dt, idLabel.Text.Trim(), warehouseIdLabel.Text.Trim()); string message = "<span class='actionTopic'></span> <span class='actionTopic'>" + msg + "</span>."; MyAlertBox("var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/PurchaseRequisition/ApprovalRequisitionList.aspx\"; }; SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", callbackOk);"); // MyAlertBox("alert(\"" + msg + " \"); window.location=\"/UI/PurchaseRequisition/ApprovalRequisitionList.aspx\""); } else { msgbox.Visible = true; msgTitleLabel.Text = "Collected Data Count Mismatch!!!"; msgDetailLabel.Text = ""; } } } catch (Exception ex) { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = ex.Message; } }
protected void saveButton_Click(object sender, EventArgs e) { string msg = string.Empty; List<PurchaseRequisitionBLL> purchaseRequisitions = new List<PurchaseRequisitionBLL>(); PurchaseRequisitionBLL purchaseRequisition; decimal quantity = 0; TextBox requisitionQuantityTextBox; TextBox requiredDateTextBox; TextBox productNarrationTextBox; int i = 0; try { if (warehouseDropDownList.SelectedValue == "") { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Warehouse Name field is required."; } else { for (i = 0; i < selectedProductListGridView.Rows.Count; i++) { requisitionQuantityTextBox = (TextBox)selectedProductListGridView.Rows[i].FindControl("requisitionQuantityTextBox"); requiredDateTextBox = (TextBox)selectedProductListGridView.Rows[i].FindControl("requiredDateTextBox"); productNarrationTextBox = (TextBox)selectedProductListGridView.Rows[i].FindControl("productNarrationTextBox"); if (!string.IsNullOrEmpty(requisitionQuantityTextBox.Text.Trim()) && decimal.TryParse(requisitionQuantityTextBox.Text.Trim(), out quantity)) { purchaseRequisition = new PurchaseRequisitionBLL(); purchaseRequisition.ProductId = selectedProductListGridView.Rows[i].Cells[0].Text.ToString(); purchaseRequisition.RequisitionQuantity = quantity.ToString(); purchaseRequisition.RequiredDate = LumexLibraryManager.ParseAppDate(requiredDateTextBox.Text.ToString()); purchaseRequisition.ProductNarration = productNarrationTextBox.Text.ToString(); purchaseRequisitions.Add(purchaseRequisition); } else { msg = "Product ID [" + selectedProductListGridView.Rows[i].Cells[0].Text.ToString() + "] has no valid quantity."; msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = msg; return; } } if (purchaseRequisitions.Count == selectedProductListGridView.Rows.Count) { purchaseRequisition = new PurchaseRequisitionBLL(); string purchaseRequisitionId = purchaseRequisition.SavePurchaseRequisition(purchaseRequisitions, warehouseDropDownList.SelectedValue.Trim(), narrationTextBox.Text.Trim()); string message = "Purchase Requisition <span class='actionTopic'>Created</span> Successfully with Purchase Requisition ID: <span class='actionTopic'>" + purchaseRequisitionId + "</span>."; MyAlertBox("var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/PurchaseRequisition/RequisitionList.aspx\"; }; SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", callbackOk);"); } else { } } } catch (Exception ex) { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = ex.Message; } finally { purchaseRequisition = null; } }
protected void requisitionListButton_Click(object sender, EventArgs e) { PurchaseRequisitionBLL purchaseRequisition = new PurchaseRequisitionBLL(); try { if (warehouseDropDownList.SelectedValue == "") { msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Warehouse Name field is required."; } else if (fromDateTextBox.Text.Trim() == "" || LumexLibraryManager.ParseAppDate(fromDateTextBox.Text.Trim()) == "False") { msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Date From field is required."; } else if (toDateTextBox.Text.Trim() == "" || LumexLibraryManager.ParseAppDate(toDateTextBox.Text.Trim()) == "False") { msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Date To field is required."; } else { string warehouseId = warehouseDropDownList.SelectedValue.Trim(); string fromDate = LumexLibraryManager.ParseAppDate(fromDateTextBox.Text.Trim()); string toDate = LumexLibraryManager.ParseAppDate(toDateTextBox.Text.Trim()); string status = statusDropDownList.SelectedValue.Trim(); DataTable dt = purchaseRequisition.GetPurchaseRequisitionsListByWarehouseDateRangeAndStatus(warehouseId, fromDate, toDate, status); purchaseRequisitionListGridView.DataSource = dt; purchaseRequisitionListGridView.DataBind(); if (purchaseRequisitionListGridView.Rows.Count > 0) { purchaseRequisitionListGridView.UseAccessibleHeader = true; purchaseRequisitionListGridView.HeaderRow.TableSection = TableRowSection.TableHeader; } else { msgbox.Visible = true; msgTitleLabel.Text = "Data Not Found!!!"; msgDetailLabel.Text = ""; } } } catch (Exception ex) { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = ex.Message; } finally { purchaseRequisition = null; } }