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); }