public ActionResult Create([Bind(Include = "MAKHU,TENKHU,MOTAKHAC")] KHUNHA kHUNHA) { if (ModelState.IsValid) { db.KHUNHAs.Add(kHUNHA); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(kHUNHA)); }
public ActionResult Create([Bind(Include = "MADGNUOC,DONGIANUOC")] DGNUOC dGNUOC) { if (ModelState.IsValid) { db.DGNUOCs.Add(dGNUOC); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(dGNUOC)); }
public ActionResult Create([Bind(Include = "MADGDIEN,DONGIADIEN")] DGDIEN dGDIEN) { if (ModelState.IsValid) { db.DGDIENs.Add(dGDIEN); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(dGDIEN)); }
public ActionResult Create([Bind(Include = "MAHOADON,MAPHONG,MAQL,THANG,NAM,CHISODIENCU,CHISODIENMOI,MADGDIEN,TIENDIEN,CHISONUOCCU,CHISONUOCMOI,MADGNUOC,TIENNUOC,TONGTIEN,TRANGTHAITHANHTOAN")] HDDIENNUOC hDDIENNUOC) { if (ModelState.IsValid) { db.HDDIENNUOCs.Add(hDDIENNUOC); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.MADGDIEN = new SelectList(db.DGDIENs, "MADGDIEN", "MADGDIEN", hDDIENNUOC.MADGDIEN); ViewBag.MADGNUOC = new SelectList(db.DGNUOCs, "MADGNUOC", "MADGNUOC", hDDIENNUOC.MADGNUOC); ViewBag.MAPHONG = new SelectList(db.PHONGs, "MAPHONG", "MAKHU", hDDIENNUOC.MAPHONG); ViewBag.MAQL = new SelectList(db.QUANLies, "MAQL", "MATKHAU", hDDIENNUOC.MAQL); return(View(hDDIENNUOC)); }
public void UpdateSoChoTrong(string id) { var phong = db.PHONGs.Find(id); phong.SOCHOTRONG = phong.SOCHOTRONG - 1; db.SaveChanges(); }
public ActionResult Edit([Bind(Include = "MASV,MATKHAU,HOTENLOT,TEN,HOVATEN,NGAYSINH,GIOITINH,DIACHI,CMND,SDT,LOP,KHOA,ANH,SVNOITRU")] SINHVIEN sINHVIEN) { if (ModelState.IsValid) { db.Entry(sINHVIEN).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(sINHVIEN)); }
public ActionResult Edit([Bind(Include = "MATHANNHAN,MASV,HOTENCHA,NGHENGHIEPCHA,SDTCHA,HOTENME,NGHENGHIEPME,SDTME,THANNHANSVNT")] THANNHAN tHANNHAN) { if (ModelState.IsValid) { db.Entry(tHANNHAN).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.MASV = new SelectList(db.SINHVIENs, "MASV", "MASV", tHANNHAN.MASV); return(View(tHANNHAN)); }
public ActionResult Create([Bind(Include = "MAKHU,TENKHU,MOTAKHAC")] KHUNHA kHUNHA) { var dao = new AdminDao(); if (ModelState.IsValid) { if (dao.insertKhuNha(kHUNHA.MAKHU)) { db.KHUNHAs.Add(kHUNHA); db.SaveChanges(); return(RedirectToAction("Index")); } else { ModelState.AddModelError("", "Mã khu nhà đã tồn tại!"); } } return(View(kHUNHA)); }
public ActionResult Create([Bind(Include = "MAPHONG,SOPHONG,MAKHU,SOLUONGSV,GIAPHONG,SOCHOTRONG,MOTAKHAC,TRANGTHAI")] PHONG pHONG) { var dao = new AdminDao(); if (ModelState.IsValid) { if (dao.insertPhong(pHONG.MAPHONG)) { db.PHONGs.Add(pHONG); db.SaveChanges(); return(RedirectToAction("Index")); } else { ModelState.AddModelError("", "Mã phòng đã tồn tại!"); } } ViewBag.MAKHU = new SelectList(db.KHUNHAs, "MAKHU", "TENKHU", pHONG.MAKHU); return(View(pHONG)); }
public ActionResult Edit([Bind(Include = "MAHOPDONG,MASV,MAPHONG,NGAYLAP,NGAYBATDAU,NGAYKETTHUC,HIEULUCHD")] HOPDONG hOPDONG) { if (ModelState.IsValid) { db.Entry(hOPDONG).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.MAPHONG = new SelectList(db.PHONGs, "MAPHONG", "MAKHU", hOPDONG.MAPHONG); ViewBag.MASV = new SelectList(db.SINHVIENs, "MASV", "MATKHAU", hOPDONG.MASV); return(View(hOPDONG)); }
public ActionResult Edit([Bind(Include = "MASV,MATKHAU,HOTENLOT,TEN,HOVATEN,NGAYSINH,GIOITINH,DIACHI,CMND,SDT,LOP,KHOA,ANH,SVNOITRU")] SINHVIEN sINHVIEN) { if (ModelState.IsValid) { sINHVIEN.SVNOITRU = true; sINHVIEN.MATKHAU = sINHVIEN.MATKHAU; db.Entry(sINHVIEN).State = EntityState.Modified; db.SaveChanges(); } return(RedirectToAction("Create", "THANNHANs", new { Area = "Student" })); //return View(sINHVIEN); }
public ActionResult Create([Bind(Include = "MATHANNHAN,MASV,HOTENCHA,NGHENGHIEPCHA,SDTCHA,HOTENME,NGHENGHIEPME,SDTME,THANNHANSVNT")] THANNHAN tHANNHAN) { if (ModelState.IsValid) { tHANNHAN.THANNHANSVNT = true; db.THANNHANs.Add(tHANNHAN); db.SaveChanges(); return(RedirectToAction("Create", "HOPDONGs", new { Area = "Student" })); } ViewBag.MASV = new SelectList(db.SINHVIENs, "MASV", "HOVATEN", tHANNHAN.MASV); return(View(tHANNHAN)); }
public ActionResult Create([Bind(Include = "MAHOPDONG,MASV,MAPHONG,NGAYLAP,NGAYBATDAU,NGAYKETTHUC,HIEULUCHD")] HOPDONG hOPDONG) { var idsession = (DMS_DTCK.Common.RegistrationRoom)Session[DMS_DTCK.Common.CommonConstants.ID_SESSION]; if (ModelState.IsValid) { hOPDONG.HIEULUCHD = true; hOPDONG.NGAYLAP = DateTime.Now; db.HOPDONGs.Add(hOPDONG); db.SaveChanges(); var dao = new StudentDao(); dao.UpdateSoChoTrong(idsession.ID); return(RedirectToAction("IndexID", "HDDIENNUOCs", new { Area = "Boarder", id = idsession.ID })); //return RedirectToAction("Index"); } ViewBag.MAPHONG = new SelectList(db.PHONGs, "MAPHONG", "MAKHU", hOPDONG.MAPHONG); ViewBag.MASV = new SelectList(db.SINHVIENs, "MASV", "MATKHAU", hOPDONG.MASV); return(View(hOPDONG)); }
public ActionResult Create([Bind(Include = "THANG,NAM,MADGDIEN,MADGNUOC")] HDDIENNUOC hDDIENNUOC) { var dao = new AdminDao(); var session = (DMS_DTCK.Common.AdminLogin)Session[DMS_DTCK.Common.CommonAdmin.ADMIN_SESSION]; List <DIENNUOC> phongmoi = db.DIENNUOCs.Where(x => (x.THANG.Equals(hDDIENNUOC.THANG)) && (x.NAM.Equals(hDDIENNUOC.NAM))).ToList(); var dgdien = db.DGDIENs.Find(hDDIENNUOC.MADGDIEN); var dgnuoc = db.DGNUOCs.Find(hDDIENNUOC.MADGNUOC); if ((dao.InsertHDDN(hDDIENNUOC.THANG, hDDIENNUOC.NAM)) == true) { foreach (var item in phongmoi) { string mp = item.MAPHONG; var phongcu = item; if (hDDIENNUOC.THANG > 1) { if ((dao.InsertDienNuoc(item.MAPHONG, hDDIENNUOC.THANG - 1, hDDIENNUOC.NAM))) { continue; } else { phongcu = db.DIENNUOCs.Where(x => (x.MAPHONG == mp) && (x.THANG.Equals(hDDIENNUOC.THANG - 1)) && (x.NAM.Equals(hDDIENNUOC.NAM))).SingleOrDefault(); } } else { if (dao.InsertDienNuoc(item.MAPHONG, 12, hDDIENNUOC.NAM - 1)) { continue; } else { phongcu = db.DIENNUOCs.Where(x => (x.MAPHONG == mp) && (x.THANG.Equals(12)) && (x.NAM.Equals(hDDIENNUOC.NAM - 1))).SingleOrDefault(); } } hDDIENNUOC.MAPHONG = item.MAPHONG; hDDIENNUOC.MAQL = session.UserName; hDDIENNUOC.THANG = hDDIENNUOC.THANG; hDDIENNUOC.NAM = hDDIENNUOC.NAM; hDDIENNUOC.CHISODIENMOI = item.CHISODIEN; hDDIENNUOC.CHISODIENCU = phongcu.CHISODIEN; hDDIENNUOC.TIENDIEN = (hDDIENNUOC.CHISODIENMOI - hDDIENNUOC.CHISODIENCU) * dgdien.DONGIADIEN; hDDIENNUOC.CHISONUOCMOI = item.CHISONUOC; hDDIENNUOC.CHISONUOCCU = phongcu.CHISONUOC; hDDIENNUOC.TIENNUOC = (hDDIENNUOC.CHISONUOCMOI - hDDIENNUOC.CHISONUOCCU) * dgnuoc.DONGIANUOC; hDDIENNUOC.TONGTIEN = hDDIENNUOC.TIENDIEN + hDDIENNUOC.TIENNUOC; hDDIENNUOC.TRANGTHAITHANHTOAN = false; if (ModelState.IsValid) { db.HDDIENNUOCs.Add(hDDIENNUOC); db.SaveChanges(); } ViewBag.MADGDIEN = new SelectList(db.DGDIENs, "MADGDIEN", "DONGIADIEN", hDDIENNUOC.MADGDIEN); ViewBag.MADGDNUOC = new SelectList(db.DGNUOCs, "MADGNUOC", "DONGIANUOC", hDDIENNUOC.MADGNUOC); ViewBag.MAPHONG = new SelectList(db.PHONGs, "MAPHONG", "MAPHONG", hDDIENNUOC.MAPHONG); ViewBag.MAQL = new SelectList(db.QUANLies, "MAQL", "MAQL", hDDIENNUOC.MAQL); } } if ((dao.InsertHDDN(hDDIENNUOC.THANG, hDDIENNUOC.NAM)) == false) { foreach (var item in phongmoi) { if (dao.InsertHDDienNuoc(item.MAPHONG, hDDIENNUOC.THANG, hDDIENNUOC.NAM)) { string mp = item.MAPHONG; var phongcu = item; if (hDDIENNUOC.THANG > 1) { if ((dao.InsertDienNuoc(item.MAPHONG, hDDIENNUOC.THANG - 1, hDDIENNUOC.NAM))) { continue; } else { phongcu = db.DIENNUOCs.Where(x => (x.MAPHONG == mp) && (x.THANG.Equals(hDDIENNUOC.THANG - 1))).SingleOrDefault(); } } else { if (dao.InsertDienNuoc(item.MAPHONG, 12, hDDIENNUOC.NAM - 1)) { continue; } else { phongcu = db.DIENNUOCs.Where(x => (x.MAPHONG == mp) && (x.THANG.Equals(12)) && (x.NAM.Equals(hDDIENNUOC.NAM - 1))).SingleOrDefault(); } } hDDIENNUOC.MAPHONG = item.MAPHONG; hDDIENNUOC.MAQL = session.UserName; hDDIENNUOC.THANG = hDDIENNUOC.THANG; hDDIENNUOC.NAM = hDDIENNUOC.NAM; hDDIENNUOC.CHISODIENMOI = item.CHISODIEN; hDDIENNUOC.CHISODIENCU = phongcu.CHISODIEN; hDDIENNUOC.TIENDIEN = (hDDIENNUOC.CHISODIENMOI - hDDIENNUOC.CHISODIENCU) * dgdien.DONGIADIEN; hDDIENNUOC.CHISONUOCMOI = item.CHISONUOC; hDDIENNUOC.CHISONUOCCU = phongcu.CHISONUOC; hDDIENNUOC.TIENNUOC = (hDDIENNUOC.CHISONUOCMOI - hDDIENNUOC.CHISONUOCCU) * dgnuoc.DONGIANUOC; hDDIENNUOC.TONGTIEN = hDDIENNUOC.TIENDIEN + hDDIENNUOC.TIENNUOC; hDDIENNUOC.TRANGTHAITHANHTOAN = false; if (ModelState.IsValid) { db.HDDIENNUOCs.Add(hDDIENNUOC); db.SaveChanges(); } ViewBag.MADGDIEN = new SelectList(db.DGDIENs, "MADGDIEN", "DONGIADIEN", hDDIENNUOC.MADGDIEN); ViewBag.MADGDNUOC = new SelectList(db.DGNUOCs, "MADGNUOC", "DONGIANUOC", hDDIENNUOC.MADGNUOC); ViewBag.MAPHONG = new SelectList(db.PHONGs, "MAPHONG", "MAPHONG", hDDIENNUOC.MAPHONG); ViewBag.MAQL = new SelectList(db.QUANLies, "MAQL", "MAQL", hDDIENNUOC.MAQL); } } } return(RedirectToAction("Index")); }
public ActionResult Create([Bind(Include = "MADIENNUOC,MAPHONG,MAQL,THANG,NAM,CHISODIEN,CHISONUOC")] DIENNUOC dIENNUOC) { if (ModelState.IsValid) { var dao = new AdminDao(); if (dao.InsertDienNuoc(dIENNUOC.MAPHONG, dIENNUOC.THANG, dIENNUOC.NAM)) { if (dIENNUOC.THANG > 1) { if (dao.InsertDienNuoc(dIENNUOC.MAPHONG, dIENNUOC.THANG - 1, dIENNUOC.NAM)) { db.DIENNUOCs.Add(dIENNUOC); db.SaveChanges(); return(RedirectToAction("Index")); } else { int sodiencu = dao.LaySoDien(dIENNUOC.MAPHONG, dIENNUOC.THANG - 1, dIENNUOC.NAM); int sonuoccu = dao.LaySoNuoc(dIENNUOC.MAPHONG, dIENNUOC.THANG - 1, dIENNUOC.NAM); if (sodiencu < dIENNUOC.CHISODIEN && sonuoccu < dIENNUOC.CHISONUOC) { db.DIENNUOCs.Add(dIENNUOC); db.SaveChanges(); return(RedirectToAction("Index")); } else { if (sodiencu > dIENNUOC.CHISODIEN) { ModelState.AddModelError("", "Chỉ số điện phải lớn hơn tháng trước!"); } if (sonuoccu > dIENNUOC.CHISONUOC) { ModelState.AddModelError("", "Chỉ số nước phải lớn hơn tháng trước!"); } } } } else { if (dao.InsertDienNuoc(dIENNUOC.MAPHONG, 12, dIENNUOC.NAM - 1)) { db.DIENNUOCs.Add(dIENNUOC); db.SaveChanges(); return(RedirectToAction("Index")); } else { int sodiencu = dao.LaySoDien(dIENNUOC.MAPHONG, 12, dIENNUOC.NAM - 1); int sonuoccu = dao.LaySoNuoc(dIENNUOC.MAPHONG, 12, dIENNUOC.NAM - 1); if (sodiencu < dIENNUOC.CHISODIEN && sonuoccu < dIENNUOC.CHISONUOC) { db.DIENNUOCs.Add(dIENNUOC); db.SaveChanges(); return(RedirectToAction("Index")); } else { if (sodiencu > dIENNUOC.CHISODIEN) { ModelState.AddModelError("", "Chỉ số điện phải lớn hơn tháng trước!"); } if (sonuoccu > dIENNUOC.CHISONUOC) { ModelState.AddModelError("", "Chỉ số nước phải lớn hơn tháng trước!"); } } } } } else { ModelState.AddModelError("", "Phòng này đã được thêm!"); } } ViewBag.MAPHONG = new SelectList(db.PHONGs, "MAPHONG", "MAPHONG", dIENNUOC.MAPHONG); ViewBag.MAQL = new SelectList(db.QUANLies, "MAQL", "MAQL", dIENNUOC.MAQL); return(View(dIENNUOC)); }