public static dynamic volunteerDetails(familyModel obj) { dynamic objdata = new ExpandoObject(); try { string captchaverify = new captchahelper().GetCaptchVerify(obj); if (captchaverify == "Success") { obj.type = "2"; DataTable dt = familyProc(obj); if (dt != null && dt.Rows.Count > 0) { objdata.success = true; objdata.result = dt; } else { objdata.success = false; objdata.result = "Your Aadhaar Number is not surveyed !!!"; } } else { objdata.Status = "102"; objdata.result = "Invalid Captcha"; } } catch (Exception ex) { objdata.success = false; objdata.result = ex.Message.ToString(); } return(objdata); }
public IHttpActionResult volunteerDetails(dynamic data) { dynamic objdata = new ExpandoObject(); try { string serialized_data = JsonConvert.SerializeObject(data); familyModel rootobj = JsonConvert.DeserializeObject <familyModel>(serialized_data); return(Ok(KYVHelper.volunteerDetails(rootobj))); } catch (Exception ex) { objdata.status = false; objdata.result = ex.Message.ToString(); } return(Ok(objdata)); }
public static DataTable familyProc(familyModel obj) { try { OracleCommand cmd = new OracleCommand(); cmd.InitialLONGFetchSize = 1000; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "gsws_get_family_details"; cmd.Parameters.Add("ptype", OracleDbType.Varchar2).Value = obj.type; cmd.Parameters.Add("pdist", OracleDbType.Varchar2).Value = obj.districtId; cmd.Parameters.Add("pmandal", OracleDbType.Varchar2).Value = obj.mandalId; cmd.Parameters.Add("psecretariat", OracleDbType.Varchar2).Value = obj.secId; cmd.Parameters.Add("pcluster", OracleDbType.Varchar2).Value = obj.clusterId; cmd.Parameters.Add("puid_num", OracleDbType.Varchar2).Value = obj.uidNum; cmd.Parameters.Add("phh_id", OracleDbType.Varchar2).Value = obj.hhID; cmd.Parameters.Add("p_cur", OracleDbType.RefCursor).Direction = ParameterDirection.Output; DataTable dtstatus = _Hel.GetProdgswsDataAdapter(cmd); return(dtstatus); } catch (Exception ex) { throw ex; } }