public IHttpActionResult GetColumnDef(string ViewName) { IEnumerable <dynamic> vwColDef = null; IEnumerable <dynamic> avColDef = null; int?vwColDefCnt = ViewMaster.getVwColDefCnt(ViewName); if (vwColDefCnt == null) { return(BadRequest()); } else { if (vwColDefCnt > 0) { vwColDef = ViewMaster.getVwColumnDef(ViewName); avColDef = ViewMaster.getAvColumnDef(ViewName); } else { vwColDef = ViewMaster.getDfColumnDef(ViewName); } } var columnDef = new { vwColDef, avColDef }; return(Ok(columnDef)); }
public IHttpActionResult UpdateColumnInfo([FromBody] dynamic ColumnInfo) { int afRowCnt = ViewMaster.updateColumnInfo(ColumnInfo); if (afRowCnt == 0) { return(BadRequest()); } return(Ok()); }
public IHttpActionResult GetRow(string ViewName, string ViewKey, string KeyValue) { var row = ViewMaster.getRow(ViewName, ViewKey, KeyValue); if (row == null) { return(BadRequest()); } return(Ok(row)); }
public async Task <IHttpActionResult> GetView(string ViewName, string ViewKey, string Filter = "") { if (!ModelState.IsValid) { return(BadRequest()); } var Columns = await ViewMaster.GetViewColumns(ViewName, ViewKey); var Data = await ViewMaster.getViewData(ViewName, ViewKey, Columns, Filter); if (Columns == null) { return(InternalServerError()); } return(Ok(new { Columns, Data })); }