public async Task <ActionResult> DeleteConfirmed(int id)
{
NHAP_KHO nhap_kho = await db.NHAP_KHO.FindAsync(id);
db.NHAP_KHO.Remove(nhap_kho);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
//var cau_Hinh = new CAU_HINH();
//if (nhomTB == "PC")
//{
// if (!String.IsNullOrEmpty(form["thong_so1"]))
// {
// temp = form["thong_so1"].ToString();
// cau_Hinh.CPU = (from p in db.DM_CPU
// where p.TEN_CPU == temp
// select p.MA_CPU).First();
// }
// if (!String.IsNullOrEmpty(form["thong_so2"]))
// {
// temp = form["thong_so2"].ToString();
// cau_Hinh.RAM = (from p in db.DM_RAM
// where p.TEN_RAM == temp
// select p.MA_RAM).First();
// }
// if (!String.IsNullOrEmpty(form["thong_so3"]))
// {
// temp = form["thong_so3"].ToString();
// cau_Hinh.MAN_HINH = (from p in db.DM_MAN_HINH
// where p.TEN_MAN_HINH == temp
// select p.MA_MAN_HINH).First();
// }
// if (!String.IsNullOrEmpty(form["thong_so4"]))
// {
// temp = form["thong_so4"].ToString();
// cau_Hinh.O_CUNG = (from p in db.DM_O_CUNG
// where p.TEN_O_CUNG == temp
// select p.MA_O_CUNG).First();
// }
// if (!String.IsNullOrEmpty(form["thong_so5"]))
// {
// temp = form["thong_so5"].ToString();
// cau_Hinh.VGA = (from p in db.DM_VGA
// where p.TEN_VGA == temp
// select p.MA_VGA).First();
// }
// if (!String.IsNullOrEmpty(form["thong_so6"]))
// {
// temp = form["thong_so6"].ToString();
// cau_Hinh.HE_DIEU_HANH = (from p in db.DM_HDH
// where p.TEN_HDH == temp
// select p.MA_HDH).First();
// }
//}
//else if (nhomTB == "PR")
//{
// if (!String.IsNullOrEmpty(form["input_thong_so1"]))
// {
// cau_Hinh.KICH_THUOC = form["input_thong_so1"];
// }
// if (!String.IsNullOrEmpty(form["thong_so2"]))
// {
// temp = form["thong_so2"].ToString();
// cau_Hinh.LOAI_MUC = (from a in db.DM_LOAI_MUC
// where a.TEN_LOAI_MUC == temp
// select a.MA_LOAI_MUC).FirstOrDefault();
// }
// if (!String.IsNullOrEmpty(form["input_thong_so3"]))
// {
// cau_Hinh.TOC_DO = form["input_thong_so3"] + "ppm";
// }
// if (!String.IsNullOrEmpty(form["input_thong_so4"]))
// {
// cau_Hinh.DO_PHAN_GIAI = form["input_thong_so4"];
// }
//}
#endregion
#region Thêm nhập kho
public NHAP_KHO THEM_NHAP_KHO(string mATB, int?mADV_NHAP, string mAND_QL, int?sO_LUONG)
{
NHAP_KHO nHAP_KHO = new NHAP_KHO();
nHAP_KHO.MATB = mATB;
nHAP_KHO.MADV_NHAP = mADV_NHAP;
nHAP_KHO.MAND_NHAP = mAND_QL;
nHAP_KHO.NGAY_NHAP = DateTime.Now;
nHAP_KHO.SO_LUONG = sO_LUONG;
return(nHAP_KHO);
}
// GET: /NhapKho/Delete/5
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
NHAP_KHO nhap_kho = await db.NHAP_KHO.FindAsync(id);
if (nhap_kho == null)
{
return(HttpNotFound());
}
return(View(nhap_kho));
}
public async Task <ActionResult> Edit([Bind(Include = "MA_NHAPKHO,MATB,MADV_NHAP,MAND_NHAP,NGAY")] NHAP_KHO nhap_kho)
{
if (ModelState.IsValid)
{
db.Entry(nhap_kho).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.MADV_NHAP = new SelectList(db.DON_VI, "MA_DON_VI", "TEN_DON_VI", nhap_kho.MADV_NHAP);
ViewBag.MAND_NHAP = new SelectList(db.NGUOI_DUNG, "MA_ND", "TEN_ND", nhap_kho.MANS_NHAP);
ViewBag.MATB = new SelectList(db.THIETBIs, "MATB", "TENTB", nhap_kho.MATB);
return(View(nhap_kho));
}
public ActionResult NhapKho(FormCollection frmCreate, NHAP_KHO a)
{
a.MaSP = Convert.ToInt32(frmCreate["masp"]);
a.SoLuong = Convert.ToInt32(frmCreate["sl"]);
SANPHAM sp = db.SANPHAMs.Single(n => n.MaSP == a.MaSP);
sp.SoLuong = sp.SoLuong + a.SoLuong;
a.ThoiGian = DateTime.Now;
db.NHAP_KHO.Add(a);
db.SaveChanges();
return(RedirectToAction("NhapKho", "Quanly"));
}
// GET: /NhapKho/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
NHAP_KHO nhap_kho = await db.NHAP_KHO.FindAsync(id);
if (nhap_kho == null)
{
return(HttpNotFound());
}
ViewBag.MADV_NHAP = new SelectList(db.DON_VI, "MA_DON_VI", "TEN_DON_VI", nhap_kho.MADV_NHAP);
ViewBag.MAND_NHAP = new SelectList(db.NGUOI_DUNG, "MA_ND", "TEN_ND", nhap_kho.MANS_NHAP);
ViewBag.MATB = new SelectList(db.THIETBIs, "MATB", "TENTB", nhap_kho.MATB);
return(View(nhap_kho));
}
public async Task <ActionResult> Create(FormCollection form, string SAVE, HttpPostedFileBase HINH_ANH)
{
//, string hinh_anh
if (!String.IsNullOrEmpty(SAVE))
{
//Tạo thiết bị
var thiet_Bi = new THIETBI();
thiet_Bi.TENTB = form["TENTB"];
thiet_Bi.SO_SERIAL = form["SO_SERIAL"];
//thiet_Bi.GIA_TIEN = Decimal.Parse(form["GIA_TIEN"]);
thiet_Bi.THOI_HAN_BAO_HANH = form["THOI_HAN_BAO_HANH"];
thiet_Bi.TINH_TRANG = "Mới nhập";
var temp = form["MA_LOAITB"].ToString();
thiet_Bi.MA_LOAITB = (from p in db.LOAI_THIETBI
where p.TEN_LOAI == temp
select p.MA_LOAITB).FirstOrDefault();
if (!String.IsNullOrEmpty(form["MA_DON_VI"]))
{
temp = form["MA_DON_VI"].ToString();
thiet_Bi.MA_DV = (from p in db.DON_VI
where p.TEN_DON_VI == temp
select p.MA_DON_VI).First();
}
if (!String.IsNullOrEmpty(form["MA_NCC"]))
{
temp = form["MA_NCC"].ToString();
thiet_Bi.MA_NCC = (from p in db.NHA_CUNG_CAP
where p.TEN_NCC == temp
select p.MA_NCC).First();
}
//thiet_Bi.NGAY_GD = DateTime.Now;
if (ModelState.IsValid)
{
db.THIETBIs.Add(thiet_Bi);
await db.SaveChangesAsync();
}
//Tạo cấu hình
var cau_Hinh = new CAU_HINH();
temp = form["TENTB"].ToString();
cau_Hinh.MATB = 17;
//(from p in db.THIETBIs
// where p.TENTB == temp
// select p.MATB).First();
if (!String.IsNullOrEmpty(form["CPU"]))
{
temp = form["CPU"].ToString();
cau_Hinh.CPU = (from p in db.DM_CPU
where p.TEN_CPU == temp
select p.MA_CPU).First();
}
if (!String.IsNullOrEmpty(form["MAN_HINH"]))
{
temp = form["MAN_HINH"].ToString();
cau_Hinh.MAN_HINH = (from p in db.DM_MAN_HINH
where p.TEN_MAN_HINH == temp
select p.MA_MAN_HINH).First();
}
if (!String.IsNullOrEmpty(form["RAM"]))
{
temp = form["RAM"].ToString();
cau_Hinh.RAM = (from p in db.DM_RAM
where p.TEN_RAM == temp
select p.MA_RAM).First();
}
if (!String.IsNullOrEmpty(form["HDH"]))
{
temp = form["HDH"].ToString();
cau_Hinh.HE_DIEU_HANH = (from p in db.DM_HDH
where p.TEN_HDH == temp
select p.MA_HDH).First();
}
if (!String.IsNullOrEmpty(form["O_CUNG"]))
{
temp = form["O_CUNG"].ToString();
cau_Hinh.O_CUNG = (from p in db.DM_O_CUNG
where p.TEN_O_CUNG == temp
select p.MA_O_CUNG).First();
}
if (!String.IsNullOrEmpty(form["VGA"]))
{
temp = form["VGA"].ToString();
cau_Hinh.VGA = (from p in db.DM_VGA
where p.TEN_VGA == temp
select p.MA_VGA).First();
}
if (ModelState.IsValid)
{
db.CAU_HINH.Add(cau_Hinh);
await db.SaveChangesAsync();
}
//Tạo nhập kho
var nhap_Kho_Create = new NHAP_KHO();
temp = form["TENTB"].ToString();
nhap_Kho_Create.MATB = (from p in db.THIETBIs
where p.TENTB == temp
select p.MATB).First();
if (!String.IsNullOrEmpty(form["MA_DON_VI"]))
{
temp = form["MA_DON_VI"].ToString();
nhap_Kho_Create.MADV_NHAP = (from p in db.DON_VI
where p.TEN_DON_VI == temp
select p.MA_DON_VI).FirstOrDefault();
}
nhap_Kho_Create.NGAY_NHAP = DateTime.Now;
if (ModelState.IsValid)
{
db.NHAP_KHO.Add(nhap_Kho_Create);
await db.SaveChangesAsync();
}
//Tạo hình ảnh
if (!String.IsNullOrEmpty(HINH_ANH.ToString()))
{
var hinh_Anh = new HINH_ANH();
temp = form["TENTB"].ToString();
hinh_Anh.MATB = (from p in db.THIETBIs
where p.TENTB == temp
select p.MATB).First();
string ImageName = System.IO.Path.GetFileName(HINH_ANH.FileName);
string physicalPath = Server.MapPath("~/Images/" + ImageName);
// save image in folder
HINH_ANH.SaveAs(physicalPath);
hinh_Anh.HINH1 = ImageName;
if (ModelState.IsValid)
{
db.HINH_ANH.Add(hinh_Anh);
await db.SaveChangesAsync();
}
}
}
//else if (!String.IsNullOrEmpty(REFESH))
//{
// return RedirectToAction("Index");
//}
return(RedirectToAction("Index"));
//ViewBag.MADV_NHAP = new SelectList(db.DON_VI, "MA_DON_VI", "TEN_DON_VI", nhap_kho.MADV_NHAP);
//ViewBag.MAND_NHAP = new SelectList(db.NGUOI_DUNG, "MA_ND", "TEN_ND", nhap_kho.MANS_NHAP);
//ViewBag.MATB = new SelectList(db.THIETBIs, "MATB", "TENTB", nhap_kho.MATB);
//return View(nhap_kho);
}
