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