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