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