public dynamic LoadBankDetails(JobCardBankModel ObjLGD) { dynamic obj = new ExpandoObject(); PRRDSPHelper spobj = new PRRDSPHelper(); try { DataTable dt = spobj.GetBankDetails_SP(ObjLGD); if (dt != null && dt.Rows.Count > 0) { obj.Status = 100; obj.Reason = ""; obj.BankDetails = dt; } else { obj.Status = 101; obj.Reason = "No Data Found"; } } catch (Exception ex) { string mappath = HttpContext.Current.Server.MapPath("JobcardHelperExceptions"); Task WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_Log_Exception(mappath, "Error Getting LoadBankDetails:" + ex.ToString())); obj.Status = 102; obj.Reason = ex.Message.ToString() + "Error Occued While Loading Data"; return(obj); } return(obj); }
public DataTable GetBankDetails_SP(JobCardBankModel ObjLGD) { try { cmd = new OracleCommand(); cmd.InitialLONGFetchSize = 1000; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "PR_GET_BANK_IFSC_CODES"; cmd.Parameters.Add("P_TYPE", OracleDbType.Varchar2, 10).Value = ObjLGD.TYPE; cmd.Parameters.Add("P_BANK_NAME", OracleDbType.Varchar2, 50).Value = ObjLGD.BankName; cmd.Parameters.Add("P_BRANCH_NAME", OracleDbType.Varchar2, 50).Value = ObjLGD.BranchName; cmd.Parameters.Add("P_IFSC_CODE", OracleDbType.Varchar2, 50).Value = ObjLGD.IFSCCode; cmd.Parameters.Add("P_CUR", OracleDbType.RefCursor).Direction = ParameterDirection.Output; DataTable dtLogin = GetgswsDataAdapter(cmd); if (dtLogin != null) { return(dtLogin); } else { return(null); } } catch (Exception ex) { string mappath = HttpContext.Current.Server.MapPath("JobCardExceptions"); Task WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_Log_Exception(mappath, "Error GetBankDetails_SP" + ex.Message.ToString())); throw ex; } }
public dynamic GetJobCardBankMaster(dynamic data) { string jsondata = token_gen.Authorize_aesdecrpty(data); JobCardBankModel val = JsonConvert.DeserializeObject <JobCardBankModel>(jsondata); LogModel ologmodel = new LogModel(); ologmodel.UserId = val.UserId; ologmodel.SacId = val.SacId; ologmodel.DesignId = val.DesignId; ologmodel.DeptId = string.Empty; ologmodel.TranId = val.TranId; //olog.WriteLogParameters(ologmodel); try { JobCardHelper hlpval = new JobCardHelper(); //_log.Info("In the RevenueController => GetRevenueMaster: " + jsondata.ToString()); return(Ok(hlpval.LoadBankDetails(val))); // return "SuccessEncryptDataModel } catch (Exception ex) { string mappath = HttpContext.Current.Server.MapPath("JobcardControllrExceptions"); Task WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_Log_Exception(mappath, "getting error GetJobCardBankMaster :" + ex.Message.ToString())); CatchData.Status = "Failure"; CatchData.Reason = CommonSPHel.ThirdpartyMessage; return(Ok(CatchData)); } }