public ActionResult PreviewData(Guid id, CC.Web.Models.jQueryDataTableParamModel jq)
{
var model = new CC.Web.Areas.Admin.Models.AppsImportModel(id);
var result = model.GetPreview(this.db, jq);
return(this.MyJsonResult(result));
}
public ActionResult Upload(HttpPostedFileBase file)
{
var model = new CC.Web.Areas.Admin.Models.AppsImportModel();
model.Upload(file);
return(this.RedirectToAction(f => f.Preview(model.Id)));
}
public ActionResult Preview(Guid id)
{
var model = new CC.Web.Areas.Admin.Models.AppsImportModel(id);
var data = model.PreviewData(db);
ViewBag.HasErrors = data.Any(f => f.Errors != null && f.Errors != "");
return(View(model.Id));
}
public ActionResult Import(Guid id)
{
var model = new CC.Web.Areas.Admin.Models.AppsImportModel();
var cnt = db.ExecuteStoreCommand("exec [dbo].[ImportApps] @id",
new System.Data.SqlClient.SqlParameter {
ParameterName = "id", Value = id
});
var lft = db.AppsImports.Count(f => f.Id == id);
if (lft > 0)
{
ModelState.AddModelError(string.Empty,
string.Format("{0} rows have been imported. {1} rows left.", cnt, lft));
}
return(RedirectToAction("Index"));
}
