public ActionResult Create(KhoVatDung khoVatDung)
{
if (ModelState.IsValid)
{
khoVatDung.Status = 1;
db.KhoVatDungs.Add(khoVatDung);
string ngaymua;
if (khoVatDung.NgayMua.HasValue)
{
ngaymua = khoVatDung.NgayMua.Value.ToString("dd/mm/yyyy");
}
else
{
ngaymua = null;
}
TestObject test = new TestObject();
string exception = test.TestKho(khoVatDung.TenVatDung, ngaymua);
if (exception == "OK")
{
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", exception);
}
}
return(View(khoVatDung));
}
public JsonResult Update(string kho, string ngaymua)
{
try
{
JavaScriptSerializer serializer = new JavaScriptSerializer();
KhoVatDung kho_edit = serializer.Deserialize <KhoVatDung>(kho);
if (!kho_edit.TenVatDung.Equals(""))
{
try
{
KhoVatDung khoVatDung = db.KhoVatDungs.SingleOrDefault(x => x.ID == kho_edit.ID);
khoVatDung.TenVatDung = kho_edit.TenVatDung;
if (ngaymua == null || ngaymua == "null" || ngaymua == "")
{
khoVatDung.NgayMua = null;
}
else
{
khoVatDung.NgayMua = Convert.ToDateTime(ngaymua);
}
khoVatDung.GhiChu = kho_edit.GhiChu;
db.SaveChanges();
return(Json(new
{
status = true
}));
}
catch
{
return(Json(new
{
status = false,
mess = "Ngày mua sai định dạng"
}));
}
}
else
{
return(Json(new
{
status = false
}));
}
}
catch
{
return(Json(new
{
status = false
}));
}
}
public JsonResult XoaChitietPhieuXuat(int idctpx)
{
CTPhieuXuatKho ctpx = db.CTPhieuXuatKhoes.SingleOrDefault(x => x.ID == idctpx);
db.CTPhieuXuatKhoes.Remove(ctpx);
KhoVatDung vatdung = db.KhoVatDungs.SingleOrDefault(x => x.ID == ctpx.IDVatDung);
vatdung.Status = 1;
db.SaveChanges();
return(Json(new
{
status = true
}));
}
public JsonResult LoadDungCu()
{
// string name = HttpContext.User.Identity.Name;
//var ktv = db.NhanViens.SingleOrDefault(x => x.Username.Equals(name) && x.Status == 1);
var rs = db.KhoVatDungs.Where(x => x.Status == 1);
List <KhoVatDung> list = new List <KhoVatDung>();
foreach (KhoVatDung item in rs)
{
KhoVatDung vd = new KhoVatDung();
vd.ID = item.ID;
vd.TenVatDung = item.TenVatDung;
list.Add(vd);
}
return(Json(new {
data = list, status = true
}, JsonRequestBehavior.AllowGet));
}
public JsonResult LuuCTPhieuXuat(int idvatdung, int idktv, int idpx)
{
//Lưu chi tiết
CTPhieuXuatKho ct = new CTPhieuXuatKho();
ct.IDPhieuXuat = idpx;
ct.IDVatDung = idvatdung;
ct.Status = 0;
//Thay đổi Status vật dụng
KhoVatDung vd = db.KhoVatDungs.SingleOrDefault(x => x.ID == idvatdung);
vd.Status = 2;
db.CTPhieuXuatKhoes.Add(ct);
db.SaveChanges();
return(Json(new
{
status = true,
}));
}
public JsonResult ChangeStatusPhieu(int idphieuxuat)
{
PhieuXuatKho px = db.PhieuXuatKhoes.SingleOrDefault(x => x.ID == idphieuxuat);
if (px.Status == 0)
{
px.Status = 1;
px.NgayTra = DateTime.Now;
List <CTPhieuXuatKho> listct = db.CTPhieuXuatKhoes.Where(x => x.IDPhieuXuat == idphieuxuat).ToList();
foreach (CTPhieuXuatKho item in listct)
{
KhoVatDung vatDung = db.KhoVatDungs.SingleOrDefault(x => x.ID == item.IDVatDung);
vatDung.Status = 1;
db.SaveChanges();
}
}
else
{
px.Status = 0;
px.NgayTra = null;
List <CTPhieuXuatKho> listct = db.CTPhieuXuatKhoes.Where(x => x.IDPhieuXuat == idphieuxuat).ToList();
foreach (CTPhieuXuatKho item in listct)
{
KhoVatDung vatDung = db.KhoVatDungs.SingleOrDefault(x => x.ID == item.IDVatDung);
vatDung.Status = 2;
db.SaveChanges();
}
}
db.SaveChanges();
return(Json(new
{
status = true
}));
}
public ActionResult Import(FormCollection formCollection)
{
var orderbyList = db.KhoVatDungs.ToList().OrderBy(x => x.ID);
if (Request != null)
{
DataTable dt = new DataTable();
HttpPostedFileBase file = Request.Files["UploadedFile"];
if ((file != null) && (file.ContentLength > 0) && !string.IsNullOrEmpty(file.FileName))
{
if (file.FileName.EndsWith("xls") || file.FileName.EndsWith("xlsx"))
{
string fileName = file.FileName;
string path = Server.MapPath("~/ExcelFiles/" + fileName);
file.SaveAs(path);
if (System.IO.File.Exists(Server.MapPath("~/ExcelFiles/" + fileName)))
{
System.IO.File.Delete(Server.MapPath("~/ExcelFiles/" + fileName));
}
file.SaveAs(path);
var excelData = new ExcelData(path);
try
{
var sData = excelData.getData("Kho");
List <KhoVatDung> list = new List <KhoVatDung>();
dt = sData.CopyToDataTable();
foreach (DataRow item in dt.Rows)
{
KhoVatDung dvsp = new KhoVatDung();
dvsp.TenVatDung = item["Tên vật dụng"].ToString();
if (String.IsNullOrEmpty(item["Ngày mua"].ToString()))
{
dvsp.NgayMua = null;
}
else
{
dvsp.NgayMua = Convert.ToDateTime(item["Ngày mua"].ToString());
}
dvsp.GhiChu = item["Ghi chú"].ToString();
dvsp.Status = 1;
list.Add(dvsp);
}
if (ModelState.IsValid)
{
if (list != null)
{
for (int i = 0; i < list.Count; i++)
{
string tenvatdung = list[i].TenVatDung;
KhoVatDung kho = db.KhoVatDungs.SingleOrDefault(x => x.TenVatDung == tenvatdung);
if (db.KhoVatDungs.SingleOrDefault(x => x.TenVatDung == tenvatdung) == null)
{
db.KhoVatDungs.Add(list[i]);
db.SaveChanges();
}
}
TempData["msg"] = "<script>alert('Thành công');</script>";
return(RedirectToAction("Index", "Kho"));
}
}
}
catch
{
ViewBag.Error = "Import thất bại";
}
}
else
{
ViewBag.Error = "Vui lòng chọn file excel";
return(View("Index", orderbyList));
}
}
}
ViewBag.Error = "Vui lòng chọn file excel";
return(RedirectToAction("Index", "Kho"));
}
