public async Task <List <SchemeTypeDTO> > GetSchemeType(string BranchName, string ConnectionString)
{
List <SchemeTypeDTO> lstSchemetype = new List <SchemeTypeDTO>();
string query = string.Empty;
await Task.Run(() =>
{
try
{
//query = "select distinct tc.fdname,tc.fdconfigid from tblmstfixeddepositConfig tc join tbltransfdcreation tf on tc.fdconfigid=tf.fdconfigid and tf.statusid=" + Convert.ToInt32(Status.Active) + " where chitbranchname='"+ BranchName + "' AND tc.statusid=" + Convert.ToInt32(Status.Active) + " order by fdname";
query = "select distinct fdconfigid,fdname from vwfdtransaction_details where chitbranchname='" + BranchName + "' and balanceamount<=0 and interestpayout<>'On Maturity' and fdaccountid not in(select trans_type_id from maturity_bonds) and fdaccountid not in(select fd_account_id from self_or_adjustment) order by fdname";
using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(ConnectionString, CommandType.Text, query))
{
while (dr.Read())
{
SchemeTypeDTO objSchemetypes = new SchemeTypeDTO();
objSchemetypes.pSchemeid = dr["fdconfigid"];
objSchemetypes.pSchemeName = dr["fdname"];
lstSchemetype.Add(objSchemetypes);
}
}
}
catch (Exception ex)
{
throw ex;
}
});
return(lstSchemetype);
}
public async Task <List <SchemeTypeDTO> > GetSchemeType(string ConnectionString)
{
List <SchemeTypeDTO> lstSchemetype = new List <SchemeTypeDTO>();
await Task.Run(() =>
{
try
{
using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(ConnectionString, CommandType.Text, "select distinct fdname,fdconfigid from tblmstfixeddepositConfig where statusid = " + Convert.ToInt32(Status.Active) + " order by fdname;"))
{
while (dr.Read())
{
SchemeTypeDTO objSchemetypes = new SchemeTypeDTO();
objSchemetypes.pSchemeid = dr["fdconfigid"];
objSchemetypes.pSchemeName = dr["fdname"];
lstSchemetype.Add(objSchemetypes);
}
}
}
catch (Exception ex)
{
throw ex;
}
});
return(lstSchemetype);
}
