public ActionResult Create(tblNhaXuatBan model, FormCollection collection) { db = new TRUONGHOCDbContext(); model.TRANGTHAI = 1; var item = db.tblNhaXuatBans.Where(x => x.TRANGTHAI == 1).ToList(); foreach (var itemNXB in item) { if (model.MA_NXB == itemNXB.MA_NXB) { ModelState.AddModelError("", "Mã đã tồn tại"); break; } } if (ModelState.IsValid) { db.tblNhaXuatBans.Add(model); db.SaveChanges(); return(RedirectToAction("Index", "NXB")); } else { return(View()); } }
public ActionResult Edit(int id) { db = new TRUONGHOCDbContext(); var model = db.tblTheLoaiSaches.Find(id); return(View(model)); }
public ActionResult Edit(tblTheLoaiSach model, FormCollection collection) { db = new TRUONGHOCDbContext(); var item = db.tblTheLoaiSaches.Find(model.ID); item.TEN_THELOAI = model.TEN_THELOAI; item.MA_THELOAI = model.MA_THELOAI; var itemtl = db.tblTheLoaiSaches.Where(x => x.TRANG_THAI == 1 && x.ID != model.ID).ToList(); foreach (var itemNXB in itemtl) { if (item.MA_THELOAI == itemNXB.MA_THELOAI) { ModelState.AddModelError("", "Mã đã tồn tại"); break; } } if (ModelState.IsValid) { db.SaveChanges(); return(RedirectToAction("Index", "TheLoaiSach")); } else { return(View(model)); } }
// GET: Admin/TheLoaiSach public ActionResult Index() { db = new TRUONGHOCDbContext(); var model = db.tblTheLoaiSaches.Where(x => x.TRANG_THAI == 1).ToList(); return(View(model)); }
public ActionResult Details(int id) { db = new TRUONGHOCDbContext(); var model = db.tblNhaXuatBans.Find(id); return(PartialView(model)); }
public ActionResult Edit(int id) { db = new TRUONGHOCDbContext(); var model = db.tblNhaXuatBans.Find(id); return(View(model)); }
// GET: Admin/NXB public ActionResult Index() { db = new TRUONGHOCDbContext(); var model = db.tblNhaXuatBans.Where(x => x.TRANGTHAI == 1).ToList(); return(View(model)); }
public ActionResult Edit(tblNhaXuatBan model, FormCollection collection) { db = new TRUONGHOCDbContext(); var item = db.tblNhaXuatBans.Find(model.ID); item.TEN_NXB = model.TEN_NXB; item.MA_NXB = model.MA_NXB; item.DIA_CHI = model.DIA_CHI; item.GHI_CHU = model.GHI_CHU; item.SO_DTHOAI = model.SO_DTHOAI; var itemnxb = db.tblNhaXuatBans.Where(x => x.TRANGTHAI == 1 && x.ID != model.ID).ToList(); foreach (var itemNXB in itemnxb) { if (item.MA_NXB == itemNXB.MA_NXB) { ModelState.AddModelError("", "Mã đã tồn tại"); break; } } if (ModelState.IsValid) { db.SaveChanges(); return(RedirectToAction("Index", "NXB")); } else { return(View(model)); } }
public ActionResult Details(int id) { setControl(); db = new TRUONGHOCDbContext(); var model = db.tblSaches.Find(id); return(PartialView(model)); }
public void setControl() { db = new TRUONGHOCDbContext(); var cboTheLoai = db.tblTheLoaiSaches.Where(x => x.TRANG_THAI == 1).ToList(); ViewBag.setcontrolTLoai = cboTheLoai; var cboTacGia = db.tblTacGias.Where(x => x.TRANG_THAI == 1).ToList(); ViewBag.setcontrolTGia = cboTacGia; var cboNXB = db.tblNhaXuatBans.Where(x => x.TRANGTHAI == 1).ToList(); ViewBag.setcontrolNXB = cboNXB; }
public ActionResult Delete(int id) { db = new TRUONGHOCDbContext(); var item = db.tblTheLoaiSaches.Find(id); if (item != null) { item.TRANG_THAI = 0; db.SaveChanges(); return(RedirectToAction("Index", "TheLoaiSach")); } else { return(View()); } }
public ActionResult Delete(int id) { db = new TRUONGHOCDbContext(); var item = db.tblNhaXuatBans.Find(id); if (item != null) { db.tblNhaXuatBans.Remove(item); db.SaveChanges(); return(RedirectToAction("Index", "NXB")); } else { return(View()); } }
// GET: Admin/DocGia public ActionResult Index() { db = new TRUONGHOCDbContext(); var sinhvien = db.tblSinhViens.Where(x => x.TINH_TRANG == 1).ToList(); var giangvien = db.tblNhanViens.Where(x => x.MA_CHUCVU.Contains("CV001")).ToList(); var loai = db.tblLoaiDocGias.Where(x => x.TRANG_THAI == 1); Session["loai"] = loai; List <tblDocGia> list = new List <tblDocGia>(); foreach (var item in sinhvien) { tblDocGia docGia = new tblDocGia(); docGia.MA_DOCGIA = item.MA_SINHVIEN; docGia.MA_LOAI = "SV"; docGia.MA_THE = item.MA_SINHVIEN; docGia.NGAY_SINH = item.NGAY_SINH; docGia.SO_DTHOAI = item.SO_DTHOAI; docGia.TEN_DOCGIA = item.HO_TEN; docGia.TRANG_THAI = 1; docGia.GIOI_TINH = item.GIOI_TINH; docGia.GHI_CHU = item.GHI_CHU; list.Add(docGia); } foreach (var item1 in giangvien) { tblDocGia docGia2 = new tblDocGia(); docGia2.MA_DOCGIA = item1.MA_NHANVIEN; docGia2.MA_LOAI = "GV"; docGia2.MA_THE = item1.MA_NHANVIEN; docGia2.NGAY_SINH = item1.NGAY_SINH; docGia2.GIOI_TINH = item1.GIOI_TINH; docGia2.TEN_DOCGIA = item1.HO_TEN; docGia2.SO_DTHOAI = item1.SO_DIENTHOAI; docGia2.TRANG_THAI = 1; docGia2.GHI_CHU = item1.GHI_CHU; list.Add(docGia2); } return(View(list)); }
// GET: Admin/Book public ActionResult Index(string searchString) { db = new TRUONGHOCDbContext(); var listTheLoai = db.tblTheLoaiSaches.Where(x => x.TRANG_THAI == 1); Session["TheloaiSach"] = listTheLoai; var listNXB = db.tblNhaXuatBans.Where(x => x.TRANGTHAI == 1); Session["NXB"] = listNXB; var listTacGia = db.tblTacGias.Where(x => x.TRANG_THAI == 1); Session["TacGia"] = listTacGia; if (!string.IsNullOrEmpty(searchString)) { foreach (var item in listTacGia) { if (item.TEN_TACGIA.Contains(searchString)) { var model1 = db.tblSaches.Where(x => x.TRANG_THAI == 1 && (x.MA_TACGIA == item.MA_TACGIA)).ToList(); return(View(model1)); } } foreach (var item1 in listTheLoai) { if (item1.TEN_THELOAI.Contains(searchString)) { var model1 = db.tblSaches.Where(x => x.TRANG_THAI == 1 && (x.MA_THELOAI == item1.MA_THELOAI)).ToList(); return(View(model1)); } } var model2 = db.tblSaches.Where(x => x.TRANG_THAI == 1 && (x.TEN_SACH.Contains(searchString))).ToList(); return(View(model2)); } else { var model2 = db.tblSaches.Where(x => x.TRANG_THAI == 1).ToList(); return(View(model2)); } }
public ActionResult IndexUser(int page = 1, int pageSize = 5) { db = new TRUONGHOCDbContext(); double totalRecord = db.tblSaches.Where(x => x.TRANG_THAI == 1).Count(); ViewBag.Total = totalRecord; ViewBag.Page = page; int maxPage = 5; double totalPage = 0; totalPage = (double)Math.Ceiling(((decimal)(totalRecord / pageSize))); ViewBag.TotalPage = totalPage; ViewBag.MaxPage = maxPage; ViewBag.First = 1; ViewBag.Last = totalPage; ViewBag.Next = page + 1; ViewBag.Prev = page - 1; var model = db.tblSaches.Where(x => x.TRANG_THAI == 1).OrderByDescending(x => x.ID).Skip((page - 1) * pageSize).Take(pageSize).ToList(); return(View(model)); }
public ActionResult Index(tblAccount model, FormCollection collection) { db = new TRUONGHOCDbContext(); var item = db.tblAccounts.Where(x => x.AccoutName == model.AccoutName && x.Password == model.Password && x.Status == 1).FirstOrDefault(); if (item != null) { if (item.DateIssued < DateTime.Now) { return(RedirectToAction("Index", "Home")); } else { ModelState.AddModelError("", "Tài khoản hết hiệu lực"); return(View()); } } else { ModelState.AddModelError("", "Thông tin tài khoản hoặc mật khẩu không chính xác"); return(View()); } }
public ActionResult Create(tblTacGia model, HttpPostedFile filePost, FormCollection collection) { string fileLocation = ""; if (Request.Files["filePost"].ContentLength <= 0) { model.IMAGE = ""; } ModelState["filePost"].Errors.Clear(); //if (ModelState.IsValid == true) //{ if (Request.Files["filePost"].ContentLength > 0) { string fileExtension = System.IO.Path.GetExtension(Request.Files["filePost"].FileName); fileLocation = Server.MapPath("~/Content/") + Request.Files["filePost"].FileName; if (System.IO.File.Exists(fileLocation)) { System.IO.File.Delete(fileLocation); } Request.Files["filePost"].SaveAs(fileLocation); } string strRadio = collection["customRadio"].ToString(); if (strRadio == "Nam") { model.GIOI_TINH = 1; } else if (strRadio == "Nu") { model.GIOI_TINH = 0; } db = new TRUONGHOCDbContext(); model.TRANG_THAI = 1; int iContent = fileLocation.IndexOf("Content"); if (iContent > 0) { model.IMAGE = @"\" + fileLocation.Substring(iContent, fileLocation.Length - iContent); } var item = db.tblTacGias.Where(x => x.TRANG_THAI == 1).ToList(); foreach (var itemTG in item) { if (model.MA_TACGIA == itemTG.MA_TACGIA) { ModelState.AddModelError("", "Mã đã tồn tại"); break; } } if (ModelState.IsValid) { db.tblTacGias.Add(model); db.SaveChanges(); return(RedirectToAction("Index", "TacGia")); } else { return(View()); } }
public ActionResult Create(tblSach model, HttpPostedFile filePost, FormCollection collection) { setControl(); string fileLocation = ""; if (Request.Files["filePost"].ContentLength <= 0) { model.IMAGE = ""; } ModelState["filePost"].Errors.Clear(); //if (ModelState.IsValid == true) //{ if (Request.Files["filePost"].ContentLength > 0) { string fileExtension = System.IO.Path.GetExtension(Request.Files["filePost"].FileName); fileLocation = Server.MapPath("~/Content/") + Request.Files["filePost"].FileName; if (System.IO.File.Exists(fileLocation)) { System.IO.File.Delete(fileLocation); } Request.Files["filePost"].SaveAs(fileLocation); } model.MA_NXB = collection["cboNXB"].ToString(); model.MA_TACGIA = collection["cboTacGia"].ToString(); model.MA_THELOAI = collection["cboTLoai"].ToString(); model.MO_TA = "1"; model.TRANG_THAI = 1; int iContent = fileLocation.IndexOf("Content"); if (iContent > 0) { model.IMAGE = @"\" + fileLocation.Substring(iContent, fileLocation.Length - iContent); } db = new TRUONGHOCDbContext(); var item = db.tblSaches.Where(x => x.TRANG_THAI == 1).ToList(); var result = false; foreach (var itemSach in item) { if (model.MA_SACH == itemSach.MA_SACH) { result = false; break; } else { result = true; } } if (result == false) { ModelState.AddModelError("", "Mã sách đã tồn tại"); setControl(); return(View()); } else if (collection["cboNXB"].ToString() == "-1" || collection["cboTacGia"].ToString() == "-1" || collection["cboTLoai"].ToString() == "-1" || model.MA_SACH == null) { ModelState.AddModelError("", "Lỗi kiểm tra dữ liệu"); setControl(); return(View()); } else { db.tblSaches.Add(model); db.SaveChanges(); return(RedirectToAction("Index", "Book")); } }