// GET: Factory/Create
public ActionResult Create()
{
List<WorkNC_Company> listCompany = new List<WorkNC_Company>();
using (WorkNCDbContext db = new WorkNCDbContext())
{
listCompany = db.WorkNC_Company.ToList();
}
ViewBag.Company = new SelectList(listCompany, "CompanyId", "CompanyName");
return View();
}
// GET: WorkZone/Edit/5
public ActionResult Edit(int? id)
{
List<WorkNC_Factory> listFactory = new List<WorkNC_Factory>();
List<WorkNC_Machine> listMachine = new List<WorkNC_Machine>();
using (WorkNCDbContext context = new WorkNCDbContext())
{
listFactory = db.WorkNC_Factory.ToList();
listMachine = db.WorkNC_Machine.ToList();
}
WorkNC_WorkZone workZone = db.WorkNC_WorkZone.Find(id);
//fill to DropdownList
ViewBag.Factory = new SelectList(listFactory.OrderBy(n => n.Name), "FactoryId", "Name");
ViewBag.Machine = new SelectList(listMachine.OrderBy(n => n.Name), "MachineId", "Name");
return View(workZone);
}
public PartialViewResult SearchMachine()
{
var user = (from f in db.WorkNC_UserPermission
where f.Username == User.Identity.Name
select f).FirstOrDefault();
List<WorkNC_Factory> listFactory = new List<WorkNC_Factory>();
using (WorkNCDbContext context = new WorkNCDbContext())
{
int companyId;
HttpCookie cookie = Request.Cookies["cookieCompany"];
if (cookie != null)
companyId = Convert.ToInt32(cookie.Value);
else
companyId = user.CompanyId;
listFactory = context.WorkNC_Factory.Where(n=>n.CompanyId == companyId).ToList();
}
ViewBag.FacrotyId = new SelectList(listFactory, "FactoryId", "Name");
return PartialView("_SearchMachine");
}
public ActionResult Edit(int? id)
{
List<WorkNC_Factory> listFactory = new List<WorkNC_Factory>();
List<WorkNC_Machine> listMachine = new List<WorkNC_Machine>();
using (WorkNCDbContext context = new WorkNCDbContext())
{
listFactory = db.WorkNC_Factory.ToList();
listMachine = db.WorkNC_Machine.ToList();
}
ViewBag.Factory = new SelectList(listFactory, "FactoryId", "Name");
ViewBag.Machine = new SelectList(listMachine, "MachineId", "Name");
if (id == null)
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
WorkNC_WorkZone workZone = db.WorkNC_WorkZone.Find(id);
//fill to DropdownList
ViewBag.Factory = new SelectList(db.WorkNC_Factory.OrderBy(n => n.Name), "FactoryId", "Name");
ViewBag.Machine = new SelectList(db.WorkNC_Machine.OrderBy(n => n.Name), "MachineId", "Name");
if (workZone == null)
return HttpNotFound();
return View(workZone);
}
public JsonResult GetMachine(int factoryId)
{
List<WorkNC_Machine> allMachine = new List<WorkNC_Machine>();
using (WorkNCDbContext db = new WorkNCDbContext())
{
allMachine = db.WorkNC_Machine.Where(n => n.FactoryId.Equals(factoryId)).OrderBy(n => n.Name).ToList();
}
return new JsonResult { Data = allMachine, JsonRequestBehavior = JsonRequestBehavior.AllowGet };
}
public JsonResult GetFactory()
{
List<WorkNC_Factory> allFactory = new List<WorkNC_Factory>();
using (WorkNCDbContext context = new WorkNCDbContext())
{
allFactory = db.WorkNC_Factory.OrderBy(n => n.Name).ToList();
}
return new JsonResult { Data = allFactory, JsonRequestBehavior = JsonRequestBehavior.AllowGet };
//return PartialView("_Search");
}
public ActionResult Edit(int? id, WorkNC_WorkZone workZone)
{
List<WorkNC_Factory> listFactory = new List<WorkNC_Factory>();
List<WorkNC_Machine> listMachine = new List<WorkNC_Machine>();
using (WorkNCDbContext context = new WorkNCDbContext())
{
listFactory = db.WorkNC_Factory.ToList();
listMachine = db.WorkNC_Machine.ToList();
}
ViewBag.Factory = new SelectList(listFactory, "FactoryId", "Name");
ViewBag.Machine = new SelectList(listMachine, "MachineId", "Name");
try
{
if (ModelState.IsValid)
{
db.Entry(workZone).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
return View(workZone);
}
catch
{
return View();
}
}
public ActionResult Edit(WorkNC_WorkZone workZone, HttpPostedFileBase upload)
{
List<WorkNC_Factory> listFactory = new List<WorkNC_Factory>();
List<WorkNC_Machine> listMachine = new List<WorkNC_Machine>();
using (WorkNCDbContext context = new WorkNCDbContext())
{
listFactory = db.WorkNC_Factory.ToList();
listMachine = db.WorkNC_Machine.ToList();
}
ViewBag.Factory = new SelectList(listFactory.OrderBy(n => n.Name), "FactoryId", "Name");
ViewBag.Machine = new SelectList(listMachine.OrderBy(n => n.Name), "MachineId", "Name");
try
{
if (ModelState.IsValid)
{
if (upload != null && upload.ContentLength > 0)
{
}
//workZone.FactoryId = ViewBag.Factory("Name");
workZone.ModifiedDate = DateTime.Now;
workZone.ModifiedAccount = User.Identity.Name;
db.Entry(workZone).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
return View(workZone);
}
catch (Exception e)
{
ModelState.AddModelError("error", e);
return View();
}
}
public ActionResult FillDropDownCompany()
{
if (!string.IsNullOrEmpty(User.Identity.Name))
{
List<WorkNC_Company> listCompany = new List<WorkNC_Company>();
using (WorkNCDbContext db = new WorkNCDbContext())
{
listCompany = db.WorkNC_Company.ToList();
}
var user = (from f in db.WorkNC_UserPermission
where f.Username == User.Identity.Name
select f).FirstOrDefault();
//check role
if (user != null)
{
if (User.IsInRole("Admin"))
{
int companyId;
HttpCookie cookie = Request.Cookies["cookieCompany"];
if (cookie != null)
companyId = Convert.ToInt32(cookie.Value);
else
companyId = user.CompanyId;
ViewBag.Company = new SelectList(listCompany, "CompanyId", "CompanyName", companyId);
}
else
{
listCompany = db.WorkNC_Company.Where(n => n.CompanyId == user.CompanyId && n.isDeleted == false).ToList();
ViewBag.Company = new SelectList(listCompany, "CompanyId", "CompanyName");
}
}
}
return PartialView("_CompanyPartial");
}
