public PartialViewResult Search(string name) { var customerResultsViewModel = new Models.CustomerResultsViewModel(); CustomersDatabaseDataContext db = new CustomersDatabaseDataContext(); if (name == "") { var customers = from a in db.Customers select a; var parsingSearchResults = customers.Select(customer => new Models.CustomerViewModel { ID = customer.Id, FirstName = customer.FirstName, LastName = customer.LastName, Email = customer.Email }); var customerSearchResults = new List<Models.CustomerViewModel> { }; foreach (var customer in parsingSearchResults) { customerSearchResults.Add(customer); } customerResultsViewModel.CustomerSearchResults = customerSearchResults; } else { var customers = from a in db.Customers. Where(p => p.FirstName == name) select a; var parsingSearchResults = customers.Select(customer => new Models.CustomerViewModel { ID = customer.Id, FirstName = customer.FirstName, LastName = customer.LastName, Email = customer.Email }); var customerSearchResults = new List<Models.CustomerViewModel> { }; foreach (var customer in parsingSearchResults) { customerSearchResults.Add(customer); } customerResultsViewModel.CustomerSearchResults = customerSearchResults; } return PartialView("_UserResultsViewPartial", customerResultsViewModel); }
public PartialViewResult AddCustomer(string firstName, string lastName, string email) { using (CustomersDatabaseDataContext db = new CustomersDatabaseDataContext()) { Customer customer = new Customer(); customer.FirstName = firstName; customer.LastName = lastName; customer.Email = email; db.Customers.InsertOnSubmit(customer); db.SubmitChanges(); }; return PartialView("_AddUserResultsViewPartial"); }
public PartialViewResult DeleteCustomer(string customer_id) { int person_id = int.Parse(customer_id); using (CustomersDatabaseDataContext db = new CustomersDatabaseDataContext()) { var customer = from a in db.Customers. Where(p => p.Id == person_id) select a; foreach (var person in customer) { db.Customers.DeleteOnSubmit(person); } db.SubmitChanges(); }; return PartialView("_DeleteResultsViewPartial"); }