Пример #1
0
        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));
        }
Пример #3
0
        // 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));
        }
Пример #4
0
        // 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));
        }
Пример #5
0
        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));
        }
Пример #6
0
        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));
        }
Пример #7
0
        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));
        }
Пример #8
0
        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));
        }
Пример #9
0
        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));
        }
Пример #10
0
        // 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));
        }
Пример #11
0
        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));
        }
Пример #12
0
        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));
        }
Пример #14
0
        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));
        }