public ActionResult SendProductPrice([FromBody] SendProductPriceRequest request)
{
if (request != null)
{
new ProductManager().ChangeProductRecommendedPrice(request);
return(Ok(new { Result = "success" }));
}
return(BadRequest(new { Result = "parameter errors" }));
}
internal void ChangeProductRecommendedPrice(SendProductPriceRequest request)
{
using (var conn = new NpgsqlConnection(DBProvider.GetConnectionString()))
{
conn.Open();
var query = string.Format(
@"
do $$ begin
if (select 1 from ""ProductRecommendedPrice"" where ""Code""='{0}') then
UPDATE ""public"".""ProductRecommendedPrice"" SET ""Price"" = {1} WHERE ""Code"" = '{0}';
ELSE
INSERT INTO ""public"".""ProductRecommendedPrice"" (""Price"", ""Code"") VALUES ('{1}', '{0}');
END IF;
END $$",
(request.Code ?? "").Replace("'", "''"), request.Price.ToString().Replace(",", "."));
new NpgsqlCommand(query, conn).ExecuteNonQuery();
}
}
