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 EditLoc(BvLocation l) { if (ModelState.IsValid) { lRepo.SaveBvLocation(l); TempData["message"] = string.Format("{0} has been saved", l.BvLocationId); return RedirectToAction("AdminLocIndex"); } else { return View(l); } }
public ActionResult Index() { //data to get db up and running -- delete when done //add a location BvLocation loc1 = new BvLocation { Address = "333 N Main St", City = "BobVille", BvStoreNum = "BV99", Phone = "839-839-8393", Zip = "88898" }; lRepo.AddBvLocation(loc1); //add a user User u1 = new User { UserFName = "Bob", UserLName = "Bobberson", AccessLevel = 1, BvLocation = loc1, Password = "******", UserEmail = "*****@*****.**", PhoneNumber = "541-389-8293" }; uRepo.AddUser(u1); //add a charity Charity c1 = new Charity { Address = "8939 S Seventh", City = "CharityVille", FederalTaxId = "893018XS", Name = "HopeForBob", Phone = "893-829-8393", TypeOfCharity = "Helpful", Zip = "83928" }; cRepo.AddCharity(c1); //add a partnership night PartnershipNight pn1 = new PartnershipNight { AfterTheEventFinished = false, AmountRaised = 0, BeforeTheEventFinished = true, BVLocation = loc1, Charity = c1, CheckRequestFinished = false, Comments = "blah blah", Date = DateTime.Parse("05/30/2014") }; pnRepo.AddPartnershipNight(pn1); //add stats StatsInfo s1 = new StatsInfo { AmountOfTotalSalesToCharity = 25.88M, CashDonations = 19.83M, GuestCount = 10, TotalSales = 100.00M, partnershipNight = pn1}; sRepo.AddStatsInfo(s1); return View(); }
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 IQueryable<PartnershipNight> GetPartnershipNightsByLoc(BvLocation loc) { throw new NotImplementedException(); }
public IQueryable<PartnershipNight> GetPartnershipNightsByDateRange(DateTime firstDate, DateTime lastDate, BvLocation loc) { throw new NotImplementedException(); }
public PartnershipNight GetPartnershipNightByDate(DateTime date, BvLocation loc) { throw new NotImplementedException(); }
public void AddBvLocation(BvLocation bvLocation) { var db = new CapstoneDbContext(); db.BvLocations.Add(bvLocation); db.SaveChanges(); ; }