public void Create(MainImageViewModel model)
{
foreach (var element in GetAllPerProductId(model.ProductId))
{
if (model.MainPicture)
{ element.MainPicture = false; }
else
{ break; }
}
Image picture = new Image
{
ImageId= model.ImageId,
ProductId = model.ProductId,
FileName = model.FileName,
Picture = new byte [model.Image.ContentLength],
ImageMineType = model.Image.ContentType,
MainPicture = model.MainPicture
};
using (MemoryStream memStream = new MemoryStream(model.Image.ContentLength))
{
// model.Image.InputStream.Read(picture.Picture,0, model.Image.ContentLength);
model.Image.InputStream.CopyTo(memStream, model.Image.ContentLength);
picture.Picture = memStream.ToArray();
}
using (var context = new WebShopMVCContext())
{
context.Images.Add(picture);
context.SaveChanges();
}
}
public ProductViewModel GetModelById(int id)
{
ProductViewModel model;
using (var context = new WebShopMVCContext())
{
var product = context.Products.Find(id);
model = new ProductViewModel
{
ProductId = product.ProductId,
ProductName = product.ProductName,
SubcategoryId = product.SubcategoryId,
Price = product.Price,
Discount = product.Discount,
Description = product.Description,
Subcategories = context.Subcategories.Select(c => new PartViewSubcategoriesForProduct
{
SubcategoryName = c.SubcategoryName,
SubcategoryId = c.SubcategoryId
}).ToList(),
Images = context.Images.Select(f => new PartImageViewModel
{
MainPicture = f.MainPicture,
FileName = f.FileName,
ImageId = f.ImageId,
ProductId = f.ProductId
}).Where(p=>p.ProductId==id).ToList()
};
}
return model;
}
public void Delete(int id)
{
using (var context = new WebShopMVCContext())
{
context.Clients.Remove(
context.Clients.Where(m => m.UserId == id).FirstOrDefault());
context.SaveChanges();
}
}
public void RemoveUnit(int productId)
{
using (var context = new WebShopMVCContext())
{
var product = context.CartItems.Find(productId);
context.CartItems.Remove(product);
context.SaveChanges();
}
}
public void Delete(int id)
{
using (var context = new WebShopMVCContext())
{
var product = context.Products.Find(id);
context.Products.Remove(product);
context.SaveChanges();
}
}
public void Delete(int id)
{
using (var context = new WebShopMVCContext())
{
var picture = context.Images.Find(id);
context.Images.Remove(picture);
context.SaveChanges();
}
}
public void Delete(int id)
{
using (var context = new WebShopMVCContext())
{
var category = context.Categories.Find(id);
context.Categories.Remove(category);
context.SaveChanges();
}
}
public void Create(CategoryViewModel model)
{
Category category = new Category
{
CategoryName = model.CategoryName
};
using (var context = new WebShopMVCContext())
{
context.Categories.Add(category);
context.SaveChanges();
}
}
public IEnumerable<CategoryViewModel> GetAll()
{
var list = new List<CategoryViewModel>();
using (var context = new WebShopMVCContext())
{
list = context.Categories.Select(m => new CategoryViewModel
{
CategoryId = m.CategoryId,
CategoryName = m.CategoryName
}).ToList();
}
return list;
}
public void Create(SubcategoryViewModel model)
{
Subcategory subcategory = new Subcategory
{
CategoryId = model.CategoryId,
SubcategoryName = model.SubcategoryName
};
using (var context = new WebShopMVCContext())
{
context.Subcategories.Add(subcategory);
context.SaveChanges();
}
}
public void AddItem(int clientId, int productId, int quantity)
{
CartItem item = new CartItem
{
ProductId = productId,
ClientId = clientId,
Quantity = quantity
};
using (var context = new WebShopMVCContext())
{
context.CartItems.Add(item);
context.SaveChanges();
}
}
public CategoryViewModel GetModelById(int id)
{
CategoryViewModel model;
using (var context = new WebShopMVCContext())
{
var category = context.Categories.Find(id);
model = new CategoryViewModel
{
CategoryId = category.CategoryId,
CategoryName = category.CategoryName
};
}
return model;
}
public IEnumerable<SubcategoryViewModel> GetAllById(int categoryId)
{
var list = new List<SubcategoryViewModel>();
using (var context = new WebShopMVCContext())
{
list = context.Subcategories.Include("Categories").Where(c => c.CategoryId == categoryId).Select(m => new SubcategoryViewModel
{
CategoryId = m.CategoryId,
SubcategoryId = m.SubcategoryId,
SubcategoryName = m.SubcategoryName,
CategoryName = m.Category.CategoryName
}).ToList();
}
return list;
}
public IEnumerable<PartImageViewModel> GetAllPerProductId(int id)
{
var list = new List<PartImageViewModel>();
using (var context = new WebShopMVCContext())
{
list = context.Images.Select(m => new PartImageViewModel
{
ImageId = m.ImageId,
ProductId = m.ProductId,
MainPicture = m.MainPicture,
FileName = m.FileName
}).Where(m => m.ProductId==id).ToList();
}
return list;
}
public FileContentResult GetImage(int imageId)
{
using (var context = new WebShopMVCContext())
{
var image = context.Images.FirstOrDefault(i => i.ImageId == imageId);
if (image != null)
{
return File(image.Picture, image.ImageMineType);
}
else
{
return null;
}
}
}
public IEnumerable<CartItemViewModel> GetCartFromSession()
{
HttpContext context = HttpContext.Current;
if (context.Session["Cart"] == null)
{
return null;
}
else
{
var cart = (List<PartCartItemViewModel>)(context.Session["Cart"]);
List<CartItemViewModel> list = new List<CartItemViewModel>();
List<ProductViewModel> products = new List<ProductViewModel>();
foreach (var item in cart)
{
using (var contextBd = new WebShopMVCContext())
{
ProductViewModel product = contextBd.Products.Select(p => new ProductViewModel
{
ProductId = p.ProductId,
ProductName = p.ProductName,
SubcategoryId = p.SubcategoryId,
Price = p.Price,
Discount = p.Discount,
Description = p.Description,
}).Where(p => p.ProductId == item.ProductId).SingleOrDefault();
products.Add(product);
}
foreach (var product in products)
{
if (product.ProductId == item.ProductId)
{
CartItemViewModel cartitem = new CartItemViewModel
{
ProductId = product.ProductId,
Product = product,
Quantity = item.Quantity
};
list.Add(cartitem);
}
}
}
return list;
}
}
public IEnumerable<ClientViewModel> GetAll()
{
var model = new List<ClientViewModel>();
using (var context = new WebShopMVCContext())
{
model = context.Clients.Select(m => new ClientViewModel
{
FirstName = m.FirstName,
LastName = m.LastName,
Login = m.Login,
Password = m.Password,
Email = m.Email,
Phone = m.Phone
}).ToList();
}
return model;
}
public IEnumerable<ProductViewModel> GetAll()
{
var list = new List<ProductViewModel>();
using (var context = new WebShopMVCContext())
{
list = context.Products.Select(m => new ProductViewModel
{
ProductId = m.ProductId,
ProductName = m.ProductName,
SubcategoryId = m.SubcategoryId,
Price = m.Price,
Discount = m.Discount,
Description = m.Description
}).ToList();
}
return list;
}
public void Create(ProductViewModel model)
{
Product product = new Product
{
ProductId = model.ProductId,
ProductName = model.ProductName,
SubcategoryId = model.SubcategoryId,
Price = model.Price,
Discount = model.Discount,
Description = model.Description
};
using (var context = new WebShopMVCContext())
{
context.Products.Add(product);
context.SaveChanges();
}
}
public void ClearCart()
{
var list = new List<CartItem>();
using (var context = new WebShopMVCContext())
{
list = context.CartItems.Select(m => new CartItem
{
CartItemId = m.CartItemId,
ClientId = m.ClientId,
Client = m.Client,
ProductId = m.ProductId,
Product = m.Product,
Quantity = m.Quantity
}).ToList();
context.CartItems.RemoveRange(list);
context.SaveChanges();
}
}
public IEnumerable<CompositeCategoryViewModel> GetAllWithSubcategory()
{
using (var context = new WebShopMVCContext())
{
//context.Database.Log = message => Trace.Write(message);
return context.Categories.Select(c => new CompositeCategoryViewModel
{
CategoryId = c.CategoryId,
CategoryName = c.CategoryName,
Subcategories = context.Subcategories.Where(s => s.CategoryId == c.CategoryId).Select(s => new SubcategoryViewModel
{
SubcategoryId = s.SubcategoryId,
SubcategoryName = s.SubcategoryName
})
}).ToList();
}
}
public void Create(ClientViewModel model)
{
Client client = new Client
{
FirstName = model.FirstName,
LastName = model.LastName,
Login = model.Login,
Password = model.Password, //.GetHashCode().ToString(),
Email = model.Email,
Phone = model.Phone
};
using (var context = new WebShopMVCContext())
{
context.Clients.Add(client);
context.SaveChanges();
}
}
public ClientViewModel GetModelById(int id)
{
ClientViewModel model;
using (var context = new WebShopMVCContext())
{
model = context.Clients.Where(m => m.UserId == id)
.Select(m => new ClientViewModel
{
UserId = m.UserId,
Login = m.Login,
Email = m.Email,
FirstName = m.FirstName,
LastName = m.LastName,
Phone = m.Phone,
RowVersion = m.RowVersion
}).SingleOrDefault();
}
return model;
}
public CompositeSubcategoryViewModel GetModelById(int id)
{
CompositeSubcategoryViewModel model;
using (var context = new WebShopMVCContext())
{
var subcategory = context.Subcategories.Find(id);
model = new CompositeSubcategoryViewModel
{
CategoryId = subcategory.CategoryId,
SubcategoryId = subcategory.SubcategoryId,
SubcategoryName = subcategory.SubcategoryName,
Categories = context.Categories.Select(c => new CategoryViewModel
{ CategoryName = c.CategoryName, CategoryId = c.CategoryId }).ToList()
};
}
return model;
}
public ClientViewModel GetClientByLoginAndPassword(string login, string password)
{
ClientViewModel model;
using (var context = new WebShopMVCContext())
{
model = context.Clients.Where(m => m.Login == login && m.Password == password)
.Select(m => new ClientViewModel
{
UserId = m.UserId,
Login = m.Login,
Email = m.Email,
FirstName = m.FirstName,
LastName = m.LastName,
Phone = m.Phone,
RowVersion = m.RowVersion
}).SingleOrDefault();
}
return model;
}
public EmployeeViewModel GetEmployeeById(int id)
{
EmployeeViewModel model = new EmployeeViewModel();
using (var context = new WebShopMVCContext())
{
var employee = context.Employees.Find(id);
model.UserId = id;
employee.FirstName = model.FirstName;
model.LastName = employee.LastName;
model.Address = employee.Address;
model.Email = employee.Email;
model.Phone = employee.Phone;
model.Login = employee.Login;
model.Password = employee.Password;
model.Role = employee.Role;
model.IsBlocked = employee.IsBlocked;
model.IsDelete = employee.IsDelete;
model.RowVersion = employee.RowVersion;
}
return model;
}
public void Create(EmployeeViewModel model)
{
Employee employee = new Employee
{
FirstName = model.FirstName,
LastName = model.LastName,
Login = model.Login,
Password = model.Password,
Address = model.Address,
Email = model.Email,
Phone = model.Phone,
Role = model.Role,
IsBlocked = model.IsBlocked,
IsDelete = model.IsDelete,
RowVersion = model.RowVersion
};
using (var context = new WebShopMVCContext())
{
context.Employees.Add(employee);
context.SaveChanges();
}
}
public IEnumerable<EmployeeViewModel> GetAllEmployee()
{
var model = new List<EmployeeViewModel>();
using (var context = new WebShopMVCContext())
{
model = context.Employees.Select(m => new EmployeeViewModel
{
UserId = m.UserId,
FirstName = m.FirstName,
LastName = m.LastName,
Address = m.Address,
Email = m.Email,
Phone = m.Phone,
Login = m.Login,
Password = m.Password,
Role = m.Role,
IsBlocked = m.IsBlocked,
IsDelete = m.IsDelete,
RowVersion = m.RowVersion
}).ToList();
}
return model;
}
public IEnumerable<CartItemViewModel> GetAllCartItem()
{
var list = new List<CartItemViewModel>();
using (var context = new WebShopMVCContext())
{
list = context.CartItems.Select(m => new CartItemViewModel
{
CartItemId = m.CartItemId,
ClientId = m.ClientId,
ProductId = m.ProductId,
Product = context.Products.Select(p => new ProductViewModel//??
{
ProductId = p.ProductId,
ProductName = p.ProductName,
SubcategoryId = p.SubcategoryId,
Price = p.Price,
Discount = p.Discount,
Description = p.Description,
}).Where(p => p.ProductId == m.ProductId).SingleOrDefault(),
Quantity = m.Quantity
}).ToList();
}
return list;
}
public ProductViewModel GetNewProductViewModelWithSubcategory()
{
ProductViewModel model = new ProductViewModel();
using (var context = new WebShopMVCContext())
{
model.Subcategories = context.Subcategories.Select(c => new PartViewSubcategoriesForProduct
{
SubcategoryName = c.SubcategoryName,
SubcategoryId = c.SubcategoryId
}).ToList();
}
return model;
}
