public void GetCategory(long CustomerID)
{
ddlPrdCategory.Items.Clear();
iProductSubCategoryMasterClient SubCategoryClient = new iProductSubCategoryMasterClient();
CustomProfile profile = CustomProfile.GetProfile();
ddlPrdCategory.DataSource = SubCategoryClient.GetCategoryListByCustomer(CustomerID, profile.DBConnection._constr);;
ddlPrdCategory.DataTextField = "Name";
ddlPrdCategory.DataValueField = "ID";
ddlPrdCategory.DataBind();
ListItem lst = new ListItem {
Text = "-Select-", Value = "0"
};
ddlPrdCategory.Items.Insert(0, lst);
SubCategoryClient.Close();
}
public static List <contact> GetCategory(object objReq)
{
iProductSubCategoryMasterClient SubCategoryClient = new iProductSubCategoryMasterClient();
CustomProfile profile = CustomProfile.GetProfile();
DataSet ds = new DataSet();
DataTable dt = new DataTable();
List <contact> LocList = new List <contact>();
try
{
Dictionary <string, object> dictionary = new Dictionary <string, object>();
dictionary = (Dictionary <string, object>)objReq;
long ddlcustomer = long.Parse(dictionary["ddlcustomer"].ToString());
ds = SubCategoryClient.GetCategoryListByCustomer(ddlcustomer, profile.DBConnection._constr);
dt = ds.Tables[0];
contact Loc = new contact();
Loc.Name = "--Select--";
Loc.Id = "0";
LocList.Add(Loc);
Loc = new contact();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
Loc.Id = dt.Rows[i]["ID"].ToString();
Loc.Name = dt.Rows[i]["Name"].ToString();
LocList.Add(Loc);
Loc = new contact();
}
}
}
catch
{
}
finally
{
SubCategoryClient.Close();
}
return(LocList);
}