public void Delete(Training_NonEmpCertification objUI)
{
if (objUI != null)
{
Training_NonEmpCertification objDb = GetNonEmCertificationByID(objUI.ID);
if (objDb != null)
{
objDb.DeleteFlag = true;
dbContext.SubmitChanges();
}
}
}
public void UpdateNonEmployeeCert(Training_NonEmpCertification objUI)
{
Training_NonEmpCertification objDB = GetNonEmCertificationByID(objUI.ID);
if (objDB != null)
{
//objDB.CreateDate = objUI.CreateDate;
//objDB.CreatedBy = objUI.CreatedBy;
objDB.DeleteFlag = objUI.DeleteFlag;
objDB.ExpireDate = objUI.ExpireDate;
objDB.NonEmpId = objUI.NonEmpId;
objDB.Notes = objUI.Notes;
objDB.Score = objUI.Score;
objDB.TypeId = objUI.TypeId;
objDB.UpdateDate = objUI.UpdateDate;
objDB.UpdatedBy = objUI.UpdatedBy;
dbContext.SubmitChanges();
}
}
public Message Update(Training_NonEmpCertification objUI, List<Training_NonEmpCertification> oldList, List<Training_NonEmpCertification> newList)
{
Message msg = null;
DbTransaction trans = null;
try
{
dbContext.Connection.Open();
trans = dbContext.Connection.BeginTransaction();
dbContext.Transaction = trans;
if (objUI != null)
{
Training_NonEmpCertification objDB = GetNonEmCertificationByNonEmpID(objUI.ID);
if (objDB != null)
{
//if (oldList.Count > 0)
//{
string oldCertID = string.Empty;
foreach (Training_NonEmpCertification item in oldList)
{
UpdateNonEmployeeCert(item);
oldCertID += item.ID + ",";
}
foreach (Training_NonEmpCertification deleteItem in GetOldListNonCertByID(objDB.NonEmpId))
{
if (!oldCertID.TrimEnd(',').Split(',').Contains(deleteItem.ID.ToString()))
{
Delete(deleteItem);
}
}
dbContext.SubmitChanges();
msg = new Message(MessageConstants.I0001, MessageType.Info,
objUI.NonEmployee.FirstName + " "
+ objUI.NonEmployee.MiddleName == null ? string.Empty : objUI.NonEmployee.MiddleName + " "
+ objUI.NonEmployee.LastName + "'s certification", "updated");
}
if (newList.Count > 0)
{
Insert(newList);
msg = new Message(MessageConstants.I0001, MessageType.Info,
objUI.NonEmployee.FirstName + " "
+ (objUI.NonEmployee.MiddleName == null ? string.Empty : objUI.NonEmployee.MiddleName) + " "
+ objUI.NonEmployee.LastName + "'s certification", "updated");
}
trans.Commit();
}
}
catch (Exception)
{
if (trans != null) trans.Rollback();
// Show system error
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
return msg;
}
public Message InsertCert(Training_NonEmpCertification objUI)
{
Message msg = null;
try
{
dbContext.Training_NonEmpCertifications.InsertOnSubmit(objUI);
dbContext.SubmitChanges();
msg = new Message(MessageConstants.I0001, MessageType.Info, "Certification '" + objUI.NonEmpId + "'", "added");
}
catch (Exception ex)
{
throw ex;
}
return msg;
}
