override public void showDetailsPanel(Flat flat, Views.UserControls.Income view) { string SelectFlatDetails = "SELECT * FROM " + TABLE_NAME + " WHERE flatNumber = " + flat.getFlatNumber() + " AND apartmentID = '" + flat.getApartment().getID() + "'"; connection.Open(); using (SqlCommand command = new SqlCommand(SelectFlatDetails, connection)) { using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { try { view.showDetails(reader["residentName"].ToString(), Convert.ToInt32(reader["flatNumber"]), Convert.ToInt32(reader["monthlyFee"]), Convert.ToInt32(reader["dues"]), Convert.ToBoolean(reader["isManager"]), reader["email"].ToString(), reader["mobileNumber"].ToString()); } catch (System.InvalidCastException es) { view.showDetails("-", Convert.ToInt32(reader["flatNumber"]), 0, 0, false, "-", "-"); } } } } connection.Close(); }
virtual public void showDetailsPanel(Flat flat, Views.UserControls.Income view) { }