public List <prpplayers> Find_rec(Int32 id)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("findplayers", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@id", SqlDbType.Int).Value = id;
SqlDataReader dr = cmd.ExecuteReader();
List <prpplayers> obj = new List <prpplayers>();
if (dr.HasRows)
{
dr.Read();
prpplayers k = new prpplayers();
k.id = Convert.ToInt32(dr[0]);
k.name = dr[1].ToString();
k.category = dr[2].ToString();
k.value = Convert.ToSingle(dr[3]);
// k.points = Convert.ToInt32(dr[4]);
k.team = dr[4].ToString();
obj.Add(k);
}
dr.Close();
cmd.Dispose();
con.Close();
return(obj);
}
public List <prpplayers> Disp_Rec()
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("displayers", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = cmd.ExecuteReader();
List <prpplayers> obj1 = new List <prpplayers>();
while (dr.Read())
{
prpplayers k = new prpplayers();
k.id = Convert.ToInt32(dr[0]);
k.name = dr[1].ToString();
k.category = dr[2].ToString();
k.value = Convert.ToSingle(dr[3]);
k.team = dr[4].ToString();
obj1.Add(k);
}
dr.Close();
cmd.Dispose();
con.Close();
return(obj1);
}
public void Del_rec(prpplayers p)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("delplayers", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@id", SqlDbType.Int).Value = p.id;
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
}
public void Save_Rec(prpplayers p)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("insplayers", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@name", SqlDbType.VarChar, 50).Value = p.name;
cmd.Parameters.Add("@category", SqlDbType.VarChar, 50).Value = p.category;
cmd.Parameters.Add("@value", SqlDbType.Float).Value = p.value;
cmd.Parameters.Add("@team", SqlDbType.VarChar, 50).Value = p.team;
cmd.ExecuteNonQuery();
con.Close();
cmd.Dispose();
}