private void delete_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("Do you want to delete account?", "Warning!", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
if (_table.Equals("Clinic"))
{
using (VeterinaryEntities dataBase = new VeterinaryEntities())
{
Clinic clinic = dataBase.Clinics.FirstOrDefault(c => c.Name.Equals(_username) && c.City.Equals(_password));
dataBase.Clinics.Remove(clinic);
dataBase.SaveChanges();
}
}
else if (_table.Equals("Owner"))
{
using (VeterinaryEntities dataBase = new VeterinaryEntities())
{
Owner owner = dataBase.Owners.FirstOrDefault(c => c.Name.Equals(_username) && c.SurName.Equals(_password));
dataBase.Owners.Remove(owner);
dataBase.SaveChanges();
}
}
DialogResult = DialogResult.OK;
Close();
}
}
private void ok_Click(object sender, EventArgs e)
{
fName.ForeColor = System.Drawing.Color.Black;
sName.ForeColor = System.Drawing.Color.Black;
pCode.ForeColor = System.Drawing.Color.Black;
phone.ForeColor = System.Drawing.Color.Black;
if (string.IsNullOrEmpty(fName.Text) || string.IsNullOrEmpty(sName.Text) ||
string.IsNullOrEmpty(pCode.Text))
{
MessageBox.Show("Some required fields are empty.", "Error", MessageBoxButtons.OK);
}
else
{
if (CheckValidation())
{
using (VeterinaryEntities dataBase = new VeterinaryEntities())
{
dataBase.Vets.Add(new Vet
{
Clinic = _username,
Name = fName.Text,
SurName = sName.Text,
PCode = pCode.Text,
Phone = _phone,
StartedAt = _date
});
dataBase.SaveChanges();
}
Close();
}
}
}
private void ok_Click(object sender, EventArgs e)
{
city_fNameTextBox.ForeColor = System.Drawing.Color.Black;
streetTextBox.ForeColor = System.Drawing.Color.Black;
noTextBox.ForeColor = System.Drawing.Color.Black;
phoneTextBox.ForeColor = System.Drawing.Color.Black;
sNameTextBox.ForeColor = System.Drawing.Color.Black;
if (_table.Equals("Clinic"))
{
if (CheckValidation())
{
using (VeterinaryEntities dataBase = new VeterinaryEntities())
{
Clinic clinic = dataBase.Clinics.FirstOrDefault(c => c.Name.Equals(_username));
clinic.City = city_fNameTextBox.Text;
clinic.Street = streetTextBox.Text;
clinic.No = noTextBox.Text;
clinic.Phone = phoneTextBox.Text;
dataBase.SaveChanges();
}
Close();
}
}
else if (_table.Equals("Owner"))
{
if (CheckValidation())
{
using (VeterinaryEntities dataBase = new VeterinaryEntities())
{
Owner owner = dataBase.Owners.FirstOrDefault(c => c.PCode.Equals(_username));
owner.Name = city_fNameTextBox.Text;
owner.SurName = streetTextBox.Text;
owner.Phone = phoneTextBox.Text;
dataBase.SaveChanges();
}
Close();
}
}
else if (_table.Equals("Vet"))
{
if (CheckValidation())
{
using (VeterinaryEntities dataBase = new VeterinaryEntities())
{
Vet vet = dataBase.Vets.FirstOrDefault(c => c.PCode.Equals(_username));
vet.Name = city_fNameTextBox.Text;
vet.SurName = streetTextBox.Text;
vet.Phone = phoneTextBox.Text;
vet.StartedAt = startedDate.Value.Date;
dataBase.SaveChanges();
}
Close();
}
}
}
private void ok_Click(object sender, EventArgs e)
{
using (VeterinaryEntities dataBase = new VeterinaryEntities())
{
var treat = dataBase.Treatments.Add(new Treatment {
Animal = _selectedPet,
Vet = _selectedVet,
Start = startDate.Value.Date,
End = null
});
dataBase.SaveChanges();
}
Close();
}
private void ok_Click(object sender, EventArgs e)
{
name.ForeColor = System.Drawing.Color.Black;
type.ForeColor = System.Drawing.Color.Black;
species.ForeColor = System.Drawing.Color.Black;
weight.ForeColor = System.Drawing.Color.Black;
color.ForeColor = System.Drawing.Color.Black;
if (_type.Equals("Vet") || _type.Equals("VetEdit"))
{
if (survive.Checked)
{
using (VeterinaryEntities dataBase = new VeterinaryEntities())
{
var treats = dataBase.Treatments.Where(t => t.Animal == _petId && _pCode.Equals(t.Vet)).Select(t => t);
foreach (var treat in treats)
{
dataBase.Treatments.Remove(treat);
}
Pet pet = dataBase.Pets.Where(t => t.Id == _petId).Select(t => t).First();
dataBase.Pets.Remove(pet);
dataBase.SaveChanges();
}
}
else
{
using (VeterinaryEntities dataBase = new VeterinaryEntities())
{
Treatment treat = dataBase.Treatments.Where(t => t.Animal == _petId && t.Vet.Equals(_pCode)).Select(t => t).First();
treat.End = endDate.Value.Date;
dataBase.SaveChanges();
}
}
Close();
}
else
{
if (string.IsNullOrEmpty(name.Text) || string.IsNullOrEmpty(type.Text))
{
MessageBox.Show("Some required fields are empty.", "Error", MessageBoxButtons.OK);
}
else
{
if (CheckValidation())
{
string str_connection = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Dovile\Desktop\Veterinary\VeterinarySystem\VeterinarySystem\DatabaseVeterinary.mdf;Integrated Security=True";
SqlConnection connection = new SqlConnection();
connection.ConnectionString = str_connection;
connection.Open();
SqlCommand insert = new SqlCommand("INSERT INTO Pet (Name, Owner, Type, Species, Born, Weight, Color) " +
"VALUES (@N, @O, @T, @S, @B, @W, @C)", connection);
insert.Parameters.Add(new SqlParameter("@N", name.Text));
insert.Parameters.Add(new SqlParameter("@O", _pCode));
insert.Parameters.Add(new SqlParameter("@T", type.Text));
if (string.IsNullOrEmpty(species.Text))
{
insert.Parameters.Add(new SqlParameter("@S", DBNull.Value));
}
else
{
insert.Parameters.Add(new SqlParameter("@S", species.Text));
}
if (string.IsNullOrEmpty(birth.Text))
{
insert.Parameters.Add(new SqlParameter("@B", DBNull.Value));
}
else
{
insert.Parameters.Add(new SqlParameter("@B", birth.Value.Date));
}
if (string.IsNullOrEmpty(weight.Text))
{
insert.Parameters.Add(new SqlParameter("@W", DBNull.Value));
}
else
{
insert.Parameters.Add(new SqlParameter("@W", weight.Text));
}
if (string.IsNullOrEmpty(color.Text))
{
insert.Parameters.Add(new SqlParameter("@C", DBNull.Value));
}
else
{
insert.Parameters.Add(new SqlParameter("@C", color.Text));
}
try
{
insert.ExecuteNonQuery();
}
catch (SqlException) { }
connection.Close();
Close();
}
}
}
}