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