public JSONObject ToJson()
{
JSONObject obj = new JSONObject();
obj.Add("status", new JSONString(status.ToString()));
obj.Add("requestInfo", new JSONString(requestInfo));
obj.Add("time", new JSONString(requestTime.ToFileTime().ToString()));
obj.Add("requestor", requestor.ToString());
obj.Add("song", song);
return(obj);
}
private static Status universalRetriver(string query, SqlCommand cmd, int type)
{
SqlConnection con = new SqlConnection(ConnectionInit.ConnectionString);
Status status = new Status();
status.State = 0;
status.Exception = "not found";
status.Json_data = "[";
try
{
con.Open();
cmd.Connection = con;
cmd.CommandText = query;
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.HasRows)
{
while (reader.Read())
{
if (type == GET_USERS_AND_CHATS)
{
ChatUser chat = initChatUser(reader);
status.Json_data += chat.ToString() + ",";
}
else if (type == GET_CHATS)
{
Chat chat = initChat(reader);
status.Json_data += chat.ToString() + ",";
}
else if (type == UNREADED_MESSAGE)
{
Message message = initMessage(reader);
status.Json_data += message + ",";
}
}
reader.NextResult();
}
status.Json_data = status.Json_data.Remove(status.Json_data.Length - 1);
status.State = 1;
status.Exception = "Done";
status.Json_data += "]";
}
else
{
status.State = 0;
status.Exception = "not found";
status.Json_data = "";
}
reader.Close();
}
catch (Exception e1)
{
status.State = -1;
status.Exception = e1.Message;
}
finally
{
con.Close();
}
return(status);
}
public void ToStringTest()
{
ChatUser user = new ChatUser(1, "name");
Assert.AreEqual("name#1", user.ToString());
}
