public tbl_product ViewProduct(int ID)
{
CDBEntities dal = new CDBEntities();
var rec = dal.tbl_product.Where(p => p.pid == ID).SingleOrDefault();
return(rec);
}
public string ViewCategoryNane(string cid)
{
CDBEntities dal = new CDBEntities();
var record = dal.tbl_category.Where(o => o.cid == cid).Select(o => o.cname).SingleOrDefault();
return(record);
}
public List <string> GetAllCategoryById()
{
CDBEntities db = new CDBEntities();
var result = db.tbl_category.Select(o => o.cid).ToList();
return(result);
}
public void AddProducts(tbl_product pro)
{
CDBEntities dbctx = new CDBEntities();
dbctx.tbl_product.Add(pro);
dbctx.SaveChanges();
}
public List <tbl_product> GetAllProducts()
{
CDBEntities dbctx = new CDBEntities();
var result = dbctx.tbl_product.ToList();
return(result);
}
public List <tbl_category> GetAllCategories()
{
CDBEntities dbctx = new CDBEntities();
var result = dbctx.tbl_category.ToList();
return(result);
}
