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;
}
}