public async Task <ApiResult <PagedResult <CustomersDto> > > GetCustomersPagingAsync(int pageIndex, int pageSize) { var customers = await(from c in _context.Customers join employee in _context.Employees on c.EmployeeId equals employee.Id into EmployeeGroup from e in EmployeeGroup.DefaultIfEmpty() join appuser in _context.AppUsers on c.AppUserId equals appuser.Id into AppUserGroup from au in AppUserGroup.DefaultIfEmpty() where c.IsDelete == false select new CustomersDto() { Id = c.Id, Name = c.Name, EmployeeName = e.Name, PhoneNumber = c.PhoneNumber, UserName = au.UserName }).GetPagedAsync(pageIndex, pageSize); if (customers == null) { return(new ApiResult <PagedResult <CustomersDto> >(HttpStatusCode.NoContent)); } return(new ApiResult <PagedResult <CustomersDto> >(HttpStatusCode.OK, customers)); }
public async Task <ApiResult <EmployeeDto> > GetEmployeeAsync(string employeeId) { var employee = await(from e in _context.Employees join appuser in _context.AppUsers on e.AppuserId equals appuser.Id into AppUserGroup from au in AppUserGroup.DefaultIfEmpty() join branch in _context.Branches on e.BranchId equals branch.Id into BranchsGroup from b in BranchsGroup.DefaultIfEmpty() join department in _context.Departments on e.DepartmentId equals department.Id into DepartmentsGroup from d in DepartmentsGroup.DefaultIfEmpty() where e.Id == employeeId select new EmployeeDto() { Id = e.Id, Address = e.Address, Description = e.Description, Dob = e.Dob, Gender = e.Gender, Name = e.Name, PhoneNumber = e.PhoneNumber, UserName = au.UserName, IsDelete = e.IsDelete, DepartmentName = d.Name, BranchName = b.Name }).SingleOrDefaultAsync(); if (employee == null) { return(new ApiResult <EmployeeDto>(HttpStatusCode.NotFound, $"Không tìm thấy nhân viên có mã: {employeeId}")); } return(new ApiResult <EmployeeDto>(HttpStatusCode.OK, employee)); }
public async Task <ApiResult <IEnumerable <CustomerDto> > > SearchCustomerAsync(string customerName) { var customers = await(from c in _context.Customers join employee in _context.Employees on c.EmployeeId equals employee.Id into EmployeeGroup from e in EmployeeGroup.DefaultIfEmpty() join appuser in _context.AppUsers on c.AppUserId equals appuser.Id into AppUserGroup from au in AppUserGroup.DefaultIfEmpty() join customertype in _context.CustomerTypes on c.CustomerTypeId equals customertype.Id into CustomerTypeGroup from ct in CustomerTypeGroup.DefaultIfEmpty() let customerDebt = (_context.Orders.Where(x => x.CustomerId == c.Id && x.TransactionStatusId != GlobalProperties.CancelTransactionId && x.TransactionStatusId != GlobalProperties.WaitingTransactionId) .Sum(x => (decimal?)x.TotalAmount) ?? 0) + (_context.PaymentVouchers.Where(x => x.CustomerId == c.Id) .Sum(x => (decimal?)x.Paid) ?? 0) - (_context.ReceiptVouchers.Where(x => x.CustomerId == c.Id) .Sum(x => (decimal?)x.Received) ?? 0) where c.Name.ToLower().Contains(customerName.ToLower()) && c.IsDelete == false select new CustomerDto() { Address = c.Address, Description = c.Description, Dob = c.Dob, Fax = c.Fax, Gender = c.Gender, Id = c.Id, Name = c.Name, Website = c.Website, EmployeeName = e.Name, IsDelete = c.IsDelete, UserName = au.UserName, PhoneNumber = c.PhoneNumber, CustomerTypeName = ct.Name, TotalDebt = customerDebt, Email = string.IsNullOrEmpty(c.Email)?au.Email:c.Email }).ToListAsync(); return(new ApiResult <IEnumerable <CustomerDto> >() { Code = HttpStatusCode.OK, ResultObj = customers }); }
public async Task <ApiResult <CustomerDto> > GetCustomerAsync(string customerId) { var totalAmountOrders = await _context.Orders.Where(x => x.CustomerId == customerId && x.TransactionStatusId != GlobalProperties.CancelTransactionId && x.TransactionStatusId != GlobalProperties.WaitingTransactionId).SumAsync(x => x.TotalAmount); var totalPaymentVouchers = await _context.PaymentVouchers.Where(x => x.CustomerId == customerId).SumAsync(x => x.Paid); var totalReceiptVouchers = await _context.ReceiptVouchers.Where(x => x.CustomerId == customerId).SumAsync(x => x.Received); var customer = await(from c in _context.Customers join employee in _context.Employees on c.EmployeeId equals employee.Id into EmployeeGroup from e in EmployeeGroup.DefaultIfEmpty() join appuser in _context.AppUsers on c.AppUserId equals appuser.Id into AppUserGroup from au in AppUserGroup.DefaultIfEmpty() join customertype in _context.CustomerTypes on c.CustomerTypeId equals customertype.Id into CustomerTypeGroup from ct in CustomerTypeGroup.DefaultIfEmpty() where c.Id == customerId && c.IsDelete == false select new CustomerDto() { Address = c.Address, Description = c.Description, Dob = c.Dob, Fax = c.Fax, Gender = c.Gender, Id = c.Id, Name = c.Name, Website = c.Website, EmployeeName = e.Name, PhoneNumber = c.PhoneNumber, IsDelete = c.IsDelete, UserName = au.UserName, CustomerTypeName = ct.Name, TotalDebt = totalAmountOrders + totalPaymentVouchers - totalReceiptVouchers }).SingleOrDefaultAsync(); if (customer == null) { return(new ApiResult <CustomerDto>(HttpStatusCode.NotFound, $"Không tìm thấy khách hàng có mã: {customerId}")); } return(new ApiResult <CustomerDto>(HttpStatusCode.OK, customer)); }
public async Task <ApiResult <ReportCustomerSupplierDebtDto> > GetAllCustomerDebtAsync(int pageIndex, int pageSize) { var customers = from c in _context.Customers join employee in _context.Employees on c.EmployeeId equals employee.Id into EmployeeGroup from e in EmployeeGroup.DefaultIfEmpty() join appuser in _context.AppUsers on c.AppUserId equals appuser.Id into AppUserGroup from au in AppUserGroup.DefaultIfEmpty() join ct in _context.CustomerTypes on c.CustomerTypeId equals ct.Id let customerDebt = (_context.Orders.Where(x => x.CustomerId == c.Id && x.TransactionStatusId != GlobalProperties.CancelTransactionId && x.TransactionStatusId != GlobalProperties.WaitingTransactionId) .Sum(x => (decimal?)x.TotalAmount) ?? 0) + (_context.PaymentVouchers.Where(x => x.CustomerId == c.Id) .Sum(x => (decimal?)x.Paid) ?? 0) - (_context.ReceiptVouchers.Where(x => x.CustomerId == c.Id) .Sum(x => (decimal?)x.Received) ?? 0) where (int)customerDebt != 0 select new CustomersSuppliersForReportDto() { Id = c.Id, Name = c.Name, PhoneNumber = c.PhoneNumber, TotalDebt = customerDebt, Address = c.Address, Email = au.Email, }; decimal totalDebt = 0; foreach (var c in await customers.ToListAsync()) { totalDebt += c.TotalDebt; } var reportCustomer = new ReportCustomerSupplierDebtDto() { Targets = await customers.GetPagedAsync(pageIndex, pageSize), TotalDebt = totalDebt }; return(new ApiResult <ReportCustomerSupplierDebtDto>(HttpStatusCode.OK, reportCustomer)); }