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 }; }