public async Task <List <ShareviewDTO> > GetSharNames(string Membertype, string Applicanttype, string ConnectionString)
{
List <ShareviewDTO> lstShareviewDTO = new List <ShareviewDTO>();
await Task.Run(() =>
{
try
{
using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(ConnectionString, CommandType.Text, "select distinct shareconfigid,sharename from tblmstshareconfigdetails where membertype='" + ManageQuote(Membertype) + "' and applicanttype='" + ManageQuote(Applicanttype) + "' and statusid=" + Convert.ToInt32(Status.Active) + ";"))
{
while (dr.Read())
{
ShareviewDTO ShareviewDTO = new ShareviewDTO();
ShareviewDTO.pshareconfigid = Convert.ToInt64(dr["shareconfigid"]);
ShareviewDTO.psharename = Convert.ToString(dr["sharename"]);
lstShareviewDTO.Add(ShareviewDTO);
}
}
}
catch (Exception)
{
throw;
}
});
return(lstShareviewDTO);
}
public async Task <List <ShareviewDTO> > GetShareview(string ConnectionString)
{
List <ShareviewDTO> lstShareviewDTO = new List <ShareviewDTO>();
await Task.Run(() =>
{
try
{
using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(ConnectionString, CommandType.Text, "select shareconfigid,sharename,sharecode,sharenamecode,statusid from tblmstshareconfig where statusid = " + Convert.ToInt32(Status.Active) + " order by sharename;"))
{
while (dr.Read())
{
ShareviewDTO ShareviewDTO = new ShareviewDTO();
ShareviewDTO.pshareconfigid = Convert.ToInt64(dr["shareconfigid"]);
ShareviewDTO.psharename = Convert.ToString(dr["sharename"]);
ShareviewDTO.psharecode = Convert.ToString(dr["sharecode"]);
ShareviewDTO.psharenamecode = Convert.ToString(dr["sharenamecode"]);
if (Convert.ToInt32(dr["statusid"]) == Convert.ToInt32(Status.Active))
{
ShareviewDTO.pstatus = "Active";
}
if (Convert.ToInt32(dr["statusid"]) == Convert.ToInt32(Status.Inactive))
{
ShareviewDTO.pstatus = "In-Active";
}
lstShareviewDTO.Add(ShareviewDTO);
}
}
}
catch (Exception)
{
throw;
}
});
return(lstShareviewDTO);
}
