public tbl_category getcategorynames(string id)
{
DXC_DBEntities DB = new DXC_DBEntities();
var result = DB.tbl_category.Where(o => o.categoryid == id).SingleOrDefault();
return(result);
}
public List <string> getcategoryid()
{
DXC_DBEntities DB = new DXC_DBEntities();
var d = DB.tbl_category.Select(o => o.categoryid).ToList();
return(d);
}
public void addproduct(tbl_product p)
{
DXC_DBEntities DB = new DXC_DBEntities();
DB.tbl_product.Add(p);
DB.SaveChanges();
}
public List <tbl_product> Viewproduct()
{
DXC_DBEntities DB = new DXC_DBEntities();
var p = DB.tbl_product.ToList();
return(p);
}
