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