public static bool DoesUserExists(UserLoginDetails userLoginDetails)
{
bool found;
using (marketContext = new MarketContext())
{
var user = marketContext.Users.Where(u => (u.Email == userLoginDetails.UserEmail) && (u.Password == userLoginDetails.UserPassword)).FirstOrDefault();
found = user != null ? true : false;
}
return(found);
}
public ProductDetails AddProduct(ProductDetails productDetails)
{
ProductDetails productAdded;
using (marketContext = new MarketContext())
{
productAdded = marketContext.Products.Add(productDetails);
marketContext.SaveChanges();
}
return(productAdded);
}
public static UserDetails AddUser(UserDetails userDetails)
{
UserDetails user;
using (marketContext = new MarketContext())
{
user = marketContext.Users.Add(userDetails);
marketContext.SaveChanges();
}
return(user);
}
public static ProductDetails GetProduct(int id)
{
ProductDetails product = null;
using (var context = new MarketContext())
{
product = context.Products
.Where(x => x.ProductId == id)
.FirstOrDefault();
}
return(product);
}
public static List <ProductCategory> GetProductCategories()
{
List <ProductCategory> productCategories = null;
using (var context = new MarketContext())
{
productCategories = context.ProductCategories.ToList <ProductCategory>();
}
if (productCategories == null || productCategories.Count == 0)
{
return(null);
}
return(productCategories);
}
public static List <ProductDTO> GetAllProducts()
{
List <ProductDTO> allProducts;
using (marketContext = new MarketContext())
{
allProducts = marketContext.Products.Where(product => product.ProductId != null).Select(product => new ProductDTO()
{
ProductId = product.ProductId,
ProductCategory = product.ProductCategory,
ProductModelName = product.ProductModelName,
ProductDescription = product.ProductDescription
}).ToList();
}
return(allProducts);
}
public static void AddProduct(MultipartFormDataStreamProvider provider)
{
var model = provider.FormData["product"];
var jsonObj = JObject.Parse(model);
var product = JsonConvert.DeserializeObject <ProductDetails>(jsonObj.ToString());
string filename = String.Empty, filepath = String.Empty;
foreach (MultipartFileData file in provider.FileData)
{
filename = file.Headers.ContentDisposition.FileName;
filepath = file.LocalFileName;
}
product.ProductImageFile = File.ReadAllBytes(filepath);
product.ProductFileName = filename;
using (marketContext = new MarketContext())
{
var stud = product;
marketContext.Products.Add(product);
marketContext.SaveChanges();
}
File.Delete(filepath);
}