/// <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);
}
