MARKUS

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace RefinalDPF

{

    class Program

    {

        private static string MarkusConnectionString;

        static void Main(string[] args)

        {

            Console.WriteLine("Start Any Key");

            Console.ReadKey();

            service.ServiceDeepViewClient service = new service.ServiceDeepViewClient();

            using (Markus.EntityModel.MarkusModel _entity = new Markus.EntityModel.MarkusModel(MarkusConnectionString))

            {

                var lstFinalPDF =_entity.FINAL_PDF.Where(x => x.STATUS == 105).GroupBy(x=>x.MARKUPINFO_ID).ToList();

                foreach (var item in lstFinalPDF)

                    if(item.Count() > 0)

                    {

                        var firstItem =  item.OrderByDescending(x => x.CREATE_DATETIME).First();

                        var result = service.SetFinalPDF(firstItem.PROJECT_NO, firstItem.DOCINFO_ID, firstItem.MARKUPINFO_ID, firstItem.CREATE_USER_ID);

                        if(result.Exception != null)

                        {

                            Console.WriteLine(result.Exception);

                            Console.ReadKey();

                        }

                        else

                        {

                            Console.WriteLine($"{firstItem.PROJECT_NO}, {firstItem.DOCINFO_ID}, {firstItem.MARKUPINFO_ID}, {firstItem.CREATE_USER_ID}");

                            Console.ReadKey();

                        }

                    }

            }

        }

    }

}