protected void Page_Init(object sender, EventArgs e)
{
if (Request["id"] != null)
{
id = Guid.Parse(Request["id"]);
}
context = new CustomerManagementEntities();
}
public string[] GetCountries()
{
var context = new CustomerManagementEntities();
var res =
from c in context.Countries
orderby c.Name
select c.Name;
return(res.ToArray());
}
public string CountryByCode(string isoCode)
{
var context = new CustomerManagementEntities();
return
((from c in context.Countries
where c.InternetTLD == isoCode
select c.Name)
.FirstOrDefault());
}
public Customer[] GetCustomersByCountry(string country)
{
var context = new CustomerManagementEntities();
return
((from customer in context.Customers
where customer.Country.Name == country
select customer)
.ToArray());
}
public List <string> GetContries()
{
using (CustomerManagementEntities customerManagementEntities =
new CustomerManagementEntities())
{
var contry = from c in customerManagementEntities.Countries
orderby c.Name
select c.Name;
return(contry.ToList());
}
}
public List <string> GetCustomersByCountry(string countryName)
{
using (CustomerManagementEntities context =
new CustomerManagementEntities())
{
var r = from c in context.Countries
where c.Name == countryName
select c.ID;
Guid idCountry = r.FirstOrDefault <Guid>();
var customers = from f in context.Customers
where f.CountryID == idCountry
select f.LastName;
return(customers.ToList());
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
using (CustomerManagementEntities context = new CustomerManagementEntities())
{
foreach (XElement country in countriesWithPhNoFormat)
{
Guid g = new Guid(country.Attribute("ID").Value);
Country c = context.Countries.Where(x => x.ID == g).FirstOrDefault <Country>();
c.PhoneNoFormat = country.Attribute("PhoneNoFormat").Value;
}
context.SaveChanges();
ImportResultLabel.Text = "Импорт завершен успешно";
}
}
catch (Exception ex)
{
ImportResultLabel.Text = ex.Message;
}
}
protected void Page_Init(object sender, EventArgs e)
{
context = new CustomerManagementEntities();
}
