//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); }