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