public List <UserRequestCriteria> GetRequestsByUser_id(int user_id)
{
//OfferQuery offerQuery = new OfferQuery(language);
OrderQuery orderQuery = new OrderQuery(language);
OfferQuery offerQuery = new OfferQuery(language);
System.Data.DataTable dataTable = conn_db.ReadTable(orderQuery.GetRequestsByUser_id(user_id, 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());
userRequestCriteria.offer_id = -1;
if (userRequestCriteria.ORDER_STATUS == (int)orderStatus.FINISHED)
{
System.Data.DataTable offerTable = conn_db.ReadTable(new OfferQuery(language).GetOfferDetailsByOrderId(userRequestCriteria.ORDER_ID));
if (offerTable.Rows.Count > 0)
{
userRequestCriteria.offer_id = Int32.Parse(offerTable.Rows[0]["OFFER_ID"].ToString());
}
else
{
userRequestCriteria.offer_id = -1;
}
}
ListRequestCriterias.Add(userRequestCriteria);
}
return(ListRequestCriterias);
}
