public ActionResult Edit([Bind(Include = "ID,Name,UserLogin,UserPassword,UgID,TelNo,Email")] Staff staff)
{
if (ModelState.IsValid)
{
db.Entry(staff).State = EntityState.Modified;
db.SaveChanges();
StaffID = staff.ID;
//Delete old data
StaffWarehouse sf = db.StaffWarehouses.Find(StaffID);
db.StaffWarehouses.Remove(sf);
db.SaveChanges();
staff.StWh.RemoveAt(0);
foreach (var a in staff.StWh)
{
StaffWarehouse SW = new StaffWarehouse();
SW.StID = StaffID;
SW.WhID = a.WhID;
SW.IsManager = a.IsManager;
db.StaffWarehouses.Add(SW);
db.SaveChanges();
}
return(Json("success"));
}
ViewBag.ID = new SelectList(db.UserGroups, "ID", "Name", staff.ID);
return(View(staff));
}
public ActionResult InsertStaff(Staff model)
{
using (DLSMEntities context = new DLSMEntities())
{
using (var dbContextTransaction = context.Database.BeginTransaction())
{
try
{
Staff w = context.Staffs.Where(p => p.UserLogin == model.UserLogin).FirstOrDefault();
if (w != null)
{
return(Json("UserLogin นี้มีอยู่แล้วในระบบ"));
}
model.UserPassword = Hash(model.UserPassword);
context.Staffs.Add(model);
context.SaveChanges();
StaffID = model.ID;
model.StWh.RemoveAt(0);
foreach (var a in model.StWh)
{
StaffWarehouse SW = new StaffWarehouse();
SW.StID = StaffID;
SW.WhID = a.WhID;
SW.IsManager = a.IsManager;
context.StaffWarehouses.Add(SW);
}
context.SaveChanges();
dbContextTransaction.Commit();
}
catch (Exception ex)
{
dbContextTransaction.Rollback();
return(Json(ex.InnerException.Message));
}
}
}
return(Json(StaffID));
}
public ActionResult DeleteConfirmed(int id)
{
var context = new DLSMEntities();
StaffWarehouse st = context.StaffWarehouses.Where(p => p.WhID == id).FirstOrDefault();
Stock s = context.Stocks.Where(p => p.WhID == id).FirstOrDefault();
if (st != null || s != null)
{
// Cannot delete becasue Topic group is using another process
TempData["Msg"] = "ลบไม่ได้ เนื่องจากข้อมูลนี้มีการถูกใช้งานอยู่";
return(RedirectToAction("Edit", new { id = id, ViewBag.Msg }));
}
else
{
Warehouse warehouse = db.Warehouses.Find(id);
db.Warehouses.Remove(warehouse);
db.SaveChanges();
TempData["Msg"] = "ลบข้อมูลเรียบร้อยแล้ว";
}
return(RedirectToAction("Index"));
}
public JsonResult EditStaff(Staff staff)
{
using (DLSMEntities context = new DLSMEntities())
{
using (var dbContextTransaction = context.Database.BeginTransaction())
{
try
{
if (staff != null && staff.ID != 0)
{
Staff w = context.Staffs.Where(p => (p.UserLogin == staff.UserLogin) && (p.ID != staff.ID)).FirstOrDefault();
if (w != null)
{
return(Json("UserLogin นี้มีอยู่แล้วในระบบ"));
}
if (staff.NewUserPassword != null && staff.NewUserPassword != "")
{
staff.UserPassword = Hash(staff.NewUserPassword);
}
context.Entry(staff).State = EntityState.Modified;
context.SaveChanges();
StaffID = staff.ID;
context.StaffWarehouses.RemoveRange(context.StaffWarehouses.Where(x => x.StID == StaffID));
context.SaveChanges();
staff.StWh.RemoveAt(0);
foreach (var a in staff.StWh)
{
StaffWarehouse SW = new StaffWarehouse();
SW.StID = StaffID;
SW.WhID = a.WhID;
SW.IsManager = a.IsManager;
context.StaffWarehouses.Add(SW);
}
context.SaveChanges();
//Update some data Referance with Authorize
var updRef = (from rf in context.Staffs
where rf.RefAuthorize == staff.ID
select rf).ToList();
foreach (var i in updRef)
{
i.TitleTH = staff.TitleTH;
i.AuthorizeNameTH = staff.AuthorizeNameTH;
i.AuthorizeLastNameTH = staff.AuthorizeLastNameTH;
i.TitleEN = staff.TitleEN;
i.AuthorizeNameEN = staff.AuthorizeNameEN;
i.AuthorizeLastNameEN = staff.AuthorizeLastNameEN;
i.Signature = staff.Signature;
i.AuthorityType = staff.AuthorityType;
i.AuthorizeIdCard = staff.AuthorizeIdCard;
}
context.SaveChanges();
dbContextTransaction.Commit();
}
}
catch (Exception ex)
{
dbContextTransaction.Rollback();
return(Json(ex.InnerException.Message));
}
}
}
return(Json(StaffID));
}
