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