public string Apartment(int id) { SqlConnection conn = new SqlConnection( "Data Source=(local);Initial Catalog=Project;Integrated Security=SSPI"); SqlDataReader rdr = null; try { conn.Open(); SqlCommand cmd = new SqlCommand("select * from Buyers", conn); rdr = cmd.ExecuteReader(); rdr.Read(); Appartment temp = new Appartment("temp", "temp", 2); temp.Correct(); return(temp.GetAp(Convert.ToInt32(rdr[2]), 0, "none", 0)); } finally { if (rdr != null) { rdr.Close(); } if (conn != null) { conn.Close(); } } }
public string GetAp(int H, int L, string Ad, int Nr) { SqlConnection conn = new SqlConnection( "Data Source=(local);Initial Catalog=Project;Integrated Security=SSPI"); SqlDataReader rdr = null; string output = ""; List <Appartment> Ap = new List <Appartment>(); try { conn.Open(); SqlCommand cmd = new SqlCommand("select * from Apartments", conn); rdr = cmd.ExecuteReader(); while (rdr.Read()) { Appartment P = new Appartment(Convert.ToString(rdr[1]), Convert.ToString(rdr[2]), Convert.ToInt32(rdr[3])); P.Id = Convert.ToInt32(rdr[0]); if (P.Price < H && P.Price > L) { Ap.Add(P); } Correct(); } List <Appartment> SortedList = Ap.OrderBy(o => o.Price).ToList(); Ap.Clear(); foreach (Appartment P in SortedList) { if (Ad != "none" && P.Address == Ad) { Ap.Add(P); } if (Nr != 0 && P.NbOfRooms == Nr) { Ap.Add(P); } if (Nr == 0 && Ad == "none") { Ap.Add(P); } } foreach (Appartment P in Ap) { output += "||" + P.Id + " " + P.Title + " " + P.Address + " " + P.NbOfRooms + " " + P.Price + "||"; } Correct(); return(output); } finally { if (rdr != null) { rdr.Close(); } if (conn != null) { conn.Close(); } } }