public static void Main(string[] args) { //DataStorage DB = DataStorage.Instance; //bool status = false; //status = DB.PhoneBooks.FixBrokenContacts(); //status = status && true; AdLib ad = new AdLib(); AdUserInfo userInfo = ad.GetUserAttributes("*****@*****.**"); //string result = string.Empty; //result = DB.NumberingPlans.GetTypeOfServiceByNumber("+962795797572"); //result = result + ""; //var users_summaries = DB.UsersCallsSummaries.GetBySipAccount("*****@*****.**", startDate, endDate); //users_summaries = DB.UsersCallsSummaries.GetBySite("MOA", startDate, endDate, Globals.CallsSummary.GroupBy.UserAndInvoiceFlag); //users_summaries = DB.UsersCallsSummaries.GetByGateway("10.1.1.3"); //var first_user_summary = summaries.First(); //var sites_summaries = DB.SitesCallsSummaries.GetBySite("MOA", startDate, endDate); //var yearsForAAlhour = DB.UsersCallsSummaries.GetYearsBySipAccount("*****@*****.**"); //var siteSummaries = DB.SitesCallsSummaries.GetBySite("MOA"); //siteSummaries = DB.SitesCallsSummaries.GetBySite("MOA", startDate, endDate); //var departmensSummaries = DB.DepartmensCallsSummaries.GetByDepartment("MOA", "ISD"); //var departmentTotal = DB.DepartmensCallsSummaries.GetTotalByDepartment("MOA", "ISD"); //var siteDepartmensTotals = DB.DepartmensCallsSummaries.GetTotalsForEachDepartmentInSite("MOA"); //var MOA_Gateways_Summaries = DB.GatewaysCallsSummaries.GetBySite("MOA", groupBy: Globals.CallsSummaryForGateway.GroupBy.GatewayNameOnly); //var MOA_101012_Summaries = DB.GatewaysCallsSummaries.GetBySiteAndGateway("MOA", "10.1.0.12"); //var Gateways_Usage = DB.GatewaysCallsSummaries.GetUsageForAllGateways(startDate, endDate); //var Usage_Stats = DB.GatewaysCallsSummaries.GetGatewaysStatisticsResults(Gateways_Usage); //var topNumbers = DB.TopDestinationNumbers.GetBySipAccount("*****@*****.**", 10); //var topCountriesForUser = DB.TopDestinationCountries.GetByUser("*****@*****.**", 10); //var topCountriesForDepartment = DB.TopDestinationCountries.GetByDepartment("MOA", "ISD", 10); //var topCountriesForSite = DB.TopDestinationCountries.GetBySite("MOA", 10); //var mailReportsForUser = DB.MailReports.GetByUser("*****@*****.**", (new DateTime(2013, 10, 1))); //var mailReportForUser = DB.MailReports.GetTotalByUser("*****@*****.**", (new DateTime(2013, 10, 1))); //var mailReportForDepartment = DB.MailReports.GetByDepartment("MOA", "ISD", (new DateTime(2013, 10, 1))); //var userChartReports = DB.ChartsReports.GetByUser("*****@*****.**"); //var departmentChartReports = DB.ChartsReports.GetByDepartment("MOA", "ISD"); //var siteChartsReports = DB.ChartsReports.GetBySite("MOA"); //var gatewayChartsReports = DB.ChartsReports.GetByGateway("MOA", "10.1.0.12"); }