public bool Delete(AcademicLevelEntity academicLevel) { try { TIMSDBEntities entity = new TIMSDBEntities(); tblAcademicLevel AcademicLevel = entity.tblAcademicLevels.Where(x => x.ID == academicLevel.ID).FirstOrDefault(); entity.tblAcademicLevels.Remove(AcademicLevel); entity.SaveChanges(); return(true); } catch (Exception) { throw; } }
public AcademicLevelEntity GetSingle(int ID) { try { TIMSDBEntities entity = new TIMSDBEntities(); tblAcademicLevel AcademicLevel = entity.tblAcademicLevels.Where(x => x.ID == ID).FirstOrDefault(); AcademicLevelEntity academicLevel = new AcademicLevelEntity(); academicLevel.ID = AcademicLevel.ID; academicLevel.Title = AcademicLevel.Title; return(academicLevel); } catch (Exception ex) { return(null); } }
public bool Save(AcademicLevelEntity academicLevel) { try { tblAcademicLevel AcademicLevel = new tblAcademicLevel(); AcademicLevel.ID = academicLevel.ID; AcademicLevel.Title = academicLevel.Title; TIMSDBEntities entity = new TIMSDBEntities(); entity.tblAcademicLevels.Add(AcademicLevel); entity.SaveChanges(); return(true); } catch (Exception) { throw; } }
public bool Update(AcademicLevelEntity academicLevel) { try { tblAcademicLevel newAcademicLevel = new tblAcademicLevel(); newAcademicLevel.ID = academicLevel.ID; newAcademicLevel.Title = academicLevel.Title; TIMSDBEntities entity = new TIMSDBEntities(); tblAcademicLevel oldAcademicLevel = entity.tblAcademicLevels.Where(x => x.ID == academicLevel.ID).FirstOrDefault(); entity.Entry(oldAcademicLevel).CurrentValues.SetValues(newAcademicLevel); entity.SaveChanges(); return(true); } catch (Exception) { throw; } }