public void FillVendorDataList(int SocietyID, String UserType)
{
try
{
VendorController vendorController = new VendorController();
DataSet DatasetVendors = vendorController.GetVendors(muser.currentResident.SocietyID, muser.currentResident.UserType, 0);
//String TotalvendorsQuery = "Select Count(ID) from dbo.vendors;";
int Totalvendors = 0; //dacess.GetSingleValue(TotalvendorsQuery);
if (DatasetVendors == null || DatasetVendors.Tables == null || DatasetVendors.Tables.Count == 0 ||
DatasetVendors.Tables[0].Rows.Count == 0)
{
drpvendorfilter.Visible = false;
//lblVendrCatText.Visible = false;
lblVendrEmptyText.Text = "At this time there are no Vendors registered in this society";
}
else
{
drpVendorcategory.Visible = true;
//lblVendrCatText.Visible = true;
DataTable dt = DatasetVendors.Tables[0];
Datavendors.DataSource = dt;
Datavendors.DataBind();
Totalvendors = dt.Rows.Count;
//if (dt.Rows.Count > 0)
//{
// if (dt.Rows.Count == 2)
// {
// Datavendors.Width = new Unit("100%");
// }
// if (dt.Rows.Count == 1)
// {
// Datavendors.Width = new Unit("100%");
// }
// Datavendors.DataSource = dt;
// Datavendors.DataBind();
// Totalvendors = dt.Rows.Count;
//}
lblTotalVendors.Text = Totalvendors.ToString();
}
}
catch (Exception ex)
{
}
}
public void Filterdata(int SocietyID)
{
try
{
muser = (User)Session["User"];
DataAccess dacess = new DataAccess();
if (drpvendorfilter.SelectedItem.Text == "All")
{
FillVendorDataList(muser.currentResident.SocietyID, muser.currentResident.UserType);
}
else
{
String DatalistQuery = "Select * from dbo.Vendors where ShopCategory = '" + drpvendorfilter.SelectedItem.Text + "' and SocietyID ='" + SocietyID + "'";
DataSet ds = dacess.ReadData(DatalistQuery);
int Totalvendors = 0;
if (ds != null && ds.Tables != null && ds.Tables.Count > 0)
{
DataTable data = ds.Tables[0];
if (data.Rows.Count == 2)
{
Datavendors.Width = new Unit("100%");
}
if (data.Rows.Count == 1)
{
Datavendors.Width = new Unit("100%");
}
//String TotalvendorsQuery = "Select Count(ID) from dbo.vendors where ShopCategory = '" + drpvendorfilter.SelectedItem.Text + "'";
Totalvendors = ds.Tables[0].Rows.Count; //dacess.GetSingleValue(TotalvendorsQuery);
}
else
{
ds = new DataSet();
}
Datavendors.DataSource = ds;
Datavendors.DataBind();
lblTotalVendors.Text = Totalvendors.ToString();
}
}
catch (Exception ex)
{
}
}
