private void saveButton_Click(object sender, EventArgs e)
{
using (vet_clinicContext db = new vet_clinicContext())
{
String validateMessages = validate();
if (validateMessages != null)
{
MessageBox.Show(validateMessages, "Ошибка",
MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
owners.OwnerName = owner_name.Text.Trim();
owners.OwnerSurname = owner_surname.Text.Trim();
owners.OwnerLastname = owner_lastname.Text.Trim();
owners.Phone = phone.Text.Trim();
if (owners.Id == 0)
{
db.Owners.Add(owners);
}
else
{
db.Owners.Update(owners);
}
db.SaveChanges();
}
populateDataGridView();
clear();
}
private void saveButton_Click(object sender, EventArgs e)
{
using (vet_clinicContext db = new vet_clinicContext())
{
String validateMessages = validate();
if (validateMessages != null)
{
MessageBox.Show(validateMessages, "Ошибка",
MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
services.ServiceName = service_name.Text.Trim();
services.Price = Convert.ToDouble(prices.Text);
if (services.Id == 0)
{
db.Services.Add(services);
}
else
{
db.Services.Update(services);
}
db.SaveChanges();
}
populateDataGridView();
clear();
}
private void saveButton_Click(object sender, EventArgs e)
{
using (vet_clinicContext db = new vet_clinicContext())
{
String validateMessages = validate();
if (validateMessages != null)
{
MessageBox.Show(validateMessages, "Ошибка",
MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
veterinarian.VeterinarianName = veterinarian_name.Text.Trim();
veterinarian.VeterinarianSurname = veterinarian_surname.Text.Trim();
veterinarian.VeterinarianLastname = veterinarian_lastname.Text.Trim();
veterinarian.Email = email.Text.Trim();
if (veterinarian.Id == 0)
{
db.Veterinarian.Add(veterinarian);
}
else
{
db.Veterinarian.Update(veterinarian);
}
db.SaveChanges();
}
populateDataGridView();
clear();
}
void populateDataGridView3()
{
ownersServicesView.AutoGenerateColumns = false;
using (vet_clinicContext db = new vet_clinicContext())
{
ownersServicesView.DataSource = db.OwnersServices.ToList();
}
}
void populateDataGridView()
{
veterinarianView.AutoGenerateColumns = false;
using (vet_clinicContext db = new vet_clinicContext())
{
veterinarianView.DataSource = db.Veterinarian.ToList();
}
}
private void animalsVactinationView_DoubleClick(object sender, EventArgs e)
{
if (animalsVactinationView.CurrentRow.Index != -1)
{
animals_vactination.Id = Convert.ToInt32(animalsVactinationView.CurrentRow.Cells["avId"].Value);
using (vet_clinicContext db = new vet_clinicContext())
{
animals_vactination = db.AnimalsVactination.Where(x => x.Id == animals_vactination.Id).FirstOrDefault();
animal_id.Text = animals_vactination.AnimalId.ToString();
vactination_id.Text = animals_vactination.VactinationId.ToString();
}
saveButton.Text = "Обновить";
deleteButton.Enabled = true;
}
}
private void ownersServicesView_DoubleClick(object sender, EventArgs e)
{
if (ownersServicesView.CurrentRow.Index != -1)
{
owners_services.Id = Convert.ToInt32(ownersServicesView.CurrentRow.Cells["osId"].Value);
using (vet_clinicContext db = new vet_clinicContext())
{
owners_services = db.OwnersServices.Where(x => x.Id == owners_services.Id).FirstOrDefault();
owner_id.Text = owners_services.OwnerId.ToString();
service_id.Text = owners_services.ServiceId.ToString();
}
saveButton.Text = "Обновить";
deleteButton.Enabled = true;
}
}
private void vactinationView_DoubleClick(object sender, EventArgs e)
{
if (vactinationView.CurrentRow.Index != -1)
{
vactination.Id = Convert.ToInt32(vactinationView.CurrentRow.Cells["id"].Value);
using (vet_clinicContext db = new vet_clinicContext())
{
vactination = db.Vactination.Where(x => x.Id == vactination.Id).FirstOrDefault();
Console.WriteLine(vactination.VactinationName); // ???
vactination_name.Text = vactination.VactinationName;
}
saveButton.Text = "Обновить";
deleteButton.Enabled = true;
}
}
private void servicesView_DoubleClick(object sender, EventArgs e)
{
if (servicesView.CurrentRow.Index != -1)
{
services.Id = Convert.ToInt32(servicesView.CurrentRow.Cells["id"].Value);
using (vet_clinicContext db = new vet_clinicContext())
{
services = db.Services.Where(x => x.Id == services.Id).FirstOrDefault();
Console.WriteLine(services.ServiceName);
service_name.Text = services.ServiceName;
prices.Text = services.Price.ToString();
}
saveButton.Text = "Обновить";
deleteButton.Enabled = true;
}
}
private void deleteButton_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Вы действительно хотите удалить запись?", "Удалить", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
using (vet_clinicContext db = new vet_clinicContext())
{
var entry = db.Entry(veterinarian);
if (entry.State == Microsoft.EntityFrameworkCore.EntityState.Detached)
{
db.Veterinarian.Attach(veterinarian);
}
db.Veterinarian.Remove(veterinarian);
db.SaveChanges();
}
populateDataGridView();
clear();
}
}
private void veterinarianView_DoubleClick(object sender, EventArgs e)
{
if (veterinarianView.CurrentRow.Index != -1)
{
veterinarian.Id = Convert.ToInt32(veterinarianView.CurrentRow.Cells["id"].Value);
using (vet_clinicContext db = new vet_clinicContext())
{
veterinarian = db.Veterinarian.Where(x => x.Id == veterinarian.Id).FirstOrDefault();
Console.WriteLine(veterinarian.VeterinarianName);
veterinarian_name.Text = veterinarian.VeterinarianName.ToString();
veterinarian_surname.Text = veterinarian.VeterinarianSurname.ToString();
veterinarian_lastname.Text = veterinarian.VeterinarianLastname.ToString();
email.Text = veterinarian.Email.ToString();
}
saveButton.Text = "Обновить";
deleteButton.Enabled = true;
}
}
private void ownerView_DoubleClick(object sender, EventArgs e)
{
if (ownerView.CurrentRow.Index != -1)
{
owners.Id = Convert.ToInt32(ownerView.CurrentRow.Cells["id"].Value);
using (vet_clinicContext db = new vet_clinicContext())
{
owners = db.Owners.Where(x => x.Id == owners.Id).FirstOrDefault();
Console.WriteLine(owners.OwnerName);
owner_name.Text = owners.OwnerName;
owner_surname.Text = owners.OwnerSurname;
owner_lastname.Text = owners.OwnerLastname;
phone.Text = owners.Phone;
}
saveButton.Text = "Обновить";
deleteButton.Enabled = true;
}
}
private void animalsView_DoubleClick(object sender, EventArgs e)
{
if (animalsView.CurrentRow.Index != -1)
{
animals.Id = Convert.ToInt32(animalsView.CurrentRow.Cells["Id"].Value);
using (vet_clinicContext db = new vet_clinicContext())
{
animals = db.Animals.Where(x => x.Id == animals.Id).FirstOrDefault();
AnimalName.Text = animals.AnimalName.ToString();
AnimalBreed.Text = animals.Breed.ToString();
AnimalGender.Text = animals.Gender.ToString();
AnimalAge.Text = animals.Age.ToString();
veterinarian_id.Text = animals.VeterinarianId.ToString();
owner_id.Text = animals.OwnerId.ToString();
}
saveButton.Text = "Обновить";
deleteButton.Enabled = true;
}
}
private void saveButton_Click(object sender, EventArgs e)
{
using (vet_clinicContext db = new vet_clinicContext())
{
String validateMessages = validate();
if (validateMessages != null)
{
MessageBox.Show(validateMessages, "Ошибка",
MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
animals.AnimalName = AnimalName.Text.Trim();
animals.Breed = AnimalBreed.Text.Trim();
animals.Gender = AnimalGender.Text.Trim();
animals.Age = Convert.ToInt32(AnimalAge.Text);
animals.OwnerId = Convert.ToInt32(owner_id.Text);
animals.VeterinarianId = Convert.ToInt32(veterinarian_id.Text);
if (animals.Id == 0)
{
db.Animals.Add(animals);
}
else
{
db.Animals.Update(animals);
}
//db.SaveChanges();
try
{
db.SaveChanges();
}
catch (Microsoft.EntityFrameworkCore.DbUpdateException)
{
MessageBox.Show("Ошибка, Проверьте слуществует ли такой Id", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
populateDataGridView();
clear();
}
void populateDataGridView()
{
animalsView.AutoGenerateColumns = false;
using (vet_clinicContext db = new vet_clinicContext())
{
animalsView.DataSource = db.Animals.ToList();
}
vactinationView.AutoGenerateColumns = false;
using (vet_clinicContext db = new vet_clinicContext())
{
vactinationView.DataSource = db.Vactination.ToList();
}
animalsVactinationView.AutoGenerateColumns = false;
using (vet_clinicContext db = new vet_clinicContext())
{
animalsVactinationView.DataSource = db.AnimalsVactination.ToList();
}
}
private void saveButton_Click(object sender, EventArgs e)
{
using (vet_clinicContext db = new vet_clinicContext())
{
String validateMessages = validate();
if (validateMessages != null)
{
MessageBox.Show(validateMessages, "Ошибка",
MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
owners_services.OwnerId = Convert.ToInt32(owner_id.Text);
owners_services.ServiceId = Convert.ToInt32(service_id.Text);
//owners_services.OwnerId = ownerId;
//WindowsFormsApp3.Models.Owners owners = db.Owners.Where(x => x.Id == ownerId).FirstOrDefault();
//WindowsFormsApp3.Models.Services services = db.Services.Where(x => x.Id == serviceId).FirstOrDefault();
if (owners_services.Id == 0)
{
db.OwnersServices.Add(owners_services);
}
else
{
db.OwnersServices.Update(owners_services);
}
//db.SaveChanges();
try
{
db.SaveChanges();
}
catch (Microsoft.EntityFrameworkCore.DbUpdateException)
{
MessageBox.Show("Ошибка,такого Id Не существует", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
populateDataGridView3();
clear();
}
private void saveButton_Click(object sender, EventArgs e)
{
using (vet_clinicContext db = new vet_clinicContext())
{
String validateMessages = validate();
if (validateMessages != null)
{
MessageBox.Show(validateMessages, "Ошибка",
MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
animals_vactination.AnimalId = Convert.ToInt32(animal_id.Text);
animals_vactination.VactinationId = Convert.ToInt32(vactination_id.Text);
if (animals_vactination.Id == 0)
{
db.AnimalsVactination.Add(animals_vactination);
}
else
{
db.AnimalsVactination.Update(animals_vactination);
}
//db.SaveChanges();
try
{
db.SaveChanges();
}
catch (Microsoft.EntityFrameworkCore.DbUpdateException)
{
MessageBox.Show("Ошибка,такого Id Не существует", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
populateDataGridView();
clear();
}
