public bool UpdateBankBranch(TBL_MP_Master_BankBranch model)
{
bool result = false;
try
{
TBL_MP_Master_BankBranch dbModel = _dbContext.TBL_MP_Master_BankBranch.Where(x => x.PK_BankBranchID == model.PK_BankBranchID).FirstOrDefault();
dbModel.BranchAddress = model.BranchAddress;
dbModel.BranchName = model.BranchName;
dbModel.FK_BankID = model.FK_BankID;
dbModel.FK_CityID = model.FK_CityID;
dbModel.FK_CountryID = model.FK_CountryID;
dbModel.FK_StateID = model.FK_StateID;
dbModel.IFSCCode = model.IFSCCode;
dbModel.IsActive = model.IsActive;
_dbContext.SaveChanges();
result = true;
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "ServiceBankMaster::UpdateBankBranch", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(result);
}
private void btnSave_Click(object sender, EventArgs e)
{
TBL_MP_Master_BankBranch model = null;
ServiceBankMaster _service = new ServiceBankMaster();
try
{
if (!this.ValidateChildren())
{
return;
}
if (this.BankBranchID == 0)
{
model = new TBL_MP_Master_BankBranch();
}
else
{
model = _service.GetBankBranchDbRecord(this.BankBranchID);
}
model.FK_BankID = this.BankID;
model.BranchName = txtBranchName.Text;
model.BranchAddress = txtBankBranchAddress.Text;
model.FK_CountryID = ((SelectListItem)cboBranchCountries.SelectedItem).ID;
model.FK_StateID = ((SelectListItem)cboBranchStates.SelectedItem).ID;
model.FK_CityID = ((SelectListItem)cboBranchCity.SelectedItem).ID;
model.IsActive = chkIsActive.Checked;
model.IFSCCode = txtBranchIFSCCode.Text;
if (this.BankBranchID == 0)
{
this.BankBranchID = _service.AddNewBankBranch(model);
}
else
{
_service.UpdateBankBranch(model);
}
DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "frmAddEditBankBranch::btnSave_Click", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void frmAddEditBankBranch_Load(object sender, EventArgs e)
{
try
{
PopulateBankBranchCountry();
if (BankBranchID == 0)
{
txtBranchName.Text = txtBankBranchAddress.Text = txtBranchIFSCCode.Text = string.Empty;
chkIsActive.Checked = true;
int indiaID = Program.LIST_DEFAULTS.Where(x => x.ID == (int)APP_DEFAULT_VALUES.DefaultCountryID).FirstOrDefault().DEFAULT_VALUE;
cboBranchCountries.SelectedItem = ((List <SelectListItem>)cboBranchCountries.DataSource).Where(x => x.ID == indiaID).FirstOrDefault();
PopulateBankBranchState();
if (this.BankID != 0)
{
TBL_MP_Master_Bank model = (new ServiceBankMaster()).GetBankDbRecord(this.BankID);
if (model != null)
{
this.Text = string.Format("{0} - ADD BRANCH", model.BankName);
}
}
}
else
{
TBL_MP_Master_BankBranch model = (new ServiceBankMaster()).GetBankBranchDbRecord(this.BankBranchID);
if (model != null)
{
txtBranchName.Text = model.BranchName;
txtBankBranchAddress.Text = model.BranchAddress;
txtBranchIFSCCode.Text = model.IFSCCode;
cboBranchCountries.SelectedItem = ((List <SelectListItem>)cboBranchCountries.DataSource).Where(x => x.ID == model.FK_CountryID).FirstOrDefault();
PopulateBankBranchState();
cboBranchStates.SelectedItem = ((List <SelectListItem>)cboBranchStates.DataSource).Where(x => x.ID == model.FK_StateID).FirstOrDefault();
PopulateBankBranchCity();
cboBranchCity.SelectedItem = ((List <SelectListItem>)cboBranchCity.DataSource).Where(x => x.ID == model.FK_CityID).FirstOrDefault();
chkIsActive.Checked = model.IsActive;
}
}
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "frmAddEditBankBranch::frmAddEditBankBranch_Load", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public int AddNewBankBranch(TBL_MP_Master_BankBranch model)
{
int newID = 0;
try
{
model.IsActive = true;
_dbContext.TBL_MP_Master_BankBranch.Add(model);
_dbContext.SaveChanges();
newID = model.PK_BankBranchID;
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "ServiceBankMaster::AddNewBankBranch", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(newID);
}
