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