public Extensions.DataBaseResult Delete(int id)
{
using (MySqlHealthContext ctx = new MySqlHealthContext())
{
if (!ctx.ServerIsEnable)
{
return(Extensions.DataBaseResult.ServerDisable);
}
Doctor doctor = ctx.Doctors.FirstOrDefault(d => d.Id == id && d.IsActive);
if (doctor == null)
{
return(Extensions.DataBaseResult.NotFound);
}
bool b = ctx.Rendezvouses.Any(r => r.DoctorId == id && r.IsActive) ||
ctx.Examinations.Any(e => e.DoctorId == id && e.IsActive);
if (b)
{
return(Extensions.DataBaseResult.Referanced);
}
doctor.IsActive = false;
return(ctx.SaveChanges() > -1 ? Extensions.DataBaseResult.Success : Extensions.DataBaseResult.Error);
}
}
public Extensions.DataBaseResult Update(Patient newInfoPatient)
{
using (MySqlHealthContext ctx = new MySqlHealthContext())
{
if (!ctx.ServerIsEnable)
{
return(Extensions.DataBaseResult.ServerDisable);
}
Patient patient = ctx.Patients.FirstOrDefault(d => d.Id == newInfoPatient.Id);
if (patient == null)
{
return(Extensions.DataBaseResult.NotFound);
}
patient.TcNo = newInfoPatient.TcNo;
patient.Name = newInfoPatient.Name;
patient.Surname = newInfoPatient.Surname;
patient.MotherName = newInfoPatient.MotherName;
patient.FatherName = newInfoPatient.FatherName;
patient.Address = newInfoPatient.Address;
patient.CityId = newInfoPatient.CityId;
patient.CountryId = newInfoPatient.CountryId;
patient.Phone = newInfoPatient.Phone;
patient.Mail = newInfoPatient.Mail;
patient.BirthDay = newInfoPatient.BirthDay;
patient.Gender = newInfoPatient.Gender;
patient.BloodGroupId = newInfoPatient.BloodGroupId;
patient.IsActive = newInfoPatient.IsActive;
patient.Password = newInfoPatient.Password;
bool b = ctx.SaveChanges() > -1;
return(b ? Extensions.DataBaseResult.Success : Extensions.DataBaseResult.Error);
}
}
public bool Update(Personnel newInfoPersonnel)
{
using (MySqlHealthContext ctx = new MySqlHealthContext())
{
Personnel personnel = ctx.Personnels.FirstOrDefault(d => d.Id == newInfoPersonnel.Id);
if (personnel == null)
{
return(false);
}
personnel.TcNo = newInfoPersonnel.TcNo;
personnel.Name = newInfoPersonnel.Name;
personnel.Surname = newInfoPersonnel.Surname;
personnel.Address = newInfoPersonnel.Address;
personnel.CityId = newInfoPersonnel.CityId;
personnel.CountryId = newInfoPersonnel.CountryId;
personnel.Phone = newInfoPersonnel.Phone;
personnel.Mail = newInfoPersonnel.Mail;
personnel.BirthDay = newInfoPersonnel.BirthDay;
personnel.Gender = newInfoPersonnel.Gender;
personnel.City = newInfoPersonnel.City;
personnel.Country = newInfoPersonnel.Country;
personnel.IsActive = newInfoPersonnel.IsActive;
personnel.DegreeId = newInfoPersonnel.DegreeId;
return(ctx.SaveChanges() > -1);
}
}
public Extensions.DataBaseResult Delete(int id)
{
using (MySqlHealthContext ctx = new MySqlHealthContext())
{
if (!ctx.ServerIsEnable)
{
return(Extensions.DataBaseResult.ServerDisable);
}
Patient patient = ctx.Patients.FirstOrDefault(d => d.Id == id);
if (patient == null)
{
return(Extensions.DataBaseResult.NotFound);
}
bool b = ctx.Consultations.Any(d => d.PatientId == id) || ctx.Examinations.Any(d => d.PatientId == id) ||
ctx.Messages.Any(d => d.PatientId == id) || ctx.Rendezvouses.Any(d => d.PatientId == id);
if (b)
{
return(Extensions.DataBaseResult.Referanced);
}
ctx.Patients.Remove(patient);
return(ctx.SaveChanges() > -1 ? Extensions.DataBaseResult.Success : Extensions.DataBaseResult.Error);
}
}
public Extensions.DataBaseResult Update(City newInfoCity)
{
using (MySqlHealthContext ctx = new MySqlHealthContext())
{
if (!ctx.ServerIsEnable)
{
return(Extensions.DataBaseResult.ServerDisable);
}
if (ctx.Cities.Any(d => d.Name == newInfoCity.Name))
{
return(Extensions.DataBaseResult.AlreadyFound);
}
City city = ctx.Cities.FirstOrDefault(b => b.Id == newInfoCity.Id);
if (city == null)
{
return(Extensions.DataBaseResult.NotFound);
}
city.Name = newInfoCity.Name;
city.IsActive = newInfoCity.IsActive;
return(ctx.SaveChanges() > -1 ? Extensions.DataBaseResult.Success : Extensions.DataBaseResult.Error);
}
}
public Extensions.DataBaseResult Update(Diagnosis newInfoDiagnosis)
{
using (MySqlHealthContext ctx = new MySqlHealthContext())
{
if (!ctx.ServerIsEnable)
{
return(Extensions.DataBaseResult.ServerDisable);
}
if (ctx.Diagnoses.Any(d => d.Name == newInfoDiagnosis.Name && d.Id != newInfoDiagnosis.Id))
{
return(Extensions.DataBaseResult.AlreadyFound);
}
Diagnosis diagnosis = ctx.Diagnoses.FirstOrDefault(d => d.Id == newInfoDiagnosis.Id);
if (diagnosis == null)
{
return(Extensions.DataBaseResult.NotFound);
}
diagnosis.Name = newInfoDiagnosis.Name;
diagnosis.IsActive = newInfoDiagnosis.IsActive;
return(ctx.SaveChanges() > -1 ? Extensions.DataBaseResult.Success : Extensions.DataBaseResult.Error);
}
}
public Extensions.DataBaseResult Update(Doctor newInfoDoctor)
{
using (MySqlHealthContext ctx = new MySqlHealthContext())
{
if (!ctx.ServerIsEnable)
{
return(Extensions.DataBaseResult.ServerDisable);
}
if (ctx.Doctors.Any(d => d.TcNo == newInfoDoctor.TcNo && d.Id != newInfoDoctor.Id))
{
return(Extensions.DataBaseResult.AlreadyFound);
}
Doctor doctor = ctx.Doctors.FirstOrDefault(d => d.Id == newInfoDoctor.Id);
if (doctor == null)
{
return(Extensions.DataBaseResult.NotFound);
}
doctor.Name = newInfoDoctor.Name;
doctor.Surname = newInfoDoctor.Surname;
doctor.BirthDay = newInfoDoctor.BirthDay;
doctor.TcNo = newInfoDoctor.TcNo;
doctor.RegistrationNumber = newInfoDoctor.RegistrationNumber;
doctor.DepartmentId = newInfoDoctor.DepartmentId;
doctor.DegreeId = newInfoDoctor.DegreeId;
doctor.MotherName = newInfoDoctor.MotherName;
doctor.FatherName = newInfoDoctor.FatherName;
doctor.IsActive = newInfoDoctor.IsActive;
doctor.Password = newInfoDoctor.Password;
return(ctx.SaveChanges() > -1 ? Extensions.DataBaseResult.Success : Extensions.DataBaseResult.Error);
}
}
public Extensions.DataBaseResult Update(Department newInfoDepartment)
{
using (MySqlHealthContext ctx = new MySqlHealthContext())
{
if (!ctx.ServerIsEnable)
{
return(Extensions.DataBaseResult.ServerDisable);
}
if (ctx.Departments.Any(d => d.Name == newInfoDepartment.Name && d.Id != newInfoDepartment.Id))
{
return(Extensions.DataBaseResult.AlreadyFound);
}
Department department = ctx.Departments.FirstOrDefault(d => d.Id == newInfoDepartment.Id);
if (department == null)
{
return(Extensions.DataBaseResult.NotFound);
}
department.Name = newInfoDepartment.Name;
department.IsActive = newInfoDepartment.IsActive;
department.MinAge = newInfoDepartment.MinAge;
department.MaxAge = newInfoDepartment.MaxAge;
department.Gender = newInfoDepartment.Gender;
return(ctx.SaveChanges() > -1 ? Extensions.DataBaseResult.Success : Extensions.DataBaseResult.Error);
}
}
public Extensions.DataBaseResult Update(Holiday newInfoHoliday)
{
using (MySqlHealthContext ctx = new MySqlHealthContext())
{
if (!ctx.ServerIsEnable)
{
return(Extensions.DataBaseResult.ServerDisable);
}
if (ctx.Holidays.Any(d => d.Name == newInfoHoliday.Name))
{
return(Extensions.DataBaseResult.AlreadyFound);
}
Holiday holiday = ctx.Holidays.FirstOrDefault(b => b.Id == newInfoHoliday.Id);
if (holiday == null)
{
return(Extensions.DataBaseResult.NotFound);
}
holiday.Name = newInfoHoliday.Name;
holiday.Year = newInfoHoliday.Year;
holiday.Month = newInfoHoliday.Month;
holiday.Day = newInfoHoliday.Day;
return(ctx.SaveChanges() > -1 ? Extensions.DataBaseResult.Success : Extensions.DataBaseResult.Error);
}
}
public Extensions.DataBaseResult Delete(int id)
{
using (MySqlHealthContext ctx = new MySqlHealthContext())
{
if (!ctx.ServerIsEnable)
{
return(Extensions.DataBaseResult.ServerDisable);
}
Diagnosis diagnosis = ctx.Diagnoses.FirstOrDefault(d => d.Id == id);
if (diagnosis == null)
{
return(Extensions.DataBaseResult.NotFound);
}
bool b = ctx.Examinations.Any(d => d.DiagnosisId == id);
if (b)
{
return(Extensions.DataBaseResult.Referanced);
}
ctx.Diagnoses.Remove(diagnosis);
return(ctx.SaveChanges() > -1 ? Extensions.DataBaseResult.Success : Extensions.DataBaseResult.Error);
}
}
public Extensions.DataBaseResult Delete(int id)
{
using (MySqlHealthContext ctx = new MySqlHealthContext())
{
if (!ctx.ServerIsEnable)
{
return(Extensions.DataBaseResult.ServerDisable);
}
Medicament medicament = ctx.Medicaments.FirstOrDefault(d => d.Id == id);
if (medicament == null)
{
return(Extensions.DataBaseResult.NotFound);
}
bool b = ctx.PrescriptionItems.Any(d => d.MedicamentId == id);
if (b)
{
return(Extensions.DataBaseResult.Referanced);
}
ctx.Medicaments.Remove(medicament);
return(ctx.SaveChanges() > -1 ? Extensions.DataBaseResult.Success : Extensions.DataBaseResult.Error);
}
}
public Extensions.DataBaseResult Update(Medicament newInfoMedicament)
{
using (MySqlHealthContext ctx = new MySqlHealthContext())
{
if (!ctx.ServerIsEnable)
{
return(Extensions.DataBaseResult.ServerDisable);
}
if (ctx.Departments.Any(d => d.Name == newInfoMedicament.Name && d.Id != newInfoMedicament.Id))
{
return(Extensions.DataBaseResult.AlreadyFound);
}
Medicament medicament = ctx.Medicaments.FirstOrDefault(d => d.Id == newInfoMedicament.Id);
if (medicament == null)
{
return(Extensions.DataBaseResult.NotFound);
}
medicament.Name = newInfoMedicament.Name;
medicament.UsePerDay = newInfoMedicament.UsePerDay;
medicament.Note = newInfoMedicament.Note;
medicament.IsActive = newInfoMedicament.IsActive;
return(ctx.SaveChanges() > -1 ? Extensions.DataBaseResult.Success : Extensions.DataBaseResult.Error);
}
}
public Extensions.DataBaseResult Delete(int id)
{
using (MySqlHealthContext ctx = new MySqlHealthContext())
{
if (!ctx.ServerIsEnable)
{
return(Extensions.DataBaseResult.ServerDisable);
}
Country country = ctx.Countries.FirstOrDefault(c => c.Id == id);
if (country == null)
{
return(Extensions.DataBaseResult.NotFound);
}
bool b = ctx.Patients.Any(d => d.CountryId == id);
if (b)
{
return(Extensions.DataBaseResult.Referanced);
}
ctx.Countries.Remove(country);
return(ctx.SaveChanges() > -1 ? Extensions.DataBaseResult.Success : Extensions.DataBaseResult.Error);
}
}
public bool Insert(LaboratoryRequestType newLaboratoryRequestType)
{
using (MySqlHealthContext ctx = new MySqlHealthContext())
{
ctx.LaboratoryRequestTypes.Add(newLaboratoryRequestType);
return(ctx.SaveChanges() > -1);
}
}
public bool Insert(Examination newExamination)
{
using (MySqlHealthContext ctx = new MySqlHealthContext())
{
ctx.Examinations.Add(newExamination);
return(ctx.SaveChanges() > -1);
}
}
public bool Insert(Message newMessage)
{
using (MySqlHealthContext ctx = new MySqlHealthContext())
{
ctx.Messages.Add(newMessage);
return(ctx.SaveChanges() > -1);
}
}
public bool Insert(PrescriptionItem newPrescriptionItem)
{
using (MySqlHealthContext ctx = new MySqlHealthContext())
{
ctx.PrescriptionItems.Add(newPrescriptionItem);
return(ctx.SaveChanges() > -1);
}
}
public bool Insert(LaboratoryItemUnit newLaboratoryItemUnit)
{
using (MySqlHealthContext ctx = new MySqlHealthContext())
{
ctx.LaboratoryItemUnits.Add(newLaboratoryItemUnit);
return(ctx.SaveChanges() > -1);
}
}
public bool Insert(BloodGroup newBloodGroup)
{
using (MySqlHealthContext ctx = new MySqlHealthContext())
{
ctx.BloodGroups.Add(newBloodGroup);
return(ctx.SaveChanges() > -1);
}
}
public bool Insert(Personnel newPersonnel)
{
using (MySqlHealthContext ctx = new MySqlHealthContext())
{
ctx.Personnels.Add(newPersonnel);
return(ctx.SaveChanges() > -1);
}
}
public bool Insert(LaboratoryRequest newLaboratoryRequest)
{
using (MySqlHealthContext ctx = new MySqlHealthContext())
{
newLaboratoryRequest.Examination =
ctx.Examinations.FirstOrDefault(e => e.Id == newLaboratoryRequest.ExaminationId);
ctx.LaboratoryRequests.Add(newLaboratoryRequest);
return(ctx.SaveChanges() > -1);
}
}
public bool Delete(int id)
{
using (MySqlHealthContext ctx = new MySqlHealthContext())
{
LaboratoryRequest laboratoryRequest = ctx.LaboratoryRequests.FirstOrDefault(d => d.Id == id);
if (laboratoryRequest == null)
{
return(false);
}
ctx.LaboratoryRequests.Remove(laboratoryRequest);
return(ctx.SaveChanges() > -1);
}
}
public bool Delete(int id)
{
using (MySqlHealthContext ctx = new MySqlHealthContext())
{
BloodGroup bloodGroup = ctx.BloodGroups.FirstOrDefault(b => b.Id == id);
if (bloodGroup == null)
{
return(false);
}
ctx.BloodGroups.Remove(bloodGroup);
return(ctx.SaveChanges() > -1);
}
}
public bool Delete(int id)
{
using (MySqlHealthContext ctx = new MySqlHealthContext())
{
Message message = ctx.Messages.FirstOrDefault(d => d.Id == id);
if (message == null)
{
return(false);
}
ctx.Messages.Remove(message);
return(ctx.SaveChanges() > -1);
}
}
public bool Delete(int id)
{
using (MySqlHealthContext ctx = new MySqlHealthContext())
{
Examination examination = ctx.Examinations.FirstOrDefault(d => d.Id == id);
if (examination == null)
{
return(false);
}
ctx.Examinations.Remove(examination);
return(ctx.SaveChanges() > -1);
}
}
public bool Delete(int id)
{
using (MySqlHealthContext ctx = new MySqlHealthContext())
{
PrescriptionItem prescriptionItem = ctx.PrescriptionItems.FirstOrDefault(d => d.Id == id);
if (prescriptionItem == null)
{
return(false);
}
ctx.PrescriptionItems.Remove(prescriptionItem);
return(ctx.SaveChanges() > -1);
}
}
public Extensions.DataBaseResult Insert(ref Rendezvous newRendezvous)
{
using (MySqlHealthContext ctx = new MySqlHealthContext())
{
if (!ctx.ServerIsEnable)
{
return(Extensions.DataBaseResult.ServerDisable);
}
ctx.Rendezvouses.Add(newRendezvous);
return(ctx.SaveChanges() > -1 ? Extensions.DataBaseResult.Success : Extensions.DataBaseResult.Error);
}
}
public Extensions.DataBaseResult Insert(DoctorPhone newDoctorPhone)
{
using (MySqlHealthContext ctx = new MySqlHealthContext())
{
if (!ctx.ServerIsEnable)
{
return(Extensions.DataBaseResult.ServerDisable);
}
ctx.DoctorPhones.Add(newDoctorPhone);
return(ctx.SaveChanges() > -1 ? Extensions.DataBaseResult.Success : Extensions.DataBaseResult.Error);
}
}
public bool Delete(int id)
{
using (MySqlHealthContext ctx = new MySqlHealthContext())
{
Personnel personnel = ctx.Personnels.FirstOrDefault(d => d.Id == id);
if (personnel == null)
{
return(false);
}
ctx.Personnels.Remove(personnel);
return(ctx.SaveChanges() > -1);
}
}
public bool Insert(RendezvousTime newRendezvousTime)
{
using (MySqlHealthContext ctx = new MySqlHealthContext())
{
if (ctx.RendezvousTimes.Any(d => d.StartTime == newRendezvousTime.StartTime) &&
ctx.RendezvousTimes.Any(d => d.FinishTime == newRendezvousTime.FinishTime))
{
return(false);
}
ctx.RendezvousTimes.Add(newRendezvousTime);
return(ctx.SaveChanges() > -1);
}
}
