protected void ButtonDeleteContinent_Click(object sender, EventArgs e)
{
this.LabelContinentErrors.Text = string.Empty;
if (string.IsNullOrWhiteSpace(this.ListBoxContinents.SelectedValue))
{
this.LabelContinentErrors.Text = "No continent selected.";
return;
}
string confirmValue = Request.Form["confirm-value"];
if (confirmValue == "No")
{
return;
}
using (var context = new WorldEntities())
{
int continentId = int.Parse(this.ListBoxContinents.SelectedValue);
var continent = context.Continents.FirstOrDefault(c => c.ContinentId == continentId);
if (continent != null)
{
context.Continents.Remove(continent);
context.SaveChanges();
Response.Redirect(Request.RawUrl);
}
else
{
this.LabelContinentErrors.Text = "No continent found with id=" + continentId;
}
}
}
protected void ButtonUpdateContinent_Click(object sender, EventArgs e)
{
this.LabelContinentErrors.Text = string.Empty;
if (string.IsNullOrWhiteSpace(this.ListBoxContinents.SelectedValue))
{
this.LabelContinentErrors.Text = "No continent selected.";
return;
}
string newContinentName = this.TextBoxContinentName.Text.Trim();
if (string.IsNullOrWhiteSpace(newContinentName))
{
this.LabelContinentErrors.Text = "No continent name specified.";
return;
}
using (var context = new WorldEntities())
{
int continentId = int.Parse(this.ListBoxContinents.SelectedValue);
var continent = context.Continents.FirstOrDefault(c => c.ContinentId == continentId);
if (continent != null)
{
continent.ContinentName = newContinentName;
context.Entry <Continent>(continent).State = EntityState.Modified;
context.SaveChanges();
Response.Redirect(Request.RawUrl);
}
else
{
this.LabelContinentErrors.Text = "No continent found with id=" + continentId;
}
}
}
protected void ButtonAddContinent_Click(object sender, EventArgs e)
{
string newName = this.TextBoxUpdateContinent.Text;
if (string.IsNullOrWhiteSpace(newName))
{
Response.Write("Please enter name to Create continent!");
return;
}
if (newName.Length > 20)
{
Response.Write("Continent name must be less than 20 symbols!");
}
WorldEntities db = new WorldEntities();
Continent newContinent = new Continent()
{
ContinentName = newName
};
db.Continents.Add(newContinent);
db.SaveChanges();
Response.Redirect(Request.RawUrl);
}
protected void ButtonDeleteContinent_Click(object sender, EventArgs e)
{
string newName = Server.HtmlEncode(this.TextBoxUpdateContinent.Text);
if (string.IsNullOrWhiteSpace(newName))
{
Response.Write("Please enter name to delete continent!");
return;
}
var selectedContinentId = this.ListBoxContinents.SelectedItem.Value;
WorldEntities db = new WorldEntities();
var continent = db.Continents.FirstOrDefault(c => c.ContinentId.ToString() == selectedContinentId);
if (continent == null)
{
Response.Write("Selected continent was not found!");
return;
}
db.Entry <Continent>(continent).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
Response.Redirect(Request.RawUrl);
}
protected void ButtonAddContinent_Click(object sender, EventArgs e)
{
this.LabelContinentErrors.Text = string.Empty;
string newContinentName = this.TextBoxNewContinentName.Text.Trim();
if (string.IsNullOrWhiteSpace(newContinentName))
{
this.LabelContinentErrors.Text = "No continent name specified.";
return;
}
using (var context = new WorldEntities())
{
context.Continents.Add(new Continent
{
ContinentName = newContinentName
});
context.SaveChanges();
Response.Redirect(Request.RawUrl);
}
}
protected void ButtonAddCountry_Click(object sender, EventArgs e)
{
WorldEntities context = null;
this.LabelCountryErrors.Text = string.Empty;
try
{
string countryId = this.GetFooterRowTextBoxText(this.GridViewCountries, "TextBoxNewCountryId");
this.ValidateCountryId(countryId);
string countryName = this.GetFooterRowTextBoxText(this.GridViewCountries, "TextBoxNewCountryName");
this.ValidateName(countryName);
float latitude;
string latitudeAsString = this.GetFooterRowTextBoxText(this.GridViewCountries, "TextBoxNewLatitude");
this.ValidateGeoCoordinate(latitudeAsString, out latitude);
float longitude;
string longitudeAsString = this.GetFooterRowTextBoxText(this.GridViewCountries, "TextBoxNewLongitude");
this.ValidateGeoCoordinate(longitudeAsString, out longitude);
float area;
string areaAsString = this.GetFooterRowTextBoxText(this.GridViewCountries, "TextBoxNewSurfaceArea");
this.ValidateArea(areaAsString, out area);
int population;
string populationAsString = this.GetFooterRowTextBoxText(this.GridViewCountries, "TextBoxNewPopulation");
this.ValidatePopulation(populationAsString, out population);
context = new WorldEntities();
int continentId = int.Parse(this.ListBoxContinents.SelectedValue);
FileUpload flagImageUpload = this.GetFooterRowControl(this.GridViewCountries, "FileUploadNewCountryFlag") as FileUpload;
byte[] fileData = this.GetUploadedFile(flagImageUpload.PostedFile);
var country = new Country
{
CountryId = countryId,
CountryName = countryName,
Latitude = latitude,
Longitude = longitude,
SurfaceArea = area,
ContinentId = continentId,
Population = population,
FlagImage = fileData
};
string newLanguageNames = this.GetFooterRowTextBoxText(this.GridViewCountries, "TextBoxNewLanguages");
string[] languageNames = newLanguageNames.Split(new char[] { ',', ' ' }, StringSplitOptions.RemoveEmptyEntries);
foreach (string languageName in languageNames)
{
var language = context.Languages.FirstOrDefault(l => string.Compare(l.LanguageName, languageName, true) == 0);
if (language == null)
{
language = new Language
{
LanguageName = languageName
};
context.Languages.Add(language);
context.SaveChanges();
}
country.Languages.Add(language);
}
context.Countries.Add(country);
context.SaveChanges();
Response.Redirect(Request.RawUrl);
}
catch (Exception ex)
{
this.LabelCountryErrors.Text = ex.Message;
}
finally
{
if (context != null)
{
context.Dispose();
}
}
}
protected void GridViewCountries_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
WorldEntities context = null;
this.LabelCountryErrors.Text = string.Empty;
try
{
string countryName = (this.GridViewCountries.Rows[e.RowIndex].FindControl("TextBoxCountryName") as TextBox).Text;
this.ValidateName(countryName);
float latitude;
string latitudeAsString = (this.GridViewCountries.Rows[e.RowIndex].FindControl("TextBoxLatitude") as TextBox).Text;
this.ValidateGeoCoordinate(latitudeAsString, out latitude);
float longitude;
string longitudeAsString = (this.GridViewCountries.Rows[e.RowIndex].FindControl("TextBoxLongitude") as TextBox).Text;
this.ValidateGeoCoordinate(longitudeAsString, out longitude);
float area;
string areaAsString = (this.GridViewCountries.Rows[e.RowIndex].FindControl("TextBoxSurfaceArea") as TextBox).Text;
this.ValidateArea(areaAsString, out area);
int population;
string populationAsString = (this.GridViewCountries.Rows[e.RowIndex].FindControl("TextBoxPopulation") as TextBox).Text;
this.ValidatePopulation(populationAsString, out population);
context = new WorldEntities();
string selectedCountryId = this.GridViewCountries.DataKeys[e.RowIndex].Value.ToString();
var country = context.Countries.FirstOrDefault(c => c.CountryId == selectedCountryId);
if (country != null)
{
var postedFile = (this.GridViewCountries.Rows[e.RowIndex].FindControl("FileUploadChangeFlag") as FileUpload).PostedFile;
if (postedFile != null && postedFile.ContentLength > 0)
{
byte[] data = this.GetUploadedFile(postedFile);
country.FlagImage = data;
context.Entry <Country>(country).State = EntityState.Modified;
context.SaveChanges();
}
country.Languages.Clear();
string newLanguageNames = this.GetTextBoxText(this.GridViewCountries, e.RowIndex, "TextBoxLanguages");
string[] languageNames = newLanguageNames.Split(new char[] { ',', ' ' }, StringSplitOptions.RemoveEmptyEntries);
foreach (string languageName in languageNames)
{
var language = context.Languages.FirstOrDefault(l => string.Compare(l.LanguageName, languageName, true) == 0);
if (language == null)
{
language = new Language
{
LanguageName = languageName
};
context.Languages.Add(language);
context.SaveChanges();
}
country.Languages.Add(language);
}
context.SaveChanges();
}
}
catch (Exception ex)
{
this.LabelCountryErrors.Text = ex.Message;
e.Cancel = true;
}
finally
{
if (context != null)
{
context.Dispose();
}
}
}
protected void ButtonAddCountry_Click(object sender, EventArgs e)
{
string newCountryID = this.GetFooterRowTextBoxText(this.GridViewCountries, "TextBoxAddCountryId");
if (!IsValidCountryId(newCountryID))
{
return;
}
string newCountryName = this.GetFooterRowTextBoxText(this.GridViewCountries, "TextBoxAddCountry");
if (!IsValidCountryName(newCountryName))
{
return;
}
string newCountryLatitude = this.GetFooterRowTextBoxText(this.GridViewCountries, "TextBoxAddLatitude");
float latitude;
if (!float.TryParse(newCountryLatitude, out latitude))
{
Response.Write("Enter correct latitude!");
return;
}
string newCountryLongitude = this.GetFooterRowTextBoxText(this.GridViewCountries, "TextBoxAddLongitude");
float longitude;
if (!float.TryParse(newCountryLongitude, out longitude))
{
Response.Write("Enter correct longitude!");
return;
}
string newCountrySurfaceArea = this.GetFooterRowTextBoxText(this.GridViewCountries, "TextBoxAddSurfaceArea");
int surfaceArea;
if (!int.TryParse(newCountrySurfaceArea, out surfaceArea))
{
Response.Write("Enter correct Surface Area (int number)!");
return;
}
string newCountryPopulation = this.GetFooterRowTextBoxText(this.GridViewCountries, "TextBoxAddPopulation");
int population;
if (!int.TryParse(newCountryPopulation, out population))
{
Response.Write("Enter correct population (int number)!");
return;
}
ListBox listBoxLanguages = this.GridViewCountries.FooterRow.FindControl("ListBoxAddLanguages") as ListBox;
int[] listBoxLanguagesIndices = listBoxLanguages.GetSelectedIndices();
if (listBoxLanguagesIndices.Length < 1)
{
Response.Write("Correct Country is required!");
return;
}
Country newCountry = new Country()
{
CountryId = newCountryID,
CountryName = newCountryName,
Latitude = latitude,
Longitude = longitude,
SurfaceArea = surfaceArea,
Population = population
};
WorldEntities db = new WorldEntities();
var allLanguages = listBoxLanguages.Items;
string currSelectedLanguageId = string.Empty;
Language currLanguage;
foreach (int languageIndex in listBoxLanguagesIndices)
{
currSelectedLanguageId = allLanguages[languageIndex].Value;
currLanguage = db.Languages.FirstOrDefault(lang => lang.LanguageId.ToString() == currSelectedLanguageId);
if (currLanguage == null)
{
Response.Write("Invalid Country entered!");
return;
}
newCountry.Languages.Add(currLanguage);
}
var selectedContinentId = this.ListBoxContinents.SelectedItem.Value;
var continent = db.Continents.FirstOrDefault(c => c.ContinentId.ToString() == selectedContinentId);
if (continent == null)
{
Response.Write("Selected continent was not found!");
return;
}
newCountry.Continent = continent;
FileUpload fileUploadControl = this.GridViewCountries.FooterRow.FindControl("FileUploadFlagChange") as FileUpload;
byte[] fileData = this.GetUploadedFile(fileUploadControl.PostedFile);
newCountry.FlagImage = fileData;
db.Countries.Add(newCountry);
db.SaveChanges();
Response.Redirect(Request.RawUrl);
}