//מחזיר רשימת חניונים לפי קרטריון בחירה public static List <Parking_Entity> getParkings_Search(int user_id, decimal latA, decimal longA) { List <Parking_Entity> searchParking_list = new List <Parking_Entity>(); //לולאה על כל החניונים חישוב לפי נקודות שלהם foreach (var parking in db.Parkings) { if (parking.p_Lat == latA && parking.p_Long == longA) { searchParking_list.Add(Convert_Parking.convertToEntity(parking)); } } return(searchParking_list); //double xDiff = x2 - x1; //double yDiff = y2 - y1; //return Math.Atan2(yDiff, xDiff) * 180.0 / Math.PI; //double distance = locA.GetDistanceTo(locB); //List<Parking_Entity> searchParking_list = new List<Parking_Entity>(); //var range = db.Setting_user.Find(user_id).s_range; //searchParking_list.Add(Convert_Parking.convertToEntity(item)); //if (db.Setting_user.Find(user_id).s_choose_criterion == 1) // searchParking_list = searchParking_list.OrderBy(s => s.p_PricesHour).ToList(); //else if (db.Setting_user.Find(user_id).s_choose_criterion == 2) // searchParking_list = searchParking_list.OrderBy(s => s.p_Lat).ThenBy(p => p.p_Long).ToList(); //else if (db.Setting_user.Find(user_id).s_choose_criterion == 3) // searchParking_list = searchParking_list.OrderBy(s => s.p_EmptyParkings).ToList(); //return searchParking_list; }
//החזרת רשימת כל החניונים public static List <Parking_Entity> GetAllParkings() { List <Parking_Entity> Parkings = new List <Parking_Entity>(); foreach (var item in db.Parkings.ToList()) { Parkings.Add(Convert_Parking.convertToEntity(item)); } return(Parkings); }
//החזרת רשימת חניונים של מנהל public static List <Parking_Entity> GetAllParkings(int owner_id) { List <Parking_Entity> owners_parkings = new List <Parking_Entity>(); foreach (var item in db.Parkings_of_owner.ToList()) { if (item.op_owner_id == owner_id) { foreach (var parking in db.Parkings.ToList()) { if (parking.p_Id == item.op_parking_id) { owners_parkings.Add(Convert_Parking.convertToEntity(parking)); } } } } return(owners_parkings); }
//הוספת חניון public static void AddParking(Parking_Entity parking) { db.Parkings.Add(Convert_Parking.convertToDal(parking)); db.SaveChanges(); }