public DataTable getRequestById(int _id)
{
string query = "select * from YEUCAUSUACHUA where MaYeuCau = @_id";
SqlParameter[] sqlParameters = new SqlParameter[1];
sqlParameters[0] = new SqlParameter("@_id", SqlDbType.VarChar);
sqlParameters[0].Value = Convert.ToString(_id);
return(conn.executeSelectQuery(query, sqlParameters));
}
public DataTable getDeviceById(int _id)
{
string query = "select * from THIETBISUACHUA where MaThietBi = @_id";
SqlParameter[] sqlParameters = new SqlParameter[1];
sqlParameters[0] = new SqlParameter("@_id", SqlDbType.VarChar);
sqlParameters[0].Value = Convert.ToString(_id);
return(conn.executeSelectQuery(query, sqlParameters));
}
public DataTable getFullInfoByRequestId(int _id)
{
string query = "select y.MaYeuCau, TenThietBi, NgayNhan, TenNhanHieu, Model, HoTen, SoDienThoai, DiaChi, DaSuaChua, SoLuong, MoTaTinhTrang, ChiTiet, TienCong, MoTaLoi from YEUCAUSUACHUA y inner join KHACHHANG k on y.MaKH = k.MaKhachHang join THIETBISUACHUA t on y.MaMonHang = t.MaThietBi join NHANHIEU n on t.MaNhanHieu = n.MaNhanHieu left join SUACHUA s on s.MaYeuCau = y.MaYeuCau where s.MaYeuCau = @_id";
SqlParameter[] sqlParameters = new SqlParameter[1];
sqlParameters[0] = new SqlParameter("@_id", SqlDbType.VarChar);
sqlParameters[0].Value = Convert.ToString(_id);
return(conn.executeSelectQuery(query, sqlParameters));
}
public DataTable getBrandById(int _id)
{
string query = "select * from NhanHieu where MaNhanHieu = @_id";
SqlParameter[] sqlParameters = new SqlParameter[1];
sqlParameters[0] = new SqlParameter("@_id", SqlDbType.VarChar);
sqlParameters[0].Value = Convert.ToString(_id);
return(conn.executeSelectQuery(query, sqlParameters));
}
public DataTable getCustomerById(int _id)
{
string query = "select * from KhachHang where MaKhachHang = @_id";
SqlParameter[] sqlParameters = new SqlParameter[1];
sqlParameters[0] = new SqlParameter("@_id", SqlDbType.VarChar);
sqlParameters[0].Value = Convert.ToString(_id);
return(conn.executeSelectQuery(query, sqlParameters));
}
public DataTable getRequestSpecificDayStatistic(DateTime date)
{
string query = "select count(*) from YEUCAUSUACHUA where NgayNhan = @_date";
SqlParameter[] sqlParameters = new SqlParameter[1];
sqlParameters[0] = new SqlParameter("@_date", SqlDbType.VarChar);
sqlParameters[0].Value = Convert.ToString(date.ToString("MM-dd-yyyy"));
return(conn.executeSelectQuery(query, sqlParameters));
}
