public async Task <ActionResult> DeleteConfirmed(int id)
{
XUAT_KHO xuat_kho = await db.XUAT_KHO.FindAsync(id);
db.XUAT_KHO.Remove(xuat_kho);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
// GET: /XuatKho/Delete/5
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
XUAT_KHO xuat_kho = await db.XUAT_KHO.FindAsync(id);
if (xuat_kho == null)
{
return(HttpNotFound());
}
return(View(xuat_kho));
}
public async Task <ActionResult> Edit([Bind(Include = "MA_XUAT_KHO,MATB,MADV_XUAT,MADV_NHAN,MAND_XUAT,MAND_NHAN,NGAY_THUC_HIEN")] XUAT_KHO xuat_kho)
{
if (ModelState.IsValid)
{
db.Entry(xuat_kho).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.MADV_XUAT = new SelectList(db.DON_VI, "MA_DON_VI", "TEN_DON_VI", xuat_kho.MADV_XUAT);
ViewBag.MADV_NHAN = new SelectList(db.DON_VI, "MA_DON_VI", "TEN_DON_VI", xuat_kho.MADV_NHAN);
ViewBag.MAND_XUAT = new SelectList(db.NGUOI_DUNG, "MA_ND", "TEN_ND", xuat_kho.MAND_XUAT);
ViewBag.MAND_NHAN = new SelectList(db.NGUOI_DUNG, "MA_ND", "TEN_ND", xuat_kho.MAND_NHAN);
ViewBag.MATB = new SelectList(db.THIETBIs, "MATB", "TENTB", xuat_kho.MATB);
return(View(xuat_kho));
}
public async Task <ActionResult> Create(XUAT_KHO xuat_kho)
{
if (ModelState.IsValid)
{
db.XUAT_KHO.Add(xuat_kho);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.MADV_XUAT = new SelectList(db.DON_VI, "MA_DON_VI", "TEN_DON_VI", xuat_kho.MADV_XUAT);
ViewBag.MADV_NHAN = new SelectList(db.DON_VI, "MA_DON_VI", "TEN_DON_VI", xuat_kho.MADV_NHAN);
ViewBag.MAND_XUAT = new SelectList(db.NGUOI_DUNG, "MA_ND", "TEN_ND", xuat_kho.MAND_XUAT);
ViewBag.MAND_NHAN = new SelectList(db.NGUOI_DUNG, "MA_ND", "TEN_ND", xuat_kho.MAND_NHAN);
ViewBag.MATB = new SelectList(db.THIETBIs, "MATB", "TENTB", xuat_kho.MATB);
return(View(xuat_kho));
}
// GET: /XuatKho/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
XUAT_KHO xuat_kho = await db.XUAT_KHO.FindAsync(id);
if (xuat_kho == null)
{
return(HttpNotFound());
}
ViewBag.MADV_XUAT = new SelectList(db.DON_VI, "MA_DON_VI", "TEN_DON_VI", xuat_kho.MADV_XUAT);
ViewBag.MADV_NHAN = new SelectList(db.DON_VI, "MA_DON_VI", "TEN_DON_VI", xuat_kho.MADV_NHAN);
ViewBag.MAND_XUAT = new SelectList(db.NGUOI_DUNG, "MA_ND", "TEN_ND", xuat_kho.MAND_XUAT);
ViewBag.MAND_NHAN = new SelectList(db.NGUOI_DUNG, "MA_ND", "TEN_ND", xuat_kho.MAND_NHAN);
ViewBag.MATB = new SelectList(db.THIETBIs, "MATB", "TENTB", xuat_kho.MATB);
return(View(xuat_kho));
}
public async Task <ActionResult> Create(string maTB, FormCollection form, string SAVE)
{
if (!String.IsNullOrEmpty(SAVE))
{
//Tạo xuất kho
var xuat_kho_create = new XUAT_KHO();
xuat_kho_create.MATB = Int32.Parse(maTB);
var temp = form["MADV_XUAT"].ToString();
xuat_kho_create.MADV_XUAT = (from p in db.DON_VI
where p.TEN_DON_VI.ToString() == temp
select p.MA_DON_VI).FirstOrDefault();
temp = form["MADV_NHAN"].ToString();
xuat_kho_create.MADV_NHAN = (from p in db.DON_VI
where p.TEN_DON_VI.ToString() == temp
select p.MA_DON_VI).FirstOrDefault();
xuat_kho_create.NGAY_XUAT = DateTime.Now;
if (ModelState.IsValid)
{
db.XUAT_KHO.Add(xuat_kho_create);
await db.SaveChangesAsync();
}
}
return(RedirectToAction("Index"));
//if (ModelState.IsValid)
//{
// db.XUAT_KHO.Add(xuat_kho);
// await db.SaveChangesAsync();
// return RedirectToAction("Index");
//}
//ViewBag.MADV_XUAT = new SelectList(db.DON_VI, "MA_DON_VI", "TEN_DON_VI", xuat_kho.MADV_XUAT);
//ViewBag.MADV_NHAN = new SelectList(db.DON_VI, "MA_DON_VI", "TEN_DON_VI", xuat_kho.MADV_NHAN);
//ViewBag.MAND_XUAT = new SelectList(db.NGUOI_DUNG, "MA_ND", "TEN_ND", xuat_kho.MANS_XUAT);
//ViewBag.MAND_NHAN = new SelectList(db.NGUOI_DUNG, "MA_ND", "TEN_ND", xuat_kho.MANS_NHAN);
//ViewBag.MATB = new SelectList(db.THIETBIs, "MATB", "TENTB", xuat_kho.MATB);
//return View(xuat_kho);
}
public XUAT_KHO THEM_XUAT_KHO(FormCollection form, string mATB)
{
var xUAT_KHO = new XUAT_KHO();
xUAT_KHO.MATB = mATB;
var tEN_DANG_NHAP = Session["TEN_DANG_NHAP"].ToString();
var nGUOI_DUNG = db.NGUOI_DUNG.FirstOrDefault(a => a.TEN_DANG_NHAP == tEN_DANG_NHAP);
xUAT_KHO.MADV_XUAT = nGUOI_DUNG.MA_DON_VI;
xUAT_KHO.MAND_XUAT = nGUOI_DUNG.MA_ND;
xUAT_KHO.MADV_NHAN = Int32.Parse(form["MADV_NHAN"]);
xUAT_KHO.MAND_NHAN = form["MAND_NHAN"];
xUAT_KHO.NGAY_XUAT = DateTime.Now;
xUAT_KHO.SO_LUONG = Int32.Parse(form["SO_LUONG"]);
xUAT_KHO.GHI_CHU = form["GHI_CHU"];
xUAT_KHO.VAN_CHUYEN = form["VAN_CHUYEN"];
return(xUAT_KHO);
}
public ActionResult XuatHuy()
{
var ctx = new SmsContext();
var stores = ctx.KHOes.Where(u => u.ACTIVE == "A").ToList <KHO>();
var units = ctx.DON_VI_TINH.Where(u => u.ACTIVE == "A").ToList <DON_VI_TINH>();
ViewBag.Stores = stores;
ExportModelXuatHuy model = new ExportModelXuatHuy();
XUAT_KHO Infor = new XUAT_KHO();
model.Infor = Infor;
var storeList = ctx.SP_GET_STORES_BY_USR_ID(Convert.ToInt32(Session["UserId"])).ToList <SP_GET_STORES_BY_USR_ID_Result>();
if (storeList != null && storeList.Count > 0)
{
model.Infor.MA_KHO_XUAT = storeList.First().MA_KHO;
}
model.Stores = stores;
model.Units = units;
model.StoreList = storeList;
ViewBag.InputKind = -1;
ctx.Dispose();
return(View(model));
}
