/*<summary>
* Edits the event if EventId>0 else Adds the event to the
* Database
* </summary>*/
/// <param name="eventModel"> Gets the Event object from controller that is given
/// as input by user to create or edit</param>
/// <param name="currentUser"> gets the user who edits or creates it</param>
/*<returns>The List of Events</returns>*/
public List <Event> EditEventList(Event eventModel, string currentUser)
{
if (eventModel.EventID > 0)
{
Event editEvents = db.Events.Include("Teams").Include("PitStops").SingleOrDefault(x => x.EventID == eventModel.EventID);
editEvents.EventName = eventModel.EventName;
editEvents.EventDescription = eventModel.EventDescription;
editEvents.EventCountry = eventModel.EventCountry;
editEvents.EventCity = eventModel.EventCity;
editEvents.StartDate = eventModel.StartDate;
editEvents.EndDate = eventModel.EndDate;
editEvents.LastModifiedBy = currentUser;
editEvents.LastModifiedAt = DateTime.Now;
editEvents.ImagePath = eventModel.ImagePath;
db.SaveChanges();
}
else
{
eventModel.CreatedBy = currentUser;
db.Events.Add(eventModel);
db.SaveChanges();
}
return(db.Events.OrderBy(o => o.StartDate).ToList());;
}
public List <Event> EditEventList(Event eventModel, string currentUser)
{
if (eventModel.EventID > 0)
{
Event editEvents = db.Events.SingleOrDefault(x => x.EventID == eventModel.EventID);
editEvents.EventName = eventModel.EventName;
editEvents.EventDescription = eventModel.EventDescription;
editEvents.EventCountry = eventModel.EventCountry;
editEvents.EventCity = eventModel.EventCity;
editEvents.StartDate = eventModel.StartDate;
editEvents.EndDate = eventModel.EndDate;
editEvents.TotalPitStops = eventModel.TotalPitStops;
editEvents.TotalTeams = eventModel.TotalTeams;
editEvents.LastModifiedBy = currentUser;
editEvents.LastModifiedAt = DateTime.Now;
db.SaveChanges();
}
else
{
eventModel.CreatedBy = currentUser;
db.Events.Add(eventModel);
db.SaveChanges();
}
return(db.Events.ToList());;
}
public List <PitStop> CreatePitStopList(PitStop pitStop, string currentUser)
{
if (pitStop.PitStopID > 0)
{
PitStop editPitStops = db.PitStops.SingleOrDefault(x => x.PitStopID == pitStop.PitStopID);
editPitStops.PitStopName = pitStop.PitStopName;
editPitStops.SequenceNumber = pitStop.SequenceNumber;
editPitStops.Address = pitStop.Address;
editPitStops.LastModifiedBy = currentUser;
editPitStops.LastModifiedAt = DateTime.Now;
db.SaveChanges();
pitStop.CreatedBy = currentUser;
//db.PitStops.Add(pitStop);
db.SaveChanges();
}
else
{
pitStop.CreatedBy = currentUser;
db.PitStops.Add(pitStop);
db.SaveChanges();
}
return(db.PitStops.ToList());
}
public void DeleteTeam(int teamId)
{
Team team = db.Teams.SingleOrDefault(x => x.TeamID == teamId);
db.Teams.Remove(team);
db.SaveChanges();
}
public List <Member> AddMembers(String email, int teamId, int eventId)
{
Member member = new Member();
Event events = db.Events.SingleOrDefault(x => x.EventID == eventId);
Team teams = db.Teams.SingleOrDefault(x => x.TeamID == teamId);
member.MemberName = email;
member.Event = events;
member.Team = teams;
db.Members.Add(member);
db.SaveChanges();
return(getMembers(teamId, eventId));
}
/*<summary>
* Create and edit pitStops for the eventId
* </summary>
* <returns>
* List of pitStops created/updated
* </returns>*/
/// <param name="pitStop"></param>
/// <param name="currentUser"></param>
/// <param name="eventId"></param>
/// <param name="userId"></param>
public List <PitStop> CreatePitStopList(PitStop pitStop, string currentUser, int eventId, string userId)
{
if (pitStop.PitStopID > 0)
{
PitStop editPitStops = db.PitStops.SingleOrDefault(x => x.PitStopID == pitStop.PitStopID);
editPitStops.PitStopName = pitStop.PitStopName;
editPitStops.SequenceNumber = pitStop.SequenceNumber;
editPitStops.Address = pitStop.Address;
editPitStops.Latitude = pitStop.Latitude;
editPitStops.Longitude = pitStop.Longitude;
editPitStops.LastModifiedBy = currentUser;
Event currentEvent = db.Events.SingleOrDefault(x => x.EventID == eventId);
pitStop.Event = currentEvent;
TARUser staffInfo = db.Users.FirstOrDefault(d => d.Id == userId);
editPitStops.Staff = staffInfo;
editPitStops.LastModifiedAt = DateTime.Now;
db.SaveChanges();
pitStop.CreatedBy = currentUser;
//db.PitStops.Add(pitStop);
db.SaveChanges();
}
else
{
pitStop.CreatedBy = currentUser;
pitStop.Staff.Id = userId;
Event currentEvent = db.Events.SingleOrDefault(x => x.EventID == eventId);
TARUser staffInfo = db.Users.FirstOrDefault(d => d.Id == userId);
pitStop.Staff = staffInfo;
pitStop.Event = currentEvent;
db.PitStops.Add(pitStop);
db.SaveChanges();
}
return(getPitStopOfEvent(eventId));
}
public void Save()
{
try
{
_context.SaveChanges();
}
catch (DbEntityValidationException e)
{
var outputLines = new List <string>();
foreach (var eve in e.EntityValidationErrors)
{
outputLines.Add(string.Format("{0}: Entity of type \"{1}\" in state \"{2}\" has the following validation errors:", DateTime.Now, eve.Entry.Entity.GetType().Name, eve.Entry.State));
foreach (var ve in eve.ValidationErrors)
{
outputLines.Add(string.Format("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage));
}
}
System.IO.File.AppendAllLines(@"C:\errors.txt", outputLines);
throw e;
}
}
