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; } }