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