protected void GetProductTransferRequisitionProductListById(string transferRequisitionId) { ProductTransferRequisitionBLL productTransferRequisition = new ProductTransferRequisitionBLL(); try { DataTable dt = productTransferRequisition.GetProductTransferRequisitionProductListById(transferRequisitionId); if (dt.Rows.Count > 0) { productTransferRequisitionProductListGridView.DataSource = dt; productTransferRequisitionProductListGridView.DataBind(); if (productTransferRequisitionProductListGridView.Rows.Count > 0) { productTransferRequisitionProductListGridView.UseAccessibleHeader = true; productTransferRequisitionProductListGridView.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 { productTransferRequisition = null; } }
protected void GetProductTransferRequisitionById(string transferRequisitionId) { ProductTransferRequisitionBLL productTransferRequisition = new ProductTransferRequisitionBLL(); try { DataTable dt = productTransferRequisition.GetProductTransferRequisitionById(transferRequisitionId); if (dt.Rows.Count > 0) { requisitionDateLabel.Text = dt.Rows[0]["RequisitionDate"].ToString(); transferTypeLabel.Text = dt.Rows[0]["TransferType"].ToString(); transferFromIdLabel.Text = dt.Rows[0]["TransferFrom"].ToString(); transferFromNameLabel.Text = dt.Rows[0]["TransferFromName"].ToString(); transferToIdLabel.Text = dt.Rows[0]["TransferTo"].ToString(); transferToNameLabel.Text = dt.Rows[0]["TransferToName"].ToString(); narrationLabel.Text = dt.Rows[0]["Narration"].ToString(); statusLabel.Text = dt.Rows[0]["Status"].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 { productTransferRequisition = null; } }
protected void GetProductTransferRequisitionProductListById(string transferRequisitionId) { ProductTransferRequisitionBLL productTransferRequisition = new ProductTransferRequisitionBLL(); try { DataTable dt = productTransferRequisition.GetProductTransferRequisitionProductListById(transferRequisitionId); if (dt.Rows.Count > 0) { productTransferRequisitionProductListGridView.DataSource = dt; productTransferRequisitionProductListGridView.DataBind(); if (productTransferRequisitionProductListGridView.Rows.Count > 0) { approveButton.Enabled = true; productTransferRequisitionProductListGridView.UseAccessibleHeader = true; productTransferRequisitionProductListGridView.HeaderRow.TableSection = TableRowSection.TableHeader; TextBox approveQuantityTextBox; for (int i = 0; i < productTransferRequisitionProductListGridView.Rows.Count; i++) { approveQuantityTextBox = (TextBox)productTransferRequisitionProductListGridView.Rows[i].FindControl("approveQuantityTextBox"); //approveQuantityTextBox.Text = productTransferRequisitionProductListGridView.Rows[i].Cells[3].Text.ToString(); approveQuantityTextBox.Text = dt.Rows[i][3].ToString(); } } 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 { productTransferRequisition = null; } }
protected void GetProductTransferRequisitionsApprovalListByTransferTypeFromAndTo() { ProductTransferRequisitionBLL productTransferRequisition = new ProductTransferRequisitionBLL(); try { if (transferTypeDropDownList.SelectedValue == "") { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Transfer Type field is required."; } else if (transferFromDropDownList.SelectedValue == "") { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Transfer From field is required."; } else if (transferToDropDownList.SelectedValue == "") { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Transfer To field is required."; } else if (transferFromDropDownList.SelectedValue != "All" && transferToDropDownList.SelectedValue != "All" && transferFromDropDownList.SelectedValue == transferToDropDownList.SelectedValue) { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Transfer From & Transfer To field value should be different."; } else { string transferType = transferTypeDropDownList.SelectedValue.Trim(); string transferFrom = transferFromDropDownList.SelectedValue.Trim(); string transferTo = transferToDropDownList.SelectedValue.Trim(); DataTable dt = productTransferRequisition.GetProductTransferRequisitionsApprovalListByTransferTypeFromAndTo(transferType, transferFrom, transferTo); productTransferRequisitionApprovalListGridView.DataSource = dt; productTransferRequisitionApprovalListGridView.DataBind(); if (productTransferRequisitionApprovalListGridView.Rows.Count > 0) { productTransferRequisitionApprovalListGridView.UseAccessibleHeader = true; productTransferRequisitionApprovalListGridView.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 { productTransferRequisition = null; } }
protected void requisitionListButton_Click(object sender, EventArgs e) { ProductTransferRequisitionBLL productTransferRequisition = new ProductTransferRequisitionBLL(); try { if (transferTypeDropDownList.SelectedValue == "") { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Transfer Type field is required."; } else if (transferFromDropDownList.SelectedValue == "") { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Transfer From field is required."; } else if (transferToDropDownList.SelectedValue == "") { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Transfer To field is required."; } else if (transferFromDropDownList.SelectedValue != "All" && transferToDropDownList.SelectedValue != "All" && transferFromDropDownList.SelectedValue == transferToDropDownList.SelectedValue) { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Transfer From & Transfer To field value should be different."; } else { string transferType = transferTypeDropDownList.SelectedValue.Trim(); string transferFrom = transferFromDropDownList.SelectedValue.Trim(); string transferTo = transferToDropDownList.SelectedValue.Trim(); string fromDate = LumexLibraryManager.ParseAppDate(fromDateTextBox.Text.Trim()); string toDate = LumexLibraryManager.ParseAppDate(toDateTextBox.Text.Trim()); string status = statusDropDownList.SelectedValue.Trim(); DataTable dt = productTransferRequisition.GetProductTransferRequisitionsListByTransferTypeFromToDateRangeAndStatus(transferType, transferFrom, transferTo, fromDate, toDate, status); productRequisitionListGridView.DataSource = dt; productRequisitionListGridView.DataBind(); if (productRequisitionListGridView.Rows.Count > 0) { productRequisitionListGridView.UseAccessibleHeader = true; productRequisitionListGridView.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 { productTransferRequisition = null; } }
protected void saveButton_Click(object sender, EventArgs e) { string msg = string.Empty; List<ProductTransferRequisitionBLL> productTransferRequisitions = new List<ProductTransferRequisitionBLL>(); ProductTransferRequisitionBLL productTransferRequisition; int quantity = 0; TextBox requisitionQuantityTextBox; TextBox requiredDateTextBox; TextBox productNarrationTextBox; int i = 0; try { if (transferTypeDropDownList.SelectedValue == "") { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Transfer Type field is required."; } else if (transferFromDropDownList.SelectedValue == "") { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Transfer From field is required."; } else if (transferToDropDownList.SelectedValue == "") { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Transfer To field is required."; } else if (transferFromDropDownList.SelectedValue == transferToDropDownList.SelectedValue) { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Transfer From & Transfer To field value should be different."; } else { for (i = 0; i < selectedProductListGridView.Rows.Count; i++) { requisitionQuantityTextBox = (TextBox)selectedProductListGridView.Rows[i].Cells[4].FindControl("requisitionQuantityTextBox"); requiredDateTextBox = (TextBox)selectedProductListGridView.Rows[i].Cells[5].FindControl("requiredDateTextBox"); productNarrationTextBox = (TextBox)selectedProductListGridView.Rows[i].Cells[6].FindControl("productNarrationTextBox"); if (!string.IsNullOrEmpty(requisitionQuantityTextBox.Text.Trim()) && Int32.TryParse(requisitionQuantityTextBox.Text.Trim(), out quantity)) { productTransferRequisition = new ProductTransferRequisitionBLL(); productTransferRequisition.ProductId = selectedProductListGridView.Rows[i].Cells[1].Text.ToString(); productTransferRequisition.RequisitionQuantity = quantity.ToString(); productTransferRequisition.RequiredDate = LumexLibraryManager.ParseAppDate(requiredDateTextBox.Text.ToString()); productTransferRequisition.ProductNarration = productNarrationTextBox.Text.ToString(); productTransferRequisitions.Add(productTransferRequisition); } else { msg = "Product ID [" + selectedProductListGridView.Rows[i].Cells[1].Text.ToString() + "] has no valid quantity."; msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = msg; return; } } if (productTransferRequisitions.Count > 0) { productTransferRequisition = new ProductTransferRequisitionBLL(); string transferRequisitionId = productTransferRequisition.SaveProductTransferRequisition(productTransferRequisitions, transferTypeDropDownList.SelectedValue.Trim(), transferFromDropDownList.SelectedValue.Trim(), transferToDropDownList.SelectedValue.Trim(), narrationTextBox.Text.Trim()); MyAlertBox("alert(\"Product Transfer Requisition Created Successfully with Transfer Requisition ID: " + transferRequisitionId + " \"); window.location=\"/UI/ProductTransferRequisition/RequisitionList.aspx\""); } } } catch (Exception ex) { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = ex.Message; } finally { productTransferRequisition = null; productTransferRequisitions = null; } }
public string ApproveTransferRequisitionAndCreateTransferOrder(DataTable dt, ProductTransferRequisitionBLL productTransferRequisition, LumexDBPlayer db) { string transferOrderId = ""; int totalProductCount = dt.Rows.Count; int approveProductCount = 0; try { for (int i = 0; i < dt.Rows.Count; i++) { db.ClearParameters(); if (dt.Rows[i]["Status"].ToString().Trim() == "R") { db.AddParameters("@TransferRequisitionId", productTransferRequisition.TransferRequisitionId.Trim()); db.AddParameters("@ProductId", dt.Rows[i]["ProductId"].ToString().Trim()); db.AddParameters("@ApprovedQuantity", DBNull.Value); db.AddParameters("@StatusNarration", dt.Rows[i]["Narration"].ToString().Trim()); db.AddParameters("@Status", dt.Rows[i]["Status"].ToString().Trim()); dt.Rows.RemoveAt(i); i--; } else if (dt.Rows[i]["Status"].ToString().Trim() == "A") { db.AddParameters("@TransferRequisitionId", productTransferRequisition.TransferRequisitionId.Trim()); db.AddParameters("@ProductId", dt.Rows[i]["ProductId"].ToString().Trim()); db.AddParameters("@ApprovedQuantity", dt.Rows[i]["ApprovedQuantity"].ToString().Trim()); db.AddParameters("@StatusNarration", dt.Rows[i]["Narration"].ToString().Trim()); db.AddParameters("@Status", dt.Rows[i]["Status"].ToString().Trim()); } db.ExecuteNonQuery("UPDATE_PRODUCT_TRANSFER_REQUISITION_PRODUCT_BY_REQUISITION_AND_PRODUCT_ID", true); } approveProductCount = dt.Rows.Count; db.ClearParameters(); db.AddParameters("@TransferRequisitionId", productTransferRequisition.TransferRequisitionId.Trim()); if (approveProductCount == totalProductCount) { db.AddParameters("@Status", "A"); } else if (approveProductCount == 0) { db.AddParameters("@Status", "R"); } else { db.AddParameters("@Status", "PA"); } db.AddParameters("@OccuredBy", LumexSessionManager.Get("ActiveUserId").ToString()); db.AddParameters("@OccuredFrom", LumexLibraryManager.GetTerminal()); db.ExecuteNonQuery("UPDATE_PRODUCT_TRANSFER_REQUISITION_STATUS_BY_ID", true); if (approveProductCount != 0) { db.ClearParameters(); db.AddParameters("@Narration", "Aprv. Prd: " + approveProductCount.ToString() + ", Rej. Prd: " + (totalProductCount - approveProductCount).ToString()); db.AddParameters("@RequisitionId", productTransferRequisition.TransferRequisitionId.Trim()); db.AddParameters("@TransferFrom", productTransferRequisition.TransferFrom.Trim()); db.AddParameters("@TransferTo", productTransferRequisition.TransferTo.Trim()); db.AddParameters("@TransferType", productTransferRequisition.TransferType.Trim()); db.AddParameters("@Description", "Transfer Requisition"); db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString()); db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal()); DataTable dtPO = db.ExecuteDataTable("INSERT_PRODUCT_TRANSFER_ORDER", true); transferOrderId = dtPO.Rows[0][0].ToString(); for (int i = 0; i < dt.Rows.Count; i++) { db.ClearParameters(); db.AddParameters("@TransferOrderId", transferOrderId.Trim()); db.AddParameters("@ProductId", dt.Rows[i]["ProductId"].ToString().Trim()); db.AddParameters("@FreeQuantityWas", dt.Rows[i]["FreeQuantityWas"].ToString().Trim()); db.AddParameters("@ApprovedQuantity", dt.Rows[i]["ApprovedQuantity"].ToString().Trim()); db.ExecuteNonQuery("INSERT_PRODUCT_TRANSFER_ORDER_PRODUCT", true); } db.ClearParameters(); db.AddParameters("@TransferOrderId", transferOrderId.Trim()); db.AddParameters("@Description", "Transfer Requisition"); db.AddParameters("@TransferType", productTransferRequisition.TransferType.Trim()); db.AddParameters("@TransferFrom", productTransferRequisition.TransferFrom.Trim()); db.AddParameters("@ApprovedBy", LumexSessionManager.Get("ActiveUserId").ToString()); db.AddParameters("@ApprovedFrom", LumexLibraryManager.GetTerminal()); db.ExecuteNonQuery("UPDATE_PRODUCT_STOCK_TO_CREATE_PRODUCT_TRANSFER_ORDER", true); return "This Product Transfer Order Created & Product Stock Updated Successfully.\\r\\nContaining [ " + transferOrderId.Trim() + " ] Transfer Order ID."; } else { return "This Product Transfer Requisition[" + productTransferRequisition.TransferRequisitionId.Trim() + "] Rejected Successfully."; } } catch (Exception) { throw; } finally { dt = null; productTransferRequisition = null; } }
protected void approveButton_Click(object sender, EventArgs e) { try { if (productTransferRequisitionProductListGridView.Rows.Count > 0) { TextBox approveQuantityTextBox; int num; bool isApproveQuantityNum; DropDownList statusDropDownList; TextBox narrationTextBox; string freeQtyWas; DataTable dt = new DataTable(); DataRow dr = null; dt.Columns.Add(new DataColumn("ProductId")); dt.Columns.Add(new DataColumn("ApprovedQuantity")); dt.Columns.Add(new DataColumn("Status")); dt.Columns.Add(new DataColumn("Narration")); dt.Columns.Add(new DataColumn("FreeQuantityWas")); for (int i = 0; i < productTransferRequisitionProductListGridView.Rows.Count; i++) { approveQuantityTextBox = (TextBox)productTransferRequisitionProductListGridView.Rows[i].FindControl("approveQuantityTextBox"); isApproveQuantityNum = int.TryParse(approveQuantityTextBox.Text.Trim(), out num); statusDropDownList = (DropDownList)productTransferRequisitionProductListGridView.Rows[i].FindControl("statusDropDownList"); narrationTextBox = (TextBox)productTransferRequisitionProductListGridView.Rows[i].FindControl("narrationTextBox"); freeQtyWas = productTransferRequisitionProductListGridView.Rows[i].Cells[4].Text.Trim(); if (statusDropDownList.SelectedValue == "") { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Product ID [" + productTransferRequisitionProductListGridView.Rows[i].Cells[0].Text.ToString() + "] has no status selected."; return; } dr = dt.NewRow(); dr["ProductId"] = productTransferRequisitionProductListGridView.Rows[i].Cells[0].Text.ToString(); dr["ApprovedQuantity"] = approveQuantityTextBox.Text.Trim(); dr["Status"] = statusDropDownList.SelectedValue.Trim(); dr["Narration"] = narrationTextBox.Text.Trim(); dr["FreeQuantityWas"] = freeQtyWas.Trim(); dt.Rows.Add(dr); } if (dt.Rows.Count == productTransferRequisitionProductListGridView.Rows.Count) { ProductTransferRequisitionBLL productTransferRequisition = new ProductTransferRequisitionBLL(); productTransferRequisition.TransferRequisitionId = idLabel.Text.Trim(); productTransferRequisition.TransferFrom = transferFromIdLabel.Text.Trim(); productTransferRequisition.TransferTo = transferToIdLabel.Text.Trim(); productTransferRequisition.TransferType = transferTypeLabel.Text.Trim(); string msg = productTransferRequisition.ApproveTransferRequisitionAndCreateTransferOrder(dt); MyAlertBox("alert(\"" + msg + " \"); window.location=\"/UI/ProductTransferRequisition/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; } }