public ActionResult Create([Bind(Include = "UserRequestID,DateRequested,RequestorEmail,Status,RequestDescription,DateNeededBy,DeliveryType,TotalCost")] UserRequest userRequest) { if (ModelState.IsValid) { db.UserRequests.Add(userRequest); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(userRequest)); }
public ActionResult Create([Bind(Include = "AnimalId,AnimalName")] Animal animal) { if (ModelState.IsValid) { db.Animals.Add(animal); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(animal)); }
public ActionResult Create([Bind(Include = "ProductID,ProductName,ProductDescription,PricePerUnit,QtyInStock")] Product product) { if (ModelState.IsValid) { db.Products.Add(product); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(product)); }
public ActionResult Create([Bind(Include = "CookId,CookType1")] CookType cookType) { if (ModelState.IsValid) { db.CookTypes.Add(cookType); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(cookType)); }
public ActionResult Create([Bind(Include = "AltNameId,CutId,AltName1")] AltName altName) { if (ModelState.IsValid) { db.AltNames.Add(altName); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CutId = new SelectList(db.CutNames, "CutId", "CutName1", altName.CutId); return(View(altName)); }
public ActionResult Create([Bind(Include = "PrimalCutId,PrimalCutName,AnimalId")] PrimalCut primalCut) { if (ModelState.IsValid) { db.PrimalCuts.Add(primalCut); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.AnimalId = new SelectList(db.Animals, "AnimalId", "AnimalName", primalCut.AnimalId); return(View(primalCut)); }
public ActionResult Create([Bind(Include = "CutId,CutName1,PrimalCutId")] CutName cutName) { if (ModelState.IsValid) { db.CutNames.Add(cutName); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.PrimalCutId = new SelectList(db.PrimalCuts, "PrimalCutId", "PrimalCutName", cutName.PrimalCutId); return(View(cutName)); }
public ActionResult Create([Bind(Include = "CutId,CookId,Good_Bad,CookCutId")] CookCut cookCut) { if (ModelState.IsValid) { db.CookCuts.Add(cookCut); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CookId = new SelectList(db.CookTypes, "CookId", "CookType1", cookCut.CookId); ViewBag.CutId = new SelectList(db.CutNames, "CutId", "CutName1", cookCut.CutId); return(View(cookCut)); }
public void AddGroup(Group group, string Course) { using (var context = new FinalProjectDBEntities1()) { List <int> list = (context.Courses.Join(context.Groups, cor => cor.Name, grop => Course, (cor, grop) => cor.Id)).Distinct().ToList(); group.BeginigDate = DateTime.Now; try { group.CourseId = list[0]; } catch (Exception e) { group.CourseId = 1; } List <Group> query = context.Groups .Where(x => x.Name == group.Name && (x.IsDeleted == false || x.IsDeleted == null)) .ToList(); if (query.Count == 0) { context.Groups.Add(group); context.SaveChanges(); } } }
public void DeleteUser(int?Id) { using (var context = new FinalProjectDBEntities1()) { User user = context.Users.Find(Id); user.IsDeleted = true; context.SaveChanges(); userList.Remove(user); } }
public void DeleteGroup(int?Id) { using (var context = new FinalProjectDBEntities1()) { Group group = context.Groups.Find(Id); group.IsDeleted = true; context.SaveChanges(); groupList.Remove(group); } }
public void DeleteCourse(int?Id) { using (var context = new FinalProjectDBEntities1()) { Course course = context.Courses.Find(Id); course.IsDeleted = true; context.SaveChanges(); courseList.Remove(course); } }
public ActionResult Create(PRViewModel requestItem) { if (ModelState.IsValid) { if (requestItem.RI.UserRequest.TotalCost <= 20) { requestItem.RI.UserRequest.Status = "Approved"; } else { requestItem.RI.UserRequest.Status = "Pending"; } requestItem.RI.UserRequest.RequestorEmail = User.Identity.Name != string.Empty ? User.Identity.Name : "No Email"; requestItem.RI.UserRequest.DateRequested = DateTime.Now; var newPR = db.UserRequests.Add(requestItem.RI.UserRequest); db.SaveChanges(); var cps = requestItem.Products; var prodItems = JsonConvert.DeserializeObject <List <ProductsJson> >(cps); int prodid = 0; int qty = 0; foreach (var prod in prodItems) { prodid = int.Parse(prod.ProductID); qty = int.Parse(prod.QtyNeeded); db.PurchaseRequests.Add(new PurchaseRequest { UserRequestID = newPR.UserRequestID, ProductID = prodid, QtyNeeded = qty }); var qtyfix = from pd in db.Products where pd.ProductID == prodid select pd; qtyfix.First().QtyInStock = qtyfix.First().QtyInStock - qty; } db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ProductId = new SelectList(db.Products, "ProductId", "ProductName", requestItem.RI.ProductID); ViewBag.PurchaseRequestId = new SelectList(db.PurchaseRequests, "RequestId", "Status", requestItem.RI.UserRequestID); return(View(requestItem)); }
public void AddCourse(Course course) { using (FinalProjectDBEntities1 context = new FinalProjectDBEntities1()) { List <Course> query = context.Courses .Where(x => x.Name == course.Name && (x.IsDeleted == false || x.IsDeleted == null)) .ToList(); if (query.Count == 0) { context.Courses.Add(course); context.SaveChanges(); } } }
public void AddUser(User user, string role) { using (var context = new FinalProjectDBEntities1()) { List <int> list = (context.UserTypes.Join(context.Users, us => us.Name, type => role, (us, type) => us.Id)).Distinct().ToList(); try { user.UserTypeId = list[0]; } catch { user.UserTypeId = 1; } context.Users.Add(user); context.SaveChanges(); } }