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