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();
}
}