protected static void PostReview()
{
var data = new InfrastructureObjectReview
{
InfrastructureObjectId = 1,
ReviewText = "awdasdasd",
UserName = "******"
};
var facade = new InfrastructureObjectReviewsFacade();
var retVal = facade.InsertReview(data);
}
public long InsertReview(InfrastructureObjectReview infrastructureObjectReview)
{
using (var db = GetDbConnection())
{
var cmd = db.CreateCommand();
cmd.CommandText = SqlStrings.InsertReview;
cmd.AddParameter("@InfrastructureObjectId", infrastructureObjectReview.InfrastructureObjectId);
cmd.AddParameter("@UserName", infrastructureObjectReview.UserName);
cmd.AddParameter("@ReviewText", infrastructureObjectReview.ReviewText);
cmd.AddParameter("@Phone", infrastructureObjectReview.Phone);
cmd.AddParameter("@Type", infrastructureObjectReview.IsGoodReview);
return((long)(ulong)cmd.ExecuteScalar());
}
}
