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