protected void GetPurchaseRecordById(string purchaseRecordId)
{
PurchaseRecordBLL purchaseRecord = new PurchaseRecordBLL();
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]["BankName"].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();
}
else
{
msgbox.Visible = true; msgTitleLabel.Text = "Data Not Found!!!"; 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 GetPurchesRecordById(string PurchesRecordId)
{
PurchaseRecordBLL parRecordBll = new PurchaseRecordBLL();
try
{
DataTable dt = parRecordBll.GetPurchaseRecordById(PurchesRecordId);
if (dt.Rows.Count > 0)
{
recordDateLabel.Text = dt.Rows[0]["RecordDate"].ToString();
statusLabel.Text = dt.Rows[0]["Status"].ToString();
//if (string.IsNullOrEmpty(dt.Rows[0]["WarehouseId"].ToString()))
//{
// salesCenterIdLabel.Text = dt.Rows[0]["SalesCenterId"].ToString();
// salesCenterNameLabel.Text = dt.Rows[0]["SalesCenterName"].ToString();
//}
salesCenterIdLabel.Text = dt.Rows[0]["WarehouseId"].ToString();
salesCenterNameLabel.Text = dt.Rows[0]["WarehouseName"].ToString();
salesCenterOrWareHouseIdLabel.Text = "Warehouse Id";
salesCenterOrWareHouseNameLabel.Text = "Warehouse Name";
// salesCenterIdLabel.Text = dt.Rows[0]["WarehouseId"].ToString();
//if (salesCenterIdLabel.Text[0] == 'W')
//{
//}
// salesCenterNameLabel.Text = dt.Rows[0]["WarehouseName"].ToString();
VendorIdLabel.Text = dt.Rows[0]["VendorId"].ToString();
vendorNameLabel.Text = dt.Rows[0]["VendorName"].ToString();
OderDatelabel.Text = dt.Rows[0]["VendorOrderDate"].ToString();
orderNumberLabel.Text = dt.Rows[0]["VendorOrderNumber"].ToString();
invoiceNumberLabel.Text = dt.Rows[0]["VendorInvoiceNumber"].ToString();
receiveDateLabel.Text = dt.Rows[0]["ReceivedDate"].ToString();
// [ReceivedDate]
totalAmountLabel.Text = dt.Rows[0]["TotalAmount"].ToString();
discountAmountLabel.Text = dt.Rows[0]["DiscountAmount"].ToString();
transportCostLabel.Text = dt.Rows[0]["TransportCost"].ToString();
paidAmountLabel.Text = dt.Rows[0]["PaidAmount"].ToString();
//vatPercentageLabel.Text = dt.Rows[0]["VATPercentage"].ToString();
totalpayableLabel.Text = dt.Rows[0]["TotalPayable"].ToString();
NarationLabel.Text = dt.Rows[0]["Narration"].ToString();
salesDueAmountTextBox.Text = (decimal.Parse(totalpayableLabel.Text) - decimal.Parse(paidAmountLabel.Text)).ToString();
}
else
{
msgbox.Visible = true; msgTitleLabel.Text = "Data Not Found!!!"; msgDetailLabel.Text = "";
}
}
catch (Exception ex)
{
string message = "Some things goes wrong on create Sales Return";
if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; }
MyAlertBox("ErrorAlert( \"" + message + "\", \"\");");
}
finally
{
parRecordBll = null;
}
}
//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;
}
}
