public void AddPartnershipNight(PartnershipNight pn)
{
//throw new NotImplementedException();
var db = new ApplicationDbContext();
db.PartnershipNights.Add(pn);
db.SaveChanges();
//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;
}
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 void UpdatePartnershipNight(PartnershipNight pn)
{
var db = new ApplicationDbContext();
if (pn.PartnershipNightId == 0)
db.PartnershipNights.Add(pn);
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 void UpdatePartnershipNight(PartnershipNight pn)
{
var db = new ApplicationDbContext();
if (pn.PartnershipNightId == 0)
{
pn.BVLocation = db.BvLocations.Find(pn.BVLocation.BvLocationId);
pn.Charity = db.Charities.Find(pn.Charity.CharityId);
db.PartnershipNights.Add(pn);
}
else
{
PartnershipNight dbEntry = db.PartnershipNights.Find(pn.PartnershipNightId);
if (dbEntry != null)
{
dbEntry.StartDate = pn.StartDate;
dbEntry.EndDate = pn.EndDate;
dbEntry.AfterTheEventFinished = pn.AfterTheEventFinished;
dbEntry.BeforeTheEventFinished = pn.BeforeTheEventFinished;
dbEntry.CheckRequestFinished = pn.CheckRequestFinished;
dbEntry.CheckRequestId = pn.CheckRequestId;
dbEntry.Comments = pn.Comments;
dbEntry.Charity = db.Charities.Find(pn.Charity.CharityId);
dbEntry.BVLocation = db.BvLocations.Find(pn.BVLocation.BvLocationId);
}
}
db.SaveChanges();
}
