public bool danhgia_xoa(DOT_danhgia da) { using (SqlConnection conn = getConnect()) { SqlCommand cmd = new SqlCommand("sp_delete_danhgia", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@madg", da.madg)); cmd.ExecuteNonQuery(); } return(true); }
public int danhgia_them(DOT_danhgia dg) { using (SqlConnection conn = getConnect()) { SqlCommand cmd = new SqlCommand("sp_insert_danhgia", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@manhiemv", dg.manhiemv)); cmd.Parameters.Add(new SqlParameter("@manv", dg.manv)); cmd.Parameters.Add(new SqlParameter("@tiendo", dg.tiendo)); return(Convert.ToInt32(cmd.ExecuteScalar())); } }
public bool danhgia_sua(DOT_danhgia dg) { using (SqlConnection conn = getConnect()) { SqlCommand cmd = new SqlCommand("sp_update_danhgia", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@madg", dg.madg)); cmd.Parameters.Add(new SqlParameter("@manhiemv", dg.manhiemv)); cmd.Parameters.Add(new SqlParameter("@manv", dg.manv)); cmd.Parameters.Add(new SqlParameter("@tiendo", dg.tiendo)); cmd.ExecuteNonQuery(); } return(true); }