public async Task <IActionResult> SellClientAuthoSeller(string deparID, string empID, string currentMonth, string searchName)
{
string StrQuery;
currentMonth = currentMonth is null ? "''" : currentMonth;
searchName = searchName is null ? "''" : searchName;
StrQuery = string.Format("EXECUTE [dbo].[clientReward_QueryResult] @yearMonthSet = {0},@deparID={1},@empID={2},@clientNamePart={3}", currentMonth, deparID, empID, searchName);
var clientDataset = new ClientListDatasetViewModels(_contextServer);
clientDataset.clientListDetails = await _contextXf.Set <ClientListDetail>().FromSql(StrQuery).ToListAsync();
var grouped = clientDataset.clientListDetails.GroupBy(x => x.EmployeeID_xf);
clientDataset.clientListTotals = grouped.Select(s =>
new ClientListTotal
{
EmployeeID_xf = s.Key,
SellSum = s.Sum(t => t.SellSum),
CostSum = s.Sum(t => t.CostSum),
ProfitSum = s.Sum(t => t.ProfitSum),
EmpName = s.Max(t => t.EmpName),
ResultSum = s.Sum(t => t.ProfitSum) * (decimal)0.05
});
clientDataset.DeparID = deparID;
clientDataset.EmpID = empID;
clientDataset.CurrentMonth = currentMonth;
clientDataset.EmpLists = MyClass.PopulateSomethingsToList.PopulateEmpList(_contextServer, Convert.ToInt16(deparID));
return(View(clientDataset));
}
public IActionResult GetEmpFromDepar(string deparID)
{
ClientListDatasetViewModels returnModel = new ClientListDatasetViewModels(_contextServer);
returnModel.EmpLists = MyClass.PopulateSomethingsToList.PopulateEmpList(_contextServer, Convert.ToInt16(deparID));
return(PartialView("PartialEmployeeListView", returnModel));
}
public ActionResult SellClientAuthoSeller()
{
ClientListDatasetViewModels clientDataset = new ClientListDatasetViewModels(_contextServer);
return(View(clientDataset));
}
