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;
}
}
