public void Update(PajamaType pajamaType)
{
using var db = new SqlConnection(ConnectionString);
var sql = @"UPDATE [dbo].[PajamaType]
SET [Type] = @Type,
[IsActive] = @IsActive
WHERE Id = @id";
db.Execute(sql, pajamaType);
}
public void Add(PajamaType pajamaType)
{
using var db = new SqlConnection(ConnectionString);
var sql = @"INSERT INTO [dbo].[PajamaType]([Type],[IsActive])
OUTPUT inserted.id
VALUES(@Type,@IsActive)";
var id = db.ExecuteScalar <int>(sql, pajamaType);
pajamaType.Id = id;
}
public IActionResult UpdatePajamaType(PajamaType pajamaType)
{
_repo.Update(pajamaType);
return(Ok(pajamaType));
}
public IActionResult AddPajamaType(PajamaType pajamaType)
{
_repo.Add(pajamaType);
return(Created($"api/PajamaType/{pajamaType.Id}", pajamaType));
}
