public int Create(PetVaccine item)
{
_context.PetVaccines.Add(item);
_context.SaveChanges();
return item.Id;
}
public void Update(int id, PetVaccine item)
{
var todo = _context.PetVaccines.Find(id);
if (todo == null)
{
return;
}
_context.PetVaccines.Update(todo);
_context.SaveChanges();
return;
}
public static List <PetVaccine> LoadVaccines()
{
List <PetVaccine> vaccineList = new List <PetVaccine>();
DataBase dataBase = new DataBase("LAPTOP-N5V21FUT\\SQLEXPRESS", "AdoPetDB");
var dane = dataBase.SelectQuery("SELECT * FROM Vaccines WHERE RemovalDate IS NULL");
foreach (DataRow dr in dane)
{
PetVaccine petvaccine = new PetVaccine();
petvaccine.ID = int.Parse(dr["ID"].ToString());
petvaccine.Name = dr["Name"].ToString();
petvaccine.ValidInMonths = int.Parse(dr["ValidInMonths"].ToString());
vaccineList.Add(petvaccine);
}
return(vaccineList);
}
public IActionResult Update(int id, PetVaccine item)
{
_service.Update(id, item);
return(NoContent());
}
public IActionResult Create(PetVaccine item)
{
var id = _service.Create(item);
return(CreatedAtRoute("GetPetVaccine", new { id = item.Id }, item));
}
