public void Insert(CustomerVM customerVM)
{
var entity = new storeDBEntities();
CustomerVM vm = new CustomerVM();
customer customerobj = new customer(); //table
customerobj.customerid = customerVM.customerid;
customerobj.customername = customerVM.customername;
customerobj.rewards = customerVM.rewards;
customerobj.contactnumber = customerVM.contactnumber;
customerobj.location = customerVM.location;
entity.customers.Add(customerobj); //db.table-object
entity.SaveChanges();
}
public void Insert(ItemsVM Items)
{
var _context = new storeDBEntities();
ItemsVM vm = new ItemsVM();
item newitemobj = new item(); //table
newitemobj.itemname = Items.itemname;
newitemobj.price = Items.price;
newitemobj.discount = Items.discount;
newitemobj.manufacturedate = Items.manufacturedate;
newitemobj.expirydate = Items.expirydate;
newitemobj.manufacturerid = 1;
newitemobj.itemtypeid = 1;
_context.items.Add(newitemobj);
_context.SaveChanges();
}
public ActionResult Index()
{
storeDBEntities entities = new storeDBEntities();
return(View(from item in entities.items select item));
}
public ActionResult Index()
{
storeDBEntities storeDBEntities = new storeDBEntities();
return(View(from customer in storeDBEntities.customers select customer));
}
