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