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