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)
{
}
