public void SaveCosplan(string name = "", int franchise_nr = 0, int?nummer = null, bool erledigt = false) { Cosplans cosplans = new Cosplans(); if (!string.IsNullOrEmpty(name)) { cosplans.Name = name; } if (franchise_nr > 0) { cosplans.Franchise_Nr = franchise_nr; } if (nummer == null) { cosplans.Erledigt = false; cosplans.Save(ApS.Databases.SqlAction.Insert); } else { cosplans.Where = "Nummer = " + nummer; cosplans.Erledigt = erledigt; cosplans.Save(ApS.Databases.SqlAction.Update); } }
public static void ResetCosplanNummern() { using (Cosplans cosplans = new Cosplans()) { // read highest number cosplans.Where = "Nummer is not null"; cosplans.OrderBy = "Nummer desc"; cosplans.AnzahlTop = 1; cosplans.Read(); int newNummer = cosplans.Nummer + 1; cosplans.OrderBy = "Franchise_Nr asc, Nummer asc"; cosplans.Read(); while (!cosplans.EoF) { cosplans.Where = "Nummer = " + cosplans.Nummer; cosplans.Nummer = newNummer++; cosplans.Save(ApS.Databases.SqlAction.Update); cosplans.Skip(); } // now reset all cosplans.Where = "Nummer is not null"; cosplans.Read(); newNummer = 1; while (!cosplans.EoF) { cosplans.Where = "Nummer = " + cosplans.Nummer; cosplans.Nummer = newNummer++; cosplans.Save(ApS.Databases.SqlAction.Update); cosplans.Skip(); } string stmt = "ALTER SEQUENCE GEN_COSPLANS_ID RESTART WITH " + --newNummer + ";"; cosplans.Execute(stmt); } }