//מחזיר רשימת חניונים לפי קרטריון בחירה
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();
}
