public static void CheckParties()
{
using (var db = new PartyContext())
{
Debug.WriteLine("fff");
foreach (Party party in db.parties)
{
if (party.ToDate.CompareTo(DateTime.Today) < 0 && !party.AlreadyDone)
{
party.AlreadyDone = true;
var partyDb = db.parties.Find(party.PartyId);
db.Entry(partyDb).CurrentValues.SetValues(party);
Party tmp = new Party();
Party newParty = Utilities.CloneJson <Party>(party);
newParty.PartyId = tmp.PartyId;
newParty.StandsAsStrings = null;
newParty.FilesAsStrings = null;
newParty.Accepted = true;
newParty.AlreadyDone = false;
newParty.ToDate = newParty.ToDate.AddMonths(party.Frequency);
newParty.Date = newParty.Date.AddMonths(party.Frequency);
db.parties.Add(newParty);
}
}
db.SaveChanges();
}
}
public static void DeleteStands(Party partyTmp, List <string> Stands)
{
using (var db = new PartyContext())
{
Party party = db.parties.Find(partyTmp.PartyId);
if (party != null)
{
List <string> realStands = party.StandsIDs;
List <string> removedstand = Stands.Except(realStands).ToList();
foreach (string standId in removedstand)
{
var stand = db.stands.Find(Convert.ToInt32(standId));
db.Entry(stand).State = Microsoft.EntityFrameworkCore.EntityState.Deleted;
}
}
else
{
if (partyTmp.StandsIDs != null)
{
foreach (string standId in partyTmp.StandsIDs)
{
var stand = db.stands.Find(Convert.ToInt32(standId));
db.Entry(stand).State = Microsoft.EntityFrameworkCore.EntityState.Deleted;
}
}
}
db.SaveChanges();
}
}
public static void DeleteToolEntry(Tool element)
{
using (var db = new PartyContext())
{
db.Entry(element).State = Microsoft.EntityFrameworkCore.EntityState.Deleted;
db.SaveChanges();
}
}
public static void DeletePartyEntry(Party element)
{
RemoveStands(element);
using (var db = new PartyContext())
{
db.Entry(element).State = Microsoft.EntityFrameworkCore.EntityState.Deleted;
db.SaveChanges();
}
}
public static void RemoveStands(Party party)
{
using (var db = new PartyContext())
{
foreach (Stand stand in GetStandsByID(party.StandsIDs))
{
db.Entry(stand).State = Microsoft.EntityFrameworkCore.EntityState.Deleted;
}
db.SaveChanges();
}
}
public void Vote(Participant participant)
{
if (participant.Name != string.Empty)
{
Participant temp = _context.Participants.FirstOrDefault(p => p.Name == participant.Name);
if (temp != null)
{
temp.IsAttending = participant.IsAttending;
temp.PartyId = participant.PartyId;
if (participant.Avatar != null)
{
temp.Avatar = participant.Avatar;
}
_context.SaveChanges();
}
else
{
_context.Participants.Add(participant);
_context.SaveChanges();
}
}
}
public EventMutation()
{
var db = new PartyContext();
Field <EventType>(
"createEvent",
arguments: new QueryArguments(
new QueryArgument <NonNullGraphType <EventInputType> > {
Name = "event"
},
new QueryArgument <NonNullGraphType <StringGraphType> > {
Name = "email"
}
),
resolve: context =>
{
var ev = context.GetArgument <Event>("event");
var email = context.GetArgument <string>("email");
ev.Owner = db.Contacts.FirstOrDefault(c => c.Email == email);
db.Events.Add(ev);
db.SaveChanges();
return(ev);
});
Field <ListGraphType <ContrubutionType> >(
"createContributions",
arguments: new QueryArguments(
new QueryArgument <NonNullGraphType <ListGraphType <ContributionInputType> > > {
Name = "contributions"
}
),
resolve: context =>
{
var contributions = context.GetArgument <List <Contribution> >("contributions");
db.Contributions.AddRange(contributions);
db.SaveChanges();
return(contributions);
});
Field <ContactType>(
"createContact",
arguments: new QueryArguments(
new QueryArgument <NonNullGraphType <ContactInputType> > {
Name = "contact"
}
),
resolve: context =>
{
var ct = context.GetArgument <Contact>("contact");
db.Contacts.Add(ct);
db.SaveChanges();
return(ct);
});
Field <ListGraphType <EventGuestType> >(
"createEventGuests",
arguments: new QueryArguments(
new QueryArgument <NonNullGraphType <ListGraphType <EventGuestInputType> > > {
Name = "eventGuest"
}
),
resolve: context =>
{
var guests = context.GetArgument <List <EventGuest> >("eventGuest");
db.EventGuests.AddRange(guests);
db.SaveChanges();
return(guests);
});
}
