//public List<Models.MonitorFax> Get()
//public System.Web.Mvc.JsonResult Get()
public System.Web.Mvc.JsonResult Grid(KendoGridBinder.KendoGridRequest request)
{
Models.MonitorFax monitorFax = new Models.MonitorFax();
List<Models.MonitorFax> monitorFaxList = new List<Models.MonitorFax>();
try
{
using (var ctx = ConnectionManager<SqlConnection>.GetManager(Database.WaldenFax, false))
{
using (var cm = ctx.Connection.CreateCommand())
{
cm.CommandText = "select SendID,Status,FaxName,"
+ " CreateTime,CompletionTime,PageCount,"
+ " RecipientName,Notes"
+ " from FaxesSendServer "
+ " where UserID = @UserID"
+ " and ShowFax = 'Y'"
+ " order by CreateTime DESC";
cm.CommandType = System.Data.CommandType.Text;
cm.Parameters.AddWithValue("@UserID",Environment.UserName);
using (var dr = new SafeDataReader(cm.ExecuteReader()))
{
while (dr.Read())
{
monitorFax.SendID = int.Parse(dr["SendID"].ToString());
monitorFax.Status = dr["Status"].ToString();
//monitorFax.FaxName = dr["FaxName"].ToString();
monitorFax.CreateTime = dr["CreateTime"].ToString();
monitorFax.CompletionTime = dr["CompletionTime"].ToString();
monitorFax.PageCount = int.Parse(dr["PageCount"].ToString());
monitorFax.RecipientName = dr["RecipientName"].ToString();
monitorFax.Notes = dr["Notes"].ToString();
monitorFaxList.Add(monitorFax);
}
}
var grid = new KendoGridBinder.KendoGrid<Models.MonitorFax>(request,monitorFaxList);
// var data = new KendoGrid<Employee>(request, employees);
// return Json(data);
//using System.Web.Mvc;
//using ComicShop.Models;
//using System.Collections.Generic;
//System.Web.Mvc.Controller Json
//System.Web.Mvc.Controller.
//System.Collections.Generic.J
return Json(grid);
}
}
}
catch
{
return monitorFaxList;
}
}
public ActionResult AjaxRead(KendoGridBinder.KendoGridRequest request)
{
var list = ((IEnumerable<dynamic>)this.Get()).Select(x => new ConfigDto
{
Name = x.Name,
Value = x.Value,
UpdatedAt = x.UpdatedAt
});
/*
var fromdb = ((Log)_table).All();
var dto = fromdb.Select(x => new LogDto
{
UpdatedAt = x.UpdatedAt,
UpdatedAtString = x.UpdatedAt.ToString(),
IpAddress = x.IpAddress, Level = x.Level, Server = x.Server,
Session=x.Session, UserName= x.UserName,
Summary = x.Summary, Id = x.Id,
Email = x.Email
}).OrderByDescending(x => x.UpdatedAt);*/
return Json(list, JsonRequestBehavior.AllowGet);
}
public ActionResult AjaxRead(KendoGridBinder.KendoGridRequest request)
{
var list = Session["employees"];
return Json(list, JsonRequestBehavior.AllowGet);
}
