public IHttpActionResult PrintChallan(dynamic data) { string serialized_data = token_gen.Authorize_aesdecrpty(data); SeedDepositModal rootobj = JsonConvert.DeserializeObject <SeedDepositModal>(serialized_data); return(Ok(seedsPaymentHelper.PrintChallanData(rootobj))); }
// Seed bank Deposit Module public static dynamic SeedbankDepositModule_hel(SeedDepositModal Lobj) { dynamic _ResObj = new ExpandoObject(); try { DataTable dt = SeedbankDepositModule_sphel(Lobj); if (dt != null && dt.Rows.Count > 0) { _ResObj.Status = 100; _ResObj.Reason = "Data Loaded Successfully"; _ResObj.DataList = dt; } else { _ResObj.Status = 102; _ResObj.Reason = "Data Loading Failed"; } } catch (Exception ex) { if (ex.Message.Contains("ORA-12520:")) { _ResObj.Status = 102; _ResObj.Reason = "Server busy.Please try again after sometime"; } else { _ResObj.Status = 102; _ResObj.Reason = ex.Message; } } return(_ResObj); }
// Seed bank Deposit Module public static DataTable SeedbankDepositModule_sphel(SeedDepositModal Obj) { try { OracleCommand cmd = new OracleCommand(); cmd.InitialLONGFetchSize = 1000; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "GSWS_APSEEDS_CHALLAN_PROC"; cmd.Parameters.Add("P_TYPE", OracleDbType.Varchar2, 200).Value = Obj.P_TYPE; cmd.Parameters.Add("P_DISTRICT", OracleDbType.Varchar2, 200).Value = Obj.P_DISTRICT; cmd.Parameters.Add("P_MANDAL", OracleDbType.Varchar2, 200).Value = Obj.P_MANDAL; cmd.Parameters.Add("P_SEC", OracleDbType.Varchar2, 200).Value = Obj.P_SEC; cmd.Parameters.Add("P_CHALLAN_TXN_ID", OracleDbType.Varchar2, 200).Value = Obj.P_CHALAN_TXN_ID; cmd.Parameters.Add("P_BANK_REF_NO", OracleDbType.Varchar2, 200).Value = Obj.P_BANK_REF_NO; cmd.Parameters.Add("P_BANK_TXN_DATE", OracleDbType.Varchar2, 200).Value = Obj.P_BANK_TXN_DATE; cmd.Parameters.Add("P_CUR", OracleDbType.RefCursor).Direction = ParameterDirection.Output; DataTable dtLogin = _Hel.GetProdgswsDataAdapter(cmd); if (dtLogin != null) { return(dtLogin); } else { return(null); } } catch (Exception ex) { throw ex; } }
public static dynamic PrintChallanData(SeedDepositModal objs) { dynamic _ResObj = new ExpandoObject(); try { DataTable dt = SeedbankDepositModule_sphel(objs); if (dt != null && dt.Rows.Count > 0) { _ResObj.Status = 100; _ResObj.Reason = "Data Loaded Successfully"; _ResObj.DataList = dt; } else { _ResObj.Status = 102; _ResObj.Reason = "Data Loading Failed"; } } catch (Exception ex) { _ResObj.Status = 102; _ResObj.Reason = ex.Message.ToString(); } return(_ResObj); }
public dynamic SeedbankDepositModule(dynamic data) { string jsondata = token_gen.Authorize_aesdecrpty(data); try { SeedDepositModal val = JsonConvert.DeserializeObject <SeedDepositModal>(jsondata); return(Ok(seedsPaymentHelper.SeedbankDepositModule_hel(val))); } catch (Exception ex) { dynamic _response = new ExpandoObject(); _response.Status = 102; _response.Reason = ex.Message.ToString(); return(Ok(_response)); } }