public Message Insert(Training_CertificationMaster objUI)
{
Message msg = null;
try
{
if (!isDublicateId(objUI))
{
objUI.CreateDate = DateTime.Now;
objUI.UpdateDate = DateTime.Now;
objUI.DeleteFlag = false;
dbContext.Training_CertificationMasters.InsertOnSubmit(objUI);
dbContext.SubmitChanges();
// Show success message
msg = new Message(MessageConstants.I0001, MessageType.Info, "Certification '" + objUI.Name + "'", "added");
}
else
{
msg = new Message(MessageConstants.E0020, MessageType.Error, "Name '" + objUI.Name + "'", "Certification");
}
}
catch (Exception ex)
{
msg = new Message(MessageConstants.E0007, MessageType.Error);
throw ex;
}
return msg;
}
private bool IsValidUpdateDate(Training_CertificationMaster objUI, Training_CertificationMaster 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, "Training Certification ID " + objDb.ID);
}
}
}
}
catch
{
throw;
}
return isValid;
}
private void Delete(Training_CertificationMaster objUI)
{
if (objUI != null)
{
// Get current group in dbContext
Training_CertificationMaster objDb = GetById(objUI.ID.ToString());
if (objDb != null)
{
// Set delete info
objDb.DeleteFlag = true;
objDb.UpdateDate = DateTime.Now;
objDb.UpdatedBy = objUI.UpdatedBy;
// Submit changes to dbContext
dbContext.SubmitChanges();
}
}
}
private bool isDublicateId(Training_CertificationMaster objUI)
{
bool isDublicateName = true;
Training_CertificationMaster dublicateName = dbContext.Training_CertificationMasters.Where(a => a.Name.Equals(objUI.Name) && a.DeleteFlag == false).FirstOrDefault<Training_CertificationMaster>();
if (dublicateName == null || dublicateName.ID == objUI.ID)
{
isDublicateName = false;
}
return isDublicateName;
}
public Message UpdateTrainingCertification(Training_CertificationMaster objUI)
{
Message msg = null;
try
{
if (objUI != null)
{
// Get current group in dbContext
Training_CertificationMaster objDb = GetById(objUI.ID.ToString());
if (objDb != null)
{
// Check valid update date
if (IsValidUpdateDate(objUI, objDb, out msg) && !isDublicateId(objUI))
{
// Update info by objUI
objDb.Name = objUI.Name;
objDb.Description = objUI.Description;
objDb.IsActive = objUI.IsActive;
objDb.UpdateDate = DateTime.Now;
objDb.UpdatedBy = objUI.UpdatedBy;
// Submit changes to dbContext
dbContext.SubmitChanges();
// Show success message
msg = new Message(MessageConstants.I0001, MessageType.Info, "Certification '" + objDb.Name + "'", "updated");
}
else
{
msg = new Message(MessageConstants.E0020, MessageType.Error, "'" + objUI.Name + "'", "Certification");
}
}
}
}
catch
{
// Show system error
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
return msg;
}
