public static int Update(tym tym, 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, tym);
int ret = db.ExecuteNonQuery(command);
if (pDB == null)
{
db.Close();
}
return(ret);
}
private static List <tym> Read(SqlDataReader dataReader)
{
List <tym> list = new List <tym>();
while (dataReader.Read())
{
int i = -1;
tym tym = new tym();
tym.Idtym = dataReader.GetInt32(++i);
tym.Nazev = dataReader.GetString(++i);
if (!dataReader.IsDBNull(++i))
{
--i;
tym.Rokvzniku = dataReader.GetString(++i);
}
else
{
tym.Rokvzniku = "0000";
}
list.Add(tym);
}
return(list);
}
/// <summary>
/// Insert the record.
/// </summary>
public static int Insert(tym tym, 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, tym);
int ret = db.ExecuteNonQuery(command);
if (pDb == null)
{
db.Close();
}
return(ret);
}
public static XElement Insert(tym tym)
{
return(new XElement("tym",
new XAttribute("Idtym", tym.Idtym.ToString()),
new XAttribute("Nazev", tym.Nazev),
new XAttribute("Rokvzniku", tym.Rokvzniku)));
}
private static void PrepareCommand(SqlCommand command, tym tym)
{
command.Parameters.AddWithValue("@idtym", tym.Idtym);
command.Parameters.AddWithValue("@nazev", tym.Nazev);
command.Parameters.AddWithValue("@rokvzniku", tym.Rokvzniku);
}
