public ProductFullModel GetProductById(
[ValueProvider(typeof(HeaderValueProviderFactory <string>))] string sessionKey, int id)
{
var context = new StoreContext();
using (context)
{
var user = UsersController.GetUserBySessionKey(sessionKey);
if (user == null)
{
throw new ArgumentException("There is no user with such sessionKey!");
}
var productById = context.Products.FirstOrDefault(p => p.ProductId == id);
var newProductModel = new ProductFullModel()
{
ProductId = productById.ProductId,
Price = productById.Price,
Category = productById.Category.CategoryName,
DateOfCreation = productById.DateOfCreation,
Description = productById.Description,
Manufacturer = productById.Manufacturer,
ProductName = productById.ProductName,
Quantity = productById.Quantity
};
return(newProductModel);
}
}
public HttpResponseMessage PutLogoutUser(
[ValueProvider(typeof(HeaderValueProviderFactory <string>))] string sessionKey)
{
var responseMsg = this.PerformOperationAndHandleExceptions(
() =>
{
var context = new StoreContext();
using (context)
{
User user = UsersController.GetUserBySessionKey(sessionKey);
if (user == null)
{
throw new ArgumentException("There is no user with such sessionKey!");
}
context.Users.
FirstOrDefault(usr => usr.SessionKey == sessionKey).
SessionKey = null;
context.SaveChanges();
var response =
this.Request.CreateResponse(HttpStatusCode.OK);
return(response);
}
});
return(responseMsg);
}
public IQueryable <ProductModel> GetByIdCategories(
[ValueProvider(typeof(HeaderValueProviderFactory <string>))] string sessionKey, int id)
{
var context = new StoreContext();
using (context)
{
var user = UsersController.GetUserBySessionKey(sessionKey);
if (user == null)
{
throw new ArgumentException("There is no user with such sessionKey!");
}
var newProductModel =
(from product in context.Products
where product.Category.CategoryId == id
select new ProductModel()
{
ProductId = product.ProductId,
ProductsName = product.ProductName
}).ToList();
return(newProductModel.AsQueryable());
}
}
public HttpResponseMessage PostProductByAdmin(
[ValueProvider(typeof(HeaderValueProviderFactory <string>))] string sessionKey, ProductFullModel product)
{
var responseMsg = this.PerformOperationAndHandleExceptions(
() =>
{
var context = new StoreContext();
using (context)
{
var user = UsersController.GetUserBySessionKey(sessionKey);
if (user == null)
{
throw new ArgumentException("There is no user with such sessionKey!");
}
if (!CheckUserIsAdmin(user.UserId))
{
throw new ArgumentException("You are not admin");
}
var cat = context.Categories.Where(c => c.CategoryName == product.Category).FirstOrDefault();
var newCategory = new Category();
if (cat == null)
{
newCategory.CategoryName = product.ProductName;
}
var newProduct =
new Product()
{
ProductId = product.ProductId,
Price = product.Price,
Category = newCategory,
DateOfCreation = product.DateOfCreation,
Description = product.Description,
Manufacturer = product.Manufacturer,
ProductName = product.ProductName,
Quantity = product.Quantity
};
context.Products.Add(newProduct);
context.SaveChanges();
var response =
this.Request.CreateResponse(HttpStatusCode.OK);
return(response);
}
});
return(responseMsg);
}
public IQueryable <UserModel> GetAllUsers(
[ValueProvider(typeof(HeaderValueProviderFactory <string>))] string sessionKey)
{
var context = new StoreContext();
using (context)
{
var user = UsersController.GetUserBySessionKey(sessionKey);
if (user == null)
{
throw new ArgumentException("There is no user with such sessionKey!");
}
if (user.Role != "admin")
{
throw new ArgumentException("You are not admin!");
}
var productsModels =
(from p in user.Products
select new ProductModel()
{
ProductId = p.ProductId,
ProductsName = p.ProductName
}).AsQueryable();
var newUserModel =
(from usr in context.Users
select new UserModel()
{
Username = usr.Username,
FirstName = usr.FirstName,
LastName = usr.LastName,
Email = usr.Email,
SessionKey = usr.SessionKey,
Password = usr.Password,
Role = usr.Role,
//Products = productsModels
}).ToList();
return(newUserModel.AsQueryable());
}
}
public IQueryable <CategoryModel> GetCategories(
[ValueProvider(typeof(HeaderValueProviderFactory <string>))] string sessionKey)
{
var context = new StoreContext();
using (context)
{
var user = UsersController.GetUserBySessionKey(sessionKey);
if (user == null)
{
throw new ArgumentException("There is no user with such sessionKey!");
}
var newCategoryModel =
(from category in context.Categories
select new CategoryModel()
{
CategoryId = category.CategoryId,
CategoryName = category.CategoryName
}).ToList();
return(newCategoryModel.AsQueryable());
}
}