public ProductType(ICategory category, IReview review, IOrder order)
{
Name = "Product";
Description = "Product fields";
Field(x => x.ProductId).Description("Product Id");
Field(x => x.Name).Description("Product name");
Field(x => x.Description).Description("Product description");
Field(x => x.Price).Description("Product price");
Field(x => x.ImagePath).Description("Product image path");
Field <ProductType>("Category",
Description = "Category of product",
resolve: context =>
{
return(category.GetById(context.Source.CategoryId));
});
Field <ListGraphType <ReviewType> >("Reviews",
Description = "Reviews of product",
resolve: context =>
{
return(review.GetReviewsByProductId(context.Source.ProductId));
});
Field <ListGraphType <OrderType> >("Orders",
Description = "Orders of product",
resolve: context =>
{
return(order.GetOrdersByProductId(context.Source.ProductId));
});
}
public ReviewViewModel(IReview review)
{
Title = review.Title;
Text = review.Text;
Rating = review.Rating;
DateOfPost = review.DateOfPost;
}
public Result AddReview(IReview review)
{
Result result = new Result()
{
IsSuccessful = true
};
try
{
using (var ctx = new RestaurantReviewContext())
{
Review rev = review as Review;
rev.ReviewID = Guid.NewGuid().ToString();
ctx.Reviews.Add(rev);
ctx.SaveChanges();
}
}
catch (Exception e)
{
result.IsSuccessful = false;
result.Message = e.Message;
}
return(result);
}
public CustomerReviewController(IReviewNotification reviewNotification, IReview review, IReviewAction reviewAction, IReviewKind reviewKind)
{
_review = review;
_reviewNotification = reviewNotification;
_reviewAction = reviewAction;
_reviewKind = reviewKind;
}
public DetailModel(UserManager <User> userManager,
TuplaContext context,
IGame db,
IGamePicture picdb,
IGameTag dbgametag,
IPlatform platformdb,
IPlatformOfGame gamePlatformdb,
ITag dbTag,
IWishList wishdb,
ITransaction transdb,
IOrderDetail orderdetaildb,
IReview reviewdb,
ICustomerPicture userpicdb)
{
this.userManager = userManager;
this.context = context;
this.db = db;
this.picdb = picdb;
this.dbgametag = dbgametag;
this.platformdb = platformdb;
this.gamePlatformdb = gamePlatformdb;
this.dbTag = dbTag;
this.wishdb = wishdb;
this.transdb = transdb;
this.orderdetaildb = orderdetaildb;
this.reviewdb = reviewdb;
this.userpicdb = userpicdb;
}
public UserType(IReview review, IOrder order, IDataLoaderContextAccessor accessor)
{
Name = "User";
Description = "User fields";
Field(x => x.UserId).Description("User Id");
Field(x => x.FullName).Description("User name and surname");
Field <ListGraphType <ReviewType>, IEnumerable <Review> >()
.Name("Reviews")
.Description("User reviews")
.ResolveAsync(ctx =>
{
var ordersLoader = accessor.Context.GetOrAddCollectionBatchLoader <int, Review>("GetReviewsByUserId", review.GetReviewsByUserIdAsync);
return(ordersLoader.LoadAsync(ctx.Source.UserId));
});
Field <ListGraphType <OrderType>, IEnumerable <Order> >()
.Name("Orders")
.Description("User orders")
.ResolveAsync(ctx =>
{
var ordersLoader = accessor.Context.GetOrAddCollectionBatchLoader <int, Order>("GetOrdersByUserId", order.GetOrdersByUserIdAsync);
return(ordersLoader.LoadAsync(ctx.Source.UserId));
});
}
public Book(string title, string author, IReview review)
{
Title = title;
Author = author;
this.review = review;
}
public ReviewViewModel(IReview review, string reviewWriterFullName)
{
Title = review.Title;
Text = review.Text;
Rating = review.Rating;
DateOfPost = review.DateOfPost;
ReviewWriterFullName = reviewWriterFullName;
}
public UssdController(IOrganisationAsync organisation, ICustomer customer, ITeamMember teamMember, IReviewNotification reviewNotification, IReview review)
{
_organisation = organisation;
_customer = customer;
_teamMember = teamMember;
_reviewNotification = reviewNotification;
_review = review;
}
public Review(IReview review)
{
if (review == null)
{
throw new ArgumentNullException(nameof(review));
}
_review = review;
}
public TextOfferSimple(ITravelAgency agency, int n)
{
trip = agency.CreateTrip();
review = new IReview[n];
for (int i = 0; i < n; i++)
{
review[i] = agency.CreateReview();
}
}
public void Review_WhenSet_RaisesPropertyChanged()
{
IReview newReview = AReview.Build();
var test = new ReviewChecklistItem();
test.AssertThatChangeNotificationIsRaisedBy(x => x.Review).
When(() => test.Review = newReview);
Assert.Same(newReview, test.Review);
}
public ITripOffer CreateTemporaryTripOffer()
{
ITravelAgency travelAgency = TravelAgencies[Rd.Next(0, TravelAgencies.Count)];
IReview[] reviews = new IReview[NumberOfReviews];
for (int i = 0; i < NumberOfReviews; ++i)
{
reviews[i] = travelAgency.CreateReview();
}
return(new TextTemporaryTripOffer(travelAgency.CreateTrip(), ViewLimit, reviews));
}
public override IOffer PrepareOffer(ITravelAgency travelAgency)
{
IReview[] reviews = new IReview[reviewsAmount];
for (int i = 0; i < reviewsAmount; i++)
{
reviews[i] = travelAgency.CreateReview();
}
return(new TextOffer(travelAgency.CreateTrip(), reviews));
}
public void CreateOffer(ITravelAgency travelAgency, int descriptionsCount, bool timed, int expireTime)
{
ITrip trip = travelAgency.CreateTrip();
IReview[] reviews = new IReview[descriptionsCount];
for (int i = 0; i < descriptionsCount; i++)
{
reviews[i] = travelAgency.CreateReview();
}
Offers.Add(new TextOffer(trip, reviews, timed, expireTime));
}
/// <summary>
/// コンストラクタ
/// </summary>
/// <param name="reviewModel"></param>
public Review(IReview reviewModel)
{
// 同じ名前のフィールドをコピー
this.CopyFieldsFrom(reviewModel);
// 指摘をコピー
foreach (var issueModel in reviewModel.Issues)
{
var issue = new Issue(issueModel);
Issues.Add(issue);
}
}
public void CreateReview(IReview _review)
{
var review = new ReviewModel
{
ReviewId = _review.ReviewId,
Review = _review.Review,
Rating = _review.Rating,
MovieId = _review.MovieId,
UserId = _review.UserId
};
reviewContext.CreateReview(review);
}
public void CreateReview(IReview review)
{
var _review = new Review()
{
ID = review.ID,
EventID = review.ID,
AccountID = review.AccountID,
Rating = review.Rating,
Message = review.Message
};
ReviewDataBaseHandler.CreateReview(_review);
}
public AdminController(IDonation donation, ILoanDonor loanDonor, IRecurringDonation recurringDonation,
ILoan loan, IContact contact, IUserProfile userProfile, ICause cause, IReview review, IVolunteer volunteer, IConfiguration config, IHttpContextAccessor accessor)
{
_cause = cause;
_recurringdonation = recurringDonation;
_loan = loan;
_loandonor = loanDonor;
_volunteer = volunteer;
_donation = donation;
_contact = contact;
_review = review;
_userprofile = userProfile;
_config = config;
_accessor = accessor;
}
public Result AddReview(IReview review)
{
string filePath = ConfigurationManager.AppSettings["ReviewsXMLFilePath"];
Result result = new Result()
{
IsSuccessful = true
};
List <Review> reviews = new List <Review>();
//Get a list of existing restaurants from disk
IRestaurant[] restaurants = GetRestaurantsByCity(string.Empty);
//Check if the restaurant ID is valid
if (!isRestaurantIDValid(review.RestaurantID, restaurants))
{
result.IsSuccessful = false;
result.Message = Constants.ErrorMessageInvalidRestaurantID;
return(result);
}
//If the restaurant ID is valid, get a list of reviews from disk
try
{
reviews = deserializeFromDisk <List <Review> >(filePath);
}
catch (Exception e)
{
result.IsSuccessful = false;
result.Message = e.Message;
}
//Generate new ID for the review
review.ReviewID = Guid.NewGuid().ToString();
reviews.Add((Review)review);
//Save all reviews to disk
try
{
result = serializeToDisk <List <Review> >(reviews, filePath);
}
catch (Exception e)
{
result.IsSuccessful = false;
result.Message = e.Message;
}
return(result);
}
public bool Update(int id, IReview review)
{
using (var connection = Database.GetConnection())
{
connection.Open();
var cmd = connection.CreateCommand();
cmd.CommandText = ReviewSqlServer.ReqPut;
cmd.Parameters.AddWithValue($"@{ReviewSqlServer.ColId}", id);
cmd.Parameters.AddWithValue($"@{ReviewSqlServer.ColStars}", review.Stars);
cmd.Parameters.AddWithValue($"@{ReviewSqlServer.ColDescriptionReview}", review.DescriptionReview);
return(cmd.ExecuteNonQuery() > 0);
}
}
public void Create(IReview review)
{
if (review == null)
{
throw new ArgumentNullException("review");
}
var errors = _reviewValidator.Validate(review);
if (errors?.Any() == true)
{
throw new Exception(string.Join(Environment.NewLine, errors));
}
_reviewRepository.Create(review);
}
//Update in CRUD
public void UpdateReview(IReview R1)
{
using (MySqlConnection conn = new MySqlConnection(connectionString))
{
string query = "UPDATE review SET EventID = @EventID, AccountID = @AccountID, Rating=@Rating,Message=@Message WHERE ID=@ID; ";
using (MySqlCommand command = new MySqlCommand(query, conn))
{
command.Parameters.AddWithValue("@ID", R1.ID);
command.Parameters.AddWithValue("@EventID", R1.EventID);
command.Parameters.AddWithValue("@AccountID", R1.AccountID);
command.Parameters.AddWithValue("@Rating", R1.Rating);
command.Parameters.AddWithValue("@Message", R1.Message);
command.ExecuteNonQuery();
}
}
}
//Create in CRUD
public void CreateReview(IReview R1)
{
using (MySqlConnection conn = new MySqlConnection(connectionString))
{
string query = "INSERT INTO review VALUES(@EventID, @AccountID,@Rating,@Message); ";
using (MySqlCommand command = new MySqlCommand(query, conn))
{
command.Parameters.AddWithValue("@EventID", R1.EventID);
command.Parameters.AddWithValue("@AccountID", R1.AccountID);
command.Parameters.AddWithValue("@Rating", R1.Rating);
command.Parameters.AddWithValue("@Message", R1.Message);
command.ExecuteNonQuery();
}
}
}
//Create in CRUD
public void CreateReview(IReview review)
{
_connection.SqlConnection.Open();
string query = "INSERT INTO `review` (`ReviewId`, `Review`, `Rating`, `MovieId`, `UserId`) VALUES (@ReviewId, @Review, @Rating, @MovieId, @UserId); ";
using (MySqlCommand command = new MySqlCommand(query, _connection.SqlConnection))
{
command.Parameters.AddWithValue("@ReviewId", review.ReviewId);
command.Parameters.AddWithValue("@Review", review.Review);
command.Parameters.AddWithValue("@Rating", review.Rating);
command.Parameters.AddWithValue("@MovieId", review.MovieId);
command.Parameters.AddWithValue("@UserId", review.UserId);
command.ExecuteNonQuery();
}
_connection.SqlConnection.Close();
}
public void AddReviewTest()
{
IReview review = _container.Resolve <IReview>();
review.RestaurantID = "cb3174cb-d626-499f-b14c-9a87af082c37";
review.Reviewer = "countcyrillus";
review.Rating = "4";
review.Comment = "This is a test";
Result result = _dataAccessLayer.AddReview(review);
Assert.IsTrue(result.IsSuccessful);
Assert.IsNull(result.Message);
review.RestaurantID = "146bb41b-a648-41bd-8999-b0b94ed2bfc";
result = _dataAccessLayer.AddReview(review);
Assert.IsFalse(result.IsSuccessful);
Assert.IsNotNull(result.Message);
}
public IReview Create(int uservId, int itemId, IReview review)
{
using (var connection = Database.GetConnection())
{
connection.Open();
var cmd = connection.CreateCommand();
cmd.CommandText = ReviewSqlServer.ReqCreate;
cmd.Parameters.AddWithValue($"@{ReviewSqlServer.ColStars}", review.Stars);
cmd.Parameters.AddWithValue($"@{ReviewSqlServer.ColTitle}", review.Title);
cmd.Parameters.AddWithValue($"@{ReviewSqlServer.ColDescriptionReview}", review.DescriptionReview);
cmd.Parameters.AddWithValue($"@{ReviewSqlServer.ColItemId}", itemId);
cmd.Parameters.AddWithValue($"@{ReviewSqlServer.ColUserId}", uservId);
review.Id = (int)cmd.ExecuteScalar();
}
return(review);
}
public ProductType(ICategory category, IReview review, IOrder order, IDataLoaderContextAccessor accessor)
{
Name = "Product";
Description = "Product fields";
Field(x => x.ProductId).Description("Product Id");
Field(x => x.Name).Description("Product name");
Field(x => x.Description).Description("Product description");
Field(x => x.Price).Description("Product price");
Field(x => x.ImagePath).Description("Product image path");
Field <ProductType>("Category",
Description = "Category of product",
resolve: context =>
{
return(category.GetByIdAsync(context.Source.CategoryId));
});
Field <ListGraphType <ReviewType>, Review>()
.Name("Reviews")
.Description("Reviews of product")
.ResolveAsync(context =>
{
var loader = accessor.Context.GetOrAddBatchLoader <int, Review>("GetReviewsByProductId", async(IEnumerable <int> ids) => { return(await review.GetReviewsByProductIdAsync(ids)); });
return(loader.LoadAsync(context.Source.ProductId));
//var loader = accessor.Context.GetOrAddBatchLoader<int, Review>("GetReviewsByProductId", review.GetReviewsByProductIdAsync);
//return loader.LoadAsync(context.Source.ProductId);
});
Field <OrderType, Order>()
.Name("Orders")
.Description("Orders of product")
.ResolveAsync(context =>
{
var loader = accessor.Context.GetOrAddBatchLoader <int, Order>("GetOrdersByProductId", async(IEnumerable <int> ids) => { return(await order.GetOrdersByProductIdAsync(ids)); });
return(loader.LoadAsync(context.Source.ProductId));
//var loader = accessor.Context.GetOrAddBatchLoader<int, Order>("GetOrdersByProductId", order.GetOrdersByProductIdAsync);
//return loader.LoadAsync(context.Source.ProductId);
});
}
public UserType(IReview review, IOrder order)
{
Name = "User";
Description = "User fields";
Field(x => x.UserId).Description("User Id");
Field(x => x.FullName).Description("User name and surname");
Field <ListGraphType <ReviewType> >("Reviews",
Description = "User reviews",
resolve: context =>
{
return(review.GetReviewsByUserId(context.Source.UserId));
});
Field <ListGraphType <OrderType> >("Orders",
Description = "User orders",
resolve: context =>
{
return(review.GetReviewsByUserId(context.Source.UserId));
});
}
public IReview SaveReview(IReview review)
{
if (review == null)
{
throw new ArgumentNullException(nameof(review), "Review is required");
}
var reviewEntity = (Review)review;
AuditHelper.SetAuditFieldsOnSave(reviewEntity,
_dateTimeService.UtcNow(),
_securityService.CurrentUserId());
ValidateReview(reviewEntity);
AddReviewToContext(reviewEntity);
_context.SaveChanges();
return(reviewEntity);
}
/// <summary>
/// Add entity
/// </summary>
public async Task<int> AddAsync(IReview review)
{
try
{
return await repository.AddAsync<ReviewEntity>
(Mapper.Map<ReviewEntity>(review));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Update IReview
/// </summary>
/// <param name="review">IReview</param>
/// <returns>IReview</returns>
public async Task<IReview> UpdateIReviewAsync(IReview review)
{
try
{
IUnitOfWork uow = repository.CreateUnitOfWork();
ReviewEntity result = await uow.UpdateWithAttachAsync<ReviewEntity>(AutoMapper.Mapper.Map<ReviewEntity>(review));
await uow.CommitAsync();
return AutoMapper.Mapper.Map<IReview>(result);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Adds review and updates game with score
/// </summary>
/// <param name="review">Review</param>
/// <returns>Review</returns>
public async Task<IReview> AddIReviewAsync(IReview review)
{
try
{
IUnitOfWork uow = repository.CreateUnitOfWork();
ReviewEntity result = await uow.AddAsync<ReviewEntity>(Mapper.Map<ReviewEntity>(review));
await uow.CommitAsync();
return Mapper.Map<IReview>(result);
}
catch (Exception ex)
{
throw ex;
}
}
