public AutherizedUsersList GetAutherizedUsersFor(long userId)
{
SqlParameter[] sqlParms = new SqlParameter[]{
new SqlParameter("@AutherizedUserId",userId)
};
var list = new List<IGNITE_MODEL.AutherizedUser.AutherizedUser>();
using (SqlDataReader sqlobj = SqlHelper.ExecuteReader(SqlHelper.ConnectionString, CommandType.StoredProcedure, "sp_hick_GetAuthorizedUsersFor", sqlParms))
{
while (sqlobj.Read())
{
var autherobj = new IGNITE_MODEL.AutherizedUser.AutherizedUser();
autherobj.UserId = DBHelper.getInt64(sqlobj, "UserId");
autherobj.ReferenceId= DBHelper.getInt64(sqlobj, "ReferenceId");
autherobj.DOB = ecd.DecryptData(DBHelper.getString(sqlobj, "dateofbirth"),ecd.GetEncryptType());
autherobj.Email = ecd.DecryptData(DBHelper.getString(sqlobj, "EmailID"), ecd.GetEncryptType());
autherobj.FirstName = ecd.DecryptData(DBHelper.getString(sqlobj, "Firstname"), ecd.GetEncryptType());
autherobj.LastName = ecd.DecryptData(DBHelper.getString(sqlobj, "Lastname"), ecd.GetEncryptType());
autherobj.Passcode = ecd.DecryptData(DBHelper.getString(sqlobj, "Password"), ecd.GetEncryptType());
autherobj.Relationship = DBHelper.getString(sqlobj, "Relationship");
autherobj.RelationshipOther = DBHelper.getString(sqlobj, "OtherRelationship");
autherobj.AccessLevel = "Advanced";
list.Add(autherobj);
}
}
return new AutherizedUsersList
{
AutherizedUsers = list
};
}
public AutherizedUsersList GetAutherizedUsers(string action, long userId, long authorizedUserId)
{
SqlParameter[] sqlParms = new SqlParameter[]{
new SqlParameter("@action",action),
new SqlParameter("@UserId",userId),
new SqlParameter("@AutherizedUserId",authorizedUserId)
};
var list = new List<IGNITE_MODEL.AutherizedUser.AutherizedUser>();
using (SqlDataReader sqlobj = SqlHelper.ExecuteReader(SqlHelper.ConnectionString, CommandType.StoredProcedure, "sp_hick_GetAuthorizedUser", sqlParms))
{
while (sqlobj.Read())
{
var autherobj = new IGNITE_MODEL.AutherizedUser.AutherizedUser();
autherobj.AutherizedUserId = DBHelper.getInt64(sqlobj, "AuthorizedUserId");
//autherobj.AutherizedUserId = Convert.ToInt64(ecd.DecryptData( DBHelper.getString(sqlobj, "AuthorizedUserId"),ecd.GetEncryptType()));
autherobj.DOB = ecd.DecryptData(DBHelper.getString(sqlobj, "dateofbirth"), ecd.GetEncryptType());
autherobj.Email = ecd.DecryptData(DBHelper.getString(sqlobj, "EmailID"),ecd.GetEncryptType());
autherobj.FirstName = ecd.DecryptData(DBHelper.getString(sqlobj, "Firstname"),ecd.GetEncryptType());
autherobj.LastName = ecd.DecryptData(DBHelper.getString(sqlobj, "Lastname"), ecd.GetEncryptType());
autherobj.Passcode = ecd.DecryptData(DBHelper.getString(sqlobj, "Password"),ecd.GetEncryptType());
autherobj.Relationship = DBHelper.getString(sqlobj, "Relationship");
autherobj.RelationshipOther = DBHelper.getString(sqlobj, "OtherRelationship");
autherobj.AccessHistory = (DBHelper.getDateTime(sqlobj, "LastAccessedIn")).ToString("MM/dd/yyyy").Replace("01/01/0001","N/A");
autherobj.AccessLevel = "Advanced";
list.Add(autherobj);
}
}
return new AutherizedUsersList
{
AutherizedUsers = list
};
}
