public void FillDatabaseServersFromSession()
{
DataTable DataServers = new DataTable();
try
{
if (Session["SharePointDatabaseList"] != null && Session["SharePointDatabaseList"] != "")
{
DataServers = Session["SharePointDatabaseList"] as DataTable;
}
DBServersGridView.DataSource = DataServers;
DBServersGridView.DataBind();
}
catch (Exception ex)
{
Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex);
throw ex;
}
}
protected void DBServersGridView_SelectionChanged(object sender, EventArgs e)
{
if (DBServersGridView.Selection.Count > 0)
{
if (Session["UserFullName"] != null)
{
List <object> fieldValues = DBServersGridView.GetSelectedFieldValues(new string[] { "redirectto" });
//7/22/2014 NS commented the line below, uncommented the following line - the page would auto redirect on each refresh
//Response.Redirect(fieldValues[0].ToString());
//Mukund: VSPLUS-844, Page redirect on callback
try
{
DevExpress.Web.ASPxWebControl.RedirectOnCallback(fieldValues[0].ToString());
Context.ApplicationInstance.CompleteRequest();//Mukund, 05Aug14, VSPLUS-844:Page redirect on callback
}
catch (Exception ex)
{
Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex);
//throw ex;
}
}
}
}
public void FillDatabaseServers()
{
DataTable dt = VSWebBL.DashboardBL.SharepointDetailsBL.Ins.GetDatabaseServerDetails();
Session["SharePointDatabaseList"] = dt;
DBServersGridView.DataSource = dt;
DBServersGridView.DataBind();
object sumObject;
sumObject = dt.Compute("Sum(DatabaseSiteCount)", "");
UsersLabel.Text = sumObject.ToString() + " Sites";
//DataRow rolerow;
DataRow[] foundRows;
DataRow SiteRow;
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
if (Spacelist.Rows.Count > 0)
{
foundRows = Spacelist.Select("AppName = '" + dt.Rows[i]["WebAppName"].ToString() + "'");
if (foundRows.Length == 0)
{
SiteRow = Spacelist.Rows.Add();
SiteRow["AppName"] = dt.Rows[i]["WebAppName"].ToString();
SiteRow["SiteCount"] = Convert.ToInt32(dt.Rows[i]["DatabaseSiteCount"].ToString());
SiteRow = Spacelist.NewRow();
}
else
{
//SiteRow = foundRows[0];
//SiteRow["SiteCount"] = Convert.ToInt32(SiteRow["SiteCount"].ToString());
}
}
else
{
SiteRow = Spacelist.Rows.Add();
SiteRow["AppName"] = dt.Rows[i]["WebAppName"].ToString();
SiteRow["SiteCount"] = Convert.ToInt32(dt.Rows[i]["DatabaseSiteCount"].ToString());
SiteRow = Spacelist.NewRow();
}
}
}
/*
* if (dt != null && dt.Rows.Count > 0)
* {
* for (int i = 0; i < dt.Rows.Count; i++)
* {
* if (Spacelist.Rows.Count > 0)
* {
* foundRows = Spacelist.Select("Memory = '" + memorydt.Rows[i]["ContentMemory"].ToString() + "'");
* if (foundRows.Length == 0)
* {
* Memoryrow = Spacelist.Rows.Add();
* Memoryrow["Memory"] = memorydt.Rows[i]["ContentMemory"].ToString() + "MB";
* Memoryrow["MemoryCount"] = 1;
* Memoryrow = Spacelist.NewRow();
* }
* else
* {
* Memoryrow = foundRows[0];
* Memoryrow["MemoryCount"] = Convert.ToInt32(Memoryrow["MemoryCount"].ToString() + "MB") + 1;
* }
* }
* else
* {
* Memoryrow = Spacelist.Rows.Add();
* Memoryrow["Memory"] = memorydt.Rows[i]["ContentMemory"].ToString() + "MB";
* Memoryrow["MemoryCount"] = 1;
* Memoryrow = Spacelist.NewRow();
* }
* }
* }
*/
}
