// GET: api/CategoryType
//[Authorize(Roles = "17")]
public CategoryListData GetAllCategories()
{
//List<Categories> categoryType = new List<Categories>();
//using (var connection = new SqlConnection(sqlConnectionString))
//{
// connection.Open();
// categoryType = connection.Query<Categories>("Select ID,Category_Name,Category_desc from CategoryMaster").ToList();
// connection.Close();
//}
//return categoryType;
CategoryListData data = new CategoryListData();
var connection = new SqlConnection(sqlConnectionString);
SqlCommand command = new SqlCommand("spManageCategory", connection);
command.CommandType = System.Data.CommandType.StoredProcedure;
connection.Open();
DataTable dt = new DataTable();
dt.Load(command.ExecuteReader());
var list = DataTableToJSONWithJSONNet(dt);
dynamic json = JsonConvert.DeserializeObject(list);
data.CategoryList = json;
return(data);
}
public List <Category> GetCategories(bool WithLabels)
{
Console.WriteLine("Getting categories...");
RestRequest request = new RestRequest("/{version}/admin/categories", Method.GET); //TODO
request.AddParameter("version", _ver, ParameterType.UrlSegment);
if (WithLabels)
{
request.AddParameter("include", "category_labels", ParameterType.QueryString);
}
request.AddHeader("Content-Type", "application/json");
request.AddParameter("Authorization", _token.token_type + " " + _token.access_token, ParameterType.HttpHeader);
IRestResponse response = _client.Execute(request);
HttpStatusCode statusCode = response.StatusCode;
int numericCode = (int)statusCode;
if (numericCode != 200)
{
throw new FoundryException(response.ErrorMessage, numericCode, response.Content);
}
CategoryListData categoryData = JsonConvert.DeserializeObject <CategoryListData>(response.Content);
List <Category> categories = new List <Category>();
foreach (Category category in categoryData.Data)
{
category.ConfigureCategory();
if (WithLabels)
{
for (int i = 0; i < category.Labels.Count; i++)
{
category.Labels[i] = GetLabelById(category.Labels[i].Id);
}
}
/*else
* {
* category.Labels.Clear();
* }*/
categories.Add(category);
}
return(categories);
}
