public Pajama Add(PajamaAdd pajama) { var sql = @"INSERT INTO [Pajama] ([Size],[Color],[Pattern], [Price], [Description], [Inventory], [Title], [DateCreated], [IsActive], [PajamaTypeId], [PetTypeId], [Image]) OUTPUT inserted.* VALUES(@Size, @Color, @Pattern, @Price, @Description, @Inventory, @Title, @DateCreated, @IsActive, @PajamaTypeId, @PetTypeId, @Image)"; using var db = new SqlConnection(ConnectionString); var newPajama = db.QuerySingle <Pajama>(sql, new { pajama.Size, pajama.Color, pajama.Pattern, pajama.Price, pajama.Description, pajama.Inventory, pajama.Title, pajama.DateCreated, pajama.IsActive, pajama.PajamaTypeId, pajama.PetTypeId, pajama.Image }); return(newPajama); }
public void Update(PajamaAdd pajama) { using var db = new SqlConnection(ConnectionString); var sql = @"update Pajama Set Size = @Size, Color = @Color, Pattern = @Pattern, Price = @Price, Description = @Description, Inventory = @Inventory, Title = @Title, DateCreated = @DateCreated, IsActive = @IsActive, PajamaTypeId = @PajamaTypeId, PetTypeId = @PetTypeId, Image = @Image Where Id = @id"; db.Execute(sql, pajama); }
public IActionResult UpdatePajama(PajamaAdd pajama) { _repo.Update(pajama); return(Ok()); }
public IActionResult AddPajama(PajamaAdd pajama) { var newPajama = _repo.Add(pajama); return(Created($"api/Pajamas/{newPajama.Id}", newPajama)); }