//data display
public EntityDisplayProductCategory GetallProCat(EntityDisplayProductCategory Objdisplayent)
{
using (DairyHubEntities db = new DairyHubEntities())
{
//WRITE QUERY FOR FETCHING DATA OF PRODUCT CATEGORY
var data = (from x in db.ProductCategories
select new
{
x.Catid,
x.CatName
});
bool isrecordcontain = data.ToList().Any();
Objdisplayent.productcatdata = new List <EntityProductCategory>();
if (isrecordcontain && data.ToList().Count > 0)
{
for (int i = 0; i < data.ToList().Count; i++)
{
EntityProductCategory OBJENT = new EntityProductCategory();
OBJENT.Catid = data.ToList()[i].Catid.ToString();
OBJENT.CatName = data.ToList()[i].CatName.ToString();
Objdisplayent.productcatdata.Add(OBJENT);
}
}
}
return(Objdisplayent);
}
//data insert
public string[] AddUpdateProductCat(EntityProductCategory EntProCat)
{
string[] returnValues = new string[2];
using (DairyHubEntities db = new DairyHubEntities())
{
ProductCategory objtblprocat = new ProductCategory();
objtblprocat.Catid = EntProCat.Catid;
objtblprocat.CatName = EntProCat.CatName;
db.ProductCategories.Add(objtblprocat);
string savevalue = db.SaveChanges().ToString();
returnValues[0] = "Insert";
returnValues[1] = objtblprocat.Catid.ToString();
}
return(returnValues);
}
