//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);
}
public string[] AddUpdateProductCat(EntityAddImage Entaddimg)
{
string[] returnValues = new string[2];
using (DairyHubEntities db = new DairyHubEntities())
{
Product objtblpro = new Product();
objtblpro.Catid = Entaddimg.Catid;
objtblpro.ProductName = Entaddimg.ProductName;
db.Products.Add(objtblpro);
string savevalue = db.SaveChanges().ToString();
returnValues[0] = "Insert";
returnValues[1] = objtblpro.Catid.ToString();
}
return(returnValues);
}
public ActionResult ProductJSON(string idd)
{
if (idd.ToString() == "Select")
{
idd = "0";
}
DairyHubEntities objEntity = new DairyHubEntities();
IEnumerable <SelectListItem> DDLList = new List <SelectListItem>();
string id = idd;
DDLList = (from objP in objEntity.Products where objP.Catid == id select objP).AsEnumerable().Select(p => new SelectListItem()
{
Text = p.ProductName, Value = p.Proid.ToString()
}).OrderBy(b => b.Text);
return(Json(DDLList));
}
public EntityAddImage GetAllData(EntityAddImage objadd)
{
using (DairyHubEntities lifstylobjdb = new DairyHubEntities())
{
objadd.DDLCategory = new List <SelectListItem>();
objadd.DDLProduct = new List <SelectListItem>();
var cat = from objcat in lifstylobjdb.ProductCategories
select new
{
objcat.Catid,
objcat.CatName
};
objadd.DDLCategory.Add(new SelectListItem
{
Text = "Select",
Value = "0",
Selected = true
});
if (cat != null && cat.ToList().Count > 0)
{
for (int i = 0; i < cat.ToList().Count; i++)
{
objadd.DDLCategory.Add(new SelectListItem
{
Text = cat.ToList()[i].CatName.ToString(),
Value = cat.ToList()[i].Catid.ToString()
});
}
}
objadd.DDLProduct.Add(new SelectListItem
{
Text = "Select",
Value = "0",
Selected = true
});
}
return(objadd);
}
