// GET: Login
public async Task <Boolean> ValidateUser(UserDetailModel user)
{
db = new ConnectionStrings();
var uriBuilder = db.GetCouchUrl();
Boolean valid = false;
using (var client = new MyCouchClient(uriBuilder))
{
var notifications = await client.Views.QueryAsync <UserDetailModel>(new QueryViewRequest("userCredential", "user-credential"));
UserDetailModel ud = new UserDetailModel();
var ss = notifications.Rows.Where(r => r.Value.password == user.password && r.Value.userid == user.userid);
List <UserDetailModel> un = notifications.Rows.Select(r => r.Value).ToList();
foreach (var item in un)
{
if (item.userid != null && item.userid == user.userid && item.password == user.password)
{
valid = true;
return(valid);
}
;
}
}
return(valid);
}
public async Task<ActionResult> GetElements([FromBody]string siteid)
{
db = new ConnectionStrings();
var uriBuilder = db.GetCouchUrl();
List<ElementModel> elements = new List<ElementModel>();
elements.Clear();
using (var client = new MyCouchClient(uriBuilder))
{
//Configuring the view that has to be queried
var query = new QueryViewRequest("elementList", "element-list").Configure(query1 => query1
//.Limit(5)
.Key(siteid)
//.Keys("1","111")
.Reduce(false));
//var result3 = await client.Views.QueryAsync<ElementModel>(query);
var notifications = await client.Views.QueryAsync<ElementModel>(query);
elements = notifications.Rows.Select(r => r.Value).ToList();
}
return Json(elements);
}
public async Task<ActionResult> SetElementStatus([FromBody] ElementModel revelement)
{
db = new ConnectionStrings();
var uriBuilder = db.GetCouchUrl();
List<ElementModel> element = new List<ElementModel>();
DateTime currentTimestamp = DateTime.Now;
using (var client = new MyCouchClient(uriBuilder))
{
// updating the revised element status
var notifications = await client.Entities.PutAsync(revelement);
//Configuring the view that has to be queried
//var query = new QueryViewRequest("elementList", "element-list").Configure(query1 => query1
//.Limit(5)
//.Key(elementId)
//.Keys("1","111")
//.Reduce(false));
//var notifications = await client.Views.QueryAsync<ElementModel>(query);
//element = notifications.Rows.Select(r => r.Value).ToList();
}
return Json(element);
}
public async Task<ActionResult> GetElement([FromBody]Elementid elementid)
{
/*
* request.Configure(q => q
.Stale(bool value)
.IncludeDocs(bool value)
.Descending(bool value)
.Key(string value)
.Keys(params string[] value)
.StartKey(string value)
.StartKeyDocId(string value)
.EndKey(string value)
.EndKeyDocId(string value)
.InclusiveEnd(bool value)
.Skip(int value)
.Limit(int value)
.Reduce(bool value)
.UpdateSeq(bool value)
.Group(bool value)
.GroupLevel(int value));
*/
db = new ConnectionStrings();
var uriBuilder = db.GetCouchUrl();
List<ElementModel> element = new List<ElementModel>();
element.Clear();
using (var client = new MyCouchClient(uriBuilder))
{
//Configuring the view that has to be queried
var query = new QueryViewRequest("qrElement", "qrElement-view").Configure(query1 => query1
//.Limit(5)
//.Key(qrid)
.Key(elementid.elementid)
.Reduce(false));
//var result3 = await client.Views.QueryAsync<ElementModel>(query);
var notifications = await client.Views.QueryAsync<ElementModel>(query);
element = notifications.Rows.Select(r => r.Value).ToList();
}
return Json(element);
}
public async Task<ActionResult> GetSites([FromBody]string role)//
{
db = new ConnectionStrings();
var uriBuilder = db.GetCouchUrl();
List<SiteModel> sites = new List<SiteModel>();
List<SiteModel> siteslist = new List<SiteModel>();
using (var client = new MyCouchClient(uriBuilder))
{
var notifications = await client.Views.QueryAsync<SiteModel>(new QueryViewRequest("siteList", "site-list"));
sites = notifications.Rows.Select(r => r.Value).ToList();
foreach (var item in sites)
{
//Add a check based on the role once confirmed from the user
if (item.sitename != null)
{
siteslist.Add(item);
};
}
}
return Json(siteslist);
}