public async Task <IActionResult> DeptExpense(DataSourceRequest command,
DepExpListModel model)
{
var(DepExpModelList, totalCount) = await _financialDataService.PrepareDeptExpListModel(model, command.Page, command.PageSize);
var gridModel = new DataSourceResult
{
Data = DepExpModelList,
Total = totalCount
};
return(Json(gridModel));
}
public async Task <IActionResult> DeptExpense()
{
var model = new DepExpListModel();
//CostCenter DropDown
model.AvailableCostCenter.Add(new SelectListItem {
Text = "ALL", Value = "0"
});
foreach (var item in (await _financialDataService.GetCostCenterList((int)_workContext.CurrentCustomer.ClientId)))
{
model.AvailableCostCenter.Add(new SelectListItem {
Text = item.Both, Value = item.SName.ToString()
});
}
//Vendor Dropdown
model.AvailableVendors.Add(new SelectListItem {
Text = "ALL", Value = "0"
});
foreach (var item in (await _financialDataService.GetVendorUsage((int)_workContext.CurrentCustomer.ClientId)))
{
model.AvailableVendors.Add(new SelectListItem {
Text = item.HVendorName, Value = item.HVendorName.ToString()
});
}
//Gl Dropdown
model.AvailableGL.Add(new SelectListItem {
Text = "ALL", Value = "0"
});
foreach (var item in (await _financialDataService.GetGL((int)_workContext.CurrentCustomer.ClientId)).Where(h => h.HGL != null))
{
model.AvailableGL.Add(new SelectListItem {
Text = item.HGL, Value = item.HGL.ToString()
});
}
return(View(model));
}
public async Task <(IEnumerable <Year2Date_History> DepExpModelList, int totalCount)> PrepareDeptExpListModel(DepExpListModel model, int pageIndex, int pageSize)
{
try
{
var query = from h in _historyRepository.Table
where h.HclientId == (int)_workContext.CurrentCustomer.ClientId
select new Year2Date_History
{
HshipId = h.HshipId,
Hdate = h.Hdate,
Hpo = h.Hpo,
Hoitem = h.Hoitem,
Hdescription = h.Hdescription,
Huom = h.Huom,
Hqty = h.Hqty,
Hgl = h.Hgl,
HvendorName = h.HvendorName,
Hstatus = h.Hstatus,
HshipName = h.HshipName,
Total = ((h.Hqty * h.HsellingPrice) + h.Hshipping + (Convert.ToInt32(h.Hqty) * h.HsellingPrice * Convert.ToInt32(h.HsalesTaxRate)) + h.Hadjust)
};
//Sorting
if (model.intSort == "1")
{
query = query.OrderBy(c => c.HshipId);
}
if (model.intSort == "2")
{
query = query.OrderBy(c => c.HshipName);
}
//Searching
if (!string.IsNullOrEmpty(model.intDateB))
{
query = query.Where(c => c.Hdate >= Convert.ToDateTime(model.intDateB));
}
if (!string.IsNullOrEmpty(model.intDateE))
{
query = query.Where(c => c.Hdate <= Convert.ToDateTime(model.intDateE));
}
if (model.strShipID != "0")
{
query = query.Where(c => c.HshipId.Contains(model.strShipID));
}
if (!string.IsNullOrEmpty(model.strShipName))
{
query = query.Where(c => c.HshipName.Contains(model.strShipName));
}
if (model.strHGL != "0")
{
query = query.Where(c => c.Hgl.Contains(model.strHGL));
}
if (model.strVendor != "0")
{
query = query.Where(c => c.HvendorName.Contains(model.strVendor));
}
if (!string.IsNullOrEmpty(model.strItem))
{
query = query.Where(c => c.Hoitem.Contains(model.strItem));
}
var historylist = query.ToList();
int totalCount = historylist.Count;
int pageOffSet = (Convert.ToInt32(pageIndex) - 1) * 10;
historylist = historylist.Skip(pageOffSet).Take(Convert.ToInt32(pageSize)).ToList();
return(historylist, totalCount);
}
catch (Exception ex)
{
}
return(null, 0);
}
public async Task <IList <Year2Date_History> > PrepareDeptExpList(DepExpListModel model)
{
var query = from h in _historyRepository.Table
select new Year2Date_History
{
HshipId = h.HshipId,
Hdate = h.Hdate,
Hpo = h.Hpo,
Hoitem = h.Hoitem,
Hdescription = h.Hdescription,
Huom = h.Huom,
Hqty = h.Hqty,
Hgl = h.Hgl,
HvendorName = h.HvendorName,
Hstatus = h.Hstatus,
HshipName = h.HshipName
};
query = query.Where(c => c.HclientId == (int)_workContext.CurrentCustomer.ClientId);
if (!string.IsNullOrEmpty(model.intDateB))
{
query = query.Where(c => c.Hdate <= Convert.ToDateTime(model.intDateB));
}
if (!string.IsNullOrEmpty(model.intDateE))
{
query = query.Where(c => c.Hdate >= Convert.ToDateTime(model.intDateE));
}
if (model.strVendor != "0")
{
query = query.Where(c => c.HvendorName.Contains(model.strVendor));
}
if (model.strVendor != "0")
{
query = query.Where(c => c.HshipId.Contains(model.strShipID));
}
if (!string.IsNullOrEmpty(model.strShipName))
{
query = query.Where(c => c.HshipName.Contains(model.strShipName));
}
if (!string.IsNullOrEmpty(model.strItem))
{
query = query.Where(c => c.Hoitem.Contains(model.strItem));
}
if (!string.IsNullOrEmpty(model.strHGL))
{
query = query.Where(c => c.Hgl.Contains(model.strHGL));
}
//Sorting
if (model.intSort == "1")
{
query = query.OrderBy(c => c.HshipId);
}
if (model.intSort == "2")
{
query = query.OrderBy(c => c.HshipName);
}
return(query.ToList());
}
