public async Task <List <ChitBranchDetails> > GetFDReceiptBranchDetails(string Connectionstring)
{
List <ChitBranchDetails> _ChitBranchDetailsList = new List <ChitBranchDetails>();
await Task.Run(() =>
{
try
{
using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(Connectionstring, CommandType.Text, "select * from (select distinct chitbranchid,chitbranchname,count(case when contacttype='Business Entity' then '1' else tn.vchapplicationid end)count from vwfdtransaction_details fd left join tabapplicationpersonalnomineedetails tn on tn.vchapplicationid=fd.fdaccountno where balanceamount >0 group by chitbranchid,chitbranchname order by chitbranchname)tbl where count>0"))
{
while (dr.Read())
{
var _ChitBranchDetails = new ChitBranchDetails
{
pBranchId = Convert.ToInt64(dr["chitbranchid"]),
pBranchname = dr["chitbranchname"],
};
_ChitBranchDetailsList.Add(_ChitBranchDetails);
}
}
}
catch (Exception)
{
throw;
}
});
return(_ChitBranchDetailsList);
}
public async Task <List <ChitBranchDetails> > GetFDBranchDetails(string Connectionstring)
{
List <ChitBranchDetails> _ChitBranchDetailsList = new List <ChitBranchDetails>();
await Task.Run(() =>
{
try
{
using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(Connectionstring, CommandType.Text, "select distinct chitbranchid,chitbranchname from vwfdtransaction_details where balanceamount<=0 and fdaccountid not in(select trans_type_id from maturity_bonds) order by chitbranchname;"))
{
while (dr.Read())
{
var _ChitBranchDetails = new ChitBranchDetails
{
pBranchId = Convert.ToInt64(dr["chitbranchid"]),
pBranchname = dr["chitbranchname"]
};
_ChitBranchDetailsList.Add(_ChitBranchDetails);
}
}
}
catch (Exception)
{
throw;
}
});
return(_ChitBranchDetailsList);
}
public async Task <List <ChitBranchDetails> > GetFDBranchDetails(string Connectionstring)
{
List <ChitBranchDetails> _ChitBranchDetailsList = new List <ChitBranchDetails>();
await Task.Run(() =>
{
try
{
using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(Connectionstring, CommandType.Text, "select distinct tc.code, tc.branchname, tc.vchregion, tc.vchzone from tabbranchcodes tc join tbltransfdcreation tf on tc.code=tf.chitbranchid::numeric(9,0) where tf.statusid=" + Convert.ToInt32(Status.Active) + " order by tc.branchname;"))
{
while (dr.Read())
{
var _ChitBranchDetails = new ChitBranchDetails
{
pBranchId = Convert.ToInt64(dr["code"]),
pBranchname = dr["branchname"],
pVchRegion = dr["vchregion"],
pVchZone = dr["vchzone"]
};
_ChitBranchDetailsList.Add(_ChitBranchDetails);
}
}
}
catch (Exception)
{
throw;
}
});
return(_ChitBranchDetailsList);
}
