public void AddBvLocation(BvLocation bvLocation) { var db = new CapstoneDbContext(); db.BvLocations.Add(bvLocation); db.SaveChanges();; }
public ActionResult LocationEdit(int bvLocationId) { TempData["Title"] = "Edit BV Location"; BvLocation l = lRepo.GetBvLocation(bvLocationId); return(View(l)); }
public PartnershipNight GetPartnershipNightByDate(DateTime date, BvLocation loc) { var db = new CapstoneDbContext(); return((from pnight in db.PartnershipNights.Include("Charity").Include("BVLocation") where pnight.Date == date && pnight.BVLocation == loc select pnight).FirstOrDefault()); }
public List <PartnershipNight> GetPartnershipNights(BvLocation l) { var db = new CapstoneDbContext(); List <PartnershipNight> partnershipnights = (from c in db.PartnershipNights.Include("BvLocation").Include("Charity") where c.BVLocation.BvLocationId == l.BvLocationId select c).ToList <PartnershipNight>(); return(partnershipnights); }
public ActionResult LocationDelete(int bvLocationId) { BvLocation deletedLoc = lRepo.DeleteBvLocation(bvLocationId); if (deletedLoc != null) { TempData["message"] = string.Format("{0} was deleted", deletedLoc.BvStoreNum); } return(RedirectToAction("LocationIndex")); }
//need to pass a user to this method once the login stuff is worked out public ViewResult Calendar() { User u = uRepo.GetUser(11); BvLocation bvLocation = lRepo.GetBvLocation(u.BvLocation.BvLocationId); var db = new CapstoneDbContext(); bvLocation.PartnershipNights = lRepo.GetPartnershipNights(bvLocation); return(View(bvLocation)); }
public BvLocation DeleteBvLocation(int bvLocationId) { var db = new CapstoneDbContext(); BvLocation dbEntry = db.BvLocations.Find(bvLocationId); if (dbEntry != null) { db.BvLocations.Remove(dbEntry); db.SaveChanges(); } return(dbEntry); }
public ActionResult LocationEdit(BvLocation l) { if (ModelState.IsValid) { lRepo.SaveBvLocation(l); TempData["message"] = string.Format("{0} has been saved", l.BvStoreNum); return(RedirectToAction("LocationIndex")); } else { return(View(l)); } }
public void SaveBvLocation(BvLocation l) { var db = new CapstoneDbContext(); if (l.BvLocationId == 0) { db.BvLocations.Add(l); } else { BvLocation dbEntry = db.BvLocations.Find(l.BvLocationId); if (dbEntry != null) { dbEntry.Address = l.Address; dbEntry.BvStoreNum = l.BvStoreNum; dbEntry.City = l.City; dbEntry.Phone = l.Phone; dbEntry.Zip = l.Zip; } } db.SaveChanges(); }
public ActionResult EditUser(User u) { if (ModelState.IsValid) { BvLocation l = lRepo.GetBvLocation(u.BvLocation.BvStoreNum); if (l != null) { u.BvLocation = l; uRepo.SaveUser(u); TempData["message"] = string.Format("{0} has been saved", u.UserFName + " " + u.UserLName); } else { TempData["message"] = string.Format("{0} is not a valid Restaurant", u.BvLocation.BvStoreNum); } return(RedirectToAction("AdminUserIndex")); } else { return(View(u)); } }
public ActionResult LocationEdit(int bvLocationId) { BvLocation l = lRepo.GetBvLocation(bvLocationId); return(View(l)); }