public async Task <TodayFocusViewModel> GetAllOrderDisplayByempid(string empid)
{
var foc = new TodayFocusViewModel();
foc = await _orderRespository.GetAllOrderDisplayByempid(empid);
return(foc);
}
public async Task <ActionResult> MyInfo()
{
var foc = new TodayFocusViewModel();
var emp = new EmployeeViewModel();
string id = Session["LoginId"].ToString();
emp = await _empProvider.GetEmployeeByUserIdAsync(id);
foc = await _orderProvider.GetAllOrderDisplayByempid(id);
emp.EmpId = id;
ViewBag.TodayFocus = foc;
ViewBag.Employee = emp;
return(View());
}
public async Task <TodayFocusViewModel> GetAllOrderDisplayByempid(string empid)
{
var storeProcedureName = "[dbo].[Get_TodayFocus]";
var result = await _dbContext.Database.SqlQuery <TodayFocusViewModel>(
$"{storeProcedureName} @empid",
new SqlParameter("@empid", empid)
).FirstOrDefaultAsync();
var foc = new TodayFocusViewModel();
if (result != null)
{
foc.TodayAddOrder = result.TodayAddOrder;
foc.TodayHaveDone = result.TodayHaveDone;
foc.TodayOrderWait = result.TodayOrderWait;
foc.YouHaveDone = result.YouHaveDone;
}
return(foc);
}
