public long?AddResource(string category, ApiClassResource resource)
{
if (string.IsNullOrWhiteSpace(category))
{
SetResponseStatus(HttpStatusCode.NotFound, "Invalid query parameter category");
return(null);
}
long?result;
try
{
resource.Category = category;
var dataResource = new DataClassResource();
result = dataResource.SaveResource(category, resource);
if (result == null)
{
SetResponseStatus(HttpStatusCode.InternalServerError, "Unable to save resource");
}
}
catch (Exception ex)
{
SetResponseStatus(HttpStatusCode.NotFound, ex.Message);
result = null;
}
return(result);
}
public long?SaveResource(string category, ApiClassResource resource)
{
long?resourceId = null;
ResourcesTblAdapter.SaveResource(ref resourceId, category, resource.Title, resource.Author, resource.Description, resource.Website, resource.URL);
if (resourceId != null)
{
var dataReview = new DataClassReview();
if (!dataReview.SaveReviewList((long)resourceId, resource.Reviews))
{
ResourcesTblAdapter.DeleteResource(resourceId);
resourceId = null;
}
}
return(resourceId);
}
public bool UpdateResource(long?resourceId, ApiClassResource resource)
{
ResourcesTblAdapter.SaveResource(ref resourceId, resource.Category, resource.Title, resource.Author, resource.Description, resource.Website, resource.URL);
var bResult = (resourceId != null);
if (bResult)
{
var dataReview = new DataClassReview();
bResult = dataReview.DeleteResourceReviews((long)resourceId);
if (bResult)
{
bResult = dataReview.SaveReviewList((long)resourceId, resource.Reviews);
}
}
return(bResult);
}
public void LoadResourceList(string category, List <ApiClassResource> resourceList)
{
resourceList.Clear();
var dataReview = new DataClassReview();
var dt = ResourcesTblAdapter.GetData(category);
for (var i = 0; i < dt.Count; i++)
{
var resource = new ApiClassResource();
resource.ID = dt[i].Resource_ID;
if (!dt[i].IsCategoryNull())
{
resource.Category = dt[i].Category;
}
if (!dt[i].IsTitleNull())
{
resource.Title = dt[i].Title;
}
if (!dt[i].IsAuthorNull())
{
resource.Author = dt[i].Author;
}
if (!dt[i].IsDescriptionNull())
{
resource.Description = dt[i].Description;
}
if (!dt[i].IsWebsiteNull())
{
resource.Website = dt[i].Website;
}
if (!dt[i].IsURLNull())
{
resource.URL = dt[i].URL;
}
//
dataReview.LoadReviewList(resource.ID, resource.Reviews);
resourceList.Add(resource);
}
}
public bool UpdateResource(long resourceId, ApiClassResource resource)
{
bool result = false;
try
{
resource.ID = resourceId;
var dataResource = new DataClassResource();
result = dataResource.UpdateResource(resourceId, resource);
}
catch (Exception ex)
{
SetResponseStatus(HttpStatusCode.InternalServerError, ex.Message);
return(false);
}
if (!result)
{
SetResponseStatus(HttpStatusCode.InternalServerError, "Unable to update resource");
}
return(result);
}
