public DataTable SaveVendorPaymentBySC(ReceivePaymentBLL receivePayment, LumexDBPlayer db)
{
try
{
db.AddParameters("@PurchaseRecordId", receivePayment.PurchaseRecordId.Trim());
db.AddParameters("@VendorId", receivePayment.VendorId.Trim());
db.AddParameters("@SalesCenterId", receivePayment.SalesCenterId.Trim());
db.AddParameters("@Amount", receivePayment.Amount.Trim());
db.AddParameters("@CurrentPayable", receivePayment.CurrentPayable.Trim());
db.AddParameters("@ApprovedBy", LumexSessionManager.Get("ActiveUserId").ToString());
db.AddParameters("@ApprovedFrom", LumexLibraryManager.GetTerminal());
DataTable dt = db.ExecuteDataTable("INSERT_VENDOR_PAYMENT_PURCHASE_WISE", true);
return dt;
}
catch (Exception)
{
throw;
}
}
private void getCustomerTotalReceivableByCustomerId()
{
ReceivePaymentBLL receivePayment = new ReceivePaymentBLL();
try
{
DataTable dt = receivePayment.GetCustomerTotalReceivable(customerIdDropDownList.SelectedValue, ddlSelectWareHouseOrSalesCenter.SelectedValue);
if (dt.Rows.Count > 0)
{
if (!string.IsNullOrEmpty(dt.Rows[0]["TotalDue"].ToString()))
{
previousDueTextBox.Text = dt.Rows[0]["TotalDue"].ToString();
previousDueDiv.Visible = true;
DuesAmoutPayTextBox.ReadOnly = false;
}
else
{
previousDueTextBox.Text = "0.00";
previousDueDiv.Visible = false;
DuesAmoutPayTextBox.ReadOnly = true;
}
}
else
{
//string message = "Customer <span class='actionTopic'>Due</span> Data not found.";
//MyAlertBox("WarningAlert(\"" + "Process Succeed" + "\", \"" + message + "\", \"\");");
previousDueTextBox.Text = "0.00";
previousDueDiv.Visible = false;
DuesAmoutPayTextBox.ReadOnly = true;
}
}
catch (Exception ex)
{
string message = ex.Message;
if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; }
MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");
}
finally
{
receivePayment = null;
}
}
public DataTable SaveVendorPayment(ReceivePaymentBLL receivePayment, string accountOn, string whscId,DataTable adata, LumexDBPlayer db)
{
try
{
decimal PaidAmount = Convert.ToDecimal(receivePayment.Amount.Trim());
DataTable dt = new DataTable();
if (adata.Rows.Count > 0)
{
for (int i = 0; i < adata.Rows.Count; i++)
{
db.ClearParameters();
if (PaidAmount > 0 && Convert.ToDecimal(adata.Rows[i]["Due"].ToString()) > 0)
{
db.AddParameters("@RecordId", adata.Rows[i]["PurchaseRecordId"].ToString());
if (Convert.ToDecimal(adata.Rows[i]["Due"].ToString()) >= PaidAmount)
{
db.AddParameters("@Amount", PaidAmount);
}
else
{
PaidAmount = PaidAmount - Convert.ToDecimal(adata.Rows[i]["Due"].ToString());
db.AddParameters("@Amount", Convert.ToDecimal(adata.Rows[i]["Due"].ToString()));
}
db.AddParameters("@AccountId", receivePayment.AccountId.Trim());
db.AddParameters("@VendorId", receivePayment.VendorId.Trim());
db.AddParameters("@SalesCenterId", whscId);
db.AddParameters("@CashCheque", receivePayment.CashCheque.Trim());
//db.AddParameters("@Amount", receivePayment.Amount.Trim());
db.AddParameters("@CurrentPayable", receivePayment.CurrentPayable.Trim());
db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString());
db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
db.AddParameters("@Bank", receivePayment.Bank.Trim());
db.AddParameters("@BankBrach", receivePayment.BankBrach.Trim());
db.AddParameters("@ChequeNo", receivePayment.ChequeNo.Trim());
db.AddParameters("@ChequeDate", LumexLibraryManager.ParseAppDate(receivePayment.ChequeDate));
dt = db.ExecuteDataTable("[INSERT_VENDOR_PAYMENT_BY_RECORD_ID]", true);
}
else
{
// break;
}
}
}
else
{
db.AddParameters("@AccountId", receivePayment.AccountId.Trim());
// db.AddParameters("@WHSCId", whscId.Trim());
db.AddParameters("@VendorId", receivePayment.VendorId.Trim());
db.AddParameters("@CashCheque", receivePayment.CashCheque.Trim());
db.AddParameters("@Amount", receivePayment.Amount.Trim());
db.AddParameters("@CurrentPayable", receivePayment.CurrentPayable.Trim());
db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString());
db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
db.AddParameters("@Bank", receivePayment.Bank.Trim());
db.AddParameters("@BankBrach", receivePayment.BankBrach.Trim());
db.AddParameters("@ChequeNo", receivePayment.ChequeNo.Trim());
db.AddParameters("@ChequeDate", LumexLibraryManager.ParseAppDate(receivePayment.ChequeDate));
db.AddParameters("@WHSCId", whscId);
dt = db.ExecuteDataTable("[INSERT_VENDOR_PAYMENT]", true);
}
return dt;
}
catch (Exception)
{
throw;
}
}
public DataTable SaveCustomerPayment(ReceivePaymentBLL receivePayment, string accountOn, DataTable adata, LumexDBPlayer db)
{
try
{
decimal ReceiveAmount = Convert.ToDecimal(receivePayment.Amount.Trim());
DataTable dt = new DataTable();
if (adata.Rows.Count > 0)
{
for (int i = 0; i < adata.Rows.Count; i++)
{
db.ClearParameters();
if (ReceiveAmount > 0 && Convert.ToDecimal(adata.Rows[i]["Due"].ToString())>0)
{
db.AddParameters("@RecordId", adata.Rows[i]["RecordId"].ToString());
if (Convert.ToDecimal(adata.Rows[i]["Due"].ToString()) >= ReceiveAmount)
{
db.AddParameters("@Amount", ReceiveAmount);
}
else
{
ReceiveAmount = ReceiveAmount - Convert.ToDecimal(adata.Rows[i]["Due"].ToString());
db.AddParameters("@Amount", Convert.ToDecimal(adata.Rows[i]["Due"].ToString()));
}
db.AddParameters("@AccountId", receivePayment.AccountId.Trim());
db.AddParameters("@CustomerId", receivePayment.CustomerId.Trim());
db.AddParameters("@SalesCenterId", accountOn);//(string)LumexSessionManager.Get("UserSalesCenterId"));
db.AddParameters("@CashCheque", receivePayment.CashCheque.Trim());
//db.AddParameters("@Amount", receivePayment.Amount.Trim());
db.AddParameters("@CurrentReceivable", receivePayment.CurrentReceivable.Trim());
db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString());
db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
db.AddParameters("@Bank", receivePayment.Bank.Trim());
db.AddParameters("@BankBrach", receivePayment.BankBrach.Trim());
db.AddParameters("@ChequeNo", receivePayment.ChequeNo.Trim());
db.AddParameters("@ChequeDate", LumexLibraryManager.ParseAppDate(receivePayment.ChequeDate));
dt = db.ExecuteDataTable("INSERT_CUSTOMER_PAYMENT_BY_RECORD_ID", true);
}
else
{
// break;
}
}
}
else
{
db.ClearParameters();
db.AddParameters("@SalesCenterId", accountOn);
db.AddParameters("@AccountId", receivePayment.AccountId.Trim());
db.AddParameters("@CustomerId", receivePayment.CustomerId.Trim());
// db.AddParameters("@SalesCenterId", (string)LumexSessionManager.Get("UserSalesCenterId"));
db.AddParameters("@CashCheque", receivePayment.CashCheque.Trim());
db.AddParameters("@Amount", receivePayment.Amount.Trim());
db.AddParameters("@CurrentReceivable", receivePayment.CurrentReceivable.Trim());
db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString());
db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
db.AddParameters("@Bank", receivePayment.Bank.Trim());
db.AddParameters("@BankBrach", receivePayment.BankBrach.Trim());
db.AddParameters("@ChequeNo", receivePayment.ChequeNo.Trim());
db.AddParameters("@ChequeDate", LumexLibraryManager.ParseAppDate(receivePayment.ChequeDate));
dt = db.ExecuteDataTable("INSERT_CUSTOMER_PAYMENT", true);
}
return dt;
}
catch (Exception)
{
throw;
}
}
//protected void LoadVendors()
//{
// VendorBLL vendor = new VendorBLL();
// try
// {
// DataTable dt = vendor.GetActiveVendors();
// vendorDropDownList.DataSource = dt;
// vendorDropDownList.DataValueField = "VendorId";
// vendorDropDownList.DataTextField = "VendorName";
// vendorDropDownList.DataBind();
// vendorDropDownList.Items.Insert(0, "");
// vendorDropDownList.SelectedIndex = 0;
// }
// catch (Exception ex)
// {
// msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = ex.Message;
// }
// finally
// {
// vendor = null;
// }
//}
protected void GetPaymentInfo()
{
ReceivePaymentBLL receivePayment = new ReceivePaymentBLL();
PurchaseRecordBLL purchaseRecord = new PurchaseRecordBLL();
try
{
DataTable dtInfo = purchaseRecord.GetPurchaseRecordById(purchaseRecordIdTextBox.Text.Trim());
if (dtInfo.Rows.Count > 0)
{
//salesCenterIdLabel.Text = dtInfo.Rows[0]["SalesCenterId"].ToString();
//salesCenterNameLabel.Text = dtInfo.Rows[0]["SalesCenterName"].ToString();
recordIdLabel.Text = dtInfo.Rows[0]["PurchaseRecordId"].ToString();
recordDateLabel.Text = dtInfo.Rows[0]["RecordDate"].ToString();
vendorIdLabel.Text = dtInfo.Rows[0]["VendorId"].ToString();
vendorNameLabel.Text = dtInfo.Rows[0]["VendorName"].ToString();
warehouseIdLabel.Text = dtInfo.Rows[0]["WarehouseId"].ToString();
warehouseNameLabel.Text = dtInfo.Rows[0]["WarehouseName"].ToString();
//salesCenterIdLabel.Text = dtInfo.Rows[0]["WarehouseId"].ToString();
//salesCenterNameLabel.Text = dtInfo.Rows[0]["WarehouseName"].ToString();
totalAmountLabel.Text = dtInfo.Rows[0]["TotalAmount"].ToString();
//vatLabel.Text = dtInfo.Rows[0]["VAT"].ToString();
transportCostLabel.Text = dtInfo.Rows[0]["TransportCost"].ToString();
totalPayableLabel.Text = dtInfo.Rows[0]["TotalPayable"].ToString();
}
DataTable dt = receivePayment.GetVendorPayments(vendorIdLabel.Text.Trim(), purchaseRecordIdTextBox.Text.Trim(), "PA");
paymentDetailsGridView.DataSource = dt;
paymentDetailsGridView.DataBind();
decimal amt = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["Status"].ToString() == "Approved")
{
amt = amt + decimal.Parse(dt.Rows[i]["Amount"].ToString());
}
}
totalReceivedLabel.Text = amt.ToString();
currentPayableLabel.Text = (decimal.Parse(totalPayableLabel.Text) - decimal.Parse(totalReceivedLabel.Text)).ToString();
if (paymentDetailsGridView.Rows.Count > 0)
{
paymentDetailsGridView.UseAccessibleHeader = true;
paymentDetailsGridView.HeaderRow.TableSection = TableRowSection.TableHeader;
}
}
catch (Exception ex)
{
string message = ex.Message;
if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; }
MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");
}
finally
{
receivePayment = null;
purchaseRecord = null;
}
}
protected void saveButton_Click(object sender, EventArgs e)
{
ReceivePaymentBLL receivePayment = new ReceivePaymentBLL();
try
{
if (decimal.Parse(currentPayableLabel.Text) > 0)
{
receivePayment.PurchaseRecordId = recordIdLabel.Text;
receivePayment.VendorId = vendorIdLabel.Text;
receivePayment.SalesCenterId = "";//salesCenterIdLabel.Text;
receivePayment.Amount = amountTextBox.Text.Trim();
receivePayment.CurrentPayable = currentPayableLabel.Text;
receivePayment.SaveVendorPaymentBySC();
GetPaymentInfo();
string message = "";
MyAlertBox("SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", callbackOk);");
MyAlertBox("alert(\"Saved Successfully.\");");
}
else
{
msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "No Payable to Payment.";
}
}
catch (Exception ex)
{
string message = ex.Message;
if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; }
MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");
}
}
protected void saveButton_Click(object sender, EventArgs e)
{
ReceivePaymentBLL receivePayment = new ReceivePaymentBLL();
DataRow dr = null;
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("RecordDate"));
dt.Columns.Add(new DataColumn("PurchaseRecordId"));
dt.Columns.Add(new DataColumn("SalesCenterName"));
dt.Columns.Add(new DataColumn("TotalAmount"));
dt.Columns.Add(new DataColumn("DiscountAmount"));
dt.Columns.Add(new DataColumn("TotalPayable"));
dt.Columns.Add(new DataColumn("PaidAmount"));
dt.Columns.Add(new DataColumn("Due"));
try
{
if (amountTextBox.Text == "")
{
msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Amount field is required.";
}
else if (paymentModeDropDownList.SelectedValue == "")
{
msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Select Payment field is required.";
}
else if (accountHeadDropDownList.SelectedValue == "")
{
msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Select Account Head field is required.";
}
else if (paymentModeDropDownList.SelectedValue == "Cheque")
{
if (chequeNumberTextBox.Text == "")
{
msgbox.Visible = true;
msgTitleLabel.Text = "Validation!!!";
msgDetailLabel.Text = "Cheque Number field is required.";
}
else if (chequeDateTextBox.Text == "")
{
if (chequeNumberTextBox.Text == "")
{
msgbox.Visible = true;
msgTitleLabel.Text = "Validation!!!";
msgDetailLabel.Text = "Cheque Date field is required.";
}
}
}
else
{
if (decimal.Parse(currentPayableLabel.Text) > 0)
{
if (decimal.Parse(currentPayableLabel.Text) >= decimal.Parse(amountTextBox.Text.Trim()))
{
receivePayment.AccountId = accountHeadDropDownList.SelectedValue.Trim();
receivePayment.VendorId = vendorDropDownList.SelectedValue.Trim();
receivePayment.CashCheque = paymentModeDropDownList.SelectedValue.Trim();
receivePayment.CurrentPayable = currentPayableLabel.Text;
receivePayment.Amount = amountTextBox.Text.Trim();
receivePayment.ChequeNo = chequeNumberTextBox.Text;
receivePayment.ChequeDate = chequeDateTextBox.Text;
receivePayment.Bank = bankDropDownList.Text;
receivePayment.BankBrach = bankBranchTextBox.Text;
for (int i = 0; i < payableListGridView.Rows.Count; i++)
{
CheckBox chkbx = (CheckBox)payableListGridView.Rows[i].FindControl("selectCheckBox");
if (chkbx.Checked)
{
dr = dt.NewRow();
// dr["Barcode"] = productListGridView.Rows[i].Cells[0].Text.ToString();
dr["RecordDate"] = payableListGridView.Rows[i].Cells[0].Text.ToString();
dr["PurchaseRecordId"] = payableListGridView.Rows[i].Cells[1].Text.ToString();
dr["SalesCenterName"] = payableListGridView.Rows[i].Cells[2].Text.ToString();
dr["TotalAmount"] = payableListGridView.Rows[i].Cells[3].Text.ToString();
dr["DiscountAmount"] = payableListGridView.Rows[i].Cells[4].Text.ToString();
dr["TotalPayable"] = payableListGridView.Rows[i].Cells[5].Text.ToString();
dr["PaidAmount"] = payableListGridView.Rows[i].Cells[6].Text.ToString();
dr["Due"] = payableListGridView.Rows[i].Cells[7].Text.ToString();
dt.Rows.Add(dr);
}
}
receivePayment.SaveVendorPayment("", drpdwnSalesCenterOrWarehouse.SelectedValue,dt);
//drpdwnAccountOn.SelectedValue, drpdwnSalesCenterOrWarehouse.SelectedValue);
//string message = "Vendor Payment <span class='actionTopic'>Saved</span> Successfully.";
//MyAlertBox("SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", \"\");");
initializeFields();
string message = "Vendor Payment <span class='actionTopic'>" + receivePayment.Amount +
" Tk Saved</span> Successfully.";
MyAlertBox("SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", \"\");");
GetVendorPayableList();
//MyAlertBox("alert(\"Saved Successfully.\");");
}
else
{
msgbox.Visible = true;
msgTitleLabel.Text = "Exception!!!";
msgDetailLabel.Text = "Amount must be equal or less of Current Payable Amount.";
}
}
else
{
msgbox.Visible = true;
msgTitleLabel.Text = "Exception!!!";
msgDetailLabel.Text = "No Payable to Payment.";
}
}
}
catch (Exception ex)
{
string message = ex.Message;
if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; }
MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");
}
}
protected void GetVendorPayableList()
{
ReceivePaymentBLL receivePayment = new ReceivePaymentBLL();
try
{
if (vendorDropDownList.SelectedValue.Trim() == "")
{
msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Vendor Name field is required.";
}
else
{
DataTable dt = receivePayment.GetVendorPayableList(vendorDropDownList.SelectedValue, "Warehouse", drpdwnSalesCenterOrWarehouse.SelectedValue);
payableListGridView.DataSource = dt;
payableListGridView.DataBind();
if (payableListGridView.Rows.Count > 0)
{
payableListGridView.UseAccessibleHeader = true;
payableListGridView.HeaderRow.TableSection = TableRowSection.TableHeader;
decimal currentPayable = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
currentPayable += decimal.Parse(dt.Rows[i]["Due"].ToString());
}
currentPayableLabel.Text = currentPayable.ToString();
}
else
{
msgbox.Visible = true; msgTitleLabel.Text = "Vendor Payable List Data Not Found!!!"; msgDetailLabel.Text = "";
msgbox.Attributes.Add("class", "alert alert-info");
currentPayableLabel.Text = "0.00";
}
}
}
catch (Exception ex)
{
string message = ex.Message;
if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; }
MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");
}
finally
{
receivePayment = null;
MyAlertBox("MyOverlayStop();");
}
}