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