protected void GetProductTransferRecordProductListById(string transferRecordId) { ProductTransferRecordBLL productTransferRecord = new ProductTransferRecordBLL(); try { DataTable dt = productTransferRecord.GetProductTransferRecordProductListById(transferRecordId); if (dt.Rows.Count > 0) { transferRecordProductListGridView.DataSource = dt; transferRecordProductListGridView.DataBind(); if (transferRecordProductListGridView.Rows.Count > 0) { transferRecordProductListGridView.UseAccessibleHeader = true; transferRecordProductListGridView.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 { productTransferRecord = null; } }
public string SaveProductTransferRecord(ProductTransferRecordBLL productTransferRecord, DataTable dtPrdList, LumexDBPlayer db) { string transferRecordId = ""; try { db.AddParameters("@TransferOrderId", productTransferRecord.TransferOrderId.Trim()); db.AddParameters("@TransferFrom", productTransferRecord.TransferFrom.Trim()); db.AddParameters("@TransferTo", productTransferRecord.TransferTo.Trim()); db.AddParameters("@TransferType", productTransferRecord.TransferType.Trim()); db.AddParameters("@Description", productTransferRecord.Description.Trim()); db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString()); db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal()); DataTable dt = db.ExecuteDataTable("INSERT_PRODUCT_TRANSFER_RECORD", true); if (dt.Rows.Count > 0) { transferRecordId = dt.Rows[0][0].ToString(); } for (int i = 0; i < dtPrdList.Rows.Count; i++) { db.ClearParameters(); db.AddParameters("@TransferRecordId", transferRecordId.Trim()); db.AddParameters("@ProductId", dtPrdList.Rows[i]["ProductId"].ToString()); db.AddParameters("@ReceivedQuantity", dtPrdList.Rows[i]["ReceivedQuantity"].ToString()); db.AddParameters("@DisappearedQuantity", dtPrdList.Rows[i]["DisappearedQuantity"].ToString()); db.AddParameters("@Status", dtPrdList.Rows[i]["Status"].ToString()); db.AddParameters("@Narration", dtPrdList.Rows[i]["Narration"].ToString()); db.ExecuteNonQuery("INSERT_PRODUCT_TRANSFER_RECORD_PRODUCT", true); } db.ClearParameters(); db.AddParameters("@TransferOrderId", productTransferRecord.TransferOrderId.Trim()); db.AddParameters("@Status", productTransferRecord.Status.Trim()); db.AddParameters("@CanceledBy", ""); db.AddParameters("@CanceledFrom", ""); db.ExecuteNonQuery("UPDATE_PRODUCT_TRANSFER_ORDER_STATUS_BY_ID", true); return transferRecordId; } catch (Exception) { throw; } finally { productTransferRecord = null; } }
protected void GetProductTransferRecordById(string transferRecordId) { ProductTransferRecordBLL productTransferRecord = new ProductTransferRecordBLL(); try { DataTable dt = productTransferRecord.GetProductTransferRecordById(transferRecordId); if (dt.Rows.Count > 0) { receivedDateLabel.Text = dt.Rows[0]["ReceivedDate"].ToString(); recordStatusLabel.Text = dt.Rows[0]["RecordStatus"].ToString(); orderIdLabel.Text = dt.Rows[0]["TransferOrderId"].ToString(); orderDateLabel.Text = dt.Rows[0]["OrderDate"].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(); requisitionIdLabel.Text = dt.Rows[0]["RequisitionId"].ToString(); requisitionDateLabel.Text = dt.Rows[0]["RequisitionDate"].ToString(); transportDateLabel.Text = dt.Rows[0]["TransportDate"].ToString(); descriptionLabel.Text = dt.Rows[0]["Description"].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 { productTransferRecord = null; } }
public DataTable GetProductTransferRecordsListByTransferDescriptionTypeFromToDateRangeAndStatus(ProductTransferRecordBLL productTransferRecord, LumexDBPlayer db) { try { db.AddParameters("@TransferDescription", productTransferRecord.Description.Trim()); db.AddParameters("@TransferType", productTransferRecord.TransferType.Trim()); db.AddParameters("@TransferTo", productTransferRecord.TransferTo.Trim()); db.AddParameters("@FromDate", productTransferRecord.FromDate.Trim()); db.AddParameters("@ToDate", productTransferRecord.ToDate.Trim()); db.AddParameters("@Status", productTransferRecord.Status.Trim()); DataTable dt = db.ExecuteDataTable("GET_PRODUCT_TRANSFER_RECORDS_BY_TRANSFER_DESCRIPTION_TYPE_FROM_TO_DATE_RANGE_AND_STATUS", true); return dt; } catch (Exception) { throw; } finally { productTransferRecord = null; } }
protected void saveButton_Click(object sender, EventArgs e) { ProductTransferRecordBLL productTransferRecord = new ProductTransferRecordBLL(); string msg = string.Empty; TextBox receivedQuantityTextBox; TextBox disappearedQuantityTextBox; TextBox narrationTextBox; int rQty; int dQty; int pNClCount = 0; DataTable dt = new DataTable(); DataRow dr = null; dt.Columns.Add("ProductId"); dt.Columns.Add("OrderQuantity"); dt.Columns.Add("ReceivedQuantity"); dt.Columns.Add("DisappearedQuantity"); dt.Columns.Add("Narration"); dt.Columns.Add("Status"); try { for (int i = 0; i < productTransferOrderProductListGridView.Rows.Count; i++) { receivedQuantityTextBox = (TextBox)productTransferOrderProductListGridView.Rows[i].FindControl("receivedQuantityTextBox"); disappearedQuantityTextBox = (TextBox)productTransferOrderProductListGridView.Rows[i].FindControl("disappearedQuantityTextBox"); narrationTextBox = (TextBox)productTransferOrderProductListGridView.Rows[i].FindControl("narrationTextBox"); string[] oQty = productTransferOrderProductListGridView.Rows[i].Cells[2].Text.Trim().Split(' '); if (!int.TryParse(receivedQuantityTextBox.Text.Trim(), out rQty)) { msg = "Product ID [" + productTransferOrderProductListGridView.Rows[i].Cells[0].Text.ToString() + "] has no valid Received Quantity."; msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = msg; return; } else if (!int.TryParse(disappearedQuantityTextBox.Text.Trim(), out dQty)) { msg = "Product ID [" + productTransferOrderProductListGridView.Rows[i].Cells[0].Text.ToString() + "] has no valid Disappeared Quantity."; msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = msg; return; } else if (disappearedQuantityTextBox.Text.Trim() != "0" && string.IsNullOrEmpty(narrationTextBox.Text.Trim())) { msg = "Narration field is required for Product ID [" + productTransferOrderProductListGridView.Rows[i].Cells[0].Text.ToString() + "]"; msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = msg; return; } else { dr = dt.NewRow(); dr["ProductId"] = productTransferOrderProductListGridView.Rows[i].Cells[0].Text.ToString(); dr["OrderQuantity"] = oQty[0].ToString().Trim(); dr["ReceivedQuantity"] = receivedQuantityTextBox.Text.Trim(); dr["DisappearedQuantity"] = disappearedQuantityTextBox.Text.Trim(); dr["Narration"] = narrationTextBox.Text.Trim(); if (disappearedQuantityTextBox.Text.Trim() == "0") { dr["Status"] = "Cl"; } else { dr["Status"] = "NCl"; pNClCount++; } dt.Rows.Add(dr); } } if (dt.Rows.Count == productTransferOrderProductListGridView.Rows.Count) { productTransferRecord.TransferOrderId = orderIdLabel.Text.Trim(); productTransferRecord.TransferFrom = transferFromIdLabel.Text.Trim(); productTransferRecord.TransferTo = transferToIdLabel.Text.Trim(); productTransferRecord.TransferType = transferTypeLabel.Text.Trim(); productTransferRecord.Description = descriptionLabel.Text.Trim(); if (pNClCount > 0) { productTransferRecord.Status = "PD"; } else { productTransferRecord.Status = "D"; } string id = productTransferRecord.SaveProductTransferRecord(dt); if (!string.IsNullOrEmpty(id)) { MyAlertBox("alert(\"Product Transfer Record Created Successfully with Transfer Record ID: " + id + " \"); window.location=\"/UI/ProductTransferRecord/TransferRecordList.aspx\""); } else { msgbox.Visible = true; msgTitleLabel.Text = "Failed to Create Product Transfer Record!!!"; msgDetailLabel.Text = ""; } } } catch (Exception ex) { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = ex.Message; } finally { productTransferRecord = null; } }
protected void recordListButton_Click(object sender, EventArgs e) { ProductTransferRecordBLL productTransferRecord = new ProductTransferRecordBLL(); try { if (transferTypeDropDownList.SelectedValue == "") { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Transfer Type field is required."; } else if (transferToDropDownList.SelectedValue == "") { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Transfer To field is required."; } else { productTransferRecord.Description = transferDescriptionDropDownList.SelectedValue.Trim(); productTransferRecord.TransferType = transferTypeDropDownList.SelectedValue.Trim(); productTransferRecord.TransferTo = transferToDropDownList.SelectedValue.Trim(); productTransferRecord.FromDate = LumexLibraryManager.ParseAppDate(fromDateTextBox.Text.Trim()); productTransferRecord.ToDate = LumexLibraryManager.ParseAppDate(toDateTextBox.Text.Trim()); productTransferRecord.Status = statusDropDownList.SelectedValue.Trim(); DataTable dt = productTransferRecord.GetProductTransferRecordsListByTransferDescriptionTypeFromToDateRangeAndStatus(); transferRecordListGridView.DataSource = dt; transferRecordListGridView.DataBind(); if (transferRecordListGridView.Rows.Count > 0) { transferRecordListGridView.UseAccessibleHeader = true; transferRecordListGridView.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 { productTransferRecord = null; } }
public void ApproveProductTransferRecord(ProductTransferRecordBLL productTransferRecord, LumexDBPlayer db) { try { db.AddParameters("@TransferRecordId", productTransferRecord.TransferRecordId.Trim()); db.AddParameters("@Description", productTransferRecord.Description.Trim()); db.AddParameters("@TransferType", productTransferRecord.TransferType.Trim()); db.AddParameters("@TransferTo", productTransferRecord.TransferTo.Trim()); db.AddParameters("@ApprovedBy", LumexSessionManager.Get("ActiveUserId").ToString()); db.AddParameters("@ApprovedFrom", LumexLibraryManager.GetTerminal()); db.ExecuteNonQuery("APPROVE_PRODUCT_TRANSFER_RECORD", true); } catch (Exception) { throw; } finally { productTransferRecord = null; } }
protected void GetApprovalList() { ProductTransferRecordBLL productTransferRecord = new ProductTransferRecordBLL(); try { if (transferTypeDropDownList.SelectedValue == "") { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Transfer Type field is required."; } else if (transferToDropDownList.SelectedValue == "") { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Transfer To field is required."; } else { productTransferRecord.Description = transferDescriptionDropDownList.SelectedValue.Trim(); productTransferRecord.TransferType = transferTypeDropDownList.SelectedValue.Trim(); productTransferRecord.TransferTo = transferToDropDownList.SelectedValue.Trim(); productTransferRecord.Status = "P"; DataTable dt = productTransferRecord.GetProductTransferRecordsListByTransferDescriptionTypeFromToAndStatus(); transferRecordListGridView.DataSource = dt; transferRecordListGridView.DataBind(); if (transferRecordListGridView.Rows.Count > 0) { transferRecordListGridView.UseAccessibleHeader = true; transferRecordListGridView.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 { productTransferRecord = null; } }
protected void approveButton_Click(object sender, EventArgs e) { ProductTransferRecordBLL productTransferRecord = new ProductTransferRecordBLL(); try { productTransferRecord.TransferRecordId = idLabel.Text.Trim(); productTransferRecord.Description = descriptionLabel.Text.Trim(); productTransferRecord.TransferType = transferTypeLabel.Text.Trim(); productTransferRecord.TransferTo = transferToIdLabel.Text.Trim(); productTransferRecord.ApproveProductTransferRecord(); MyAlertBox("alert(\"Product Transfer Record Approved Successfully.\"); window.location=\"/UI/ProductTransferRecord/TransferRecordApprovalList.aspx\""); } catch (Exception ex) { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = ex.Message; } finally { productTransferRecord = null; } }