public static int Update(PoziceZamestnance pz, 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, pz); int ret = db.ExecuteNonQuery(command); if (pDb == null) { db.Close(); } return(ret); }
private static Collection <PoziceZamestnance> Read(SqlDataReader reader) { Collection <PoziceZamestnance> pzC = new Collection <PoziceZamestnance>(); while (reader.Read()) { int i = -1; PoziceZamestnance pz = new PoziceZamestnance(); pz.ID_poziceZamestnance = reader.GetInt32(++i); pz.ID_zamestnance = reader.GetInt32(++i); pz.ID_pozice = reader.GetInt32(++i); pzC.Add(pz); } return(pzC); }
public static PoziceZamestnance 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_poziceZamestnance", id); SqlDataReader reader = db.Select(command); Collection <PoziceZamestnance> pzC = Read(reader); PoziceZamestnance pz = null; if (pzC.Count == 1) { pz = pzC[0]; } reader.Close(); if (pDb == null) { db.Close(); } if (pz == null) { Console.WriteLine("Pozice zamestnance neexistuje"); } return(pz); }
private static void PrepareCommand(SqlCommand command, PoziceZamestnance pz) { command.Parameters.AddWithValue("@ID_poziceZamestnance", pz.ID_poziceZamestnance); command.Parameters.AddWithValue("@ID_zamestnance", pz.ID_zamestnance); command.Parameters.AddWithValue("@ID_pozice", pz.ID_pozice); }