/// <summary>
/// Insert the record.
/// </summary>
public static int Insert(zamestnanec zamestnanec, 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, zamestnanec);
int ret = db.ExecuteNonQuery(command);
if (pDb == null)
{
db.Close();
}
return(ret);
}
private static void PrepareCommand(SqlCommand command, zamestnanec zamestnanec)
{
command.Parameters.AddWithValue("@idzamestnanec", zamestnanec.Idzamestnanec);
command.Parameters.AddWithValue("@jmeno", zamestnanec.Jmeno);
command.Parameters.AddWithValue("@prijmeni", zamestnanec.Prijmeni);
command.Parameters.AddWithValue("@datnar", zamestnanec.Datnar);
command.Parameters.AddWithValue("@prace", zamestnanec.Prace);
command.Parameters.AddWithValue("@tym", zamestnanec.Tym_idtym);
}
public static XElement Insert(zamestnanec zamestnanec)
{
return(new XElement("zamestnanec",
new XAttribute("Idzamestnanec", zamestnanec.Idzamestnanec.ToString()),
new XAttribute("Jmeno", zamestnanec.Jmeno),
new XAttribute("Prijmeni", zamestnanec.Prijmeni),
new XAttribute("Datnar", zamestnanec.Datnar.ToString()),
new XAttribute("Prace", zamestnanec.Prace),
new XAttribute("Tym_idtym", zamestnanec.Tym_idtym.ToString())));
}
private static List <zamestnanec> Read(SqlDataReader dataReader)
{
List <zamestnanec> list = new List <zamestnanec>();
while (dataReader.Read())
{
int i = -1;
zamestnanec zamestnanec = new zamestnanec();
zamestnanec.Idzamestnanec = dataReader.GetInt32(++i);
zamestnanec.Jmeno = dataReader.GetString(++i);
zamestnanec.Prijmeni = dataReader.GetString(++i);
zamestnanec.Datnar = dataReader.GetDateTime(++i);
zamestnanec.Prace = dataReader.GetString(++i);
zamestnanec.Tym_idtym = dataReader.GetInt32(++i);
list.Add(zamestnanec);
}
return(list);
}
