/// <summary> /// Author: Phạm Huy Hùng /// Todo: cập nhật đối tượng /// </summary> /// <param name=""></param> /// <returns></returns>\ public void Update(TblUserUnit o) { try { using (TkSchoolDbContext db = new TkSchoolDbContext()) { var res = db.TblUserUnits.Where(x => x.Id == o.Id).SingleOrDefault(); res.UserName = o.UserName; res.UnitId = o.UnitId; res.Status = o.Status; db.SaveChanges(); } } catch (Exception ex) { if (ex.InnerException == null) { throw new Exception("TblUserUnitDao::Update::" + ex.Message); } else { throw new Exception("TblUserUnitDao::Update::" + ex.InnerException.Message); } } }
/// <summary> /// Author: Phạm Huy Hùng /// Todo: tìm kiếm đối tượng theo khóa chính /// </summary> /// <param name="obj"></param> /// <returns></returns> public TblUserUnit FindById(TblUserUnit obj) { try { using (TkSchoolDbContext db = new TkSchoolDbContext()) { return(db.TblUserUnits.SingleOrDefault(x => x.Id == obj.Id)); } } catch (Exception ex) { if (ex.InnerException == null) { throw new Exception("TblUserUnitDao::FindById::" + ex.Message); } else { throw new Exception("TblUserUnitDao::FindByID::" + ex.InnerException.Message); } } }
/// <summary> /// Author: Phạm Huy Hùng /// Todo: tạo đối tượng mới /// </summary> /// <param name=""></param> /// <returns></returns> public void Create(TblUserUnit o) { try { using (TkSchoolDbContext db = new TkSchoolDbContext()) { db.TblUserUnits.Add(o); db.SaveChanges(); } } catch (Exception ex) { if (ex.InnerException == null) { throw new Exception("TblUserUnitDao::Create::" + ex.Message); } else { throw new Exception("TblUserUnitDao::Create::" + ex.InnerException.Message); } } }
/// <summary> /// Author: Phạm Huy Hùng /// Todo: xóa đối tượng /// </summary> /// <param name="o"></param> /// <returns></returns> public void Delete(TblUserUnit o) { try { using (TkSchoolDbContext db = new TkSchoolDbContext()) { var res = db.TblUserUnits.Where(x => x.Id == o.Id).SingleOrDefault(); db.TblUserUnits.Remove(res); db.SaveChanges(); } } catch (Exception ex) { if (ex.InnerException == null) { throw new Exception("TblUserUnitDao::Delete::" + ex.Message); } else { throw new Exception("TblUserUnitDao::Delete::" + ex.InnerException.Message); } } }