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 }));
}
