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 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 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();
}
}
