static void Main()
        {
            //string filename = "log\\Log.txt";
            //CustomSharePointUtility.logFile = new StreamWriter(filename);
            //CustomSharePointUtility.WriteLog("*********************************************");
            //CustomSharePointUtility.WriteLog("Reminder Mail Starts: " + DateTime.Now.ToString());
            //CustomSharePointUtility.WriteLog("*********************************************");
            //Console.WriteLine("*********************************************");
            //Console.WriteLine("Reminder Mail starts : " + DateTime.Now.ToString());
            //Console.WriteLine("*********************************************");
            List <ExpenseVoucher> SPTravelVoucher = null;

            try
            {
                var    siteUrl = ConfigurationManager.AppSettings["SP_Address_Live"];
                string TestingExpenseHeaderList = ConfigurationManager.AppSettings["TestingExpenseHeaderList"];
                string EmailList      = ConfigurationManager.AppSettings["EmailList"];
                string DaysDifference = ConfigurationManager.AppSettings["DaysDifference"];
                //string query = SQLUtility.ReadQuery("EmployeeMasterQuery.txt");
                SPTravelVoucher = new List <ExpenseVoucher>();
                //Task task_SPEmployeeMaster = Task.Run(() => SPTravelVoucher = CustomSharePointUtility.GetAll_TravelVoucherFromSharePoint(siteUrl, TestingTravelHeaderList));
                SPTravelVoucher = CustomSharePointUtility.GetAll_TravelVoucherFromSharePoint(siteUrl, TestingExpenseHeaderList, DaysDifference);
                //List<TravelVoucher> empMasterFinal = new List<TravelVoucher>();
                List <ExpenseVoucher> empMasterFinal = SPTravelVoucher;
                if (empMasterFinal.Count > 0)
                {
                    //CustomSharePointUtility.WriteLog("Voucher data successfully.");
                    //Console.WriteLine("Employee data synchronized successfully.");
                    var success = CustomSharePointUtility.EmailData(empMasterFinal, siteUrl, EmailList);
                    if (success)
                    {
                        //CustomSharePointUtility.WriteLog("Reminder Mail Sent Successfully.");
                        //Console.WriteLine("Reminder Mail Sent Successfully.");
                    }
                }
                else
                {
                    //CustomSharePointUtility.WriteLog("No employee data to synchronize.");
                    //Console.WriteLine("No employee data to synchronize.");
                }
            }
            catch (Exception ex)
            {
                //CustomSharePointUtility.WriteLog("Error in scheduler : " + ex.StackTrace);
                //Console.WriteLine("Error in scheduler : " + ex.StackTrace);
            }
            finally
            {
                //CustomSharePointUtility.WriteLog("*********************************************");
                //CustomSharePointUtility.WriteLog("Reminder Mail ends : " + DateTime.Now.ToString());
                //CustomSharePointUtility.WriteLog("*********************************************");
                //Console.WriteLine("*********************************************");
                //Console.WriteLine("Reminder Mail ends : " + DateTime.Now.ToString());
                //Console.WriteLine("*********************************************");
                //   CustomSharePointUtility.logFile.Close();
                //Console.ReadKey();
            }
        }
Example #2
0
        static void Main()
        {
            List <ITAssets> SPITAssets = null;

            try
            {
                var    siteUrl = ConfigurationManager.AppSettings["SP_Address_Live"];
                string TestAssetsRequisition = ConfigurationManager.AppSettings["TestAssetsRequisition"];
                string EmailList             = ConfigurationManager.AppSettings["EmailList"];
                string DaysDifference        = ConfigurationManager.AppSettings["DaysDifference"];
                //string query = SQLUtility.ReadQuery("EmployeeMasterQuery.txt");
                SPITAssets = new List <ITAssets>();
                //Task task_SPEmployeeMaster = Task.Run(() => SPTravelVoucher = CustomSharePointUtility.GetAll_TravelVoucherFromSharePoint(siteUrl, TestingTravelHeaderList));
                SPITAssets = CustomSharePointUtility.GetAll_AssetsDetailsFromSharePoint(siteUrl, TestAssetsRequisition, DaysDifference);
                //List<TravelVoucher> empMasterFinal = new List<TravelVoucher>();
                List <ITAssets> empMasterFinal = SPITAssets;
                if (empMasterFinal.Count > 0)
                {
                    //Console.WriteLine("Employee data synchronized successfully.");
                    var success = CustomSharePointUtility.EmailData(empMasterFinal, siteUrl, EmailList);
                    if (success)
                    {
                        ///CustomSharePointUtility.WriteLog("Reminder Mail Sent Successfully.");
                        //Console.WriteLine("Reminder Mail Sent Successfully.");
                    }
                }
                else
                {
                    //CustomSharePointUtility.WriteLog("No Pending Records.");
                    //Console.WriteLine("No Pending Records.");
                }
            }
            catch (Exception ex)
            {
                CustomSharePointUtility.WriteLog("Error in scheduler : " + ex.StackTrace);
                Console.WriteLine("Error in scheduler : " + ex.StackTrace);
            }
            finally
            {
            }
        }
Example #3
0
        static void Main()
        {
            //string filename = "log\\Log.txt";
            //CustomSharePointUtility.logFile = new StreamWriter(filename);
            //CustomSharePointUtility.WriteLog("*********************************************");
            //CustomSharePointUtility.WriteLog("Reminder Mail Starts: " + DateTime.Now.ToString());
            //CustomSharePointUtility.WriteLog("*********************************************");
            //Console.WriteLine("*********************************************");
            //Console.WriteLine("Reminder Mail starts : " + DateTime.Now.ToString());
            //Console.WriteLine("*********************************************");
            List <Employee> SPEmployee      = null;
            List <Employee> SPMonthEmployee = null;
            List <Employee> PendingEmployee = null;

            DateTime nextmonth = DateTime.Now.AddMonths(1);

            string currentMonth = nextmonth.Month.ToString();
            string currentYear  = nextmonth.Year.ToString();

            // string currentMonth = DateTime.Now.Month.ToString();
            // string currentYear = DateTime.Now.Year.ToString();
            try
            {
                var    siteUrl               = ConfigurationManager.AppSettings["SP_Address_Live"];
                var    RootsiteUrl           = ConfigurationManager.AppSettings["SP_Address_RootLive"];
                string SentMail              = ConfigurationManager.AppSettings["SentMail"];
                string HODMaster             = ConfigurationManager.AppSettings["HODMaster"];
                string SalesEstimateEmployee = ConfigurationManager.AppSettings["SalesEstimateEmployee"];
                //string TestingPurchaseHeaderList = ConfigurationManager.AppSettings["TestingPurchaseHeaderList"];
                //string PurchaseApprovers = ConfigurationManager.AppSettings["PurchaseApprovers"];
                //string EmailList = ConfigurationManager.AppSettings["EmailList"];
                //string DaysDifference = ConfigurationManager.AppSettings["DaysDifference"];
                //string query = SQLUtility.ReadQuery("EmployeeMasterQuery.txt");
                SPEmployee      = new List <Employee>();
                SPMonthEmployee = new List <Employee>();
                PendingEmployee = new List <Employee>();



                //Task task_SPEmployeeMaster = Task.Run(() => SPTravelVoucher = CustomSharePointUtility.GetAll_TravelVoucherFromSharePoint(siteUrl, TestingTravelHeaderList));
                SPEmployee      = CustomSharePointUtility.GetEmployees(siteUrl, HODMaster);
                SPMonthEmployee = CustomSharePointUtility.GetEnterEstimate(currentMonth, currentYear, SalesEstimateEmployee, siteUrl);
                PendingEmployee = CustomSharePointUtility.GetFilter(SPEmployee, SPMonthEmployee);

                CustomSharePointUtility.EmailData(PendingEmployee, siteUrl, SentMail);



                // List<TravelVoucher> empMasterFinal = new List<TravelVoucher>();
                ////List<PurchaseOrder> purchaseDataFinal = SPPurchaseOrder;
                ////if (purchaseDataFinal.Count > 0)
                ////{
                ////    for (var i = 0; i < purchaseDataFinal.Count; i++)
                ////    {
                ////        if (purchaseDataFinal[i].LocationType == "Office")
                ////        {
                ////            if (purchaseDataFinal[i].ApprovalStatus == "Submitted")
                ////            {
                ////                CustomSharePointUtility.EmployeeMasterData(purchaseDataFinal[i], RootsiteUrl, siteUrl, EmployeeMaster, EmailList);
                ////            }
                ////            else if (purchaseDataFinal[i].ApprovalStatus == "Approved By Functional Head")
                ////            {
                ////                CustomSharePointUtility.PurchaseApproversData(purchaseDataFinal[i], RootsiteUrl, siteUrl, PurchaseApprovers, EmailList);
                ////            }
                ////        }
                ////        else if(purchaseDataFinal[i].LocationType == "Plant"){
                ////            if (purchaseDataFinal[i].ApprovalStatus == "Submitted")
                ////            {
                ////                CustomSharePointUtility.PurchaseApproversData(purchaseDataFinal[i], RootsiteUrl, siteUrl, PurchaseApprovers, EmailList);
                ////            }
                ////            else if (purchaseDataFinal[i].ApprovalStatus == "Approved By Purchase Head")
                ////            {
                ////                CustomSharePointUtility.PurchaseApproversData(purchaseDataFinal[i], RootsiteUrl, siteUrl, PurchaseApprovers, EmailList);
                ////            }
                ////            else if (purchaseDataFinal[i].ApprovalStatus == "Approved By Plant Head")
                ////            {
                ////                CustomSharePointUtility.PurchaseApproversData(purchaseDataFinal[i], RootsiteUrl, siteUrl, PurchaseApprovers, EmailList);
                ////            }
                ////        }
                ////    }



                ////        //Console.WriteLine("Employee data synchronized successfully.");
                ////        //var success = CustomSharePointUtility.EmailData(empMasterFinal, siteUrl, EmailList);
                ////        //if (success)
                ////        //{
                ////        //    ///CustomSharePointUtility.WriteLog("Reminder Mail Sent Successfully.");
                ////        //    //Console.WriteLine("Reminder Mail Sent Successfully.");
                ////        //}
                ////}
                ////else
                ////{
                ////    //CustomSharePointUtility.WriteLog("No Pending Records.");
                ////    //Console.WriteLine("No Pending Records.");
                ////}
            }
            catch (Exception ex)
            {
                CustomSharePointUtility.WriteLog("Error in scheduler : " + ex.StackTrace);
                Console.WriteLine("Error in scheduler : " + ex.StackTrace);
            }
            finally
            {
                //CustomSharePointUtility.WriteLog("*********************************************");
                //CustomSharePointUtility.WriteLog("Reminder Mail ends : " + DateTime.Now.ToString());
                //CustomSharePointUtility.WriteLog("*********************************************");
                //Console.WriteLine("*********************************************");
                // Console.WriteLine("Reminder Mail ends : " + DateTime.Now.ToString());
                //Console.WriteLine("*********************************************");
                //CustomSharePointUtility.logFile.Close();
                //Console.ReadKey();
            }
        }