public ActionResult Index() { TempData["SelectedMenu"] = "Summary"; TempData["SelectedSubMenu"] = ""; TempData["SelectedSubMenuFolder"] = ""; User userObj = (User)Session["user"]; Account accountObj = (Account)Session["account"]; if (userObj != null) { //if (accountObj.isOverFlow == true) //{ // return RedirectToAction("BillingOptions", "Admin", new { id = 1 }); //} LimitationsViewModel limitationsObj = new LimitationsViewModel(); HelperFunctions HF = new HelperFunctions(); limitationsObj = HF.updateAccountLimitations(accountObj); Session["limitations"] = limitationsObj; if (userObj.isPasswordChange == false) { return RedirectToAction("ChangePassword", "Admin"); } if (Session["trialData"] == null) { if (accountObj.HasPurchased == false) { if ((((DateTime)(accountObj.TrialEnds) - (DateTime)(DateTime.Now.Date)).TotalDays > (CCGlobalValues.trialPeriod - 2)) | (((DateTime)(accountObj.TrialEnds) - (DateTime)(DateTime.Now.Date)).TotalDays < 2)) { TrialDataModel trialObj = new TrialDataModel(); trialObj.hasPurchased = accountObj.HasPurchased; trialObj.createdDate = accountObj.CreatedDate; trialObj.trialEndDate = accountObj.TrialEnds; trialObj.showPurchaseOptions = true; Session["trialData"] = trialObj; return RedirectToAction("Index", "Admin"); } else if (((DateTime)(accountObj.TrialEnds) - (DateTime)(DateTime.Now.Date)).TotalDays < CCGlobalValues.trialPeriod) { TrialDataModel trialObj = new TrialDataModel(); trialObj.hasPurchased = accountObj.HasPurchased; trialObj.createdDate = accountObj.CreatedDate; trialObj.trialEndDate = accountObj.TrialEnds; trialObj.showPurchaseOptions = true; Session["trialData"] = trialObj; } } } if (accountObj.HasPurchased == true & Session["trialData"] != null) { Session["trialData"] = null; } AdminViewModel ObjModel = new AdminViewModel(); List<AdminDashboardViewModel> objDash = new List<AdminDashboardViewModel>(); List<List<ConnectionInforViewModel>> connectionInforByConnction = new List<List<ConnectionInforViewModel>>(); if (CCFolderRepository.CCFolders != null) { } var allFolders = CCFolderRepository.CCFolders.Where(guid => guid.AccountGUID == accountObj.AccountGUID).ToList(); ObjModel.noOfFolders = CCFolderRepository.CCFolders.Where(F => F.AccountGUID == accountObj.AccountGUID).Count(); ObjModel.noOfConnections = CCConnectionRepository.CCSubscriptions.Where(C => C.AccountGUID == accountObj.AccountGUID).Count(); ObjModel.noOfUsers = CCUserRepository.Users.Where(U => U.AccountID == userObj.AccountID).Count(); //ObjModel.noOfSubscriptionsPurchased = 0; ObjModel.noOfTotalItems = CCItemRepository.CCContacts.Where(I => I.AccountGUID == accountObj.AccountGUID & I.isDeleted == false).Count(); // get saved quantity var accDetails = accountRepo.Accounts.Where(aguid => aguid.AccountGUID == accountObj.AccountGUID).FirstOrDefault(); var planLeval = planRepository.Plans.Where(pid => pid.ID == accDetails.PlanID).FirstOrDefault().PlanLevel; var featureQuality = featureRepository.Features.Where(pid => pid.PlanLevel == planLeval & pid.Type == "Max Items per Folder").FirstOrDefault(); var savedQuality = purchRepository.Purchases.Where(fid => fid.FeatureID == featureQuality.ID && fid.AccountGUID == accountObj.AccountGUID).FirstOrDefault(); if (savedQuality != null) { var quantitySaved = (savedQuality.Quantity) / (featureQuality.Quantity); ObjModel.NoOfConnection = quantitySaved * 5; ObjModel.noOfSubscriptionsPurchased = quantitySaved; //limitationsObj.availableCconnectionCount = (int)ObjModel.NoOfConnection - (int)ObjModel.noOfConnections; //limitationsObj.maxItemCountPerFolder = featureQuality.Quantity; //if (featureRepository.Features.Where(pid => pid.PlanLevel == planLeval & pid.Type == "Sync Calendar").FirstOrDefault().Quantity == 0) // limitationsObj.isCalendarSyncAvailable = false; //else // limitationsObj.isCalendarSyncAvailable = true; } else { ObjModel.NoOfConnection = 0; ObjModel.noOfSubscriptionsPurchased = 0; } foreach (var folder in allFolders) { AdminDashboardViewModel dash = new AdminDashboardViewModel(); List<ConnectionInforViewModel> connectionInforByFolder = new List<ConnectionInforViewModel>(); dash.FolderName = folder.Name; dash.FolderID = folder.FolderID; dash.FolderType = folder.Type; dash.NumberOfItems = CCContactRepository.CCContacts.Where(fid => fid.FolderID == folder.FolderID & fid.AccountGUID == accountObj.AccountGUID & fid.isDeleted == false).Count(); dash.NumberOfConnections = CCConnectionRepository.CCSubscriptions.Where(fid => fid.FolderID == folder.FolderID & fid.AccountGUID == accountObj.AccountGUID).Count(); if (folder.IsPaused == false) { dash.IsPaused = false; } else { dash.IsPaused = true; } objDash.Add(dash); var connections = CCConnectionRepository.CCSubscriptions.Where(fid => fid.FolderID == folder.FolderID & fid.AccountGUID == accountObj.AccountGUID); foreach (var conn in connections) { ConnectionInforViewModel connectionInfor = new ConnectionInforViewModel(); connectionInfor.FolderName = folder.Name; connectionInfor.ConnctionFolderName = conn.FolderName; connectionInfor.ConnectionID = conn.ConnectionID; if (DateTime.Parse(conn.LastSyncTime) < DateTime.Parse("1902-01-01 00:00")) { connectionInfor.LastSyncTime = "Never"; } else { DateTime timeUtc = DateTime.Parse(conn.LastSyncTime); DateTime cstTime = new DateTime(); try { TimeZoneInfo cstZone = TimeZoneInfo.FindSystemTimeZoneById(accountObj.TimeZone.ToString()); cstTime = TimeZoneInfo.ConvertTimeFromUtc(timeUtc, cstZone); Console.WriteLine("The date and time are {0} {1}.", cstTime, cstZone.IsDaylightSavingTime(cstTime) ? cstZone.DaylightName : cstZone.StandardName); } catch (TimeZoneNotFoundException) { Console.WriteLine("Timezone conversion error"); } catch (InvalidTimeZoneException) { Console.WriteLine("conn.LastSyncTime"); } connectionInfor.LastSyncTime = cstTime.ToString(); //connectionInfor.LastSyncTime = conn.LastSyncTime; } connectionInfor.Type = conn.Type; connectionInfor.FolderID = folder.FolderID; if (conn.IsRunning == null) { connectionInfor.IsRunning = false; } else if (conn.IsRunning == false) { connectionInfor.IsRunning = false; } else if (conn.IsRunning == true) { connectionInfor.IsRunning = true; } if (conn.IsPaused == false) { connectionInfor.IsPaused = false; connectionInfor.rowClass = "notPaused "; } else { connectionInfor.IsPaused = true; connectionInfor.rowClass = "Paused "; } connectionInforByFolder.Add(connectionInfor); } connectionInforByConnction.Add(connectionInforByFolder); } var assemblyVersion = System.Reflection.Assembly.GetExecutingAssembly().GetName().Version.ToString(); ViewBag.version = assemblyVersion; Session["version"] = assemblyVersion; ObjModel.FoldersInfor = objDash; ObjModel.ConnectionsInfor = connectionInforByConnction; return View(ObjModel); } return View(); }
public ActionResult ImpersonatedAccount(long AccID) { if (Session["SysAdminDetails"] != null) { TempData["SelectedMenu"] = "AccImpersontation"; var userObj = CCUserRepository.GetUserByEmailAddress(CCUserRepository.Users.First(U => U.AccountID == AccID).Email); Session["user"] = userObj; var accountObj = CCAccRepository.Accounts.FirstOrDefault(x => x.ID == userObj.AccountID); Session["account"] = accountObj; var timeZone = CCAccRepository.Accounts.Where(aid => aid.ID == userObj.AccountID).FirstOrDefault().TimeZone; Session["timeZone"] = timeZone; var folders = CCFolderRepository.CCFolders.Where(guid => guid.AccountGUID == accountObj.AccountGUID).ToList(); Session["folderss"] = folders; LimitationsViewModel limitationsObj = new LimitationsViewModel(); HelperFunctions HF1 = new HelperFunctions(); limitationsObj = HF1.updateAccountLimitations(accountObj); Session["limitations"] = limitationsObj; List<NotificationListViewModel> notificationList = new List<NotificationListViewModel>(); CronJobController CJC = new CronJobController(); Session["account"] = CJC.checkAccountTrialExpiryForAccount(accountObj); HelperFunctions HF = new HelperFunctions(); notificationList = HF.generateNotificationList(accountObj); HF.CheckAcccountStatus(accountObj); if (notificationList.Count > 0) Session["notifications"] = notificationList; else Session["notifications"] = null; if (((DateTime)(accountObj.TrialEnds) - (DateTime)(DateTime.Now.Date)).TotalDays < CCGlobalValues.trialPeriod) { TrialDataModel trialObj = new TrialDataModel(); trialObj.hasPurchased = accountObj.HasPurchased; trialObj.createdDate = accountObj.CreatedDate; trialObj.trialEndDate = accountObj.TrialEnds; trialObj.showPurchaseOptions = true; Session["trialData"] = trialObj; } ImpersonateAccountsSysAdminModel model = new ImpersonateAccountsSysAdminModel(); var AccountsInfo = CCAccRepository.Accounts.Where(A => A.ID == AccID).FirstOrDefault(); model.SelectedAccountInfo = AccountsInfo; model.FolderCount = CCFolderRepository.CCFolders.Where(F => F.AccountGUID == AccountsInfo.AccountGUID).Count(); model.ConnectionCount = CCConnectionRepository.CCSubscriptions.Where(C => C.AccountGUID == AccountsInfo.AccountGUID).Count(); model.UserCount = CCUserRepository.Users.Where(U => U.AccountID == AccountsInfo.ID).Count(); model.SubscriptionCount = 0; model.ItemsCount = CCItemRepository.CCContacts.Where(I => I.AccountGUID == AccountsInfo.AccountGUID).Count(); model.SelectedAccountOwner = CCUserRepository.Users.First(U => U.AccountID == AccountsInfo.ID).FullName; //Sync Graph Data List<string> SyncDates = new List<string>(); List<double> SyncDateUsage = new List<double>(); DateTime startDate = DateTime.Now.Date.AddDays(-1); for (int i = 6; i > -1; i--) { SyncDates.Add((startDate.AddDays(-i)).ToShortDateString()); } for (int i = 0; i < SyncDates.Count(); i++) { DateTime syncDateStart = DateTime.Parse(SyncDates[i]); DateTime syncDateEnd = syncDateStart.AddHours(23).AddMinutes(59); SyncDateUsage.Add(CCSyncItemsRepository.CCSyncItems.Where(SI => SI.LastUpdated >= syncDateStart && SI.LastUpdated <= syncDateEnd).Count()); } model.SyncDates = SyncDates; model.SyncDateUsage = SyncDateUsage; return View(model); } else { return RedirectToAction("Login", "Login"); } }