-
Notifications
You must be signed in to change notification settings - Fork 0
/
Home.aspx.cs
120 lines (108 loc) · 3.87 KB
/
Home.aspx.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Data;
using System.Data.SqlClient;
using System.Web.UI.WebControls;
public partial class Home : System.Web.UI.Page
{
String UserId = "V820350";
//String UserId = Session["UserId"];
protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
{
//resetPanelsAndLabels();
DataAccessLayer dal = new DataAccessLayer();
DDL_AppName.DataSource = dal.getAppDetails(UserId);
DDL_AppName.DataTextField = "AppName";
DDL_AppName.DataValueField = "AppName";
DDL_AppName.DataBind();
}
}
private void resetPanelsAndLabels()
{
Panel_Databases.Visible = false;
Panel_SQLJobs.Visible = false;
PanelErrorMessages.Visible = false;
Panel_Statistics.Visible = false;
Label_ErrorMessage.Text = "";
}
protected void DDL_AppName_SelectedIndexChanged(object sender, EventArgs e)
{
DataAccessLayer dal = new DataAccessLayer();
DDL_ServerName.DataSource = dal.getServerIpDetails(DDL_AppName.SelectedValue);
DDL_ServerName.DataTextField = "ServerIp";
DDL_ServerName.DataValueField = "ServerIp";
DDL_ServerName.DataBind();
}
protected void Button_SQLJobs_Click(object sender, EventArgs e)
{
resetPanelsAndLabels();
DataAccessLayer dal = new DataAccessLayer();
String AppName = DDL_AppName.SelectedValue;
String ServerIp = DDL_ServerName.SelectedValue;
DataSet ds = dal.getSqlJobsByServerIp(ServerIp);
if(ds.Tables[0].Rows.Count > 0)
{
Panel_SQLJobs.Visible = true;
GridView_JobDetails.DataSource = ds;
GridView_JobDetails.DataBind();
}
else
{
PanelErrorMessages.Visible = true;
Label_ErrorMessage.Visible = true;
Label_ErrorMessage.Text = String.Format("There are no SQL jobs scheduled on the server: {0}",ServerIp);
}
}
protected void Button_Statistics_Click(object sender, EventArgs e)
{
resetPanelsAndLabels();
DataAccessLayer dal = new DataAccessLayer();
String AppName = DDL_AppName.SelectedValue;
String ServerIp = DDL_ServerName.SelectedValue;
DataSet ds = dal.getStatsByServerIp(ServerIp);
if (ds.Tables[0].Rows.Count > 0)
{
Panel_Statistics.Visible = true;
GridView_ServerStats.DataSource = ds;
GridView_ServerStats.DataBind();
}
else
{
PanelErrorMessages.Visible = true;
Label_ErrorMessage.Visible = true;
Label_ErrorMessage.Text = String.Format("There is some error while connecting to the server {0}", ServerIp);
}
}
protected void Button_Databases_Click(object sender, EventArgs e)
{
DataAccessLayer dal = new DataAccessLayer();
resetPanelsAndLabels();
DataTable databases = dal.getDatabaseNames();
if (databases.Rows.Count > 0)
{
Panel_Databases.Visible = true;
GridView_Databases.DataSource = databases;
GridView_Databases.DataBind();
}
else
{
PanelErrorMessages.Visible = true;
Label_ErrorMessage.Visible = true;
Label_ErrorMessage.Text = String.Format("There is some error while connecting to the server " );
}
//foreach (DataRow database in databases.Rows)
//{
// String databaseName = database.Field<String>("database_name");
// short dbID = database.Field<short>("dbid");
// DateTime creationDate = database.Field<DateTime>("create_date");
//}
}
protected void GridView_Databases_SelectedIndexChanged(object sender, EventArgs e)
{
}
}