private void LoadGrid()
{
// Create a new grid that displays all
// dashboard items of the client.
grid = new Grid();
grid.ID = "gridDashboardItems";
grid.MaxHeight = base.ContentHeight - 200;
GridHeadline headline = new GridHeadline(grid);
headline.Items.Add(new GridHeadlineItem(headline, 0, Global.LanguageManager.GetText("DashboardItemTitle"), new GridHeadlineItemWidth(15)));
headline.Items.Add(new GridHeadlineItem(headline, 1, Global.LanguageManager.GetText("DashboardItemSource"), new GridHeadlineItemWidth(50)));
headline.Items.Add(new GridHeadlineItem(headline, 2, Global.LanguageManager.GetText("DashboardItemCreator"), new GridHeadlineItemWidth(15)));
headline.Items.Add(new GridHeadlineItem(headline, 3, Global.LanguageManager.GetText("DashboardItemCreationDate"), new GridHeadlineItemWidth(20)));
grid.GridHeadline = headline;
// Build the full path to the directory where
// the client's dashboard items are stored.
string directoryName = Path.Combine(
Request.PhysicalApplicationPath,
"Fileadmin",
"DashboardItems",
Global.Core.ClientName
);
// Check if the client has any dashboard items defined.
if (!Directory.Exists(directoryName))
{
Directory.CreateDirectory(directoryName);
}
// Run through all dashboard items of the client.
foreach (string fileName in Directory.GetFiles(directoryName))
{
// Create a new dashboard item by
// the dashboard item definition file.
DashboardItem info = new DashboardItem(fileName);
// Create a new grid row for the dashboard item.
GridRow row = new GridRow(grid, info.Id);
row.Items.Add(new GridRowItem(row, info.Name, true));
row.Items.Add(new GridRowItem(row, HttpUtility.UrlDecode(info.Source), true));
row.Items.Add(new GridRowItem(row, Global.GetNiceUsername(info.IdUser), true));
row.Items.Add(new GridRowItem(row, info.CreationDate.ToFormattedString(), true));
grid.Rows.Add(row);
}
pnlGrid.Controls.Add(grid);
}
public void BuildGrid()
{
this.Grid.ID = this.ID + "_Grid";
// Create the grid headline by the given fields as language labels.
GridHeadline gridHeadline = new GridHeadline(this.Grid);
int i = 0;
// Run through all grid field names in the sorting.
foreach (string fieldName in this.GridFieldsSorting)
{
if (this.GridFields.ContainsKey(fieldName))
{
GridHeadlineItemWidth fieldWidth = this.GridFields[fieldName];
// Create a new headline item.
GridHeadlineItem headlineItem = new GridHeadlineItem(
gridHeadline,
i++,
fieldName,
fieldWidth,
true
);
// Add the headline item to the grid headline.
gridHeadline.Items.Add(headlineItem);
}
else if (this.AdditionalFields.Find(x => x.Name == fieldName) != null)
{
AdditionalField <T> field = this.AdditionalFields.Find(x => x.Name == fieldName);
if (!field.ShowInGrid)
{
continue;
}
gridHeadline.Items.Add(new GridHeadlineItem(
gridHeadline,
i++,
field.Name,
field.Width,
true
));
}
}
// Set the grids headline.
this.Grid.GridHeadline = gridHeadline;
// Run through all items.
foreach (BaseItem <T> item in this.Items)
{
// Create a new grid row for the item.
GridRow row = new GridRow(this.Grid, item.Id);
// Run through all grid field names in the sorting.
foreach (string fieldName in this.GridFieldsSorting)
{
if (this.GridFields.ContainsKey(fieldName))
{
// Get the items value of the field.
object value = item.GetValue(fieldName);
// Add the formated value as grid row item to the row.
row.Items.Add(new GridRowItem(row, Format(value)));
}
else if (this.AdditionalFields.Find(x => x.Name == fieldName) != null)
{
AdditionalField <T> field = this.AdditionalFields.Find(x => x.Name == fieldName);
if (!field.ShowInGrid)
{
continue;
}
// Get the items value of the field.
object value = field.GetValue.Invoke(item);
// Create a new row item with the formated value.
GridRowItem rowItem = new GridRowItem(row, Format(value));
// Add the row item to the grid row.
row.Items.Add(rowItem);
// Check if a background is set for this row.
if (this.GridRowBackgrounds.ContainsKey(item.Id + field.Name))
{
// Set the row's background color.
//row.Style.Add("background", this.GridRowBackgrounds[item.Id]);
rowItem.Style.Add("background", this.GridRowBackgrounds[item.Id + field.Name]);
rowItem.Style.Add("color", "#000000");
}
}
}
// Add the row to the grid's rows.
this.Grid.Rows.Add(row);
}
}
private void GetUsers()
{
try
{
gridUsers = new Grid {
ID = "gridUsers"
};
var headline = new GridHeadline(gridUsers);
headline.Items.Add(new GridHeadlineItem(headline, 0, "user name", new GridHeadlineItemWidth(20)));
headline.Items.Add(new GridHeadlineItem(headline, 1, "email id", new GridHeadlineItemWidth(20)));
headline.Items.Add(new GridHeadlineItem(headline, 2, "client", new GridHeadlineItemWidth(20)));
headline.Items.Add(new GridHeadlineItem(headline, 3, "date", new GridHeadlineItemWidth(20)));
headline.Items.Add(new GridHeadlineItem(headline, 4, "roles", new GridHeadlineItemWidth(10)));
headline.Items.Add(new GridHeadlineItem(headline, 5, "browser", new GridHeadlineItemWidth(10)));
gridUsers.GridHeadline = headline;
ApplicationUtilities.UsageLogger logger = new ApplicationUtilities.UsageLogger(
Global.Core.ClientName,
Global.User
);
//object[] user = logger.SelectSingle("SELECT Id FROM Variables WHERE Name={0}", "Users");
//object[] email = logger.SelectSingle("SELECT Id FROM Variables WHERE Name={0}", "EmailId");
//object[] login = logger.SelectSingle("SELECT Id FROM Variables WHERE Name={0}", "Login");
//object[] client = logger.SelectSingle("SELECT Id FROM Variables WHERE Name={0}", "Clients");
//object[] roles = logger.SelectSingle("SELECT Id FROM Variables WHERE Name={0}", "Roles");
//object[] browsers = logger.SelectSingle("SELECT Id FROM Variables WHERE Name={0}", "Browser");
List <object[]> respondent;
if (ConfigurationManager.AppSettings["AdminPortal"] != null)
{
if (Global.Core.ClientName.ToLower() == ConfigurationManager.AppSettings["AdminPortal"])
{
respondent = logger.ExecuteReader(string.Format(
@"SELECT [Id] ,[UserName],[EmailId],[Client],CONVERT(varchar,[Login],103)+' '+CONVERT(char(8),[Login],108) AS [Date],[Role],[Browser] FROM UsageLog ORDER BY [Date]"));
}
else
{
respondent = logger.ExecuteReader(string.Format(
@"SELECT [Id] ,[UserName],[EmailId],[Client],CONVERT(varchar,[Login],103)+' '+CONVERT(char(8),[Login],108) AS [Date],[Role],[Browser] FROM UsageLog WHERE [Client]='{0}' ORDER BY [Date] ", Global.Core.ClientName));
}
}
else
{
respondent = logger.ExecuteReader(string.Format(
@"SELECT [Id] ,[UserName],[EmailId],[Client],CONVERT(varchar,[Login],103)+' '+CONVERT(char(8),[Login],108) AS [Date],[Role],[Browser] FROM UsageLog WHERE [Client]='{0}' ORDER BY [Date] ", Global.Core.ClientName));
}
if (respondent != null)
{
foreach (var useritem in respondent)
{
var row = new GridRow(gridUsers, useritem[0]);
var name = new GridRowItem(row, useritem[1].ToString());
var emailid = new GridRowItem(row, useritem[2].ToString());
var clientname = new GridRowItem(row, useritem[3].ToString());
var date = new GridRowItem(row, useritem[4].ToString());
var role = new GridRowItem(row, useritem[5].ToString());
var browser = new GridRowItem(row, useritem[6].ToString());
row.Items.Add(name);
row.Items.Add(emailid);
row.Items.Add(clientname);
row.Items.Add(date);
row.Items.Add(role);
row.Items.Add(browser);
gridUsers.Rows.Add(row);
}
pnlUserManagement.Controls.Add(gridUsers);
}
}
catch (Exception ex)
{
HttpContext.Current.Session["Error"] = ex.Message;
Response.Redirect("/Pages/ErrorPage.aspx");
}
}
private void CreateGridNews()
{
try
{
gridNews = new Grid {
ID = "gridNews"
};
GridHeadline headline = new GridHeadline(gridNews);
headline.Items.Add(new GridHeadlineItem(headline, 0, "news heading", new GridHeadlineItemWidth(20)));
headline.Items.Add(new GridHeadlineItem(headline, 1, "news description", new GridHeadlineItemWidth(60)));
headline.Items.Add(new GridHeadlineItem(headline, 2, "created user", new GridHeadlineItemWidth(10)));
headline.Items.Add(new GridHeadlineItem(headline, 3, "created date", new GridHeadlineItemWidth(10)));
gridNews.GridHeadline = headline;
NewsManager newsManager = new NewsManager();
// Get the Clients XML file
//string fileName = Path.Combine(Request.PhysicalApplicationPath, "App_Data", "News", "News.xml");
string fileName = Path.Combine(Request.PhysicalApplicationPath, "Fileadmin", "News", Global.Core.ClientName + ".xml");
newsManager.FileName = fileName;
XmlNodeList xmlNewsList = newsManager.GetNewsAll(Global.Core.ClientName);
if (xmlNewsList != null)
{
foreach (XmlNode xn in xmlNewsList)
{
var xmlElement = xn;
if (xmlElement != null)
{
GridRow row = new GridRow(gridNews, xmlElement.Attributes["Id"].Value);
GridRowItem itemHeading = new GridRowItem(row, xmlElement.Attributes["Heading"].Value);
itemHeading.Width = 20;
GridRowItem itemDesc = new GridRowItem(row, xmlElement.Attributes["Description"].Value);
itemDesc.Width = 40;
itemDesc.CssClass = "gridWrap";
string name = "";
if (xmlElement.Attributes["UserId"] != null)
{
User user = null;
user = Global.Core.Users.GetSingle(Guid.Parse(xmlElement.Attributes["UserId"].Value.Trim()));
if (user != null)
{
name = user.FirstName + " " + user.LastName;
}
}
GridRowItem itemUser = new GridRowItem(row, name);
itemUser.Width = 20;
GridRowItem itemMc = xmlElement.Attributes["CreatedDate"] != null ? new GridRowItem(row, Convert.ToDateTime(xmlElement.Attributes["CreatedDate"].Value).ToString("MM-dd-yyyy")) : new GridRowItem(row, "");
itemMc.Width = 20;
row.Items.Add(itemHeading);
row.Items.Add(itemDesc);
row.Items.Add(itemUser);
row.Items.Add(itemMc);
gridNews.Rows.Add(row);
}
}
}
pnlnewsManagement.Controls.Add(gridNews);
if (HttpContext.Current.Session["newsId"] != null)
{
gridNews.SelectedItem = HttpContext.Current.Session["newsId"].ToString();
}
if (gridNews.SelectedItem == null || gridNews.SelectedItem.ToString() != string.Empty)
{
if (gridNews.Rows.Count != 0)
{
gridNews.SelectedItem = gridNews.Rows[0].Identity;
}
}
}
catch (Exception ex)
{
HttpContext.Current.Session["Error"] = ex.Message;
Response.Redirect("/Pages/ErrorPage.aspx");
}
}
private void BindBackups()
{
// Build the full path to the client's client backups definition file.
string fileName = Path.Combine(
Request.PhysicalApplicationPath,
"Fileadmin",
"ClientBackups",
Global.Core.ClientName + ".xml"
);
if (!Directory.Exists(Path.GetDirectoryName(fileName)))
{
Directory.CreateDirectory(Path.GetDirectoryName(fileName));
}
if (!File.Exists(fileName))
{
File.WriteAllText(fileName, string.Format(
"<ClientBackups Client=\"{0}\"></ClientBackups>",
Global.Core.ClientName
));
}
// Create a new client backup collection which
// contains information of the client's backups.
ClientBackupCollection clientBackups = new ClientBackupCollection(
Global.Core.ClientName,
fileName
);
gridBackups = new Grid();
gridBackups.ID = "gridBackups";
gridBackups.MaxHeight = base.ContentHeight - 200;
GridHeadline headline = new GridHeadline(gridBackups);
headline.Items.Add(new GridHeadlineItem(headline, 0, Global.LanguageManager.GetText("User"), new GridHeadlineItemWidth(40)));
headline.Items.Add(new GridHeadlineItem(headline, 1, Global.LanguageManager.GetText("CreationDate"), new GridHeadlineItemWidth(40)));
headline.Items.Add(new GridHeadlineItem(headline, 1, Global.LanguageManager.GetText("Status"), new GridHeadlineItemWidth(20)));
gridBackups.GridHeadline = headline;
Dictionary <Guid, string> studies = new Dictionary <Guid, string>();
// Run through all client backups.
foreach (ClientBackup clientBackup in clientBackups)
{
GridRow row = new GridRow(gridBackups, clientBackup.Id);
string statusStr = "";
if (clientBackup.Status == ClientBackupStatus.Running)
{
statusStr = "<span class=\"Color2\" style=\"font-weight:bold;\">" + Global.LanguageManager.GetText(clientBackup.Status.ToString()) + "</span>";
}
else if (clientBackup.Status == ClientBackupStatus.Failed)
{
statusStr = "<span onclick=\"ShowJavascriptBox('boxClientBackupError', '" + HttpUtility.HtmlEncode(clientBackup.XmlNode.InnerXml).Replace(Environment.NewLine, "") +
"', undefined, false, 'ClientBackupErrorDetail');\" style=\"color:#FF0000;font-weight:bold;text-decoration:underline;cursor:pointer;\">" + Global.LanguageManager.GetText(clientBackup.Status.ToString()) + "</span>";
}
else
{
statusStr = clientBackup.Status.ToString();
}
row.Items.Add(new GridRowItem(row, Global.GetNiceUsername(clientBackup.IdUser), false));
row.Items.Add(new GridRowItem(row, clientBackup.CreationDate.ToString(
Global.LanguageManager.GetText("DateFormat") + " " +
Global.LanguageManager.GetText("TimeFormat")
), false));
row.Items.Add(new GridRowItem(row, statusStr, true));
gridBackups.Rows.Add(row);
}
pnlClientBackups.Controls.Add(gridBackups);
}
private void CreateGridUsers()
{
try
{
gridUsers = new Grid {
ID = "gridUsers"
};
var headline = new GridHeadline(gridUsers);
headline.Items.Add(new GridHeadlineItem(headline, 0, "name", new GridHeadlineItemWidth(15)));
headline.Items.Add(new GridHeadlineItem(headline, 1, "first name", new GridHeadlineItemWidth(20)));
headline.Items.Add(new GridHeadlineItem(headline, 2, "last name", new GridHeadlineItemWidth(20)));
headline.Items.Add(new GridHeadlineItem(headline, 3, "email", new GridHeadlineItemWidth(20)));
headline.Items.Add(new GridHeadlineItem(headline, 4, "phone", new GridHeadlineItemWidth(15)));
headline.Items.Add(new GridHeadlineItem(headline, 5, "user group", new GridHeadlineItemWidth(10)));
gridUsers.GridHeadline = headline;
var users = Global.Core.Users.Get();
if (users != null)
{
foreach (var useritem in users)
{
var userRole = Global.Core.UserRoles.GetSingle("IdUser", useritem.Id);
var role = Global.Core.Roles.GetSingle("Id", userRole.IdRole);
object idRoleUser = Global.Core.UserRoles.GetValue("IdRole", "IdUser", Global.IdUser.Value);
if (idRoleUser == null)
{
idRoleUser = new Guid();
}
if (role.Hidden && (Guid)idRoleUser != role.Id)
{
continue;
}
var row = new GridRow(gridUsers, useritem.Id);
var name = new GridRowItem(row, useritem.Name);
var fName = new GridRowItem(row, useritem.FirstName);
var lName = new GridRowItem(row, useritem.LastName);
var eMail = new GridRowItem(row, useritem.Mail);
var phone = new GridRowItem(row, useritem.Phone);
row.Items.Add(name);
row.Items.Add(fName);
row.Items.Add(lName);
row.Items.Add(eMail);
row.Items.Add(phone);
if (userRole != null)
{
var itemrole = new GridRowItem(row, role.Name);
row.Items.Add(itemrole);
}
else
{
var itemrole = new GridRowItem(row, "not assigned");
row.Items.Add(itemrole);
}
gridUsers.Rows.Add(row);
}
pnlUserManagement.Controls.Add(gridUsers);
}
}
catch (Exception ex)
{
HttpContext.Current.Session["Error"] = ex.Message;
Response.Redirect("/Pages/ErrorPage.aspx");
}
}
