public Student Edit(Student entity) { try { using (var db = new ManagerContext()) { db.Entry(entity).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } } catch (Exception ex) { throw new Exception(ex.Message); } return(entity); }
public Student Add(Student entity) { try { using (var db = new ManagerContext()) { db.Students.Add(entity); db.SaveChanges(); } } catch (Exception ex) { throw new Exception(ex.Message); } return(entity); }
public Pwd Remove(Pwd entity) { try { using (var db = new ManagerContext()) { db.Pwds.Remove(entity); db.SaveChanges(); } } catch (Exception ex) { throw new Exception(ex.Message); } return(entity); }
public int GetCampusId() { int CampusId = (new Student()).CampusId; try { using (var db = new ManagerContext()) { CampusId = db.Students.ToList().Count == 0 ? CampusId : db.Students.Max(f => f.CampusId) + 1; } } catch (Exception ex) { throw new Exception(ex.Message); } return(CampusId); }
public Student Find(int CampusId) { Student pwd = null; try { using (var db = new ManagerContext()) { pwd = db.Students?.FirstOrDefault(f => f.CampusId == CampusId); } } catch (Exception ex) { throw new Exception(ex.Message); } return(pwd); }
public Pwd Find(int id) { Pwd pwd = null; try { using (var db = new ManagerContext()) { pwd = db.Pwds?.FirstOrDefault(f => f.Id == id) as Pwd; } } catch (Exception ex) { throw new Exception(ex.Message); } return(pwd); }
public IEnumerable <Student> FindAll(string fullname = null) { IEnumerable <Student> students = null; try { using (var db = new ManagerContext()) { fullname = fullname ?? ""; students = db.Students?.ToList().Where(f => f.Fullname.Trim().ToLower().Contains(fullname.Trim().ToLower())); } } catch (Exception ex) { throw new Exception(ex.Message); } return(students); }
public IEnumerable <Pwd> FindAll(string title = null) { IEnumerable <Pwd> Pwds = null; try { using (var db = new ManagerContext()) { title = title ?? ""; Pwds = db.Pwds?.ToList().Where(f => f.Title.Trim().ToLower().Contains(title.Trim().ToLower())); } } catch (Exception ex) { throw new Exception(ex.Message); } return(Pwds); }