public static UserEditModel FromDomain(User u, UserActivitySummary logins, IAccountingService accounting)
{
var x = new UserEditModel
{
Manager = u.Manager,
Group = u.Group,
ManagedGroups = u.ManagedGroups,
State = u.State,
DateBirth = u.DateBirth,
DateHired = u.DateHired,
Email = u.Email,
Title = u.Title,
EmployeeId = u.EmployeeId,
FirstName = u.FirstName,
LastName = u.LastName,
HomeAddress = u.HomeAddress,
WorkAddress = u.WorkAddress,
HomePhone = u.HomePhone,
WorkPhone = u.WorkPhone,
MobilePhone = u.MobilePhone,
Custom = u.Custom,
Permissions = (u.Permissions ?? new UserPermissions()),
// display only fields
Login = u.Login,
DateAcceptedTermsOfService = u.DateAcceptedTermsOfService,
DateRegistered = u.DateRegistered,
DateActivated = u.DateActivated,
DateSuspended = u.DateSuspended,
DateTerminated = u.DateTerminated,
};
x.AddBudgets(u, accounting);
return x;
}
public List <UserActivitySummary> RetrieveActivitySummaryByUser(int userId)
{
SqlCommand command = null;
SqlDataAdapter adapter = null;
try
{
// Define command.
command = mDbConnection.CreateCommand();
command.CommandText = "RetrieveActivitySummaryByUser";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@Parentuserid", SqlDbType.Int).Value = userId;
// Execute command.
adapter = new SqlDataAdapter(command);
DataTable DtActivitySummary = new DataTable();
adapter.Fill(DtActivitySummary);
// Create a list.
List <UserActivitySummary> ActivitySummarylst = null;
if (DtActivitySummary.Rows.Count > 0)
{
ActivitySummarylst = new List <UserActivitySummary>();
}
// Iterate each row.
foreach (DataRow row in DtActivitySummary.Rows)
{
UserActivitySummary usr = new UserActivitySummary();
usr.UserName = row["username"].ToString();
usr.UserId = Convert.ToInt32(row["userId"].ToString());
usr.ActivityDate = Convert.ToDateTime(row["Activitydate"].ToString());
usr.ActivityCount = Convert.ToInt32(row["ActivityCount"].ToString());
usr.CustomData.Add("Duration", (string.IsNullOrEmpty(row["Duration"].ToString())) ? null : row["Duration"].ToString());
//Commented by saravanan on 07312012 release later
//usr.CustomData.Add("ActiveStatus",row["ActiveStatus"].ToString());
// Add to list.
ActivitySummarylst.Add(usr);
}
// Return the list.
return(ActivitySummarylst);
}
catch { throw; }
finally
{
// Dispose.
if (adapter != null)
{
adapter.Dispose();
}
if (command != null)
{
command.Dispose();
}
}
}
public void AddActivity(UserActivitySummary logins)
{
FailedLogins = new LoginIncrements {
Count = logins.FailedLogins, Last = logins.LastFailedLogin
};
SuccessfulLogins = new LoginIncrements {
Count = logins.SuccessfulLogins, Last = logins.LastSuccesfulLogin
};
}
/// <summary>
/// Gets the user activity summary.
/// </summary>
/// <param name="userId">The user identifier.</param>
/// <param name="startDate">The start date.</param>
/// <param name="endDate">The end date.</param>
/// <returns></returns>
public UserActivitySummary GetUserActivitySummary(int userId, DateTime startDate, DateTime endDate)
{
UserActivitySummary userActivitySummary = new UserActivitySummary();
userActivitySummary.DaysCount = GetUserActivityDaysCount(userId, startDate, endDate);
userActivitySummary.ProjectCount = GetUserActivityProjectCount(userId, startDate, endDate);
userActivitySummary.CompanyCount = GetUserActivityCompanyCount(userId, startDate, endDate);
return(userActivitySummary);
}
public UserActivitySummary TakeSummary(IQueryable <UserActivity> query)
{
var overal = from user in query
group user by 1 into g
select new
{
MinDt = g.Min(x => x.EntryDt),
MaxDt = g.Max(x => x.EntryDt),
Count = g.Count()
};
var most = (from user in query.Where(x => !String.IsNullOrEmpty(x.PageName))
group user by user.PageName into g
select new MostVisitedPage
{
PageName = g.Key,
Count = g.Count()
}).OrderByDescending(x => x.Count).Take(10);
var daily = (from user in query
group user by DbFunctions.TruncateTime(user.EntryDt) into g
orderby g.Key descending
select new DayActivity
{
Date = g.Key.Value,
Count = g.Count()
}).Take(14);
var hourly = from user in query
group user by user.EntryDt.Hour into g
orderby g.Key descending
select new HourActivity
{
Hour = g.Key,
Count = g.Count()
};
overal.Future();
most.Future();
daily.Future();
hourly.Future();
var firstOveral = overal.FirstOrDefault();
var summary = new UserActivitySummary()
{
HourActivities = hourly.ToArray(),
DayActivities = daily.ToArray(),
FirstActivityDt = firstOveral?.MinDt ?? DateTime.MinValue,
LastActivityDt = firstOveral?.MaxDt ?? DateTime.MinValue,
MostVisitedPages = most.ToArray(),
TotalActivityCount = firstOveral?.Count ?? 0
};
return(summary);
}
/// <summary>
/// Loads the user activity summary.
/// </summary>
/// <param name="selectedDate">The selected date.</param>
private void LoadUserActivitySummary(DateTime selectedDate)
{
DateTime startDate = new DateTime(selectedDate.Year, selectedDate.Month, 1);
DateTime endDate = new DateTime(selectedDate.Year, selectedDate.Month, DateTime.DaysInMonth(selectedDate.Year, selectedDate.Month));
try
{
AnalyticsManager analyticsManager = new AnalyticsManager();
UserActivitySummary projectActivitySummary = analyticsManager.GetUserActivitySummary(ViewUserId, startDate, endDate);
lblAccessedProjects.Text = projectActivitySummary.ProjectCount.ToString(CultureInfo.InvariantCulture);
lblAccessedCompanies.Text = projectActivitySummary.CompanyCount.ToString(CultureInfo.InvariantCulture);
lblActiveDays.Text = projectActivitySummary.DaysCount.ToString(CultureInfo.InvariantCulture);
lblActiveDays.ForeColor = lblAccessedCompanies.ForeColor = lblAccessedProjects.ForeColor = Color.Empty;
}
catch (StageBitzException ex)
{
lblActiveDays.Text = lblAccessedCompanies.Text = lblAccessedProjects.Text = "Error!";
lblActiveDays.ToolTip = lblAccessedCompanies.ToolTip = lblAccessedProjects.ToolTip = ex.InnerException.ToString();
lblActiveDays.ForeColor = lblAccessedCompanies.ForeColor = lblAccessedProjects.ForeColor = Color.Red;
}
}
public static UserEditModel FromDomain(User u, UserActivitySummary logins, IAccountingService accounting)
{
var x = new UserEditModel
{
Manager = u.Manager,
Group = u.Group,
ManagedGroups = u.ManagedGroups,
State = u.State,
DateBirth = u.DateBirth,
DateHired = u.DateHired,
Email = u.Email,
Title = u.Title,
EmployeeId = u.EmployeeId,
FirstName = u.FirstName,
LastName = u.LastName,
HomeAddress = u.HomeAddress,
WorkAddress = u.WorkAddress,
HomePhone = u.HomePhone,
WorkPhone = u.WorkPhone,
MobilePhone = u.MobilePhone,
Custom = u.Custom,
Permissions = (u.Permissions ?? new UserPermissions()),
// display only fields
Login = u.Login,
DateAcceptedTermsOfService = u.DateAcceptedTermsOfService,
DateRegistered = u.DateRegistered,
DateActivated = u.DateActivated,
DateSuspended = u.DateSuspended,
DateTerminated = u.DateTerminated,
};
x.AddBudgets(u, accounting);
x.AddActivity(logins);
return(x);
}
public void AddActivity(UserActivitySummary logins)
{
FailedLogins = new LoginIncrements { Count = logins.FailedLogins, Last = logins.LastFailedLogin };
SuccessfulLogins = new LoginIncrements { Count = logins.SuccessfulLogins, Last = logins.LastSuccesfulLogin };
}
