//private static CustomerRepositoryEntities1 NewMethod(Address ca) //{ // // add a new address to the address list // //System.Windows.Forms.MessageBox.Show(ca.CustomerId+""); // // var db = new CustomerRepositoryEntities1(); // var db = new MyDbContext(); // var caa = db.Customers.Where(ce => ce.CustomerId == ca.CustomerId).FirstOrDefault(); // ca.Customer = db.Customers.Where(c => c.CustomerId == ca.CustomerId).FirstOrDefault(); // return db; //} public ActionResult Delete_address(int id) { // add a new address to the address list //System.Windows.Forms.MessageBox.Show(ca.CustomerId+""); //var db = new CustomerRepositoryEntities1(); //var db = new CustomerRepositoryEntities1(); var db = new MyDbContext(); var address = db.Addresses.Where(a => a.AddressId == id).FirstOrDefault(); var cust_id = address.CustomerId; db.Addresses.Remove(address); db.SaveChanges(); var cust = db.Customers.ToList().Where(o => o.CustomerId == cust_id).FirstOrDefault(); var addresses = db.Addresses.Where(a => a.CustomerId == cust_id).ToList(); var customerDetails = new CustomerDemailModelViewModel() { customer = cust, addresses = addresses//db.Addresses.ToList().Where(o => o.CustomerId == id).ToList() }; //ViewBag.cList = db.customers; return(RedirectToAction("index")); }
public ActionResult ViewDetails(int id) { // var db = new CustomerRepositoryEntities1(); var db = new MyDbContext(); var cust = db.Customers.ToList().Where(o => o.CustomerId == id).FirstOrDefault(); var addresses = db.Addresses.Where(a => a.CustomerId == id).ToList(); var customerDetails = new CustomerDemailModelViewModel() { customer = cust, addresses = addresses,//db.Addresses.ToList().Where(o => o.CustomerId == id).ToList() }; //ViewBag.cList = db.customers; return(PartialView(customerDetails)); }