public dynamic getSecretriattovolunteer(SecretriatVVModel root) { dynamic obj = new ExpandoObject(); PRRDSPHelper spobj = new PRRDSPHelper(); try { DataTable data = spobj.GetSecretraiatToVolunteer_Sp(root); if (data != null) { obj.Status = 100; obj.Reason = "Data Loaded Successfully."; obj.Details = data; } else { obj.Status = 102; obj.Reason = "No Data Found"; } } catch (Exception ex) { obj.Status = 102; obj.Reason = "Error Occured While Getting Volunteer Data"; } return(obj); }
public IHttpActionResult SecretriattoVoluteerData(dynamic data) { string value = token_gen.Authorize_aesdecrpty(data); try { SecretriatVVModel root = JsonConvert.DeserializeObject <SecretriatVVModel>(value); return(Ok(hlpval.getSecretriattovolunteer(root))); } catch (Exception ex) { CatchData.Status = 102; CatchData.Reason = "Error Occured While Getting Data"; return(Ok(CatchData)); } }
public DataTable GetSecretraiatToVolunteer_Sp(SecretriatVVModel obj) { try { var comd = new OracleCommand(); comd.InitialLONGFetchSize = 1000; comd.CommandType = CommandType.StoredProcedure; comd.CommandText = "youth_service.PSS_DETAILS_UPD_PROC"; comd.Parameters.Add("ptype", OracleDbType.Varchar2).Value = obj.TYPE; comd.Parameters.Add("pdist", OracleDbType.Varchar2).Value = obj.DISTRICTCODE; comd.Parameters.Add("pmand", OracleDbType.Varchar2).Value = obj.MANDALCODE; comd.Parameters.Add("pgsws_code", OracleDbType.Varchar2).Value = obj.SECRETRIATCODE; comd.Parameters.Add("pvv_id", OracleDbType.Varchar2).Value = obj.VVID; comd.Parameters.Add("phh_id", OracleDbType.Varchar2).Value = obj.HHID; comd.Parameters.Add("ptemp_id", OracleDbType.Varchar2).Value = obj.TEMPID; comd.Parameters.Add("pupdated_by", OracleDbType.Varchar2).Value = obj.UpdateBy; comd.Parameters.Add("pupdated_date", OracleDbType.Date).Value = obj.UpdateDate; comd.Parameters.Add("pstatus", OracleDbType.Varchar2).Value = obj.Status; comd.Parameters.Add("P_CUR", OracleDbType.RefCursor).Direction = ParameterDirection.Output; DataTable data = GetspsDataAdapter(comd); if (data != null && data.Rows.Count > 0) { return(data); } else { return(null); } } catch (WebException wex) { string mappath = HttpContext.Current.Server.MapPath("GetSecretraiatToVolunteerExceptionLogs"); Task WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_Log_Exception(mappath, "Error Getting Volunteer Mapping Data API:" + wex.Message.ToString())); throw wex; } }