public List <CategoryRS> Get_CategoryDetails(string Name)
{
List <CategoryRS> lstcategoryRS = new List <CategoryRS>();
try
{
DataTable dt = new DataTable();
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(new SqlParameter("@CategoryName", Name));
dt = DBconnection.FillDataTable(SPNames.GetItemsByName, sqlParameters.ToArray());
for (int i = 0; i < dt.Rows.Count; i++)
{
CategoryRS categoryRS = new CategoryRS();
categoryRS.CategoryName = dt.Rows[i]["CategoryName"].ToString();
categoryRS.SubCategoryName = dt.Rows[i]["SubCategoryName"].ToString();
categoryRS.ItemName = dt.Rows[i]["ItemName"].ToString();
categoryRS.ItemDescription = dt.Rows[i]["Description"].ToString();
lstcategoryRS.Add(categoryRS);
}
}
catch (Exception ex)
{
throw ex;
}
return(lstcategoryRS);
}
