public int GetPhoneId(Phone phone)
{
using (PhoneStoreContext context = new PhoneStoreContext())
{
return(context.Phones.FirstOrDefault(e => e.Model == phone.Model).PhoneId);
}
}
public bool IsAlreadyRegister(User user)
{
using (PhoneStoreContext context = new PhoneStoreContext())
{
return(context.Users.SingleOrDefault(e => e.Email == user.Email) == null);
}
}
public User GetUserByCookies(string cookie)
{
using (PhoneStoreContext context = new PhoneStoreContext())
{
UserEntity userEntity = context.Users.FirstOrDefault(e => e.Cookie == cookie);
return(userEntity != null?userEntity.ConvertToApplicationModel() : null);
}
}
public User GetUser(Login login)
{
using (PhoneStoreContext context = new PhoneStoreContext())
{
UserEntity userEntity = context.Users.FirstOrDefault(e => e.Email == login.Email && e.Password == login.Password);
return(userEntity != null?userEntity.ConvertToApplicationModel() : null);
}
}
public void Add(User user)
{
using (PhoneStoreContext context = new PhoneStoreContext())
{
UserEntity userEntity = (UserEntity) new UserEntity().FromApplicationModel(user);
context.Users.Add(userEntity);
context.SaveChanges();
}
}
public IEnumerable <Phone> GetAllPhones()
{
using (PhoneStoreContext context = new PhoneStoreContext())
{
IEnumerable <PhoneEntity> listPhonesEntity = context.Phones.Include("Images");
return(listPhonesEntity.Count() == 0 ? null : listPhonesEntity.Select(e => e.ConvertToApplicationModel()).ToList());
}
}
public void Add(Phone phone)
{
using (PhoneStoreContext context = new PhoneStoreContext())
{
PhoneEntity phoneEntity = (PhoneEntity) new PhoneEntity().FromApplicationModel(phone);
context.Phones.Add(phoneEntity);
context.SaveChanges();
}
}
public void Add(ApplicationImage image)
{
using (PhoneStoreContext context = new PhoneStoreContext())
{
ImageEntity imageEntity = (ImageEntity) new ImageEntity().FromApplicationModel(image);
context.Images.Add(imageEntity);
context.SaveChanges();
}
}
public void UpdateCookies(User user, string cookie)
{
using (PhoneStoreContext context = new PhoneStoreContext())
{
UserEntity userResult = context.Users.SingleOrDefault(e => e.Cookie == user.Cookie);
if (userResult != null)
{
userResult.Cookie = cookie;
context.SaveChanges();
}
}
}
public void UpdateIsActive(User user, bool value)
{
using (PhoneStoreContext context = new PhoneStoreContext())
{
UserEntity userResult = context.Users.SingleOrDefault(e => e.Cookie == user.Cookie);
if (userResult != null)
{
userResult.IsActive = value;
context.SaveChanges();
}
}
}
public PhonesController(PhoneStoreContext context)
{
_context = context;
}
public CommentsController(PhoneStoreContext context)
{
_context = context;
}
public MemoriesController(PhoneStoreContext context)
{
_context = context;
}
public OrdersController(PhoneStoreContext context)
{
_context = context;
}
