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)); }