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