public ICollection <CashFoundDto> GetCashFounds(int cashRegisterId, out string message) { try { using (PosRiContext dbContext = new PosRiContext()) { message = string.Empty; var cashFounds = dbContext.CashFounds.Where(c => c.CashRegisterId == cashRegisterId).ToList(); var cashFoundsDto = new List <CashFoundDto>(); foreach (var cashFound in cashFounds) { cashFoundsDto.Add(new CashFoundDto(cashFound)); } return(cashFoundsDto); } } catch (Exception e) { message = e.Message; return(null); } }
public CashFoundDto SaveCashFound(CashFoundDto cashFoundDto, out string message) { try { using (PosRiContext dbContext = new PosRiContext()) { message = string.Empty; CashFound cashFound = new CashFound { UserId = cashFoundDto.User.Id, CashRegisterId = cashFoundDto.CashRegister.Id, Quantity = cashFoundDto.Quantity, RegisterDate = DateTime.Now }; dbContext.Entry(cashFound).State = EntityState.Added; dbContext.CashFounds.Add(cashFound); if (dbContext.SaveChanges() > 0) { cashFoundDto.Id = cashFound.Id; return(cashFoundDto); } message = "No se pudo agregar el fondo de caja."; return(null); } } catch (Exception e) { message = $"No se pudo agregar el fondo de caja. {e.Message}"; return(null); } }
public CashFoundDto GetCashFound(int cashRegisterId, out string message) { try { using (PosRiContext dbContext = new PosRiContext()) { message = string.Empty; var cashfound = dbContext.CashFounds.LastOrDefault(c => c.CashRegisterId == cashRegisterId); if (cashfound != null) { var cashFoundDto = new CashFoundDto(cashfound); return(cashFoundDto); } return(new CashFoundDto()); } } catch (Exception e) { Console.WriteLine(e); throw; } }
public bool DeleteCashRegister(CashRegisterDto cashRegisterDto, out string message) { try { using (PosRiContext dbContext = new PosRiContext()) { var cashRegister = dbContext.CashRegisters.Find(cashRegisterDto.Id); if (cashRegister == null) { message = "Caja no encontrada."; return(false); } cashRegister.IsActive = false; dbContext.Entry(cashRegister).State = EntityState.Modified; if (dbContext.SaveChanges() > 0) { message = ""; return(true); } message = "No se pudo eliminar la caja."; return(false); } } catch (Exception e) { message = e.Message; return(false); } }
public BrandDto UpdateBrand(BrandDto brandDto, out string message) { try { using (PosRiContext dbContext = new PosRiContext()) { message = ""; var brand = dbContext.Brands.Find(brandDto.Id); if (brand == null) { message = "Marca no encontrada."; return(null); } brand.Name = brandDto.Name; dbContext.Entry(brand).State = EntityState.Modified; if (dbContext.SaveChanges() > 0) { return(brandDto); } message = "No se pudo actualizar la marca."; return(null); } } catch (Exception e) { message = e.Message; return(null); } }
public CashRegisterDto UpdateCashRegister(CashRegisterDto cashRegisterDto, out string message) { try { using (PosRiContext dbContext = new PosRiContext()) { message = ""; var cashRegister = dbContext.CashRegisters.Find(cashRegisterDto.Id); if (cashRegister == null) { message = "Caja no encontrada."; return(null); } cashRegister.Name = cashRegisterDto.Name; dbContext.Entry(cashRegister).State = EntityState.Modified; if (dbContext.SaveChanges() > 0) { return(cashRegisterDto); } message = "No se pudo actualizar la caja."; return(null); } } catch (Exception e) { message = e.Message; return(null); } }
public BrandDto AddBrand(BrandDto brandDto, out string message) { try { using (PosRiContext dbContext = new PosRiContext()) { message = ""; Brand brand = new Brand { Name = brandDto.Name, IsActive = true }; dbContext.Entry(brand).State = EntityState.Added; dbContext.Brands.Add(brand); if (dbContext.SaveChanges() > 0) { brandDto.Id = brand.Id; return(brandDto); } message = "No se pudo agregar la marca."; return(null); } } catch (Exception e) { message = e.Message; return(null); } }
public bool DeleteBrand(BrandDto brandDto, out string message) { try { using (PosRiContext dbContext = new PosRiContext()) { var brand = dbContext.Brands.Find(brandDto.Id); if (brand == null) { message = "Marca no encontrada."; return(false); } brand.IsActive = false; dbContext.Entry(brand).State = EntityState.Modified; if (dbContext.SaveChanges() > 0) { message = ""; return(true); } message = "No se pudo eliminar la marca."; return(false); } } catch (Exception e) { message = e.Message; return(false); } }
public bool DeleteUser(UserDto userDto, out string message) { try { using (PosRiContext dbContext = new PosRiContext()) { var user = dbContext.Users.Find(userDto.Id); if (user == null) { message = "Usuario no encontrado."; return(false); } user.IsActive = false; user.Roles.Clear(); dbContext.Entry(user).State = EntityState.Modified; if (dbContext.SaveChanges() > 0) { message = ""; return(true); } message = "No se pudo eliminar el usario."; return(false); } } catch (Exception e) { message = e.Message; return(false); } }
public bool DeleteVendor(VendorDto vendorDto, out string message) { try { using (PosRiContext dbContext = new PosRiContext()) { var vendor = dbContext.Vendors.Find(vendorDto.Id); if (vendor == null) { message = "Proveedor no encontrado."; return(false); } vendor.IsActive = false; dbContext.Entry(vendor).State = EntityState.Modified; if (dbContext.SaveChanges() > 0) { message = ""; return(true); } message = "No se pudo eliminar el proveedor."; return(false); } } catch (Exception e) { message = $"No se pudo eliminar el proveedor. {e.Message}"; return(false); } }
public StoreDto AddStore(StoreDto storeDto, out string message) { try { using (PosRiContext dbContext = new PosRiContext()) { message = ""; Store store = new Store { Name = storeDto.Name, Address = storeDto.Address, Phone = storeDto.Phone, IsActive = true }; dbContext.Entry(store).State = EntityState.Added; dbContext.Stores.Add(store); if (dbContext.SaveChanges() > 0) { storeDto.Id = store.Id; return(storeDto); } message = "No se pudo agregar la sucursal."; return(null); } } catch (Exception e) { message = e.Message; return(null); } }
public bool DeleteCustomer(CustomerDto customerDto, out string message) { try { using (PosRiContext dbContext = new PosRiContext()) { var customer = dbContext.Customers.Find(customerDto.Id); if (customer == null) { message = "Cliente no encontrado."; return(false); } customer.IsActive = false; dbContext.Entry(customer).State = EntityState.Modified; if (dbContext.SaveChanges() > 0) { message = ""; return(true); } message = "No se pudo eliminar el cliente."; return(false); } } catch (Exception e) { message = $"No se pudo eliminar el cliente. {e.Message}"; return(false); } }
public IEnumerable <BrandDto> GetBrands() { using (PosRiContext dbContext = new PosRiContext()) { var brands = dbContext.Brands.Where(u => u.IsActive).ToList(); var brandsDto = new List <BrandDto>(); foreach (var brand in brands) { brandsDto.Add(new BrandDto(brand)); } return(brandsDto); } }
public IEnumerable <CashRegisterDto> GetCashRegisters() { using (PosRiContext dbContext = new PosRiContext()) { var cashRegisters = dbContext.CashRegisters.Where(u => u.IsActive).ToList(); var cashRegistersDto = new List <CashRegisterDto>(); foreach (var cashRegister in cashRegisters) { cashRegistersDto.Add(new CashRegisterDto(cashRegister)); } return(cashRegistersDto); } }
public IEnumerable <UserDto> GetUsers() { using (PosRiContext dbContext = new PosRiContext()) { var users = dbContext.Users.Where(u => u.IsActive).ToList(); var usersDto = new List <UserDto>(); foreach (var user in users) { usersDto.Add(new UserDto(user)); } return(usersDto); } }
public IEnumerable <StoreDto> GetStores() { using (PosRiContext dbContext = new PosRiContext()) { var stores = dbContext.Stores.Where(u => u.IsActive).ToList(); var storesDto = new List <StoreDto>(); foreach (var store in stores) { storesDto.Add(new StoreDto(store)); } return(storesDto); } }
public UserDto UpdateUser(UserDto userDto, out string message) { try { using (PosRiContext dbContext = new PosRiContext()) { message = ""; var user = dbContext.Users.Find(userDto.Id); if (user == null) { message = "Usuario no encontrado."; return(null); } List <int> rolesId = userDto.Roles.Select(r => r.Id).ToList(); var roles = dbContext.Roles.Where(r => rolesId.Contains(r.Id)).ToList(); user.Roles.Clear(); user.Roles = roles; user.Name = userDto.Name; user.Username = userDto.Username; user.Birthday = userDto.Birthday; user.HireDate = userDto.HireDate; if (!string.IsNullOrEmpty(userDto.Password)) { user.Password = userDto.Password; } dbContext.Entry(user).State = EntityState.Modified; if (dbContext.SaveChanges() > 0) { return(userDto); } message = "No se pudo actualizar el usuario."; return(null); } } catch (Exception e) { message = e.Message; return(null); } }
public VendorDto UpdateVendor(VendorDto vendorDto, out string message) { try { using (PosRiContext dbContext = new PosRiContext()) { message = ""; var vendor = dbContext.Vendors.Find(vendorDto.Id); if (vendor == null) { message = "Proveedor no encontrado."; return(null); } vendor.Brands.Clear(); var idBrands = vendorDto.Brands.Select(b => b.Id).ToList(); var brands = dbContext.Brands.Where(b => idBrands.Contains(b.Id)).ToList(); vendor.Name = vendorDto.Name; vendor.Address = vendorDto.Address; vendor.City = vendorDto.City; vendor.Email = vendorDto.Email; vendor.Phone = vendorDto.Phone; vendor.Rfc = vendorDto.Rfc; vendor.StateId = vendorDto.State.Id; vendor.Brands = brands; dbContext.Entry(vendor).State = EntityState.Modified; if (dbContext.SaveChanges() > 0) { return(vendorDto); } message = "No se pudo actualizar el proveedor."; return(null); } } catch (Exception e) { message = $"No se pudo actualizar el proveedor. {e.Message}"; return(null); } }
public VendorDto AddVendor(VendorDto vendorDto, out string message) { try { using (PosRiContext dbContext = new PosRiContext()) { message = ""; var idBrands = vendorDto.Brands.Select(b => b.Id).ToList(); var brands = dbContext.Brands.Where(b => idBrands.Contains(b.Id)).ToList(); Vendor vendor = new Vendor { Name = vendorDto.Name, Address = vendorDto.Address, City = vendorDto.City, CreationDate = DateTime.Now, Phone = vendorDto.Phone, Email = vendorDto.Email, Rfc = vendorDto.Email, IsActive = true, StateId = vendorDto.State.Id, Brands = brands }; dbContext.Entry(vendor).State = EntityState.Added; dbContext.Vendors.Add(vendor); if (dbContext.SaveChanges() > 0) { vendorDto.Id = vendor.Id; return(vendorDto); } message = "No se pudo agregar el proveedor."; return(null); } } catch (Exception e) { message = $"No se pudo agregar el proveedor. {e.Message}"; return(null); } }
public bool IsValid(MethodTypes httpMethod, StoreDto storeDto, out string message) { message = ""; switch (httpMethod) { case MethodTypes.Post: { using (PosRiContext dbContext = new PosRiContext()) { if (dbContext.Stores.Any(u => u.IsActive && u.Name.Equals(storeDto.Name, StringComparison.CurrentCultureIgnoreCase))) { message = $"Ya existe una sucursal llamada {storeDto.Name}."; return(false); } } break; } case MethodTypes.Put: { using (PosRiContext dbContext = new PosRiContext()) { var store = dbContext.Stores.Find(storeDto.Id); if (store == null) { message = "Sucursal no encontrada."; return(false); } if (dbContext.Stores.Any(u => u.IsActive && u.Id != storeDto.Id && u.Name.Equals(storeDto.Name, StringComparison.CurrentCultureIgnoreCase))) { message = $"Ya existe una sucursal llamada {storeDto.Name}."; return(false); } } break; } } return(true); }
public bool IsValid(MethodTypes httpMethod, BrandDto brandDto, out string message) { message = ""; switch (httpMethod) { case MethodTypes.Post: { using (PosRiContext dbContext = new PosRiContext()) { if (dbContext.Brands.Any(u => u.IsActive && u.Name.Equals(brandDto.Name, StringComparison.CurrentCultureIgnoreCase))) { message = $"Ya existe una marca llamada {brandDto.Name}."; return(false); } } break; } case MethodTypes.Put: { using (PosRiContext dbContext = new PosRiContext()) { var brand = dbContext.Brands.Find(brandDto.Id); if (brand == null) { message = "Marca no encontrada."; return(false); } if (dbContext.Brands.Any(u => u.IsActive && u.Id != brandDto.Id && u.Name.Equals(brandDto.Name, StringComparison.CurrentCultureIgnoreCase))) { message = $"Ya existe una marca llamada {brandDto.Name}."; return(false); } } break; } } return(true); }
public bool IsValid(MethodTypes httpMethod, VendorDto vendorDto, out string message) { message = ""; switch (httpMethod) { case MethodTypes.Post: { using (PosRiContext dbContext = new PosRiContext()) { if (dbContext.Vendors.Any(u => u.IsActive && u.Name.Equals(vendorDto.Name, StringComparison.CurrentCultureIgnoreCase))) { message = $"Ya existe un provedeor con el nombre {vendorDto.Name}."; return(false); } } break; } case MethodTypes.Put: { using (PosRiContext dbContext = new PosRiContext()) { var vendor = dbContext.Vendors.Find(vendorDto.Id); if (vendor == null) { message = "Proveedor no encontrado."; return(false); } if (dbContext.Vendors.Any(u => u.IsActive && u.Id != vendorDto.Id && u.Name.Equals(vendorDto.Name, StringComparison.CurrentCultureIgnoreCase))) { message = $"Ya existe un proveedor con el nombre {vendorDto.Name}."; return(false); } } break; } } return(true); }
public bool IsValid(MethodTypes httpMethod, CashRegisterDto cashRegisterDto, out string message) { message = ""; switch (httpMethod) { case MethodTypes.Post: { using (PosRiContext dbContext = new PosRiContext()) { if (dbContext.CashRegisters.Any(u => u.IsActive && u.Name.Equals(cashRegisterDto.Name, StringComparison.CurrentCultureIgnoreCase) && u.StoreId == cashRegisterDto.Store.Id)) { message = $"Ya existe una caja llamada {cashRegisterDto.Name}."; return(false); } } break; } case MethodTypes.Put: { using (PosRiContext dbContext = new PosRiContext()) { var cashRegister = dbContext.CashRegisters.Find(cashRegisterDto.Id); if (cashRegister == null) { message = "Caja no encontrada."; return(false); } if (dbContext.CashRegisters.Any(u => u.IsActive && u.Id != cashRegisterDto.Id && u.Name.Equals(cashRegisterDto.Name, StringComparison.CurrentCultureIgnoreCase) && u.StoreId == cashRegisterDto.Store.Id)) { message = $"Ya existe una caja llamada {cashRegisterDto.Name}."; return(false); } } break; } } return(true); }
public bool IsValid(MethodTypes httpMethod, CustomerDto customerDto, out string message) { message = ""; switch (httpMethod) { case MethodTypes.Post: { using (PosRiContext dbContext = new PosRiContext()) { if (dbContext.Customers.Any(u => u.IsActive && u.Name.Equals(customerDto.Name, StringComparison.CurrentCultureIgnoreCase))) { message = $"Ya existe un cliente con el nombre {customerDto.Name}."; return(false); } } break; } case MethodTypes.Put: { using (PosRiContext dbContext = new PosRiContext()) { var customer = dbContext.Customers.Find(customerDto.Id); if (customer == null) { message = "Cliente no encontrado."; return(false); } if (dbContext.Customers.Any(u => u.IsActive && u.Id != customerDto.Id && u.Name.Equals(customerDto.Name, StringComparison.CurrentCultureIgnoreCase))) { message = $"Ya existe un cliente con el nombre {customerDto.Name}."; return(false); } } break; } } return(true); }
public CashRegisterDto AddCashRegister(CashRegisterDto cashRegisterDto, out string message) { try { using (PosRiContext dbContext = new PosRiContext()) { message = string.Empty; CashRegister cashRegister = new CashRegister { Name = cashRegisterDto.Name, IsActive = true }; CashFound cashFound = new CashFound { CashRegister = cashRegister, Quantity = 0, RegisterDate = DateTime.Now, //UserId = cashRegisterDto.User.Id }; dbContext.Entry(cashRegister).State = EntityState.Added; dbContext.Entry(cashFound).State = EntityState.Added; dbContext.CashRegisters.Add(cashRegister); dbContext.CashFounds.Add(cashFound); if (dbContext.SaveChanges() > 0) { cashRegisterDto.Id = cashRegister.Id; return(cashRegisterDto); } message = "No se pudo agregar la caja."; return(null); } } catch (Exception e) { message = $"No se pudo agregar la caja. {e.Message}"; return(null); } }
public IEnumerable <CustomerDto> GetCustomers() { using (PosRiContext dbContext = new PosRiContext()) { var customers = dbContext.Customers .Where(u => u.IsActive) .Include(u => u.State) .ToList(); var customersDto = new List <CustomerDto>(); foreach (var customer in customers) { customersDto.Add(new CustomerDto(customer)); } return(customersDto); } }
public IEnumerable <VendorDto> GetVendors() { using (PosRiContext dbContext = new PosRiContext()) { var vendors = dbContext.Vendors .Where(u => u.IsActive) .Include(u => u.State) .Include(v => v.Brands) .ToList(); var vendorsDto = new List <VendorDto>(); foreach (var vendor in vendors) { vendorsDto.Add(new VendorDto(vendor)); } return(vendorsDto); } }
public UserDto AddUser(UserDto userDto, out string message) { try { using (PosRiContext dbContext = new PosRiContext()) { message = ""; List <int> rolesId = userDto.Roles.Select(r => r.Id).ToList(); var roles = dbContext.Roles.Where(r => rolesId.Contains(r.Id)).ToList(); User user = new User { Name = userDto.Name, Password = userDto.Password, Username = userDto.Username, Birthday = userDto.Birthday, HireDate = userDto.HireDate, Roles = roles, IsActive = true }; dbContext.Entry(user).State = EntityState.Added; dbContext.Users.Add(user); if (dbContext.SaveChanges() > 0) { userDto.Id = user.Id; userDto.Password = string.Empty; return(userDto); } message = "No se pudo agregar el usuario."; return(null); } } catch (Exception e) { message = e.Message; return(null); } }
public CustomerDto AddCustomer(CustomerDto customerDto, out string message) { try { using (PosRiContext dbContext = new PosRiContext()) { message = ""; Customer customer = new Customer { Name = customerDto.Name, Address = customerDto.Address, City = customerDto.City, CreationDate = DateTime.Now, Phone = customerDto.Phone, Email = customerDto.Email, Rfc = customerDto.Email, IsActive = true, StateId = customerDto.State.Id }; dbContext.Entry(customer).State = EntityState.Added; dbContext.Customers.Add(customer); if (dbContext.SaveChanges() > 0) { customerDto.Id = customer.Id; return(customerDto); } message = "No se pudo agregar el cliente."; return(null); } } catch (Exception e) { message = $"No se pudo agregar el cliente. {e.Message}"; return(null); } }
public CustomerDto UpdateCustomer(CustomerDto customerDto, out string message) { try { using (PosRiContext dbContext = new PosRiContext()) { message = ""; var customer = dbContext.Customers.Find(customerDto.Id); if (customer == null) { message = "Cliente no encontrado."; return(null); } customer.Name = customerDto.Name; customer.Address = customerDto.Address; customer.City = customerDto.City; customer.Email = customerDto.Email; customer.Phone = customerDto.Phone; customer.Rfc = customerDto.Rfc; customer.StateId = customerDto.State.Id; dbContext.Entry(customer).State = EntityState.Modified; if (dbContext.SaveChanges() > 0) { return(customerDto); } message = "No se pudo actualizar el cliente."; return(null); } } catch (Exception e) { message = $"No se pudo actualizar el cliente. {e.Message}"; return(null); } }