internal BookDTO CreateBookAndAuthor(BookDTO book) { book.BookId = ContentGuid.ToString(); book.Author.AuthorId = ContentGuid.ToString(); List <string> queries = new List <string>(); queries.Add(BuildInsertAuthorQuery(book.Author)); queries.Add(BuildInsertBookQuery(book)); using (var dataSource = DataSource) { dataSource.Open(); using (MySqlTransaction trans = dataSource.BeginTransaction()) { foreach (string query in queries) { ExecuteNonQuery(query, dataSource, trans); } trans.Commit(); } dataSource.Close(); } book.Category = _categoryContract.GetCategoryById(book.Category.CategoryId); return(book); }
private void BindRating() { ContentRatingStats ratingStats = ContentRating.GetStats(ContentGuid); UserRating.CurrentRating = ratingStats.AverageRating; UserRating.JsonUrl = jsonServiceUrl; UserRating.ContentId = ContentGuid.ToString(); UserRating.TotalVotesElementId = lblRatingVotes.ClientID; UserRating.CommentsEnabled = allowFeedback; litRating.Text = ratingStats.AverageRating.ToString(CultureInfo.InvariantCulture); lblRatingVotes.Text = string.Format(CultureInfo.InvariantCulture, Resource.RatingCountFormat, ratingStats.TotalVotes); if (WebUser.IsAdminOrContentAdmin) { //lnkRatingsReview.Text = lblRatingVotes.Text; UserRating.TotalVotesElementId = lnkResults.ClientID; lblRatingVotes.Visible = false; //lnkRatingsReview.Visible = true; //lnkRatingsReview.NavigateUrl = SiteUtils.GetNavigationSiteRoot() + "/Dialog/ContentRatingsDialog.aspx?c=" + ContentGuid.ToString(); //lnkRatingsReview.ToolTip = Resource.RatingReviewsLink; //lnkRatingsReview.DialogCloseText = Resource.CloseDialogButton; lnkResults.Text = lblRatingVotes.Text; lnkResults.Visible = true; lnkResults.NavigateUrl = SiteUtils.GetNavigationSiteRoot() + "/Dialog/ContentRatingsDialog.aspx?c=" + ContentGuid.ToString(); lnkResults.ToolTip = Resource.RatingReviewsLink; } }
internal BookDTO CreateBookAndLinkExistingAuthor(BookDTO book, string authorId) { book.Author.AuthorId = authorId; book.BookId = ContentGuid.ToString(); string query = BuildQueryLinkExistingAuthor(book); using (var dataSource = DataSource) { dataSource.Open(); QueryDataSource(query, dataSource); dataSource.Close(); } book.Category = _categoryContract.GetCategoryById(book.Category.CategoryId); return(book); }
internal CartDTO CreateCart(CartDTO cart) { cart.CartId = ContentGuid.ToString(); DateTime date = DateTime.UtcNow; cart.CartDate = date.ToString("yyyy-MM-dd"); cart.Quantity = 1; string query = BuildCreateCartQuery(cart); using (var dataSource = DataSource) { dataSource.Open(); var queryResult = QueryDataSource(query, dataSource); dataSource.Close(); } return(cart); }
private void UpdateBookAndCreateAuthor(BookDTO book) { book.Author.AuthorId = ContentGuid.ToString(); List <string> queries = new List <string>(); queries.Add(BuildInsertAuthorQuery(book.Author)); queries.Add(BuildUpdateBookQuery(book)); using (var dataSource = DataSource) { dataSource.Open(); using (var trans = dataSource.BeginTransaction()) { foreach (string query in queries) { ExecuteNonQuery(query, dataSource, trans); } trans.Commit(); } dataSource.Close(); } }