// SUMMARY: Get .csv from for specific entrance table data
public FileContentResult Csv(EntranceTableData data)
{
if (data.Validation())
{
return(null);
}
EntranceTableManager entranceTableManager = new EntranceTableManager();
entranceTableManager.Query(data);
return(File(new System.Text.UTF8Encoding().GetBytes(entranceTableManager.ConvertToCvs()), "text/csv", "database.csv"));
}
public ActionResult LoadNewSubsequental(EntranceTableData data)
{
if (data.Validation())
{
return(Content(string.Format("<b class=\"message_error\">Internal error. '{0}'</b>", data.ErrorMessage)));
}
EntranceTableManager entranceTableManager = new EntranceTableManager();
DataTableModel model = new DataTableModel(entranceTableManager);
return(View("~/Views/Database/_DataNewSequential.cshtml", model));
}
// SUMMARY: Load entrance table data
public ActionResult Load(EntranceTableData data)
{
if (data.Validation())
{
return(Content(string.Format("<b class=\"message_error\">Internal error. '{0}'</b>", data.ErrorMessage)));
}
EntranceTableManager entranceTableManager = new EntranceTableManager();
entranceTableManager.Query(data);
return(View("~/Views/Database/_Data.cshtml", new DataTableModel(entranceTableManager)));
}
public ActionResult GetData()
{
AndroidInputModel inputModel = new AndroidInputModel(this.Request);
EntranceTableData inputData = inputModel.ToEntranceTableData();
if (inputData.Validation())
{
return(this.Json(new { status = false }, JsonRequestBehavior.AllowGet));
}
EntranceTableManager entranceTableManager = new EntranceTableManager();
List <EntranceTableAndroid> result = entranceTableManager.QueryNewAndroid(inputData);
return(this.Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult LoadNew(EntranceTableData data)
{
if (data.UseSequentialSearch)
{
return(this.LoadNewSubsequental(data));
}
if (data.Validation())
{
return(Content(string.Format("<b class=\"message_error\">Internal error. '{0}'</b>", data.ErrorMessage)));
}
EntranceTableManager entranceTableManager = new EntranceTableManager();
DataTableModel model = new DataTableModel(entranceTableManager,
(!data.AndroidClientSession.HasValue ?
entranceTableManager.QueryNew(data) :
entranceTableManager.QueryNewAndroidSession(data)));
return(View(string.Format("~/Views/Database/{0}.cshtml", data.ReturnView), model));
}
public DataTableModel(EntranceTableManager tableManager, List <EntranceTableNew> data = null)
{
this._tableManager = tableManager;
this._newEntranceTableData = data;
}
