public HINH_ANH THEM_HINH_ANH(HttpPostedFileBase[] hINH_ANH, string mATB)
{
var cREATE_HINH_ANH = new HINH_ANH();
cREATE_HINH_ANH.MATB = mATB;
foreach (var file in hINH_ANH)
{
if (file.ContentLength > 0)
{
var fileName = Path.GetFileName(file.FileName);
var path = Path.Combine(Server.MapPath("~/Images/" + fileName));
file.SaveAs(path);
if (cREATE_HINH_ANH.HINH1 == null)
{
cREATE_HINH_ANH.HINH1 = fileName;
}
else if (cREATE_HINH_ANH.HINH2 == null)
{
cREATE_HINH_ANH.HINH2 = fileName;
}
else if (cREATE_HINH_ANH.HINH3 == null)
{
cREATE_HINH_ANH.HINH3 = fileName;
}
else if (cREATE_HINH_ANH.HINH4 == null)
{
cREATE_HINH_ANH.HINH4 = fileName;
}
else if (cREATE_HINH_ANH.HINH5 == null)
{
cREATE_HINH_ANH.HINH5 = fileName;
break;
}
}
}
return(cREATE_HINH_ANH);
}
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);
}
