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