public IHttpActionResult GetCostDetails() { DataContext ctx = new Controllers.DataContext(); object[] parameterValues = new object[2]; parameterValues[0] = System.DBNull.Value; parameterValues[1] = System.DBNull.Value; var result = ctx.ReaderSp("GetCostReportDetails", parameterValues).ToList <CostDetails>(); return(Ok(result)); }
// GET: odata/Progresses(5) public IHttpActionResult GetProgress([FromODataUri] int level, ODataQueryOptions <Progress> queryOptions) { DataContext ctx = new Controllers.DataContext(); object[] parameterValues = new object[3]; parameterValues[0] = System.DBNull.Value; parameterValues[1] = System.DBNull.Value; parameterValues[2] = level; var result = ctx.ReaderSp("GetProgressTotalQuery", parameterValues).AsEnumerable().AsQueryable(); return(Ok(result)); }
// GET: odata/Finances public IHttpActionResult GetFinances(ODataQueryOptions <Finance> queryOptions) { DataContext ctx = new Controllers.DataContext(); object[] parameterValues = new object[3]; parameterValues[0] = System.DBNull.Value; parameterValues[1] = System.DBNull.Value; parameterValues[2] = 1; var result = ctx.ReaderSp("GetFinanceTotalQuery", parameterValues).AsEnumerable().AsQueryable(); return(Ok(result)); }
// GET: odata/Costs public IHttpActionResult GetCosts(ODataQueryOptions <Cost> queryOptions) { DataContext ctx = new Controllers.DataContext(); object[] parameterValues = new object[2]; parameterValues[0] = System.DBNull.Value; parameterValues[1] = System.DBNull.Value; var result = ctx.ReaderSp("GetCostReport", parameterValues).AsEnumerable().AsQueryable(); return(Ok(result)); }
public IHttpActionResult GetWBS() { DataContext ctx = new Controllers.DataContext(); object[] parameterValues = new object[4]; parameterValues[0] = System.DBNull.Value; parameterValues[1] = System.DBNull.Value; parameterValues[2] = 3; parameterValues[3] = 3;//level var result = ctx.ReaderSp("GetWBSTotalQuery", parameterValues).ToList <WBS>(); return(Ok(result)); }
public IHttpActionResult GetCommitment97First() { DataContext ctx = new Controllers.DataContext(); object[] parameterValues = new object[2]; parameterValues[0] = System.DBNull.Value; parameterValues[1] = System.DBNull.Value; var result = ctx.ReaderSp("GetCommitmentFirst", parameterValues).ToList <Commitment97First>(); return(Ok(result)); }
public IHttpActionResult GetInvoiceCM() { DataContext ctx = new Controllers.DataContext(); object[] parameterValues = new object[1]; parameterValues[0] = System.DBNull.Value; var result = ctx.ReaderSp("GetInvoiceCM", parameterValues).ToList <InvoiceCM>(); return(Ok(result)); }
public IHttpActionResult GetEvaluation() { DataContext ctx = new Controllers.DataContext(); object[] parameterValues = new object[2]; parameterValues[0] = System.DBNull.Value; parameterValues[1] = System.DBNull.Value; var result = ctx.ReaderSp("GetEvaluationDashboard", parameterValues).ToList <Evaluation>(); return(Ok(result)); }
public IHttpActionResult GetProgress() { DataContext ctx = new Controllers.DataContext(); object[] parameterValues = new object[3]; parameterValues[0] = System.DBNull.Value; parameterValues[1] = System.DBNull.Value; parameterValues[2] = 3; var result = ctx.ReaderSp("GetProgressTotalQuery", parameterValues).ToList <Progress>(); return(Ok(result)); }
// GET: odata/Tahvils public IHttpActionResult GetTahvils(ODataQueryOptions <Tahvil> queryOptions) { DataContext ctx = new Controllers.DataContext(); object[] parameterValues = new object[4]; parameterValues[0] = System.DBNull.Value; parameterValues[1] = System.DBNull.Value; parameterValues[2] = System.DBNull.Value; parameterValues[3] = 1; var result = ctx.ReaderSp("GetDeliverDataTotal", parameterValues).AsEnumerable().AsQueryable(); return(Ok(result)); }
public IHttpActionResult GetDeliverTrends() { DataContext ctx = new Controllers.DataContext(); object[] parameterValues = new object[3]; parameterValues[0] = System.DBNull.Value; parameterValues[1] = System.DBNull.Value; parameterValues[2] = 3; var result = ctx.ReaderSp("GetDeliverByYear", parameterValues).ToList <TahvilTrend>(); //var result = ctx.ReaderSp("GetDeliverTrendTotalQuery", parameterValues).ToList<TahvilTrend>(); return(Ok(result)); }
public IHttpActionResult GetDeliver2() { DataContext ctx = new Controllers.DataContext(); object[] parameterValues = new object[5]; parameterValues[0] = System.DBNull.Value; parameterValues[1] = System.DBNull.Value; parameterValues[2] = System.DBNull.Value; parameterValues[3] = 3; parameterValues[4] = System.DBNull.Value; var result = ctx.ReaderSp("GetDeliverDataExcell", parameterValues).ToList <Tahvil2>(); return(Ok(result)); }
// GET: odata/WeeklyTrends(5) public IHttpActionResult GetWeeklyTrend([FromODataUri] int level, ODataQueryOptions <WeeklyTrend> queryOptions) { DataContext ctx = new Controllers.DataContext(); object[] parameterValues = new object[6]; parameterValues[0] = System.DBNull.Value; parameterValues[1] = System.DBNull.Value; parameterValues[2] = 1; parameterValues[3] = level; parameterValues[4] = 2; parameterValues[5] = 2; var result = ctx.ReaderSp("GetWeeklyTrendTotalQuery", parameterValues).AsEnumerable().AsQueryable(); return(Ok(result)); }
public IHttpActionResult GetCommitTrends12() { DataContext ctx = new Controllers.DataContext(); object[] parameterValues = new object[5]; parameterValues[0] = System.DBNull.Value; parameterValues[1] = System.DBNull.Value; parameterValues[2] = 1; parameterValues[3] = 2; parameterValues[4] = 2; // parameterValues[5] = 1; var result = ctx.ReaderSp("GetCommitTrendUnpivotTotalQuery", parameterValues).ToList <CommitTrendUnpivot>(); return(Ok(result)); }