protected void GetPurchaseRecordsApprovalListByWarehouse(string warehouseId)
{
PurchaseToWHBLL purchaseRecord = new PurchaseToWHBLL();
try
{
DataTable dt = purchaseRecord.GetPurchaseRecordsApprovalListByWarehouse(warehouseId);
purchaseRecordListGridView.DataSource = dt;
purchaseRecordListGridView.DataBind();
if (purchaseRecordListGridView.Rows.Count > 0)
{
purchaseRecordListGridView.UseAccessibleHeader = true;
purchaseRecordListGridView.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
{
purchaseRecord = null;
}
}
protected void GetPurchaseRecordById(string purchaseRecordId)
{
PurchaseToWHBLL purchaseRecord = new PurchaseToWHBLL();
try
{
DataTable dt = purchaseRecord.GetPurchaseRecordById(purchaseRecordId);
if (dt.Rows.Count > 0)
{
//prIDLabel.Text = dt.Rows[0]["PurchaseRequisitionId"].ToString();
//prDateLabel.Text = " , " + dt.Rows[0]["PurchaseRequisitionDate"].ToString();
//poIDLabel.Text = dt.Rows[0]["PurchaseOrderId"].ToString();
//poDateLabel.Text = " , " + dt.Rows[0]["PurchaseOrderDate"].ToString();
warehouseIdLabel.Text = dt.Rows[0]["WarehouseId"].ToString();
warehouseNameLabel.Text = dt.Rows[0]["WarehouseName"].ToString();
vendorIdLabel.Text = dt.Rows[0]["VendorId"].ToString();
vendorNameLabel.Text = dt.Rows[0]["VendorName"].ToString();
//requisitionNarrationLabel.Text = dt.Rows[0]["RequisitionNarration"].ToString();
vendorOrderDateLabel.Text = dt.Rows[0]["VendorOrderDate"].ToString();
vendorOrderNumberLabel.Text = dt.Rows[0]["VendorOrderNumber"].ToString();
vendorInvoiceNumberLabel.Text = dt.Rows[0]["VendorInvoiceNumber"].ToString();
receivedDateLabel.Text = dt.Rows[0]["ReceivedDate"].ToString();
// lcNumberLabel.Text = dt.Rows[0]["LCNumber"].ToString();
// transportTypeLabel.Text = dt.Rows[0]["TransportType"].ToString();
paymentModeLabel.Text = dt.Rows[0]["PaymentMode"].ToString();
narrationLabel.Text = dt.Rows[0]["Narration"].ToString();
bankLabel.Text = dt.Rows[0]["Bank"].ToString();
bankBranchLabel.Text = dt.Rows[0]["BankBranch"].ToString();
chequeNumberLabel.Text = dt.Rows[0]["ChequeNumber"].ToString();
chequeDateLabel.Text = dt.Rows[0]["ChequeDate"].ToString();
// shippingAddressLabel.Text = dt.Rows[0]["ShippingAddress"].ToString();
// billingAddressLabel.Text = dt.Rows[0]["BillingAddress"].ToString();
recordDateLabel.Text = dt.Rows[0]["RecordDate"].ToString();
statusLabel.Text = dt.Rows[0]["Status"].ToString();
totalAmountLabel.Text = dt.Rows[0]["TotalAmount"].ToString();
//vatLabel.Text = dt.Rows[0]["VAT"].ToString();
//totalPayableLabel.Text = dt.Rows[0]["TotalPayable"].ToString();
paidAmountLabel.Text = dt.Rows[0]["PaidAmount"].ToString();
transportCostLabel.Text = dt.Rows[0]["TransportCost"].ToString();
discountAmountLabel.Text = dt.Rows[0]["DiscountAmount"].ToString();
totalPayableLabel.Text = dt.Rows[0]["TotalPayable"].ToString();
CreatedByLabel.Text = dt.Rows[0]["CreatedBy"].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
{
purchaseRecord = null;
}
}
protected void saveButton_Click(object sender, EventArgs e)
{
PurchaseToWHBLL purchaseRecord = new PurchaseToWHBLL();
string msg = string.Empty;
TextBox quantityTextBox;
TextBox ratePerUnitTextBox;
TextBox amountTextBox;
TextBox unitPriceTextBox;
float fnum;
float uprice;
double num;
int pNDCount = 0;
DataTable dt = new DataTable();
DataRow dr = null;
dt.Columns.Add("ProductId");
dt.Columns.Add("Quantity");
dt.Columns.Add("Amount");
dt.Columns.Add("RatePerUnit");
dt.Columns.Add("UnitPrice");
dt.Columns.Add("Status");
dt.Columns.Add("Narration");
try
{
//if (vendorOrderDateTextBox.Text.Trim() == "" || LumexLibraryManager.ParseAppDate(vendorOrderDateTextBox.Text.Trim()) == "False")
//{
// msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Vendor Order Date field is required.";
// return;
//}
//else if (vendorOrderNumberTextBox.Text.Trim() == "")
//{
// msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Vendor Order Number field is required.";
// return;
//}
//else
if (vendorInvoiceNumberTextBox.Text.Trim() == "")
{
msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Vendor Invoice Number field is required.";
return;
}
//else if (receivedDateTextBox.Text.Trim() == "" || LumexLibraryManager.ParseAppDate(receivedDateTextBox.Text.Trim()) == "False")
//{
// msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Received Date field is required.";
// return;
//}
//else if (transportTypeDropDownList.SelectedValue == "")
//{
// msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Transport Type field is required.";
// return;
//}
if (paymentModeDropDownList.SelectedValue == "Cheque")
{
if (chequeNumberTextBox.Text.Trim() == "")
{
msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Cheque Number field is required.";
return;
}
else if (chequeDateTextBox.Text.Trim() == "" || LumexLibraryManager.ParseAppDate(chequeDateTextBox.Text.Trim()) == "False")
{
msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Cheque Date field is required.";
return;
}
else if (bankDropDownList.Text == "")
{
msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Bank Name field is required.";
return;
}
//else if (bankBranchTextBox.Text.Trim() == "")
//{
// msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Bank Branch Name field is required.";
// return;
//}
}
UnitPriceCalculation();
for (int i = 0; i < purchaseProductListGridView.Rows.Count; i++)
{
quantityTextBox = (TextBox)purchaseProductListGridView.Rows[i].FindControl("quantityTextBox");
ratePerUnitTextBox = (TextBox)purchaseProductListGridView.Rows[i].FindControl("ratePerUnitTextBox");
amountTextBox = (TextBox)purchaseProductListGridView.Rows[i].FindControl("amountTextBox");
unitPriceTextBox = (TextBox)purchaseProductListGridView.Rows[i].FindControl("unitPriceTextBox");
if (!double.TryParse(quantityTextBox.Text.Trim(), out num))
{
msg = "Product ID [" + purchaseProductListGridView.Rows[i].Cells[0].Text.ToString() + "] has no valid Quantity.";
msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = msg;
return;
}
else if (!float.TryParse(ratePerUnitTextBox.Text.Trim(), out fnum))
{
msg = "Product ID [" + purchaseProductListGridView.Rows[i].Cells[0].Text.ToString() + "] has no valid Rate Per Unit.";
msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = msg;
return;
}
else if (!float.TryParse(amountTextBox.Text.Trim(), out fnum))
{
msg = "Product ID [" + purchaseProductListGridView.Rows[i].Cells[0].Text.ToString() + "] has no valid Amount.";
msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = msg;
return;
}
else if (!float.TryParse(unitPriceTextBox.Text.Trim(), out uprice))
{
msg = "Product ID [" + purchaseProductListGridView.Rows[i].Cells[0].Text.ToString() + "] has no valid Unit Price.";
msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = msg;
return;
}
else
{
dr = dt.NewRow();
dr["ProductId"] = purchaseProductListGridView.Rows[i].Cells[0].Text.ToString();
dr["Quantity"] = quantityTextBox.Text.Trim();
dr["Amount"] = amountTextBox.Text.Trim();
dr["RatePerUnit"] = ratePerUnitTextBox.Text.Trim();
dr["UnitPrice"] = unitPriceTextBox.Text.Trim();
dr["Status"] = "D";
dr["Narration"] = "";
//string[] oQty = purchaseProductListGridView.Rows[i].Cells[2].Text.ToString().Split(' ');
//if (int.Parse(quantityTextBox.Text.Trim()) == 0)
//{
// dr["Status"] = "ND"; pNDCount++;
//}
//else if (oQty[0].ToString().Trim() == quantityTextBox.Text.Trim())
//{
// dr["Status"] = "D";
//}
//else
//{
// dr["Status"] = "PD";
//}
dt.Rows.Add(dr);
}
}
if (dt.Rows.Count == purchaseProductListGridView.Rows.Count)
{
purchaseRecord.AccountId = accountHeadDropDownList.SelectedValue.Trim();
purchaseRecord.WarehouseId = warehouseDropDownList.SelectedValue;
purchaseRecord.PurchaseRequisitionId = "";
purchaseRecord.PurchaseOrderId = "";
purchaseRecord.VendorId = vendorDropDownList.SelectedValue;
purchaseRecord.VendorOrderDate = LumexLibraryManager.ParseAppDate(vendorOrderDateTextBox.Text.Trim());
purchaseRecord.VendorOrderNumber = vendorOrderNumberTextBox.Text.Trim();
purchaseRecord.VendorInvoiceNumber = vendorInvoiceNumberTextBox.Text.Trim();
purchaseRecord.ReceivedDate = LumexLibraryManager.ParseAppDate(receivedDateTextBox.Text.Trim());
purchaseRecord.TotalAmount = totalAmountTextBox.Text.Trim();
//purchaseRecord.VAT = vatTextBox.Text.Trim();
purchaseRecord.DiscountAmount = discountTextBox.Text.Trim();
purchaseRecord.TotalPayable = totalPayableTextBox.Text.Trim();
purchaseRecord.PaidAmount = paidAmountTextBox.Text.Trim();
purchaseRecord.TransportCost = transportCostTextBox.Text.Trim();
purchaseRecord.Narration = narrationTextBox.Text.Trim();
purchaseRecord.LCNumber = "";//lcNumberTextBox.Text.Trim();
purchaseRecord.TransportType = "";//transportTypeDropDownList.SelectedValue.Trim();
purchaseRecord.ShippingAddress = "";//shippingAddressTextBox.Text.Trim();
purchaseRecord.BillingAddress = "";//billingAddressTextBox.Text.Trim();
purchaseRecord.PaymentMode = paymentModeDropDownList.SelectedValue.Trim();
purchaseRecord.Bank = bankDropDownList.Text;
purchaseRecord.BankBranch = bankBranchTextBox.Text.Trim();
purchaseRecord.ChequeNumber = chequeNumberTextBox.Text.Trim();
purchaseRecord.ChequeDate = LumexLibraryManager.ParseAppDate(chequeDateTextBox.Text.Trim());
purchaseRecord.Status = "D";
//if (pNDCount > 0)
//{
// purchaseRecord.Status = "PD";
//}
//else
//{
// purchaseRecord.Status = "D";
//}
string id = purchaseRecord.SavePurchaseRecord(dt);
if (!string.IsNullOrEmpty(id))
{
string message = "Purchase Record <span class='actionTopic'>Created</span> Successfully with Purchase Record ID: <span class='actionTopic'>" + id + "</span>.";
MyAlertBox("var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/PurchaseToWH/PurchaseList.aspx\"; }; SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", callbackOk);");
// MyAlertBox("alert(\"Purchase Record Created Successfully with Purchase Record ID: " + id + " \"); window.location=\"/UI/PurchaseToWH/PurchaseList.aspx\"");
}
else
{
string message = "Purchase Record <span class='actionTopic'>Created</span> Is Faild </span>.";
MyAlertBox("var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/PurchaseToWH/PurchaseList.aspx\"; }; ErrorAlert(\"" + "Process Succeed" + "\", \"" + message + "\", callbackOk);");
// msgbox.Visible = true; msgTitleLabel.Text = "Failed to Create Purchase Record!!!"; msgDetailLabel.Text = "";
}
}
}
catch (Exception ex)
{
string message = ex.Message;
if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; }
MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");
}
finally
{
// purchaseRecord = null;
}
}
protected void GetPurchaseList()
{
PurchaseToWHBLL purchaseRecord = new PurchaseToWHBLL();
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 = purchaseRecord.GetPurchaseRecordsListByWarehouseDateRangeAndStatus(warehouseId, fromDate, toDate, status);
purchaseRecordListGridView.DataSource = dt;
purchaseRecordListGridView.DataBind();
if (purchaseRecordListGridView.Rows.Count > 0)
{
purchaseRecordListGridView.UseAccessibleHeader = true;
purchaseRecordListGridView.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
{
purchaseRecord = null;
}
}
public string SavePurchaseRecord(PurchaseToWHBLL purchaseRecord, DataTable dtPrdList, LumexDBPlayer db)
{
string purchaseRecordId = "";
try
{
db.AddParameters("@WarehouseId", purchaseRecord.WarehouseId.Trim());
db.AddParameters("@PurchaseRequisitionId", purchaseRecord.PurchaseRequisitionId.Trim());
db.AddParameters("@PurchaseOrderId", purchaseRecord.PurchaseOrderId.Trim());
db.AddParameters("@VendorId", purchaseRecord.VendorId.Trim());
db.AddParameters("@VendorOrderDate", purchaseRecord.VendorOrderDate.Trim());
db.AddParameters("@VendorOrderNumber", purchaseRecord.VendorOrderNumber.Trim());
db.AddParameters("@VendorInvoiceNumber", purchaseRecord.VendorInvoiceNumber.Trim());
db.AddParameters("@ReceivedDate", purchaseRecord.ReceivedDate.Trim());
db.AddParameters("@TotalAmount", purchaseRecord.TotalAmount.Trim());
//db.AddParameters("@VAT", purchaseRecord.VAT.Trim());
db.AddParameters("@DiscountAmount", purchaseRecord.DiscountAmount.Trim());
db.AddParameters("@TotalPayable", purchaseRecord.TotalPayable.Trim());
db.AddParameters("@PaidAmount", purchaseRecord.PaidAmount.Trim());
db.AddParameters("@TransportCost", purchaseRecord.TransportCost.Trim());
db.AddParameters("@Narration", purchaseRecord.Narration.Trim());
db.AddParameters("@LCNumber", purchaseRecord.LCNumber.Trim());
db.AddParameters("@TransportType", purchaseRecord.TransportType.Trim());
db.AddParameters("@ShippingAddress", purchaseRecord.ShippingAddress.Trim());
db.AddParameters("@BillingAddress", purchaseRecord.BillingAddress.Trim());
db.AddParameters("@PaymentMode", purchaseRecord.PaymentMode.Trim());
db.AddParameters("@AccountId", purchaseRecord.AccountId.Trim());
db.AddParameters("@Bank", purchaseRecord.Bank.Trim());
db.AddParameters("@BankBranch", purchaseRecord.BankBranch.Trim());
db.AddParameters("@ChequeNumber", purchaseRecord.ChequeNumber.Trim());
db.AddParameters("@ChequeDate", purchaseRecord.ChequeDate.Trim());
db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString());
db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
DataTable dt = db.ExecuteDataTable("INSERT_WAREHOUSE_PURCHASE_RECORD", true);
if (dt.Rows.Count > 0)
{
purchaseRecordId = dt.Rows[0][0].ToString();
}
for (int i = 0; i < dtPrdList.Rows.Count; i++)
{
db.ClearParameters();
db.AddParameters("@WarehouseId", purchaseRecord.WarehouseId.Trim());
db.AddParameters("@PurchaseRecordId", purchaseRecordId.Trim());
db.AddParameters("@ProductId", dtPrdList.Rows[i]["ProductId"].ToString());
db.AddParameters("@Quantity", dtPrdList.Rows[i]["Quantity"].ToString());
db.AddParameters("@Amount", dtPrdList.Rows[i]["Amount"].ToString());
db.AddParameters("@RatePerUnit", dtPrdList.Rows[i]["RatePerUnit"].ToString());
db.AddParameters("@UnitPrice", dtPrdList.Rows[i]["UnitPrice"].ToString());
db.AddParameters("@Status", dtPrdList.Rows[i]["Status"].ToString());
db.AddParameters("@Narration", dtPrdList.Rows[i]["Narration"].ToString());
db.ExecuteNonQuery("INSERT_WAREHOUSE_PURCHASE_RECORD_PRODUCT", true);
}
db.ClearParameters();
db.AddParameters("@PurchaseOrderId", purchaseRecord.PurchaseOrderId.Trim());
db.AddParameters("@Status", purchaseRecord.Status.Trim());
db.ExecuteNonQuery("UPDATE_PURCHASE_ORDER_STATUS_BY_ID", true);
return purchaseRecordId;
}
catch (Exception)
{
throw;
}
finally
{
purchaseRecord = null;
dtPrdList = null;
}
}
protected void RejectBtn_OnClick(object sender, EventArgs e)
{
PurchaseToWHBLL purchaseRecord = new PurchaseToWHBLL();
bool status = false;
try
{
status = purchaseRecord.rejectPurchaseRecord(warehouseIdLabel.Text.Trim(), idLabel.Text.Trim());
if (status)
{
string message = "Purchase Record <span class='actionTopic'>Rejected</span> Successfully.";
MyAlertBox("var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/PurchaseToWH/PurchaseApprovalList.aspx\"; }; SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", callbackOk);");
}
else
{
msgbox.Visible = true; msgTitleLabel.Text = "Warning!!!"; msgDetailLabel.Text = "Purchase can not be Rejected";
msgbox.Attributes.Add("Class", "alert alert-error");
}
}
catch (Exception ex)
{
msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = ex.Message;
}
}
protected void approveButton_Click(object sender, EventArgs e)
{
PurchaseToWHBLL purchaseRecord = new PurchaseToWHBLL();
try
{
purchaseRecord.ApprovePurchaseRecord(warehouseIdLabel.Text.Trim(), idLabel.Text.Trim());
string message = "Purchase Record <span class='actionTopic'>Approved</span> Successfully.";
MyAlertBox("var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/PurchaseToWH/PurchaseApprovalList.aspx\"; }; SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", callbackOk);");
// MyAlertBox("alert(\"Purchase Record Approved Successfully.\"); window.location=\"/UI/PurchaseToWH/PurchaseApprovalList.aspx\"");
}
catch (Exception ex)
{
msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = ex.Message;
}
finally
{
purchaseRecord = null;
}
}
protected void GetPurchaseRecordProductListById(string purchaseRecordId)
{
PurchaseToWHBLL purchaseRecord = new PurchaseToWHBLL();
try
{
DataTable dt = purchaseRecord.GetPurchaseRecordProductListById(purchaseRecordId);
if (dt.Rows.Count > 0)
{
purchaseOrderProductListGridView.DataSource = dt;
purchaseOrderProductListGridView.DataBind();
if (purchaseOrderProductListGridView.Rows.Count > 0)
{
purchaseOrderProductListGridView.UseAccessibleHeader = true;
purchaseOrderProductListGridView.HeaderRow.TableSection = TableRowSection.TableHeader;
approveButton.Enabled = true;
}
else
{
approveButton.Enabled = false;
}
}
else
{
msgbox.Visible = true; msgTitleLabel.Text = "Data Not Found!!!"; msgDetailLabel.Text = "";
}
}
catch (Exception ex)
{
msgbox.Visible = true; msgTitleLabel.Text = "Sorry!!!"; msgDetailLabel.Text = ex.Message;
}
finally
{
purchaseRecord = null;
}
}