// delete store public ActionResult DeleteStore(int id) { using (ProductFirstVersionEntities dbobj = new ProductFirstVersionEntities()) { var s = dbobj.Stores.Where(x => x.StoreId == id).FirstOrDefault(); return(View(s)); } }
// list of stores public ActionResult Store() { using (ProductFirstVersionEntities dbobj = new ProductFirstVersionEntities()) { var store = dbobj.Stores.ToList(); return(View(store)); } }
// delete record public ActionResult DeleteProduct(int id) { using (ProductFirstVersionEntities dbobj = new ProductFirstVersionEntities()) { var product = dbobj.Products.Where(x => x.ProductId == id).FirstOrDefault(); return(View(product)); } }
// delete public ActionResult DeleteCustomer(int id) { using (ProductFirstVersionEntities dbobj = new ProductFirstVersionEntities()) { var customer = dbobj.Customers.Where(x => x.CustomerId == id).FirstOrDefault(); return(View(customer)); } }
//to get list of customers public ActionResult Customer() { using (ProductFirstVersionEntities dbobj = new ProductFirstVersionEntities()) { var customer = dbobj.Customers.ToList(); return(View(customer)); } }
// get list of all products public ActionResult Product() { using (ProductFirstVersionEntities dbobj = new ProductFirstVersionEntities()) { var product = dbobj.Products.ToList(); return(View(product)); } }
public ActionResult DeleteStore(int id, Store s) { using (ProductFirstVersionEntities dbobj = new ProductFirstVersionEntities()) { var store = dbobj.Stores.Where(x => x.StoreId == id).FirstOrDefault(); dbobj.Stores.Remove(store); dbobj.SaveChanges(); return(RedirectToAction("Store")); } }
public ActionResult CreateProductSold(ProductSold newPS) { using (ProductFirstVersionEntities dbobj = new ProductFirstVersionEntities()) { dbobj.ProductSolds.Add(newPS); dbobj.SaveChanges(); return(RedirectToAction("ProductSold")); } }
public ActionResult DeleteProduct(int id, Product newproduct) { using (ProductFirstVersionEntities dbobj = new ProductFirstVersionEntities()) { var product = dbobj.Products.Where(x => x.ProductId == id).FirstOrDefault(); dbobj.Products.Remove(product); dbobj.SaveChanges(); return(RedirectToAction("Product")); } }
public ActionResult DeleteCustomer(int id, Customer newcustomer) { using (ProductFirstVersionEntities dbobj = new ProductFirstVersionEntities()) { var customer = dbobj.Customers.Where(x => x.CustomerId == id).FirstOrDefault(); dbobj.Customers.Remove(customer); dbobj.SaveChanges(); return(RedirectToAction("Customer")); } }
public ActionResult CreateStore(Store newstore) { if (ModelState.IsValid) { using (ProductFirstVersionEntities dbobj = new ProductFirstVersionEntities()) { dbobj.Stores.Add(newstore); dbobj.SaveChanges(); return(RedirectToAction("Store")); } } return(View()); }
public ActionResult ProductSold() { ProductFirstVersionEntities dbobj = new ProductFirstVersionEntities(); var productsold = dbobj.ProductSolds .Select(s => new customerproductnameview { ProductSoldId = s.ProductSoldId, CustomerName = s.CustomerName, ProductName = s.ProductName, }); return(View(productsold)); }
public ActionResult EditCustomer(int id, Customer newcustomer) { if (ModelState.IsValid) { using (ProductFirstVersionEntities dbobj = new ProductFirstVersionEntities()) { dbobj.Entry(newcustomer).State = EntityState.Modified; dbobj.SaveChanges(); return(RedirectToAction("Customer")); } } return(View()); }
public ActionResult CreateProduct(Product newproduct) { if (ModelState.IsValid) { using (ProductFirstVersionEntities dbobj = new ProductFirstVersionEntities()) { dbobj.Products.Add(newproduct); dbobj.SaveChanges(); return(RedirectToAction("Product")); } } return(View()); }
public ActionResult CreateCustomer(Customer newcustomer) { if (ModelState.IsValid) { using (ProductFirstVersionEntities dbobj = new ProductFirstVersionEntities()) { dbobj.Customers.Add(newcustomer); dbobj.SaveChanges(); return(RedirectToAction("Customer")); } } return(View()); }
public ActionResult EditStore(int id, Store newstore) { if (ModelState.IsValid) { using (ProductFirstVersionEntities dbobj = new ProductFirstVersionEntities()) { dbobj.Entry(newstore).State = EntityState.Modified; dbobj.SaveChanges(); return(RedirectToAction("Store")); } } return(View()); }
// get by id public ActionResult CustomerDetails(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } using (ProductFirstVersionEntities dbobj = new ProductFirstVersionEntities()) { var customer = dbobj.Customers.Where(x => x.CustomerId == id).FirstOrDefault(); if (customer == null) { return(HttpNotFound()); } return(View(customer)); } }
// get by id public ActionResult StoreDetails(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } using (ProductFirstVersionEntities dbobj = new ProductFirstVersionEntities()) { var store = dbobj.Stores.Where(x => x.StoreId == id).FirstOrDefault(); if (store == null) { return(HttpNotFound()); } return(View(store)); } }
// update public ActionResult EditProduct(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } using (ProductFirstVersionEntities dbobj = new ProductFirstVersionEntities()) { var product = dbobj.Products.Where(x => x.ProductId == id).FirstOrDefault(); if (product == null) { return(HttpNotFound()); } return(View(product)); } }