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