public static User Build(ITypeReader reader)
{
User user = new User();
user.UserId = reader.GetGuid("UserId");
user.AcceptedLatestTOS = reader.GetBool("AcceptedLatestTOS");
user.LastTOSVersion = reader.GetInt("LastTOSVersion");
user.PasswordExpiration = reader.GetDate("PasswordExpiration");
user.FirstTimeUser = reader.GetBool("NewUser");
user.DisplayName = reader.GetString("DisplayName");
user.FirstName = reader.GetString("FirstName");
user.MiddleName = reader.GetString("MiddleName");
user.LastName = reader.GetString("LastName");
user.Phone = reader.GetString("Phone");
user.Ext = reader.GetString("Ext");
user.SessionTimeoutInterval = reader.GetInt("SessionTimeout");
user.PasswordQuestion = reader.GetString("PasswordQuestion");
user.PasswordAnswer = reader.GetString("PasswordAnswer");
user.AdminUserId = reader.GetGuid("AdministratorUserId");
user.AdminUserName = reader.GetString("AdminUserName");
user.UserType = (UserTypes)reader.GetInt("UserTypeId");
user.UserTypeId = reader.GetInt("UserTypeId");
user.FailedPasswordAttemptCount = reader.GetInt("FailedPasswordAttemptCount");
user.FailedPasswordAnswerAttemptCount = reader.GetInt("FailedPasswordAnswerAttemptCount");
user.Status = reader.GetString("Status");
user.StatusTypeId = reader.GetInt("StatusTypeId");
return(user);
}
public static User BuildLightweight(ITypeReader reader)
{
User user = new User();
user.UserId = reader.GetGuid("UserId");
user.UserName = reader.GetString("UserName");
user.DisplayName = reader.GetString("DisplayName");
user.CreateDate = reader.GetDate("CreateDate").Value;
user.Status = reader.GetString("Status");
user.StatusTypeId = reader.GetInt("StatusTypeId");
user.UserType = (UserTypes)reader.GetInt("UserTypeId");
user.UserTypeId = reader.GetInt("UserTypeId");
user.LastLoginDate = reader.GetDate("LastLoginDate");
user.Email = reader.GetString("Email");
user.IsNewUser = reader.GetBool("IsNewUser");
return(user);
}
public static Group Build(ITypeReader reader)
{
Group group = new Group();
group.GroupId = reader.GetInt(Columns.GROUPID);
group.Name = reader.GetString(Columns.NAME);
group.EnableAll = reader.GetBool(Columns.ENABLEALL);
group.CreateDate = reader.GetDate(Columns.CREATEDATE);
return(group);
}
public DateTime?SaveSession(Guid userId, string sessionId, int sessionTimeOut, bool removeSession)
{
DateTime?expiration = null;
using (ITypeReader reader = QueryReader(null, _dbConnName, StoredProcedure.SaveUserSession, userId, sessionId, sessionTimeOut, removeSession))
{
while (reader.Read())
{
expiration = reader.GetDate("ExpirationDate");
}
}
return(expiration);
}
public static Measure Build(ITypeReader reader)
{
Measure measure = new Measure();
measure.MeasureId = reader.GetInt(Columns.MEASUREIDCOLUMN);
measure.Name = reader.GetString(Columns.MEASURENAMECOLUMN);
measure.Numerator = reader.GetInt(Columns.NUMERATORCOLUMN);
measure.Denominator = reader.GetInt(Columns.DENOMINATORCOLUMN);
measure.Excluded = reader.GetInt(Columns.EXCLUDEDCOLUMN);
measure.LastDate = reader.GetDate(Columns.LASTDATE);
measure.LastValue = reader.GetString(Columns.LASTVALUE);
double percentage = ((double)measure.Numerator / (double)measure.Denominator) * (double)100;
measure.Percentage = String.Format("{0:0 %}", percentage.ToString());
return(measure);
}
