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