public async Task <string> FindUsersByPageAndIdGroup(string token, string idGroup, int page)
{
string apiURI = APIs.GetListSubmissionsURL(Keywords.USER.ToLower()) + "?select=data";
if (page == 0)
{
// If page = 0 => get full data
apiURI += "&limit=" + Configs.LIMIT_QUERY;
}
else
{
apiURI += "&limit=" + Configs.NUMBER_ROWS_PER_PAGE + "&skip=" + (page - 1) * Configs.NUMBER_ROWS_PER_PAGE;
}
apiURI += "&data.idGroup=" + idGroup;
HttpResponseMessage response = await _httpUtil.GetAsync(token, apiURI);
if (response == null || !response.IsSuccessStatusCode)
{
return("[]");
}
string content = await response.Content.ReadAsStringAsync();
return(content);
}
public async Task <Group> FindGroupParent(string token, string condition)
{
string apiURI = APIs.GetListSubmissionsURL(Keywords.GROUP) + "?select=data&" + condition;
HttpResponseMessage response = await _httpUtil.GetAsync(token, apiURI);
if (response == null || !response.IsSuccessStatusCode)
{
return(null);
}
string content = await response.Content.ReadAsStringAsync();
JArray jArray = JArray.Parse(content);
if (jArray.Count == 0)
{
return(null);
}
JObject jObject = jArray.Children <JObject>().FirstOrDefault();
JObject dataObject = (JObject)jObject.GetValue(Keywords.DATA);
string id = jObject.GetValue(Keywords.ID).ToString();
string idGroup = dataObject.GetValue(Keywords.ID_GROUP).ToString();
string name = dataObject.GetValue(Keywords.NAME).ToString();
string idParent = dataObject.GetValue(Keywords.ID_PARENT).ToString();
string nameParent = string.Empty;
return(new Group(id, idGroup, name, idParent, nameParent));
}
public async Task <string> UpdateUserInfo(User user, string path)
{
JObject info = new JObject {
{ Keywords.EMAIL, user.Email },
{ Keywords.NAME, user.Name },
{ Keywords.ID_GROUP, user.IdGroup },
{ Keywords.PERMISSION, Keywords.USER.ToLower() },
{ Keywords.GENDER, user.Gender },
{ Keywords.PHONE, user.PhoneNumber },
{ Keywords.ADDRESS, user.Address },
{ Keywords.STATUS, 1 },
{ Keywords.SUBMIT, true }
};
JObject data = new JObject {
{ Keywords.DATA, info }
};
string apiURI = APIs.GetListSubmissionsURL(path) + "/" + user.Id;
HttpResponseMessage response = await _httpUtil.PutAsync(user.Token, apiURI, JsonConvert.SerializeObject(data));
if (response == null || !response.IsSuccessStatusCode)
{
return("{}");
}
string content = await response.Content.ReadAsStringAsync();
return(content);
}
public async Task <string> FindGroupDataById(string token, string id)
{
string apiURI = APIs.GetListSubmissionsURL(Keywords.GROUP) + "/" + id;
HttpResponseMessage response = await _httpUtil.GetAsync(token, apiURI);
if (response == null || !response.IsSuccessStatusCode)
{
return("{}");
}
string content = await response.Content.ReadAsStringAsync();
return(content);
}
public async Task <string> FindAllGroupsByIdParent(string token, string idParent)
{
string apiURI = APIs.GetListSubmissionsURL(Keywords.GROUP) + "?limit=" + Configs.LIMIT_QUERY
+ "&sort=-create&select=data&data.status=" + Configs.ACTIVE_STATUS + "&data.idParent=" + idParent;
HttpResponseMessage response = await _httpUtil.GetAsync(token, apiURI);
if (response == null || !response.IsSuccessStatusCode)
{
return("[]");
}
string content = await response.Content.ReadAsStringAsync();
return(content);
}
public async Task <string> FindSubmissionsByPage(string token, string path, int page)
{
string apiURI = APIs.GetListSubmissionsURL(path) + "?select=data&limit=" + Configs.NUMBER_ROWS_PER_PAGE + "&skip="
+ (page - 1) * Configs.NUMBER_ROWS_PER_PAGE;
HttpResponseMessage response = await _httpUtil.GetAsync(token, apiURI);
if (response == null || !response.IsSuccessStatusCode)
{
return("[]");
}
string content = await response.Content.ReadAsStringAsync();
return(content);
}
public async Task <long> CountUsers(string token, string idGroup)
{
string apiURI = APIs.GetListSubmissionsURL(Keywords.USER.ToLower()) + "?limit=" + Configs.LIMIT_QUERY + "&data.idGroup="
+ idGroup + "&select=_id";
HttpResponseMessage response = await _httpUtil.GetAsync(token, apiURI);
if (response == null || !response.IsSuccessStatusCode)
{
return(0);
}
string content = await response.Content.ReadAsStringAsync();
return(JArray.Parse(content).Count);
}
public async Task <string> FindUsersByPageAndName(string token, string keyword, int page)
{
string apiURI = APIs.GetListSubmissionsURL(Keywords.USER.ToLower()) + "?select=data&limit=" + Configs.NUMBER_ROWS_PER_PAGE
+ "&skip=" + (page - 1) * Configs.NUMBER_ROWS_PER_PAGE + "&data.name__regex=/" + keyword + "/";
HttpResponseMessage response = await _httpUtil.GetAsync(token, apiURI);
if (response == null || !response.IsSuccessStatusCode)
{
return("[]");
}
string content = await response.Content.ReadAsStringAsync();
return(content);
}
public async Task <long> CountSubmissions(string token, string path)
{
string apiURI = APIs.GetListSubmissionsURL(path) + "?limit=" + Configs.LIMIT_QUERY + "&select=_id";
HttpResponseMessage response = await _httpUtil.GetAsync(token, apiURI);
if (response == null || !response.IsSuccessStatusCode)
{
return(0);
}
string content = await response.Content.ReadAsStringAsync();
JArray jArray = JArray.Parse(content);
return(jArray.Count);
}
public async Task <string> FindAllUsers(string token)
{
List <User> users = new List <User>();
string apiURI = APIs.GetListSubmissionsURL(Keywords.USER.ToLower()) + "?limit=" + Configs.LIMIT_QUERY + "&select=data";
HttpResponseMessage response = await _httpUtil.GetAsync(token, apiURI);
if (response == null || !response.IsSuccessStatusCode)
{
return("[]");
}
string content = await response.Content.ReadAsStringAsync();
return(content);
}
public async Task <int> FindNumberOfChildGroupByIdParent(string token, string idParent)
{
string apiURI = APIs.GetListSubmissionsURL(Keywords.GROUP) + "?limit=" + Configs.LIMIT_QUERY
+ "&select=_id&data.status=" + Configs.ACTIVE_STATUS + "&data.idParent=" + idParent;
HttpResponseMessage response = await _httpUtil.GetAsync(token, apiURI);
if (response == null || !response.IsSuccessStatusCode)
{
return(0);
}
string content = await response.Content.ReadAsStringAsync();
JArray jArray = JArray.Parse(content);
return(jArray.Count);
}
public async Task <List <Group> > FindListChildGroupByIdParentWithPage(string token, string idParent, string nameParent, int page)
{
string apiURI = APIs.GetListSubmissionsURL(Keywords.GROUP);
if (page == 0)
{
// If page = 0 => get full data
apiURI += "?limit=" + Configs.LIMIT_QUERY;
}
else
{
apiURI += "?limit=" + Configs.NUMBER_ROWS_PER_PAGE + "&skip=" + (page - 1) * Configs.NUMBER_ROWS_PER_PAGE;
}
apiURI += "&sort=-create&select=data&data.status=" + Configs.ACTIVE_STATUS + "&data.idParent=" + idParent;
HttpResponseMessage response = await _httpUtil.GetAsync(token, apiURI);
if (response == null || !response.IsSuccessStatusCode)
{
return(null);
}
List <Group> groups = new List <Group>();
string content = await response.Content.ReadAsStringAsync();
JArray jArray = JArray.Parse(content);
JObject dataObject = null;
foreach (JObject jObject in jArray)
{
dataObject = (JObject)jObject.GetValue(Keywords.DATA);
string id = jObject.GetValue(Keywords.ID).ToString();
string idGroup = dataObject.GetValue(Keywords.ID_GROUP).ToString();
string name = dataObject.GetValue(Keywords.NAME).ToString();
int childSize = await FindNumberOfChildGroupByIdParent(token, idGroup);
groups.Add(new Group(id, idGroup, name, idParent, nameParent, childSize));
}
return(groups);
}
public async Task <string> FindAllSubmissions(string token, string path, bool isGetOnlyData)
{
string apiURI = APIs.GetListSubmissionsURL(path) + "?limit=" + Configs.LIMIT_QUERY;
if (isGetOnlyData)
{
apiURI += "&select=data";
}
HttpResponseMessage response = await _httpUtil.GetAsync(token, apiURI);
if (response == null || !response.IsSuccessStatusCode)
{
return("[]");
}
string content = await response.Content.ReadAsStringAsync();
return(content);
}
public async Task <string> FindGroupFieldByIdGroup(string token, string idGroup, string field)
{
string apiURI = APIs.GetListSubmissionsURL(Keywords.GROUP) + "?select=data&data.idGroup=" + idGroup;
HttpResponseMessage response = await _httpUtil.GetAsync(token, apiURI);
if (response == null || !response.IsSuccessStatusCode)
{
return(string.Empty);
}
string content = await response.Content.ReadAsStringAsync();
JArray jArray = JArray.Parse(content);
if (jArray.Count == 0)
{
return(string.Empty);
}
JObject jObject = jArray.Children <JObject>().FirstOrDefault();
JObject dataObject = (JObject)jObject.GetValue(Keywords.DATA);
return(dataObject.GetValue(field).ToString());
}
