public bool DeleteCheckListItem(int itemID) { bool result = false; try { CheckList_Master dbModel = _dbContext.CheckList_Master.Where(x => x.PK_ItemID == itemID).FirstOrDefault(); if (dbModel != null) { dbModel.IsDeleted = 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, "ServiceCheckListMaster::DeleteCheckListItem", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(result); }
public bool UpdateCheckListItem(CheckList_Master model) { bool result = false; try { CheckList_Master dbModel = _dbContext.CheckList_Master.Where(x => x.PK_ItemID == model.PK_ItemID).FirstOrDefault(); if (dbModel != null) { dbModel.FK_CheckPointID = model.FK_CheckPointID; dbModel.Description = model.Description; _dbContext.SaveChanges(); } } catch (Exception ex) { string errMessage = ex.Message; if (ex.InnerException != null) { errMessage += string.Format("\n{0}", ex.InnerException.Message); } MessageBox.Show(errMessage, "ServiceCheckListMaster::UpdateCheckListItem", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(result); }
private void btnSave_Click(object sender, EventArgs e) { CheckList_Master model = null; ServiceCheckListMaster service = new ServiceCheckListMaster(); try { if (!this.ValidateChildren()) { return; } if (this.ItemID == 0) { model = new CheckList_Master(); } else { model = service.GetCheckListItemDBInfo(this.ItemID); } #region GATHER DATA INTO MODEL FROM VIEW model.FK_CheckPointID = ((SelectListItem)cboCheckPoints.SelectedItem).ID; model.Description = txtDescription.Text.Trim(); #endregion if (this.ItemID == 0) { this.ItemID = service.AddNewCheckListItem(model); } else { service.UpdateCheckListItem(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, "frmAddEditCheckList::btnSave_Click", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public CheckList_Master GetCheckListItemDBInfo(int id) { CheckList_Master model = null; try { model = _dbContext.CheckList_Master.Where(x => x.PK_ItemID == id).FirstOrDefault(); } catch (Exception ex) { string errMessage = ex.Message; if (ex.InnerException != null) { errMessage += string.Format("\n{0}", ex.InnerException.Message); } MessageBox.Show(errMessage, "ServiceCheckListMaster::GetCheckListItemDBInfo", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(model); }
private void ScatterData() { try { CheckList_Master item = (new ServiceCheckListMaster()).GetCheckListItemDBInfo(this.ItemID); if (item != null) { cboCheckPoints.SelectedItem = ((List <SelectListItem>)cboCheckPoints.DataSource).Where(x => x.ID == item.FK_CheckPointID).FirstOrDefault(); txtDescription.Text = item.Description; } } catch (Exception ex) { string errMessage = ex.Message; if (ex.InnerException != null) { errMessage += string.Format("\n{0}", ex.InnerException.Message); } MessageBox.Show(errMessage, "frmAddEditCheckList::ScatterData", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public int AddNewCheckListItem(CheckList_Master model) { int newID = 0; try { model.IsDeleted = false; _dbContext.CheckList_Master.Add(model); _dbContext.SaveChanges(); newID = model.PK_ItemID; } catch (Exception ex) { string errMessage = ex.Message; if (ex.InnerException != null) { errMessage += string.Format("\n{0}", ex.InnerException.Message); } MessageBox.Show(errMessage, "ServiceCheckListMaster::AddNewCheckListItem", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(newID); }