public ActionResult PartnershipNightEdit(int partnershipNightId) { TempData["Title"] = "Edit"; // Get the correct partnership night, and create a view model to store values in PartnershipNight pnight = pnRepo.GetPartnershipNightById(partnershipNightId); PartnershipNightVM temp = new PartnershipNightVM() { AfterTheEventFinished = pnight.AfterTheEventFinished, BeforeTheEventFinished = pnight.BeforeTheEventFinished, CheckRequestFinished = pnight.CheckRequestFinished, BVLocation = pnight.BVLocation, Charity = pnight.Charity, StartDate = pnight.StartDate, EndDate = pnight.EndDate, Comments = pnight.Comments, CheckRequestId = pnight.CheckRequestId, PartnershipNightId = pnight.PartnershipNightId }; temp.BvLocations = lRepo.GetBvLocations().ToList <BvLocation>(); temp.Charities = charRepo.GetCharities().ToList <Charity>(); //PNightEditViewModel vModel = new PNightEditViewModel(); ////Set view model to corresponding partnership night values //vModel.PartnershipNight = pnight; //Set List variables to contain lists of child objects for selection in the view //vModel.Charities = charRepo.GetCharities().ToList<Charity>(); //vModel.Locations = lRepo.GetBvLocations().ToList<BvLocation>(); return(View(temp)); }
public ActionResult PartnershipNightEdit(PNightEditViewModel pn) { var pnEvent = new PartnershipNight(); if (pn.PartnershipNight.PartnershipNightId != 0) { pnEvent.PartnershipNightId = pn.PartnershipNight.PartnershipNightId; } pnEvent.EndDate = pn.PartnershipNight.EndDate; pnEvent.StartDate = pn.PartnershipNight.StartDate; pnEvent.AfterTheEventFinished = pn.PartnershipNight.AfterTheEventFinished; pnEvent.BeforeTheEventFinished = pn.PartnershipNight.BeforeTheEventFinished; pnEvent.CheckRequestFinished = pn.PartnershipNight.CheckRequestFinished; pnEvent.CheckRequestId = pn.PartnershipNight.CheckRequestId; pnEvent.Comments = pn.PartnershipNight.Comments; pnEvent.BVLocation = lRepo.GetBvLocation(pn.PartnershipNight.BVLocation.BvLocationId); pnEvent.Charity = charRepo.GetCharityById(pn.PartnershipNight.Charity.CharityId); if (pnEvent != null && pnEvent.BVLocation != null && pnEvent.Charity != null) { pnRepo.UpdatePartnershipNight(pnEvent); TempData["message"] = string.Format("Event for {0} has been saved", pn.PartnershipNight.Charity.Name); return(RedirectToAction("PartnershipNightIndex")); } else { return(View()); } }
/* * public IQueryable<PartnershipNight> GetPartnershipNightsByMonth(DateTime extractMonthAndYear) * { * throw new NotImplementedException(); * } * * public IQueryable<PartnershipNight> GetPartnershipNightsByDate(DateTime date) * { * throw new NotImplementedException(); * } * * public IQueryable<PartnershipNight> GetPartnershipNightsByLoc(BvLocation loc) * { * throw new NotImplementedException(); * } * * public IQueryable<PartnershipNight> GetPartnershipNightsByDateRange(DateTime firstDate, DateTime lastDate, BvLocation loc) * { * throw new NotImplementedException(); * } */ public void UpdatePartnershipNight(PartnershipNight pn) { var db = new CapstoneDbContext(); if (pn.PartnershipNightId == 0) { pn.Charity = db.Charities.Find(pn.Charity.CharityId); pn.BVLocation = db.BvLocations.Find(pn.BVLocation.BvLocationId); db.PartnershipNights.Add(pn); } else { var dbEntry = db.PartnershipNights.Find(pn.PartnershipNightId); if (dbEntry != null) { dbEntry.Date = pn.Date; dbEntry.Charity = pn.Charity; dbEntry.BVLocation = pn.BVLocation; dbEntry.CheckRequestId = pn.CheckRequestId; dbEntry.Comments = pn.Comments; dbEntry.CheckRequestFinished = pn.CheckRequestFinished; dbEntry.BeforeTheEventFinished = pn.BeforeTheEventFinished; dbEntry.AfterTheEventFinished = pn.AfterTheEventFinished; } } db.SaveChanges(); }
public void UpdatePartnershipNight(PartnershipNightVM pn) { var db = new ApplicationDbContext(); if (pn.PartnershipNightId == 0) { db.PartnershipNights.Add(new PartnershipNight() { StartDate = pn.StartDate, EndDate = pn.EndDate, Comments = pn.Comments, Charity = db.Charities.Find(pn.Charity.CharityId), BVLocation = db.BvLocations.Find(pn.BVLocation.BvLocationId) }); } else { PartnershipNight dbEntry = db.PartnershipNights.Find(pn.PartnershipNightId); if (dbEntry != null) { dbEntry.StartDate = pn.StartDate; dbEntry.EndDate = pn.EndDate; dbEntry.Comments = pn.Comments; dbEntry.Charity = db.Charities.Find(pn.Charity.CharityId); dbEntry.BVLocation = db.BvLocations.Find(pn.BVLocation.BvLocationId); } } db.SaveChanges(); }
public ActionResult Edit(PNightEditViewModel vmodel) { //PartnershipNight pnight = pnRepo.GetPartnershipNights().FirstOrDefault<PartnershipNight>(pn => pn.PartnershipNightId) if (ModelState.IsValid) { // Transfer view model values to a partnership night object PartnershipNight pnight = new PartnershipNight(); pnight.PartnershipNightId = vmodel.PartnershipNightId; pnight.Date = vmodel.Date; pnight.Comments = vmodel.Comments; pnight.CheckRequestId = vmodel.CheckRequestId; pnight.CheckRequestFinished = vmodel.CheckRequestFinished; pnight.BeforeTheEventFinished = vmodel.BeforeTheEventFinished; pnight.AfterTheEventFinished = vmodel.AfterTheEventFinished; // Store the correct child objects pnight.Charity = charRepo.GetCharities().FirstOrDefault(ch => ch.CharityId == vmodel.CharityId); pnight.BVLocation = bvlocRepo.GetBvLocations().FirstOrDefault(bvl => bvl.BvLocationId == vmodel.BVLocationId); // Save the changes to the partnership night pnRepo.UpdatePartnershipNight(pnight); TempData["message"] = string.Format("Partnership Night for BV Location {0}, {1} has been saved", pnight.Date.ToShortDateString(), pnight.BVLocation.BvStoreNum); return(RedirectToAction("Index")); } else { // there is something wrong with the data values return(View(vmodel)); } }
public ActionResult Edit(int partnershipNightId) { // Get the correct partnership night, and create a view model to store values in PartnershipNight pnight = pnRepo.GetPartnershipNights().FirstOrDefault(pn => pn.PartnershipNightId == partnershipNightId); PNightEditViewModel vmodel = new PNightEditViewModel(); //Set view model to corresponding partnership night values vmodel.PartnershipNightId = pnight.PartnershipNightId; vmodel.Date = pnight.Date; vmodel.CharityId = pnight.Charity.CharityId; vmodel.BVLocationId = pnight.BVLocation.BvLocationId; vmodel.CheckRequestId = pnight.CheckRequestId; vmodel.Comments = pnight.Comments; vmodel.CheckRequestFinished = pnight.CheckRequestFinished; vmodel.BeforeTheEventFinished = pnight.BeforeTheEventFinished; vmodel.AfterTheEventFinished = pnight.AfterTheEventFinished; //Set List variables to contain lists of child objects for selection in the view vmodel.Charities = charRepo.GetCharities().ToList <Charity>(); vmodel.Locations = bvlocRepo.GetBvLocations().ToList <BvLocation>(); //Set session variables to contain lists of child objects for selection in the view //Session["charities"] = charRepo.GetCharities().ToList<Charity>(); //Session["bvlocations"] = bvlocRepo.GetBvLocations().ToList<BvLocation>(); return(View(vmodel)); }
public void UpdateEvent(int id, string NewEventStart, string NewEventEnd) { //find the pn with the id PartnershipNight pn = pnRepo.GetPartnershipNightById(id); pn.StartDate = DateTime.Parse(NewEventStart); pn.EndDate = DateTime.Parse(NewEventEnd); pnRepo.UpdatePartnershipNight(pn); }
public void AddPartnershipNight(PartnershipNight pn) { //throw new NotImplementedException(); var db = new CapstoneDbContext(); db.PartnershipNights.Add(pn); db.SaveChanges(); //TODO: Add in error handling }
public ActionResult PartnershipNightDelete(int partnershipNightId) { PartnershipNight deletedPNight = pnRepo.DeletePartnershipNight(partnershipNightId); if (deletedPNight != null) { TempData["message"] = string.Format("Event on {0} was deleted", deletedPNight.StartDate.ToShortDateString()); } return(RedirectToAction("PartnershipNightIndex")); }
public ActionResult PartnershipNightEdit(int partnershipNightId) { TempData["Title"] = "Edit"; // Get the correct partnership night, and create a view model to store values in PartnershipNight pnight = pnRepo.GetPartnershipNightById(partnershipNightId); PNightEditViewModel temp = new PNightEditViewModel(); temp.PartnershipNight = pnight; temp.Locations = lRepo.GetBvLocations().ToList <BvLocation>(); temp.Charities = charRepo.GetCharities().ToList <Charity>(); return(View(temp)); }
public PartnershipNight DeletePartnershipNight(int id) //should this take a partnership night or id as parameter? { //throw new NotImplementedException(); var db = new CapstoneDbContext(); PartnershipNight dbEntry = db.PartnershipNights.Find(id); if (dbEntry != null) { db.PartnershipNights.Remove(dbEntry); db.SaveChanges(); } return(dbEntry); //TODO: Add in error handling }
//TODO: need use event props to create pnight props and save that to db public bool CreateNewEvent(string Title, int id, string NewStartDate, string NewStartTime, string NewEndDt, string NewEndTime) { try { var db = new ApplicationDbContext(); PartnershipNight rec = new PartnershipNight(); rec.Charity = db.Charities.Find(Title); rec.BVLocation = db.BvLocations.Find(id); rec.StartDate = DateTime.ParseExact(NewStartDate + " " + NewStartTime, "MM/dd/yyyy HH:mm tt", CultureInfo.InvariantCulture); rec.EndDate = DateTime.ParseExact(NewEndDt + " " + NewEndTime, "MM/dd/yyyy H:mm tt", CultureInfo.InvariantCulture); db.PartnershipNights.Add(rec); db.SaveChanges(); } catch (Exception) { return(false); } return(true); }