public void LoadListingInfo(int listID) { try { currentListID = listID; new System.Threading.Thread(() => { LoadComboBoxes(); SetLoadingState(true); DatabaseManager dbManager = new DatabaseManager(); AgentManager agManager = new AgentManager(); var listingInfo = dbManager.ReturnQuery("SELECT * FROM Listing WHERE List_ID = " + currentListID + " ORDER BY List_ID;"); foreach (var list in listingInfo) { DatabaseManager dbManager2 = new DatabaseManager(); var propertyInfo = dbManager2.ReturnQuery("SELECT * FROM Property WHERE Property_ID = " + Convert.ToInt32(list[1]) + " ORDER BY Property_ID;"); foreach (var property in propertyInfo) { DatabaseManager dbManager3 = new DatabaseManager(); var adressInfo = dbManager3.ReturnQuery("SELECT * FROM Address WHERE Address_ID = " + Convert.ToInt32(property[4]) + " ORDER BY Address_ID;"); foreach (var address in adressInfo) { DatabaseManager dbManager4 = new DatabaseManager(); if(Convert.ToInt32(property[2]) !=-1 && Convert.ToInt32(property[2]) !=0) { var complexInfo = dbManager4.ReturnQuery("SELECT * FROM Complex WHERE Address_ID = " + Convert.ToInt32(address[0]) + " ORDER BY Complex_ID;"); foreach (var complex in complexInfo) { DatabaseManager dbManager5 = new DatabaseManager(); var clientInfo = dbManager5.ReturnQuery("SELECT * FROM Clients WHERE Client_ID = " + Convert.ToInt32(property[1]) + " ORDER BY Client_ID;"); foreach (var client in clientInfo) { InsertIntoListingsView(client[1] + ", " + client[4], Convert.ToInt32(address[3]), address[1], address[2], Convert.ToInt32(property[2]), complex[1], property[3], property[5], property[6], property[7], property[9], property[10], property[11], (list[2]), Convert.ToInt32(list[4]), Convert.ToInt32(list[5]), Convert.ToInt32(property[8]), list[6]); LoadPropertyImages(Convert.ToInt32(list[1])); } } } else { DatabaseManager dbManager5 = new DatabaseManager(); var clientInfo = dbManager5.ReturnQuery("SELECT * FROM Clients WHERE Client_ID = " + Convert.ToInt32(property[1]) + " ORDER BY Client_ID;"); foreach (var client in clientInfo) { InsertIntoListingsView(client[1] + ", " + client[4], Convert.ToInt32(address[3]), address[1], address[2], Convert.ToInt32(property[2]), "" , property[3], property[5], property[6], property[7], property[9], property[10], property[11], (list[2]), Convert.ToInt32(list[4]), Convert.ToInt32(list[5]), Convert.ToInt32(property[8]), list[6]); LoadPropertyImages(Convert.ToInt32(list[1])); } } } } } SetLoadingState(false); }).Start(); } catch { } }
private void RefreshListings() { new System.Threading.Thread(() => { SetLoadingState(true); ClearListingsGrid(); DatabaseManager dbManager = new DatabaseManager(); AgentManager agManager = new AgentManager(); var listingInfo = dbManager.ReturnQuery("SELECT * FROM Listing WHERE Agent_ID = " + agManager.GetAgentID(GetCurrentAgent()) + " ORDER BY List_ID;"); foreach (var list in listingInfo) { DatabaseManager dbManager2 = new DatabaseManager(); var propertyInfo = dbManager2.ReturnQuery("SELECT Client_ID, Property_Unit_No, Address_ID, Complex_ID, Property_ID FROM Property WHERE Property_ID = " + Convert.ToInt32(list[1]) + " ORDER BY Property_ID;"); foreach (var property in propertyInfo) { DatabaseManager dbManager3 = new DatabaseManager(); var adressInfo = dbManager3.ReturnQuery("SELECT Address_ID, Address_Streetname, Address_Streetno FROM Address WHERE Address_ID = " + Convert.ToInt32(property[2]) + " ORDER BY Address_ID;"); foreach (var address in adressInfo) { DatabaseManager dbManager4 = new DatabaseManager(); if (Convert.ToInt32(property[3]) != 0 && Convert.ToInt32(property[3]) != -1) { var complexInfo = dbManager4.ReturnQuery("SELECT Complex_Name, Complex_ID FROM Complex WHERE Address_ID = " + Convert.ToInt32(address[0]) + " ORDER BY Complex_ID;"); foreach (var complex in complexInfo) { DatabaseManager dbManager5 = new DatabaseManager(); var clientInfo = dbManager5.ReturnQuery("SELECT Client_Email FROM Clients WHERE Client_ID = " + Convert.ToInt32(property[0]) + " ORDER BY Client_ID;"); foreach (var client in clientInfo) { string yesNoSold; string yesNoNegotiable; if (Convert.ToInt32(list[4]) == 0) yesNoNegotiable = "No"; else yesNoNegotiable = "Yes"; if (Convert.ToInt32(list[5]) == 0) yesNoSold = "No"; else yesNoSold = "Yes"; InsertIntoListingsGrid(Convert.ToInt32(list[0]), client[0], address[1] + " " + address[2], complex[0] + " " + property[1], list[2], yesNoSold, yesNoNegotiable, list[6]); } } } else { DatabaseManager dbManager5 = new DatabaseManager(); var clientInfo = dbManager5.ReturnQuery("SELECT Client_Email FROM Clients WHERE Client_ID = " + Convert.ToInt32(property[0]) + " ORDER BY Client_ID;"); foreach (var client in clientInfo) { string yesNoSold; string yesNoNegotiable; if (Convert.ToInt32(list[4]) == 0) yesNoNegotiable = "No"; else yesNoNegotiable = "Yes"; if (Convert.ToInt32(list[5]) == 0) yesNoSold = "No"; else yesNoSold = "Yes"; InsertIntoListingsGrid(Convert.ToInt32(list[0]), client[0], address[1] + " " + address[2], "N/A", list[2], yesNoSold, yesNoNegotiable, list[6]); } } } } } SetLoadingState(false); }).Start(); }