示例#1
0
        public async Task <SaleViewModel> GetSale(int id)
        {
            var sale = await _context.Sales
                       .Include(u => u.User)
                       .Include(c => c.Client)
                       .FirstOrDefaultAsync(v => v.IdSale == id);

            if (sale == null)
            {
                return(null);
            }

            return(new SaleViewModel
            {
                IdSale = sale.IdSale,
                IdUser = sale.IdUser,
                UserName = sale.User.UserName,
                IdClient = sale.IdClient,
                ClientName = sale.Client.Name + " " + sale.Client.LastName,
                TypeSale = sale.TypeSale,
                VoucherSeries = sale.VoucherSeries,
                VoucherNumber = sale.VoucherNumber,
                SaleDate = _context.Entry(sale).Property <DateTime>("DateOn").CurrentValue.Date,
                SaleDateUpdate = _context.Entry(sale).Property <DateTime>("LastUpdated").CurrentValue.Date,
                TotalPrice = sale.TotalPrice,
                State = sale.State
            });
        }
示例#2
0
        public async Task <UserViewModel> GetUser(int id)
        {
            var user = await _context.Users.FindAsync(id);

            if (user == null)
            {
                return(null);
            }

            return(new UserViewModel
            {
                IdUser = user.IdUser,
                IdRole = user.IdRole,
                UserName = user.UserName,
                DocumentType = user.DocumentType,
                DocumentNumber = user.DocumentNumber,
                Address = user.Address,
                PhoneNumber = user.PhoneNumber,
                CreatedDate = _context.Entry(user).Property <DateTime>("DateOn").CurrentValue,
                Email = user.Email,
                PasswordHash = user.PasswordHash,
                PasswordSalt = user.PasswordSalt,
                Condition = user.Condition,
            });
        }
示例#3
0
        public async Task <LossesViewModel> GetLoss(int id)
        {
            var loss = await _context.Losses.FindAsync(id);

            if (loss == null)
            {
                return(null);
            }

            return(new LossesViewModel
            {
                IdLosses = loss.IdLosses,
                DateLoss = _context.Entry(loss).Property <DateTime>("DateOn").CurrentValue,
                Cause = loss.Cause,
                State = loss.State
            });
        }
示例#4
0
        public async Task <DeliveryViewModel> GetDelivery(int id)
        {
            var delivery = await _context.Deliveries.FindAsync(id);

            if (delivery == null)
            {
                return(null);
            }

            return(new DeliveryViewModel
            {
                IdSale = delivery.IdSale,
                IdClient = delivery.IdClient,
                Adress = delivery.Adress,
                Date = _context.Entry(delivery).Property <DateTime>("DateOn").CurrentValue,
                State = delivery.State
            });
        }
示例#5
0
        public async Task <OrderViewModel> GetOrderIncome(int id)
        {
            var order = await _context.OrderIncomes.FindAsync(id);

            if (order == null)
            {
                return(null);
            }

            return(new OrderViewModel
            {
                IdOrderIncome = order.IdOrderIncome,
                IdProvider = order.IdProvider,
                Proveedor = order.Provider.ProviderName,
                IdUser = order.IdUser,
                User = order.User.UserName,
                DateEntry = _context.Entry(order).Property <DateTime>("DateOn").CurrentValue,
                Total = order.Total,
                State = order.State
            });
        }