protected void GetJournalVoucherEntryListByJournalNumber(string journalNumber) { JournalVoucherBLL journalVoucher = new JournalVoucherBLL(); try { DataTable dt = journalVoucher.GetJournalVoucherEntryListByJournal(journalNumber); if (dt.Rows.Count > 0) { transactionDateLabel.Text = dt.Rows[0]["TransactionDate"].ToString(); autoVoucherNumberLabel.Text = dt.Rows[0]["AutoVoucherNumber"].ToString() + " - T" + dt.Rows.Count.ToString(); voucherStatusLabel.Text = dt.Rows[0]["Status"].ToString(); totalEntryLabel.Text = dt.Rows.Count.ToString(); journalEntryListGridView.DataSource = dt; journalEntryListGridView.DataBind(); if (journalEntryListGridView.Rows.Count > 0) { journalEntryListGridView.UseAccessibleHeader = true; journalEntryListGridView.HeaderRow.TableSection = TableRowSection.TableHeader; } CalculateTotalDebitCreditAmount(dt); } else { msgbox.Visible = true; msgTitleLabel.Text = "Journal Voucher Entry List Data Not Found!!!"; msgDetailLabel.Text = ""; msgbox.Attributes.Add("class", "alert alert-warning"); } } catch (Exception ex) { string message = ex.Message; if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; } MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");"); } finally { journalVoucher = null; } }
public void UpdateJournalVoucherEntryByJournalAndTransactionNumber(JournalVoucherBLL journalVoucher, LumexDBPlayer db) { try { db.AddParameters("@JournalNumber", journalVoucher.JournalNumber.Trim()); db.AddParameters("@TransactionNumber", journalVoucher.TransactionNumber.Trim()); db.AddParameters("@Description", journalVoucher.Description.Trim()); db.AddParameters("@ManualVoucherNumber", journalVoucher.ManualVoucherNumber.Trim()); db.AddParameters("@AccountId", journalVoucher.AccountId.Trim()); db.AddParameters("@DebitCredit", journalVoucher.DebitCredit.Trim()); db.AddParameters("@Amount", journalVoucher.Amount.Trim()); db.AddParameters("@Bank", journalVoucher.Bank.Trim()); db.AddParameters("@BankBranch", journalVoucher.BankBranch.Trim()); db.AddParameters("@ChequeNumber", journalVoucher.ChequeNumber.Trim()); db.AddParameters("@ChequeDate", journalVoucher.ChequeDate.Trim()); db.AddParameters("@PayToFromCompany", journalVoucher.PayToFromCompany.Trim()); db.AddParameters("@Narration", journalVoucher.Narration.Trim()); db.AddParameters("@ModifiedBy", LumexSessionManager.Get("ActiveUserId").ToString()); db.AddParameters("@ModifiedFrom", LumexLibraryManager.GetTerminal()); db.ExecuteNonQuery("UPDATE_JOURNAL_VOUCHER_ENTRY", true); } catch (Exception) { throw; } finally { journalVoucher = null; } }
protected void GetAllVoucherList() { JournalVoucherBLL journalVoucher = new JournalVoucherBLL(); try { string fromDate = LumexLibraryManager.ParseAppDate(fromDateTextBox.Text.Trim()); string toDate = LumexLibraryManager.ParseAppDate(toDateTextBox.Text.Trim()); DataTable dt = journalVoucher.GetJournalVoucherListByDateRangeAndAll(drpdwnSalesCenterOrWarehouse.SelectedValue, fromDate, toDate, "All"); voucherListGridView.DataSource = dt; voucherListGridView.DataBind(); if (voucherListGridView.Rows.Count > 0) { voucherListGridView.UseAccessibleHeader = true; voucherListGridView.HeaderRow.TableSection = TableRowSection.TableHeader; } else { msgbox.Visible = true; msgTitleLabel.Text = "Journal Voucher List Data Not Found!!!"; msgDetailLabel.Text = ""; msgbox.Attributes.Add("class", "alert alert-info"); } } catch (Exception ex) { string message = ex.Message; if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; } MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");"); } finally { journalVoucher = null; MyAlertBox("MyOverlayStop();"); } }
protected void saveChangesButton_Click(object sender, EventArgs e) { JournalVoucherBLL journalVoucher = new JournalVoucherBLL(); try { if (drAmtLabel.Text == crAmtLabel.Text && voucherStatusLabel.Text == "Update Pending") { journalVoucher.UpdateJournalVoucherUpdateStatusByJournal(numberLabel.Text.Trim()); string message = "Journal Voucher Changes <span class='actionTopic'>Saved</span> Successfully."; MyAlertBox("var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/AccUI/JournalVoucher/JournalVoucherList.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 { journalVoucher = null; } }
protected void updateButton_Click(object sender, EventArgs e) { JournalVoucherBLL journalVoucher = new JournalVoucherBLL(); try { if (accountHeadDropDownList.SelectedValue == "") { msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "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 { journalVoucher.JournalNumber = journalNumberForUpdateHiddenField.Value.Trim(); journalVoucher.TransactionNumber = transactionNumberForUpdateHiddenField.Value.Trim(); journalVoucher.Description = descriptionForUpdateHiddenField.Value.Trim(); journalVoucher.ManualVoucherNumber = voucherNumberTextBox.Text.Trim(); journalVoucher.AccountId = accountHeadDropDownList.SelectedValue.Trim(); journalVoucher.DebitCredit = debitCreditDropDownList.SelectedValue.Trim(); journalVoucher.Amount = amountTextBox.Text.Trim(); journalVoucher.Bank = bankDropDownList.SelectedValue.Trim(); journalVoucher.BankBranch = bankBranchTextBox.Text.Trim(); journalVoucher.ChequeNumber = chequeNumberTextBox.Text.Trim(); journalVoucher.ChequeDate = LumexLibraryManager.ParseAppDate(chequeDateTextBox.Text.Trim()); journalVoucher.PayToFromCompany = payToFromCompanyDropDownList.SelectedValue.Trim(); journalVoucher.Narration = narrationTextBox.Text.Trim(); journalVoucher.UpdateJournalVoucherEntryByJournalAndTransactionNumber(); GetJournalVoucherEntryListByJournalNumber(numberLabel.Text.Trim()); string message = "Journal Voucher Entry <span class='actionTopic'>Updated</span> Successfully."; MyAlertBox("SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", \"\");"); } } catch (Exception ex) { string message = ex.Message; if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; } MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");"); } finally { journalVoucher = null; } }
public static string GetJournalEntryViewByJournalAndTransactionNumber(string SN, string journalNumber) { try { JournalVoucherBLL journalVoucher = new JournalVoucherBLL(); DataTable dt = journalVoucher.GetJournalVoucherEntryByJournalAndTransactionNumber(journalNumber, SN); string json = JsonConvert.SerializeObject(dt); json = json.Substring(1, json.Length - 2); return json; } catch (Exception) { throw; } }
protected void approveButton_Click(object sender, EventArgs e) { JournalVoucherBLL journalVoucher = new JournalVoucherBLL(); CheckBox selectCheckBox; int count = 0; try { for (int i = 0; i < voucherListGridView.Rows.Count; i++) { selectCheckBox = (CheckBox)voucherListGridView.Rows[i].Cells[5].FindControl("selectCheckBox"); if (selectCheckBox.Checked) { journalVoucher.ApproveJournalVoucherByJournal(voucherListGridView.Rows[i].Cells[0].Text.Trim()); count++; } } if (count > 0) { GetApprovalList(); string message = count.ToString() + " Journal Voucher(s) <span class='actionTopic'>Approved</span> Successfully."; MyAlertBox("SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", \"\");"); } else { msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "No Voucher(s) are selected to Approve."; } } catch (Exception ex) { string message = ex.Message; if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; } MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");"); } finally { journalVoucher = null; MyAlertBox("MyOverlayStop();"); } }
protected void saveButton_Click(object sender, EventArgs e) { JournalVoucherBLL journalVoucher = new JournalVoucherBLL(); payToFromCompanyDropDownList.Enabled = false; //payToFromTypeDropDownList.Enabled = false; //payToFromCompanyDropDownList.CausesValidation = false; try { DataTable dtJournalList = (DataTable)LumexSessionManager.Get("dtJournalList"); if (decimal.Parse(drAmtLabel.Text.Trim()) != decimal.Parse(crAmtLabel.Text.Trim())) { msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Total Debit & Credit Amount must be Same."; } else if (journalEntryListGridView.Rows.Count != dtJournalList.Rows.Count) { msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Total Journal Entry Mismatch."; } else { DataTable dt = journalVoucher.SaveJournalVoucher(drpdwnSalesCenterOrWarehouse.SelectedValue, dtJournalList); if (dt.Rows.Count > 0) { LumexSessionManager.Remove("dtJournalList"); string message = "Journal Voucher <span class='actionTopic'>Created</span> Successfully with Journal Number: <span class='actionTopic'>" + dt.Rows[0][0].ToString() + "</span>."; MyAlertBox("var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/AccUI/JournalVoucher/JournalVoucherList.aspx\"; }; SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", callbackOk);"); } else { string message = "<span class='actionTopic'>Failed</span> to Create Journal Voucher."; 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 { journalVoucher = null; } }
protected void approveButton_Click(object sender, EventArgs e) { JournalVoucherBLL journalVoucher = new JournalVoucherBLL(); try { if (drAmtLabel.Text.Trim() == crAmtLabel.Text.Trim()) { journalVoucher.ApproveJournalVoucherByJournal(numberLabel.Text.Trim()); string message = "Journal Voucher <span class='actionTopic'>Approved</span> Successfully."; MyAlertBox("var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/AccUI/JournalVoucher/JournalVoucherApprovalList.aspx\"; }; SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", callbackOk);"); } else { msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Total Debit & Credit Amount must be Same."; } } catch (Exception ex) { string message = ex.Message; if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; } MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");"); } finally { journalVoucher = null; } }