//
// GET: /Home/
public ActionResult Index()
{
Database.SetInitializer(new BuecherInitializer());
var db = new BuecherContext();
return(View());
}
private List <Dictionary <string, object> > LoadVerlage()
{
var db = new BuecherContext();
List <Dictionary <string, object> > result = new List <Dictionary <string, object> >();
foreach (var x in db.Verlage.OrderBy(x => x.Name))
{
var node = new Dictionary <string, object>();
node["title"] = x.Name;
node["key"] = "verlag;" + x.ID;
node["isFolder"] = false;
node["isLazy"] = false;
result.Add(node);
}
return(result);
}
private List <Dictionary <string, object> > LoadAutoren()
{
var db = new BuecherContext();
List <Dictionary <string, object> > result = new List <Dictionary <string, object> >();
foreach (var x in db.Autoren.OrderBy(x => x.Nachname))
{
var node = new Dictionary <string, object>();
node["title"] = x.Nachname + ", " + x.Vorname + "; " + x.Wohnort;
node["key"] = "autor;" + x.ID;
node["isFolder"] = false;
node["isLazy"] = false;
result.Add(node);
}
return(result);
}
public JsonResult LadeTree()
{
var db = new BuecherContext();
var data = new List <Dictionary <string, object> >();
var node = new Dictionary <string, object>();
node["title"] = "Autoren";
node["key"] = "autoren";
node["isFolder"] = true;
node["isLazy"] = true;
data.Add(node);
node = new Dictionary <string, object>();
node["title"] = "Bücher";
node["key"] = "buecher";
node["isFolder"] = true;
node["isLazy"] = true;
data.Add(node);
node = new Dictionary <string, object>();
node["title"] = "Länder";
node["key"] = "laender";
node["isFolder"] = true;
node["isLazy"] = true;
data.Add(node);
node = new Dictionary <string, object>();
node["title"] = "Sprachen";
node["key"] = "sprachen";
node["isFolder"] = true;
node["isLazy"] = true;
data.Add(node);
node = new Dictionary <string, object>();
node["title"] = "Verlage";
node["key"] = "verlage";
node["isFolder"] = true;
node["isLazy"] = true;
data.Add(node);
return(Json(data, JsonRequestBehavior.AllowGet));
}
public JsonResult LadeGrid(int page, int rows, string sidx, string sord)
{
var db = new BuecherContext();
int totalPages = 0;
int nrRecords = 0;
var list = new List <object>();
try
{
var recs = from book in db.Buecher select book;
recs = sidx == "Title" ? (recs.OrderBy(x => x.Titel)) : (recs.OrderBy(x => x.ID));
nrRecords = recs.Count();
totalPages = Convert.ToInt32(Math.Ceiling((nrRecords * 1.0) / rows));
var result = recs.Skip((page - 1) * rows).Take(rows).ToList();
foreach (var rec in result)
{
var data = new List <object>();
data.Add(rec.ID);
data.Add(rec.Titel);
data.Add(rec.Autoren.First().Nachname + ", " + rec.Autoren.First().Vorname);
data.Add(rec.Verlag.Name);
data.Add(rec.Sprache.Name);
data.Add(rec.Seiten);
list.Add(new { id = rec.ID, cell = data });
}
}
catch (Exception exc)
{
list.Add(exc.Message);
}
var response = new { total = totalPages, page = page, records = nrRecords, rows = list };
var d = Json(response, JsonRequestBehavior.AllowGet);
return(d);
}
