// GET api/integration/5
public string Get(int id)
{
SqlParameter[] param = new SqlParameter[0];
string Stored = null;
switch (id)
{
case 2: Stored = "Bi_rpt_Complains_By_Area"; break;
case 3: Stored = "Bi_rpt_Complain_Dept"; break;
case 4: Stored = "Bi_rpt_Complains_By_Call_Center"; break;
case 5: Stored = "Bi_rpt_Complains_By_Division"; break;
case 7: Stored = "Bi_rpt_in_process"; break;
case 8: Stored = "Bi_Rpt_Complains_by_CompanyName"; break;
}
return(DataTableToJsonObj(DirectSqlDao.GetAllStored_Datatable(Stored, param)));
}
// POST api/integration
public string Post([FromBody] string value)
{
SqlParameter[] param = new SqlParameter[0];
return(DataTableToJsonObj(DirectSqlDao.GetAllStored_Datatable("Bi_rpt_Complain_Dept", param)));
}