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