public IHttpActionResult DemoAPI(dynamic data) { string serialized_data = JsonConvert.SerializeObject(data); DemoModel obj = JsonConvert.DeserializeObject <DemoModel>(serialized_data); return(Ok(_Hel.DemoAPI(obj))); }
//public object DepartmentEnum { get; private set; } //CommonSPHel _comhel = new CommonSPHel(); public DataTable DemoAPI(DemoModel objrb) { try { cmd = new OracleCommand(); cmd.InitialLONGFetchSize = 1000; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "RB_SP_OWNERS_DETAILS"; cmd.Parameters.Add("P_TYPE", OracleDbType.Varchar2, 12).Value = objrb.Ftype; cmd.Parameters.Add("P_DISTRICT", OracleDbType.Varchar2, 20).Value = objrb.FDistrict; cmd.Parameters.Add("P_MANDAL", OracleDbType.Varchar2, 20).Value = objrb.FMandal; cmd.Parameters.Add("P_VILLAGE", OracleDbType.Varchar2, 20).Value = objrb.FVillage; cmd.Parameters.Add("P_KATHA_NO", OracleDbType.Varchar2, 20).Value = objrb.FKathano; cmd.Parameters.Add("P_UNIQUE_ID", OracleDbType.Varchar2, 50).Value = objrb.FUID; cmd.Parameters.Add("P_CUR", OracleDbType.RefCursor).Direction = ParameterDirection.Output; DataTable dtApproval = GetspsDataAdapter(cmd); if (dtApproval != null && dtApproval.Rows.Count > 0) { return(dtApproval); } else { return(null); } } catch (Exception ex) { string mappath = HttpContext.Current.Server.MapPath("MandalExceptionLogs"); Task WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_ReportLog_Exception(mappath, "Error From GetMandaApprovalReport_Sp:" + ex.Message.ToString())); throw ex; //throw ex; } }