private void EditArea(string oldName, string newName, string oldCity, string newCity, string oldProvince, string newProvince) { new System.Threading.Thread(() => { bool edited = false; SetLoadingState(true); Classes.LocationManager locationManager = new Classes.LocationManager(); if (locationManager.CanAddArea(newName, newCity, newProvince)) { if (locationManager.EditArea(oldName, newName, oldCity, newCity, oldProvince, newProvince)) { DisplayNotifyBox("Edited", oldName + "," + oldCity + "," + oldProvince + " changed to " + newName + "," + newCity + "," + newProvince, 3); edited = true; } else { DisplayNotifyBox("Could not edit", "En error occured. Please try again later", 3); } } else { DisplayNotifyBox("Could not edit", "Cannot change " + oldName + "," + oldCity + "," + oldProvince + " to " + newName + "," + newCity + "," + newProvince + " because " + newName + "," + newCity + "," + newProvince + " already exists", 4); } SetLoadingState(false); if (edited) { CloseForm(); } }).Start(); }
private void AddCity() { if (TB_CityName.Text != "") { new System.Threading.Thread(() => { SetLoadingState(true); Classes.LocationManager locationManager = new Classes.LocationManager(); if (locationManager.CanAddCity(GetCityName(), GetProvinceName())) { if (locationManager.AddCity(GetCityName(), GetProvinceName())) { DisplayNotifyBox(GetCityName() + " Added", GetCityName() + " was added in " + GetProvinceName(), 3); ClearForm(); } else { DisplayNotifyBox("Could not Add City", GetCityName() + " could not be added. Please try again", 3); } } else { DisplayNotifyBox("Cannot Add City", GetCityName() + " already exists in " + GetProvinceName(), 3); } SetLoadingState(false); }).Start(); } else { DisplayNotifyBox("ERROR", "City name cannot be empty", 2); } }
private void AddProvince() { new System.Threading.Thread(() => { if (GetProvinceName() != "") { Classes.LocationManager locationManager = new Classes.LocationManager(); if (locationManager.CanAddProvince(GetProvinceName())) { SetLoadingState(true); if (locationManager.AddProvince(GetProvinceName())) { DisplayNotifyBox(GetProvinceName() + " Added", GetProvinceName() + " has been added successfully", 2); ClearForm(); } else { DisplayNotifyBox("Could not Add", GetProvinceName() + " was not added", 2); } SetLoadingState(false); } else { DisplayNotifyBox("Cannot add " + GetProvinceName(), "A province with the same name already exists", 2); } } else { DisplayNotifyBox("ERROR", "Province name cannot be empty", 2); } }).Start(); }
private void AddArea() { new System.Threading.Thread(() => { if (GetAreaName() != "") { Classes.LocationManager locationManager = new Classes.LocationManager(); SetLoadingState(true); if (locationManager.CanAddArea(GetAreaName(), GetCityName(), GetProvinceName())) { if (locationManager.AddArea(GetAreaName(), GetCityName(), GetProvinceName())) { DisplayNotifyBox("Area Added", GetAreaName() + "," + GetCityName() + "," + GetProvinceName() + " was added", 3); ClearForm(); } else { DisplayNotifyBox("Could not add", "Area not added please try again", 3); } } else { DisplayNotifyBox("Cannot Add", GetAreaName() + " already exists in " + GetCityName() + "," + GetProvinceName(), 3); } SetLoadingState(false); } else { DisplayNotifyBox("ERROR", "Area name cannot be empty", 3); } }).Start(); }
private void BT_Edit_Click(object sender, RoutedEventArgs e) { if( TB_NewProvinceName.Text != "") { if( TB_NewProvinceName.Text.ToString() != provinceToEdit ) { new System.Threading.Thread(() => { Classes.LocationManager locationManager = new Classes.LocationManager(); if( locationManager.CanAddProvince(GetNewProvinceName())) { Classes.Validation valid = new Classes.Validation(); if (valid.TextIsShorterThan(GetNewProvinceName(), 32)) { if (locationManager.ChangeProvinceName(provinceToEdit, GetNewProvinceName())) { DisplayNotifyBox(provinceToEdit + " Edited", provinceToEdit + " was changed to " + GetNewProvinceName(), 2); isEdited = true; } else { DisplayNotifyBox("Could not edit " + provinceToEdit, provinceToEdit + " was not changed. Please try again", 3); } if (isEdited == true) { CloseForm(); } } else { DisplayNotifyBox("ERROR", "Province name must be shorter than 32 character", 5); } } else { DisplayNotifyBox("Province Name Already Exists", "Cannot change " + provinceToEdit + " to " + GetNewProvinceName() + " because " + GetNewProvinceName() + " already exists",3); } }).Start(); } else { DisplayNotifyBox("ERROR", "New province name must be different form old province name", 2); } } else { DisplayNotifyBox("ERROR", "New Province Name cannot be empty", 2); } }
private void BT_Edit_Click(object sender, RoutedEventArgs e) { if (TB_NewProvinceName.Text != "") { if (TB_NewProvinceName.Text.ToString() != provinceToEdit) { new System.Threading.Thread(() => { Classes.LocationManager locationManager = new Classes.LocationManager(); if (locationManager.CanAddProvince(GetNewProvinceName())) { Classes.Validation valid = new Classes.Validation(); if (valid.TextIsShorterThan(GetNewProvinceName(), 32)) { if (locationManager.ChangeProvinceName(provinceToEdit, GetNewProvinceName())) { DisplayNotifyBox(provinceToEdit + " Edited", provinceToEdit + " was changed to " + GetNewProvinceName(), 2); isEdited = true; } else { DisplayNotifyBox("Could not edit " + provinceToEdit, provinceToEdit + " was not changed. Please try again", 3); } if (isEdited == true) { CloseForm(); } } else { DisplayNotifyBox("ERROR", "Province name must be shorter than 32 character", 5); } } else { DisplayNotifyBox("Province Name Already Exists", "Cannot change " + provinceToEdit + " to " + GetNewProvinceName() + " because " + GetNewProvinceName() + " already exists", 3); } }).Start(); } else { DisplayNotifyBox("ERROR", "New province name must be different form old province name", 2); } } else { DisplayNotifyBox("ERROR", "New Province Name cannot be empty", 2); } }
private void AddProvince() { new System.Threading.Thread(() => { if( GetProvinceName() != "" ) { Classes.LocationManager locationManager = new Classes.LocationManager(); Classes.Validation valid = new Classes.Validation(); if (valid.TextIsShorterThan(GetProvinceName(), 32)) { if (locationManager.CanAddProvince(GetProvinceName())) { SetLoadingState(true); if (locationManager.AddProvince(GetProvinceName())) { DisplayNotifyBox(GetProvinceName() + " Added", GetProvinceName() + " has been added successfully", 2); ClearForm(); } else { DisplayNotifyBox("Could not Add", GetProvinceName() + " was not added", 2); } SetLoadingState(false); } else { DisplayNotifyBox("Cannot add " + GetProvinceName(), "A province with the same name already exists", 2); } } else { DisplayNotifyBox("ERROR", "Province name must be shorter than 32 character", 5); } } else { DisplayNotifyBox("ERROR", "Province name cannot be empty",2); } }).Start(); }
private void EditCity(string oldCityName, string oldProvince, string newCityName, string newProvinceName) { new System.Threading.Thread(() => { bool edited = false; SetLoadingState(true); Classes.LocationManager locationManager = new Classes.LocationManager(); Classes.Validation valid = new Classes.Validation(); if (valid.TextIsShorterThan(newCityName, 32)) { if (locationManager.CanAddCity(newCityName, newProvinceName)) { if (locationManager.EditCity(oldCityName, oldProvince, newCityName, newProvinceName)) { DisplayNotifyBox("Edited", oldCityName + "," + oldProvince + " changed to " + newCityName + "," + newProvinceName, 3); edited = true; } else { DisplayNotifyBox("Could not edit", "En error occured. Please try again later", 3); } } else { DisplayNotifyBox("Could not edit", "Cannot change " + oldCityName + "," + oldProvince + " to " + newCityName + "," + newProvinceName + " because " + newCityName + "," + newProvinceName + " already exists", 4); } } else { DisplayNotifyBox("ERROR", "City name must be shorter than 32 character", 5); } SetLoadingState(false); if (edited) { CloseForm(); } }).Start(); }
private void LoadPreferencesBox() { SetLoadingState(true); flag = false; CB_Preferences.Items.Clear(); numberOfPreferences = 0; Classes.DatabaseManager dbManager = new Classes.DatabaseManager(); Classes.LocationManager locManager = new Classes.LocationManager(); var preferences = (dbManager.ReturnQuery("SELECT Preference_ID FROM Preference WHERE Preference_Client_ID = " + clientID.ToString() + " ORDER BY Preference_ID;")); foreach (var i in preferences) { numberOfPreferences++; preferenceIDArray[numberOfPreferences - 1] = Convert.ToInt32(i[0]); flag = true; CB_Preferences.Items.Add(numberOfPreferences.ToString()); } if (!flag) { CB_Preferences.Items.Add("1"); CB_Preferences.SelectedIndex = 0; preferenceIDArray[0] = -1; preferenceID = preferenceIDArray[0]; CB_PreferedAreas.Items.Clear(); InsertPreferences(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); BT_DeletePreference.IsEnabled = false; BT_EditExisting.IsEnabled = false; } else { //LoadCurrentPreferences(preferenceIDArray[0]); preferenceID = preferenceIDArray[0]; CB_Preferences.SelectedIndex = 0; BT_DeletePreference.IsEnabled = true; BT_EditExisting.IsEnabled = true; } SetLoadingState(false); }
private void LoadCurrentPreferences(int inPrefferenceID) { preferenceID = inPrefferenceID; CB_PreferedAreas.Items.Clear(); flag = false; this.Dispatcher.Invoke(() => { SetLoadingState(true); ClearPreferences(); Classes.DatabaseManager dbManager = new Classes.DatabaseManager(); Classes.LocationManager locManager = new Classes.LocationManager(); var preferences = (dbManager.ReturnQuery("SELECT Preference_Min_Bedrooms, Preference_Max_Bedrooms, Preference_Min_Bathrooms, Preference_Max_Bathrooms, Preference_Min_Garages, Preference_Max_Garages, Preference_hasPool, Preference_Min_Plot_Size, Preference_Max_Plot_Size, Preference_Min_House_Size, Preference_Max_House_Size, Preference_Min_Price, Preference_Max_Price FROM Preference WHERE Preference_Client_ID = " + clientID.ToString() + " AND Preference_ID = " + preferenceID.ToString() + ";")); foreach (var i in preferences) { InsertPreferences(Convert.ToInt32(i[0]), Convert.ToInt32(i[1]), Convert.ToInt32(i[2]), Convert.ToInt32(i[3]), Convert.ToInt32(i[4]), Convert.ToInt32(i[5]), Convert.ToInt32(i[6]), Convert.ToInt32(i[7]), Convert.ToInt32(i[8]), Convert.ToInt32(i[9]), Convert.ToInt32(i[10]), Convert.ToInt32(i[11]), Convert.ToInt32(i[12])); } var preferedAreas = (dbManager.ReturnQuery("SELECT Area_ID FROM Preference_Area WHERE Preference_ID = " + preferenceID + " ORDER BY Area_ID;")); foreach (var j in preferedAreas) { flag = true; CB_PreferedAreas.Items.Add(locManager.AreaFullName(Convert.ToInt32(j[0]))); } if (flag) { CB_PreferedAreas.SelectedIndex = 0; BT_RemoveArea.IsEnabled = true; } else { BT_RemoveArea.IsEnabled = false; } SetLoadingState(false); }); }
private void AddArea() { new System.Threading.Thread(() => { if( GetAreaName() != "") { Classes.LocationManager locationManager = new Classes.LocationManager(); SetLoadingState(true); if( locationManager.CanAddArea(GetAreaName(),GetCityName(),GetProvinceName()) ) { if (locationManager.AddArea(GetAreaName(), GetCityName(), GetProvinceName())) { DisplayNotifyBox("Area Added", GetAreaName() + "," + GetCityName() + "," + GetProvinceName() + " was added", 3); ClearForm(); } else { DisplayNotifyBox("Could not add", "Area not added please try again", 3); } } else { DisplayNotifyBox("Cannot Add", GetAreaName() + " already exists in " + GetCityName() + "," + GetProvinceName(), 3); } SetLoadingState(false); } else { DisplayNotifyBox("ERROR", "Area name cannot be empty", 3); } }).Start(); }
private int GetProvinceID(string proviceName) { Classes.LocationManager locationManager = new Classes.LocationManager(); return locationManager.ProvinceID(proviceName); }
private void EditCity(string oldCityName, string oldProvince, string newCityName, string newProvinceName) { new System.Threading.Thread(() => { bool edited = false; SetLoadingState(true); Classes.LocationManager locationManager = new Classes.LocationManager(); if( locationManager.CanAddCity(newCityName,newProvinceName)) { if( locationManager.EditCity(oldCityName,oldProvince,newCityName,newProvinceName) ) { DisplayNotifyBox("Edited", oldCityName + "," + oldProvince + " changed to " + newCityName + "," + newProvinceName, 3); edited = true; } else { DisplayNotifyBox("Could not edit", "En error occured. Please try again later", 3); } } else { DisplayNotifyBox("Could not edit","Cannot change " + oldCityName + "," + oldProvince + " to " + newCityName + "," + newProvinceName + " because " + newCityName + "," + newProvinceName + " already exists",4); } SetLoadingState(false); if (edited) CloseForm(); }).Start(); }
private void EditArea(string oldName, string newName, string oldCity , string newCity, string oldProvince, string newProvince) { new System.Threading.Thread(() => { bool edited = false; SetLoadingState(true); Classes.LocationManager locationManager = new Classes.LocationManager(); Classes.Validation valid = new Classes.Validation(); if (valid.TextIsShorterThan(newName, 32)) { if (locationManager.CanAddArea(newName, newCity, newProvince)) { if (locationManager.EditArea(oldName, newName, oldCity, newCity, oldProvince, newProvince)) { DisplayNotifyBox("Edited", oldName + "," + oldCity + "," + oldProvince + " changed to " + newName + "," + newCity + "," + newProvince, 3); edited = true; } else { DisplayNotifyBox("Could not edit", "En error occured. Please try again later", 3); } } else { DisplayNotifyBox("Could not edit", "Cannot change " + oldName + "," + oldCity + "," + oldProvince + " to " + newName + "," + newCity + "," + newProvince + " because " + newName + "," + newCity + "," + newProvince + " already exists", 4); } } else { DisplayNotifyBox("ERROR", "Area name must be shorter than 32 character", 5); } SetLoadingState(false); if (edited) CloseForm(); }).Start(); }
private void LoadPreferencesBox() { flag = false; CB_Preferences.Items.Clear(); numberOfPreferences = 0; Classes.DatabaseManager dbManager = new Classes.DatabaseManager(); Classes.LocationManager locManager = new Classes.LocationManager(); var preferences = (dbManager.ReturnQuery("SELECT Preference_ID FROM Preference WHERE Preference_Client_ID = " + clientID.ToString() + " ORDER BY Preference_ID;")); foreach (var i in preferences) { numberOfPreferences++; preferenceIDArray[numberOfPreferences - 1] = Convert.ToInt32(i[0]); flag = true; CB_Preferences.Items.Add(numberOfPreferences.ToString()); } if (!flag) { CB_Preferences.Items.Add("1"); CB_Preferences.SelectedIndex = 0; preferenceIDArray[0] = -1; preferenceID = preferenceIDArray[0]; CB_PreferedAreas.Items.Clear(); InsertPreferences(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); BT_DeletePreference.IsEnabled = false; BT_EditExisting.IsEnabled = false; } else { //LoadCurrentPreferences(preferenceIDArray[0]); preferenceID = preferenceIDArray[0]; CB_Preferences.SelectedIndex = 0; BT_DeletePreference.IsEnabled = true; BT_EditExisting.IsEnabled = true; } }
private void LoadCurrentPreferences(int inPrefferenceID) { preferenceID = inPrefferenceID; CB_PreferedAreas.Items.Clear(); flag = false; this.Dispatcher.Invoke(() => { SetLoadingState(true); ClearPreferences(); Classes.DatabaseManager dbManager = new Classes.DatabaseManager(); Classes.LocationManager locManager = new Classes.LocationManager(); var preferences = (dbManager.ReturnQuery("SELECT Preference_Min_Bedrooms, Preference_Max_Bedrooms, Preference_Min_Bathrooms, Preference_Max_Bathrooms, Preference_Min_Garages, Preference_Max_Garages, Preference_hasPool, Preference_Min_Plot_Size, Preference_Max_Plot_Size, Preference_Min_House_Size, Preference_Max_House_Size, Preference_Min_Price, Preference_Max_Price FROM Preference WHERE Preference_Client_ID = " + clientID.ToString() + " AND Preference_ID = " + preferenceID.ToString() + ";")); foreach (var i in preferences) { InsertPreferences(Convert.ToInt32(i[0]), Convert.ToInt32(i[1]), Convert.ToInt32(i[2]), Convert.ToInt32(i[3]), Convert.ToInt32(i[4]), Convert.ToInt32(i[5]), Convert.ToInt32(i[6]), Convert.ToInt32(i[7]), Convert.ToInt32(i[8]), Convert.ToInt32(i[9]), Convert.ToInt32(i[10]), Convert.ToInt32(i[11]), Convert.ToInt32(i[12])); } var preferedAreas = (dbManager.ReturnQuery("SELECT Area_ID FROM Preference_Area WHERE Preference_ID = " + preferenceID + " ORDER BY Area_ID;")); foreach (var j in preferedAreas) { flag = true; CB_PreferedAreas.Items.Add(locManager.AreaFullName(Convert.ToInt32(j[0]))); } if(flag) { CB_PreferedAreas.SelectedIndex = 0; BT_RemoveArea.IsEnabled = true; } else { BT_RemoveArea.IsEnabled = false; } SetLoadingState(false); }); }
private int GetProvinceID(string proviceName) { Classes.LocationManager locationManager = new Classes.LocationManager(); return(locationManager.ProvinceID(proviceName)); }
private int GetCityID(string cityName, string provinceName) { Classes.LocationManager locationManager = new Classes.LocationManager(); return locationManager.CityID(cityName, GetProvinceID(provinceName)); }
private int GetCityID(string cityName, string provinceName) { Classes.LocationManager locationManager = new Classes.LocationManager(); return(locationManager.CityID(cityName, GetProvinceID(provinceName))); }