public bool UpdatePartyBankDetail(Tbl_MP_Master_Party_BankDetail model) { bool result = false; try { Tbl_MP_Master_Party_BankDetail dbModel = _dbContext.Tbl_MP_Master_Party_BankDetail.Where(x => x.PK_PartyBankID == model.PK_PartyBankID).FirstOrDefault(); if (dbModel != null) { dbModel.FK_PartyID = model.FK_PartyID; dbModel.FK_BankID = model.FK_BankID; dbModel.FK_BankBranchID = model.FK_BankBranchID; dbModel.FK_AccountType = model.FK_AccountType; dbModel.AccountNo = model.AccountNo; 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, "ServiceParties::UpdatePartyBankDetail", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(result); }
private void ScatterData() { try { Tbl_MP_Master_Party_BankDetail model = (new ServiceParties()).GetPartyBankDBRecordByPartyBankID(this.SelectedPartyBankID); if (model != null) { // you ahve to search for item from the combo and set it as selected...contine cboParties.SelectedItem = ((List <SelectListItem>)cboParties.DataSource).Where(x => x.ID == model.FK_PartyID).FirstOrDefault(); cboBankName.SelectedItem = ((List <SelectListItem>)cboBankName.DataSource).Where(x => x.ID == model.FK_BankID).FirstOrDefault(); cboBankBranchName.SelectedItem = ((List <SelectListItem>)cboBankBranchName.DataSource).Where(x => x.ID == model.FK_BankBranchID).FirstOrDefault(); cboAccountType.SelectedItem = ((List <SelectListItem>)cboAccountType.DataSource).Where(x => x.ID == model.FK_AccountType).FirstOrDefault(); txtAccountNo.Text = model.AccountNo; 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, "frmAddEditPartyBank::ScatterData", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnOK_Click(object sender, EventArgs e) { Tbl_MP_Master_Party_BankDetail model = null; try { if (!this.ValidateChildren()) { return; } if (this.SelectedPartyBankID == 0) { model = new Tbl_MP_Master_Party_BankDetail(); } else { model = (new ServiceParties()).GetPartyBankDBRecordByPartyBankID(this.SelectedPartyBankID); } //populate model from control model.FK_PartyID = ((SelectListItem)cboParties.SelectedItem).ID; model.FK_BankID = ((SelectListItem)cboBankName.SelectedItem).ID; model.FK_BankBranchID = ((SelectListItem)cboBankBranchName.SelectedItem).ID; model.FK_AccountType = ((SelectListItem)cboAccountType.SelectedItem).ID; model.AccountNo = txtAccountNo.Text.Trim(); model.IsActive = chkIsActive.Checked; if (this.SelectedPartyBankID == 0) { this.SelectedPartyBankID = (new ServiceParties()).AddNewPartyBankDetail(model); } else { (new ServiceParties()).UpdatePartyBankDetail(model); } this.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, "frmAddEditPartyBank::btnOK_Click", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public Tbl_MP_Master_Party_BankDetail GetPartyBankDBRecordByPartyBankID(int partybankID) { Tbl_MP_Master_Party_BankDetail model = null; try { model = _dbContext.Tbl_MP_Master_Party_BankDetail.Where(x => x.PK_PartyBankID == partybankID).FirstOrDefault(); } catch (Exception ex) { string errMessage = ex.Message; if (ex.InnerException != null) { errMessage += string.Format("\n{0}", ex.InnerException.Message); } MessageBox.Show(errMessage, "ServiceParties::GetPartyBankDBRecordByPartyBankID", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(model); }
public int AddNewPartyBankDetail(Tbl_MP_Master_Party_BankDetail model) { int newID = 0; try { model.IsActive = true; _dbContext.Tbl_MP_Master_Party_BankDetail.Add(model); _dbContext.SaveChanges(); newID = model.PK_PartyBankID; } catch (Exception ex) { string errMessage = ex.Message; if (ex.InnerException != null) { errMessage += string.Format("\n{0}", ex.InnerException.Message); } MessageBox.Show(errMessage, "ServiceParties::AddNewPartyBankDetail", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(newID); }