/// <summary> /// Author: Phạm Huy Hùng /// Todo: cập nhật đối tượng /// </summary> /// <param name=""></param> /// <returns></returns>\ public void Update(TblChart o) { try { using (TkSchoolDbContext db = new TkSchoolDbContext()) { var res = db.TblCharts.Where(x => x.id == 1).SingleOrDefault(); res.src1 = o.src1; res.src2 = o.src2; res.src3 = o.src3; res.src4 = o.src4; res.src5 = o.src5; res.Status = o.Status; db.SaveChanges(); } } catch (Exception ex) { if (ex.InnerException == null) { throw new Exception("TblChartDao::Update::" + ex.Message); } else { throw new Exception("TblChartDao::Update::" + ex.InnerException.Message); } } }
public ActionResult TblChartUpdate(string src1, string src2, string src3, string src4, string src5) { try { TblChart o = new TblChart(); o.src1 = src1; o.src2 = src2; o.src3 = src3; o.src4 = src4; o.src5 = src5; new TblChartDao().Update(o); SetAlert("cập nhật thành công", "success"); return(RedirectToAction("TblChartUpdate")); } catch (Exception ex) { logger.Info(ControllerName + "::TblChartUpdate::" + ex.Message); return(RedirectToAction("Index", "Error")); } }
/// <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 TblChart FindById(TblChart o) { try { using (TkSchoolDbContext db = new TkSchoolDbContext()) { return(db.TblCharts.SingleOrDefault(x => x.id == o.id)); } } catch (Exception ex) { if (ex.InnerException == null) { throw new Exception("TblChartDao::FindById::" + ex.Message); } else { throw new Exception("TblChartDao::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(TblChart o) { try { using (TkSchoolDbContext db = new TkSchoolDbContext()) { db.TblCharts.Add(o); db.SaveChanges(); } } catch (Exception ex) { if (ex.InnerException == null) { throw new Exception("TblChartDao::Create::" + ex.Message); } else { throw new Exception("TblChartDao::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(TblChart o) { try { using (TkSchoolDbContext db = new TkSchoolDbContext()) { var res = db.TblCharts.Where(x => x.id == o.id).Single(); db.TblCharts.Remove(res); db.SaveChanges(); } } catch (Exception ex) { if (ex.InnerException == null) { throw new Exception("TblChartDao::Delete::" + ex.Message); } else { throw new Exception("TblChartDao::Delete::" + ex.InnerException.Message); } } }