private void btnSave_Click(object sender, EventArgs e)
{
TBL_MP_CRM_SalesQuestionnaire model = null;
ServiceSalesQuestionnaire service = new ServiceSalesQuestionnaire();
try
{
errorProvider1.Clear();
if (!this.ValidateChildren())
{
return;
}
if (this.QuestionnaireID == 0)
{
model = new TBL_MP_CRM_SalesQuestionnaire();
}
else
{
model = service.GetQuestionnaireDBRecord(this.QuestionnaireID);
}
model.FK_CategoryID = ((SelectListItem)cboCategory.SelectedItem).ID;
model.FK_RelatedToID = ((SelectListItem)cboRelatedTo.SelectedItem).ID;
model.Question = txtQuestionText.Text;
model.Implication = txtImplecationText.Text;
model.Solution = txtSolutionText.Text;
if (this.QuestionnaireID == 0)
{
this.QuestionnaireID = service.AddNewQuestionnaire(model);
}
else
{
service.UpdateQuestionnaire(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, "frmSO_Primary::btnSave_Click", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public TBL_MP_CRM_SalesQuestionnaire GetQuestionnaireDBRecord(int qID)
{
TBL_MP_CRM_SalesQuestionnaire model = null;
try
{
model = _dbContext.TBL_MP_CRM_SalesQuestionnaire.Where(x => x.PK_QuestionnaireID == qID).FirstOrDefault();
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "ServiceSalesQuestionnaire::GetQuestionnaireDBRecord" +
"", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(model);
}
public bool UpdateQuestionnaire(TBL_MP_CRM_SalesQuestionnaire model)
{
bool result = false;
try
{
TBL_MP_CRM_SalesQuestionnaire dbModel = _dbContext.TBL_MP_CRM_SalesQuestionnaire.Where(x => x.PK_QuestionnaireID == model.PK_QuestionnaireID).FirstOrDefault();
dbModel = model;
_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, "ServiceSalesQuestionnaire::UpdateQuestionnaire", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(result);
}
public int AddNewQuestionnaire(TBL_MP_CRM_SalesQuestionnaire model)
{
int newID = 0;
try
{
model.IsDeleted = false;
_dbContext.TBL_MP_CRM_SalesQuestionnaire.Add(model);
_dbContext.SaveChanges();
newID = model.PK_QuestionnaireID;
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "ServiceSalesQuestionnaire::AddNewQuestionnaire", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(newID);
}
public bool DeleteQuestionnaire(int questionID, int deletedBy)
{
try
{
TBL_MP_CRM_SalesQuestionnaire model = _dbContext.TBL_MP_CRM_SalesQuestionnaire.Where(x => x.PK_QuestionnaireID == questionID).FirstOrDefault();
if (model != null)
{
model.IsDeleted = true;
model.DeletedBy = deletedBy;
model.DeleteDateTime = AppCommon.GetServerDateTime();
_dbContext.SaveChanges();
}
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "ServiceSalesQuestionnaire::DeleteQuestionnaire", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(true);
}
public void ScatterData()
{
try
{
TBL_MP_CRM_SalesQuestionnaire model = (new ServiceSalesQuestionnaire()).GetQuestionnaireDBRecord(this.QuestionnaireID);
if (model != null)
{
cboCategory.SelectedItem = ((List <SelectListItem>)cboCategory.DataSource).Where(x => x.ID == selectedCategoryID).FirstOrDefault();
cboRelatedTo.SelectedItem = ((List <SelectListItem>)cboRelatedTo.DataSource).Where(x => x.ID == selectedRelatedToID).FirstOrDefault();
txtQuestionText.Text = model.Question;
txtImplecationText.Text = model.Implication;
txtSolutionText.Text = model.Solution;
}
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "frmAddEditQuestionnaire::ScatterData", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
