public HttpResponseMessage Put(int id, [FromBody] Product product) { try { using (WebStoreEntities entities = new WebStoreEntities()) { var entity = entities.Products.FirstOrDefault(e => e.Id == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Product with id = " + id.ToString() + " not found to update")); } else { entity.Name = product.Name; entity.Description = product.Description; entity.Stock = product.Stock; entity.CategoryId = product.CategoryId; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public IEnumerable <Product> Get() { using (WebStoreEntities entities = new WebStoreEntities()) { return(entities.Products.ToList()); } }
// GET: Store public ActionResult Index() { WebStoreEntities db = new WebStoreEntities(); string mail = ""; //HttpContext.Response.Cookies["mail"].Value = ""; if (HttpContext.Request.Cookies.Count > 0) { if (HttpContext.Request.Cookies["mail"].Value != "") { mail = HttpContext.Request.Cookies["mail"].Value; } } //var dbStore = new STORE(); if (mail != "") { var dbStore = db.STORE.Where(x => x.USERS.EMAIL == mail).ToList(); return(View(dbStore)); } else { return(View()); } }
public ActionResult Register(string firstName, string lastName, string email, string pass, string adress) { WebStoreEntities db = new WebStoreEntities(); USERS user = new USERS(); HttpContext.Response.Cookies["regSuccess"].Value = ""; //var dbUser = db.USERS.Where(x=>x.EMAIL == email).ToList(); //if(dbUser.Count > 0) //{ if (adress != "") { user.ADRESS = adress; } user.FIRSTNAME = firstName; user.LASTNAME = lastName; user.EMAIL = email; user.PASS = pass; user.GRUP = "user"; db.USERS.Add(user); db.SaveChanges(); HttpContext.Response.Cookies["regSuccess"].Value = ""; //return View(); return(RedirectToAction("Index", "Index")); //} // else //{ //string success = "Электронная почта уже занята"; //HttpContext.Response.Cookies["regSuccess"].Value = "false"; //return View(); //} }
public HttpResponseMessage Get(int id) { using (WebStoreEntities entities = new WebStoreEntities()) { var entity = entities.Products.FirstOrDefault(e => e.Id == id); if (entity != null) { return(Request.CreateResponse(HttpStatusCode.OK, entity)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Product with id = " + id.ToString() + " not found")); } } }
public ActionResult Search(string searchItem) { WebStoreEntities db = new WebStoreEntities(); var dbItem = db.PRODUCTS.Where(x => x.PRODUCTNAME.Contains(searchItem)).ToList(); if (dbItem.Count > 0) { return(View(dbItem)); } else { return(View()); } }
public void addToStore(string name, string price, int kol, string mail) { WebStoreEntities db = new WebStoreEntities(); STORE dbStore = new STORE(); var dbUser = db.USERS.ToList(); var dbProd = db.PRODUCTS.ToList(); int idProd = dbProd.Single(x => x.PRODUCTNAME == name).ID; //string mail = HttpContext.Response.Cookies["mail"].Value; int idUser = dbUser.Single(x => x.EMAIL == mail).ID; dbStore.LOGIN_ID = idUser; dbStore.PROD_ID = idProd; dbStore.KOL = kol; db.STORE.Add(dbStore); db.SaveChanges(); }
public ActionResult Add(string productName, string productProizv, string productDesc, string productPrice, string category) { WebStoreEntities db = new WebStoreEntities(); PRODUCTS prod = new PRODUCTS(); name = productName; prod.PRODUCTNAME = productName; prod.DESCR = productDesc; prod.MANUFACT = productProizv; prod.PRICE = productPrice; prod.CATEGORY = category; db.PRODUCTS.Add(prod); db.SaveChanges(); return(View()); }
public HttpResponseMessage Post([FromBody] Product product) { try { using (WebStoreEntities entities = new WebStoreEntities()) { entities.Products.Add(product); entities.SaveChanges(); var message = Request.CreateResponse(HttpStatusCode.Created, product); message.Headers.Location = new Uri(Request.RequestUri + product.Id.ToString()); return(message); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage Delete(int id) { try { using (WebStoreEntities entities = new WebStoreEntities()) { var entity = entities.Products.FirstOrDefault(e => e.Id == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Product with id = " + id.ToString() + " not found to delete")); } else { entities.Products.Remove(entity); entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }