private void ListBankBranch() { try { grdList.Rows.Clear(); BankBranchDB bankbranchdb = new BankBranchDB(); List <bankbranch> BankBranches = bankbranchdb.getBankBranches(); foreach (bankbranch branch in BankBranches) { grdList.Rows.Add(branch.BankID, branch.BranchName, branch.Address1, branch.Address2, branch.Address3, branch.IFSCCode, branch.SWIFTCode, branch.MICRCode, branch.BSRCode, ComboFIll.getStatusString(branch.status), branch.BranchID); } } catch (Exception) { MessageBox.Show("Error in Office listing"); } enableBottomButtons(); pnlList.Visible = true; }
private void btnRegionSave_Click_1(object sender, EventArgs e) { try { bankbranch branch = new bankbranch(); BankBranchDB bankbranchdb = new BankBranchDB(); //off.OfficeID = txtID.Text; try { branch.BankID = ((Structures.ComboBoxItem)cmbBank.SelectedItem).HiddenValue; branch.BankName = ((Structures.ComboBoxItem)cmbBank.SelectedItem).ToString(); //branch.BankID = cmbBank.SelectedItem.ToString().Trim().Substring(0, cmbBank.SelectedItem.ToString().Trim().IndexOf('-')); //branch.BankName = cmbBank.SelectedItem.ToString().Trim().Substring(cmbBank.SelectedItem.ToString().Trim().IndexOf('-') + 1); } catch (Exception) { branch.BankID = ""; branch.BankName = ""; } branch.BranchName = txtBranchName.Text; branch.Address1 = txtaddress1.Text; branch.Address2 = txtaddress2.Text; branch.Address3 = txtaddress3.Text; branch.IFSCCode = txtIFSCCode.Text; branch.SWIFTCode = txtSWIFTCode.Text; branch.MICRCode = txtMICRCode.Text; branch.BSRCode = txtBSRCode.Text; branch.status = ComboFIll.getStatusCode(cmbStatus.SelectedItem.ToString()); branch.BranchID = selectedRowID; System.Windows.Forms.Button btn = sender as System.Windows.Forms.Button; string btnText = btn.Text; if (bankbranchdb.validateBankBranch(branch)) { if (btnText.Equals("Update")) { if (bankbranchdb.updateBankBranch(branch)) { MessageBox.Show("Bank Branch updated"); closeAllPanels(); ListBankBranch(); } else { MessageBox.Show("Failed to update Bank Branch"); } } else if (btnText.Equals("Save")) { if (bankbranchdb.insertBankBranch(branch)) { MessageBox.Show("Bank Branch Added"); closeAllPanels(); ListBankBranch(); } else { MessageBox.Show("Failed to Insert Bank Branch"); } } } else { MessageBox.Show("Bank Branch Data Validation failed"); } } catch (Exception) { MessageBox.Show("Failed Adding / Editing Bank Branch"); } }