/// <summary>
/// Iris can get FileVersionBudget table for approve duplicate upload
/// </summary>
/// <returns></returns>
public List <FileVersionBudget> GetFileVersionBudgetList()
{
List <FileVersionBudget> _FileVersionBudgetList = new List <FileVersionBudget>();
List <Budget_FileVersionBudget> _Budget_FileVersionBudgetList = this._budget_FileVersionBudgetService.GetAll().ToList();
List <Budget_HeadCountHR> _Budget_HeadCountHRList = this._budget_HeadCountHRService.GetAll().ToList();
List <ItemCatalog> _ItemCatalogList = this._itemCatalogService.GetAll().ToList();
List <Budget_DepartmentReport> _Budget_DepartmentReport = this._budget_DepartmentReportService.GetAll().ToList();
var results = _Budget_FileVersionBudgetList.Join(_Budget_HeadCountHRList,
p => p.Account, q => q.Account, (p, q) => new { p, q }).Join(_ItemCatalogList,
pp => pp.p.ItemId_BudgetName, r => r.ItemId, (pp, r) => new { pp, r }).Join(_Budget_DepartmentReport,
ppp => ppp.pp.p.DepartmentId, s => s.DepartmentId, (ppp, s) => new { ppp, s }
).Select(x => new
{
Id = x.ppp.pp.p.Id,
Date = x.ppp.pp.p.Date,
Version = x.ppp.pp.p.Version,
Approve = x.ppp.pp.p.Approve,
Account = x.ppp.pp.p.Account,
Factory = x.ppp.pp.p.Factory,
AltwName = x.ppp.pp.q.AltwName,
BudgetName = x.ppp.r.Name,
DepartmentName = x.s.DepartmentName
}).OrderBy(x => x.AltwName).ToList();
foreach (var r in results.Distinct())
{
FileVersionBudget _FileVersionBudget = new FileVersionBudget();
_FileVersionBudget.Id = r.Id;
_FileVersionBudget.Date = r.Date;
_FileVersionBudget.Version = r.Version;
_FileVersionBudget.Approve = r.Approve;
_FileVersionBudget.Account = r.Account;
_FileVersionBudget.Factory = r.Factory;
_FileVersionBudget.AltwName = r.AltwName;
_FileVersionBudget.BudgetName = r.BudgetName;
_FileVersionBudget.DepartmentName = r.DepartmentName;
_FileVersionBudgetList.Add(_FileVersionBudget);
}
return(_FileVersionBudgetList);
}
public bool Put([FromBody] FileVersionBudget fileVersionBudet)
{
return(this._budgetExcelUploadService.UpdateFileVersionBudgetApprove(fileVersionBudet.Id));
}
