protected void GetSalesRecordById(string salesRecordId)
{
SalesOrderBLL salesOrder = new SalesOrderBLL();
try
{
DataTable dt = salesOrder.GetSalesRecordById(salesRecordId);
if (dt.Rows.Count > 0)
{
recordDateLabel.Text = dt.Rows[0]["RecordDate"].ToString();
statusLabel.Text = dt.Rows[0]["Status"].ToString();
salesCenterIdLabel.Text = dt.Rows[0]["SalesCenterId"].ToString();
salesCenterNameLabel.Text = dt.Rows[0]["SalesCenterName"].ToString();
customerIdLabel.Text = dt.Rows[0]["CustomerId"].ToString();
customerNameLabel.Text = dt.Rows[0]["CustomerName"].ToString();
customerContactLabel.Text = dt.Rows[0]["CustomerContactNumber"].ToString();
customerAddressLabel.Text = dt.Rows[0]["CustomerAddress"].ToString();
totalAmountLabel.Text = dt.Rows[0]["TotalAmount"].ToString();
totalVATAmountLabel.Text = dt.Rows[0]["TotalVATAmount"].ToString();
receivedAmountLabel.Text = dt.Rows[0]["ReceivedAmount"].ToString();
discountAmountLabel.Text = dt.Rows[0]["DiscountAmount"].ToString();
vatPercentageLabel.Text = dt.Rows[0]["VATPercentage"].ToString();
totalReceivableLabel.Text = dt.Rows[0]["TotalReceivable"].ToString();
SalesPersonLabel.Text = dt.Rows[0]["SalesPerson"].ToString();
dueAmountLabel.Text = (decimal.Parse(totalReceivableLabel.Text) - decimal.Parse(receivedAmountLabel.Text)).ToString();
divSalesInformation.Visible = true;
divSalesDuePay.Visible = true;
}
else
{
msgbox.Visible = true; msgTitleLabel.Text = "Data Not Found!!!"; msgDetailLabel.Text = "";
divSalesInformation.Visible = false;
divSalesDuePay.Visible = false;
}
}
catch (Exception ex)
{
msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = ex.Message;
}
finally
{
salesOrder = null;
}
}
protected void GetSalesRecordById(string salesRecordId)
{
SalesOrderBLL salesOrder = new SalesOrderBLL();
try
{
DataTable dt = salesOrder.GetSalesRecordById(salesRecordId);
if (dt.Rows.Count > 0)
{
recordDateLabel.Text = dt.Rows[0]["RecordDate"].ToString();
statusLabel.Text = dt.Rows[0]["Status"].ToString();
salesCenterIdLabel.Text = dt.Rows[0]["SalesCenterId"].ToString();
salesCenterNameLabel.Text = dt.Rows[0]["SalesCenterName"].ToString();
customerIdLabel.Text = dt.Rows[0]["CustomerId"].ToString();
customerNameLabel.Text = dt.Rows[0]["CustomerName"].ToString();
customerContactLabel.Text = dt.Rows[0]["CustomerContactNumber"].ToString();
customerAddressLabel.Text = dt.Rows[0]["CustomerAddress"].ToString();
totalAmountLabel.Text = dt.Rows[0]["TotalAmount"].ToString();
totalVATAmountLabel.Text = dt.Rows[0]["TotalVATAmount"].ToString();
receivedAmountLabel.Text = dt.Rows[0]["ReceivedAmount"].ToString();
discountAmountLabel.Text = dt.Rows[0]["DiscountAmount"].ToString();
vatPercentageLabel.Text = dt.Rows[0]["VATPercentage"].ToString();
totalReceivableLabel.Text = dt.Rows[0]["TotalReceivable"].ToString();
salesDueAmountTextBox.Text = (decimal.Parse(totalReceivableLabel.Text) - decimal.Parse(receivedAmountLabel.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
{
salesOrder = null;
}
}
protected void GetSalesRecordById(string salesRecordId)
{
SalesOrderBLL salesOrder = new SalesOrderBLL();
try
{
DataTable dt = salesOrder.GetSalesRecordById(salesRecordId);
decimal changeAmount = 0;
if (dt.Rows.Count > 0 && dt.Rows[0]["Status"].ToString() == "Pending")
{
journalVoucharLavel.Text = dt.Rows[0]["JournalNumber"].ToString();
paymentMethodLavel.Text = dt.Rows[0]["PaymentMode"].ToString();
banklabel.Text = dt.Rows[0]["Bank"].ToString();
bankBranchlabel.Text = dt.Rows[0]["BankBranch"].ToString();
ChequeNumberLavel.Text = dt.Rows[0]["ChequeNumber"].ToString();
ChequeDateLavel.Text = dt.Rows[0]["ChequeDate"].ToString();
salesRecordIdlavel.Text = dt.Rows[0]["SalesRecordId"].ToString();
recordDateLabel.Text = dt.Rows[0]["RecordDate"].ToString();
lblSalesPerson.Text = dt.Rows[0]["SalesPerson"].ToString();
//statusLabel.Text = dt.Rows[0]["Status"].ToString();
salesCenterIdLabel.Text = dt.Rows[0]["SalesCenterId"].ToString();
salesCenterNameLabel.Text = dt.Rows[0]["SalesCenterName"].ToString();
customerIdLabel.Text = dt.Rows[0]["CustomerId"].ToString();
customerNameLabel.Text = dt.Rows[0]["CustomerName"].ToString();
customerContactLabel.Text = dt.Rows[0]["CustomerContactNumber"].ToString();
customerAddressLabel.Text = dt.Rows[0]["CustomerAddress"].ToString();
totalAmountTextBox.Text = dt.Rows[0]["TotalAmount"].ToString();
//vatTextBox.Text = dt.Rows[0]["TotalVATAmount"].ToString();
receivedAmountTextBox.Text = dt.Rows[0]["ReceivedAmount"].ToString();
discountTextBox.Text = dt.Rows[0]["DiscountAmount"].ToString();
vatTextBox.Text = dt.Rows[0]["VATPercentage"].ToString();
receivableAmountTextBox.Text = dt.Rows[0]["TotalReceivable"].ToString();
txtbxNarration.Text = dt.Rows[0]["Narration"].ToString();
txtbxDescription.Text = dt.Rows[0]["OthersDes"].ToString();
txtbxOthersAmount.Text = dt.Rows[0]["OthersAmount"].ToString();
changeAmountTextBox.Text =
(Convert.ToDecimal(dt.Rows[0]["ReceivedAmount"].ToString()) -
Convert.ToDecimal(dt.Rows[0]["TotalReceivable"].ToString())).ToString();
accountIdLabel.Text = dt.Rows[0]["AccountId"].ToString();
}
else
{
LumexSessionManager.Remove("SalesRecordIdForUpdate");
Response.Redirect(Request.UrlReferrer.ToString());
msgbox.Visible = true; msgTitleLabel.Text = "Data Not Found!!!"; msgDetailLabel.Text = "";
}
}
catch (Exception ex)
{
msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = ex.Message;
}
finally
{
salesOrder = null;
}
}
protected void GetSalesRecordById(string salesRecordId)
{
SalesOrderBLL salesOrder = new SalesOrderBLL();
try
{
DataTable dt = salesOrder.GetSalesRecordById(salesRecordId);
if (dt.Rows.Count > 0)
{
journalVoucharLavel.Text = dt.Rows[0]["JournalNumber"].ToString();
paymentMethodLavel.Text = dt.Rows[0]["PaymentMode"].ToString();
banklabel.Text = dt.Rows[0]["Bank"].ToString();
bankBranchlabel.Text = dt.Rows[0]["BankBranch"].ToString();
ChequeNumberLavel.Text = dt.Rows[0]["ChequeNumber"].ToString();
ChequeDateLavel.Text = dt.Rows[0]["ChequeDate"].ToString();
salesRecordIdlavel.Text = dt.Rows[0]["SalesRecordId"].ToString();
recordDateLabel.Text = dt.Rows[0]["RecordDate"].ToString();
lblSalesPerson.Text = dt.Rows[0]["SalesPerson"].ToString();
statusLabel.Text = dt.Rows[0]["Status"].ToString();
salesCenterIdLabel.Text = dt.Rows[0]["SalesCenterId"].ToString();
salesCenterNameLabel.Text = dt.Rows[0]["SalesCenterName"].ToString();
customerIdLabel.Text = dt.Rows[0]["CustomerId"].ToString();
customerNameLabel.Text = dt.Rows[0]["CustomerName"].ToString();
customerContactLabel.Text = dt.Rows[0]["CustomerContactNumber"].ToString();
customerAddressLabel.Text = dt.Rows[0]["CustomerAddress"].ToString();
totalAmountLabel.Text = dt.Rows[0]["TotalAmount"].ToString();
totalVATAmountLabel.Text = dt.Rows[0]["TotalVATAmount"].ToString();
receivedAmountLabel.Text = dt.Rows[0]["ReceivedAmount"].ToString();
discountAmountLabel.Text = dt.Rows[0]["DiscountAmount"].ToString();
vatPercentageLabel.Text = dt.Rows[0]["VATPercentage"].ToString();
totalReceivableLabel.Text = dt.Rows[0]["TotalReceivable"].ToString();
lblNaration.Text = dt.Rows[0]["Narration"].ToString();
lblOthersDescription.Text = dt.Rows[0]["OthersDes"].ToString();
lblOthersAmount.Text = dt.Rows[0]["OthersAmount"].ToString();
if (statusLabel.Text != "Pending")
{
btnAccept.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
{
salesOrder = null;
}
}
