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));
}
}
