public bool AddMessage(MessageInfo msg)
{
string query = "CHAT.MESSAGE_CREATE";
try
{
OracleDataHelper helper = OracleHelper;
helper.BeginTransaction();
helper.ExecuteNonQuery(query, msg.Id, msg.SenderId, msg.ReceiverId, msg.Content, msg.Datetime, msg.MessageType);
helper.Commit();
}
catch (Exception ex)
{
OracleHelper.Rollback();
throw ex;
}
return true;
}
static void Main(string[] args)
{
MessageInfo msg1 = new MessageInfo("11111111111112", "1", "2", DateTime.Parse("31-AUG-2015"), "Hello", 100);
MessageInfo msg2 = new MessageInfo("22222222222223", "1", "33333", DateTime.Parse("28-AUG-2015"), "Hello", 200);
MessageInfo msg3 = new MessageInfo("33333333333334", "2", "1", DateTime.Parse("25-AUG-2015"), "HAHA", 100);
MessageInfo msg4 = new MessageInfo("44444444444445", "1", "USER", DateTime.Parse("22-AUG-2015"), "Hello", 300);
//ChatController.AddMessage(msg1);
//ChatController.AddMessage(msg2);
//ChatController.AddMessage(msg3);
//ChatController.AddMessage(msg4);
DateTime todate = Convert.ToDateTime("09-SEP-2015");
List<MessageInfo> messageList = ChatController.SearchMessage("1", "2", DateTime.MinValue, todate, 100);
//Dictionary<string, AddFriendRequest> dict = ChatController.GetFriendRequest("2");
//Dictionary<string, InviteGroupRequest> dict2 = ChatController.GetGroupRequest("2");
//List<GroupInfo> grouplist = ChatController.SearchGroup("");
//List<CustomerInfo> cusList = ChatController.SearchCustomer("");
//List<MessageInfo> msg = ChatController.SearchMessage("1", "2", DateTime.MinValue, DateTime.MaxValue).OrderBy(t => t.Datetime).ToList();
DBManager manager = new DBManager();
Console.ReadLine();
}
public List<MessageInfo> mapMessage(IDataReader record)
{
List<MessageInfo> messageList = new List<MessageInfo>();
while (record.Read())
{
MessageInfo msg = new MessageInfo();
if (record["messageId"] != DBNull.Value)
msg.Id = record["messageId"].ToString();
if (record["senderId"] != DBNull.Value)
msg.SenderId = record["senderId"].ToString();
if (record["receiverId"] != DBNull.Value)
msg.ReceiverId = record["receiverId"].ToString();
if (record["content"] != DBNull.Value)
msg.Content = record["content"].ToString();
if (record["datetime"] != DBNull.Value)
msg.Datetime = DateTime.Parse(record["datetime"].ToString());
if (record["messagetype"] != DBNull.Value)
msg.MessageType = int.Parse(record["messagetype"].ToString());
messageList.Add(msg);
}
return messageList;
}
public static bool AddMessage(MessageInfo msg)
{
return ObjectController.DataProvider.AddMessage(msg);
}
