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