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