public IEnumerable <ProductViewModel> GetProducts()
{
IEnumerable <ProductViewModel> lpvm;
using (_dbContext = new AxaTestEntities())
{
var lp = _dbContext.Products.ToList();
lpvm = _mapper.Map <List <Product>, List <ProductViewModel> >(lp);
}
return(lpvm);
}
public LoggedUserViewModel Login(string email, string pass)
{
LoggedUserViewModel luvm = new LoggedUserViewModel();
using (_dbContext = new AxaTestEntities())
{
var user = (from us in _dbContext.Users
where us.Email.Equals(email) && us.Password.Equals(pass)
select us).FirstOrDefault();
luvm = _mapper.Map <User, LoggedUserViewModel>(user);
}
return(luvm);
}
public bool Delete(ProductViewModel pvm)
{
var result = 0;
//var prod = _mapper.Map<ProductViewModel, Product>(pvm);
//prod.Categories = null;
using (_dbContext = new AxaTestEntities())
{
var productIdParameter = new SqlParameter("@ProductId", pvm.IdProduct);
result = _dbContext.Database
.ExecuteSqlCommand("exec dbo.DeleteProductbyId @ProductId", productIdParameter);
}
return(result > 0 ? true : false);
}
public ProductViewModel Create(ProductViewModel pvm)
{
var result = 0;
pvm.State = pvm.State.Equals("Available") ? "true" : "false";
var prod = _mapper.Map <ProductViewModel, Product>(pvm);
prod.CreationDate = DateTime.Now;
using (_dbContext = new AxaTestEntities())
{
_dbContext.Products.Add(prod);
result = _dbContext.SaveChanges();
}
return(result > 0 ? pvm : null);
}
public ProductViewModel Update(ProductViewModel pvm)
{
var s = 0;
using (_dbContext = new AxaTestEntities())
{
var result = _dbContext.Products.SingleOrDefault(p => p.IdProduct == pvm.IdProduct);
if (result != null)
{
result.Name = pvm.Name;
result.Description = pvm.Description;
result.Quantity = Convert.ToByte(pvm.Quantity);
result.State = pvm.State.Equals("Available") ? true : false;
result.UnitPrice = pvm.Price;
s = _dbContext.SaveChanges();
}
}
return(s > 0 ? pvm : null);
}
public LoggedUserViewModel Register(RegisterViewModel rvm)
{
LoggedUserViewModel luvm = new LoggedUserViewModel();
var user = _mapper.Map <RegisterViewModel, User>(rvm);
user.CreationDate = DateTime.Now;
user.State = true;
using (_dbContext = new AxaTestEntities())
{
_dbContext.Users.Add(user);
_dbContext.SaveChanges();
if (user.IdUser != 0)
{
var u = _dbContext.Users.Where(x => x.IdUser == user.IdUser).FirstOrDefault();
luvm = _mapper.Map <User, LoggedUserViewModel>(u);
}
else
{
luvm = null;
}
}
return(luvm);
}
