public DataTable GetUserPoint(PointFilters pointFilters, Sorter sorter)
{
string ymStart = "";
string ymEnd = "";
if (pointFilters != null)
{
if (pointFilters.YMStart.HasValue)
{
ymStart = pointFilters.YMStart.Value.ToString("yyyy-MM-dd");
}
if (pointFilters.YMEnd.HasValue)
{
ymEnd = pointFilters.YMEnd.Value.ToString("yyyy-MM-dd");
}
if (sorter == null)
{
sorter = new Sorter();
}
DataSet ds = new StoredProcedures.GetDataStoredProcedures().GetDataUserPoint(pointFilters.DepartmentId, pointFilters.PositionId, pointFilters.SubdivisionId, pointFilters.UserId, ymStart, ymEnd);
if (ds != null && ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
return(dt);
}
}
return(null);
}
public ObjectResult <UserPoint> GetUserPointA(PointFilters pointFilters, Sorter sorter)
{
string procedureType = "REQUEST_POINT_LIST";
string ymStart = "";
string ymEnd = "";
if (pointFilters != null)
{
if (pointFilters.YMStart.HasValue)
{
ymStart = pointFilters.YMStart.Value.ToString("yyyy-MM-dd");
}
if (pointFilters.YMEnd.HasValue)
{
ymEnd = pointFilters.YMEnd.Value.ToString("yyyy-MM-dd");
}
if (sorter == null)
{
sorter = new Sorter();
}
ObjectResult <UserPoint> output = _ctx.UserPointProcedure(procedureType, pointFilters.DepartmentId, pointFilters.PositionId, pointFilters.SubdivisionId, pointFilters.UserId, ymStart, ymEnd, sorter.FieldName, sorter.OnDesc);
return(output);
}
return(null);
}
public int CountSearchPointForInputPoint(PointFilters pointFilters)
{
var output = _ctx.Points
.Include("User").Include("User.Position").Include("User.Position.Department")
.Include("User.Subdivision");
//filter
if (pointFilters != null)
{
if (pointFilters.DepartmentId.HasValue && pointFilters.DepartmentId > 0)
{
output.Where(point => point.User.Position.DepartmentId == pointFilters.DepartmentId);
}
if (pointFilters.SubdivisionId.HasValue && pointFilters.SubdivisionId > 0)
{
output.Where(point => point.User.SubdivisionId == pointFilters.SubdivisionId);
}
if (pointFilters.PositionId.HasValue && pointFilters.PositionId > 0)
{
output.Where(point => point.User.PositionId == pointFilters.PositionId);
}
if (pointFilters.UserId.HasValue && pointFilters.UserId > 0)
{
output.Where(point => point.UserId == pointFilters.UserId);
}
if (pointFilters.YMStart.HasValue)
{
output.Where(point => point.YM >= pointFilters.YMStart);
}
if (pointFilters.YMEnd.HasValue)
{
output.Where(point => point.YM <= pointFilters.YMEnd);
}
}
return(output.Count());
}
public List <PointByUserModel> SearchPointForInputPoint(PointFilters pointFilters, Sorter sorter, PagingTable pagingTable)
{
var output = _ctx.Points
.Include("User").Include("User.Position").Include("User.Position.Department")
.Include("User.Subdivision");
//filter
if (pointFilters != null)
{
if (pointFilters.DepartmentId.HasValue && pointFilters.DepartmentId > 0)
{
output.Where(point => point.User.Position.DepartmentId == pointFilters.DepartmentId);
}
if (pointFilters.SubdivisionId.HasValue && pointFilters.SubdivisionId > 0)
{
output.Where(point => point.User.SubdivisionId == pointFilters.SubdivisionId);
}
if (pointFilters.PositionId.HasValue && pointFilters.PositionId > 0)
{
output.Where(point => point.User.PositionId == pointFilters.PositionId);
}
if (pointFilters.UserId.HasValue && pointFilters.UserId > 0)
{
output.Where(point => point.UserId == pointFilters.UserId);
}
if (pointFilters.YMStart.HasValue)
{
output.Where(point => point.YM >= pointFilters.YMStart);
}
if (pointFilters.YMEnd.HasValue)
{
output.Where(point => point.YM <= pointFilters.YMEnd);
}
}
//sorter
if (sorter != null)
{
if (!string.IsNullOrEmpty(sorter.FieldName))
{
Type pointModelType = typeof(PointByUserModel);
var property = pointModelType.GetProperty(sorter.FieldName);
if (property != null)
{
string pointModelPropertyName = property.Name;
if (pointModelPropertyName == "YM")
{
if (sorter.OnDesc)
{
output.OrderByDescending(p => p.YM);
}
else
{
output.OrderBy(p => p.YM);
}
}
else if (pointModelPropertyName == "UserId")
{
if (sorter.OnDesc)
{
output.OrderByDescending(p => p.UserId);
}
else
{
output.OrderBy(p => p.UserId);
}
}
else if (pointModelPropertyName == "Name")
{
if (sorter.OnDesc)
{
output.OrderByDescending(p => p.User.Name);
}
else
{
output.OrderBy(p => p.User.Name);
}
}
else if (pointModelPropertyName == "Lastname")
{
if (sorter.OnDesc)
{
output.OrderByDescending(p => p.User.Lastname);
}
else
{
output.OrderBy(p => p.User.Lastname);
}
}
else if (pointModelPropertyName == "PositionName")
{
if (sorter.OnDesc)
{
output.OrderByDescending(p => p.User.Position.Name);
}
else
{
output.OrderBy(p => p.User.Position.Name);
}
}
else if (pointModelPropertyName == "DepartmentName")
{
if (sorter.OnDesc)
{
output.OrderByDescending(p => p.User.Position.Department.Name);
}
else
{
output.OrderBy(p => p.User.Position.Department.Name);
}
}
else if (pointModelPropertyName == "SubdivisionName")
{
if (sorter.OnDesc)
{
output.OrderByDescending(p => p.User.Subdivision.Name);
}
else
{
output.OrderBy(p => p.User.Subdivision.Name);
}
}
else if (pointModelPropertyName == "Point")
{
if (sorter.OnDesc)
{
output.OrderByDescending(p => p.MonthlyPoint);
}
else
{
output.OrderBy(p => p.MonthlyPoint);
}
}
else if (pointModelPropertyName == "Remark")
{
if (sorter.OnDesc)
{
output.OrderByDescending(p => p.Remark);
}
else
{
output.OrderBy(p => p.Remark);
}
}
else if (pointModelPropertyName == "TargetPoint")
{
if (sorter.OnDesc)
{
output.OrderByDescending(p => p.User.Position.TargetPoint);
}
else
{
output.OrderBy(p => p.User.Position.TargetPoint);
}
}
else if (pointModelPropertyName == "ModifyDate")
{
if (sorter.OnDesc)
{
output.OrderByDescending(p => p.ModifyDate);
}
else
{
output.OrderBy(p => p.ModifyDate);
}
}
}
}
}
//paging
if (pagingTable != null)
{
if (pagingTable.CurrentPage < 1)
{
pagingTable.CurrentPage = 1;
}
if (pagingTable.PageSize > 0)
{
output.ToPagedList(pagingTable.CurrentPage, pagingTable.PageSize);
}
}
List <Point> rawPoint = output.ToList();
List <PointByUserModel> points = new List <PointByUserModel>();
foreach (Point point in rawPoint)
{
PointByUserModel pm = new PointByUserModel(point);
points.Add(pm);
}
return(points);
}