public void FillServerCombo() { string SqlQuery = ""; DataTable dt = new DataTable(); if (DeviceTypeComboBox.Text != "All" && DeviceTypeComboBox.Text != null) { // SqlQuery = "select Distinct DeviceName from DeviceDailyStats where DeviceType='" + DeviceTypeComboBox.Text + "'"; dt = VSWebBL.ReportsBL.ReportsBL.Ins.DeviceTypeComboBoxBL(DeviceTypeComboBox.Text); ServerComboBox.DataSource = dt; ServerComboBox.TextField = "DeviceName"; ServerComboBox.ValueField = "DeviceName"; ServerComboBox.DataBind(); } else { // SqlQuery = "select Distinct DeviceName from DeviceDailyStats"; dt = VSWebBL.ReportsBL.ReportsBL.Ins.DeviceTypeComboBoxforhistoricalresponseelsepartBL(); ServerComboBox.DataSource = dt; ServerComboBox.TextField = "DeviceName"; ServerComboBox.ValueField = "DeviceName"; ServerComboBox.DataBind(); } //dt = ds.Tables[0]; //ServerComboBox.DataSourceID = ""; //ServerComboBox.DataSource = dt; //ServerComboBox.TextField = "DeviceName"; //ServerComboBox.ValueField = "DeviceName"; //ServerComboBox.DataBind(); }
public void fillcombosrv() { DataTable d = new DataTable(); d = VSWebBL.ReportsBL.ReportsBL.Ins.GetDominoDBStatsSrv(); ServerComboBox.DataSource = d; ServerComboBox.TextField = "Server"; ServerComboBox.ValueField = "Server"; ServerComboBox.DataBind(); }
public void fillcombo(string statname1) { DataTable dt = new DataTable(); dt = VSWebBL.ReportsBL.ReportsBL.Ins.GetIBMConnectionsServerlist(statname1); ServerComboBox.DataSource = dt; ServerComboBox.TextField = "ServerName"; ServerComboBox.ValueField = "ServerName"; ServerComboBox.DataBind(); }
public void fillcombo() { DataTable dt = new DataTable(); string BType = ""; BType = "NUM_OF_BOOKMARKS_BOOKMARKS_CREATED_YESTERDAY"; dt = VSWebBL.ReportsBL.ReportsBL.Ins.GetIBMConnectionsServerlist(BType); ServerComboBox.DataSource = dt; ServerComboBox.TextField = "ServerName"; ServerComboBox.ValueField = "ServerName"; ServerComboBox.DataBind(); }
public void fillcombo() { DataTable dt = new DataTable(); string Activity = ""; if (ActivityTypeCombobox.Items.Count > 0) { Activity = ActivityTypeCombobox.SelectedItem.Value.ToString(); dt = VSWebBL.ReportsBL.ReportsBL.Ins.GetIBMConnectionsServerlist(Activity); ServerComboBox.DataSource = dt; ServerComboBox.TextField = "ServerName"; ServerComboBox.ValueField = "ServerName"; ServerComboBox.DataBind(); } }
public void fillservercombo() { string FType = ""; if (FileTypeComboBox.Items.Count > 0) { DataTable dt = new DataTable(); FType = FileTypeComboBox.SelectedItem.Value.ToString(); dt = VSWebBL.ReportsBL.ReportsBL.Ins.GetIBMConnectionsServerlist(FType); ServerComboBox.DataSource = dt; ServerComboBox.TextField = "ServerName"; ServerComboBox.ValueField = "ServerName"; ServerComboBox.DataBind(); } }
public void fillcombo() { DataTable dt = new DataTable(); dt = VSWebBL.ReportsBL.ReportsBL.Ins.GetIBMConnectionsServerlist(""); ServerComboBox.DataSource = dt; ServerComboBox.TextField = "ServerName"; ServerComboBox.ValueField = "ServerName"; ServerComboBox.DataBind(); if (dt.Rows.Count > 0) { ServerComboBox.SelectedIndex = 0; selectedServer = ServerComboBox.SelectedItem.Text; } }
public void fillServersCombo() { DataTable dt = new DataTable(); //string Community = ""; //if (ServerListFilterComboBox.Items.Count > 0) //{ //Community = ServerListFilterComboBox.SelectedItem.Value.ToString(); ServerComboBox.SelectedIndex = 0; dt = VSWebBL.ReportsBL.ReportsBL.Ins.GetIBMConnectionsServers(); ServerComboBox.DataSource = dt; ServerComboBox.TextField = "ServerName"; ServerComboBox.ValueField = "ServerName"; ServerComboBox.DataBind(); //} }
public void serverCombo() { DataTable dt = new DataTable(); dt = VSWebBL.DashboardBL.mailFileBL.Ins.FillServerCombobox(); DataRow dr = dt.NewRow(); dr[0] = "All Servers"; dt.Rows.InsertAt(dr, 0); dt = dt.DefaultView.ToTable(true, "Server"); ServerComboBox.DataSource = dt; ServerComboBox.TextField = "Server"; ServerComboBox.ValueField = "Server"; ServerComboBox.DataBind(); ServerComboBox.SelectedIndex = 0; }
protected void DeviceTypeComboBox_SelectedIndexChanged(object sender, EventArgs e) { ServerComboBox.Text = ""; DataTable dt = new DataTable(); if (GraphCombobox.Text == "Today" || GraphCombobox.Text == "Two Days") { if (DeviceTypeComboBox.SelectedItem.ToString() == "NotesMail") { // ServerComboBox.DataSourceID = "SqlDataSource2"; dt = VSWebBL.ReportsBL.ReportsBL.Ins.fillNotesMailStatsBL(); ServerComboBox.DataSource = dt; ServerComboBox.TextField = "Name"; ServerComboBox.ValueField = "Name"; ServerComboBox.DataBind(); } else if (DeviceTypeComboBox.SelectedItem.ToString() == "BlackBerry") { dt = VSWebBL.ReportsBL.ReportsBL.Ins.fillBlackBerryProbeStatsBL(); // ServerComboBox.DataSourceID = "SqlDataSource3"; ServerComboBox.DataSource = dt; ServerComboBox.TextField = "Name"; ServerComboBox.ValueField = "Name"; ServerComboBox.DataBind(); } else if (DeviceTypeComboBox.Text == "All") { //ServerComboBox.DataSourceID = "SqlDataSource1"; //ServerComboBox.TextField = "DeviceName"; //ServerComboBox.ValueField = "DeviceName"; //ServerComboBox.DataBind(); FillDeviceTypeCombo(); } else { FillServerCombo(); } } else { FillServerCombo(); } }
public void serverCombo() { DataTable dt = new DataTable(); dt = VSWebBL.DashboardBL.ExchangeMailFileBL.Ins.FillServerCombobox(); DataRow dr = dt.NewRow(); dr[0] = "All Servers"; dt.Rows.InsertAt(dr, 0); dt = dt.DefaultView.ToTable(true, "Server"); ServerComboBox.DataSource = dt; ServerComboBox.TextField = "Server"; ServerComboBox.ValueField = "Server"; ServerComboBox.DataBind(); ServerComboBox.SelectedIndex = 0; ItemSizeServercombobox.DataSource = dt; ItemSizeServercombobox.TextField = "Server"; ItemSizeServercombobox.ValueField = "Server"; ItemSizeServercombobox.DataBind(); ItemSizeServercombobox.SelectedIndex = 0; DataTable dt2 = new DataTable(); dt2 = VSWebBL.DashboardBL.ExchangeMailFileBL.Ins.FillDBCombobox(); DataRow dr2 = dt2.NewRow(); dr2[0] = "All Databases"; dt2.Rows.InsertAt(dr2, 0); dt2 = dt2.DefaultView.ToTable(true, "Database"); MBSizeDatabasecombobox.DataSource = dt2; MBSizeDatabasecombobox.TextField = "Database"; MBSizeDatabasecombobox.ValueField = "Database"; MBSizeDatabasecombobox.DataBind(); MBSizeDatabasecombobox.SelectedIndex = 0; ItemSizeDatabaseComboBox.DataSource = dt2; ItemSizeDatabaseComboBox.TextField = "Database"; ItemSizeDatabaseComboBox.ValueField = "Database"; ItemSizeDatabaseComboBox.DataBind(); ItemSizeDatabaseComboBox.SelectedIndex = 0; }
public void FillGraph() { // DataTable dt = new DataTable(); if (StartDateEdit.Text == "") { StartDateEdit.Text = DateTime.Now.ToShortDateString(); } if (EndDateEdit.Text == "") { EndDateEdit.Text = DateTime.Now.ToShortDateString(); } // Today try { if (GraphCombobox.Text == "Today") { //DeviceTypeComboBox.SelectedIndex == 0 && //ServerComboBox.DataSourceID = "SqlDataSource1"; //ServerComboBox.TextField = "DeviceName"; //ServerComboBox.ValueField = "DeviceName"; //ServerComboBox.DataBind(); FillServerCombo(); if (this.ServerComboBox.SelectedIndex >= 0) { selectedServer = this.ServerComboBox.SelectedItem.Value.ToString(); } StartDateEdit.Enabled = false; EndDateEdit.Enabled = false; DashboardReports.HR1rpt report = new DashboardReports.HR1rpt(); report.Parameters["MyDevice"].Value = selectedServer; report.Parameters["StartDate"].Value = DateTime.Now.AddDays(-1); //StartDateEdit.Text; report.Parameters["EndDate"].Value = DateTime.Now; //EndDateEdit.Text; this.ReportViewer1.Report = report; this.ReportViewer1.DataBind(); } } catch (Exception) { throw; } try { if (DeviceTypeComboBox.Text == "NotesMail" && GraphCombobox.Text == "Today") { // ServerComboBox.DataSourceID = "SqlDataSource2"; DataTable dt = new DataTable(); dt = VSWebBL.ReportsBL.ReportsBL.Ins.fillNotesMailStatsBL(); ServerComboBox.DataSource = dt; ServerComboBox.TextField = "Name"; ServerComboBox.ValueField = "Name"; ServerComboBox.DataBind(); if (this.ServerComboBox.SelectedIndex >= 0) { selectedServer = this.ServerComboBox.SelectedItem.Value.ToString(); } StartDateEdit.Enabled = false; EndDateEdit.Enabled = false; DashboardReports.Hrs2NotesMail report = new DashboardReports.Hrs2NotesMail(); report.Parameters["MyDevice"].Value = selectedServer; report.Parameters["StartDate"].Value = DateTime.Now.AddDays(-1); //StartDateEdit.Text; report.Parameters["EndDate"].Value = DateTime.Now; //EndDateEdit.Text; this.ReportViewer1.Report = report; this.ReportViewer1.DataBind(); } } catch (Exception) { throw; } try { if (DeviceTypeComboBox.Text == "BlackBerry" && GraphCombobox.Text == "Today") { // ServerComboBox.DataSourceID = "SqlDataSource3"; DataTable d = new DataTable(); d = VSWebBL.ReportsBL.ReportsBL.Ins.fillBlackBerryProbeStatsBL(); ServerComboBox.DataSource = d; ServerComboBox.TextField = "Name"; ServerComboBox.ValueField = "Name"; ServerComboBox.DataBind(); if (this.ServerComboBox.SelectedIndex >= 0) { selectedServer = this.ServerComboBox.SelectedItem.Value.ToString(); } StartDateEdit.Enabled = false; EndDateEdit.Enabled = false; DashboardReports.hr3BlackBerryRpt report = new DashboardReports.hr3BlackBerryRpt(); report.Parameters["MyDevice"].Value = selectedServer; report.Parameters["StartDate"].Value = DateTime.Now.AddDays(-1); // StartDateEdit.Text; report.Parameters["EndDate"].Value = DateTime.Now; // EndDateEdit.Text; this.ReportViewer1.Report = report; this.ReportViewer1.DataBind(); } } catch (Exception) { throw; } //Two Days try { if (GraphCombobox.Text == "Two Days") { //ServerComboBox.DataSourceID = "SqlDataSource1"; //ServerComboBox.TextField = "DeviceName"; //ServerComboBox.ValueField = "DeviceName"; //ServerComboBox.DataBind(); FillServerCombo(); if (this.ServerComboBox.SelectedIndex >= 0) { selectedServer = this.ServerComboBox.SelectedItem.Value.ToString(); } StartDateEdit.Enabled = false; EndDateEdit.Enabled = false; DashboardReports.Hr4DeviceDailyStatsRpt report = new DashboardReports.Hr4DeviceDailyStatsRpt(); report.Parameters["MyDevice"].Value = selectedServer; report.Parameters["StartDate"].Value = DateTime.Now.AddDays(-2); //StartDateEdit.Text; report.Parameters["EndDate"].Value = DateTime.Now; //EndDateEdit.Text; this.ReportViewer1.Report = report; this.ReportViewer1.DataBind(); } } catch (Exception) { throw; } try { if (DeviceTypeComboBox.Text == "NotesMail" && GraphCombobox.Text == "Two Days") { // ServerComboBox.DataSourceID = "SqlDataSource2"; DataTable t = new DataTable(); t = VSWebBL.ReportsBL.ReportsBL.Ins.fillNotesMailStatsBL(); ServerComboBox.DataSource = t; ServerComboBox.TextField = "Name"; ServerComboBox.ValueField = "Name"; ServerComboBox.DataBind(); if (this.ServerComboBox.SelectedIndex >= 0) { selectedServer = this.ServerComboBox.SelectedItem.Value.ToString(); } StartDateEdit.Enabled = false; EndDateEdit.Enabled = false; DashboardReports.hr5NotesMailRpt report = new DashboardReports.hr5NotesMailRpt(); report.Parameters["MyDevice"].Value = selectedServer; report.Parameters["StartDate"].Value = DateTime.Now.AddDays(-2); //StartDateEdit.Text; report.Parameters["EndDate"].Value = DateTime.Now; //EndDateEdit.Text; this.ReportViewer1.Report = report; this.ReportViewer1.DataBind(); } } catch (Exception) { throw; } try { if (DeviceTypeComboBox.Text == "BlackBerry" && GraphCombobox.Text == "Two Days") { // ServerComboBox.DataSourceID = "SqlDataSource3"; DataTable d = new DataTable(); d = VSWebBL.ReportsBL.ReportsBL.Ins.fillBlackBerryProbeStatsBL(); ServerComboBox.DataSource = d; ServerComboBox.TextField = "Name"; ServerComboBox.ValueField = "Name"; ServerComboBox.DataBind(); if (this.ServerComboBox.SelectedIndex >= 0) { selectedServer = this.ServerComboBox.SelectedItem.Value.ToString(); } StartDateEdit.Enabled = false; EndDateEdit.Enabled = false; DashboardReports.HR10AvgresponseTime report = new DashboardReports.HR10AvgresponseTime(); report.Parameters["MyDevice"].Value = selectedServer; report.Parameters["StartDate"].Value = DateTime.Now.AddDays(-2); //StartDateEdit.Text; report.Parameters["EndDate"].Value = DateTime.Now; //EndDateEdit.Text; this.ReportViewer1.Report = report; this.ReportViewer1.DataBind(); } } catch (Exception) { throw; } // ********* Daily try { if (GraphCombobox.Text == "Daily") { //ServerComboBox.DataSourceID = "SqlDataSource1"; //ServerComboBox.TextField = "DeviceName"; //ServerComboBox.ValueField = "DeviceName"; //ServerComboBox.DataBind(); FillServerCombo(); if (this.ServerComboBox.SelectedIndex >= 0) { selectedServer = this.ServerComboBox.SelectedItem.Value.ToString(); } DashboardReports.Hr6DailyDeviceRpt report = new DashboardReports.Hr6DailyDeviceRpt(); report.Parameters["MyDevice"].Value = selectedServer; report.Parameters["StartDate"].Value = StartDateEdit.Text; report.Parameters["EndDate"].Value = EndDateEdit.Text; this.ReportViewer1.Report = report; this.ReportViewer1.DataBind(); } } catch (Exception) { throw; } try { if (GraphCombobox.Text == "Daily" && (DeviceTypeComboBox.Text == "NotesMail" || DeviceTypeComboBox.Text == "BlackBerry")) { //ServerComboBox.DataSourceID = "SqlDataSource1"; //ServerComboBox.TextField = "DeviceName"; //ServerComboBox.ValueField = "DeviceName"; //ServerComboBox.DataBind(); FillServerCombo(); if (this.ServerComboBox.SelectedIndex >= 0) { selectedServer = this.ServerComboBox.SelectedItem.Value.ToString(); } DashboardReports.Hr7NotesMailDailyRpt report = new DashboardReports.Hr7NotesMailDailyRpt(); report.Parameters["MyDevice"].Value = selectedServer; report.Parameters["StartDate"].Value = StartDateEdit.Text; report.Parameters["EndDate"].Value = EndDateEdit.Text; this.ReportViewer1.Report = report; this.ReportViewer1.DataBind(); } } catch (Exception) { throw; } //------------weekly try { if (GraphCombobox.Text == "Weekly") { //ServerComboBox.DataSourceID = "SqlDataSource1"; //ServerComboBox.TextField = "DeviceName"; //ServerComboBox.ValueField = "DeviceName"; //ServerComboBox.DataBind(); FillServerCombo(); if (this.ServerComboBox.SelectedIndex >= 0) { selectedServer = this.ServerComboBox.SelectedItem.Value.ToString(); } DashboardReports.hr8DeviceDailyStatsforweeklyRpt report = new DashboardReports.hr8DeviceDailyStatsforweeklyRpt(); report.Parameters["MyDevice"].Value = selectedServer; report.Parameters["StartDate"].Value = StartDateEdit.Text; report.Parameters["EndDate"].Value = EndDateEdit.Text; this.ReportViewer1.Report = report; this.ReportViewer1.DataBind(); } } catch (Exception) { throw; } try { if ((DeviceTypeComboBox.Text == "BlackBerry" || DeviceTypeComboBox.Text == "NotesMail") && GraphCombobox.Text == "Weekly") { //ServerComboBox.DataSourceID = "SqlDataSource1"; //ServerComboBox.TextField = "DeviceName"; //ServerComboBox.ValueField = "DeviceName"; //ServerComboBox.DataBind(); FillServerCombo(); if (this.ServerComboBox.SelectedIndex >= 0) { selectedServer = this.ServerComboBox.SelectedItem.Value.ToString(); } DashboardReports.hr9NotesMailTimeAvarageRpt report = new DashboardReports.hr9NotesMailTimeAvarageRpt(); report.Parameters["MyDevice"].Value = selectedServer; report.Parameters["StartDate"].Value = StartDateEdit.Text; report.Parameters["EndDate"].Value = EndDateEdit.Text; this.ReportViewer1.Report = report; this.ReportViewer1.DataBind(); } } catch (Exception) { throw; } //----------------monthly try { if (GraphCombobox.Text == "Monthly") { //ServerComboBox.DataSourceID = "SqlDataSource1"; //ServerComboBox.TextField = "DeviceName"; //ServerComboBox.ValueField = "DeviceName"; //ServerComboBox.DataBind(); FillServerCombo(); if (this.ServerComboBox.SelectedIndex >= 0) { selectedServer = this.ServerComboBox.SelectedItem.Value.ToString(); } DashboardReports.HR11MonthlyRpt report = new DashboardReports.HR11MonthlyRpt(); report.Parameters["MyDevice"].Value = selectedServer; report.Parameters["StartDate"].Value = StartDateEdit.Text; report.Parameters["EndDate"].Value = EndDateEdit.Text; this.ReportViewer1.Report = report; this.ReportViewer1.DataBind(); } } catch (Exception) { throw; } }