// GET: Vendor/Edit/5
public ActionResult Edit(decimal id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
item_utilisation item_utilisation = db.item_utilisation.Find(id);
if (item_utilisation == null)
{
return(HttpNotFound());
}
ViewBag.category_id = new SelectList(db.cnf_categories, "id", "category", item_utilisation.category_id);
ViewBag.location_id = new SelectList(db.cnf_locations, "id", "location_code", item_utilisation.location_id);
ViewBag.created_by = new SelectList(db.cnf_users, "username", "password", item_utilisation.created_by);
string userName = Session["UserName"].ToString();
var user = db.cnf_users.Where(x => x.username == userName).First();
ViewBag.UserName = userName;
ViewBag.Location = db.cnf_locations.Where(x => x.id == user.location_id).First().location_code;
return(View(item_utilisation));
}
public ActionResult DeleteConfirmed(decimal id)
{
item_utilisation item_utilisation = db.item_utilisation.Find(id);
db.item_utilisation.Remove(item_utilisation);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "id,asof_date,category_id,acquired,unused,wasted,created_by,location_id")] item_utilisation item_utilisation)
{
if (ModelState.IsValid)
{
db.Entry(item_utilisation).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.category_id = new SelectList(db.cnf_categories, "id", "category", item_utilisation.category_id);
ViewBag.location_id = new SelectList(db.cnf_locations, "id", "location_code", item_utilisation.location_id);
ViewBag.created_by = new SelectList(db.cnf_users, "username", "password", item_utilisation.created_by);
return(View(item_utilisation));
}
// GET: Vendor/Details/5
public ActionResult Details(decimal id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
item_utilisation item_utilisation = db.item_utilisation.Find(id);
if (item_utilisation == null)
{
return(HttpNotFound());
}
return(View(item_utilisation));
}
// GET: Vendor/Create
public ActionResult Create()
{
string userName = Session["UserName"].ToString();
var userCategories = db.cnf_user_category_mapping.Where(x => x.username == userName).Join(db.cnf_categories, x => x.category_id, y => y.id, (x, y) => new { id = y.id, category = y.category });
var list = userCategories.ToList();
ViewBag.category_id = new SelectList(userCategories, "id", "category");
ViewBag.location_id = new SelectList(db.cnf_locations, "id", "location_code");
ViewBag.created_by = new SelectList(db.cnf_users, "username", "username");
item_utilisation item_Utilisation = new item_utilisation();
item_Utilisation.asof_date = DateTime.Now.Date;
return(View(item_Utilisation));
}
// GET: Vendor/Edit/5
public ActionResult Edit(decimal id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
item_utilisation item_utilisation = db.item_utilisation.Find(id);
if (item_utilisation == null)
{
return(HttpNotFound());
}
ViewBag.category_id = new SelectList(db.cnf_categories, "id", "category", item_utilisation.category_id);
ViewBag.location_id = new SelectList(db.cnf_locations, "id", "location_code", item_utilisation.location_id);
ViewBag.created_by = new SelectList(db.cnf_users, "username", "password", item_utilisation.created_by);
return(View(item_utilisation));
}
public ActionResult Create([Bind(Include = "id,asof_date,category_id,acquired,unused,wasted,created_by,location_id")] item_utilisation item_utilisation)
{
if (ModelState.IsValid)
{
string userName = Session["UserName"].ToString();
var user = db.cnf_users.Where(x => x.username == userName).First();
item_utilisation.created_by = user.username;
item_utilisation.location_id = user.location_id;
db.item_utilisation.Add(item_utilisation);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.category_id = new SelectList(db.cnf_categories, "id", "category", item_utilisation.category_id);
ViewBag.location_id = new SelectList(db.cnf_locations, "id", "location_code", item_utilisation.location_id);
ViewBag.created_by = new SelectList(db.cnf_users, "username", "password", item_utilisation.created_by);
return(View(item_utilisation));
}
