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