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