public int edit([FromBody] tb_optional form)
{
var query = $@"
UPDATE [dbo].[tb_optional]
SET [GroupName] = @GroupName
,[Name] = @Name
,[Teaser] = @Teaser
,[Price] = @Price
,[Status] = @Status
,[Add_Date] = Getdate()
,[Update_Date] = Getdate()
WHERE A_ID = @A_ID
";
return(DatabaseContext.Database.Execute(query, form));
}
public int create([FromBody] tb_optional form)
{
var query = $@"
INSERT INTO [dbo].[tb_optional]
([GroupName]
,[Name]
,[Teaser]
,[Price]
,[Status]
,[Add_Date]
,[Update_Date])
VALUES
(@GroupName
,@Name
,@Teaser
,@Price
,@Status
,Getdate()
,Getdate())
";
return(DatabaseContext.Database.Execute(query, form));
}
