using System;
using System.Collections.Generic;
using System.Linq;
public class Program
{
public static void Main(string[] args)
{
var query = new UvwRequestAssignmentManagementBO().GetAll().Where(uvw => (uvw.FK_ProcessStep == 2)
&& (uvw.FK_Entity == 1)
&& (uvw.FK_Manager == 15))
.Select(p => new ReqSupAdminGridVm
{
NameFamily = p.NameFamily,
RequestDate = p.RequestDate,
RequestNo = p.RequestNo,
RequestType = GetReqType(p.RequestType),
RequestEvaluationStatus = GetReqEvalStatus(p.RequestEvaluationStatus_Aggregation),
});
}
private static string GetReqEvalStatus(int agg)
{
switch (agg)
{
case 1: return "a";
case 2: return "b";
case 3: return "c";
case 4: return "d";
default: return "";
}
}
private static string GetReqType(int type)
{
switch (type)
{
case 1: return "a";
case 2: return "b";
case 3: return "c";
case 4: return "d";
default: return "";
}
}
}
public class ReqSupAdminGridVm
{
public string NameFamily;
public DateTime RequestDate;
public string RequestNo;
public string RequestType;
public string RequestEvaluationStatus;
}
// ReSharper disable InconsistentNaming
public struct UvwRequestAssignmentManagementBO
{
public IEnumerable<Stuff> GetAll()
{
throw new NotImplementedException();
}
}
public struct Stuff
{
public int FK_ProcessStep;
public int FK_Entity;
public int FK_Manager;
public string NameFamily;
public DateTime RequestDate;
public string RequestNo;
public int RequestType;
public int RequestEvaluationStatus_Aggregation;
}