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