public List <UserRequestCriteria> GetAllRequests(int user_id, int pageSize, int pageNumber)
{
//OfferQuery offerQuery = new OfferQuery(language);
OrderQuery orderQuery = new OrderQuery(language);
System.Data.DataTable Supplier = conn_db.ReadTable(orderQuery.GetSupplierByUserId(user_id));
int city_id = 0;
int supplier_type = 0;
int supplier_id = 0;
double supplier_lat = 0;
double supplier_lng = 0;
if (Supplier.Rows.Count > 0)
{
supplier_id = Supplier.Rows[0]["ID"] is DBNull ? 0 : Convert.ToInt32(Supplier.Rows[0]["ID"]);
city_id = Supplier.Rows[0]["city_id"] is DBNull ? 0 : Convert.ToInt32(Supplier.Rows[0]["city_id"]);
supplier_type = Supplier.Rows[0]["SUPPLIER_TYPE_ID"] is DBNull ? 0 : Convert.ToInt32(Supplier.Rows[0]["SUPPLIER_TYPE_ID"]);
supplier_lat = Supplier.Rows[0]["LOCATIONX"] is DBNull ? 0 : Convert.ToDouble(Supplier.Rows[0]["LOCATIONX"].ToString());
supplier_lng = Supplier.Rows[0]["LOCATIONY"] is DBNull ? 0 : Convert.ToDouble(Supplier.Rows[0]["LOCATIONY"].ToString());
}
System.Data.DataTable dataTable = conn_db.ReadTable(orderQuery.GetAllRequests(city_id, supplier_type, supplier_id, pageSize, pageNumber, language));
if (dataTable.Rows.Count == 0)
{
throw new EmptyViewException(language);
}
UserRequestCriteria userRequestCriteria = new UserRequestCriteria();
List <UserRequestCriteria> ListRequestCriterias = new List <UserRequestCriteria>();
foreach (System.Data.DataRow row in dataTable.Rows)
{
userRequestCriteria = new UserRequestCriteria();
userRequestCriteria.ORDER_ID = row["ORDER_ID"] is DBNull ? 0 : Convert.ToInt32(row["ORDER_ID"]);
userRequestCriteria.USER_ID = row["USER_ID"] is DBNull ? 0 : Convert.ToInt32(row["USER_ID"].ToString());
try
{
userRequestCriteria.ORDERDATE = Convert.ToDateTime(row["ORDERDATE"].ToString()).ToString("dd-MM-yyyy");
}
catch (Exception ex)
{
userRequestCriteria.ORDERDATE = "";
}
userRequestCriteria.PLATENUMBER = row["PLATENUMBER"].ToString();
userRequestCriteria.ORDER_IDENTITY = row["ORDER_IDENTITY"].ToString();
userRequestCriteria.firstName = row["FIRSTNAME"].ToString();
userRequestCriteria.lastName = row["LASTNAME"].ToString();
userRequestCriteria.phoneNumber = row["PHONENUMBER"].ToString();
userRequestCriteria.ORDERTYPE_ID = row["ORDERTYPE_ID"] is DBNull ? 0 : Convert.ToInt32(row["ORDERTYPE_ID"]);
userRequestCriteria.ORDERTYPE_NAME = row["ORDERTYPE_NAME"].ToString();
userRequestCriteria.VEHICLE_ID = row["VEHICLE_ID"] is DBNull ? 0 : Convert.ToInt32(row["VEHICLE_ID"]);
userRequestCriteria.ORDER_STATUS = row["ORDER_STATUS"] is DBNull ? 0 : Convert.ToInt32(row["ORDER_STATUS"]);
userRequestCriteria.ISACTIVE = row["ISACTIVE"] is DBNull ? 1 : Convert.ToInt32(row["ISACTIVE"].ToString());
userRequestCriteria.OFFERS_COUNT = row["OFFERS_COUNT"] is DBNull ? 0 : Convert.ToInt32(row["OFFERS_COUNT"].ToString());
if (language == Messages.language.ar.ToString())
{
userRequestCriteria.BRANDNAME = row["BRANDNAME_AR"].ToString();
userRequestCriteria.MODELNAME = row["MODELNAME_AR"].ToString();
}
else
{
userRequestCriteria.BRANDNAME = row["BRANDNAME_EN"].ToString();
userRequestCriteria.MODELNAME = row["MODELNAME_EN"].ToString();
}
userRequestCriteria.carIMAGE = row["carImage"].ToString();
userRequestCriteria.userIMAGE = row["userImage"].ToString();
userRequestCriteria.Note = row["NOTE"].ToString();
userRequestCriteria.COLORNAME = row["COLOR_NAME"].ToString();
userRequestCriteria.lat = row["lat"] is DBNull ? 0 : Convert.ToDouble(row["lat"].ToString());
userRequestCriteria.lng = row["lng"] is DBNull ? 0 : Convert.ToDouble(row["lng"].ToString());
if (supplier_lat == 0 || supplier_lng == 0 || userRequestCriteria.lat == 0 || userRequestCriteria.lng == 0)
{
userRequestCriteria.time = "0";
userRequestCriteria.distance = 0;
}
else
{
double distanceMiles = Math.Sqrt(
Math.Pow((supplier_lat - userRequestCriteria.lat) * 69, 2) +
Math.Pow((supplier_lng - userRequestCriteria.lng) * 69.172, 2));
userRequestCriteria.distance = Math.Round(distanceMiles * 1.60934, 2);
userRequestCriteria.time = new ServicesRepository(language).getTime(supplier_lat + "," + supplier_lng, userRequestCriteria.lat + "," + userRequestCriteria.lng);
}
ListRequestCriterias.Add(userRequestCriteria);
}
return(ListRequestCriterias);
}
