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 void DeleteCosplan(int nummer)
{
Cosplans cosplans = new Cosplans
{
Where = "Nummer = " + nummer
};
cosplans.Read();
if (!cosplans.EoF)
{
cosplans.Delete();
}
}
public Cosplans GetCosplans(int?franchise_nr = null)
{
Cosplans cosplans = new Cosplans();
if (franchise_nr == null || franchise_nr == 0)
{
cosplans.Where = "Nummer is not null";
}
else
{
cosplans.Where = "Franchise_Nr = " + franchise_nr;
}
cosplans.OrderBy = this.CosplansOrderBy.ToString().Replace("_", " ");
cosplans.Read();
return(cosplans);
}
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);
}
}