public bool UpdateTermAndCondition(TBL_MP_Master_TnC model)
{
bool result = false;
try
{
TBL_MP_Master_TnC objTerm = _dbContext.TBL_MP_Master_TnC.Where(x => x.PK_TermID == model.PK_TermID).FirstOrDefault();
if (objTerm != null)
{
objTerm.Term_CategoryID = model.Term_CategoryID;
objTerm.Term_Description = model.Term_Description;
objTerm.Term_TitleID = model.Term_TitleID;
objTerm.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, "ServiceTermsAndConditions::UpdateTermAndCondition", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(result);
}
public bool ActivateTermAndCondition(int termID)
{
bool result = false;
try
{
TBL_MP_Master_TnC model = _dbContext.TBL_MP_Master_TnC.Where(x => x.PK_TermID == termID).FirstOrDefault();
if (model != null)
{
model.IsActive = true;
_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, "ServiceTermsAndConditions::ActivateTermAndCondition", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(result);
}
public int AddNewTermAndCondition(TBL_MP_Master_TnC model)
{
int newID = 0;
try
{
TBL_MP_Master_TnC newTerm = new TBL_MP_Master_TnC();
newTerm.Term_CategoryID = model.Term_CategoryID;
newTerm.Term_Description = model.Term_Description;
newTerm.Term_TitleID = model.Term_TitleID;
newTerm.IsActive = model.IsActive;
_dbContext.TBL_MP_Master_TnC.Add(newTerm);
_dbContext.SaveChanges();
newID = newTerm.PK_TermID;
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "ServiceTermsAndConditions::AddNewTermAndCondition", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(newID);
}
private void btnSave_Click(object sender, EventArgs e)
{
this.Cursor = Cursors.WaitCursor;
TBL_MP_Master_TnC dbModel = null;
try
{
errorProvider1.Clear();
if (this.ValidateChildren())
{
if (this.TermID == 0)
{
dbModel = new TBL_MP_Master_TnC()
{
Term_Description = txtDescription.Text.Trim(),
Term_TitleID = ((SelectListItem)(cboTitles.SelectedItem)).ID,
Term_CategoryID = ((SelectListItem)(cboCategories.SelectedItem)).ID,
IsActive = chkIsActive.Checked
};
this.TermID = (new ServiceTermsAndConditions()).AddNewTermAndCondition(dbModel);
if (this.TermID != 0)
{
this.DialogResult = DialogResult.OK;
}
}
else
{
dbModel = (new ServiceTermsAndConditions()).GetTermConditionItemDBRecordByID(this.TermID);
if (dbModel != null)
{
dbModel.Term_Description = txtDescription.Text.Trim();
dbModel.Term_TitleID = ((SelectListItem)(cboTitles.SelectedItem)).ID;
dbModel.Term_CategoryID = ((SelectListItem)(cboCategories.SelectedItem)).ID;
dbModel.IsActive = chkIsActive.Checked;
bool res = (new ServiceTermsAndConditions()).UpdateTermAndCondition(dbModel);
if (res)
{
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, "frmAddEditTermsAndCondition::btnSave_Click", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
this.Cursor = Cursors.Default;
}
private void frmAddEditTermsAndCondition_Load(object sender, EventArgs e)
{
try
{
txtDescription.Text = string.Empty;
chkIsActive.Checked = true;
PopulateTnCCategoriesDropdown();
PopulateTnCTitlesDropdown();
if (this.CategoryID != 0)
{
cboCategories.SelectedItem = ((List <SelectListItem>)cboCategories.DataSource).Where(X => X.ID == this.CategoryID).FirstOrDefault();
}
this.Text = "TERM & CONDITION - [ADD NEW]";
if (this.TermID != 0)
{
TBL_MP_Master_TnC objTerm = (new ServiceTermsAndConditions()).GetTermConditionItemDBRecordByID(this.TermID);
if (objTerm != null)
{
txtDescription.Text = objTerm.Term_Description;
cboCategories.SelectedItem = ((List <SelectListItem>)cboCategories.DataSource).Where(x => x.ID == objTerm.Term_CategoryID).FirstOrDefault();
cboTitles.SelectedItem = ((List <SelectListItem>)cboTitles.DataSource).Where(x => x.ID == objTerm.Term_TitleID).FirstOrDefault();
chkIsActive.Checked = objTerm.IsActive;
}
this.Text = "TERM & CONDITION - [EDIT]";
}
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "frmAddEditTermsAndCondition::frmAddEditTermsAndCondition_Load", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}