public void Add(CMRC_Categories t)
{
CommerceEntities1 dc = new CommerceEntities1();
dc.CMRC_Categories.Add(t);
dc.SaveChanges();
}
public void Add(CMRC_Customers t)
{
CommerceEntities1 dc = new CommerceEntities1();
dc.CMRC_Customers.Add(t);
dc.SaveChanges();
}
public void Add(CMRC_OrderDetails t)
{
CommerceEntities1 dc = new CommerceEntities1();
dc.CMRC_OrderDetails.Add(t);
dc.SaveChanges();
}
public ActionResult List()
{
ViewBag.list = new BLL.Category().GetAll();
CommerceEntities1 dc = new CommerceEntities1();
return(PartialView(dc.CMRC_Categories.ToList()));
}
public void Deleteid(int id)
{
CommerceEntities1 dc = new CommerceEntities1();
var a = dc.CMRC_Categories.Find(id);
dc.CMRC_Categories.Remove(a);
dc.SaveChanges();
}
List <CMRC_Products> IProducts.GetAllID(int id)
{
CommerceEntities1 dc = new CommerceEntities1();
return(dc.CMRC_Products.Where(x => x.CategoryID == id).ToList());
}
public List <CMRC_Categories> GetAll()
{
CommerceEntities1 dc = new CommerceEntities1();
return(dc.CMRC_Categories.ToList());
}
public CMRC_Categories FindID(int id)
{
CommerceEntities1 dc = new CommerceEntities1();
return((CMRC_Categories)dc.CMRC_Categories.Where(x => x.CategoryID == id));
}
public List <CMRC_Customers> GetAll()
{
CommerceEntities1 dc = new CommerceEntities1();
return(dc.CMRC_Customers.ToList());
}
public CMRC_Customers FindID(int id)
{
CommerceEntities1 dc = new CommerceEntities1();
return((CMRC_Customers)dc.CMRC_Customers.Where(x => x.CustomerID == id));
}
