void PWResource(int CityID)
{
resetPWPanelVisible();
//PW Distress
var distress = lq.getPWByCityIDCateID(1, CityID, 1, "en").ToList();;
//ISingleResult<getPWNameByCityIDCateIDResult> distress = lq.getPWNameByCityIDCateID(0, 0, 1, "en").ToList();
if (distress.Count() > 0)
{
PanelDistress.Visible = true;
gvpwDistress.DataSource = distress;
gvpwDistress.DataBind();
lblDistressNum.Text = distress.Count() + "";
}
//PW Sexual
var sexual = lq.getPWByCityIDCateID(1, CityID, 2, "en").ToList();
if (sexual.Count() > 0)
{
PanelSexual.Visible = true;
gvpwSexual.DataSource = sexual;
gvpwSexual.DataBind();
lblSexualNum.Text = sexual.Count() + "";
}
//PW LGBT
var lgbt = lq.getPWByCityIDCateID(1, CityID, 3, "en").ToList();
if (lgbt.Count() > 0)
{
Panellgbt.Visible = true;
gvpwlgbt.DataSource = lgbt;
gvpwlgbt.DataBind();
lbllgbtNum.Text = lgbt.Count() + "";
}
//Legal
var legal = lq.getPWByCityIDCateID(1, CityID, 4, "en").ToList();
if (legal.Count() > 0)
{
PanelLegal.Visible = true;
gvpwLegal.DataSource = legal;
gvpwLegal.DataBind();
lblLegalNum.Text = legal.Count() + "";
}
//Shelters
var shelters = lq.getPWByCityIDCateID(1, CityID, 5, "en").ToList();
if (shelters.Count() > 0)
{
PanelShelters.Visible = true;
gvpwShelters.DataSource = shelters;
gvpwShelters.DataBind();
lblSheltersNum.Text = shelters.Count() + "";
}
//Housing
var housing = lq.getPWByCityIDCateID(1, CityID, 6, "en").ToList();
if (housing.Count() > 0)
{
PanelHousing.Visible = true;
gvpwHousing.DataSource = housing;
gvpwHousing.DataBind();
lblHousingNum.Text = housing.Count() + "";
}
//Counselling
var counselling = lq.getPWByCityIDCateID(1, CityID, 7, "en").ToList();
if (counselling.Count() > 0)
{
PanelCounselling.Visible = true;
gvpwCounselling.DataSource = counselling;
gvpwCounselling.DataBind();
lblCounsellingNum.Text = counselling.Count() + "";
}
//Violence
var violence = lq.getPWByCityIDCateID(1, CityID, 8, "en").ToList();
if (violence.Count() > 0)
{
PanelViolence.Visible = true;
gvpwViolence.DataSource = violence;
gvpwViolence.DataBind();
lblViolenceNum.Text = violence.Count() + "";
}
//Drugs
var drug = lq.getPWByCityIDCateID(1, CityID, 9, "en").ToList();
if (drug.Count() > 0)
{
PanelDrugs.Visible = true;
gvpwDrugs.DataSource = drug;
gvpwDrugs.DataBind();
lblDrugsNum.Text = drug.Count() + "";
}
lblPWTotalNum.Text = distress.Count() + sexual.Count() + lgbt.Count() + legal.Count()
+ shelters.Count() + housing.Count() + counselling.Count() + violence.Count()
+ drug.Count() + "";
}