public List <prvdate> Find_rec(Int32 id)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("findvdate", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@id", SqlDbType.Int).Value = id;
SqlDataReader dr = cmd.ExecuteReader();
List <prvdate> obj = new List <prvdate>();
if (dr.HasRows)
{
dr.Read();
prvdate k = new prvdate();
k.id = Convert.ToInt32(dr[0]);
k.venue = dr[1].ToString();
obj.Add(k);
}
dr.Close();
cmd.Dispose();
con.Close();
return(obj);
}
public List <prvdate> Disp_Rec()
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("disvdate", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = cmd.ExecuteReader();
List <prvdate> obj1 = new List <prvdate>();
while (dr.Read())
{
prvdate k = new prvdate();
k.id = Convert.ToInt32(dr[0]);
k.venue = dr[1].ToString();
obj1.Add(k);
}
dr.Close();
cmd.Dispose();
con.Close();
return(obj1);
}
public void Del_rec(prvdate p)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("delvdate", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@id", SqlDbType.Int).Value = p.id;
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
}
public void Save_Rec(prvdate p)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("insvdate", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@venue", SqlDbType.VarChar, 50).Value = p.venue;
cmd.ExecuteNonQuery();
con.Close();
cmd.Dispose();
}
