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