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