protected void GetBankBranchById(string bankBranchId) { BankBranchBLL bankBranch = new BankBranchBLL(); try { DataTable dt = bankBranch.GetBankBranchById(bankBranchId); if (dt.Rows.Count > 0) { bankBranchNameForUpdateHiddenField.Value = bankBranchNameTextBox.Text = dt.Rows[0]["BranchName"].ToString(); descriptionTextBox.Text = dt.Rows[0]["Description"].ToString(); bankDropDownList.SelectedValue = dt.Rows[0]["BankId"].ToString(); } else { msgbox.Visible = true; msgTitleLabel.Text = "Bank Branch Data Not Found!!!"; msgDetailLabel.Text = ""; msgbox.Attributes.Add("class", "alert alert-warning"); } } catch (Exception ex) { string message = "Somethings goes wrong in get Branch By ID"; if (ex.InnerException != null) { message += " --> Somethings goes wrong in get Branch by ID "; } MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");"); } finally { bankBranch = null; } }
protected void GetBankBranchList() { BankBranchBLL bankBranch = new BankBranchBLL(); try { DataTable dt = bankBranch.GetBankBranchList(); bankBranchListGridView.DataSource = dt; bankBranchListGridView.DataBind(); if (bankBranchListGridView.Rows.Count > 0) { bankBranchListGridView.UseAccessibleHeader = true; bankBranchListGridView.HeaderRow.TableSection = TableRowSection.TableHeader; } else { msgbox.Visible = true; msgTitleLabel.Text = "Bank Branch List Data Not Found!!!"; msgDetailLabel.Text = ""; msgbox.Attributes.Add("class", "alert alert-warning"); } } catch (Exception ex) { string message = "Somethings goes wrong in get Brach List"; if (ex.InnerException != null) { message += " --> Somethings goes wrong in get Branch List"; } MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");"); } finally { bankBranch = null; } }
protected void saveButton_Click(object sender, EventArgs e) { BankBranchBLL bankBranch = new BankBranchBLL(); try { if (bankDropDownList.SelectedValue == "") { msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Bank Name field is required."; } else if (bankBranchNameTextBox.Text.Trim() == "") { msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Bank Branch Name field is required."; } else if (descriptionTextBox.Text.Trim() == "") { msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Description field is required."; } else { bankBranch.BankId = bankDropDownList.SelectedValue.Trim(); bankBranch.BankBranchName = bankBranchNameTextBox.Text.Trim(); bankBranch.Description = descriptionTextBox.Text.Trim(); if (!bankBranch.CheckDuplicateBankBranch(bankBranch.BankId.Trim(), bankBranch.BankBranchName.Trim())) { DataTable dt = bankBranch.SaveBankBranch(); if (dt.Rows.Count > 0) { string message = "Bank Branch <span class='actionTopic'>Created</span> Successfully with Bank Branch ID: <span class='actionTopic'>" + dt.Rows[0][0].ToString() + "</span>."; MyAlertBox("var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/AccUI/BankBranch/List.aspx\"; }; SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", callbackOk);"); } else { string message = "<span class='actionTopic'>Failed</span> to Create Bank Branch."; MyAlertBox("ErrorAlert(\"" + "Process Failed" + "\", \"" + message + "\");"); } } else { string message = "This Bank Branch Name <span class='actionTopic'>already exist</span>, try another one."; MyAlertBox("WarningAlert(\"" + "Data Duplicate" + "\", \"" + message + "\");"); } } } catch (Exception ex) { string message = "Somethings goes wrong in Save"; if (ex.InnerException != null) { message += " --> Somethings goes wrong in Page Load"; } MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");"); } finally { bankBranch = null; } }
protected void deletedListButton_Click(object sender, EventArgs e) { BankBranchBLL bankBranch = new BankBranchBLL(); try { 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 fromDate = LumexLibraryManager.ParseAppDate(fromDateTextBox.Text.Trim()); string toDate = LumexLibraryManager.ParseAppDate(toDateTextBox.Text.Trim()); DataTable dt = bankBranch.GetDeletedBankBranchListByDateRangeAll(fromDate, toDate, ""); deletedListGridView.DataSource = dt; deletedListGridView.DataBind(); if (deletedListGridView.Rows.Count > 0) { deletedListGridView.UseAccessibleHeader = true; deletedListGridView.HeaderRow.TableSection = TableRowSection.TableHeader; } else { msgbox.Visible = true; msgTitleLabel.Text = "Deleted Bank Branch List Data Not Found!!!"; msgDetailLabel.Text = ""; msgbox.Attributes.Add("class", "alert alert-info"); } } } catch (Exception ex) { string message = "Somethings goes wrong in Delete"; if (ex.InnerException != null) { message += " --> Somethings goes wrong in Delete "; } MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");"); } finally { bankBranch = null; MyAlertBox("MyOverlayStop();"); } }
public DataTable SaveBankBranch(BankBranchBLL bankBranch, LumexDBPlayer db) { try { db.AddParameters("@BankId", bankBranch.BankId.Trim()); db.AddParameters("@BankBranchName", bankBranch.BankBranchName.Trim()); db.AddParameters("@Description", bankBranch.Description.Trim()); db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString()); db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal()); DataTable dt = db.ExecuteDataTable("INSERT_BANK_BRANCH", true); return dt; } catch (Exception) { throw; } finally { bankBranch = null; } }
protected void activateLinkButton_Click(object sender, EventArgs e) { try { LinkButton lnkBtn = (LinkButton)sender; GridViewRow row = (GridViewRow)lnkBtn.NamingContainer; BankBranchBLL bankBranch = new BankBranchBLL(); bankBranch.UpdateBankBranchActivation(bankBranchListGridView.Rows[row.RowIndex].Cells[0].Text.ToString(), "True"); bankBranchListGridView.Rows[row.RowIndex].Cells[4].Text = "True"; string message = "Bank Branch <span class='actionTopic'>Activated</span> Successfully."; MyAlertBox("SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", \"\");"); } catch (Exception ex) { string message = "Somethings goes wrong in Activate"; if (ex.InnerException != null) { message += " --> Somethings goes wrong in Activate "; } MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");"); } }
public void UpdateBankBranch(BankBranchBLL bankBranch, LumexDBPlayer db) { try { db.AddParameters("@BankBranchId", bankBranch.BankBranchId.Trim()); db.AddParameters("@BankBranchName", bankBranch.BankBranchName.Trim()); db.AddParameters("@Description", bankBranch.Description.Trim()); db.AddParameters("@ModifiedBy", LumexSessionManager.Get("ActiveUserId").ToString()); db.AddParameters("@ModifiedFrom", LumexLibraryManager.GetTerminal()); db.ExecuteNonQuery("UPDATE_BANK_BRANCH_BY_ID", true); } catch (Exception) { throw; } finally { bankBranch = null; } }
protected void updateButton_Click(object sender, EventArgs e) { BankBranchBLL bankBranch = new BankBranchBLL(); try { if (bankBranchIdForUpdateHiddenField.Value.Trim() == "") { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Bank Branch not found to update."; } else if (bankBranchNameTextBox.Text.Trim() == "") { msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Bank Branch Name field is required."; } else if (descriptionTextBox.Text.Trim() == "") { msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Description field is required."; } else { bankBranch.BankId = bankDropDownList.SelectedValue.Trim(); bankBranch.BankBranchId = bankBranchIdForUpdateHiddenField.Value.Trim(); bankBranch.BankBranchName = bankBranchNameTextBox.Text.Trim(); bankBranch.Description = descriptionTextBox.Text.Trim(); if (!bankBranch.CheckDuplicateBankBranch(bankBranch.BankId, bankBranchNameTextBox.Text.Trim())) { bankBranch.UpdateBankBranch(); bankBranchNameForUpdateHiddenField.Value = ""; bankBranchIdForUpdateHiddenField.Value = ""; string message = "Bank Branch <span class='actionTopic'>Updated</span> Successfully."; MyAlertBox("var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/AccUI/BankBranch/List.aspx\"; }; SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", callbackOk);"); } else { if (bankBranchNameForUpdateHiddenField.Value == bankBranchNameTextBox.Text.Trim()) { bankBranch.BankBranchName = "WithOut"; bankBranch.UpdateBankBranch(); bankBranchNameForUpdateHiddenField.Value = ""; bankBranchIdForUpdateHiddenField.Value = ""; string message = "Bank Branch <span class='actionTopic'>Updated</span> Successfully."; MyAlertBox("var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/AccUI/BankBranch/List.aspx\"; }; SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", callbackOk);"); } else { string message = "This Bank Branch Name <span class='actionTopic'>already exist</span>, try another one."; MyAlertBox("WarningAlert(\"" + "Data Duplicate" + "\", \"" + message + "\");"); } } } } catch (Exception ex) { string message = "Somethings goes wrong in Update"; if (ex.InnerException != null) { message += " --> Somethings goes wrong in Update"; } MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");"); } finally { bankBranch = null; } }