// GET: PictureClassifiaction public ActionResult getUnClassifiedPictures() { ITProjektasDB db = new ITProjektasDB(); UnclassifiedPicutresModel liz = new UnclassifiedPicutresModel(); liz.pictures = db.Unclassified_pictures.Where(x => x.picture_class == "" || x.picture_class == null).ToList(); return(View(liz)); }
public ActionResult LearningParametersForm(int id) { ITProjektasDB db = new ITProjektasDB(); Search_parameters param = db.Search_parameters.SingleOrDefault(x => x.id_Search_parameters == id); return(View(param)); }
public ActionResult Update(Search_parameters updatedParameters) { ITProjektasDB db = new ITProjektasDB(); Search_parameters notupdatedParameters = db.Search_parameters.SingleOrDefault( x => x.id_Search_parameters == updatedParameters.id_Search_parameters ); if (notupdatedParameters != null) { db.Entry(notupdatedParameters).CurrentValues.SetValues(updatedParameters); } db.SaveChanges(); return(RedirectToAction("GetLearningParameters", "LearningParameters")); }
public ActionResult ClassifyPictures(Unclassified_pictures[] pictures) { ITProjektasDB db = new ITProjektasDB(); foreach (var item in pictures) { Unclassified_pictures notupdatedParameters = db.Unclassified_pictures.SingleOrDefault( x => x.id_Unclassified_pictures == item.id_Unclassified_pictures ); if (notupdatedParameters != null) { db.Entry(notupdatedParameters).CurrentValues.SetValues(item); } db.SaveChanges(); } return(RedirectToAction("getUnClassifiedPictures", "PictureClassifiaction")); }
internal string ComparePrice(Product x) { // bad idea Shop dummy = new Shop(); ITProjektasDB db = new ITProjektasDB(); string resStr = "No deals for this item found."; // Find cheapest Product_in_shop inShopObj = db.Product_in_shop.Where(model => model.fk_Productid_Product == x.id_Product).OrderBy(model => model.price).FirstOrDefault(); Shop d = dummy.GetShop(1); if (d == null || inShopObj == null) { return(resStr); } resStr = "Best price found in the " + d.name + " shop of $" + inShopObj.price + "."; return(resStr); }
public ActionResult Login(Person objUser) { if (ModelState.IsValid) { ITProjektasDB db = new ITProjektasDB(); //Search_parameters param = db.Search_parameters.SingleOrDefault(x => x.id_Search_parameters == 2); var obj = db.People.Where(a => a.user_name.Equals(objUser.user_name) && a.password.Equals(objUser.password)).FirstOrDefault(); if (obj != null) { Session["UserID"] = obj.id_Person.ToString(); Session["UserName"] = obj.user_name.ToString(); Session["Name"] = obj.name.ToString(); return(RedirectToAction("UserDashBoard")); } } return(View(objUser)); }
public List <Tuple <Product, String> > GetItems(String textQuery) { ITProjektasDB db = new ITProjektasDB(); var res = new List <Product>(); var intermed = db.Products.Where( x => x.name.Contains(textQuery) == true ).ToList(); List <Tuple <Product, String> > ret = new List <Tuple <Product, string> >(); PriceComparisonController PCC = new PriceComparisonController(); foreach (var x in intermed) { String bestPrice = PCC.ComparePrice(x); Tuple <Product, String> t = new Tuple <Product, string>(x, bestPrice); ret.Add(t); } return(ret); }
public ActionResult GetLearningParameters() { ITProjektasDB db = new ITProjektasDB(); return(View(db.Search_parameters)); }