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); }