public static int update(clsPartTypes x) { using (SqlConnection conn = new SqlConnection(clsMain.sqlconnstring)) { conn.Open(); SqlCommand cmd = new SqlCommand("shop.spUpdatePartTypes", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@id", x.ID); cmd.Parameters.AddWithValue("@tag", x.Tag); int r = cmd.ExecuteNonQuery(); return(r); } }
public static List <clsPartTypes> GetAllPartTypes() { List <clsPartTypes> x = new List <clsPartTypes>(); using (SqlConnection conn = new SqlConnection(clsMain.sqlconnstring)) { conn.Open(); SqlCommand cmd = new SqlCommand("shop.spSelectAllPartTypes", conn); cmd.CommandType = CommandType.StoredProcedure; SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { clsPartTypes y = new clsPartTypes(); y.ID = Convert.ToInt32(rdr["ID"]); y.Tag = Convert.ToString(rdr["Tag"]); x.Add(y); } } return(x); }