/// <summary>
/// Get Chat Registered User List Golbal Chat Users List DLL.
/// </summary>
/// <param name="inputModel" cref="SocialCommunicationModels.ChatInputAndOutputModels.InputModel.chatRegisterUserModel">Chat Common Input Model.</param>
/// <returns cref="SocialCommunicationModels.ChatInputAndOutputModels.OutputModel.ChatRegisteredUsers">Chat Common output Model.</returns>
/// <seealso cref="SocialCommunicationModels.ChatInputAndOutputModels.InputModel.chatRegisterUserModel"/>
/// <seealso cref="SocialCommunicationModels.ChatInputAndOutputModels.OutputModel.ChatRegisteredUsers"/>
public OutputModel ChatRegisteredUsersGet(InputModel inputModel)
{
OutputModel outputModel = null;
ChatRegisterUserModel ChatUser;
SqlCommand command = SqlServerCommon.GetSpCommandByConnectToDb(SqlServerCommon.SqlServerDBs.DbAdmin, "usp_ChatRegisterUsers_Get");
command.AddParameter("@UserID", SqlDbType.Int, inputModel.chatRegisterUserModel.UserId.ToString());
command.AddCommonInputParams();
using (IDataReader reader = command.ExecuteReader())
{
outputModel = new OutputModel();
outputModel.ChatRegisteredUsers = new List <ChatRegisterUserModel>();
reader.AddCol("UserName");
reader.AddCol("UserId");
while (reader.Read())
{
ChatUser = new ChatRegisterUserModel()
{
UserName = reader.GetDbColValue("UserName", string.Empty),
UserId = reader.GetDbColValue("UserId", -1),
};
outputModel.ChatRegisteredUsers.Add(ChatUser);
}
}
if (outputModel.ChatRegisteredUsers.Count == 0)
{
outputModel.responseModel = new ResponseModel();
command.GetCommonOutputParams(outputModel.responseModel);
}
command.ConnectionDispose();
return(outputModel);
}
/// <summary>
/// Chat User Without Friends of Particular User DLL Member.
/// </summary>
/// <param name="inputModel" cref="SocialCommunicationModels.ChatInputAndOutputModels.InputModel.chatRegisterUserModel">Chat Common Input Model.</param>
/// <returns cref="SocialCommunicationModels.ChatInputAndOutputModels.OutputModel.ChatRegisteredUsers">Chat Common Output Model.</returns>
/// <seealso cref="SocialCommunicationModels.ChatInputAndOutputModels.InputModel.chatRegisterUserModel"/>
/// <seealso cref="SocialCommunicationModels.ChatInputAndOutputModels.OutputModel.ChatRegisteredUsers"/>
public OutputModel ChatUsersWithoutFriendsGet(InputModel inputModel)
{
OutputModel outputModel;
ChatRegisterUserModel Frined;
SqlCommand command = SqlServerCommon.GetSpCommandByConnectToDb(SqlServerCommon.SqlServerDBs.DbAdmin, "usp_ChatRegisterUsersWithoutFriends_Get");
command.AddParameter("@UserID", System.Data.SqlDbType.Int, inputModel.chatRegisterUserModel.UserId.ToString());
command.AddCommonInputParams();
using (IDataReader reader = command.ExecuteReader())
{
outputModel = new OutputModel();
outputModel.Friends = new List <ChatRegisterUserModel>();
reader.AddCol("UserId");
reader.AddCol("UserName");
while (reader.Read())
{
Frined = new ChatRegisterUserModel();
Frined.UserId = reader.GetDbColValue("UserId", 0);
Frined.UserName = reader.GetDbColValue("UserName", string.Empty);
outputModel.Friends.Add(Frined);
}
}
if (outputModel?.Friends?.Count == 0)
{
outputModel.responseModel = new ResponseModel();
command.GetCommonOutputParams(outputModel.responseModel);
}
command.ConnectionDispose();
return(outputModel);
}
