public dynamic SavegetSpandanaGrievance(RootSpandaObject obj) { dynamic objdata = new ExpandoObject(); try { string status = SaveSpandanaGrievance(obj); if (status == "Success") { objdata.StatusCode = "100"; objdata.Message = "Data Submitted Successfully"; return(objdata); } else { objdata.StatusCode = "102"; objdata.Message = "Data Not Submitted Please try Again"; return(objdata); } } catch (Exception ex) { objdata.StatusCode = "102"; objdata.Message = CommonSPHel.ThirdpartyMessage; return(objdata); } }
public dynamic SaveSpandanaGrievance(RootSpandaObject objspandana) { try { cmd = new OracleCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "Insert into gsws_spandana_grienvance (AADHAARNUMBER,HOUSEHOLDID,APPLICANTNAME,CAREOF,AGE,GENDER,PINCODE,MOBILE,INCOME,OCCUPATION,APPTYPEINFO,APPCREATOR,MKMDISTCODE,MKMMANDALCODE,MKMVILLAGECODE,PSSDISTCODE,PSSMANDALCODE,PSSVILLAGECODE,HODID,FORMID,PROBLEMDETAILS,HABITATION,PRESENTADDRESS,LOGINUSER)" + " Values(:AADHAARNUMBER,:HOUSEHOLDID,:APPLICANTNAME,:CAREOF,:AGE,:GENDER,:PINCODE,:MOBILE,:INCOME,:OCCUPATION,:APPTYPEINFO,:APPCREATOR,:MKMDISTCODE,:MKMMANDALCODE,:MKMVILLAGECODE,:PSSDISTCODE,:PSSMANDALCODE,:PSSVILLAGECODE,:HODID,:FORMID,:PROBLEMDETAILS,:HABITATION,:PRESENTADDRESS,:LOGINUSER)"; cmd.Parameters.Add(":AADHAARNUMBER", OracleDbType.Varchar2, 12).Value = objspandana.AadhaarNumber; cmd.Parameters.Add(":HOUSEHOLDID", OracleDbType.Varchar2, 50).Value = objspandana.HouseHoldId; cmd.Parameters.Add(":APPLICANTNAME", OracleDbType.Varchar2, 200).Value = objspandana.ApplicantName; cmd.Parameters.Add(":CAREOF", OracleDbType.Varchar2, 200).Value = objspandana.CareOf; cmd.Parameters.Add(":AGE", OracleDbType.Varchar2, 50).Value = objspandana.Age; cmd.Parameters.Add(":GENDER", OracleDbType.Varchar2, 20).Value = objspandana.Gender; cmd.Parameters.Add(":PINCODE", OracleDbType.Varchar2, 12).Value = objspandana.PinCode; cmd.Parameters.Add(":MOBILE", OracleDbType.Varchar2, 50).Value = objspandana.Mobile; cmd.Parameters.Add(":INCOME", OracleDbType.Varchar2, 50).Value = objspandana.Income; cmd.Parameters.Add(":OCCUPATION", OracleDbType.Varchar2, 200).Value = objspandana.Occupation; cmd.Parameters.Add(":APPTYPEINFO", OracleDbType.Varchar2, 12).Value = objspandana.AppTypeInfo; cmd.Parameters.Add(":APPCREATOR ", OracleDbType.Varchar2, 50).Value = objspandana.AppCreator; cmd.Parameters.Add(":MKMDISTCODE", OracleDbType.Varchar2, 200).Value = objspandana.MkmDistCode; cmd.Parameters.Add(":MKMMANDALCODE", OracleDbType.Varchar2, 12).Value = objspandana.MkmMandalCode; cmd.Parameters.Add(":MKMVILLAGECODE ", OracleDbType.Varchar2, 50).Value = objspandana.MkmVillageCode; cmd.Parameters.Add(":PSSDISTCODE", OracleDbType.Varchar2, 200).Value = objspandana.PssDistCode; cmd.Parameters.Add(":PSSMANDALCODE", OracleDbType.Varchar2, 12).Value = objspandana.PssMandalCode; cmd.Parameters.Add(":PSSVILLAGECODE", OracleDbType.Varchar2, 50).Value = objspandana.PssVillageCode; cmd.Parameters.Add(":HODID", OracleDbType.Varchar2, 200).Value = objspandana.HodId; cmd.Parameters.Add(":FORMID", OracleDbType.Varchar2, 12).Value = objspandana.FormID; cmd.Parameters.Add(":PROBLEMDETAILS", OracleDbType.Varchar2, 250).Value = objspandana.ProblemDetails; cmd.Parameters.Add(":HABITATION", OracleDbType.Varchar2, 200).Value = objspandana.Habitation; cmd.Parameters.Add(":PRESENTADDRESS", OracleDbType.Varchar2, 200).Value = objspandana.PresentAddress; cmd.Parameters.Add(":LOGINUSER", OracleDbType.Varchar2, 200).Value = objspandana.Loginuser; int k = comhel.getgswsExecuteNonQuery(cmd); if (k > 0) { return("Success"); } else { return("Failure"); } } catch (Exception ex) { string mappath = HttpContext.Current.Server.MapPath("SapandaSubmitExceptionLogs"); Task WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_Log_Exception(mappath, ex.Message.ToString())); throw ex; } }
public IHttpActionResult SapandaSubmit(dynamic data) { string value = token_gen.Authorize_aesdecrpty(data); try { string mappath = HttpContext.Current.Server.MapPath("SapandaSubmitLogs"); Task WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_Log(mappath, value)); RootSpandaObject root = JsonConvert.DeserializeObject <RootSpandaObject>(value); //CatchData.StatusCode = "200"; //CatchData.Message = "Data Submitted Successfully"; return(Ok(Revenuehel.SavegetSpandanaGrievance(root))); } catch (Exception ex) { CatchData.Status = "Failure"; CatchData.Reason = CommonSPHel.ThirdpartyMessage; return(Ok(CatchData)); } }