public void Add(SchoolDBModel schoolDBModel) { var school = ToMode(schoolDBModel); using (JxxyContext jxxyContext = new JxxyContext()) { jxxyContext.Schools.Add(school); jxxyContext.SaveChanges(); } }
public List<SchoolDBModel> GetSchools() { using (JxxyContext jxxyContext = new JxxyContext()) { var dbSchools = (from school in jxxyContext.Schools orderby school.CreatedDate descending select school).ToList(); return FromModels(dbSchools); } }
public void Delete(string id) { using (JxxyContext jxxyContext = new JxxyContext()) { var schoolDB = (from school in jxxyContext.Schools where school.Id == id select school).FirstOrDefault(); jxxyContext.Schools.Remove(schoolDB); jxxyContext.SaveChanges(); } }
public TeacherDBModel GetTeacher(string userName) { using (JxxyContext jxxyContext = new JxxyContext()) { var dbTeacher = (from teacher in jxxyContext.Teachers where teacher.LoginName == userName select teacher).FirstOrDefault(); if(dbTeacher != null) { return FromMode(dbTeacher); } return null; } }
public SchoolDBModel GetSchoolById(string id) { using (JxxyContext jxxyContext = new JxxyContext()) { var dbSchool = (from school in jxxyContext.Schools where school.Id == id select school).FirstOrDefault(); if (dbSchool != null) { return FromModel(dbSchool); } return null; } }
public void Update(SchoolDBModel schoolDBModel) { using (JxxyContext jxxyContext = new JxxyContext()) { var schoolDB = (from school in jxxyContext.Schools where school.Id == schoolDBModel.Id select school).FirstOrDefault(); schoolDB.Name = schoolDBModel.Name; schoolDB.Address = schoolDBModel.Address; schoolDB.Remark = schoolDBModel.Remark; schoolDB.UpdatedBy = schoolDBModel.UpdatedBy; schoolDB.UpdatedDate = DateTime.Now; jxxyContext.SaveChanges(); } }