//public ActionResult Index(SystemAdminDashboardViewModel obj)
//{
// return View(obj);
//}
public ActionResult AccountInfo()
{
User userObj = (User)Session["user"];
Account accountObj = (Account)Session["account"];
TempData["SelectedMenu"] = "accInfo";
var model = new SystemAdminDashboardViewModel();
Session["ErrorSourceFilterList"] = model.ErrorSourceFilterList;
Session["ErrorTypeFilterList"] = model.ErrorTypeFilterList;
if (Session["SystemAdminDashboardViewModel"] != null)
{
model = (SystemAdminDashboardViewModel)Session["SystemAdminDashboardViewModel"];
model.ExistingAccounts = CCAccRepository.Accounts.ToList();
}
else
{
model.ExistingAccounts = CCAccRepository.Accounts.ToList();
}
var assemblyVersion = System.Reflection.Assembly.GetExecutingAssembly().GetName().Version.ToString();
ViewBag.version = assemblyVersion;
Session["version"] = assemblyVersion;
//model.SelectedAccountID = 0;
return View(model);
}
public ActionResult viewMasterErrorLog()
{
var model = new SystemAdminDashboardViewModel();
if (Session["SystemAdminDashboardViewModel"] != null)
{
model = (SystemAdminDashboardViewModel)Session["SystemAdminDashboardViewModel"];
model.ErrorLogList = CCErrorLogRepository.CCErrorLogs.OrderByDescending(e => e.DateTime).Take(200).ToList();
}
else
{
model.ErrorLogList = CCErrorLogRepository.CCErrorLogs.OrderByDescending(e => e.DateTime).Take(200).ToList();
}
model.ErrorLogList = FilteredErrorLogList(model.ErrorLogList, model.ErrorSourceFilterList, model.ErrorTypeFilterList);
Session["SystemAdminDashboardViewModel"] = model;
return View(model);
}
public ActionResult ViewConnectionDetails(long ConnectionID, long AccID)
{
var model = new SystemAdminDashboardViewModel();
model.SelectedAccountID = AccID;
var selectedAccount = CCAccRepository.Accounts.Where(acc => acc.ID == model.SelectedAccountID);
foreach (var acc in selectedAccount)
{
model.SelectedConnectionID = ConnectionID;
model.SelectedConnection = new SelectedConnectionDetails();
model.SelectedConnection.Connection = CCConnectionRepository.CCSubscriptions.Where(conn => conn.AccountGUID == acc.AccountGUID && conn.ConnectionID == model.SelectedConnectionID).FirstOrDefault();
model.SelectedConnection.Folder = CCFolderRepository.CCFolders.Where(fold => fold.FolderID == model.SelectedConnection.Connection.FolderID && fold.AccountGUID == acc.AccountGUID).FirstOrDefault();
model.SelectedConnectionCheckBoxes = new ConnectionCheckBoxToggles();
if (model.SelectedConnection.Connection.AllowAdditions == true)
model.SelectedConnectionCheckBoxes.allowAdditions = "checked";
if (model.SelectedConnection.Connection.IgnoreExisting == true)
model.SelectedConnectionCheckBoxes.ignoreExsisting = "checked";
if (model.SelectedConnection.Connection.CategoryFilterUsed == true)
model.SelectedConnectionCheckBoxes.categoryFilter = "checked";
if (model.SelectedConnection.Connection.CopyPhotos == true)
model.SelectedConnectionCheckBoxes.copyPhotos = "checked";
if (model.SelectedConnection.Connection.TurnOffReminders == true)
model.SelectedConnectionCheckBoxes.turnOffReminders = "checked";
if (model.SelectedConnection.Connection.tagSubject == true)
model.SelectedConnectionCheckBoxes.tagSubject = "checked";
if (model.SelectedConnection.Connection.IsRunning == true)
model.SelectedConnectionCheckBoxes.isRunning = "checked";
if (model.SelectedConnection.Connection.IsPaused == true)
model.SelectedConnectionCheckBoxes.isPaused = "checked";
}
return View(model);
}
public ActionResult Index()
{
User userObj = (User)Session["user"];
Account accountObj = (Account)Session["account"];
var model = new SystemAdminDashboardViewModel();
model.FolderCount = CCFolderRepository.CCFolders.Count();
model.ConnectionCount = CCConnectionRepository.CCSubscriptions.Count();
model.UserCount = CCUserRepository.Users.Count();
model.AccountCount = CCAccRepository.Accounts.Count();
model.ItemCount = CCItemRepository.CCContacts.Count();
DateTime DateStart = DateTime.Now.Date.AddDays(-3);
DateTime DateEnd = DateTime.Now.Date;
model.ErrorLogHistoryLimited = new List<CCErrorLog>();
var query = CCErrorLogRepository.CCErrorLogs.OrderByDescending(x => x.DateTime).Take(100).ToList();
model.ErrorLogHistoryLimited = CCErrorLogRepository.CCErrorLogs.OrderByDescending(x=>x.DateTime).Take(100).ToList();
var assemblyVersion = System.Reflection.Assembly.GetExecutingAssembly().GetName().Version.ToString();
ViewBag.version = assemblyVersion;
Session["version"] = assemblyVersion;
//model.SelectedAccountID = 0;
return View(model);
}
public ActionResult GenerateAccountDetails(SystemAdminDashboardViewModel obj)
{
var model = new SystemAdminDashboardViewModel();
model.SelectedAccountID = obj.SelectedAccountID;
model.SelectedInformationType = obj.SelectedInformationType;
var selectedAccount = CCAccRepository.Accounts.Where(acc => acc.ID == model.SelectedAccountID);
foreach (var acc in selectedAccount)
{
if (model.SelectedInformationType == 2) //Error List
{
model.ErrorLogList = CCErrorLogRepository.CCErrorLogs.Where(error => error.AccountGUID == acc.AccountGUID).Take(100).ToList();
model.ErrorLogList = FilteredErrorLogList(model.ErrorLogList, model.ErrorSourceFilterList, model.ErrorTypeFilterList);
//model.ErrorSourceFilterList = (List<ErrorFilters>)Session["ErrorSourceFilterList"];
//model.ErrorTypeFilterList = (List<ErrorFilters>)Session["ErrorTypeFilterList"];
}
else if (model.SelectedInformationType == 1) //Folder List
{
model.Folders = CCFolderRepository.CCFolders.Where(guid => guid.AccountGUID == acc.AccountGUID).ToList();
model.FolderList = new List<FolderDetails>();
foreach (var folder in model.Folders)
{
FolderDetails FD = new FolderDetails();
FD.FolderName = folder.Name;
FD.ItemCount = CCItemRepository.CCContacts.Where(items => items.FolderID == folder.FolderID).Count();
model.FolderList.Add(FD);
}
}
else if (model.SelectedInformationType == 3) //Connection List
{
model.Connections = CCConnectionRepository.CCSubscriptions.Where(conn => conn.AccountGUID == acc.AccountGUID).ToList();
model.ConnectionList = new List<ConnectionDetails>();
foreach (var conn in model.Connections)
{
ConnectionDetails CD = new ConnectionDetails();
CD.Connection = conn;
CD.Folders = CCFolderRepository.CCFolders.Where(fold => fold.FolderID == conn.FolderID && fold.AccountGUID == acc.AccountGUID).FirstOrDefault();
model.ConnectionList.Add(CD);
}
}
else if (model.SelectedInformationType == 4) //Database Usage
{
double TotalTableUsage = 0;
double TotalTableUsageForAccount = 0;
model.TableUsageList = new List<DBTableUsageDetails>();
//Connection Table
TotalTableUsage = CCConnectionRepository.CCSubscriptions.Count();
TotalTableUsageForAccount = CCConnectionRepository.CCSubscriptions.Where(conn => conn.AccountGUID == acc.AccountGUID).Count();
DBTableUsageDetails tblConnectionObj = new DBTableUsageDetails();
tblConnectionObj.TableName = "Connections";
tblConnectionObj.TableUsage = Math.Round((TotalTableUsageForAccount / TotalTableUsage) * 100, 2);
tblConnectionObj.RecordCount = TotalTableUsageForAccount + " of " + TotalTableUsage;
model.TableUsageList.Add(tblConnectionObj);
//Credentials Table
TotalTableUsage = CCCredentialRepository.Credentials.Count();
TotalTableUsageForAccount = CCCredentialRepository.Credentials.Where(cred => cred.AccountGUID == acc.AccountGUID).Count();
DBTableUsageDetails tblCredentialsObj = new DBTableUsageDetails();
tblCredentialsObj.TableName = "Credentials";
tblCredentialsObj.TableUsage = Math.Round((TotalTableUsageForAccount / TotalTableUsage) * 100, 2);
tblCredentialsObj.RecordCount = TotalTableUsageForAccount + " of " + TotalTableUsage;
model.TableUsageList.Add(tblCredentialsObj);
//Field Mappings Table
TotalTableUsage = CCFieldMappingsRepository.CCFieldsMapping.Count();
TotalTableUsageForAccount = CCFieldMappingsRepository.CCFieldsMapping.Where(fieldMappings => fieldMappings.AccountGUID == acc.AccountGUID).Count();
DBTableUsageDetails tblFieldMappingsObj = new DBTableUsageDetails();
tblFieldMappingsObj.TableName = "FieldMappings";
tblFieldMappingsObj.TableUsage = Math.Round((TotalTableUsageForAccount / TotalTableUsage) * 100, 2);
tblFieldMappingsObj.RecordCount = TotalTableUsageForAccount + " of " + TotalTableUsage;
model.TableUsageList.Add(tblFieldMappingsObj);
//Field Values Table
TotalTableUsage = CCFieldValueRepository.CCFieldValues.Count();
TotalTableUsageForAccount = CCFieldValueRepository.CCFieldValues.Where(fieldValues => fieldValues.AccountGUID == acc.AccountGUID).Count();
DBTableUsageDetails tblFieldValuesObj = new DBTableUsageDetails();
tblFieldValuesObj.TableName = "FieldValues";
tblFieldValuesObj.TableUsage = Math.Round((TotalTableUsageForAccount / TotalTableUsage) * 100, 2);
tblFieldValuesObj.RecordCount = TotalTableUsageForAccount + " of " + TotalTableUsage;
model.TableUsageList.Add(tblFieldValuesObj);
//Folder Fields Table
TotalTableUsage = CCFieldValueRepository.CCFieldValues.Count();
TotalTableUsageForAccount = CCFieldValueRepository.CCFieldValues.Where(folderFields => folderFields.AccountGUID == acc.AccountGUID).Count();
DBTableUsageDetails tblFolderFieldsObj = new DBTableUsageDetails();
tblFolderFieldsObj.TableName = "Folder Fields";
tblFolderFieldsObj.TableUsage = Math.Round((TotalTableUsageForAccount / TotalTableUsage) * 100, 2);
tblFolderFieldsObj.RecordCount = TotalTableUsageForAccount + " of " + TotalTableUsage;
model.TableUsageList.Add(tblFolderFieldsObj);
//Folders Table
TotalTableUsage = CCFolderRepository.CCFolders.Count();
TotalTableUsageForAccount = CCFolderRepository.CCFolders.Where(folders => folders.AccountGUID == acc.AccountGUID).Count();
DBTableUsageDetails tblFoldersObj = new DBTableUsageDetails();
tblFoldersObj.TableName = "Folders";
tblFoldersObj.TableUsage = Math.Round((TotalTableUsageForAccount / TotalTableUsage) * 100, 2);
tblFoldersObj.RecordCount = TotalTableUsageForAccount + " of " + TotalTableUsage;
model.TableUsageList.Add(tblFoldersObj);
//Group Fields Table
TotalTableUsage = CCGroupFieldRepository.CCGroupsFields.Count();
TotalTableUsageForAccount = CCGroupFieldRepository.CCGroupsFields.Where(groupFields => groupFields.AccountGUID == acc.AccountGUID).Count();
DBTableUsageDetails tblGroupFieldsObj = new DBTableUsageDetails();
tblGroupFieldsObj.TableName = "Group Fields";
tblGroupFieldsObj.TableUsage = Math.Round((TotalTableUsageForAccount / TotalTableUsage) * 100, 2);
tblGroupFieldsObj.RecordCount = TotalTableUsageForAccount + " of " + TotalTableUsage;
model.TableUsageList.Add(tblGroupFieldsObj);
//Groups Table
TotalTableUsage = CCGroupRepository.CCGroups.Count();
TotalTableUsageForAccount = CCGroupRepository.CCGroups.Where(groups => groups.AccountGUID == acc.AccountGUID).Count();
DBTableUsageDetails tblGroupsObj = new DBTableUsageDetails();
tblGroupsObj.TableName = "Groups";
tblGroupsObj.TableUsage = Math.Round((TotalTableUsageForAccount / TotalTableUsage) * 100, 2);
tblGroupsObj.RecordCount = TotalTableUsageForAccount + " of " + TotalTableUsage;
model.TableUsageList.Add(tblGroupsObj);
//Items Table
TotalTableUsage = CCItemRepository.CCContacts.Count();
TotalTableUsageForAccount = CCItemRepository.CCContacts.Where(items => items.AccountGUID == acc.AccountGUID).Count();
DBTableUsageDetails tblItemsObj = new DBTableUsageDetails();
tblItemsObj.TableName = "Items";
tblItemsObj.TableUsage = Math.Round((TotalTableUsageForAccount / TotalTableUsage) * 100, 2);
tblItemsObj.RecordCount = TotalTableUsageForAccount + " of " + TotalTableUsage;
model.TableUsageList.Add(tblItemsObj);
//Layout Groups Table
TotalTableUsage = CCLayoutGroupRepository.CCLayoutGroups.Count();
TotalTableUsageForAccount = CCLayoutGroupRepository.CCLayoutGroups.Where(layoutGroup => layoutGroup.AccountGUID == acc.AccountGUID).Count();
DBTableUsageDetails tblLayoutGroupsObj = new DBTableUsageDetails();
tblLayoutGroupsObj.TableName = "Layout Groups";
tblLayoutGroupsObj.TableUsage = Math.Round((TotalTableUsageForAccount / TotalTableUsage) * 100, 2);
tblLayoutGroupsObj.RecordCount = TotalTableUsageForAccount + " of " + TotalTableUsage;
model.TableUsageList.Add(tblLayoutGroupsObj);
//Layouts Table
TotalTableUsage = CCLayoutRepository.CCLayouts.Count();
TotalTableUsageForAccount = CCLayoutRepository.CCLayouts.Where(layouts => layouts.AccountGUID == acc.AccountGUID).Count();
DBTableUsageDetails tblLayoutsObj = new DBTableUsageDetails();
tblLayoutsObj.TableName = "Layouts";
tblLayoutsObj.TableUsage = Math.Round((TotalTableUsageForAccount / TotalTableUsage) * 100, 2);
tblLayoutsObj.RecordCount = TotalTableUsageForAccount + " of " + TotalTableUsage;
model.TableUsageList.Add(tblLayoutsObj);
//Notes Table
TotalTableUsage = CCNoteRepository.CCNotes.Count();
TotalTableUsageForAccount = CCNoteRepository.CCNotes.Where(notes => notes.AccountGUID == acc.AccountGUID).Count();
DBTableUsageDetails tblNotesObj = new DBTableUsageDetails();
tblNotesObj.TableName = "Notes";
tblNotesObj.TableUsage = Math.Round((TotalTableUsageForAccount / TotalTableUsage) * 100, 2);
tblNotesObj.RecordCount = TotalTableUsageForAccount + " of " + TotalTableUsage;
model.TableUsageList.Add(tblNotesObj);
////Sync Fields Table
//TotalTableUsage = CCSyncFieldsRepository.CCSyncFields.Count();
//TotalTableUsageForAccount = CCSyncFieldsRepository.CCSyncFields.Where(cred => cred.AccountGUID == acc.AccountGUID).Count();
//DBTableUsageDetails tblSyncFieldsObj = new DBTableUsageDetails();
//tblSyncFieldsObj.TableName = "SyncFields";
//tblSyncFieldsObj.TableUsage = Math.Round((TotalTableUsageForAccount / TotalTableUsage) * 100, 2);
//tblSyncFieldsObj.RecordCount = TotalTableUsageForAccount + " of " + TotalTableUsage;
//model.TableUsageList.Add(tblSyncFieldsObj);
////Sync Items Table
//TotalTableUsage = CCSyncItemsRepository.CCSyncItems.Count();
//TotalTableUsageForAccount = CCSyncItemsRepository.CCSyncItems.Where(cred => cred.AccountGUID == acc.AccountGUID).Count();
//DBTableUsageDetails tblSyncItemsObj = new DBTableUsageDetails();
//tblSyncItemsObj.TableName = "SyncItems";
//tblSyncItemsObj.TableUsage = Math.Round((TotalTableUsageForAccount / TotalTableUsage) * 100, 2);
//tblSyncItemsObj.RecordCount = TotalTableUsageForAccount + " of " + TotalTableUsage;
//model.TableUsageList.Add(tblSyncItemsObj);
}
Session["SystemAdminDashboardViewModel"] = model;
}
return RedirectToAction("AccountInfo", "CorporateContactsAdmin");
}
public ActionResult FilterErrorList(long AccountID, string ErrorFilter, long FilterType, string redirectMethod)
{
var model = new SystemAdminDashboardViewModel();
if (Session["SystemAdminDashboardViewModel"] != null)
{
model = (SystemAdminDashboardViewModel)Session["SystemAdminDashboardViewModel"];
}
if (FilterType == 1)
{
//List<ErrorFilters> ErrorSourceFilterList = (List<ErrorFilters>)Session["ErrorSourceFilterList"];
foreach (var err in model.ErrorSourceFilterList)
{
if (ErrorFilter == err.Error)
{
if(err.ErrorState == "active")
err.ErrorState = "disabled";
else
err.ErrorState = "active";
}
}
}
else if (FilterType == 2)
{
//List<ErrorFilters> ErrorTypeFilterList = (List<ErrorFilters>)Session["ErrorTypeFilterList"];
foreach (var err in model.ErrorTypeFilterList)
{
if (ErrorFilter == err.Error)
{
if (err.ErrorState == "active")
err.ErrorState = "disabled";
else
err.ErrorState = "active";
}
}
}
model.SelectedAccountID = AccountID;
model.SelectedInformationType = 2;
var selectedAccount = CCAccRepository.Accounts.Where(acc => acc.ID == model.SelectedAccountID);
foreach (var acc in selectedAccount)
{
if (model.SelectedInformationType == 2) //Error List
{
model.ErrorLogList = CCErrorLogRepository.CCErrorLogs.Where(error => error.AccountGUID == acc.AccountGUID).Take(100).ToList();
model.ErrorLogList = FilteredErrorLogList(model.ErrorLogList, model.ErrorSourceFilterList, model.ErrorTypeFilterList);
//model.ErrorSourceFilterList = (List<ErrorFilters>)Session["ErrorSourceFilterList"];
//model.ErrorTypeFilterList = (List<ErrorFilters>)Session["ErrorTypeFilterList"];
}
}
Session["SystemAdminDashboardViewModel"] = model;
if (redirectMethod == "index")
return RedirectToAction("Index", "CorporateContactsAdmin");
else
return RedirectToAction("viewMasterErrorLog", "CorporateContactsAdmin");
}