public RespondData FindBudgetDistributes(EvoucherBudgetDetailPagingFilterModelDTO filter)
{
filter.CompanyId = this.GetOrg();
var result = _service.FindBudgetDistributes(filter);
return(Success(result));
}
public RespondData GetEmployeeBudgetDist(EvoucherBudgetDetailPagingFilterModelDTO filter)
{
filter.CompanyId = this.GetOrg();
var result = _service.GetEmployeeBudgetDist(filter);
return(Success(result));
}
public PagingData <E_VoucherBudgetDetailDTO> GetDetails(EvoucherBudgetDetailPagingFilterModelDTO filter)
{
var query = _detailRepo.SelectWhere(x => x.VoucherBudgetId == filter.EvoucherBudgetId && x.OrgCompanyId == filter.CompanyId);
var res = query.OrderBy(x => x.Id)
.Select(x => new E_VoucherBudgetDetailDTO
{
Budget = x.Budget,
CodeUser = x.CodeUser,
NameUser = x.NameUser,
OrgCompanyId = x.OrgCompanyId,
OrgCompanyName = x.OrgCompanyName,
Status = x.Status,
StatusName = x.StatusName,
Id = x.Id,
JobTitle = x.JobTitle,
CreatedDate = x.CreatedDate,
CreatedUser = x.CreatedUser,
VoucherBudgetId = x.VoucherBudgetId
}).ToList();
// lay danh sach chi tiet voucher tung nhan vien
if (res != null && res.Count > 0)
{
foreach (var budDetail in res)
{
budDetail.DistributeLines = DistributeLines(budDetail.Id);
}
}
return(new PagingData <E_VoucherBudgetDetailDTO>()
{
PageData = res, TotalRowCount = (long)query.Count()
});
}
public PagingData <E_VoucherBudgetDetailDTO> GetDetailsPaging(EvoucherBudgetDetailPagingFilterModelDTO filter)
{
var query = _detailRepo.SelectWhere(x => x.VoucherBudgetId == filter.EvoucherBudgetId && x.OrgCompanyId == filter.CompanyId);
var res = query.OrderBy(x => x.Id).Skip(filter.Start - 1).Take(filter.Length)
.Select(x => new E_VoucherBudgetDetailDTO
{
Budget = x.Budget,
CodeUser = x.CodeUser,
NameUser = x.NameUser,
OrgCompanyId = x.OrgCompanyId,
OrgCompanyName = x.OrgCompanyName,
Status = x.Status,
StatusName = x.StatusName,
Id = x.Id,
JobTitle = x.JobTitle,
CreatedDate = x.CreatedDate,
CreatedUser = x.CreatedUser
}).ToList();
return(new PagingData <E_VoucherBudgetDetailDTO>()
{
PageData = res, TotalRowCount = (long)query.Count()
});
}
public PagingData <E_VoucherBudgetDTO> Find(EvoucherBudgetDetailPagingFilterModelDTO filter)
{
var query = _repo.SelectWhere(x =>
((x.BudgetDate.HasValue && filter.DateFrom.HasValue && DbFunctions.TruncateTime(x.BudgetDate.Value) >= DbFunctions.TruncateTime(filter.DateFrom.Value)) ||
!filter.DateFrom.HasValue
) &&
((x.BudgetDate.HasValue && filter.DateFrom.HasValue && DbFunctions.TruncateTime(x.BudgetDate.Value) <= DbFunctions.TruncateTime(filter.DateTo.Value)) ||
!filter.DateTo.HasValue
) &&
x.CompanyId == filter.CompanyId &&
((filter.Status != null && x.Status == filter.Status) || filter.Status == null)
);
var res = query.OrderBy(x => x.Id).Skip(filter.Start - 1).Take(filter.Length)
.Select(x => new E_VoucherBudgetDTO
{
Budget = x.Budget,
BudgetDate = x.BudgetDate,
CompanyId = x.CompanyId,
StaffConfirm = x.StaffConfirm,
TotalStaff = x.TotalStaff,
Status = x.Status,
StatusName = x.StatusName,
Id = x.Id,
TotalValues = x.TotalValues,
CompanyName = x.CompanyName,
CreateDate = x.CreateDate,
CreateUser = x.CreateUser
}).ToList();
return(new PagingData <E_VoucherBudgetDTO>()
{
PageData = res, TotalRowCount = (long)query.Count()
});
}
public E_VoucherBudgetDTO GetBudgetDistributesById(EvoucherBudgetDetailPagingFilterModelDTO filter)
{
E_VoucherBudgetDTO res = null;
var budget = _repo.SelectWhere(x => x.Id == filter.EvoucherBudgetId && x.CompanyId == filter.CompanyId).FirstOrDefault();
if (budget != null)
{
res = new E_VoucherBudgetDTO()
{
Budget = budget.Budget,
BudgetDate = budget.BudgetDate,
CompanyId = budget.CompanyId,
StaffConfirm = budget.StaffConfirm,
TotalStaff = budget.TotalStaff,
Status = budget.Status,
StatusName = budget.StatusName,
Id = budget.Id,
TotalValues = budget.TotalValues,
CompanyName = budget.CompanyName,
CreateDate = budget.CreateDate,
CreateUser = budget.CreateUser
};
// tong so voucher da phan bo
var totalDistriVouchers = _denomiRepo.SelectWhere(x => x.VoucherBudgetId == budget.Id).ToList();
res.TotalDistributedCount = totalDistriVouchers != null && totalDistriVouchers.Count > 0 ? totalDistriVouchers.Sum(x => x.CountNumber) : 0;
// cac menh gia
var denomis = _denomiRepo.SelectWhere(x => x.VoucherBudgetId == filter.EvoucherBudgetId).Select(
x => new E_VoucherBudgetDenominationsDTO
{
VoucherBudgetId = x.VoucherBudgetId,
CountNumber = x.CountNumber,
Denominations = x.Denominations,
Id = x.Id,
TotalValues = x.TotalValues,
VoucherTypeCode = x.VoucherTypeCode,
VoucherTypeName = x.VoucherTypeName
}).ToList();
res.BudgetDenominations = denomis;
// tong so menh gia cac loai
if (denomis != null && denomis.Count > 0)
{
res.DenomiTotalCount = denomis.Sum(x => x.CountNumber);
res.DenomiTotalValues = denomis.Sum(x => x.TotalValues);
}
}
return(res);
}
public E_VoucherBudgetDTO FindById(EvoucherBudgetDetailPagingFilterModelDTO filter)
{
var query = _repo.SelectWhere(x => x.Id == filter.EvoucherBudgetId && x.CompanyId == filter.CompanyId).Select(x => new E_VoucherBudgetDTO
{
Budget = x.Budget,
BudgetDate = x.BudgetDate,
CompanyId = x.CompanyId,
StaffConfirm = x.StaffConfirm,
TotalStaff = x.TotalStaff,
Status = x.Status,
StatusName = x.StatusName,
Id = x.Id,
TotalValues = x.TotalValues,
CompanyName = x.CompanyName,
CreateDate = x.CreateDate,
CreateUser = x.CreateUser
}).FirstOrDefault();
return(query);
}
public PagingData <E_VoucherBudgetDetailDTO> GetDetailsPaging(EvoucherBudgetDetailPagingFilterModelDTO pagingModel)
{
return(this._repo.GetDetailsPaging(pagingModel));
}
public E_VoucherBudgetDTO FindById(EvoucherBudgetDetailPagingFilterModelDTO filter)
{
return(this._repo.FindById(filter));
}
public PagingData <E_VoucherBudgetDTO> Find(EvoucherBudgetDetailPagingFilterModelDTO filter)
{
return(this._repo.Find(filter));
}
public E_VoucherBudgetDetailDTO GetEmployeeBudgetDist(EvoucherBudgetDetailPagingFilterModelDTO filter)
{
throw new NotImplementedException();
}
public E_VoucherBudgetDetailDTO GetEmployeeBudgetDist(EvoucherBudgetDetailPagingFilterModelDTO filter)
{
return(_repo.GetEmployeeBudgetDist(filter));
}
public E_VoucherBudgetDTO GetBudgetDistributesById(EvoucherBudgetDetailPagingFilterModelDTO filter)
{
return(_repo.GetBudgetDistributesById(filter));
}
public PagingData <E_VoucherBudgetDTO> FindBudgetDistributes(EvoucherBudgetDetailPagingFilterModelDTO pagingModel)
{
return(this._repo.FindBudgetDistributes(pagingModel));
}
