private string GetPagedContent()
{
var siteId = Request["siteid"];
var page = Convert.ToInt32(Request.Params["page"]);
var rp = Convert.ToInt32(Request.Params["rp"]);
var qtype = Request.Params["qtype"];
var query = Request.Params["query"];
var sortname = Request.Params["sortname"];
var sortorder = Request.Params["sortorder"];
var sid = 0;
if (int.TryParse(siteId, out sid))
{
using (var ctx = new Entities())
{
var q = from u in ctx.SITECONTACTs
where u.SITEID == sid
select u;
if (!string.IsNullOrEmpty(qtype) && !string.IsNullOrEmpty(query))
{
q = q.Where(u => u.NAME.ToLower().Contains(query.ToLower()));
}
if (!string.IsNullOrEmpty(sortname) && !string.IsNullOrEmpty(sortorder))
{
q = q.OrderBy(sortname, (sortorder == "asc"));
}
var count = q.ToList().Count;
q = q.Skip((page - 1) * rp).Take(rp);
var results = q.ToList();
var flexigrid = new FlexigridViewData {
page = page, total = count
};
foreach (var result in results)
{
var fgRow = new FlexigridRow {
id = result.ID, cell = new List <string> {
result.NAME
}
};
flexigrid.rows.Add(fgRow);
}
var serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
return(serializer.Serialize(flexigrid));
}
}
return(string.Empty);
}
private string GetPagedContent()
{
var page = Convert.ToInt32(Request.Params["page"]);
var rp = Convert.ToInt32(Request.Params["rp"]);
var qtype = Request.Params["qtype"];
var query = Request.Params["query"];
var sortname = Request.Params["sortname"];
var sortorder = Request.Params["sortorder"];
using (var ctx = new Entities())
{
var q = from u in ctx.SYSTEMUSERs
where u.DELETED == 0 select u;
if (!string.IsNullOrEmpty(qtype) && !string.IsNullOrEmpty(query))
{
q = q.Where(u => u.NAME.ToLower().Contains(query.ToLower()) || u.ORGANISATION.ToLower().Contains(query.ToLower()));
}
if (!string.IsNullOrEmpty(sortname) && !string.IsNullOrEmpty(sortorder))
{
q = q.OrderBy(sortname, (sortorder == "asc"));
}
var count = q.ToList().Count;
q = q.Skip((page - 1) * rp).Take(rp);
var results = q.ToList();
var flexigrid = new FlexigridViewData {
page = page, total = count
};
foreach (var result in results)
{
var fgRow = new FlexigridRow {
id = result.ID, cell = new List <string>
{
result.NAME,
result.EMAIL,
result.ORGANISATION,
result.LASTLOGGEDON.ToString("dd MMM yy HH:mm")
}
};
flexigrid.rows.Add(fgRow);
}
var serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
return(serializer.Serialize(flexigrid));
}
}
private string GetPagedContent()
{
var page = Convert.ToInt32(Request.Params["page"]);
var rp = Convert.ToInt32(Request.Params["rp"]);
var qtype = Request.Params["qtype"];
var query = Request.Params["query"];
var sortname = Request.Params["sortname"];
var sortorder = Request.Params["sortorder"];
using (var ctx = new Entities())
{
var q = from u in ctx.PROJECTs
where u.DELETED == 0 select u;
if (!string.IsNullOrEmpty(qtype) && !string.IsNullOrEmpty(query))
{
// TODO
}
if (!string.IsNullOrEmpty(sortname) && !string.IsNullOrEmpty(sortorder))
{
q = q.OrderBy(sortname, (sortorder == "asc"));
}
var count = q.ToList().Count;
q = q.Skip((page - 1) * rp).Take(rp);
var results = q.ToList();
var flexigrid = new FlexigridViewData {
page = page, total = count
};
foreach (var result in results)
{
var fgRow = new FlexigridRow {
id = result.ID, cell = new List <string> {
result.NAME
}
};
flexigrid.rows.Add(fgRow);
}
var serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
return(serializer.Serialize(flexigrid));
}
}
private string GetPagedContent(int id)
{
var page = Convert.ToInt32(Request.Params["page"]);
var rp = Convert.ToInt32(Request.Params["rp"]);
var qtype = Request.Params["qtype"];
var query = Request.Params["query"];
var sortname = Request.Params["sortname"];
var sortorder = Request.Params["sortorder"];
var datastore = new DataStore(ConfigurationSettings.AppSettings["datastore_path"]);
var total = 0;
var data = datastore.Retrieve(id, rp, page, out total);
var flexigrid = new FlexigridViewData {
page = page, total = total
};
int i = 0;
foreach (var row in data)
{
i++;
var fgRow = new FlexigridRow {
id = i, cell = new List <string>()
};
fgRow.cell.Add(row.RowDateTime.ToString("dd MMM yyyy HH:mm"));
fgRow.cell.Add(row.SiteID.ToString());
fgRow.cell.AddRange(row.Values);
flexigrid.rows.Add(fgRow);
}
var serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
return(serializer.Serialize(flexigrid));
}
