public int Delete(int JobCategoryQualificationID, int UserIdentity) { try { using (var db = new HCMEntities()) { JobsCategoriesQualifications JobCategoryQualification = db.JobsCategoriesQualifications.SingleOrDefault(x => x.JobCategoryQualificationID.Equals(JobCategoryQualificationID)); db.JobsCategoriesQualifications.Remove(JobCategoryQualification); return(db.SaveChanges(UserIdentity)); } } catch { throw; } }
public int Update(JobsCategoriesQualifications JobCategoryQualification) { try { using (var db = new HCMEntities()) { JobsCategoriesQualifications JobCategoryQualificationObj = db.JobsCategoriesQualifications.SingleOrDefault(x => x.JobCategoryQualificationID.Equals(JobCategoryQualification.JobCategoryQualificationID)); JobCategoryQualificationObj.JobCategoryQualificationID = JobCategoryQualification.JobCategoryQualificationID; JobCategoryQualificationObj.JobCategoryID = JobCategoryQualification.JobCategoryID; JobCategoryQualificationObj.GeneralSpecializationID = JobCategoryQualification.GeneralSpecializationID; JobCategoryQualificationObj.QualificationDegreeID = JobCategoryQualification.QualificationDegreeID; JobCategoryQualificationObj.QualificationID = JobCategoryQualification.QualificationID; JobCategoryQualificationObj.IsMinQualification = JobCategoryQualification.IsMinQualification; JobCategoryQualificationObj.LastUpdatedDate = DateTime.Now; JobCategoryQualificationObj.LastUpdatedBy = JobCategoryQualification.LastUpdatedBy; return(db.SaveChanges()); } } catch { throw; } }
public int Insert(JobsCategoriesQualifications JobCategoryQualification) { try { using (var db = new HCMEntities()) { db.JobsCategoriesQualifications.Add(JobCategoryQualification); db.SaveChanges(); return(JobCategoryQualification.JobCategoryQualificationID); } } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } }