public IActionResult UpdateStopExternal(string ExternalMemberId, int travelId, int stopId)
{
ExternalTravelMember x = _parteiDbContext.ExternalTravelMembers.SingleOrDefault(x => x.Travel.TravelId.Equals(travelId) && x.ExternalMember.ID.Equals(ExternalMemberId));
x.StopId = stopId;
_parteiDbContext.Update(x);
_parteiDbContext.SaveChanges();
//TODO Die Liste suaber befüllen...
// Funktion im Frontend dann noch callen!
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 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 GetExternalMemberData(int travelId)
{
// List<ExternalMember> externalMembers = _parteiDbContext.ExternalMembers.ToList();
List <Stop> stops = _parteiDbContext.Stops.ToList();
//stops.Add(_parteiDbContext.Stops.SingleOrDefault(x => x.StopId.Equals(-1)));
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 <Member> members = _parteiDbContext.Members.ToList();
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 tripAddUserViewModel = new TripAddUserViewModel
{
Members = members,
ExternalMembers = exmem,
SelectedExternalMemeberIDs = null,
TravelMembers = travelMembers,
Travel = _parteiDbContext.Travels.Single(x => x.TravelId == travelId),
Stops = stops,
ExternalTravelMembers = externalTravelMembers
};
return(PartialView("_ExternalMemberDropdown", tripAddUserViewModel));
}
public IActionResult DeleteExternalTravelMemberData(string ExternalMemberID, string TravelId)
{
var travelId = Convert.ToInt32(TravelId);
var tm = _parteiDbContext.ExternalTravelMembers.Single(x => x.ExternalMember.ID.Equals(ExternalMemberID) && x.Travel.TravelId.Equals(travelId));
var t = _parteiDbContext.ExternalTravelMembers.Remove(tm);
_parteiDbContext.SaveChanges();
List <ExternalMember> externalMembers = _parteiDbContext.ExternalMembers.ToList();
List <Stop> stops = _parteiDbContext.Stops.ToList();
//stops.Add(_parteiDbContext.Stops.SingleOrDefault(x => x.StopId.Equals(-1)));
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 <Member> members = _parteiDbContext.Members.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 AddExternalMemberToTrip(TripAddUserViewModel tripAddUserViewModel)
{
int travelId = tripAddUserViewModel.Travel.TravelId;
int stopId = tripAddUserViewModel.Stops[0].StopId;
foreach (var userId in tripAddUserViewModel.SelectedExternalMemeberIDs)
{
var externalMember = _parteiDbContext.ExternalMembers.Single(externalMember => externalMember.ID.Equals(userId));
Console.WriteLine(externalMember);
if (_parteiDbContext.ExternalTravelMembers.Count(x => x.ExternalMember.Equals(externalMember)) > 1)
{
throw new Exception("ExternalTravelMember existiert bereits");
}
var externalTravelMember = new ExternalTravelMember
{
ActualCosts = 0,
ExternalMember = _parteiDbContext.ExternalMembers.Single(externalMember => externalMember.ID.Equals(userId)),
Travel = _parteiDbContext.Travels.Single(travel => travel.TravelId.Equals(travelId)),
};
var t = _parteiDbContext.ExternalTravelMembers.Add(externalTravelMember);
_parteiDbContext.SaveChanges();
}
var externalMemberOne = _parteiDbContext.ExternalTravelMembers.Include(x => x.ExternalMember).ToList();
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)));
}
List <Stop> stops = _parteiDbContext.Stops.Include(x => x.TravelStops).Where(s => s.TravelStops.Select(x => x.TravelId.Equals(travelId)).First()).ToList();
var tripAddUserViewModelOut = new TripAddUserViewModel
{
Members = _parteiDbContext.Members.ToList(),
ExternalMembers = exmem,
SelectedExternalMemeberIDs = new List <String>(),
TravelMembers = _parteiDbContext.TravelMembers.ToList(),
Travel = _parteiDbContext.Travels.Single(x => x.TravelId == travelId),
Stops = stops,
ExternalTravelMembers = externalMemberOne
};
return(RedirectToAction("Index", new { TravelId = travelId }));
}
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));
}
public IActionResult GetExternalTravelMemberData(string ExternalMemberID, string TravelId)
{
var travelId = Convert.ToInt32(TravelId);
var externalMember = _parteiDbContext.ExternalMembers.Single(externalMember => externalMember.ID.Equals(ExternalMemberID));
if (_parteiDbContext.ExternalTravelMembers.Count(x => x.ExternalMember.Equals(externalMember)) > 1)
{
throw new Exception("ExternalTravelMember existiert bereits");
}
var externalTravelMember = new ExternalTravelMember
{
ActualCosts = 0,
ExternalMember = _parteiDbContext.ExternalMembers.Single(externalMember => externalMember.ID.Equals(ExternalMemberID)),
Travel = _parteiDbContext.Travels.Single(travel => travel.TravelId.Equals(travelId)),
};
var t = _parteiDbContext.ExternalTravelMembers.Add(externalTravelMember);
_parteiDbContext.SaveChanges();
var externalMemberOne = _parteiDbContext.ExternalTravelMembers.Include(x => x.ExternalMember).ToList();
List <Stop> stops = _parteiDbContext.Stops.ToList();
//stops.Add(_parteiDbContext.Stops.SingleOrDefault(x => x.StopId.Equals(-1)));
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();
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 DeleteTravelMemberData(string MemberID, int travelId)
{
var tm = _parteiDbContext.TravelMembers.Single(x => x.Member.ID.Equals(MemberID) && x.Travel.TravelId.Equals(travelId));
var t = _parteiDbContext.TravelMembers.Remove(tm);
_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)));
}
var member = _parteiDbContext.TravelMembers.Include(x => x.Member).Where(x => x.Travel.TravelId.Equals(travelId)).ToList();
List <Stop> stops = _parteiDbContext.Stops.ToList();
//stops.Add(_parteiDbContext.Stops.SingleOrDefault(x => x.StopId.Equals(-1)));
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
};
// so wird nur die TravelMemberTable aktualisiert... die MemberTable bleibt aber unverändert und wird halt beim neuladen dann wieder richtig initialisiert!
return(PartialView("_TravelMemberTable", tripAddUserViewModel));
// return RedirectToAction("Index", new { TravelId = travelId });
}
