public List <clsgamprp> Gam(Int32 cod)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("disgam", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@cod", SqlDbType.Int).Value = cod;
SqlDataReader dr = cmd.ExecuteReader();
List <clsgamprp> obj = new List <clsgamprp>();
while (dr.Read())
{
clsgamprp k = new clsgamprp();
k.gamcod = Convert.ToInt32(dr[0]);
k.gamhed = dr[1].ToString();
k.gamdis = dr[2].ToString();
k.gamdis1 = dr[3].ToString();
k.gamdis2 = dr[4].ToString();
k.gamimg = dr[5].ToString();
k.gamcat = dr[6].ToString();
k.gamdate = Convert.ToDateTime(dr[7]);
k.gamautcod = Convert.ToInt32(dr[8]);
obj.Add(k);
}
dr.Close();
cmd.Dispose();
con.Close();
return(obj);
}
public void Sub_Gam(clsgamprp p)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("insgame", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@cod", SqlDbType.Int).Value = p.gamcod;
cmd.Parameters.Add("@hed", SqlDbType.VarChar).Value = p.gamhed;
cmd.Parameters.Add("@dis", SqlDbType.NVarChar).Value = p.gamdis;
cmd.Parameters.Add("@dis1", SqlDbType.VarChar).Value = p.gamdis1;
cmd.Parameters.Add("@dis2", SqlDbType.VarChar).Value = p.gamdis2;
cmd.Parameters.Add("@img", SqlDbType.VarChar).Value = p.gamimg;
cmd.Parameters.Add("@simg", SqlDbType.VarChar).Value = p.gamsimg;
cmd.Parameters.Add("@cat", SqlDbType.VarChar).Value = p.gamcat;
cmd.Parameters.Add("@date", SqlDbType.DateTime).Value = p.gamdate;
cmd.Parameters.Add("@aut", SqlDbType.Int).Value = p.gamautcod;
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
}
