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