public void Update(ReviewEM model)
{
using (IDbConnection db = new SqlConnection(connectionString))
{
db.Query(SP_UPDATE_REVIEW, model, null, true, null, CommandType.StoredProcedure);
}
}
public ReviewEM Create(ReviewEM model)
{
using (IDbConnection db = new SqlConnection(connectionString))
{
DynamicParameters sqlParams = new DynamicParameters();
sqlParams.Add("@Name", model.Name, DbType.String);
sqlParams.Add("@DateOfBirth", model.DateOfBirth, DbType.Date);
sqlParams.Add("@Message", model.Message, DbType.String);
model.Id = db.Query <int>(SP_Create_REVIEW, sqlParams, null, true, null, CommandType.StoredProcedure).FirstOrDefault();
}
return(model);
}
