public void Concurrency_AddRemoveSearshByName_OkAndNoExceptions()
{
UserCollection <int, int, int> c = new UserCollection <int, int, int>();
Parallel.For(0, 1000, (i) =>
{
try
{
Tuple <int, int> k1 = new Tuple <int, int>(-1, i);
Tuple <int, int> k2 = new Tuple <int, int>(-2, i);
c.Add(k1, i);
c.Add(k2, i);
var d = c.SearchByName(i);
Assert.AreEqual(2, d.Count);
Assert.IsTrue(c.Remove(k1));
Assert.IsTrue(c.Remove(k2));
Assert.IsFalse(c.ContainsKey(k1));
Assert.IsFalse(c.ContainsKey(k2));
}
catch (Exception e)
{
Assert.Fail(e.Message);
}
});
Assert.AreEqual(0, c.Count);
}
public void Add_AddingByNullKeyParts_ThrowsException()
{
UserCollection <UserType, string, string> c = new UserCollection <UserType, string, string>();
bool hasException1 = false, hasException2 = false;
try
{
c.Add(new Key(new UserType(1, null), "Mike"), "Superman");
}
catch (Exception e)
{
hasException1 = true;
}
try
{
c.Add(new Key(new UserType(1, "xyz"), null), "Superman");
}
catch (Exception e)
{
hasException2 = true;
}
Assert.IsTrue(hasException1);
Assert.IsTrue(hasException2);
}
public void Remove_Adding3Remove1_Expected2AndNoElement()
{
UserCollection <UserType, string, string> c = new UserCollection <UserType, string, string>();
Key k = new Key(new UserType(3, "a"), "Mike");
c.Add(new Key(new UserType(1, "a"), "Mike"), "Employee");
c.Add(new Key(new UserType(2, "a"), "Mike"), "Employee");
c.Add(k, "Employee");
c.Remove(k);
Assert.AreEqual(2, c.Count);
Assert.IsFalse(c.ContainsKey(k));
}
public UserCollection GetUnSignedUsers(BPMConnection cn, BPMObjectNameCollection accounts)
{
BPMObjectNameCollection accountsUnSigned = new BPMObjectNameCollection();
accountsUnSigned.AddRange(accounts);
foreach (Footmark footmark in this)
{
if (accountsUnSigned.Contains(footmark.Account))
{
accountsUnSigned.Remove(footmark.Account);
}
}
UserCollection users = new UserCollection();
foreach (string account in accountsUnSigned)
{
if (users.Contains(account))
{
continue;
}
User user = User.TryGetUser(cn, account);
if (user != null)
{
users.Add(user);
}
}
return(users);
}
void _userOperationVM_OnSaved(object sender, User e)
{
UserCollection.Remove(e);
UserCollection.Add(e);
_hardwareOperationVM_OnClosed(sender, new EventArgs {
});
}
public void UpdateU()
{
try
{
UserCollection.Clear();
string sql = "SELECT Username, Password, Email FROM tblUser WHERE Username != @admin";
SqlCommand command = new SqlCommand(sql, sqlCon);
command.Parameters.AddWithValue("@admin", "admin");
sqlCon.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
User user = new User();
user.Username = reader.GetString(0);
user.Password = reader.GetString(1);
user.Email = reader.GetString(2);
UserCollection.Add(user);
}
reader.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
if (sqlCon != null)
{
sqlCon.Close();
}
}
}
public void SendChannelMessage(string msg, ClientSocket sender)
{
MinecraftHandler mc = Tunnel.MinecraftHandler;
char colorCode = mc.Config.ServerBroadcastColorChar;
List <Channel> channels = Channels.FindAll(x => x.User.IsInlist(sender.Name));
UserCollection users = new UserCollection();
foreach (Channel c in channels)
{
foreach (User u in c.User)
{
if (mc.IsStringInList(u.Name, mc.Player))
{
if (!users.IsInlist(u))
{
users.Add(u);
}
}
}
}
foreach (User player in users)
{
ClientSocket client = (ClientSocket)FindPlayer(player.Name);
if (client != null)
{
String message = string.Concat(new object[] { "§" + colorCode, msg });
foreach (var item in CreateList(message, 119))
{
client.SendPacket(3, ByteArythmetic.StoA(item));
}
}
}
}
public void OnUserSubmitButtonClicked(object sender, RoutedEventArgs e)
{
UserCollection.Add(new User(view.usernameTextBox.Text, view.emailTextBox.Text));
view.usernameTextBox.Text = "";
view.emailTextBox.Text = "";
}
public UserCollection GetAllUsersDynamicCollection(string where, string orderBy)
{
IDBManager dbm = new DBManager();
UserCollection col = new UserCollection();
try
{
dbm.CreateParameters(2);
dbm.AddParameters(0, "@WhereCondition", where);
dbm.AddParameters(1, "@OrderByExpression", orderBy);
IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectUsersDynamic");
while (reader.Read())
{
User user = new User();
user.ID = Int32.Parse(reader["ID"].ToString());
user.EmployeeID = Int32.Parse(reader["EmployeeID"].ToString());
user.UserName = reader["UserName"].ToString();
user.Password = reader["Password"].ToString();
col.Add(user);
}
}
catch (Exception ex)
{
log.Write(ex.Message, "GetAllUsersDynamicCollection");
}
finally
{
dbm.Dispose();
}
return(col);
}
public UserCollection SearchUser(string partialUsername)
{
if (skype.Friends.Count <= 0)
{
return(null);
}
UserCollection friends = new UserCollection();
try
{
foreach (User friend in skype.Friends)
{
if (friend.Handle.Contains(partialUsername))
{
friends.Add(friend);
}
}
}
catch
{
return(null);
}
return(friends);
}
public virtual UserCollection GetGroupUsers(HttpContext context)
{
YZRequest request = new YZRequest(context);
int groupid = request.GetInt32("groupid");
Group.MemberCollection members;
using (IYZDbProvider provider = YZDbProviderManager.DefaultProvider)
{
using (IDbConnection cn = provider.OpenConnection())
{
members = GroupManager.GetGroupMembers(provider, cn, groupid);
}
}
UserCollection users = new UserCollection();
using (BPMConnection cn = new BPMConnection())
{
cn.WebOpen();
foreach (Group.Member member in members)
{
User user = User.TryGetUser(cn, member.UID);
if (user != null)
{
users.Add(user);
}
}
}
return(users);
}
public virtual JObject Public(HttpContext context)
{
YZRequest request = new YZRequest(context);
this.ApproveCheck(context);
int taskid = request.GetInt32("TaskID");
JObject jPost = request.GetPostData <JObject>();
string comments = (string)jPost["comments"];
BPMObjectNameCollection accounts = jPost["uids"].ToObject <BPMObjectNameCollection>();
UserCollection users = new UserCollection();
using (BPMConnection cn = new BPMConnection())
{
cn.WebOpen();
foreach (string account in accounts)
{
User user = BPMTask.Public(cn, taskid, account);
users.Add(user);
}
JObject rv = new JObject();
rv[YZJsonProperty.success] = true;
rv["UserNameList"] = YZStringHelper.GetUserNameListString(users);
return(rv);
}
}
public override CommandResult Execute(String chan, String pw, String arg3, String arg4)
{
if (!String.IsNullOrEmpty(chan))
{
Channel channel = EasyGuess.GetMatchedChannel(((ServerSocket)Server).Channels, chan);
if (channel != null)
{
String str = "";
UserCollection usersOnline = new UserCollection();
foreach (User u in channel.User)
{
if (MinecraftHandler.IsStringInList(u.Name, MinecraftHandler.Player))
{
usersOnline.Add(u);
}
}
Server.SendExecuteResponse(TriggerPlayer, String.Format("Users in channel {0} ({1}): ", chan, usersOnline.Count));
foreach (User u in usersOnline)
{
str += u.Name + ", ";
}
if (!String.IsNullOrEmpty(str))
{
Server.SendExecuteResponse(TriggerPlayer, String.Format("{0}", str));
}
return(new CommandResult(true, String.Format("{0} executed cinfo", TriggerPlayer)));
}
return(new CommandResult(true, String.Format("Channel not found"), true));
}
else
{
List <Channel> channels = ((ServerSocket)Server).Channels.FindAll(x => x.User.IsInlist(TriggerPlayer));
Server.SendExecuteResponse(TriggerPlayer, String.Format("You're in the following channels: "));
String str = "";
foreach (Channel c in channels)
{
UserCollection usersOnline = new UserCollection();
foreach (User u in c.User)
{
if (MinecraftHandler.IsStringInList(u.Name, MinecraftHandler.Player))
{
usersOnline.Add(u);
}
}
str += String.Format("{0} ({1}), ", c.Name, usersOnline.Count);
}
if (!String.IsNullOrEmpty(str))
{
Server.SendExecuteResponse(TriggerPlayer, String.Format("{0}", str));
}
return(new CommandResult(true, String.Format("{0} executed cinfo", TriggerPlayer)));
}
}
/// <summary>
///
/// </summary>
/// <param name="roleName"></param>
/// <returns></returns>
public UserCollection GetUsersInRole(int roleID)
{
UserCollection collection = new UserCollection();
collection.Clear();
try
{
// Create SQL parameters
SqlParameter prmRoleID = new SqlParameter("@RoleID", SqlDbType.Int, 4);
prmRoleID.Direction = ParameterDirection.Input;
prmRoleID.Value = roleID;
// Execute procedure to update role
using (IDataReader dr = Database.ExecuteReader("UspGetUsersInRole", CommandType.StoredProcedure, prmRoleID))
{
while (dr.Read())
{
User user = Populate(dr);
collection.Add(user);
}
}
return(collection);
}
catch (Exception ex)
{
throw ex;
}
}
public static bool Save(User user)
{
if (user.Id < 0)
{
using (TransactionScope ts = new TransactionScope())
{
// Insert new user
bool userInserted = repo.Insert(user);
// Insert settings for the user
bool settingsInserted = settingsRepo.Insert(user);
// Complete transaction
if (userInserted && settingsInserted)
{
ts.Complete();
users.Add(user);
return(true);
}
else
{
// Do nothing
// Transaction will be rolled back.
}
}
}
else
{
return(repo.Update(user));
}
return(false);
}
public UserCollection GetAllUsersCollection()
{
IDBManager dbm = new DBManager();
UserCollection col = new UserCollection();
try
{
IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectUsersAll");
while (reader.Read())
{
User user = new User();
user.ID = Int32.Parse(reader["ID"].ToString());
user.EmployeeID = Int32.Parse(reader["EmployeeID"].ToString());
user.UserName = reader["UserName"].ToString();
user.Password = reader["Password"].ToString();
col.Add(user);
}
}
catch (Exception ex)
{
log.Write(ex.Message, "GetAllUsersCollection");
throw (ex);
}
finally
{
dbm.Dispose();
}
return(col);
}
/// <summary>
///
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public UserCollection FindUsersByUserName(string userName)
{
try
{
UserCollection collection = new UserCollection();
collection.Clear();
// create sql parameters
SqlParameter prmUserName = new SqlParameter("@UserName", SqlDbType.VarChar, 128);
prmUserName.Direction = ParameterDirection.Input;
prmUserName.Value = userName;
// Execute procedure
using (IDataReader dr = Database.ExecuteReader("UspFindUserByUserName", CommandType.StoredProcedure, prmUserName))
{
while (dr.Read())
{
User user = Populate(dr);
collection.Add(user);
}
}
return(collection);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public UserCollection GetAllUsers()
{
try
{
UserCollection collection = new UserCollection();
collection.Clear();
// Execute procedure
using (IDataReader dr = Database.ExecuteReader("UspGetAllUsers", CommandType.StoredProcedure))
{
while (dr.Read())
{
User user = Populate(dr);
collection.Add(user);
}
}
return(collection);
}
catch (Exception ex)
{
throw ex;
}
}
public void Add_AddingEquelKeysElements_ThrowsException()
{
UserCollection <UserType, string, string> c = new UserCollection <UserType, string, string>();
bool hasException = false;
c.Add(new Key(new UserType(1, "xyz"), "Mike"), "Employee");
try
{
c.Add(new Key(new UserType(1, "xyz"), "Mike"), "Superman");
}
catch (ArgumentOutOfRangeException e)
{
hasException = true;
}
Assert.IsTrue(hasException);
}
private void LoadCollectionFromCache()
{
foreach (BoardGameDataItem game in BoardGameStorage.CollectionGames)
{
UserCollection.Add(game);
}
UpdateCollectionForHub();
}
public void AddUser_AddsToCollection()
{
var users = new UserCollection();
users.Add(new User());
Assert.AreEqual(1, users.Count);
}
public override CommandResult Execute(String chan,String pw, String arg3, String arg4)
{
if (!String.IsNullOrEmpty(chan))
{
Channel channel = EasyGuess.GetMatchedChannel(((ServerSocket)Server).Channels, chan);
if (channel != null)
{
String str = "";
UserCollection usersOnline = new UserCollection();
foreach (User u in channel.User)
{
if (MinecraftHandler.IsStringInList(u.Name, MinecraftHandler.Player))
{
usersOnline.Add(u);
}
}
Server.SendExecuteResponse(TriggerPlayer, String.Format("Users in channel {0} ({1}): ", chan, usersOnline.Count));
foreach (User u in usersOnline)
{
str += u.Name + ", ";
}
if (!String.IsNullOrEmpty(str))
{
Server.SendExecuteResponse(TriggerPlayer, String.Format("{0}", str));
}
return new CommandResult(true, String.Format("{0} executed cinfo",TriggerPlayer));
}
return new CommandResult(true, String.Format("Channel not found"), true);
}
else
{
List<Channel> channels = ((ServerSocket)Server).Channels.FindAll(x => x.User.IsInlist(TriggerPlayer));
Server.SendExecuteResponse(TriggerPlayer, String.Format("You're in the following channels: "));
String str = "";
foreach (Channel c in channels)
{
UserCollection usersOnline = new UserCollection();
foreach (User u in c.User)
{
if (MinecraftHandler.IsStringInList(u.Name, MinecraftHandler.Player))
{
usersOnline.Add(u);
}
}
str += String.Format("{0} ({1}), ", c.Name, usersOnline.Count);
}
if (!String.IsNullOrEmpty(str))
{
Server.SendExecuteResponse(TriggerPlayer, String.Format("{0}", str));
}
return new CommandResult(true, String.Format("{0} executed cinfo", TriggerPlayer));
}
}
/// <summary>
/// Imports the new SiteUsers to the target SharePoint.
/// </summary>
/// <exception cref="ElementsMigrationException">If the migration fails</exception>
private void ImportNewUsers()
{
Console.WriteLine("import new Users...");
Logger.AddMessage("import new Users...");
UserCollection sourceUserCollection = this.GetAllUser(SourceClientContext);
UserCollection targetUserCollection = this.GetAllUser(TargetClientContext);
HashSet <string> targetUserNames = targetUserCollection.GetAllLoginNames();
foreach (var sourceUser in sourceUserCollection)
{
if (!targetUserNames.Contains(sourceUser.LoginName))
{
Console.WriteLine("Import user '{0}'", sourceUser.LoginName);
Logger.AddMessage("import User '" + sourceUser.LoginName + "'");
UserCreationInformation creationObject = new UserCreationInformation();
creationObject.Email = sourceUser.Email;
creationObject.LoginName = sourceUser.LoginName;
creationObject.Title = sourceUser.Title;
User targetUser = targetUserCollection.Add(creationObject);
try
{
targetUser.IsSiteAdmin = sourceUser.IsSiteAdmin;
}
catch (PropertyOrFieldNotInitializedException)
{
}
try
{
targetUser.Tag = sourceUser.Tag;
}
catch (PropertyOrFieldNotInitializedException)
{
}
}
else
{
Console.WriteLine("user '{0}' is already on target server. nothing to import.", sourceUser.LoginName);
Logger.AddMessage("don't have to import user '" + sourceUser.LoginName + "'");
}
}
try
{
TargetClientContext.ExecuteQuery();
}
catch (Exception e)
{
Console.WriteLine("Exception during importing the SiteUsers.", e);
Logger.AddMessage("Exception during importing the Users. Error = " + e.Message);
throw new ElementsMigrationException("Exception during importing the SiteUsers.", e);
}
}
public void ClearAndContainssKey_Adding2Remove1_ExpectedNothing()
{
UserCollection <UserType, string, string> c = new UserCollection <UserType, string, string>();
Key k1 = new Key(new UserType(1, "a"), "Mike");
Key k2 = new Key(new UserType(2, "b"), "Mike");
Key k3 = new Key(new UserType(2, "b"), "Jane");
c.Add(k1, "Employee");
c.Add(k2, "Manager");
c.Add(k3, "Looser");
c.Clear();
Assert.AreEqual(0, c.Count);
Assert.IsFalse(c.ContainsKey(k1));
Assert.IsFalse(c.ContainsKey(k2));
Assert.IsFalse(c.ContainsKey(k3));
}
public void Login(string connectionId)
{
if (!users.Where(user => user.ClientId == connectionId).Any())
{
User thisUser = new User();
thisUser.ClientId = connectionId;
users.Add(thisUser);
}
}
/// <summary>
/// 根据动态参数查询用户
/// </summary>
/// <param name="strFields"></param>
/// <param name="strValues"></param>
/// <returns></returns>
public static UserCollection GetUser(List <QueryElement> list)
{
StringBuilder sb = new StringBuilder();
UserCollection coll = new UserCollection();
sb.AppendFormat("{0} ", "select * from user where 1=1");
if (list.Count > 0)
{
MySqlParameter[] pars = new MySqlParameter[list.Count];
for (int i = 0; i < list.Count; i++)
{
QueryElement query = list[i];
sb.AppendFormat("{0} {1} {2} @{3} ", query.QueryLogic, query.Queryname, query.QueryOperation, query.Queryname);
pars[i] = new MySqlParameter("@" + query.Queryname, query.QueryElementType);
if (query.QueryOperation.Equals("like"))
{
pars[i].Value = "%" + query.Queryvalue + "%";
}
else
{
pars[i].Value = query.Queryvalue;
}
}
using (MySqlDataReader reader = MySqlDBHelper.GetReader(sb.ToString(), pars))
{
while (reader.Read())
{
coll.Add(new UserInfo(reader));
}
}
}
else
{
using (MySqlDataReader reader = MySqlDBHelper.GetReader(sb.ToString()))
{
while (reader.Read())
{
coll.Add(new UserInfo(reader));
}
}
}
return(coll);
}
public static UserCollection GetUsers(List <int> userIDs)
{
UserCollection users = new UserCollection();
foreach (int id in userIDs)
{
users.Add(GetUser(id));
}
return(users);
}
public void ValuesByName_Adding3AndSearch_Ok()
{
UserCollection <UserType, string, string> c = new UserCollection <UserType, string, string>();
Key k1 = new Key(new UserType(1, "a"), "Mike");
Key k2 = new Key(new UserType(2, "b"), "Mike");
Key k3 = new Key(new UserType(2, "b"), "Jane");
c.Add(k1, "Employee");
c.Add(k2, "Manager");
c.Add(k3, "Looser");
var d1 = c.SearchByName("Jane");
var d2 = c.SearchByName("Mike");
Assert.AreEqual(1, d1.Count);
Assert.AreEqual(2, d2.Count);
Assert.AreEqual("Employee", d2[new UserType(1, "a")]);
Assert.AreEqual("Manager", d2[new UserType(2, "b")]);
Assert.AreEqual("Looser", d1[new UserType(2, "b")]);
}
private async void LoadUsers()
{
var users = await _userDataService.GetUsersAsync();
UserCollection.Clear();
foreach (var item in users)
{
UserCollection.Add(item);
}
RaisePropertyChanged(() => UserCollection);
}
public void DoNotDuplicateUserWhenCallingGetUser()
{
var collection = new UserCollection();
var user = new User("Test");
collection.Add(user);
var user2 = collection.GetUser("Test");
Assert.Single(collection);
Assert.Same(user, user2);
}
public void Should_send_message_to_group()
{
var oSkype = new Skype();
if (oSkype.Client.IsRunning == false)
{
oSkype.Client.Start(false, true);
}
UserCollection users = oSkype.Friends;
foreach (User f in users)
{
Console.WriteLine(f.DisplayName + "|" + f.FullName + "|" + f.Handle);
}
//var msg = oSkype.SendMessage("testgogroups", "some text...");
var om = new UserCollection();
om.Add(oSkype.get_User("testgogroups"));
om.Add(oSkype.get_User("jonny.plankton"));
var oc = oSkype.CreateChatMultiple(om);
oc.OpenWindow();
//oc.Topic = "Build is broken";
oc.SendMessage("Build is broken");
oc.Leave();
}
internal static UserCollection CollectAll()
{
var dataTable = DatabaseController.ExecuteSelectQuery("SELECT * FROM " + TABLE_NAME);
var collection = new UserCollection();
foreach (DataRow dataRow in dataTable.Rows)
{
var item = new User();
item.SetPropertiesFromDataRow(dataRow);
collection.Add(item);
}
return(collection);
}
public static UserCollection GetUsers(List<int> userIDs)
{
UserCollection users = new UserCollection();
foreach (int id in userIDs) {
users.Add(GetUser(id));
}
return users;
}
public UserCollection SearchUser(string partialUsername)
{
if( skype.Friends.Count <= 0)
return null;
UserCollection friends = new UserCollection();
try
{
foreach (User friend in skype.Friends)
{
if (friend.Handle.Contains(partialUsername))
friends.Add(friend);
}
}
catch
{
return null;
}
return friends;
}
public override UserCollection GetUserShows(int userID, int pageNumber, int pageSize, out Dictionary<int, int> points, out Dictionary<int, string> contents)
{
using (SqlQuery query = new SqlQuery())
{
query.Pager.TableName = "bx_PointShowUsers";
query.Pager.SortField = "[Price]";
query.Pager.IsDesc = true;
query.Pager.PageNumber = pageNumber;
query.Pager.PageSize = pageSize;
query.Pager.SelectCount = true;
query.Pager.PrimaryKey = "[UserID]";
using (XSqlDataReader reader = query.ExecuteReader())
{
UserCollection users = new UserCollection();
points = new Dictionary<int, int>();
contents = new Dictionary<int, string>();
while (reader.Read())
{
User user = new User(reader);
users.Add(user);
points.Add(user.UserID, reader.Get<int>("Price"));
contents.Add(user.UserID, reader.Get<string>("Content"));
}
if (reader.NextResult())
{
while (reader.Read())
{
users.TotalRecords = reader.Get<int>(0);
}
}
return users;
}
}
}
///// <summary>
///// 查询一条用户记录.
///// </summary>
///// <param name="userName">用户名</param>
///// <returns>User 模型</returns>
//public User GetSingleUser(string userName)
//{
// string sql = "SELECT * FROM [T_Users] WHERE UserName=@UserName";
// OleDbParameter[] parms = {new OleDbParameter("@UserName",OleDbType.VarChar,50)};
// parms[0].Value = userName;
// DataTable table = DbHelper.ExecuteDataTable(sql, parms);
// User tUser = null;
// if (table.Rows.Count > 0)
// {
// tUser = new User();
// tUser.UID = Convert.ToInt32(table.Rows[0]["UID"]);
// tUser.UserName = table.Rows[0]["UserName"].ToString();
// tUser.Pwd = table.Rows[0]["Pwd"].ToString();
// tUser.JoinDate = Convert.ToDateTime(table.Rows[0]["JoinDate"]);
// tUser.Login_IP = table.Rows[0]["Login_IP"].ToString();
// tUser.Login_Date = Convert.ToDateTime(table.Rows[0]["Login_Date"]);
// }
// return tUser;
//}
/// <summary>
/// 查询用户 所有用户
/// </summary>
/// <returns>UserCollection 包含所有记录.</returns>
public static UserCollection GetList()
{
UserCollection list = new UserCollection();
string sql = "select * from T_Users";
MySqlDataReader reader = DbHelper.ExecuteDataReader(sql);
if (reader.HasRows)
{
list = new UserCollection();
while (reader.Read())
{
list.Add(FillDataRecord(reader));
}
}
reader.Close();
return list;
}
/// <summary>
/// Returns the user's friends who have most recently updated, each with current status inline.
/// </summary>
public UserCollection GetFriends(int userId)
{
try
{
UserCollection users = new UserCollection();
int friendsCount;
if (currentLoggedInUser != null && currentLoggedInUser.Id == userId)
{
friendsCount = CurrentlyLoggedInUser.FollowingCount;
}
else
{
// need to make an extra call to twitter
User user = GetUser(userId);
friendsCount = user.FollowingCount;
}
var ceiling = Math.Ceiling(friendsCount / 100m);
var results = new List<TwitterUser>();
for (var i = 1; i <= ceiling; i++)
{
var friends = FluentTwitter.CreateRequest(new Dimebrain.TweetSharp.TwitterClientInfo() { ClientName = "Witty" })
.AuthenticateAs(username, ToInsecureString(password))
.Users().GetFriends().For(userId)
.Skip(i).AsJson()
.Request().AsUsers();
results.AddRange(friends);
}
foreach (TwitterUser user in results)
users.Add(CreateUser(user));
return users;
}
catch
{
return null;
}
}
public void SendChannelMessage(string msg, ClientSocket sender)
{
MinecraftHandler mc = Tunnel.MinecraftHandler;
char colorCode = mc.Config.ServerBroadcastColorChar;
List<Channel> channels = Channels.FindAll(x => x.User.IsInlist(sender.Name));
UserCollection users = new UserCollection();
foreach (Channel c in channels)
{
foreach (User u in c.User)
{
if (mc.IsStringInList(u.Name, mc.Player))
{
if (!users.IsInlist(u))
{
users.Add(u);
}
}
}
}
foreach (User player in users)
{
ClientSocket client = (ClientSocket)FindPlayer(player.Name);
if (client != null)
{
String message = string.Concat(new object[] { "§" + colorCode, msg });
foreach (var item in CreateList(message, 119))
{
client.SendPacket(3, ByteArythmetic.StoA(item));
}
}
}
}
public UserCollection QueryAll()
{
UserCollection collection = new UserCollection();
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandText = "SP_SEL_Table";
SqlParameter _param = command.Parameters.Add("@value1", System.Data.SqlDbType.VarChar);
_param.Value = "Users";
SqlParameter _param2 = command.Parameters.Add("@value2", System.Data.SqlDbType.VarChar);
_param2.Value = "";
SqlParameter _param3 = command.Parameters.Add("@value3", System.Data.SqlDbType.VarChar);
_param3.Value = "";
SqlParameter _param4 = command.Parameters.Add("@order_by1", System.Data.SqlDbType.VarChar);
_param4.Value = "2";
SqlParameter _param5 = command.Parameters.Add("@order_by2", System.Data.SqlDbType.TinyInt);
_param5.Value = 0;
command.CommandType = System.Data.CommandType.StoredProcedure;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
User user = new User();
user.UserID = Convert.ToInt32(reader["ID"]);
user.UserName = reader["UserAccount"].ToString();
user.Enable = Convert.ToInt32(reader["Enable"]);
collection.Add(user);
}
}
reader.Close();
return collection;
}
}