public List <Search_Filter_DATA> Filter( int Building_Max_Area, int Building_Min_Area, int Room_Max_Number, int Room_Min_Number, int Total_Max_Cost, int Total_Min_Cost, string location, int Purpose) { List <Search_Filter_DATA> Filter_DATA_list = new List <Search_Filter_DATA>(); SqlConnection con = new SqlConnection(" Data Source=MOHAMED-PC;Initial Catalog=Real_Estate_Management;Integrated Security=True"); SqlCommand cmd = new SqlCommand("Search2", con); cmd.CommandType = CommandType.StoredProcedure; SqlDataReader rdr; con.Open(); cmd.ExecuteNonQuery(); rdr = cmd.ExecuteReader(); while (rdr.Read()) { Search_Filter_DATA Search_Filter = new Search_Filter_DATA(); Search_Filter.Area = (Double)rdr["Area"]; Search_Filter.Image_1 = rdr["Image_1"].ToString(); Search_Filter.All_Cost = (Double)rdr["All_Cost"]; Search_Filter.Country = rdr["Country"].ToString(); Search_Filter.Governorate = rdr["Governorate"].ToString(); Search_Filter.City = rdr["City"].ToString(); Search_Filter.Room_number = (int)rdr["Room_number"]; Filter_DATA_list.Add(Search_Filter); } con.Close(); Filter_DATA_list = Filter_DATA_list.Where (x => ((((x.All_Cost < Total_Max_Cost) & (x.All_Cost > Total_Min_Cost)) || ((x.All_Cost < Total_Max_Cost) & (Total_Min_Cost == 0)) || ((x.All_Cost > Total_Min_Cost) & (Total_Max_Cost == 0))) && (((x.Area < Building_Max_Area) & (x.Area > Building_Min_Area)) || ((x.Area < Building_Max_Area) & (Building_Min_Area == 0)) || ((x.Area > Building_Min_Area) & (Building_Max_Area == 0))) && (((x.Room_number < Room_Max_Number) | (x.Room_number > Room_Min_Number)) || ((x.Area < Room_Max_Number) & (Room_Min_Number == 0)) || ((x.Area > Building_Min_Area) & (Room_Max_Number == 0))) && (location == " " || x.City.Contains(location) || x.Country.Contains(location) || x.Governorate.Contains(location) ) )).ToList(); return(Filter_DATA_list); }
public List <Search_Filter_DATA> Filter( int Building_Max_Area, int Building_Min_Area, int Room_Max_Number, int Room_Min_Number, int Total_Max_Cost, int Total_Min_Cost, string location, int Purpose) { List <Search_Filter_DATA> Filter_DATA_list = new List <Search_Filter_DATA>(); SqlConnection con = new SqlConnection(" Data Source=MOHAMED-PC;Initial Catalog=Real_Estate_Management;Integrated Security=True"); SqlCommand cmd = new SqlCommand("Search", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("Building_Max_Area", Building_Max_Area);//Building_Max_Area); cmd.Parameters.AddWithValue("Building_Min_Area", Building_Min_Area); cmd.Parameters.AddWithValue("Room_Max_Number", Room_Max_Number); cmd.Parameters.AddWithValue("Room_Min_Number", Room_Min_Number); cmd.Parameters.AddWithValue("Total_Max_Cost", Total_Max_Cost); cmd.Parameters.AddWithValue("Total_Min_Cost", Total_Min_Cost); cmd.Parameters.AddWithValue("Purpose", Purpose); cmd.Parameters.AddWithValue("location", location); SqlDataReader rdr; con.Open(); cmd.ExecuteNonQuery(); rdr = cmd.ExecuteReader(); while (rdr.Read()) { Search_Filter_DATA Search_Filter = new Search_Filter_DATA(); Search_Filter.Area = (Double)rdr["Area"]; Search_Filter.Image_1 = rdr["Image_1"].ToString(); Search_Filter.All_Cost = (Double)rdr["All_Cost"]; Search_Filter.Country = rdr["Country"].ToString(); Search_Filter.Governorate = rdr["Governorate"].ToString(); Search_Filter.City = rdr["City"].ToString(); Search_Filter.Room_number = (int)rdr["Room_number"]; Search_Filter.ID = (int)rdr["ID"]; Filter_DATA_list.Add(Search_Filter); } con.Close(); return(Filter_DATA_list); }