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