public List <ChallanaNoDTO> GetCinEntryChallanaNumbers(string connectionstring)
{
List <ChallanaNoDTO> lstChallanaNumbers = new List <ChallanaNoDTO>();
try
{
using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(connectionstring, CommandType.Text, "select distinct b.challana_no,b.challana_id from cin_entry a join challana_entry b on a.challana_id=b.challana_id order by b.challana_id"))
{
while (dr.Read())
{
ChallanaNoDTO objChallanaNumbers = new ChallanaNoDTO()
{
pChallanaId = dr["challana_id"],
pChallanaNo = dr["challana_no"],
};
lstChallanaNumbers.Add(objChallanaNumbers);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(lstChallanaNumbers);
}
public List <ChallanaNoDTO> GetChallanaPaymentNumbers(string connectionstring)
{
List <ChallanaNoDTO> lstChallanaNumbers = new List <ChallanaNoDTO>();
try
{
using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(connectionstring, CommandType.Text, "select distinct challana_no ,ce.challana_id,from_date,to_date from challana_entry ce join challana_entry_details ced on ce.challana_id=ced.challana_id where voucher_id is not null and ce.challana_id not in(select challana_id from cin_entry ); "))
{
while (dr.Read())
{
ChallanaNoDTO objChallanaNumbers = new ChallanaNoDTO()
{
pChallanaId = dr["challana_id"],
pChallanaNo = dr["challana_no"],
pFromdate = Convert.ToDateTime(dr["from_date"]).ToString("dd/MMM/yyyy"),
pTodate = Convert.ToDateTime(dr["to_date"]).ToString("dd/MMM/yyyy"),
};
lstChallanaNumbers.Add(objChallanaNumbers);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(lstChallanaNumbers);
}
