public IActionResult SaveTdsSectionNo(TdsSectionDTO tdsSectionNo)
{
bool isSaved = false;
try
{
isSaved = obReferralAdvocate.SaveTdsSectionNo(tdsSectionNo, Con);
}
catch (Exception ex)
{
throw new FieldAccessException(ex.ToString());
}
return(Ok(isSaved));
}
//public bool saveRelationShip(RelationShipDTO objRelation, string connectionString)
//{
// try
// {
// return NPGSqlHelper.ExecuteNonQuery(connectionString, CommandType.Text, "") > 0 ? true : false;
// }
// catch (Exception)
// {
// throw;
// }
//}
#region GetTdsSectionNo
public List <TdsSectionDTO> getTdsSectionNo(string ConnectionString)
{
lstTdsSectionDetails = new List <TdsSectionDTO>();
try
{
using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(ConnectionString, CommandType.Text, "select recordid,tdssection,coalesce( tdspercentage,0) tdspercentage from tblmsttdssections where statusid=" + Convert.ToInt32(Status.Active) + " order by tdssection;"))
{
while (dr.Read())
{
TdsSectionDTO objTdsSectionDetails = new TdsSectionDTO();
objTdsSectionDetails.pRecordid = Convert.ToInt64(dr["recordid"]);
objTdsSectionDetails.pTdsSection = Convert.ToString(dr["tdssection"]);
objTdsSectionDetails.pTdsPercentage = Convert.ToDecimal(dr["tdspercentage"]);
lstTdsSectionDetails.Add(objTdsSectionDetails);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(lstTdsSectionDetails);
}
public async Task <List <TdsSectionDTO> > getTdsSectionsbyPartyid(long ppartyid, string ConnectionString)
{
await Task.Run(() =>
{
lstTdsSectionDetails = new List <TdsSectionDTO>();
string query = "";
try
{
if (Convert.ToBoolean(NPGSqlHelper.ExecuteScalar(ConnectionString, CommandType.Text, "select count(*) from tblmstparty t1 join tblmstpartytaxdetails t2 on t1.partiid =t2.partiid where istdsapplicable =true and contactid =" + ppartyid + "; ")))
{
query = "select distinct istdsapplicable,tdssectionname tdssection,coalesce( tdspercentage,0) tdspercentage from tblmstparty t1 join tblmstpartytaxdetails t2 on t1.partiid=t2.partiid join tblmsttdssections t3 on t2.tdssectionname=t3.tdssection where t1.contactid =" + ppartyid;
}
else
{
query = "select distinct tdssection,false as istdsapplicable ,coalesce( tdspercentage,0) tdspercentage from tblmsttdssections where statusid=" + Convert.ToInt32(Status.Active) + " order by tdssection;";
}
using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(ConnectionString, CommandType.Text, query))
{
while (dr.Read())
{
TdsSectionDTO objTdsSectionDetails = new TdsSectionDTO();
objTdsSectionDetails.pTdsSection = Convert.ToString(dr["tdssection"]);
objTdsSectionDetails.pTdsPercentage = Convert.ToDecimal(dr["tdspercentage"]);
objTdsSectionDetails.istdsapplicable = Convert.ToBoolean(dr["istdsapplicable"]);
lstTdsSectionDetails.Add(objTdsSectionDetails);
}
}
}
catch (Exception ex)
{
throw ex;
}
});
return(lstTdsSectionDetails);
}