public DataTable LoadDistricts_helper(DistrictsCls oj) { try { cmd = new OracleCommand(); cmd.InitialLONGFetchSize = 1000; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "GSWS_GET_SERVICE_DETAILS"; cmd.Parameters.Add("FTYPE", OracleDbType.Varchar2, 12).Value = oj.TYPE; cmd.Parameters.Add("FDEPT_ID", OracleDbType.Varchar2, 12).Value = oj.DEPARTMENT; cmd.Parameters.Add("FHOD_ID", OracleDbType.Varchar2, 12).Value = oj.HOD; cmd.Parameters.Add("FDIST_CODE", OracleDbType.Varchar2, 12).Value = oj.DISTRICT; cmd.Parameters.Add("FMAND_CODE", OracleDbType.Varchar2, 12).Value = oj.MANDAL; cmd.Parameters.Add("FVILL_CODE", OracleDbType.Varchar2, 12).Value = oj.PANCHAYAT; cmd.Parameters.Add("P_URFLG", OracleDbType.Varchar2, 12).Value = oj.RUFLAG; cmd.Parameters.Add("P_CUR", OracleDbType.RefCursor).Direction = ParameterDirection.Output; DataTable dtstatus = GetgswsDataAdapter(cmd); if (dtstatus != null && dtstatus.Rows.Count > 0) { return(dtstatus); } else { return(null); } } catch (Exception ex) { string mappath = HttpContext.Current.Server.MapPath("BirthExceptionLogs"); Task WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_ReportLog_Exception(mappath, "Error From Load Districts Data :" + ex.Message.ToString())); throw ex; } }
public dynamic LoadDistricts(DistrictsCls oj) { dynamic obj = new ExpandoObject(); PRRDSPHelper spobj = new PRRDSPHelper(); try { DataTable dt = spobj.LoadDistricts_helper(oj); if (dt != null && dt.Rows.Count > 0) { obj.Status = 100; obj.Reason = ""; obj.Details = dt; } else { obj.Status = 101; obj.Reason = "No Data Found"; } } catch (Exception ex) { obj.Status = 102; obj.Reason = "Error Occued While Loading Data"; return(obj); } return(obj); }
public IHttpActionResult LoadDistricts(dynamic data) { dynamic obj = new ExpandoObject(); string value = token_gen.Authorize_aesdecrpty(data); try { //string value = JsonConvert.SerializeObject(data); DistrictsCls rootobj = JsonConvert.DeserializeObject <DistrictsCls>(value); return(Ok(hlpval.LoadDistricts(rootobj))); } catch (Exception ex) { obj.Status = 102; obj.Reason = "Error Occued While Loading Data"; return(Ok(obj)); } }