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));
}