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);
}
