/// <summary>
/// returns all Descendant or OffSpring Items
/// </summary>
/// <param name="CategoryId"></param>
/// <returns></returns>
public DataTable GetAllDescendantItems(int CategoryId)
{
SqlCommand procedure = DBUtils.StoredProcedure("Items_GetCategoryDescendants", cte.lib);
DBUtils.AddProcedureParameter(procedure, "@CategoryId", SqlDbType.Int, CategoryId, ParameterDirection.Input);
return(DBUtils.GetDataSet(procedure, cte.lib).Tables[0]);
}
public void UpdateConversationStatus(int ConversationId, int UserId, ConversationStatus Status)
{
SqlCommand command = DBUtils.StoredProcedure("Chat_UpdateConversationStatus", cte.lib);
DBUtils.AddProcedureParameter(command, "@ConversationId", SqlDbType.Int, ConversationId, ParameterDirection.Input);
DBUtils.AddProcedureParameter(command, "@UserId", SqlDbType.Int, UserId, ParameterDirection.Input);
DBUtils.AddProcedureParameter(command, "@Status", SqlDbType.Int, (int)Status, ParameterDirection.Input);
command.Connection.Open();
command.ExecuteNonQuery();
command.Connection.Close();
}
public int LeaveUser(int userId2, int convId)
{
SqlCommand command = DBUtils.StoredProcedure("Chat_LeaveUser", cte.lib);
DBUtils.AddProcedureParameter(command, "@convId", SqlDbType.Int, convId, ParameterDirection.Input);
DBUtils.AddProcedureParameter(command, "@userTo", SqlDbType.Int, userId2, ParameterDirection.Input);
DBUtils.AddProcedureParameter(command, "@ConversationId", SqlDbType.Int, -1, ParameterDirection.Output);
command.Connection.Open();
command.ExecuteNonQuery();
int conversationId = (int)command.Parameters["@ConversationId"].Value;
command.Connection.Close();
return(conversationId);
}
/// <summary>
/// Sends a message to the conversation opening all pending conversation for receiptions
/// </summary>
/// <param name="UserFrom">User Id</param>
/// <param name="ConversationId">ConversationId</param>
/// <param name="Message">Chat Message</param>
/// <returns>MessageId can be used to communicate with client messageid</returns>
public int SendMessage(int UserFrom, int ConversationId, string Message)
{
SqlCommand command = DBUtils.StoredProcedure("Chat_SendMessage", cte.lib);
DBUtils.AddProcedureParameter(command, "@UserFrom", SqlDbType.Int, UserFrom, ParameterDirection.Input);
DBUtils.AddProcedureParameter(command, "@ConversationId", SqlDbType.Int, ConversationId, ParameterDirection.Input);
DBUtils.AddProcedureParameter(command, "@Message", SqlDbType.NText, Message, ParameterDirection.Input);
DBUtils.AddProcedureParameter(command, "@MessageId", SqlDbType.Int, -1, ParameterDirection.Output);
command.Connection.Open();
command.ExecuteNonQuery();
int MessageId = (int)command.Parameters["@MessageId"].Value;
command.Connection.Close();
return(MessageId);
}