/// <summary>
/// Check update date whether is valid
/// </summary>
/// <param name="objUI"></param>
/// <param name="objDb"></param>
/// <param name="msg"></param>
/// <returns></returns>
private bool IsValidExamUpdateDate(JobTitleLevel objUI, JobTitleLevel objDb, out Message msg)
{
bool isValid = false;
msg = null;
try
{
if ((objUI != null) && (objUI.UpdateDate != null))
{
if (objDb != null)
{
if (objDb.UpdateDate.ToString().Equals(objUI.UpdateDate.ToString()))
{
isValid = true;
}
else
{
msg = new Message(MessageConstants.E0025, MessageType.Error, "Job Title Level '" + objDb.DisplayName + "'");
}
}
}
}
catch
{
throw;
}
return isValid;
}
/// <summary>
/// Update
/// </summary>
/// <param name="objUI"></param>
/// <returns></returns>
public Message Update(JobTitleLevel objUI)
{
Message msg = null;
try
{
if (objUI != null)
{
JobTitleLevel objDB = GetById(objUI.ID);
if (IsValidExamUpdateDate(objUI, objDB, out msg))
{
objDB.JobTitleId = objUI.JobTitleId;
objDB.JobLevel = objUI.JobLevel;
objDB.DisplayName = objUI.DisplayName;
objDB.IsActive = objUI.IsActive;
// Set more info
objDB.UpdateDate = DateTime.Now;
objDB.UpdatedBy = objUI.UpdatedBy;
dbContext.SubmitChanges();
msg = new Message(MessageConstants.I0001, MessageType.Info, "Job Title Level '" + objUI.DisplayName + "'", "updated");
}
}
}
catch (Exception)
{
// Show system error
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
return msg;
}
/// <summary>
/// Delete by set DeleteFlag = true
/// </summary>
/// <param name="objUI"></param>
private Message Delete(JobTitleLevel objUI)
{
Message msg = null;
try
{
if (objUI != null)
{
JobTitleLevel objDb = GetById(objUI.ID);
if (objDb != null)
{
if (IsValidDeleteJobTitleLevel(objDb.ID))
{
// Set delete info
objDb.DeleteFlag = true;
objDb.UpdateDate = DateTime.Now;
objDb.UpdatedBy = objUI.UpdatedBy;
dbContext.SubmitChanges();
msg = new Message(MessageConstants.I0001, MessageType.Info, "Job Title Level", "deleted");
}
else
{
msg = new Message(MessageConstants.E0006, MessageType.Error, "delete", "it");
}
}
else
{
msg = new Message(MessageConstants.E0006, MessageType.Error, "delete", "it");
}
// Submit changes to dbContext
dbContext.SubmitChanges();
}
}
catch
{
msg = new Message(MessageConstants.E0006, MessageType.Error, "delete", "it");
}
return msg;
}
/// <summary>
/// Insert to database
/// </summary>
/// <param name="objUI"></param>
/// <returns></returns>
public Message Insert(JobTitleLevel objUI)
{
Message msg = null;
try
{
if (objUI != null)
{
// Set more info
objUI.DeleteFlag = false;
dbContext.JobTitleLevels.InsertOnSubmit(objUI);
dbContext.SubmitChanges();
msg = new Message(MessageConstants.I0001, MessageType.Info, "Job Title Level '" + objUI.DisplayName + "'", "added");
}
}
catch (Exception)
{
// Show system error
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
return msg;
}
