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