public void ProcessRequest(HttpContext context)
{
HPCBusinessLogic.NguoidungDAL _NguoidungDAL = new NguoidungDAL();
DataTable dt = new DataTable();
string sqlselect = string.Empty;
string type = context.Request.QueryString["type"].Split('?').GetValue(0).ToString();
string searchText = context.Request.QueryString["term"];
Collection <AutoCompleteDTO> collection;
collection = new Collection <AutoCompleteDTO>();
AutoCompleteDTO dto;
if (type == "1")
{
sqlselect = "select top 20 Ma_Nguoidung, LTRIM(RTRIM(TenDaydu))+case when Loai=1 then ' -- (CTV)' when Loai=0 then '' end as Ten_Dangnhap from T_Nguoidung where (Trangthai_Xoa=0 or Trangthai_Xoa is null) and TenDaydu LIKE N'%" + searchText.Trim() + "%' and Ten_Dangnhap is not null";
dt = Ulti.ExecSqlDataSet(sqlselect).Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
dto = new AutoCompleteDTO();
dto.value = dto.label = (string)dt.Rows[i]["Ten_Dangnhap"];
dto.id = Convert.ToString(dt.Rows[i]["Ma_Nguoidung"]);
collection.Add(dto);
}
}
if (type == "2")
{
string _where = "IsDeleted = 0 and UserFullName LIKE N'%" + searchText.Trim() + "%'";
dt = _NguoidungDAL.GetT_User_Dynamic(_where).Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
dto = new AutoCompleteDTO();
dto.value = dto.label = (string)dt.Rows[i]["UserFullName"];
dto.id = Convert.ToString(dt.Rows[i]["UserID"]);
collection.Add(dto);
}
}
JavaScriptSerializer serializer = new JavaScriptSerializer();
string jsonString = serializer.Serialize(collection);
context.Response.Write(jsonString);
}
public List <AutoCompleteDTO> GetAllMembers(string prefixTxt)
{
//GetCompletionList
MessagesDAL member = new MessagesDAL();
List <Member> members = member.SearchMember(prefixTxt);
List <Group> groups = member.SearchGroup(prefixTxt);
AutoCompleteDTO auto;
List <AutoCompleteDTO> items = new List <AutoCompleteDTO>();
string[,] mmb = new string[1, 2];
//ADDING MEMBERS TO LIST
foreach (var element in members)
{
if (element.MemberId == HttpContext.Current.Session["memberID"].ToString())
{
//DO NOT ADD
}
else
{
auto = new AutoCompleteDTO(element.MemberId, element.DisplayName, "People");
items.Add(auto);
}
}
//ADDING GROUPS TO LIST
foreach (var element in groups)
{
if (element.MemberId == HttpContext.Current.Session["memberID"].ToString())
{
//DO NOT ADD
}
else
{
auto = new AutoCompleteDTO(element.GroupId.ToString(), element.GroupDescription, "Groups");
items.Add(auto);
}
}
return(items);
}
public List<AutoCompleteDTO> GetAllMembers(string prefixTxt)
{
//GetCompletionList
MessagesDAL member = new MessagesDAL();
List<Member> members = member.SearchMember(prefixTxt);
List<Group> groups = member.SearchGroup(prefixTxt);
AutoCompleteDTO auto;
List<AutoCompleteDTO> items = new List<AutoCompleteDTO>();
string[,] mmb = new string[1, 2];
//ADDING MEMBERS TO LIST
foreach (var element in members)
{
if (element.MemberId == HttpContext.Current.Session["memberID"].ToString())
{
//DO NOT ADD
}
else
{
auto = new AutoCompleteDTO(element.MemberId, element.DisplayName, "People");
items.Add(auto);
}
}
//ADDING GROUPS TO LIST
foreach (var element in groups)
{
if (element.MemberId == HttpContext.Current.Session["memberID"].ToString())
{
//DO NOT ADD
}
else
{
auto = new AutoCompleteDTO(element.GroupId.ToString(), element.GroupDescription, "Groups");
items.Add(auto);
}
}
return items;
}
public List<AutoCompleteDTO> GetAllFriends(string prefixTxt)
{
//GetCompletionList
MessagesDAL member = new MessagesDAL();
List<Member> members = member.SearchMember(prefixTxt);
AutoCompleteDTO auto;
List<AutoCompleteDTO> items = new List<AutoCompleteDTO>();
string[,] mmb = new string[1,2];
foreach (var element in members)
{
auto = new AutoCompleteDTO(element.MemberId, element.DisplayName);
items.Add(auto);
}
return items;
}
public List <AutoCompleteDTO> GetAllFriends(string prefixTxt)
{
//GetCompletionList
MessagesDAL member = new MessagesDAL();
List <Member> members = member.SearchMember(prefixTxt);
AutoCompleteDTO auto;
List <AutoCompleteDTO> items = new List <AutoCompleteDTO>();
string[,] mmb = new string[1, 2];
foreach (var element in members)
{
auto = new AutoCompleteDTO(element.MemberId, element.DisplayName);
items.Add(auto);
}
return(items);
}
public List <AutoCompleteDTO> GetUntaggedFriends(string prefixTxt, int postID)
{
Member m;
Post p;
MessagesDAL member = new MessagesDAL();
List <Member> members = member.SearchUntaggedMember(m = new Member(Context.Session["memberID"].ToString(), prefixTxt), p = new Post(postID));
AutoCompleteDTO auto;
List <AutoCompleteDTO> items = new List <AutoCompleteDTO>();
string[,] mmb = new string[1, 2];
foreach (var element in members)
{
auto = new AutoCompleteDTO(element.MemberId, element.DisplayName);
items.Add(auto);
}
return(items);
}
public List<AutoCompleteDTO> GetUntaggedFriends(string prefixTxt, int postID)
{
Member m;
Post p;
MessagesDAL member = new MessagesDAL();
List<Member> members = member.SearchUntaggedMember(m = new Member(Context.Session["memberID"].ToString(), prefixTxt), p = new Post(postID));
AutoCompleteDTO auto;
List<AutoCompleteDTO> items = new List<AutoCompleteDTO>();
string[,] mmb = new string[1, 2];
foreach (var element in members)
{
auto = new AutoCompleteDTO(element.MemberId, element.DisplayName);
items.Add(auto);
}
return items;
}
