protected void GetSalesReturnProductListById(string salesReturnId)
{
SalesOrderBLL salesOrder = new SalesOrderBLL();
try
{
DataTable dt = salesOrder.GetSalesReturnProductListById(salesReturnId);
if (dt.Rows.Count > 0)
{
salesReturnProductListGridView.DataSource = dt;
salesReturnProductListGridView.DataBind();
if (salesReturnProductListGridView.Rows.Count > 0)
{
salesReturnProductListGridView.UseAccessibleHeader = true;
salesReturnProductListGridView.HeaderRow.TableSection = TableRowSection.TableHeader;
}
}
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
{
salesOrder = null;
}
}
protected void GetSalesRecordProductListById(string salesRecordId)
{
SalesOrderBLL salesOrder = new SalesOrderBLL();
try
{
DataTable dt = salesOrder.GetSalesRecordProductListById(salesRecordId);
if (dt.Rows.Count > 0)
{
salesRecordProductListGridView.DataSource = dt;
salesRecordProductListGridView.DataBind();
if (salesRecordProductListGridView.Rows.Count > 0)
{
salesRecordProductListGridView.UseAccessibleHeader = true;
salesRecordProductListGridView.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
{
salesOrder = null;
}
}
protected void GetSalesOrderList()
{
SalesOrderBLL salesOrder = new SalesOrderBLL();
try
{
DataTable dt = salesOrder.GetSalesOrdersListBySalesCenterAndStatus(salesCenterDropDownList.SelectedValue.Trim(), "OT");
pendingSalesOrderListGridView.DataSource = dt;
pendingSalesOrderListGridView.DataBind();
if (pendingSalesOrderListGridView.Rows.Count > 0)
{
pendingSalesOrderListGridView.UseAccessibleHeader = true;
pendingSalesOrderListGridView.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
{
salesOrder = null;
}
}
protected void GetSalesOrderById(string salesOrderId)
{
SalesOrderBLL salesOrder = new SalesOrderBLL();
try
{
DataTable dt = salesOrder.GetSalesOrderById(salesOrderId);
if (dt.Rows.Count > 0)
{
orderIdLabel.Text = dt.Rows[0]["SalesOrderId"].ToString();
orderDateLabel.Text = dt.Rows[0]["OrderDate"].ToString();
salesPersonIdLabel.Text = dt.Rows[0]["SalesPersonId"].ToString();
salesPersonNameLabel.Text = dt.Rows[0]["SalesPersonName"].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();
customerContactNumberLabel.Text = dt.Rows[0]["CustomerContactNumber"].ToString();
customerAddressLabel.Text = dt.Rows[0]["CustomerAddress"].ToString();
narrationLabel.Text = dt.Rows[0]["Narration"].ToString();
statusLabel.Text = dt.Rows[0]["Status"].ToString();
transportTypeLabel.Text = dt.Rows[0]["TransportType"].ToString();
shippingAddressLabel.Text = dt.Rows[0]["ShippingAddress"].ToString();
billingAddressLabel.Text = dt.Rows[0]["BillingAddress"].ToString();
paymentModeLabel.Text = dt.Rows[0]["PaymentMode"].ToString();
chequeNumberLabel.Text = dt.Rows[0]["ChequeNumber"].ToString();
chequeDateLabel.Text = dt.Rows[0]["ChequeDate"].ToString();
bankLabel.Text = dt.Rows[0]["Bank"].ToString();
bankBranchLabel.Text = dt.Rows[0]["BankBranch"].ToString();
deliveryDateLabel.Text = dt.Rows[0]["DeliveryDate"].ToString();
lcNumberLabel.Text = dt.Rows[0]["LCNumber"].ToString();
transportDateLabel.Text = dt.Rows[0]["TransportDate"].ToString();
totalAmountLabel.Text = dt.Rows[0]["TotalAmount"].ToString();
vatLabel.Text = dt.Rows[0]["VAT"].ToString();
totalReceivableLabel.Text = dt.Rows[0]["TotalReceivable"].ToString();
receivedAmountLabel.Text = dt.Rows[0]["ReceivedAmount"].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
{
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();
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 GetDamageRecordById(string damageRecordId)
{
SalesOrderBLL salesOrder = new SalesOrderBLL();
try
{
DataTable dt = salesOrder.GetDamageRecordById(damageRecordId);
if (dt.Rows.Count > 0)
{
recordIdLabel.Text = dt.Rows[0]["DamageRecordId"].ToString();
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();
totalAmountLabel.Text = dt.Rows[0]["TotalAmount"].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
{
salesOrder = null;
}
}
protected void GetSalesReturnById(string salesReturnId)
{
SalesOrderBLL salesOrder = new SalesOrderBLL();
try
{
DataTable dt = salesOrder.GetSalesReturnById(salesReturnId);
if (dt.Rows.Count > 0)
{
returnIdLabel.Text = dt.Rows[0]["SalesReturnId"].ToString();
returnDateLabel.Text = dt.Rows[0]["ReturnDate"].ToString();
salesRecordIdLabel.Text = dt.Rows[0]["SalesRecordId"].ToString();
returnAmountLabel.Text = dt.Rows[0]["ReturnAmount"].ToString();
returnVATAmountLabel.Text = dt.Rows[0]["ReturnVATAmount"].ToString();
dueAmountLabel.Text = dt.Rows[0]["SalesDueAmount"].ToString();
statusLabel.Text = dt.Rows[0]["Status"].ToString();
salesCenterIdLabel.Text = dt.Rows[0]["SalesCenterId"].ToString();
salesCenterNameLabel.Text = dt.Rows[0]["SalesCenterName"].ToString();
AdjustedAmountLabel.Text = dt.Rows[0]["AdjustedAmount"].ToString();
SalesPersonLabel.Text = dt.Rows[0]["CreatedBy"].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
{
salesOrder = null;
}
}
protected void setOnTransportLinkButton_Click(object sender, EventArgs e)
{
SalesOrderBLL salesOrder = new SalesOrderBLL();
try
{
LinkButton lnkBtn = (LinkButton)sender;
GridViewRow row = (GridViewRow)lnkBtn.NamingContainer;
salesOrder.UpdateSalesOrderOnTransport(pendingSalesOrderListGridView.Rows[row.RowIndex].Cells[0].Text.ToString());
MyAlertBox("alert(\"Sales Order Updated Successfully.\"); window.location=\"/UI/SalesOrder/GetSalesOrderOnTransport.aspx\"");
}
catch (Exception ex)
{
msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = ex.Message;
}
finally
{
salesOrder = null;
}
}
internal string ApproveSalesRecordRetailSubproducs(SalesOrderBLL salesOrder, DataTable dt, LumexDBPlayer db)
{
string salesRecordId = "";
try
{
for (int i = 0; i < dt.Rows.Count; i++)
{
db.ClearParameters();
db.AddParameters("@SalesCenterId", salesOrder.SalesCenterId.Trim());
db.AddParameters("@SalesRecordId", salesOrder.SalesRecordId.Trim());
db.AddParameters("@ProductId", dt.Rows[i]["MainProductId"].ToString());
db.AddParameters("@RatePerUnit", dt.Rows[i]["RatePerUnit"].ToString());
db.AddParameters("@Quantity", dt.Rows[i]["Quantity"].ToString());
db.AddParameters("@Amount", (Convert.ToDecimal(dt.Rows[i]["RatePerUnit"].ToString()) * Convert.ToDecimal(dt.Rows[i]["Quantity"].ToString())).ToString());
db.AddParameters("@VATPercentage", "0");
db.AddParameters("@Height", "0");
db.AddParameters("@Width", "0");
db.AddParameters("@OnSale", "No");
db.AddParameters("@OrderUnit", "0");
db.AddParameters("@TotalUit", "0");
db.AddParameters("@Description", "");
db.ExecuteNonQuery("INSERT_RETAIL_SALES_RECORD_PRODUCT", true);
}
db.ClearParameters();
db.AddParameters("@SalesRecordId", salesOrder.SalesRecordId.Trim());
db.AddParameters("@SalesCenterId", salesOrder.SalesCenterId.Trim());
db.AddParameters("@ModifiedBy", LumexSessionManager.Get("ActiveUserId").ToString());
db.AddParameters("@ModifiedFrom", LumexLibraryManager.GetTerminal());
db.ExecuteNonQuery("UPDATE_PRODUCT_STOCK_FOR_RETAIL_SALES", true);
db.ClearParameters();
db.AddParameters("@SalesRecordId", salesOrder.SalesRecordId.Trim());
db.AddParameters("@SalesCenterId", salesOrder.SalesCenterId.Trim());
db.AddParameters("@JournalNumber", salesOrder.JournalNumber.Trim());
db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString());
db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
db.ExecuteNonQuery("[INSERT_RETAIL_SALES_RECEIVE_PAYMENT_LEDGER_TRANSACTION_FOR_APPROVE_RETAIL_CGS_SUBP]", true);
return salesRecordId = salesOrder.SalesRecordId.Trim();
}
catch (Exception)
{
throw;
}
finally
{
salesOrder = null;
dt = null;
}
}
internal string ApproveSalesOrder(SalesOrderBLL salesOrder, DataTable dtPrdList, LumexDBPlayer db)
{
string salesRecordId = "";
try
{
db.AddParameters("@TotalAmount", salesOrder.TotalAmount.Trim());
db.AddParameters("@DiscountAmount", salesOrder.DiscountAmount.Trim());
db.AddParameters("@VAT", salesOrder.VAT.Trim());
db.AddParameters("@TotalReceivable", salesOrder.TotalReceivable.Trim());
db.AddParameters("@ReceivedAmount", salesOrder.ReceivedAmount.Trim());
db.AddParameters("@ChangeAmount", salesOrder.ChangeAmount.Trim());
db.AddParameters("@PaymentMode", salesOrder.PaymentMode.Trim());
db.AddParameters("@TotalVATAmount", salesOrder.TotalVATAmount.Trim());
db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString());
db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
db.AddParameters("@SalesOrderId", salesOrder.SalesOrderId.Trim());
DataTable dt = db.ExecuteDataTable("INSERT_SALES_RECORD_BY_APPROVE_SALES_ORDER", true);
if (dt.Rows.Count > 0)
{
salesRecordId = dt.Rows[0][0].ToString();
}
for (int i = 0; i < dtPrdList.Rows.Count; i++)
{
db.ClearParameters();
db.AddParameters("@SalesCenterId", salesOrder.SalesCenterId.Trim());
db.AddParameters("@SalesRecordId", salesRecordId.Trim());
db.AddParameters("@ProductId", dtPrdList.Rows[i]["ProductId"].ToString());
db.AddParameters("@RatePerUnit", dtPrdList.Rows[i]["RatePerUnit"].ToString());
db.AddParameters("@Quantity", dtPrdList.Rows[i]["Quantity"].ToString());
db.AddParameters("@Amount", dtPrdList.Rows[i]["Amount"].ToString());
db.AddParameters("@VATPercentage", dtPrdList.Rows[i]["VATPercentage"].ToString());
//need to add this 3 paremeters
db.AddParameters("@Height", dtPrdList.Rows[i]["Height"].ToString());
db.AddParameters("@Running", dtPrdList.Rows[i]["Running"].ToString());
db.AddParameters("@OnSale", dtPrdList.Rows[i]["OnSale"].ToString());
db.ExecuteNonQuery("INSERT_RETAIL_SALES_RECORD_PRODUCT", true);
}
db.ClearParameters();
db.AddParameters("@SalesRecordId", salesRecordId.Trim());
db.AddParameters("@SalesCenterId", salesOrder.SalesCenterId.Trim());
db.AddParameters("@ModifiedBy", LumexSessionManager.Get("ActiveUserId").ToString());
db.AddParameters("@ModifiedFrom", LumexLibraryManager.GetTerminal());
db.ExecuteNonQuery("UPDATE_PRODUCT_STOCK_FOR_RETAIL_SALES", true);
db.ClearParameters();
db.AddParameters("@SalesRecordId", salesRecordId.Trim());
db.AddParameters("@SalesCenterId", salesOrder.SalesCenterId.Trim());
db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString());
db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
db.ExecuteNonQuery("INSERT_RETAIL_SALES_RECEIVE_PAYMENT_LEDGER_TRANSACTION", true);
return salesRecordId;
}
catch (Exception)
{
throw;
}
finally
{
salesOrder = null;
dtPrdList = null;
}
}
public DataTable SaveSalesReturn(SalesOrderBLL salesOrder, DataTable dtPrdList, LumexDBPlayer db)
{
string salesReturnId = "";
try
{
db.AddParameters("@SalesRecordId", salesOrder.SalesRecordId.Trim());
db.AddParameters("@ReturnAmount", salesOrder.ReturnAmount.Trim());
db.AddParameters("@ReturnVATAmount", salesOrder.ReturnVATAmount.Trim());
db.AddParameters("@SalesDueAmount", salesOrder.SalesDueAmount.Trim());
db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString());
db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
DataTable dt = db.ExecuteDataTable("INSERT_SALES_RETURN_RECORD", true);
if (dt.Rows.Count > 0)
{
salesReturnId = dt.Rows[0][0].ToString();
}
for (int i = 0; i < dtPrdList.Rows.Count; i++)
{
db.ClearParameters();
db.AddParameters("@PurchaseRecordId", dtPrdList.Rows[i]["PurchaseRecordId"].ToString());
db.AddParameters("@SalesRecordId", salesOrder.SalesRecordId.Trim());
db.AddParameters("@SalesReturnId", salesReturnId);
db.AddParameters("@ProductId", dtPrdList.Rows[i]["ProductId"].ToString());
if (dtPrdList.Rows[i]["PurchaseRate"].ToString() == "")
{
db.AddParameters("@PurchaseRate", "0");
}
else
{
db.AddParameters("@PurchaseRate", dtPrdList.Rows[i]["PurchaseRate"].ToString());
}
db.AddParameters("@RatePerUnit", dtPrdList.Rows[i]["RatePerUnit"].ToString());
db.AddParameters("@ReturnQuantity", dtPrdList.Rows[i]["ReturnQuantity"].ToString());
db.AddParameters("@ReturnAmount", dtPrdList.Rows[i]["ReturnAmount"].ToString());
db.AddParameters("@VATPercentage", dtPrdList.Rows[i]["VATPercentage"].ToString());
db.ExecuteNonQuery("INSERT_SALES_RETURN_RECORD_PRODUCT", true);
}
db.ClearParameters();
db.AddParameters("@SalesCenterId", salesOrder.SalesCenterId.Trim());
db.AddParameters("@SalesReturnId", salesReturnId.Trim());
db.AddParameters("@ModifiedBy", LumexSessionManager.Get("ActiveUserId").ToString());
db.AddParameters("@ModifiedFrom", LumexLibraryManager.GetTerminal());
db.ExecuteNonQuery("UPDATE_PRODUCT_STOCK_FOR_SALES_RETURN", true);
db.ClearParameters();
db.AddParameters("@SalesRecordId", salesOrder.SalesRecordId.Trim());
db.AddParameters("@SalesCenterId", salesOrder.SalesCenterId.Trim());
db.AddParameters("@SalesReturnId", salesReturnId.Trim());
db.AddParameters("@SalesDueAmount", salesOrder.SalesDueAmount.Trim());
db.AddParameters("@ReturnAmount", salesOrder.ReturnAmount.Trim());
db.AddParameters("@CustomerId", salesOrder.CustomerId.Trim());
db.AddParameters("@IsDueAdjust", salesOrder.IsDuesAdjustforSalesReturn);
db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString());
db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
dt = db.ExecuteDataTable("INSERT_SALES_RETURN_RECEIVE_PAYMENT_LEDGER_TRANSACTION", true);
return dt;
}
catch (Exception)
{
throw;
}
finally
{
salesOrder = null;
dtPrdList = null;
}
}
public DataTable SaveCustomerPaymentBySales(SalesOrderBLL salesOrder, LumexDBPlayer db)
{
try
{
db.AddParameters("@SalesRecordId", salesOrder.SalesRecordId.Trim());
db.AddParameters("@SalesCenterId", salesOrder.SalesCenterId.Trim());
db.AddParameters("@CustomerId", salesOrder.CustomerId.Trim());
db.AddParameters("@Amount", salesOrder.Amount.Trim());
db.AddParameters("@Due", salesOrder.Due.Trim());
db.AddParameters("@ApprovedBy", LumexSessionManager.Get("ActiveUserId").ToString());
db.AddParameters("@ApprovedFrom", LumexLibraryManager.GetTerminal());
DataTable dt = db.ExecuteDataTable("INSERT_CUSTOMER_PAYMENT_SALES_WISE", true);
return dt;
}
catch (Exception)
{
throw;
}
}
protected void GetSalesRecordProductListByIdForReturn(string salesRecordId)
{
SalesOrderBLL salesOrder = new SalesOrderBLL();
try
{
DataTable dt = salesOrder.GetSalesRecordProductListByIdForReturn(salesRecordId);
if (dt.Rows.Count > 0)
{
dt.Columns.Add("ReturnQuantity");
dt.Columns.Add("ReturnAmount");
dt.AcceptChanges();
salesRecordProductListGridView.DataSource = dt;
salesRecordProductListGridView.DataBind();
LumexSessionManager.Add("RPLdt", dt);
for (int i = 0; i < salesRecordProductListGridView.Rows.Count; i++)
{
if (salesRecordProductListGridView.Rows[i].Cells[2].Text.Trim() == salesRecordProductListGridView.Rows[i].Cells[6].Text.Trim())
{
TextBox returnQuantityTextBox = (TextBox)salesRecordProductListGridView.Rows[i].FindControl("returnQuantityTextBox");
returnQuantityTextBox.Enabled = false;
}
}
if (salesRecordProductListGridView.Rows.Count > 0)
{
salesRecordProductListGridView.UseAccessibleHeader = true;
salesRecordProductListGridView.HeaderRow.TableSection = TableRowSection.TableHeader;
}
}
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 saveButton_Click(object sender, EventArgs e)
{
string msg = string.Empty;
SalesOrderBLL salesOrder = new SalesOrderBLL();
DataTable dtPrdList = new DataTable();
DataRow dr = null;
decimal quantity = 0;
double rate = 0;
double amount = 0;
TextBox orderQuantityTextBox;
TextBox ratePerUnitTextBox;
TextBox amountTextBox;
int i = 0;
dtPrdList.Columns.Add("ProductId");
dtPrdList.Columns.Add("Available");
dtPrdList.Columns.Add("Quantity");
dtPrdList.Columns.Add("RatePerUnit");
dtPrdList.Columns.Add("VATPercentage");
dtPrdList.Columns.Add("Amount");
//dtPrdList.Columns.Add("Height");
//dtPrdList.Columns.Add("Width");
try
{
if (totalAmountTextBox.Text.Trim() == "")
{
msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Total Amount field is required.";
return;
}
else if (vatTextBox.Text.Trim() == "")
{
msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "VAT field is required.";
return;
}
else if (receivedAmountTextBox.Text.Trim() == "")
{
msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Received Amount field is required.";
return;
}
else if (customerIdDropDownList.SelectedValue == "")
{
msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Customer ID field is required.";
return;
}
else if (customerIdDropDownList.SelectedValue == "Retail" && customerNameTextBox.Text.Trim() == "")
{
msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Customer Name field is required.";
return;
}
else if (customerIdDropDownList.SelectedValue == "Retail" && customerContactNumberTextBox.Text.Trim() == "")
{
msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Customer Contact Number field is required.";
return;
}
else if (customerIdDropDownList.SelectedValue == "Retail" && customerAddressTextBox.Text.Trim() == "")
{
msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Customer Address 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;
}
}
for (i = 0; i < selectedProductListGridView.Rows.Count; i++)
{
orderQuantityTextBox = (TextBox)selectedProductListGridView.Rows[i].FindControl("orderQuantityTextBox");
ratePerUnitTextBox = (TextBox)selectedProductListGridView.Rows[i].FindControl("ratePerUnitTextBox");
amountTextBox = (TextBox)selectedProductListGridView.Rows[i].FindControl("amountTextBox");
if (string.IsNullOrEmpty(orderQuantityTextBox.Text.Trim()) || !decimal.TryParse(orderQuantityTextBox.Text.Trim(), out quantity))
{
msg = "Product ID [" + selectedProductListGridView.Rows[i].Cells[0].Text.ToString() + "] has no valid quantity.";
msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = msg;
return;
}
else if (string.IsNullOrEmpty(ratePerUnitTextBox.Text.Trim()) || !double.TryParse(ratePerUnitTextBox.Text.Trim(), out rate))
{
msg = "Product ID [" + selectedProductListGridView.Rows[i].Cells[0].Text.ToString() + "] has no valid rate.";
msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = msg;
return;
}
else if (string.IsNullOrEmpty(amountTextBox.Text.Trim()) || !double.TryParse(amountTextBox.Text.Trim(), out amount))
{
msg = "Product ID [" + selectedProductListGridView.Rows[i].Cells[0].Text.ToString() + "] has no valid amount.";
msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = msg;
return;
}
else
{
dr = dtPrdList.NewRow();
dr["ProductId"] = selectedProductListGridView.Rows[i].Cells[1].Text.ToString();
dr["Available"] = selectedProductListGridView.Rows[i].Cells[4].Text.ToString();
dr["Quantity"] = quantity.ToString();
dr["RatePerUnit"] = rate.ToString();
dr["VATPercentage"] = selectedProductListGridView.Rows[i].Cells[7].Text.ToString();
dr["Amount"] = amount.ToString();
//dr["Height"] = "0.00";
//dr["Width"] = "0.00";
dtPrdList.Rows.Add(dr);
}
}
salesOrder.SalesCenterId = ddlSelectWareHouseOrSalesCenter.SelectedValue;
salesOrder.CustomerId = customerIdDropDownList.SelectedValue.Trim();
salesOrder.CustomerName = customerNameTextBox.Text.Trim();
salesOrder.CustomerContactNumber = customerContactNumberTextBox.Text.Trim();
salesOrder.CustomerAddress = customerAddressTextBox.Text.Trim();
salesOrder.SalesCenterId = ddlSelectWareHouseOrSalesCenter.SelectedValue;
salesOrder.SalesPersonId = LumexSessionManager.Get("ActiveUserId").ToString();
salesOrder.DeliveryDate = LumexLibraryManager.ParseAppDate(deliveryDateTextBox.Text.Trim());
salesOrder.Narration = txtNaration.Text.Trim();
salesOrder.TransportType = transportTypeDropDownList.SelectedValue.Trim();
salesOrder.PaymentMode = paymentModeDropDownList.SelectedValue;
salesOrder.AccountId = accountHeadDropDownList.SelectedValue;
salesOrder.Bank = bankDropDownList.Text.Trim();
salesOrder.BankBranch = bankBranchTextBox.Text.Trim();
salesOrder.ChequeNumber = chequeNumberTextBox.Text.Trim();
salesOrder.ChequeDate = LumexLibraryManager.ParseAppDate(chequeDateTextBox.Text.Trim());
salesOrder.LCNumber = lcNumberTextBox.Text.Trim();
salesOrder.ShippingAddress = shippingAddressTextBox.Text.Trim();
salesOrder.BillingAddress = billingAddressTextBox.Text.Trim();
salesOrder.TotalAmount = totalAmountTextBox.Text.Trim();
salesOrder.DiscountAmount = discountTextBox.Text.Trim();
salesOrder.VAT = vatTextBox.Text.Trim();
salesOrder.TotalReceivable = receivableAmountTextBox.Text.Trim();
salesOrder.Due = DuesAmoutPayTextBox.Text;
salesOrder.ReceivedAmount = receivedAmountTextBox.Text.Trim();
salesOrder.ChangeAmount = (Convert.ToDecimal(salesOrder.ReceivedAmount) - Convert.ToDecimal(salesOrder.TotalReceivable)).ToString();
// salesOrder.ChangeAmount = changeAmountTextBox.Text.Trim();
//salesOrder.TotalVATAmount = CalculateTotalVATAmount().ToString();
salesOrder.TotalVATAmount = totalVATAmountHiddenField.Value;
if (dtPrdList.Rows.Count == selectedProductListGridView.Rows.Count)
{
string salesRecordId = salesOrder.SaveSalesOrder(dtPrdList);
string message = "Product's <span class='actionTopic'>Sales</span> Successfully with Sale ID: <span class='actionTopic'>" +
salesRecordId + "</span>.";
MyAlertBox("var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/SalesOrder/CreateSalesOrder.aspx\"; }; SuccessAlert(\"" +
"Process Succeed" + "\", \"" + message + "\", callbackOk);");
}
//MyAlertBox("alert(\"Retail Sales Created Successfully with Sales ID: " + salesRecordId.Trim() + " \"); window.location=\"/UI/Sales/RetailSalesList.aspx\"");
//Response.Redirect("/UI/Sales/RetailSalesList.aspx", false);
// }
}
catch (Exception ex)
{
string message = ex.Message;
if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; }
MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");
}
finally
{
salesOrder = null;
dtPrdList = 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;
}
}
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 btnAccept_Click(object sender, EventArgs e)
{
try
{
string msg = string.Empty;
SalesOrderBLL salesOrder = new SalesOrderBLL();
DataTable dt = new DataTable();
DataRow dr = null;
//dt.Columns.Add(new DataColumn("Barcode"));
dt.Columns.Add(new DataColumn("MainProductId"));
dt.Columns.Add(new DataColumn("MainProductName"));
dt.Columns.Add(new DataColumn("MainPUnit"));
dt.Columns.Add(new DataColumn("ProductName"));
dt.Columns.Add(new DataColumn("Quantity"));
dt.Columns.Add(new DataColumn("RatePerUnit"));
for (int i = 0; i < selectedProductListGridView.Rows.Count; i++)
{
dr = dt.NewRow();
//dr["Barcode"] = selectedProductListGridView.Rows[i].Cells[0].Text.ToString();
dr["MainProductId"] = selectedProductListGridView.Rows[i].Cells[0].Text.ToString();
dr["MainProductName"] = selectedProductListGridView.Rows[i].Cells[1].Text.ToString();
dr["MainPUnit"] = selectedProductListGridView.Rows[i].Cells[2].Text.ToString();
dr["ProductName"] = selectedProductListGridView.Rows[i].Cells[3].Text.ToString();
dr["RatePerUnit"] = selectedProductListGridView.Rows[i].Cells[5].Text.ToString();
TextBox orderQuantityTextBox =
(TextBox)selectedProductListGridView.Rows[i].FindControl("orderQuantityTextBox");
dr["Quantity"] = orderQuantityTextBox.Text.Trim();
dt.Rows.Add(dr);
}
if (totalAmountLabel.Text.Trim() == "")
{
msgbox.Visible = true;
msgTitleLabel.Text = "Warning!!!";
msgDetailLabel.Text = "Total Amount field is required.";
return;
}
//else if (vatLabel.Text.Trim() == "")
//{
// msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "VAT field is required.";
// return;
//}
else if (totalReceivableLabel.Text.Trim() == "")
{
msgbox.Visible = true;
msgTitleLabel.Text = "Warning!!!";
msgDetailLabel.Text = "Total Receivable field is required.";
return;
}
//if (string.IsNullOrEmpty(vatLabel.Text))
//{
// vatLabel.Text = "0";
//}
salesOrder.SalesRecordId = salesRecordIdlavel.Text;
salesOrder.RecordDate = recordDateLabel.Text;
salesOrder.JournalNumber = journalVoucharLavel.Text;
salesOrder.SalesCenterId = salesCenterIdLabel.Text;
//if (dt.Rows.Count == selectedProductListGridView.Rows.Count)
//{
string salesRecordId = salesOrder.ApproveSalesRecordRetailSubproducs(dt);
// salesOrder.UpdateSalesOrderOnApproved(salesRecordId, salesOrder.SalesOrderId);
if (!string.IsNullOrEmpty(salesRecordId))
{
string message =
"Product's <span class='actionTopic'>Sales Recorded</span> Successfully with Sale ID: <span class='actionTopic'>" +
salesRecordId + "</span>.";
MyAlertBox(
"var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/Sales/RetailSalesList.aspx\"; }; SuccessAlert(\"" +
"Process Succeed" + "\", \"" + message + "\", callbackOk);");
}
else
{
string message =
"Product's <span class='actionTopic'>Sales Recorded</span> Update Failed" +
salesRecordId + "</span>.";
MyAlertBox(
"var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/Sales/RetailSalesList.aspx\"; }; SuccessAlert(\"" +
"Process Succeed" + "\", \"" + message + "\", callbackOk);");
}
//}
}
catch (Exception ex)
{
string message = ex.Message;
if (ex.InnerException != null)
{
message += " --> " + ex.InnerException.Message;
}
MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");
}
finally
{
//salesOrder = null;
//dtPrdList = null;
}
}
protected void btnUpdate_OnClick(object sender, EventArgs e)
{
string msg = string.Empty;
SalesOrderBLL salesOrder = new SalesOrderBLL();
DataTable dtPrdList = new DataTable();
DataRow dr = null;
decimal quantity = 0;
double rate = 0;
double amount = 0;
TextBox orderQuantityTextBox;
TextBox ratePerUnitTextBox;
TextBox amountTextBox;
TextBox heighTextBox;
TextBox widthTextBox;
TextBox UnitTextBox;
TextBox totalUnitTextBox;
Label vatLabel;
Label SerialLabel;
int i = 0;
dtPrdList.Columns.Add(new DataColumn("ProductId"));
dtPrdList.Columns.Add(new DataColumn("Height"));
dtPrdList.Columns.Add(new DataColumn("Width"));
dtPrdList.Columns.Add(new DataColumn("OrderUnit"));
dtPrdList.Columns.Add(new DataColumn("TotalUnit"));
dtPrdList.Columns.Add(new DataColumn("OrderQuantity"));
dtPrdList.Columns.Add(new DataColumn("Quantity"));
dtPrdList.Columns.Add(new DataColumn("RatePerUnit"));
dtPrdList.Columns.Add(new DataColumn("VATPercentage"));
dtPrdList.Columns.Add(new DataColumn("Amount"));
dtPrdList.Columns.Add(new DataColumn("Serial"));
try
{
for (i = 0; i < selectedProductListGridView.Rows.Count; i++)
{
//double availAbleQuantity = Convert.ToDouble(selectedProductListGridView.Rows[i].Cells[3].Text.ToString());
heighTextBox = (TextBox)selectedProductListGridView.Rows[i].FindControl("heightTextBox");
widthTextBox = (TextBox)selectedProductListGridView.Rows[i].FindControl("WidthTextBox");
UnitTextBox = (TextBox)selectedProductListGridView.Rows[i].FindControl("UnitTextBox");
totalUnitTextBox = (TextBox)selectedProductListGridView.Rows[i].FindControl("totalUnitTextBox");
orderQuantityTextBox = (TextBox)selectedProductListGridView.Rows[i].FindControl("orderQuantityTextBox");
ratePerUnitTextBox = (TextBox)selectedProductListGridView.Rows[i].FindControl("ratePerUnitTextBox");
amountTextBox = (TextBox)selectedProductListGridView.Rows[i].FindControl("amountTextBox");
vatLabel = (Label)selectedProductListGridView.Rows[i].FindControl("lblVatparcentage");
SerialLabel = (Label)selectedProductListGridView.Rows[i].FindControl("SerialLabel");
if (string.IsNullOrEmpty(orderQuantityTextBox.Text.Trim()) || !decimal.TryParse(orderQuantityTextBox.Text.Trim(), out quantity))
{
msg = "Product ID [" + selectedProductListGridView.Rows[i].Cells[0].Text.ToString() + "] has no valid quantity.";
msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = msg;
return;
}
else if (string.IsNullOrEmpty(ratePerUnitTextBox.Text.Trim()) || !double.TryParse(ratePerUnitTextBox.Text.Trim(), out rate))
{
msg = "Product ID [" + selectedProductListGridView.Rows[i].Cells[0].Text.ToString() + "] has no valid rate.";
msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = msg;
return;
}
else if (string.IsNullOrEmpty(amountTextBox.Text.Trim()) || !double.TryParse(amountTextBox.Text.Trim(), out amount))
{
msg = "Product ID [" + selectedProductListGridView.Rows[i].Cells[0].Text.ToString() + "] has no valid amount.";
msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = msg;
return;
}
//else if (Convert.ToDouble(orderQuantityTextBox.Text) > availAbleQuantity)
//{
// msg = "Product ID [" + selectedProductListGridView.Rows[i].Cells[0].Text.ToString() + "] has no valid Availability.";
// msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = msg;
// return;
//}
else
{
dr = dtPrdList.NewRow();
dr["ProductId"] = selectedProductListGridView.Rows[i].Cells[0].Text.ToString();
// dr["Available"] = selectedProductListGridView.Rows[i].Cells[3].Text.ToString();
dr["Height"] = heighTextBox.Text;
dr["Width"] = widthTextBox.Text;
dr["OrderUnit"] = UnitTextBox.Text;
dr["TotalUnit"] = totalUnitTextBox.Text;
dr["Quantity"] = quantity.ToString();
dr["RatePerUnit"] = rate.ToString();
dr["VATPercentage"] = vatLabel.Text; //selectedProductListGridView.Rows[i].Cells[8].Text.ToString();
dr["Amount"] = amount.ToString();
dr["Serial"] = SerialLabel.Text;
dtPrdList.Rows.Add(dr);
}
}
salesOrder.SalesRecordId = idLabel.Text.Trim();
salesOrder.JournalNumber = journalVoucharLavel.Text;
salesOrder.SalesCenterId = salesCenterIdLabel.Text.Trim();
// salesOrder.CustomerId = customerIdLabel.Text.Trim();
// salesOrder.CustomerName = customerNameLabel.Text.Trim();
// salesOrder.CustomerContactNumber = customerContactLabel.Text.Trim();
//salesOrder.CustomerAddress = customerAddressLabel.Text.Trim();
salesOrder.TotalAmount = totalAmountTextBox.Text.Trim();
salesOrder.DiscountAmount = discountTextBox.Text.Trim();
salesOrder.VAT = vatTextBox.Text.Trim();
salesOrder.TotalReceivable = receivableAmountTextBox.Text.Trim();
// salesOrder.Due = "0";//DuesAmoutPayTextBox.Text;
//salesOrder.SalesOrderId = "";
salesOrder.ReceivedAmount = receivedAmountTextBox.Text.Trim();
salesOrder.ChangeAmount = (Convert.ToDecimal(salesOrder.ReceivedAmount) - Convert.ToDecimal(salesOrder.TotalReceivable)).ToString();
// salesOrder.TotalVATAmount = ;
// salesOrder.AccountId = accountIdLabel.Text;
//salesOrder.CustomerId = customerIdDropDownList.SelectedValue.Trim();
// salesOrder.PaymentMode = paymentMethodLavel.Text.Trim();
// receivePayment.Amount = receivedAmountTextBox.Text.Trim();
// salesOrder.Bank = banklabel.Text.Trim();
// salesOrder.BankBranch = bankBranchlabel.Text.Trim();
// salesOrder.ChequeNumber = ChequeNumberLavel.Text.Trim();
// salesOrder.ChequeDate = LumexLibraryManager.ParseAppDate(ChequeDateLavel.Text);
salesOrder.OthersDes = txtbxDescription.Text;
salesOrder.OthersAmount = txtbxOthersAmount.Text.Trim();
salesOrder.Narration = txtbxNarration.Text;
if (dtPrdList.Rows.Count == selectedProductListGridView.Rows.Count)
{
string salesRecordId = salesOrder.UpdateRetailSales(dtPrdList);
if (salesRecordId != "")
{
//IPOSReportBLL iposReport = new IPOSReportBLL();
//iposReport.GetSalesInvoiceBySalesRecord(salesRecordId, salesOrder.SalesCenterId);
//ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "ViewReportForm();", true);
string message = "Product's <span class='actionTopic'>Sales</span> Successfully Updated in Sale ID: <span class='actionTopic'>" +
salesRecordId + "</span>.";
MyAlertBox("var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/Sales/RetailSalesList.aspx\"; }; SuccessAlert(\"" +
"Process Succeed" + "\", \"" + message + "\", callbackOk);");
}
else
{
string message = "Product's <span class='actionTopic'>Sales</span>Update Falied" +
salesRecordId + "</span>.";
MyAlertBox("var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/Sales/RetailSalesList.aspx\"; }; SuccessAlert(\"" +
"Process Succeed" + "\", \"" + message + "\", callbackOk);");
}
}
}
catch (Exception ex)
{
string message = ex.Message;
if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; }
MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");
}
finally
{
salesOrder = null;
dtPrdList = null;
}
}
protected void deliveredButton_Click(object sender, EventArgs e)
{
SalesOrderBLL salesOrder = new SalesOrderBLL();
try
{
salesOrder.UpdateSalesOrderOnDelivered(idLabel.Text.ToString());
MyAlertBox("alert(\"Sales Order Updated Successfully.\"); window.location=\"/UI/SalesOrder/SalesOrderDelivery.aspx\"");
}
catch (Exception ex)
{
msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = ex.Message;
}
finally
{
salesOrder = null;
}
}
protected void saveButton_Click(object sender, EventArgs e)
{
SalesOrderBLL salesOrder = new SalesOrderBLL();
try
{
if (uncollectableAmountTextBox.Text!="0.00")
{
salesOrder.SaveUncollectableAmountBySalesRecordId(idLabel.Text.Trim(),uncollectableAmountTextBox.Text.Trim());
uncollectableAmountTextBox.Text = "0.00";
GetSalesRecordById(salesRecordIdForViewHiddenField.Value.Trim());
GetSalesRecordProductListById(salesRecordIdForViewHiddenField.Value.Trim());
}
else
{
msgbox.Visible = true;
msgTitleLabel.Text = "Validation Requiered.";
msgDetailLabel.Text = "Amounts Field is Empty!!!";
}
}
catch (Exception ex)
{
msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = ex.Message;
}
finally
{
salesOrder = null;
}
}
protected void recordListButton_Click(object sender, EventArgs e)
{
SalesOrderBLL salesOrder = new SalesOrderBLL();
try
{
if (salesCenterDropDownList.SelectedValue == "")
{
msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Sales Center 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 salesCenterId = salesCenterDropDownList.SelectedValue.Trim();
string fromDate = LumexLibraryManager.ParseAppDate(fromDateTextBox.Text.Trim());
string toDate = LumexLibraryManager.ParseAppDate(toDateTextBox.Text.Trim());
string status = statusDropDownList.SelectedValue.Trim();
DataTable dt = new DataTable();
//if (chkatDropdownList.SelectedValue == "SC")
//{
// dt= salesOrder.GetDamageRecordsListBySalesCenterDateRangeAndStatus(salesCenterId, fromDate, toDate, status);
//}
//else
//{
dt=salesOrder.GetDamageRecordsListByWarehouseDateRangeAndStatus(salesCenterId, fromDate, toDate, status);
damageRecordListGridView.DataSource = dt;
damageRecordListGridView.DataBind();
if (damageRecordListGridView.Rows.Count > 0)
{
damageRecordListGridView.UseAccessibleHeader = true;
damageRecordListGridView.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
{
salesOrder = null;
}
}
public string SaveSalesOrder(SalesOrderBLL salesOrder, DataTable dtPrdList, LumexDBPlayer db)
{
string salesOrderId = "";
try
{
db.AddParameters("@CustomerId", salesOrder.CustomerId.Trim());
db.AddParameters("@CustomerName", salesOrder.CustomerName.Trim());
db.AddParameters("@CustomerContactNumber", salesOrder.CustomerContactNumber.Trim());
db.AddParameters("@CustomerAddress", salesOrder.CustomerAddress.Trim());
db.AddParameters("@SalesCenterId", salesOrder.SalesCenterId.Trim());
db.AddParameters("@SalesPersonId", salesOrder.SalesPersonId.Trim());
db.AddParameters("@TotalAmount", salesOrder.TotalAmount.Trim());
db.AddParameters("@VAT", salesOrder.VAT.Trim());
db.AddParameters("@DiscountAmount", salesOrder.DiscountAmount.Trim());
db.AddParameters("@TotalVATAmount", salesOrder.TotalVATAmount.Trim());
db.AddParameters("@TotalReceivable", salesOrder.TotalReceivable.Trim());
db.AddParameters("@ReceivedAmount", salesOrder.ReceivedAmount.Trim());
db.AddParameters("@ChangeAmount", salesOrder.ChangeAmount);
db.AddParameters("@DeliveryDate", salesOrder.DeliveryDate.Trim());
db.AddParameters("@Narration", salesOrder.Narration.Trim());
db.AddParameters("@TransportType", salesOrder.TransportType.Trim());
db.AddParameters("@AccountId", salesOrder.AccountId);
db.AddParameters("@PaymentMode", salesOrder.PaymentMode.Trim());
db.AddParameters("@Bank", salesOrder.Bank.Trim());
db.AddParameters("@BankBranch", salesOrder.BankBranch.Trim());
db.AddParameters("@ChequeNumber", salesOrder.ChequeNumber.Trim());
db.AddParameters("@ChequeDate", salesOrder.ChequeDate.Trim());
db.AddParameters("@LCNumber", salesOrder.LCNumber.Trim());
db.AddParameters("@ShippingAddress", salesOrder.ShippingAddress.Trim());
db.AddParameters("@BillingAddress", salesOrder.BillingAddress.Trim());
db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString());
db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
DataTable dt = db.ExecuteDataTable("INSERT_SALES_ORDER", true);
if (dt.Rows.Count > 0)
{
salesOrderId = dt.Rows[0][0].ToString();
}
for (int i = 0; i < dtPrdList.Rows.Count; i++)
{
db.ClearParameters();
if (dtPrdList.Rows[i]["Quantity"].ToString() == "" || dtPrdList.Rows[i]["Amount"].ToString() == "" || dtPrdList.Rows[i]["Available"].ToString() == "" || dtPrdList.Rows[i]["RatePerUnit"].ToString() == "")
{
if (dtPrdList.Rows[i]["Quantity"].ToString() == "")
{
dtPrdList.Rows[i]["Quantity"] = 0;
}
if (dtPrdList.Rows[i]["Amount"].ToString() == "")
{
dtPrdList.Rows[i]["Amount"] = 0;
}
if (dtPrdList.Rows[i]["Available"].ToString() == "")
{
dtPrdList.Rows[i]["Available"] = 0;
}
if (dtPrdList.Rows[i]["RatePerUnit"].ToString() == "")
{
dtPrdList.Rows[i]["RatePerUnit"] = 0;
}
if (dtPrdList.Rows[i]["VATPercentage"].ToString() == "")
{
dtPrdList.Rows[i]["VATPercentage"] = 0;
}
}
db.AddParameters("@SalesOrderId", salesOrderId.Trim());
db.AddParameters("@ProductId", dtPrdList.Rows[i]["ProductId"].ToString());
db.AddParameters("@RatePerUnit", dtPrdList.Rows[i]["RatePerUnit"].ToString());
db.AddParameters("@ProductVat", dtPrdList.Rows[i]["VATPercentage"].ToString());
db.AddParameters("@Quantity", dtPrdList.Rows[i]["Quantity"].ToString());
db.AddParameters("@Amount", dtPrdList.Rows[i]["Amount"].ToString());
db.AddParameters("@FreeQuantityWas", dtPrdList.Rows[i]["Available"].ToString());
db.AddParameters("@Narration", "");
db.ExecuteNonQuery("INSERT_SALES_ORDER_PRODUCT", true);
}
//db.ClearParameters();
//db.AddParameters("@SalesOrderId", salesOrderId.Trim());
//db.AddParameters("@SalesCenterId", salesOrder.SalesCenterId.Trim());
//db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString());
//db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
//db.ExecuteNonQuery("UPDATE_PRODUCT_STOCK_TO_CREATE_SALES_ORDER", true);
return salesOrderId;
}
catch (Exception)
{
throw;
}
finally
{
salesOrder = null;
dtPrdList = null;
}
}
internal bool RejectRetailSales(SalesOrderBLL salesOrderBLL, LumexDBPlayer db)
{
try
{
bool status = false;
db.AddParameters("@SalesRecordId", salesOrderBLL.SalesRecordId);
db.AddParameters("@SalesCenterId", salesOrderBLL.SalesCenterId);
db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString());
db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
db.ExecuteNonQuery("[INSERT_RETAIL_SALES_RECEIVE_PAYMENT_LEDGER_TRANSACTION_FOR_SUB_PRODUCT_REJECT]", true);
status = true;
return status;
}
catch (Exception)
{
throw;
}
}
internal string UpdateRetailSales(SalesOrderBLL salesOrder, DataTable dtPrdList, LumexDBPlayer db)
{
string salesRecordId = "";
try
{
db.AddParameters("@TotalAmount", salesOrder.TotalAmount.Trim());
db.AddParameters("@DiscountAmount", salesOrder.DiscountAmount.Trim());
db.AddParameters("@VAT", salesOrder.VAT.Trim());
db.AddParameters("@TotalReceivable", salesOrder.TotalReceivable.Trim());
db.AddParameters("@ReceivedAmount", salesOrder.ReceivedAmount.Trim());
db.AddParameters("@ChangeAmount", salesOrder.ChangeAmount.Trim());
db.AddParameters("@SalesRecordId", salesOrder.SalesRecordId.Trim());
db.AddParameters("@OthersAmount", salesOrder.OthersAmount.Trim());
db.AddParameters("@OthersDes", salesOrder.OthersDes.Trim());
db.AddParameters("@Narration", salesOrder.Narration.Trim());
DataTable dt = db.ExecuteDataTable("[UPDATE_RETAIL_SALES_RECORD_BY_RECORD_ID]", true);
if (dt.Rows.Count > 0)
{
salesRecordId = dt.Rows[0][0].ToString();
}
for (int i = 0; i < dtPrdList.Rows.Count; i++)
{
db.ClearParameters();
db.AddParameters("@SalesRecordId", salesRecordId.Trim());
db.AddParameters("@ProductId", dtPrdList.Rows[i]["ProductId"].ToString());
db.AddParameters("@RatePerUnit", dtPrdList.Rows[i]["RatePerUnit"].ToString());
db.AddParameters("@Quantity", dtPrdList.Rows[i]["Quantity"].ToString());
db.AddParameters("@Amount", dtPrdList.Rows[i]["Amount"].ToString());
db.AddParameters("@VATPercentage", dtPrdList.Rows[i]["VATPercentage"].ToString());
db.AddParameters("@Height", dtPrdList.Rows[i]["Height"].ToString());
db.AddParameters("@Width", dtPrdList.Rows[i]["Width"].ToString());
db.AddParameters("@OnSale", "Yes");
db.AddParameters("@OrderUnit", dtPrdList.Rows[i]["OrderUnit"].ToString());
db.AddParameters("@TotalUit", dtPrdList.Rows[i]["TotalUnit"].ToString());
db.AddParameters("@Serial", dtPrdList.Rows[i]["Serial"].ToString());
db.AddParameters("@Description", "");
db.ExecuteNonQuery("UPDATE_RETAIL_SALES_RECORD_PRODUCT", true);
}
db.ClearParameters();
db.AddParameters("@SalesRecordId", salesRecordId.Trim());
db.AddParameters("@SalesCenterId", salesOrder.SalesCenterId.Trim());
db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString());
db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
db.ExecuteNonQuery("[UPDATE_RETAIL_SALES_RECEIVE_PAYMENT_LEDGER_TRANSACTION_FOR_SUB_PRODUCT_APPROVE_BY_JV_RECORD]", true);
return salesRecordId;
}
catch (Exception)
{
throw;
}
finally
{
salesOrder = null;
dtPrdList = null;
}
}
// Insert Sales
public string SaveRetailSales(SalesOrderBLL salesOrder, DataTable dtPrdList, LumexDBPlayer db)
{
string salesRecordId = "";
try
{
db.AddParameters("@CustomerId", salesOrder.CustomerId.Trim());
db.AddParameters("@CustomerName", salesOrder.CustomerName.Trim());
db.AddParameters("@CustomerContactNumber", salesOrder.CustomerContactNumber.Trim());
db.AddParameters("@CustomerAddress", salesOrder.CustomerAddress.Trim());
db.AddParameters("@SalesCenterId", salesOrder.SalesCenterId.Trim());
db.AddParameters("@TotalAmount", salesOrder.TotalAmount.Trim());
db.AddParameters("@DiscountAmount", salesOrder.DiscountAmount.Trim());
db.AddParameters("@VAT", salesOrder.VAT.Trim());
db.AddParameters("@TotalReceivable", salesOrder.TotalReceivable.Trim());
db.AddParameters("@ReceivedAmount", salesOrder.ReceivedAmount.Trim());
db.AddParameters("@ChangeAmount", salesOrder.ChangeAmount.Trim());
db.AddParameters("@TotalVATAmount", salesOrder.TotalVATAmount.Trim());
db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString());
db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
db.AddParameters("@SalesOrderId", salesOrder.SalesOrderId.Trim());
//New Add
db.AddParameters("@PaymentMode", salesOrder.PaymentMode.Trim());
db.AddParameters("@AccountId", salesOrder.AccountId.Trim());
db.AddParameters("@Bank", salesOrder.Bank.Trim());
db.AddParameters("@BankBranch", salesOrder.BankBranch.Trim());
db.AddParameters("@ChequeNumber", salesOrder.ChequeNumber.Trim());
db.AddParameters("@ChequeDate", salesOrder.ChequeDate.Trim());
db.AddParameters("@OthersDes", salesOrder.OthersDes.Trim());
db.AddParameters("@OthersAmount", salesOrder.OthersAmount.Trim());
db.AddParameters("@Narration", salesOrder.Narration.Trim());
//
DataTable dt = db.ExecuteDataTable("INSERT_RETAIL_SALES_RECORD", true);
if (dt.Rows.Count > 0)
{
salesRecordId = dt.Rows[0][0].ToString();
}
for (int i = 0; i < dtPrdList.Rows.Count; i++)
{
db.ClearParameters();
db.AddParameters("@SalesCenterId", salesOrder.SalesCenterId.Trim());
db.AddParameters("@SalesRecordId", salesRecordId.Trim());
db.AddParameters("@ProductId", dtPrdList.Rows[i]["ProductId"].ToString());
db.AddParameters("@RatePerUnit", dtPrdList.Rows[i]["RatePerUnit"].ToString());
db.AddParameters("@Quantity", dtPrdList.Rows[i]["Quantity"].ToString());
db.AddParameters("@Amount", dtPrdList.Rows[i]["Amount"].ToString());
db.AddParameters("@VATPercentage", dtPrdList.Rows[i]["VATPercentage"].ToString());
db.AddParameters("@Height", dtPrdList.Rows[i]["Height"].ToString());
db.AddParameters("@Width", dtPrdList.Rows[i]["Width"].ToString());
db.AddParameters("@OnSale", "Yes");
db.AddParameters("@OrderUnit", dtPrdList.Rows[i]["OrderUnit"].ToString());
db.AddParameters("@TotalUit", dtPrdList.Rows[i]["TotalUnit"].ToString());
db.AddParameters("@Description", "");
db.ExecuteNonQuery("INSERT_RETAIL_SALES_RECORD_PRODUCT", true);
}
if (salesOrder.SalesCenterId == "WH-002")
{
db.ClearParameters();
db.AddParameters("@SalesRecordId", salesRecordId.Trim());
db.AddParameters("@SalesCenterId", salesOrder.SalesCenterId.Trim());
db.AddParameters("@ModifiedBy", LumexSessionManager.Get("ActiveUserId").ToString());
db.AddParameters("@ModifiedFrom", LumexLibraryManager.GetTerminal());
db.ExecuteNonQuery("UPDATE_PRODUCT_STOCK_FOR_RETAIL_SALES", true);
db.ClearParameters();
db.AddParameters("@SalesRecordId", salesRecordId.Trim());
db.AddParameters("@SalesCenterId", salesOrder.SalesCenterId.Trim());
db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString());
db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
db.ExecuteNonQuery("INSERT_RETAIL_SALES_RECEIVE_PAYMENT_LEDGER_TRANSACTION", true);
}
else
{
db.ClearParameters();
db.AddParameters("@SalesRecordId", salesRecordId.Trim());
db.AddParameters("@SalesCenterId", salesOrder.SalesCenterId.Trim());
db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString());
db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
db.ExecuteNonQuery("[INSERT_RETAIL_SALES_RECEIVE_PAYMENT_LEDGER_TRANSACTION_FOR_SUB_PRODUCT_APPROVE]", true);
}
return salesRecordId;
}
catch (Exception)
{
throw;
}
finally
{
salesOrder = null;
dtPrdList = null;
}
}
protected void recordListButton_Click(object sender, EventArgs e)
{
SalesOrderBLL salesOrder = new SalesOrderBLL();
try
{
if (salesCenterDropDownList.SelectedValue == "")
{
msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Sales Center 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 salesCenterId = salesCenterDropDownList.SelectedValue.Trim();
string fromDate = LumexLibraryManager.ParseAppDate(fromDateTextBox.Text.Trim());
string toDate = LumexLibraryManager.ParseAppDate(toDateTextBox.Text.Trim());
string status = statusDropDownList.SelectedValue.Trim();
DataTable dt = salesOrder.GetSalesReturnsListBySalesCenterDateRangeAndStatus(salesCenterId, fromDate, toDate, status);
salesReturnListGridView.DataSource = dt;
salesReturnListGridView.DataBind();
if (salesReturnListGridView.Rows.Count > 0)
{
salesReturnListGridView.UseAccessibleHeader = true;
salesReturnListGridView.HeaderRow.TableSection = TableRowSection.TableHeader;
}
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
{
salesOrder = null;
}
}
public string SaveWarehouseDamageProduct(SalesOrderBLL salesOrder, DataTable dtPrdList, LumexDBPlayer db)
{
string damageRecordId = "";
try
{
db.AddParameters("@WarehouseId", salesOrder.SalesCenterId.Trim());
db.AddParameters("@TotalAmount", salesOrder.TotalAmount.Trim());
db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString());
db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
DataTable dt = db.ExecuteDataTable("INSERT_WAREHOUSE_PRODUCT_DAMAGE_RECORD", true);
if (dt.Rows.Count > 0)
{
damageRecordId = dt.Rows[0][0].ToString();
}
for (int i = 0; i < dtPrdList.Rows.Count; i++)
{
db.ClearParameters();
db.AddParameters("@WarehouseId", salesOrder.SalesCenterId.Trim());
db.AddParameters("@DamageRecordId", damageRecordId.Trim());
db.AddParameters("@ProductId", dtPrdList.Rows[i]["ProductId"].ToString());
db.AddParameters("@RatePerUnit", dtPrdList.Rows[i]["RatePerUnit"].ToString());
db.AddParameters("@Quantity", dtPrdList.Rows[i]["Quantity"].ToString());
db.AddParameters("@Amount", dtPrdList.Rows[i]["Amount"].ToString());
db.ExecuteNonQuery("INSERT_WAREHOUSE_PRODUCT_DAMAGE_RECORD_PRODUCT", true);
}
db.ClearParameters();
db.AddParameters("@DamageRecordId", damageRecordId.Trim());
db.AddParameters("@WarehouseId", salesOrder.SalesCenterId.Trim());
db.AddParameters("@ModifiedBy", LumexSessionManager.Get("ActiveUserId").ToString());
db.AddParameters("@ModifiedFrom", LumexLibraryManager.GetTerminal());
db.ExecuteNonQuery("UPDATE_WAREHOUSE_PRODUCT_STOCK_FOR_DAMAGE_RECORD", true);
db.ClearParameters();
db.AddParameters("@DamageRecordId", damageRecordId.Trim());
db.AddParameters("@WarehouseId", salesOrder.SalesCenterId.Trim());
db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString());
db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
db.ExecuteNonQuery("INSERT_WAREHOUSE_PRODUCT_DAMAGE_LEDGER_TRANSACTION", true);
return damageRecordId;
}
catch (Exception)
{
throw;
}
finally
{
salesOrder = null;
dtPrdList = null;
}
}
protected void btnReject_OnClick(object sender, EventArgs e)
{
SalesOrderBLL salesOrder = new SalesOrderBLL();
try
{
bool status = false;
salesOrder.SalesRecordId = idLabel.Text.Trim();
salesOrder.SalesCenterId = salesCenterIdLabel.Text.Trim();
status = salesOrder.RejectRetailSales();
if (status)
{
string message = "Product's <span class='actionTopic'>Sales</span> Successfully Rejected By ID: <span class='actionTopic'>" +
salesOrder.SalesRecordId + "</span>.";
MyAlertBox("var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/Sales/RetailSalesList.aspx\"; }; SuccessAlert(\"" +
"Process Succeed" + "\", \"" + message + "\", callbackOk);");
}
else
{
string message = "Product's <span class='actionTopic'>Sales</span>Rejection Falied" +
salesOrder.SalesRecordId + "</span>.";
MyAlertBox("var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/Sales/RetailSalesList.aspx\"; }; SuccessAlert(\"" +
"Process Succeed" + "\", \"" + message + "\", callbackOk);");
}
}
catch (Exception)
{
//throw;
}
finally
{
salesOrder = null;
}
}
protected void SaveSalesReturn(string isDuesAdjust)
{
SalesOrderBLL salesOrder = new SalesOrderBLL();
try
{
if (Convert.ToDecimal(totalReturnAmountTextBox.Text) > 0)
{
DataTable dtPrdList = (DataTable) LumexSessionManager.Get("RPLdt");
for (int i = 0; i < salesRecordProductListGridView.Rows.Count; i++)
{
TextBox returnQuantityTextBox =
(TextBox) salesRecordProductListGridView.Rows[i].FindControl("returnQuantityTextBox");
dtPrdList.Rows[i]["ReturnQuantity"] = returnQuantityTextBox.Text.Trim();
TextBox returnAmountTextBox =
(TextBox) salesRecordProductListGridView.Rows[i].FindControl("returnAmountTextBox");
dtPrdList.Rows[i]["ReturnAmount"] = returnAmountTextBox.Text.Trim();
}
dtPrdList.AcceptChanges();
for (int i = 0; i < dtPrdList.Rows.Count; i++)
{
if (string.IsNullOrEmpty(dtPrdList.Rows[i]["ReturnQuantity"].ToString()) ||
dtPrdList.Rows[i]["ReturnQuantity"].ToString() == "0")
{
dtPrdList.Rows.RemoveAt(i);
i--;
}
}
salesOrder.SalesRecordId = salesRecordIdTextBox.Text.Trim();
salesOrder.SalesCenterId = salesCenterIdLabel.Text.Trim();
salesOrder.ReturnAmount = totalReturnAmountTextBox.Text.Trim();
salesOrder.ReturnVATAmount = totalReturnVATAmountTextBox.Text.Trim();
salesOrder.SalesDueAmount = salesDueAmountTextBox.Text.Trim();
salesOrder.CustomerId = customerIdLabel.Text.Trim();
salesOrder.IsDuesAdjustforSalesReturn = isDuesAdjust;
DataTable dt = salesOrder.SaveSalesReturn(dtPrdList);
if (isDuesAdjust == "Y")
{
LumexSessionManager.Add("ReturnableAmount", dt.Rows[0]["ReturnAmount"]);
string message =
"Sales <span class='actionTopic'>Return</span> Successfully with Adjust Dues of Return ID: <span class='actionTopic'>" +
dt.Rows[0]["SalesReturnId"] + " And Money Back Amount:" + dt.Rows[0]["ReturnAmount"] +
"</span>.";
MyAlertBox(
"var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/SalesReturn/SalesReturnList.aspx\"; }; SuccessAlert(\"" +
"Process Succeed" + "\", \"" + message + "\", \"\");");
}
else
{
string message =
"Sales <span class='actionTopic'>Return</span> Successfully with Money Back Only of Return ID: <span class='actionTopic'>" +
dt.Rows[0]["SalesReturnId"] + " And Money Back Amount:" + dt.Rows[0]["ReturnAmount"] +
"</span>.";
MyAlertBox(
"var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/SalesReturn/SalesReturnList.aspx\"; }; SuccessAlert(\"" +
"Process Succeed" + "\", \"" + message + "\", \"\");");
}
receiveSalesReturnforAdjustButton.Enabled = false;
receiveSalesReturnForMoneyBackButton.Enabled = false;
}
else
{
string message = "Sales Return Amount must be greater than 0.00";
MyAlertBox("WarningAlert( \"" + message + "\", \"\");");
}
}
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;
}
}
