public List <MessageInfo> GetBroadcastMessage(string customerId)
{
string query = "CHAT.GETBROADCASTMESSAGE";
IDataReader reader = OracleHelper.ExecuteReader(query, customerId);
Mapper map = new Mapper();
return(map.mapMessage(reader));
}
public List <MessageInfo> GetOfflineMessageGroup(string customerId, string groupId)
{
string query = "CHAT.GETOFFLINEMESSAGEGROUP";
IDataReader reader = OracleHelper.ExecuteReader(query, customerId, groupId);
Mapper map = new Mapper();
return(map.mapMessage(reader));
}
public List <MessageInfo> SearchMessage(string senderId, string receiverId, DateTime fromDate, DateTime toDate, int messageType)
{
string query = "CHAT.MESSAGE_SEARCH";
IDataReader reader = OracleHelper.ExecuteReader(query, senderId, receiverId, fromDate, toDate, messageType);
Mapper map = new Mapper();
return(map.mapMessage(reader));
}
public List<MessageInfo> SearchMessage(string senderId, string receiverId, DateTime fromDate, DateTime toDate, int messageType)
{
string query = "CHAT.MESSAGE_SEARCH";
IDataReader reader = OracleHelper.ExecuteReader(query, senderId, receiverId, fromDate, toDate, messageType);
Mapper map = new Mapper();
return map.mapMessage(reader);
}
public List<MessageInfo> GetOfflineMessageGroup(string customerId, string groupId)
{
string query = "CHAT.GETOFFLINEMESSAGEGROUP";
IDataReader reader = OracleHelper.ExecuteReader(query, customerId, groupId);
Mapper map = new Mapper();
return map.mapMessage(reader);
}
public List<MessageInfo> GetBroadcastMessage(string customerId)
{
string query = "CHAT.GETBROADCASTMESSAGE";
IDataReader reader = OracleHelper.ExecuteReader(query, customerId);
Mapper map = new Mapper();
return map.mapMessage(reader);
}