public ActionResult Edit([Bind(Include = "MaDD,TenDD,Khoa,NguoiTao,NgayTao,NguoiCapNhat,NgayCapNhat")] DM_DiaDiem dM_DiaDiem)
{
db.Configuration.LazyLoadingEnabled = false;
try
{
int d = db.DM_DiaDiem.Count(p => p.MaDD != dM_DiaDiem.MaDD && string.Compare(p.TenDD.Trim().Replace("\n", "").Replace("\r", ""), dM_DiaDiem.TenDD.Trim()) == 0);
if (d > 0)
{
ModelState.AddModelError("TenDD", $"Tên Địa điểm {dM_DiaDiem.TenDD} bị trùng.");
}
if (ModelState.IsValid)
{
List <SelectListItem> list = _Common.getThongTinBang();
dM_DiaDiem.NguoiCapNhat = list.Where(o => o.Value == "NguoiCapNhat").SingleOrDefault().Text;
dM_DiaDiem.NgayCapNhat = DateTime.Parse(list.Where(o => o.Value == "NgayCapNhat").SingleOrDefault().Text);
db.Entry(dM_DiaDiem).State = EntityState.Modified;
db.SaveChanges();
HT_LichSuHoatDong ls = new HT_LichSuHoatDong(
ChucNang
, "UPDATE"
, DateTime.Now, Session["username"]?.ToString()
, $" Cập nhật - tên địa điểm {dM_DiaDiem.TenDD} ");
db.HT_LichSuHoatDong.Add(ls);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(dM_DiaDiem));
}
catch (Exception ex)
{
string cauBaoLoi = "Lỗi ghi dữ liệu.<br/>Lý do:" + ex.Message;
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest, cauBaoLoi));
}
}
public ActionResult Delete(string id)
{
DM_DiaDiem dM_DiaDiem = db.DM_DiaDiem.Find(id);
db.DM_DiaDiem.Remove(dM_DiaDiem);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
db.Configuration.LazyLoadingEnabled = false;
DM_DiaDiem dM_DiaDiem = db.DM_DiaDiem.Find(id);
if (dM_DiaDiem == null)
{
return(HttpNotFound());
}
return(View(dM_DiaDiem));
}
public ActionResult Create([Bind(Include = "MaDD,TenDD,Khoa,NguoiTao,NgayTao,NguoiCapNhat,NgayCapNhat")] DM_DiaDiem dM_DiaDiem)
{
db.Configuration.LazyLoadingEnabled = false;
try
{
DM_DiaDiem dd = db.DM_DiaDiem.Find(dM_DiaDiem.MaDD);
if (dd != null)
{
ModelState.AddModelError("MaDD", $"Mã Địa điểm {dM_DiaDiem.MaDD} đã tồn tại");
}
int d = db.DM_DiaDiem.Count(p => string.Compare(p.TenDD.Trim().Replace("\n", "").Replace("\r", ""), dM_DiaDiem.TenDD.Trim()) == 0);
if (dd != null)
{
ModelState.AddModelError("TenDD", $"Tên Địa điểm {dM_DiaDiem.TenDD} đã tồn tại");
}
if (ModelState.IsValid)
{
List <SelectListItem> list = _Common.getThongTinBang();
dM_DiaDiem.NguoiTao = list.Where(o => o.Value == "NguoiTao").SingleOrDefault().Text;
dM_DiaDiem.NgayTao = DateTime.Parse(list.Where(o => o.Value == "NgayTao").SingleOrDefault().Text);
db.DM_DiaDiem.Add(dM_DiaDiem);
db.SaveChanges();
HT_LichSuHoatDong ls = new HT_LichSuHoatDong(
ChucNang
, "CREATE"
, DateTime.Now, Session["username"]?.ToString()
, $" Thêm mới - {dM_DiaDiem.TenDD} ");
db.HT_LichSuHoatDong.Add(ls);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(dM_DiaDiem));
}
catch (Exception ex)
{
string cauBaoLoi = "Không ghi được dữ liệu.<br/>Lý do: " + ex.Message;
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest, cauBaoLoi));
}
}
