public static int Update(Duvod duvod, MyDatabase pDb = null) { MyDatabase db; if (pDb == null) { db = new MyDatabase(); db.Connect(); } else { db = (MyDatabase)pDb; } SqlCommand command = db.CreateCommand(SQL_UPDATE); PrepareCommand(command, duvod); int ret = db.ExecuteNonQuery(command); if (pDb == null) { db.Close(); } return(ret); }
public static int Insert(Duvod duvod, MyDatabase pDB = null) { MyDatabase db; if (pDB == null) { db = new MyDatabase(); db.Connect(); } else { db = (MyDatabase)pDB; } SqlCommand command = db.CreateCommand(SQL_INSERT); PrepareCommand(command, duvod); int ret = db.ExecuteNonQuery(command); if (pDB == null) { db.Close(); } return(ret); }
private static Collection <Duvod> Read(SqlDataReader reader) { Collection <Duvod> duvody = new Collection <Duvod>(); while (reader.Read()) { int i = -1; Duvod duvod = new Duvod(); duvod.ID_duvodu = reader.GetInt32(++i); duvod.Nazev = reader.GetString(++i); duvody.Add(duvod); } return(duvody); }
public static Duvod Select(int id, MyDatabase pDb = null) { MyDatabase db; if (pDb == null) { db = new MyDatabase(); db.Connect(); } else { db = (MyDatabase)pDb; } SqlCommand command = db.CreateCommand(SQL_SELECT_ID); command.Parameters.AddWithValue("@ID_duvodu", id); SqlDataReader reader = db.Select(command); Collection <Duvod> duvody = Read(reader); Duvod duvod = null; if (duvody.Count == 1) { duvod = duvody[0]; } reader.Close(); if (pDb == null) { db.Close(); } if (duvod == null) { Console.WriteLine("Duvod neexistuje"); } return(duvod); }
private static void PrepareCommand(SqlCommand command, Duvod duvod) { command.Parameters.AddWithValue("@ID_duvodu", duvod.ID_duvodu); command.Parameters.AddWithValue("@Nazev", duvod.Nazev); }