public IActionResult UpdateTravelCost(int travelMemberId, string paid) { TravelMember x = _parteiDbContext.TravelMembers.SingleOrDefault(x => x.ID.Equals(travelMemberId)); if (paid.Equals("true")) { x.ActualCosts = x.TargetCosts; } else { x.ActualCosts = 0; } _parteiDbContext.Update(x); _parteiDbContext.SaveChanges(); var tripAddUserViewModel = new TripAddUserViewModel { Members = _parteiDbContext.Members.ToList(), ExternalMembers = _parteiDbContext.ExternalMembers.ToList(), SelectedExternalMemeberIDs = new List <String>(), TravelMembers = _parteiDbContext.TravelMembers.ToList(), Travel = _parteiDbContext.Travels.Single(x => x.TravelId == 1), Stops = _parteiDbContext.Stops.ToList(), ExternalTravelMembers = _parteiDbContext.ExternalTravelMembers.Include(x => x.ExternalMember).ToList(), }; return(PartialView("_TravelMemberTable", tripAddUserViewModel)); }
public IActionResult UpdateStop(string MemberID, int travelId, int stopId) { TravelMember x = _parteiDbContext.TravelMembers.SingleOrDefault(x => x.Travel.TravelId.Equals(travelId) && x.Member.ID.Equals(MemberID)); x.StopId = stopId; _parteiDbContext.Update(x); _parteiDbContext.SaveChanges(); //TODO Die Liste sauber befüllen... List <Member> members = _parteiDbContext.Members.ToList(); List <ExternalMember> externalMembers = _parteiDbContext.ExternalMembers.ToList(); List <TravelMember> travelMembers = _parteiDbContext.TravelMembers.Where(x => x.Travel.TravelId.Equals(travelId)).ToList(); List <ExternalTravelMember> externalTravelMembers = _parteiDbContext.ExternalTravelMembers.Where(x => x.Travel.TravelId.Equals(travelId)).ToList(); List <Stop> stops = _parteiDbContext.Stops.Include(x => x.TravelStops).Where(s => s.TravelStops.Select(x => x.TravelId.Equals(travelId)).First()).ToList(); var tripAddUserViewModel = new TripAddUserViewModel { Members = members, ExternalMembers = externalMembers, SelectedExternalMemeberIDs = null, TravelMembers = travelMembers, Travel = _parteiDbContext.Travels.Single(x => x.TravelId == travelId), Stops = stops, ExternalTravelMembers = externalTravelMembers, }; return(PartialView("_TravelMemberTable", tripAddUserViewModel)); }
public IActionResult Index(int TravelId) { var tid = TravelId; TravelMember trav3 = new TravelMember { TargetCosts = 20, ActualCosts = 0, }; List <Stop> stops = _parteiDbContext.Stops.Include(x => x.TravelStops).Where(s => s.TravelStops.Select(x => x.TravelId.Equals(TravelId)).First()).ToList(); //stops.Add(_parteiDbContext.Stops.SingleOrDefault(x => x.StopId.Equals(-1))); List <Member> allMembers = _parteiDbContext.Members.ToList(); List <ExternalMember> allExternalMembers = _parteiDbContext.ExternalMembers.ToList(); List <TravelMember> allTravelMembers = _parteiDbContext.TravelMembers.Where(x => x.Travel.TravelId.Equals(TravelId)).ToList(); List <ExternalTravelMember> externalTravelMembers = _parteiDbContext.ExternalTravelMembers.Where(x => x.Travel.TravelId.Equals(TravelId)).ToList(); List <string> allMemberstr = _parteiDbContext.Members.Select(x => x.ID).ToList(); List <string> allTravelMembersStr = _parteiDbContext.TravelMembers.Where(x => x.Travel.TravelId.Equals(TravelId)).Select(x => x.Member.ID).ToList(); List <string> s = allMemberstr.Except(allTravelMembersStr).ToList(); List <Member> mem = new List <Member>(); foreach (string id in s) { mem.Add(_parteiDbContext.Members.Single(x => x.ID.Equals(id))); } var travel = _parteiDbContext.Travels.Single(x => x.TravelId == TravelId); List <string> allExternalMemberstr = _parteiDbContext.ExternalMembers.Select(x => x.ID).ToList(); List <string> allExternalTravelMembersStr = _parteiDbContext.ExternalTravelMembers.Where(x => x.Travel.TravelId.Equals(TravelId)).Select(x => x.ExternalMember.ID).ToList(); List <string> es = allExternalMemberstr.Except(allExternalTravelMembersStr).ToList(); List <ExternalMember> exmem = new List <ExternalMember>(); foreach (string id in es) { exmem.Add(_parteiDbContext.ExternalMembers.Single(x => x.ID.Equals(id))); } // var testStops = _parteiDbContext.Stops.ToList(); //var tupleModel = new Tuple<List<Member>, List<ExternalMember>, List<TravelMember>, Travel, List<Stop>, List<ExternalTravelMember>>(mem, allExternalMembers, allTravelMembers, travel, testStops, allExternalTravelMembers); var tripAddUserViewModel = new TripAddUserViewModel { Members = mem, ExternalMembers = exmem, SelectedExternalMemeberIDs = new List <String>(), TravelMembers = allTravelMembers, Travel = travel, Stops = stops, ExternalTravelMembers = externalTravelMembers }; return(View(tripAddUserViewModel)); //return View(tupleModel); }
public IActionResult Delete(TravelMember travelMember) { /* * Das Funkt so noch nicht * */ //var travelMember = _parteiDbContext.Remove(travelMember.ID); _parteiDbContext.SaveChanges(); return(RedirectToAction("Index")); }
public IActionResult AddMemberToTrip(Member member) { TravelMember travelMember = new TravelMember(); travelMember.Member = member; _parteiDbContext.Add(travelMember); _parteiDbContext.SaveChanges(); return(RedirectToAction("Index")); }
public IActionResult GetTravelMemberData(string MemberID, int travelId) { //var travelId = Convert.ToInt32(TravelId); var Member = _parteiDbContext.Members.Single(member => member.ID.Equals(MemberID)); if (_parteiDbContext.TravelMembers.Count(x => x.Member.Equals(Member)) > 1) { throw new Exception("Travelmember existiert bereits"); } var travel = _parteiDbContext.Travels.Single(travel => travel.TravelId.Equals(travelId)); var TravelMember = new TravelMember { ActualCosts = 0, Member = Member, Travel = travel }; Console.WriteLine(TravelMember); var t = _parteiDbContext.TravelMembers.Add(TravelMember); _parteiDbContext.SaveChanges(); List <string> allMemberstr = _parteiDbContext.Members.Select(x => x.ID).ToList(); List <string> allTravelMembersStr = _parteiDbContext.TravelMembers.Where(x => x.Travel.TravelId.Equals(travelId)).Select(x => x.Member.ID).ToList(); List <string> s = allMemberstr.Except(allTravelMembersStr).ToList(); List <Member> mem = new List <Member>(); foreach (string id in s) { mem.Add(_parteiDbContext.Members.Single(x => x.ID.Equals(id))); } List <Stop> stops = _parteiDbContext.Stops.ToList(); //evl hängt es hier an den Stops... var member = _parteiDbContext.TravelMembers.Include(x => x.Member).Where(x => x.Travel.TravelId.Equals(travelId)).ToList(); List <ExternalTravelMember> externalTravelMembers = _parteiDbContext.ExternalTravelMembers.Where(x => x.Travel.TravelId.Equals(travelId)).ToList(); List <ExternalMember> externalMembers = _parteiDbContext.ExternalMembers.ToList(); var tripAddUserViewModel = new TripAddUserViewModel { Members = mem, ExternalMembers = externalMembers, SelectedExternalMemeberIDs = null, TravelMembers = member, Travel = _parteiDbContext.Travels.Single(x => x.TravelId.Equals(travelId)), Stops = stops, ExternalTravelMembers = externalTravelMembers }; return(PartialView("_TravelMemberTable", tripAddUserViewModel)); }