/// <summary> /// Insert the record. /// </summary> public static int Insert(stadion stadion, Database pDb = null) { Database db; if (pDb == null) { db = new Database(); db.Connect(); } else { db = (Database)pDb; } SqlCommand command = db.CreateCommand(SQL_INSERT); PrepareCommand(command, stadion); int ret = db.ExecuteNonQuery(command); if (pDb == null) { db.Close(); } return(ret); }
public static int Update(stadion stadion, Database pDB = null) { Database db; if (pDB == null) { db = new Database(); db.Connect(); } else { db = (Database)pDB; } SqlCommand command = db.CreateCommand(SQL_UPDATE); PrepareCommand(command, stadion); int ret = db.ExecuteNonQuery(command); if (pDB == null) { db.Close(); } return(ret); }
private static void PrepareCommand(SqlCommand command, stadion stadion) { command.Parameters.AddWithValue("@idstadion", stadion.Idstadion); command.Parameters.AddWithValue("@nazev", stadion.Nazev); command.Parameters.AddWithValue("@kapacita", stadion.Kapacita); command.Parameters.AddWithValue("@mesto", stadion.Mesto); command.Parameters.AddWithValue("@ulice", stadion.Ulice); command.Parameters.AddWithValue("@psc", stadion.Psc); }
public static XElement Insert(stadion stadion) { return(new XElement("stadion", new XAttribute("Idstadion", stadion.Idstadion.ToString()), new XAttribute("Nazev", stadion.Nazev), new XAttribute("Kapacita", stadion.Kapacita.ToString()), new XAttribute("Mesto", stadion.Mesto), new XAttribute("Ulice", stadion.Ulice), new XAttribute("Psc", stadion.Psc.ToString()))); }
private static List <stadion> Read(SqlDataReader dataReader) { List <stadion> list = new List <stadion>(); while (dataReader.Read()) { int i = -1; stadion stadion = new stadion(); stadion.Idstadion = dataReader.GetInt32(++i); stadion.Nazev = dataReader.GetString(++i); stadion.Kapacita = dataReader.GetInt32(++i); stadion.Mesto = dataReader.GetString(++i); stadion.Ulice = dataReader.GetString(++i); stadion.Psc = dataReader.GetString(++i); list.Add(stadion); } return(list); }