// Returns the current city from database
/// <summary>
/// Returns the current city from database.
/// </summary>
/// <returns></returns>
private string ReturnCity()
{
DataBaseLocalizationDbContext db = new DataBaseLocalizationDbContext();
var r = from d in db.DataBaseLocalizations1
where d.Id == 1
select d;
DataBaseLocalization1 obj = r.SingleOrDefault();
return(obj.Localization.ToString());
}
// Get data from database
/// <summary>
/// Get data from database
/// </summary>
/// <returns> return localization </returns>
public string GetLocalization()
{
var r = from d in this.DataBaseLocalizations1
select d;
DataBaseLocalization1 obj = r.SingleOrDefault();
if (obj != null)
{
return(obj.Localization.ToString());
}
return("Empty database");
}
// The method that save simple localization
/// <summary>
/// The method that save simple localization
/// </summary>
/// <param name="localization"> the object we are adding to database </param>
public void SaveLocalization(string localization)
{
var r = from d in this.DataBaseLocalizations1
where d.Id == 1
select d;
DataBaseLocalization1 obj = r.SingleOrDefault();
if (obj != null)
{
obj.Localization = localization;
}
this.SaveChanges();
}
// Loads the current city from database
/// <summary>
/// Loads the current city from database
/// </summary>
private void CityInitialization()
{
DataBaseLocalizationDbContext db = new DataBaseLocalizationDbContext();
var r = from d in db.DataBaseLocalizations1
select d;
DataBaseLocalization1 obj = r.SingleOrDefault();
if (obj == null)
{
DataBaseLocalization1 doctroObject = new DataBaseLocalization1()
{
Localization = "Wrocław",
};
db.DataBaseLocalizations1.Add(doctroObject);
db.SaveChanges();
}
}