public static int insert(clsPractice x)
{
using (SqlConnection conn = new SqlConnection(clsMain.sqlconnstring))
{
conn.Open();
SqlCommand cmd = new SqlCommand("shop.pInsert", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@n", x.FullName);
cmd.Parameters.AddWithValue("@f", x.Flag);
cmd.Parameters.AddWithValue("@fn", x.FlagName);
int r = cmd.ExecuteNonQuery();
return(r);
}
}
public static List <clsPractice> GetAll()
{
List <clsPractice> x = new List <clsPractice>();
using (SqlConnection conn = new SqlConnection(clsMain.sqlconnstring))
{
conn.Open();
SqlCommand cmd = new SqlCommand("shop.pSelectAll", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
clsPractice y = new clsPractice();
y.ID = Convert.ToInt32(rdr["ID"]);
y.FullName = Convert.ToString(rdr["FullName"]);
y.Flag = (byte[])(rdr["Flag"]);
y.FlagName = Convert.ToString(rdr["FlagName"]);
x.Add(y);
}
}
return(x);
}
