/*<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; } }