private List <BankUPI> ViewBankUpiDetails(long pRecordid, string con) { lstBankUpi = new List <BankUPI>(); try { using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(con, CommandType.Text, "select recordid,bankid,upiid,upiname,statusname,'OLD' as typeofoperation from tblmstbankupidtls t join tblmststatus ts on t.statusid=ts.statusid and upper(statusname)=upper('active') where bankid=" + pRecordid + "")) { while (dr.Read()) { BankUPI obj = new BankUPI(); obj.pRecordid = Convert.ToInt64(dr["recordid"]); obj.pBankId = Convert.ToInt64(dr["bankid"]); obj.pUpiid = Convert.ToString(dr["upiid"]); obj.pUpiname = Convert.ToString(dr["upiname"]); obj.pStatusname = Convert.ToString(dr["statusname"]); obj.ptypeofoperation = Convert.ToString(dr["typeofoperation"]); lstBankUpi.Add(obj); } } } catch (Exception ex) { throw ex; } return(lstBankUpi); }
public async Task <List <BankUPI> > GetUpiNames(long bankid, string ConnectionString) { await Task.Run(() => { bankupilist = new List <BankUPI>(); try { using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(ConnectionString, CommandType.Text, "select upiid,upiname from tblmstbankupidtls where bankid=" + bankid + " and statusid=" + Convert.ToInt32(Status.Active) + " order by upiname;")) { while (dr.Read()) { BankUPI _BankUPI = new BankUPI { pUpiid = Convert.ToString(dr["upiid"]), pUpiname = Convert.ToString(dr["upiname"]) }; bankupilist.Add(_BankUPI); } } } catch (Exception ex) { throw ex; } }); return(bankupilist); }
public List <BankUPI> GetBankUPIDetails(string con) { List <BankUPI> lstBankUPI = new List <BankUPI>(); try { using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(con, CommandType.Text, "select recordid,upiname from tblmstbankupi t join tblmststatus t1 on t.statusid=t1.statusid where t1.statusname='Active';")) { while (dr.Read()) { BankUPI obj = new BankUPI(); obj.pRecordid = Convert.ToInt64(dr["recordid"]); obj.pUpiname = Convert.ToString(dr["upiname"]); lstBankUPI.Add(obj); } } } catch (Exception ex) { throw ex; } return(lstBankUPI); }