public List <SearchDashboard_Result> SearchDashboard(DashboardCriteria criteria, ref string strDivName, ref string strWorkHC, ref string strTotalHC, ref string strWorkPercent, ref int?iMaxColumn) { using (TransactionEntities Context = new TransactionEntities()) { var opDivName = new ObjectParameter("DivName", typeof(string)); var opWorkHC = new ObjectParameter("WorkHC", typeof(string)); var opTotalHC = new ObjectParameter("TotalHC", typeof(string)); var opWorkPercent = new ObjectParameter("WorkPercent", typeof(string)); var opMaxColumn = new ObjectParameter("MaxColumn", typeof(int?)); var result = Context.SearchDashboard( divCode: criteria.DivCode , deptCode: criteria.DeptCode , secCode: criteria.SecCode , userCode: criteria.UserCode , divName: opDivName , workHC: opWorkHC , totalHC: opTotalHC , workPercent: opWorkPercent , maxColumn: opMaxColumn ).ToList(); strDivName = opDivName.Value == null || opDivName.Value == DBNull.Value ? null : (string)opDivName.Value; strWorkHC = opWorkHC.Value == null || opWorkHC.Value == DBNull.Value ? null : (string)opWorkHC.Value; strTotalHC = opTotalHC.Value == null || opTotalHC.Value == DBNull.Value ? null : (string)opTotalHC.Value; strWorkPercent = opWorkPercent.Value == null || opWorkPercent.Value == DBNull.Value ? null : (string)opWorkPercent.Value; iMaxColumn = opMaxColumn.Value == null || opMaxColumn.Value == DBNull.Value ? null : (int?)opMaxColumn.Value; return(result); //if (criteria.UserSelectedDate.HasValue) //{ // return Context.Companies.Where(d => d.DeleteFlag == (criteria.DeleteFlag ?? d.DeleteFlag)) // .Where(d => d.Status == criteria.Status || criteria.Status == null) // .Where(d => d.DeleteFlag == false || (d.DeleteFlag == true && d.UpdatedDate > criteria.UserSelectedDate)) // .ToList(); //} //else //{ // return Context.Companies.Where(d => d.DeleteFlag == (criteria.DeleteFlag ?? d.DeleteFlag)).Where(d => d.Status == criteria.Status || criteria.Status == null).ToList(); //} } }