public Models.API.CodeTableDTO Get(int id, bool?sort = true)
{
using (var daCT = new DataAccess.DataAccessObjects.CodeTables())
{
var result = daCT.GetCodeTable(id);
if (result == null)
{
throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.NotFound, "This item does not exist."));
}
else
{
var list = daCT.DropDownForCodeTable((Constants.CodeTables)id, (sort.HasValue && sort.Value));
return(new Models.API.CodeTableDTO()
{
Id = result.CodeTableId,
Description = result.Name,
Values = list.Select(x => new Models.API.CodeValueDTO()
{
CodeTableId = result.CodeTableId,
CodeValue = x.Key,
Description = x.Value
})
});
}
}
}
protected void PopulateLists(Models.BaseWithCodeTables model)
{
using (var daCodeTables = new DataAccess.DataAccessObjects.CodeTables())
{
model.RewardTypes = daCodeTables.DropDownForCodeTable(Constants.CodeTables.RewardType);
model.Characters = daCodeTables.DropDownForCodeTable(Constants.CodeTables.Characters, true);
}
}
public Models.API.CodeValueDTO Get(int id)
{
using (var daCT = new DataAccess.DataAccessObjects.CodeTables())
{
var result = daCT.GetCodeValue(id);
if (result == null)
{
throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.NotFound, "This item does not exist."));
}
else
{
return new Models.API.CodeValueDTO()
{
CodeTableId = result.CodeTableId,
CodeValue = result.CodeValue1,
Description = result.Description
}
};
}
}
}
