Exemplo n.º 1
0
        public static void ISForRevBySiteVereco(string beginPeriod, string endPeriod, string report)
        {
            string reportingPeriod = null;

            System.Console.WriteLine("Compiling Vereco PL Data...");
            RunSqlFromExcel.DistributorClass dc = new RunSqlFromExcel.DistributorClass();
            dc.DistributorMethod(beginPeriod, endPeriod, "ISForRevBySiteVereco", "A", "O", 2, "K:K", "null", reportingPeriod, "ISForRevBySiteVereco", report); //begin period functioning as month


            RunSqlFromExcel.EndProc ep = new RunSqlFromExcel.EndProc();
            ep.EndProcMethod();
            return;
        }
Exemplo n.º 2
0
        public static void BaseAudit(string beginPeriod, string endPeriod, string report)
        {
            string reportingPeriod = null;

            System.Console.WriteLine("Compiling BaseAudit Data...");
            RunSqlFromExcel.DistributorClass dc = new RunSqlFromExcel.DistributorClass();
            dc.DistributorMethod(beginPeriod, endPeriod, "BaseAudit", "A", "B", 2, "K:K", "null", reportingPeriod, "BaseAudit", report);


            RunSqlFromExcel.EndProc ep = new RunSqlFromExcel.EndProc();
            ep.EndProcMethod();
            return;
        }
Exemplo n.º 3
0
        public static void NewSoftwareContracts(string beginPeriod, string endPeriod, string report)
        {
            string reportingPeriod = null;

            System.Console.WriteLine("Compiling New Software Contracts Data...");
            RunSqlFromExcel.DistributorClass dc = new RunSqlFromExcel.DistributorClass();
            dc.DistributorMethod(beginPeriod, endPeriod, "NewSoftwareContracts", "A", "M", 2, "E:E", "null", reportingPeriod, "New Software Contracts", report); //begin period functioning as month


            RunSqlFromExcel.EndProc ep = new RunSqlFromExcel.EndProc();
            ep.EndProcMethod();
            return;
        }
Exemplo n.º 4
0
        public static void BillToNext(string beginPeriod, string report)
        {
            string reportingPeriod = null;

            System.Console.WriteLine("Compiling SC Contracts Data...");
            RunSqlFromExcel.DistributorClass dc = new RunSqlFromExcel.DistributorClass();
            dc.DistributorMethod(beginPeriod, "null", "SCContracts", "A", "D", 2, "E:E", "null", reportingPeriod, "Versants Data", report); //begin period functioning as month


            RunSqlFromExcel.EndProc ep = new RunSqlFromExcel.EndProc();
            ep.EndProcMethod();
            return;
        }
Exemplo n.º 5
0
        public static void SpecialInvoice(string beginPeriod, string report)
        {
            string reportingPeriod = null;

            System.Console.WriteLine("Compiling Invoice Data...");
            RunSqlFromExcel.DistributorClass dc = new RunSqlFromExcel.DistributorClass();
            dc.DistributorMethod(beginPeriod, "null", "SpecialInvoice", "A", "Z", 2, "P:S", "null", reportingPeriod, "Invoice", report);  //begin period functioning as ivoice number


            RunSqlFromExcel.EndProc ep = new RunSqlFromExcel.EndProc();
            ep.EndProcMethod();
            return;
        }
Exemplo n.º 6
0
        public static void Billing(string beginPeriod, string endPeriod)
        {
            string reportingPeriod = null;

            System.Console.WriteLine("Refreshing Billing Analysis report...");
            RunSqlFromExcel.DistributorClass dc = new RunSqlFromExcel.DistributorClass();
            dc.DistributorMethod(beginPeriod, endPeriod, "BillingAnalysis", "A", "X", 2, "Q:Q", "null", reportingPeriod, "BillingAnalysisData", "BillingAnalysisReport");


            RunSqlFromExcel.EndProc ep = new RunSqlFromExcel.EndProc();
            ep.EndProcMethod();
            return;
        }
Exemplo n.º 7
0
        static void Main(string[] args)
        {
            RunSqlFromExcel.EndProc e = new RunSqlFromExcel.EndProc();
            if (e.IsClientActive("MRC") != "Active")
            {
                System.Console.WriteLine("Account requires maintenance. Please contact Jared to authenticate.");
                System.Console.ReadLine();
                Environment.Exit(1);
            }

            //collect args
            System.Console.WriteLine("Starting...");

            string beginPeriod     = null;
            string endPeriod       = null;
            string reportingPeriod = null;
            string report          = null;

            try
            {
                beginPeriod     = args.GetValue(0).ToString();
                endPeriod       = args.GetValue(1).ToString();
                reportingPeriod = args.GetValue(2).ToString();
                report          = args.GetValue(3).ToString();
            }
            catch
            {
                System.Console.WriteLine("Error: VBA variables passed in incorrectly. Press any key to exit.");
                System.Console.ReadLine();
                Environment.Exit(1);
            }


            if (report == "BillingAnalysis")
            {
                Billing(beginPeriod, endPeriod);
                return;
            }

            if (report == "SpecialInvoice")
            {
                SpecialInvoice(beginPeriod, report);
                return;
            }


            if (report == "BillToNext")
            {
                BillToNext(beginPeriod, report);
                return;
            }

            if (report == "SoftwareRenewalsReport")
            {
                NewSoftwareContracts(beginPeriod, endPeriod, report);
                return;
            }

            if (report == "ISForRevBySiteVereco")
            {
                ISForRevBySiteVereco(beginPeriod, endPeriod, report);
                return;
            }

            if (report == "BaseAudit")
            {
                BaseAudit(beginPeriod, endPeriod, report);
                return;
            }



            //sql name                                                       //tab name
            System.Console.WriteLine("Refreshing IS For Rev By Site report...");
            //DistributorMethod(query input 1, query input 2, name of SQL string that lives in the getSQLClass class, column where the query is placed, last column the query occupies,
            //starting row of query, range that needs to be converted to number in excel, siteID, reportingPeriod, name of the tab to be pasted on, report Name


            RunSqlFromExcel.DistributorClass dc = new RunSqlFromExcel.DistributorClass();
            dc.DistributorMethod(beginPeriod, endPeriod, "ISForRevBySite", "A", "I", 2, "H:H", "null", reportingPeriod, "ISServiceCOGS", "null");

            System.Console.WriteLine("Refreshing Supplies Expense Report...");
            dc.DistributorMethod(beginPeriod, endPeriod, "SuppliesExpense", "A", "N", 2, "L:L", "null", reportingPeriod, "SuppliesExpense", "null");

            System.Console.WriteLine("Refreshing Daily Parts Usage Report...");
            // dc.DistributorMethod(beginPeriod, endPeriod, "DailyPartsUsagePivot", "A", "AV", 2, "M:M", "null", reportingPeriod, "DailyPartsUsagePivot");
            dc.DistributorMethod(beginPeriod, endPeriod, "DailyPartsUsage", "A", "E", 2, "E:E", "null", reportingPeriod, "DailyPartsUsage", "null");

            System.Console.WriteLine("Refreshing Labor Cost Report...");
            dc.DistributorMethod(beginPeriod, endPeriod, "LaborUsage", "A", "E", 2, "E:E", "null", reportingPeriod, "LaborData", "null");

            System.Console.WriteLine("Refreshing Supplies Revenue Report...");
            dc.DistributorMethod(beginPeriod, endPeriod, "SuppliesRevenue", "A", "I", 2, "I:I", "null", reportingPeriod, "SuppliesRevenue", "null");

            System.Console.WriteLine("Refreshing Supplies Revenue and Expense Report...");
            dc.DistributorMethod(beginPeriod, endPeriod, "SuppliesRevAndExp", "A", "D", 2, "D:D", "null", reportingPeriod, "SuppliesRevAndExp", "null");

            System.Console.WriteLine("Refreshing Tech Linkage Report...");
            dc.DistributorMethod(beginPeriod, endPeriod, "TechLinkage", "A", "M", 2, "N:N", "null", reportingPeriod, "TechTeam", "null");

            System.Console.WriteLine("Refreshing Equipment Revenue by Branch Report...");
            dc.DistributorMethod(beginPeriod, endPeriod, "EquipRevBySite", "A", "C", 2, "C:C", "null", reportingPeriod, "EquipRevBySite", "null");



            RunSqlFromExcel.EndProc ep = new RunSqlFromExcel.EndProc();
            ep.EndProcMethod();
        }