public List<GroupInfo> SearchGroup(string name)
{
string query = "CHAT.GROUP_SEARCH";
IDataReader reader = OracleHelper.ExecuteReader(query, name);
Mapper map = new Mapper();
List<GroupInfo> groupList = map.mapGroupByName(reader);
if (groupList == null)
return null;
foreach (GroupInfo group in groupList)
{
group.CustomerList = GetCustomersInGroup(group.GroupId);
group.AdminList = GetAdminsInGroup(group.GroupId);
}
return groupList;
}
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<CustomerInfo> SearchCustomer(string customerName)
{
string query = "CHAT.CUSTOMER_SEARCH";
IDataReader reader = OracleHelper.ExecuteReader(query, customerName);
Mapper map = new Mapper();
List<CustomerInfo> cusList = map.mapCustomerByName(reader);
return cusList;
}
public InviteGroupRequest GetGroupRequestById(string requestId)
{
string query = "CHAT.GROUPREQUEST_GETBYID";
IDataReader reader = OracleHelper.ExecuteReader(query, requestId);
Mapper map = new Mapper();
return map.MapGroupRequestById(reader);
}
public List<string> GetGroupsOfCustomer(string customerId)
{
string query = "CHAT.GETGROUPSOFCUSTOMER";
IDataReader reader = OracleHelper.ExecuteReader(query, customerId);
Mapper map = new Mapper();
return map.MapGroupList(reader);
}
public GroupInfo GetGroup(string groupId)
{
string query = "CHAT.GROUP_GET_BYID";
IDataReader reader = OracleHelper.ExecuteReader(query, groupId);
Mapper map = new Mapper();
GroupInfo group = map.mapGroupByID(reader);
if (group == null)
return null;
group.CustomerList = GetCustomersInGroup(group.GroupId);
group.AdminList = GetAdminsInGroup(group.GroupId);
return group;
}
public Dictionary<string, InviteGroupRequest> GetGroupRequest(string customerId)
{
string query = "CHAT.GROUPREQUEST_GET";
IDataReader reader = OracleHelper.ExecuteReader(query, customerId);
Mapper map = new Mapper();
return map.MapGroupRequest(reader);
}
public Dictionary<string, AddFriendRequest> GetFriendRequest(string customerId)
{
string query = "CHAT.FRIENDREQUEST_GET";
IDataReader reader = OracleHelper.ExecuteReader(query, customerId);
Mapper map = new Mapper();
return map.MapFriendRequest(reader);
}
public AddFriendRequest GetFriendRequestById(string requestId)
{
string query = "CHAT.FRIENDREQUEST_GETBYID";
IDataReader reader = OracleHelper.ExecuteReader(query, requestId);
Mapper map = new Mapper();
return map.MapFriendRequestById(reader);
}
public List<string> GetFriendList(string customerId)
{
string query = "CHAT.FRIEND_GET";
IDataReader reader = OracleHelper.ExecuteReader(query, customerId);
Mapper map = new Mapper();
return map.MapFriendList(reader);
}
public List<string> GetCustomersInGroup(string groupId)
{
string query = "CHAT.GETCUSTOMERSINGROUP";
IDataReader reader = OracleHelper.ExecuteReader(query, groupId);
Mapper map = new Mapper();
return map.MapCustomerList(reader);
}
public CustomerInfo GetCustomer(string customerId)
{
string query = "CHAT.CUSTOMER_GET";
IDataReader reader = OracleHelper.ExecuteReader(query, customerId);
Mapper map = new Mapper();
CustomerInfo cus = map.MapCustomerByID(reader);
if (cus == null)
return null;
cus.FriendList = GetFriendList(customerId);
cus.GroupList = GetGroupsOfCustomer(customerId);
return cus;
}
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<string> GetAdminsInGroup(string groupId)
{
string query = "CHAT.GETADMINSINGROUP";
IDataReader reader = OracleHelper.ExecuteReader(query, groupId);
Mapper map = new Mapper();
return map.MapAdminList(reader);
}
