public ActionResult ReportBuilder() { ListDatabaseObjects db = new ListDatabaseObjects(); DataTable dt = db.getAllViews(); SqlReportModel model = new SqlReportModel(); List <SqlViewsPropertyModel> vwFields = new List <SqlViewsPropertyModel>(); List <SqlViewsModel> vwList = new List <SqlViewsModel>(); vwList = Converter.GetEntityList <SqlViewsModel>(dt); var roles = AdminService.GetRoles(); var modules = AdminService.GetModules(); //ViewBag.Tables = vwList; ViewBag.TableProperties = vwFields; ViewBag.Modules = modules; ViewBag.Tables = Converter.GetEntityList <SqlViewsModel>(dt); var selectedRoles = new List <RolesModel>(); model.AvailableRoles = roles; model.SelectedRoles = new List <RolesModel>(); //model.AvailableFields = vwFields; //model.SelectedFields = new List<SqlViewsPropertyModel>(); ViewBag.Roles = new MultiSelectList(roles, "RoleId", "RoleName"); ViewBag.SelectedRoles = new MultiSelectList(selectedRoles, "RoleId", "RoleName"); ViewBag.fields = new MultiSelectList(vwFields, "ID", "fieldName"); return(View("ReportBuilder", model)); }
public ActionResult ReportViewer(SqlReportModel model) { ListDatabaseObjects db = new ListDatabaseObjects(); var dbView = db.getAllViews(); DataTable dt = db.getAllViews(); SqlViewsModel vwModel = new SqlViewsModel(); List <SqlViewsPropertyModel> vwPropertyList = new List <SqlViewsPropertyModel>(); List <SqlViewsModel> vwList = new List <SqlViewsModel>(); foreach (DataRow row in dt.Rows) { vwList.Add(new SqlViewsModel { ID = row["ID"].ToString(), name = row["name"].ToString() }); } ViewBag.Tables = vwList; ViewBag.Reports = dt; //WebGridClass.GetDetailsForGrid(vwList, "View List", "ID"); return(View("ReportViewer", model)); }
public ActionResult EditReport(int ReportID) { SqlReportModel model = new SqlReportModel(); ListDatabaseObjects db = new ListDatabaseObjects(); DataTable dt = db.getAllViews(); List <SqlViewsPropertyModel> vwFields = new List <SqlViewsPropertyModel>(); List <SqlViewsModel> vwList = new List <SqlViewsModel>(); vwList = Converter.GetEntityList <SqlViewsModel>(dt); var roles = AdminService.GetRoles(); var modules = AdminService.GetModules(); ViewBag.TableProperties = vwFields; ViewBag.Modules = modules; ViewBag.Tables = vwList; var selectedRoles = new List <RolesModel>(); model.AvailableRoles = roles; model.SelectedRoles = new List <RolesModel>(); ViewBag.Roles = new MultiSelectList(roles, "RoleId", "RoleName"); ViewBag.SelectedRoles = new MultiSelectList(selectedRoles, "RoleId", "RoleName"); ViewBag.fields = new MultiSelectList(vwFields, "ID", "fieldName"); if (ReportID > 0) { DataSet dsReport = db.getReportDetails(ReportID); var result = new { }; if (dsReport != null && dsReport.Tables.Count > 0) { var dtReport = Converter.GetEntities <SqlViewsModel>(dsReport.Tables[0]); var dtFields = Converter.GetEntityList <ReportFieldModel>(dsReport.Tables[1]); var dtFilter = Converter.GetEntityList <FilterFieldModel>(dsReport.Tables[2]); var dtSelectedRoles = Converter.GetEntityList <RolesModel>(dsReport.Tables[3]); var dtRoles = Converter.GetEntities <RolesModel>(dsReport.Tables[4]); DataRow report = (dsReport.Tables[0].Rows.Count > 0) ? dsReport.Tables[0].Rows[0] : null; model = Converter.DataRowTonEntity <SqlReportModel>(report); model.dtReportFields = dtFields; model.dtFilterFields = dtFilter; ViewBag.SelectedRoles = dtSelectedRoles; ViewBag.Roles = new MultiSelectList(dtRoles, "RoleID", "RoleName");; } } return(View(model)); }
// GET: DynamicReport public ActionResult Index() { ListDatabaseObjects db = new ListDatabaseObjects(); var dbView = db.getAllViews(); DataSet dsReport = db.getReportDetails(-1); ViewBag.Tables = dbView; DataTable dtReports = dsReport.Tables[0]; var reports = Converter.GetEntities <SqlReportModel>(dtReports); //WebGridClass wg = new WebGridClass(); //var table = wg.GetDetailsFromDataTableForGrid<SqlReportModel>(dtReport, "View List", "ID"); return(View()); //return View("DynamicReports", dbView); //var data = new WebGridClass(); //data = WebGridClass.HoldWebGridDetails; //return View(data); }