public void Pridat()
{
this.ID = Hrac.getLastID() + 1;
SqlConnectionStringBuilder builder = DBconnector.GetBuilder();
try
{
using (SqlConnection connection = new SqlConnection(builder.ConnectionString))
{
connection.Open();
string sql = "INSERT INTO Hraci VALUES(@p_id, @p_jmeno, @p_prijmeni, @p_datum, @p_zeme, @p_tym_id)";
using (SqlCommand command = new SqlCommand(sql, connection))
{
command.Parameters.AddWithValue("@p_id", this.ID);
command.Parameters.AddWithValue("@p_jmeno", this.jmeno);
command.Parameters.AddWithValue("@p_prijmeni", this.prijmeni);
command.Parameters.AddWithValue("@p_datum", this.datumZalozeni);
command.Parameters.AddWithValue("@p_zeme", this.zeme);
command.Parameters.AddWithValue("@p_tym_id", this.tym.ID);
command.ExecuteNonQuery();
}
}
}
catch (Exception e) {; }
}
public static Hrac Find(int _id)
{
Hrac hrac = new Hrac();
DataTable dt = new Hrac().FindD(_id);
hrac = MapResultsetToObject(dt.Rows[0]);
return(hrac);
}
public static Hrac MapResultsetToObject(DataRow dr)
{
Hrac hrac = new Hrac();
hrac.ID = Convert.ToInt32(dr.ItemArray[0].ToString());
hrac.jmeno = dr.ItemArray[1].ToString();
hrac.prijmeni = dr.ItemArray[2].ToString();
hrac.datumZalozeni = Convert.ToDateTime(dr.ItemArray[3].ToString());
hrac.zeme = dr.ItemArray[4].ToString();
hrac.tym = Tym.MapResultsetToObject(Tym.FindD(Convert.ToInt32(dr.ItemArray[5].ToString())).Rows[0]);
return(hrac);
}
public static List <Hrac> Find()
{
List <Hrac> hracList = new List <Hrac>();
DataTable dt = new Hrac().FindD();
foreach (DataRow dr in dt.Rows)
{
hracList.Add(MapResultsetToObject(dr));
}
return(hracList);
}
