public static InspectionPlanFileViewModel GetInspectionPlanFileView(InspectionPlanFileFilterModel filter)
{
ACTION = "GetInspectionPlanFileView(InspectionPlanFileFilterModel)";
try
{
ResponseModel response = new ResponseModel();
int totalRecord = 0;
decimal lastVersion = 0;
var model = InspectionPlanFileDAL.GetInspectionPlanFileList(filter, ref totalRecord, ref response, ref lastVersion);
filter.Pagination.TotalRecord = totalRecord;
PaginationModel pagination = new PaginationModel(totalRecord, filter.Pagination.Page, filter.Pagination.Take);
filter.Pagination = pagination;
filter.LastInspectionPlanFileVersion = lastVersion;
return(new InspectionPlanFileViewModel()
{
Action = ACTION,
Source = SOURCE,
Status = response.Status,
Message = response.Message,
List = model,
Filter = filter
});
}
catch (Exception ex)
{
return(new InspectionPlanFileViewModel()
{
Action = ACTION,
Source = SOURCE,
Status = false,
Message = ex.Message,
List = null,
Filter = filter
});
}
}
public static List <InspectionPlanFileModel> GetInspectionPlanFileList(InspectionPlanFileFilterModel filter, ref int totalRecord, ref ResponseModel response, ref decimal lastVersion)
{
ACTION = "GetInspectionPlanFileList(InspectionPlanFileFilterModel)";
try
{
using (UTMMABCDBEntities context = new UTMMABCDBEntities())
{
filter.InspectionPlanFileIDs = filter.InspectionPlanFileIDs != null ? filter.InspectionPlanFileIDs : new int[] { };
var IQuery = context.USR_TMMA_INSPECTION_PLAN_FILE
.Where(o =>
(!string.IsNullOrEmpty(filter.Keywords) ?
(o.RecObjectName.Contains(filter.Keywords)) ||
(o.CreatedBy.Contains(filter.Keywords))
: true) &&
(filter.InspectionPlanFileID.HasValue ? o.InspectionPlanFileID == filter.InspectionPlanFileID.Value : true) &&
(filter.InspectionPlanFileIDs.Count() > 0 ? filter.InspectionPlanFileIDs.Contains(o.InspectionPlanFileID) : true) &&
(!string.IsNullOrEmpty(filter.RecObjectName) ? filter.CreatedBy.Contains(o.RecObjectName) : true) &&
(filter.ProductsTypeID.HasValue ? o.ProductsTypeID == filter.ProductsTypeID.Value : true) &&
(filter.IsActive.HasValue ? o.IsActive == 1 : true)
);
totalRecord = IQuery.Count();
var lists = filter.Sort == "asc"
? filter.Order == "RecObjectName" ? IQuery.OrderBy(o => o.RecObjectName)
: filter.Order == "UserSAP" ? IQuery.OrderBy(o => o.UserSAP)
: filter.Order == "Version" ? IQuery.OrderBy(o => o.InspectionPlanFileVersion)
: filter.Order == "Status" ? IQuery.OrderBy(o => o.InspectionPlanFileStatus)
: filter.Order == "ValidDate" ? IQuery.OrderBy(o => o.ValidDate)
: filter.Order == "CreatedBy" ? IQuery.OrderBy(o => o.CreatedBy)
: filter.Order == "CreatedDate" ? IQuery.OrderBy(o => o.CreatedDate)
: IQuery.OrderBy(o => o.CreatedDate)
: filter.Order == "RecObjectName" ? IQuery.OrderByDescending(o => o.RecObjectName)
: filter.Order == "UserSAP" ? IQuery.OrderByDescending(o => o.UserSAP)
: filter.Order == "Version" ? IQuery.OrderByDescending(o => o.InspectionPlanFileVersion)
: filter.Order == "Status" ? IQuery.OrderByDescending(o => o.InspectionPlanFileStatus)
: filter.Order == "ValidDate" ? IQuery.OrderByDescending(o => o.ValidDate)
: filter.Order == "CreatedBy" ? IQuery.OrderByDescending(o => o.CreatedBy)
: filter.Order == "CreatedDate" ? IQuery.OrderByDescending(o => o.CreatedDate)
: IQuery.OrderByDescending(o => o.CreatedDate);
lastVersion = IQuery.OrderByDescending(o => o.InspectionPlanFileVersion).FirstOrDefault().InspectionPlanFileVersion.GetValueOrDefault();
List <USR_TMMA_INSPECTION_PLAN_FILE> list = filter.Pagination.IsPaging ? lists.Skip(filter.Pagination.Skip).Take(filter.Pagination.Take).ToList() : lists.ToList();
List <InspectionPlanFileModel> mList = Mapping(list);
response = new ResponseModel()
{
Source = SOURCE,
Action = ACTION,
Status = true,
Message = "Success"
};
return(mList);
}
}
catch (Exception ex)
{
totalRecord = 0;
response = new ResponseModel()
{
Source = SOURCE,
Action = ACTION,
Status = false,
Message = ex.Message
};
return(null);
}
}
/// <summary>
/// Monomer Inspection Plan
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public InspectionPlanFileViewModel GetInspectionPlanFileView(InspectionPlanFileFilterModel filter)
{
return(InspectionPlanFileBLL.GetInspectionPlanFileView(filter));
}
