protected void generateButton_OnClick(object sender, EventArgs e) { try { IPOSReportBLL iposReport = new IPOSReportBLL(); iposReport.GetProductSalesRecordListByProductId(drpdwnProduct.SelectedValue, fromDateTextBox.Text,toDateTextBox.Text); ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "ViewReportForm();", true); //} //else if (drpdwnReportOnStock.SelectedValue == "2") //{ // IPOSReportBLL iposReport = new IPOSReportBLL(); // iposReport.GetAvailableProductBySaclesCenterIdPRWise(SalesCenterIdDropDownList.SelectedValue); // ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "ViewReportForm();", true); //} } catch (Exception ex) { string message = ex.Message; if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; } MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");"); } finally { MyAlertBox("MyOverlayStop();"); } }
protected void generateButton_Click(object sender, EventArgs e) { try { IPOSReportBLL iposReport = new IPOSReportBLL(); iposReport.Get_Income_Statement_by_Date(reportTypeDropDownList.SelectedValue, SCWHDropDownList.SelectedValue, toDateTextBox.Text, fromDateTextBox.Text); ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "ViewReportForm();", true); } catch (Exception ex) { string message = ex.Message; if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; } MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");"); } finally { MyAlertBox("MyOverlayStop();"); } }
protected void generateButton_Click(object sender, EventArgs e) { try { IPOSReportBLL iposReport = new IPOSReportBLL(); iposReport.GetSalesCenterCustomerDueAmountList(salesCenterDropDownList.SelectedValue); ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "ViewReportForm();", true); } catch (Exception ex) { string message = ex.Message; if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; } MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");"); } finally { MyAlertBox("MyOverlayStop();"); } }
protected void exportButton_Click(object sender, EventArgs e) { try { IPOSReportBLL iposReport = new IPOSReportBLL(); iposReport.GetPurchaseRecordbySC_Date_RANGE_STATUS(drpdwnSalesCenterOrWarehouse.SelectedValue, toDateTextBox.Text, fromDateTextBox.Text, drpdwnPRStatus.SelectedValue); ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "ExportReportForm();", true); //else if (drpdwnReportOnStock.SelectedValue == "2") //{ // IPOSReportBLL iposReport = new IPOSReportBLL(); // iposReport.GetAvailableProductBySaclesCenterId(SalesCenterIdDropDownList.SelectedValue); // ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "ExportReportForm();", true); //} } catch (Exception ex) { string message = ex.Message; if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; } MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");"); } finally { MyAlertBox("MyOverlayStop();"); } }
protected void printInvoiceButton_OnClick(object sender, EventArgs e) { try { LinkButton lnkBtn = (LinkButton)sender; GridViewRow row = (GridViewRow)lnkBtn.NamingContainer; string JournalNo = customerPaymentListGridView.Rows[row.RowIndex].Cells[0].Text.ToString(); string customerId = customerDropDownList.SelectedValue; string WHSCId = LumexSessionManager.Get("UserWareHouseId").ToString(); IPOSReportBLL iposReport = new IPOSReportBLL(); iposReport.GetReceivePaymentVaucharbyVendororCustomer(JournalNo, customerId, WHSCId); ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "ViewReportForm();", true); } catch (Exception ex) { // } }
protected void printInvoiceButton_OnClick(object sender, EventArgs e) { LinkButton lnkBtn = (LinkButton)sender; GridViewRow row = (GridViewRow)lnkBtn.NamingContainer; string cmdarg = "1"; string voucherId = voucherListGridView.Rows[row.RowIndex].Cells[0].Text.ToString(); //string salesCencerId = salesCenterDropDownList.SelectedValue; IPOSReportBLL iposReport = new IPOSReportBLL(); iposReport.GetCreditOrDebitVoucherByVoucherId(voucherId, drpdwnSalesCenterOrWarehouse.SelectedValue, cmdarg); ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "ViewReportForm();", true); }
protected void saveButton_Click(object sender, EventArgs e) { DebitCreditVoucherBLL debitCreditVoucher = new DebitCreditVoucherBLL(); Button btn = (Button)sender; string cmdarg = btn.CommandArgument; try { if (accountHeadDropDownList.SelectedValue == "") { msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Account Head field is required."; } else if (amountTextBox.Text.Trim() == "") { msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Amount field is required."; } else if (cashAccountHeadDropDownList.SelectedValue == "") { msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Cash Account Head field is required."; } else if (voucherNumberTextBox.Text.Trim() == "") { msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Voucher Number field is required."; } else if (payToFromCompanyDropDownList.SelectedValue == "") { msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Pay To/From Company field is required."; } else if (narrationTextBox.Text.Trim() == "") { msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Narration field is required."; } else { debitCreditVoucher.ManualVoucherNumber = voucherNumberTextBox.Text.Trim(); debitCreditVoucher.AccountId = accountHeadDropDownList.SelectedValue.Trim(); debitCreditVoucher.CounterAccountId = cashAccountHeadDropDownList.SelectedValue.Trim(); debitCreditVoucher.Amount = amountTextBox.Text.Trim(); debitCreditVoucher.PayToFromCompany = payToFromCompanyDropDownList.SelectedValue.Trim(); debitCreditVoucher.Narration = narrationTextBox.Text.Trim(); debitCreditVoucher.SalesCenterId = drpdwnSalesCenterOrWarehouse.SelectedValue; DataTable dt = debitCreditVoucher.SaveDebitVoucherCash(); if (dt.Rows.Count > 0) { if (cmdarg == "2") { IPOSReportBLL iposReport = new IPOSReportBLL(); iposReport.GetCreditOrDebitVoucherByVoucherId(dt.Rows[0][0].ToString(), debitCreditVoucher.SalesCenterId.ToString(),cmdarg); ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "ViewReportForm();", true); } string message = "Debit Voucher Cash <span class='actionTopic'>Created</span> Successfully with Voucher Number: <span class='actionTopic'>" + dt.Rows[0][0].ToString() + "</span>."; MyAlertBox("var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/AccUI/DebitVoucher/DebitVoucherCashList.aspx\"; }; SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", callbackOk);"); } else { string message = "<span class='actionTopic'>Failed</span> to Create Debit Voucher Cash."; MyAlertBox("ErrorAlert(\"" + "Process Failed" + "\", \"" + message + "\");"); } } } catch (Exception ex) { string message = ex.Message; if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; } MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");"); } finally { debitCreditVoucher = 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; TextBox heighTextBox; TextBox widthTextBox; TextBox UnitTextBox; TextBox totalUnitTextBox; Label vatLabel; 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")); 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"); 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(); dtPrdList.Rows.Add(dr); } } if (accountHeadDropDownList.SelectedValue == "") { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Select Any Account Head"; return; } else if (totalAmountTextBox.Text.Trim() == "") { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Total Amount field is required."; return; } else if (receivedAmountTextBox.Text.Trim() == "" && customerIdDropDownList.SelectedIndex == 1) { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Received Amount field is required."; return; } else if (changeAmountTextBox.Text.Trim() == "") { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Change Amount field is required."; return; } else if (customerIdDropDownList.SelectedItem.Text.Trim() == "Retail" && Convert.ToDecimal(receivableAmountTextBox.Text) > Convert.ToDecimal(receivedAmountTextBox.Text) && customerNameTextBox.Text == "" && customerContactNumberTextBox.Text == "") { msgbox.Visible = true; msgTitleLabel.Text = "Warning!!!"; msgDetailLabel.Text = "Can not sale Retail on Due please select Customer."; return; } else if ((paymentModeDropDownList.SelectedValue == "Cheque" && chequeNumberTextBox.Text == "") || (paymentModeDropDownList.SelectedValue == "Cheque" && chequeDateTextBox.Text == "")) { //if (chequeNumberTextBox.Text == "" || chequeDateTextBox.Text == "") //{ msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Cheque Number Or Cheque Date field is Required."; return; // } } //if (string.IsNullOrEmpty(DuesAmoutPayTextBox.Text)) //{ // DuesAmoutPayTextBox.Text = "0"; //} else { if (receivedAmountTextBox.Text == "") { receivedAmountTextBox.Text = "0"; } salesOrder.SalesCenterId = ddlSelectWareHouseOrSalesCenter.SelectedValue.Trim(); salesOrder.CustomerId = customerIdDropDownList.SelectedValue.Trim(); salesOrder.CustomerName = customerNameTextBox.Text.Trim(); salesOrder.CustomerContactNumber = customerContactNumberTextBox.Text.Trim(); salesOrder.CustomerAddress = customerAddressTextBox.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 = totalVATAmountHiddenField.Value; salesOrder.AccountId = accountHeadDropDownList.SelectedValue; salesOrder.CustomerId = customerIdDropDownList.SelectedValue.Trim(); salesOrder.PaymentMode = paymentModeDropDownList.SelectedValue; // receivePayment.Amount = receivedAmountTextBox.Text.Trim(); salesOrder.Bank = bankDropDownList.Text; salesOrder.BankBranch = bankBranchTextBox.Text; salesOrder.ChequeNumber = chequeNumberTextBox.Text; salesOrder.ChequeDate = LumexLibraryManager.ParseAppDate(chequeDateTextBox.Text); salesOrder.OthersDes = txtbxDescription.Text; salesOrder.OthersAmount = txtbxOthersAmount.Text; salesOrder.Narration = txtbxNarration.Text; if (dtPrdList.Rows.Count == selectedProductListGridView.Rows.Count) { string salesRecordId = salesOrder.SaveRetailSales(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 with Sale ID: <span class='actionTopic'>" + salesRecordId + "</span>."; MyAlertBox("var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/Sales/RetailSales.aspx\"; }; SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", callbackOk);"); } else { string message = "Product's <span class='actionTopic'>Sales</span> Falied" + salesRecordId + "</span>."; MyAlertBox("var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/Sales/RetailSales.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 exportButton_Click(object sender, EventArgs e) { try { if (titleSalesCenterOrWarehouse.Text == "Sales Center") { if (drpdwnReportOnStock.SelectedValue == "1") { IPOSReportBLL iposReport = new IPOSReportBLL(); iposReport.GetAvailableProductBySaclesCenterId(drpdwnSalesCenterOrWarehouse.SelectedValue); ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "ExportReportForm();", true); } else if (drpdwnReportOnStock.SelectedValue == "2") { IPOSReportBLL iposReport = new IPOSReportBLL(); iposReport.GetAvailableProductBySaclesCenterIdPRWise(drpdwnSalesCenterOrWarehouse.SelectedValue); ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "ExportReportForm();", true); } } else { if (drpdwnReportOnStock.SelectedValue == "1") { IPOSReportBLL iposReport = new IPOSReportBLL(); iposReport.GetAvailableProductByWarehouseId(drpdwnSalesCenterOrWarehouse.SelectedValue); ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "ExportReportForm();", true); } else if (drpdwnReportOnStock.SelectedValue == "2") { IPOSReportBLL iposReport = new IPOSReportBLL(); iposReport.GetAvailableProductByWarehouseIdPRWise(drpdwnSalesCenterOrWarehouse.SelectedValue); ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "ExportReportForm();", true); } } } catch (Exception ex) { string message = ex.Message; if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; } MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");"); } finally { MyAlertBox("MyOverlayStop();"); } }
protected void printInvoiceButton_OnClick(object sender, EventArgs e) { LinkButton lnkBtn = (LinkButton)sender; GridViewRow row = (GridViewRow)lnkBtn.NamingContainer; string salesRecordId = salesRecordListGridView.Rows[row.RowIndex].Cells[0].Text.ToString(); string salesCencerId = salesCenterDropDownList.SelectedValue; IPOSReportBLL iposReport = new IPOSReportBLL(); iposReport.GetSalesInvoiceBySalesRecord(salesRecordId, salesCencerId); ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "ViewReportForm();", true); }