public ActionResult Edit(int?id) { if (User.IsInRole("manager") || User.IsInRole("director")) { ; } else if (User.IsInRole("doctor")) { var user = HttpContext.GetOwinContext().GetUserManager <ApplicationUserManager>().Users.FirstOrDefault(it => it.UserName == User.Identity.Name); int doctorId = DoctorsId.getDoctorId(user.Id); if (doctorId != id) { return(RedirectToAction("Index")); } } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } doctors doctors = db.doctors.Find(id); if (doctors == null) { return(HttpNotFound()); } return(View(doctors)); }
/// <summary> /// Main BindingSource changed handler /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void vDoctorsBindingSource_CurrentChanged(object sender, EventArgs e) { if (IsBindingSourceLoading) { return; } int doctors_id = -1; if (vDoctorsBindingSource.Current != null) { doctors_id = (((DataRowView)vDoctorsBindingSource.Current).Row).Field <int>("doctors_id"); } doctors_lastloginDateTimePicker.Visible = false; doctors_lastloginLabel.Visible = false; if (doctors_id != -1) { doctors doctor = _dentnedModel.Doctors.Find(doctors_id); if (doctor.doctors_lastlogin != null) { doctors_lastloginDateTimePicker.Visible = true; doctors_lastloginLabel.Visible = true; } } }
public ActionResult DeleteConfirmed(int id) { doctors doctors = db.doctors.Find(id); db.doctors.Remove(doctors); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Create([Bind(Include = "id,FIO,phone,salary,date_start_work,date_end_work,position,qualification,address")] doctors doctors) { if (ModelState.IsValid) { db.doctors.Add(doctors); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(doctors)); }
public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } doctors doctors = db.doctors.Find(id); if (doctors == null) { return(HttpNotFound()); } return(View(doctors)); }
public ActionResult Edit([Bind(Include = "id,FIO,phone,salary,date_start_work,date_end_work,position,qualification,address")] doctors doctors) { if (User.IsInRole("manager") || User.IsInRole("director")) { ; } else if (User.IsInRole("doctor")) { var user = HttpContext.GetOwinContext().GetUserManager <ApplicationUserManager>().Users.FirstOrDefault(it => it.UserName == User.Identity.Name); int doctorId = DoctorsId.getDoctorId(user.Id); if (doctorId != doctors.id) { return(RedirectToAction("Index")); } } if (ModelState.IsValid) { db.Entry(doctors).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(doctors)); }
public void Rooms_Test2() { string[] errors = new string[] { }; patients t_patients = null; doctors t_doctors = null; rooms t_rooms = null; appointments t_appointments = null; t_patients = _dentnedModel.Patients.FirstOrDefault(r => r.patients_name == "XX1" && r.patients_surname == "XX1"); if (t_patients != null) { _dentnedModel.Appointments.Remove(_dentnedModel.Appointments.List(r => r.patients_id == t_patients.patients_id).ToArray()); } _dentnedModel.Patients.Remove(_dentnedModel.Patients.List(r => r.patients_name == "XX1" && r.patients_surname == "XX1").ToArray()); _dentnedModel.Doctors.Remove(_dentnedModel.Doctors.List(r => r.doctors_name == "XX1" && r.doctors_surname == "XX1").ToArray()); _dentnedModel.Rooms.Remove(_dentnedModel.Rooms.List(r => r.rooms_name == "XX1").ToArray()); t_patients = new patients() { patients_name = "XX1", patients_surname = "XX1", patients_birthdate = DateTime.Now, patients_birthcity = "xxx", patients_doctext = "xxx", patients_sex = "M", patients_username = "******", patients_password = "******" }; _dentnedModel.Patients.Add(t_patients); t_doctors = new doctors() { doctors_name = "XX1", doctors_surname = "XX1", doctors_doctext = "XXXXX", doctors_username = "******", doctors_password = "******" }; _dentnedModel.Doctors.Add(t_doctors); t_rooms = new rooms() { rooms_name = "XX1" }; _dentnedModel.Rooms.Add(t_rooms); t_appointments = new appointments() { patients_id = t_patients.patients_id, doctors_id = t_doctors.doctors_id, rooms_id = t_rooms.rooms_id, appointments_title = "xxx", appointments_from = DateTime.Now, appointments_to = DateTime.Now.AddMinutes(40) }; _dentnedModel.Appointments.Add(t_appointments); Assert.IsFalse(_dentnedModel.Rooms.CanRemove(_dentnedModel.Rooms.List(r => r.rooms_name == "XX1").ToArray())); t_patients = _dentnedModel.Patients.FirstOrDefault(r => r.patients_name == "XX1" && r.patients_surname == "XX1"); if (t_patients != null) { _dentnedModel.Appointments.Remove(_dentnedModel.Appointments.List(r => r.patients_id == t_patients.patients_id).ToArray()); } Assert.IsTrue(_dentnedModel.Rooms.CanRemove(_dentnedModel.Rooms.List(r => r.rooms_name == "XX1").ToArray())); _dentnedModel.Patients.Remove(_dentnedModel.Patients.List(r => r.patients_name == "XX1" && r.patients_surname == "XX1").ToArray()); _dentnedModel.Doctors.Remove(_dentnedModel.Doctors.List(r => r.doctors_name == "XX1" && r.doctors_surname == "XX1").ToArray()); _dentnedModel.Rooms.Remove(_dentnedModel.Rooms.List(r => r.rooms_name == "XX1").ToArray()); }
public void Estimates_Test2() { DateTime today = DateTime.Now; string[] errors = new string[] { }; estimates t_estimates = null; doctors t_doctors = null; patients t_patients = null; estimateslines t_estimateslines = null; treatments t_treatments = null; treatmentstypes t_treatmentstypes = null; patientstreatments t_patientstreatments = null; _dentnedModel.Estimates.Remove(_dentnedModel.Estimates.List(r => r.estimates_number == "XX1" && r.estimates_date == today.Date).ToArray()); _dentnedModel.Patients.Remove(_dentnedModel.Patients.List(r => r.patients_name == "XX1" && r.patients_surname == "XX1").ToArray()); _dentnedModel.Doctors.Remove(_dentnedModel.Doctors.List(r => r.doctors_name == "XX1" && r.doctors_surname == "XX1").ToArray()); _dentnedModel.Treatments.Remove(_dentnedModel.Treatments.List(r => r.treatments_code == "XX1").ToArray()); _dentnedModel.TreatmentsTypes.Remove(_dentnedModel.TreatmentsTypes.List(r => r.treatmentstypes_name == "XX1").ToArray()); t_doctors = new doctors() { doctors_name = "XX1", doctors_surname = "XX1", doctors_doctext = "XXXXX", doctors_username = "******", doctors_password = "******" }; _dentnedModel.Doctors.Add(t_doctors); t_patients = new patients() { patients_name = "XX1", patients_surname = "XX1", patients_birthdate = DateTime.Now, patients_birthcity = "xxx", patients_doctext = "xxx", patients_sex = "M", patients_username = "******", patients_password = "******" }; _dentnedModel.Patients.Add(t_patients); t_treatmentstypes = new treatmentstypes() { treatmentstypes_name = "XX1" }; _dentnedModel.TreatmentsTypes.Add(t_treatmentstypes); t_treatments = new treatments() { treatmentstypes_id = t_treatmentstypes.treatmentstypes_id, treatments_code = "XX1", treatments_name = "XX1", treatments_price = 10 }; _dentnedModel.Treatments.Add(t_treatments); t_patientstreatments = new patientstreatments() { doctors_id = t_doctors.doctors_id, patients_id = t_patients.patients_id, treatments_id = t_treatments.treatments_id, patientstreatments_creationdate = DateTime.Now, patientstreatments_price = 10 }; _dentnedModel.PatientsTreatments.Add(t_patientstreatments); t_estimates = new estimates() { estimates_date = today, estimates_number = "XX1", doctors_id = t_doctors.doctors_id, patients_id = t_patients.patients_id, estimates_doctor = "test", estimates_patient = "patient", estimates_footer = "footer", estimates_payment = "payment", estimates_totalnet = 0, estimates_totalgross = 0, estimates_totaldue = 0, estimates_deductiontaxrate = 20 }; _dentnedModel.Estimates.Add(t_estimates); t_estimateslines = new estimateslines() { estimates_id = t_estimates.estimates_id, estimateslines_code = "XXX", estimateslines_description = "test", estimateslines_quantity = 1, estimateslines_unitprice = 10, estimateslines_taxrate = 22, estimateslines_istaxesdeductionsable = true, patientstreatments_id = t_patientstreatments.patientstreatments_id }; _dentnedModel.EstimatesLines.Add(t_estimateslines); t_estimateslines = new estimateslines() { estimates_id = t_estimates.estimates_id, estimateslines_code = "XXY", estimateslines_description = "test", estimateslines_quantity = 2, estimateslines_unitprice = 12, estimateslines_taxrate = 22, estimateslines_istaxesdeductionsable = true, patientstreatments_id = t_patientstreatments.patientstreatments_id }; _dentnedModel.EstimatesLines.Add(t_estimateslines); t_estimates = _dentnedModel.Estimates.FirstOrDefault(r => r.estimates_number == "XX1" && r.estimates_date == today.Date); Assert.That(t_estimates.estimates_totalnet, Is.EqualTo(34)); t_estimateslines = new estimateslines() { estimates_id = t_estimates.estimates_id, estimateslines_code = "XXY", estimateslines_description = "test", estimateslines_quantity = 1, estimateslines_unitprice = -10, estimateslines_taxrate = 22, estimateslines_istaxesdeductionsable = true, patientstreatments_id = t_patientstreatments.patientstreatments_id }; _dentnedModel.EstimatesLines.Add(t_estimateslines); t_estimates = _dentnedModel.Estimates.FirstOrDefault(r => r.estimates_number == "XX1" && r.estimates_date == today.Date); Assert.That(t_estimates.estimates_totalnet, Is.EqualTo(24)); Assert.That(t_estimates.estimates_totalgross, Is.EqualTo(29.28)); Assert.That(t_estimates.estimates_totaldue, Is.EqualTo(24.48)); _dentnedModel.Estimates.Remove(_dentnedModel.Estimates.List(r => r.estimates_number == "XX1" && r.estimates_date == today.Date).ToArray()); _dentnedModel.Patients.Remove(_dentnedModel.Patients.List(r => r.patients_name == "XX1" && r.patients_surname == "XX1").ToArray()); _dentnedModel.Doctors.Remove(_dentnedModel.Doctors.List(r => r.doctors_name == "XX1" && r.doctors_surname == "XX1").ToArray()); _dentnedModel.Treatments.Remove(_dentnedModel.Treatments.List(r => r.treatments_code == "XX1").ToArray()); _dentnedModel.TreatmentsTypes.Remove(_dentnedModel.TreatmentsTypes.List(r => r.treatmentstypes_name == "XX1").ToArray()); }
public void Estimates_Test1() { DateTime today = DateTime.Now; string[] errors = new string[] { }; estimates t_estimates = null; doctors t_doctors = null; patients t_patients = null; _dentnedModel.Estimates.Remove(_dentnedModel.Estimates.List(r => r.estimates_number == "XX1" && r.estimates_date == today.Date).ToArray()); _dentnedModel.Estimates.Remove(_dentnedModel.Estimates.List(r => r.estimates_number == "XX2" && r.estimates_date == today.Date).ToArray()); _dentnedModel.Doctors.Remove(_dentnedModel.Doctors.List(r => r.doctors_name == "XX1" && r.doctors_surname == "XX1").ToArray()); _dentnedModel.Patients.Remove(_dentnedModel.Patients.List(r => r.patients_name == "XX1" && r.patients_surname == "XX1").ToArray()); t_doctors = new doctors() { doctors_name = "XX1", doctors_surname = "XX1", doctors_doctext = "XXXXX", doctors_username = "******", doctors_password = "******" }; _dentnedModel.Doctors.Add(t_doctors); t_patients = new patients() { patients_name = "XX1", patients_surname = "XX1", patients_birthdate = DateTime.Now, patients_birthcity = "xxx", patients_doctext = "xxx", patients_sex = "M", patients_username = "******", patients_password = "******" }; _dentnedModel.Patients.Add(t_patients); t_estimates = new estimates() { estimates_date = today, //estimates_number = "XX1", doctors_id = t_doctors.doctors_id, patients_id = t_patients.patients_id, estimates_doctor = "test", estimates_patient = "patient", estimates_footer = "footer", estimates_payment = "payment", estimates_totalnet = 0, estimates_totalgross = 0, estimates_totaldue = 0, estimates_deductiontaxrate = 0 }; Assert.IsFalse(_dentnedModel.Estimates.CanAdd(t_estimates)); t_estimates = new estimates() { estimates_date = today, estimates_number = "XX1", doctors_id = -999, patients_id = t_patients.patients_id, estimates_doctor = "test", estimates_patient = "patient", estimates_footer = "footer", estimates_payment = "payment", estimates_totalnet = 0, estimates_totalgross = 0, estimates_totaldue = 0, estimates_deductiontaxrate = 0 }; Assert.IsFalse(_dentnedModel.Estimates.CanAdd(t_estimates)); t_estimates = new estimates() { estimates_date = today, estimates_number = "XX1", doctors_id = t_doctors.doctors_id, patients_id = -999, estimates_doctor = "test", estimates_patient = "patient", estimates_footer = "footer", estimates_payment = "payment", estimates_totalnet = 0, estimates_totalgross = 0, estimates_totaldue = 0, estimates_deductiontaxrate = 0 }; Assert.IsFalse(_dentnedModel.Estimates.CanAdd(t_estimates)); t_estimates = new estimates() { estimates_date = today, estimates_number = "XX1", //doctors_id = t_doctors.doctors_id, patients_id = t_patients.patients_id, estimates_doctor = "test", estimates_patient = "patient", estimates_footer = "footer", estimates_payment = "payment", estimates_totalnet = 0, estimates_totalgross = 0, estimates_totaldue = 0, estimates_deductiontaxrate = 0 }; Assert.IsFalse(_dentnedModel.Estimates.CanAdd(t_estimates)); t_estimates = new estimates() { estimates_date = today, estimates_number = "XX1", doctors_id = t_doctors.doctors_id, //patients_id = t_patients.patients_id, estimates_doctor = "test", estimates_patient = "patient", estimates_footer = "footer", estimates_payment = "payment", estimates_totalnet = 0, estimates_totalgross = 0, estimates_totaldue = 0, estimates_deductiontaxrate = 0 }; Assert.IsFalse(_dentnedModel.Estimates.CanAdd(t_estimates)); t_estimates = new estimates() { estimates_date = today, estimates_number = "XX1", doctors_id = t_doctors.doctors_id, patients_id = t_patients.patients_id, //estimates_doctor = "test", estimates_patient = "patient", estimates_footer = "footer", estimates_payment = "payment", estimates_totalnet = 0, estimates_totalgross = 0, estimates_totaldue = 0, estimates_deductiontaxrate = 0 }; Assert.IsFalse(_dentnedModel.Estimates.CanAdd(t_estimates)); t_estimates = new estimates() { estimates_date = today, estimates_number = "XX1", doctors_id = t_doctors.doctors_id, patients_id = t_patients.patients_id, estimates_doctor = "test", //estimates_patient = "patient", estimates_footer = "footer", estimates_payment = "payment", estimates_totalnet = 0, estimates_totalgross = 0, estimates_totaldue = 0, estimates_deductiontaxrate = 0 }; Assert.IsFalse(_dentnedModel.Estimates.CanAdd(t_estimates)); t_estimates = new estimates() { estimates_date = today, estimates_number = "XX1", doctors_id = t_doctors.doctors_id, patients_id = t_patients.patients_id, estimates_doctor = "test", estimates_patient = "patient", estimates_footer = "footer", //estimates_payment = "payment", estimates_totalnet = 0, estimates_totalgross = 0, estimates_totaldue = 0, estimates_deductiontaxrate = 0 }; Assert.IsFalse(_dentnedModel.Estimates.CanAdd(t_estimates)); t_estimates = new estimates() { estimates_date = today, estimates_number = "XX1", doctors_id = t_doctors.doctors_id, patients_id = t_patients.patients_id, estimates_doctor = "test", estimates_patient = "patient", estimates_footer = "footer", estimates_payment = "payment", estimates_totalnet = -10, estimates_totalgross = 0, estimates_totaldue = 0, estimates_deductiontaxrate = 0 }; Assert.IsFalse(_dentnedModel.Estimates.CanAdd(t_estimates)); t_estimates = new estimates() { estimates_date = today, estimates_number = "XX1", doctors_id = t_doctors.doctors_id, patients_id = t_patients.patients_id, estimates_doctor = "test", estimates_patient = "patient", estimates_footer = "footer", estimates_payment = "payment", estimates_totalnet = 10, estimates_totalgross = 8, estimates_totaldue = 0, estimates_deductiontaxrate = 0 }; Assert.IsFalse(_dentnedModel.Estimates.CanAdd(t_estimates)); t_estimates = new estimates() { estimates_date = today, estimates_number = "XX1", doctors_id = t_doctors.doctors_id, patients_id = t_patients.patients_id, estimates_doctor = "test", estimates_patient = "patient", estimates_footer = "footer", estimates_payment = "payment", estimates_totalnet = 0, estimates_totalgross = 0, estimates_totaldue = 0, estimates_deductiontaxrate = 0 }; Assert.IsTrue(_dentnedModel.Estimates.CanAdd(t_estimates)); _dentnedModel.Estimates.Add(t_estimates); t_estimates = new estimates() { estimates_date = today.AddYears(1), estimates_number = "XX1", doctors_id = t_doctors.doctors_id, patients_id = t_patients.patients_id, estimates_doctor = "test", estimates_patient = "patient", estimates_footer = "footer", estimates_payment = "payment", estimates_totalnet = 0, estimates_totalgross = 0, estimates_totaldue = 0, estimates_deductiontaxrate = 0 }; Assert.IsTrue(_dentnedModel.Estimates.CanAdd(t_estimates)); t_estimates = new estimates() { estimates_date = today, estimates_number = "XX2", doctors_id = t_doctors.doctors_id, patients_id = t_patients.patients_id, estimates_doctor = "test", estimates_patient = "patient", estimates_footer = "footer", estimates_payment = "payment", estimates_totalnet = 0, estimates_totalgross = 0, estimates_totaldue = 0, estimates_deductiontaxrate = 0 }; Assert.IsTrue(_dentnedModel.Estimates.CanAdd(t_estimates)); _dentnedModel.Estimates.Add(t_estimates); t_estimates = _dentnedModel.Estimates.FirstOrDefault(r => r.estimates_number == "XX1" && r.estimates_date == today.Date); t_estimates.estimates_number = "XX2"; Assert.IsFalse(_dentnedModel.Estimates.CanUpdate(t_estimates)); t_estimates.estimates_number = "XX3"; Assert.IsTrue(_dentnedModel.Estimates.CanUpdate(t_estimates)); t_estimates = _dentnedModel.Estimates.FirstOrDefault(r => r.estimates_number == "XX1" && r.estimates_date == today.Date); t_estimates.doctors_id = -999; Assert.IsTrue(_dentnedModel.Estimates.CanUpdate(t_estimates)); _dentnedModel.Estimates.Remove(_dentnedModel.Estimates.List(r => r.estimates_number == "XX1" && r.estimates_date == today.Date).ToArray()); _dentnedModel.Estimates.Remove(_dentnedModel.Estimates.List(r => r.estimates_number == "XX2" && r.estimates_date == today.Date).ToArray()); _dentnedModel.Doctors.Remove(_dentnedModel.Doctors.List(r => r.doctors_name == "XX1" && r.doctors_surname == "XX1").ToArray()); _dentnedModel.Patients.Remove(_dentnedModel.Patients.List(r => r.patients_name == "XX1" && r.patients_surname == "XX1").ToArray()); }
public void PatientsTreatments_Test1() { string[] errors = new string[] { }; patients t_patients = null; doctors t_doctors = null; treatments t_treatments = null; treatmentstypes t_treatmentstypes = null; patientstreatments t_patientstreatments = null; _dentnedModel.Patients.Remove(_dentnedModel.Patients.List(r => r.patients_name == "XX1" && r.patients_surname == "XX1").ToArray()); _dentnedModel.Doctors.Remove(_dentnedModel.Doctors.List(r => r.doctors_name == "XX1" && r.doctors_surname == "XX1").ToArray()); _dentnedModel.Treatments.Remove(_dentnedModel.Treatments.List(r => r.treatments_code == "XX1").ToArray()); _dentnedModel.TreatmentsTypes.Remove(_dentnedModel.TreatmentsTypes.List(r => r.treatmentstypes_name == "XX1").ToArray()); t_patients = new patients() { patients_name = "XX1", patients_surname = "XX1", patients_birthdate = DateTime.Now, patients_birthcity = "xxx", patients_doctext = "xxx", patients_sex = "M", patients_username = "******", patients_password = "******" }; _dentnedModel.Patients.Add(t_patients); t_doctors = new doctors() { doctors_name = "XX1", doctors_surname = "XX1", doctors_doctext = "XXXXX", doctors_username = "******", doctors_password = "******" }; _dentnedModel.Doctors.Add(t_doctors); t_treatmentstypes = new treatmentstypes() { treatmentstypes_name = "XX1" }; _dentnedModel.TreatmentsTypes.Add(t_treatmentstypes); t_treatments = new treatments() { treatmentstypes_id = t_treatmentstypes.treatmentstypes_id, treatments_code = "XX1", treatments_name = "XX1", treatments_price = 10 }; _dentnedModel.Treatments.Add(t_treatments); t_patientstreatments = new patientstreatments() { //doctors_id = t_doctors.doctors_id, patients_id = t_patients.patients_id, treatments_id = t_treatments.treatments_id, patientstreatments_creationdate = DateTime.Now, patientstreatments_price = 10, patientstreatments_taxrate = 0, }; Assert.IsFalse(_dentnedModel.PatientsTreatments.CanAdd(t_patientstreatments)); t_patientstreatments = new patientstreatments() { doctors_id = t_doctors.doctors_id, //patients_id = t_patients.patients_id, treatments_id = t_treatments.treatments_id, patientstreatments_creationdate = DateTime.Now, patientstreatments_price = 10, patientstreatments_taxrate = 0, }; Assert.IsFalse(_dentnedModel.PatientsTreatments.CanAdd(t_patientstreatments)); t_patientstreatments = new patientstreatments() { doctors_id = t_doctors.doctors_id, patients_id = t_patients.patients_id, //treatments_id = t_treatments.treatments_id, patientstreatments_creationdate = DateTime.Now, patientstreatments_price = 10, patientstreatments_taxrate = 0, }; Assert.IsFalse(_dentnedModel.PatientsTreatments.CanAdd(t_patientstreatments)); t_patientstreatments = new patientstreatments() { doctors_id = t_doctors.doctors_id, patients_id = t_patients.patients_id, treatments_id = t_treatments.treatments_id, patientstreatments_creationdate = DateTime.Now, patientstreatments_price = 10, patientstreatments_taxrate = -10, }; Assert.IsFalse(_dentnedModel.PatientsTreatments.CanAdd(t_patientstreatments)); t_patientstreatments = new patientstreatments() { doctors_id = t_doctors.doctors_id, patients_id = t_patients.patients_id, treatments_id = t_treatments.treatments_id, patientstreatments_creationdate = DateTime.Now, patientstreatments_price = 10, patientstreatments_taxrate = 0, }; Assert.IsTrue(_dentnedModel.PatientsTreatments.CanAdd(t_patientstreatments)); _dentnedModel.PatientsTreatments.Add(t_patientstreatments); _dentnedModel.Patients.Remove(_dentnedModel.Patients.List(r => r.patients_name == "XX1" && r.patients_surname == "XX1").ToArray()); _dentnedModel.Doctors.Remove(_dentnedModel.Doctors.List(r => r.doctors_name == "XX1" && r.doctors_surname == "XX1").ToArray()); _dentnedModel.Treatments.Remove(_dentnedModel.Treatments.List(r => r.treatments_code == "XX1").ToArray()); _dentnedModel.TreatmentsTypes.Remove(_dentnedModel.TreatmentsTypes.List(r => r.treatmentstypes_name == "XX1").ToArray()); }
public void Appointments_Purge() { string[] errors = new string[] { }; patients t_patients = null; doctors t_doctors = null; rooms t_rooms = null; appointments t_appointments = null; t_patients = _dentnedModel.Patients.FirstOrDefault(r => r.patients_name == "XX1" && r.patients_surname == "XX1"); if (t_patients != null) { _dentnedModel.Appointments.Remove(_dentnedModel.Appointments.List(r => r.patients_id == t_patients.patients_id).ToArray()); } _dentnedModel.Patients.Remove(_dentnedModel.Patients.List(r => r.patients_name == "XX1" && r.patients_surname == "XX1").ToArray()); _dentnedModel.Doctors.Remove(_dentnedModel.Doctors.List(r => r.doctors_name == "XX1" && r.doctors_surname == "XX1").ToArray()); _dentnedModel.Rooms.Remove(_dentnedModel.Rooms.List(r => r.rooms_name == "XX1").ToArray()); //remove all appointments _dentnedModel.Appointments.Remove(_dentnedModel.Appointments.List().ToArray()); t_patients = new patients() { patients_name = "XX1", patients_surname = "XX1", patients_birthdate = DateTime.Now, patients_birthcity = "xxx", patients_doctext = "xxx", patients_sex = "M", patients_username = "******", patients_password = "******" }; _dentnedModel.Patients.Add(t_patients); t_doctors = new doctors() { doctors_name = "XX1", doctors_surname = "XX1", doctors_doctext = "XXXXX", doctors_username = "******", doctors_password = "******" }; _dentnedModel.Doctors.Add(t_doctors); t_rooms = new rooms() { rooms_name = "XX1" }; _dentnedModel.Rooms.Add(t_rooms); t_appointments = new appointments() { patients_id = t_patients.patients_id, doctors_id = t_doctors.doctors_id, rooms_id = t_rooms.rooms_id, appointments_title = "xxx", appointments_from = DateTime.Now, appointments_to = DateTime.Now.AddMinutes(40), appointments_color = "#dddddd" }; _dentnedModel.Appointments.Add(t_appointments); t_appointments = new appointments() { patients_id = t_patients.patients_id, doctors_id = t_doctors.doctors_id, rooms_id = t_rooms.rooms_id, appointments_title = "xxx", appointments_from = DateTime.Now.AddDays(-10), appointments_to = DateTime.Now.AddDays(-10).AddMinutes(40), appointments_color = "#dddddd" }; _dentnedModel.Appointments.Add(t_appointments); t_appointments = new appointments() { patients_id = t_patients.patients_id, doctors_id = t_doctors.doctors_id, rooms_id = t_rooms.rooms_id, appointments_title = "xxx", appointments_from = DateTime.Now.AddDays(-20), appointments_to = DateTime.Now.AddDays(-20).AddMinutes(40), appointments_color = "#dddddd" }; _dentnedModel.Appointments.Add(t_appointments); int purgedAppointments = 0; _dentnedModel.Appointments.Purge(0, ref purgedAppointments); Assert.That(purgedAppointments, Is.EqualTo(0)); _dentnedModel.Appointments.Purge(10, ref purgedAppointments); Assert.That(purgedAppointments, Is.EqualTo(0)); _dentnedModel.Appointments.Purge(-11, ref purgedAppointments); Assert.That(purgedAppointments, Is.EqualTo(1)); _dentnedModel.Appointments.Purge(-10, ref purgedAppointments); Assert.That(purgedAppointments, Is.EqualTo(1)); t_patients = _dentnedModel.Patients.FirstOrDefault(r => r.patients_name == "XX1" && r.patients_surname == "XX1"); if (t_patients != null) { _dentnedModel.Appointments.Remove(_dentnedModel.Appointments.List(r => r.patients_id == t_patients.patients_id).ToArray()); } _dentnedModel.Patients.Remove(_dentnedModel.Patients.List(r => r.patients_name == "XX1" && r.patients_surname == "XX1").ToArray()); _dentnedModel.Doctors.Remove(_dentnedModel.Doctors.List(r => r.doctors_name == "XX1" && r.doctors_surname == "XX1").ToArray()); _dentnedModel.Rooms.Remove(_dentnedModel.Rooms.List(r => r.rooms_name == "XX1").ToArray()); }
public void Populate() { int medicalrecordstypesNum = 10; int roomsNum = 3; int patientsattachmentstypesNum = 3; int treatmentstypesNum = 3; int treatmentspriceslistsNum = 2; int treatmentsNum = 100; bool generatedatafiles = true; DateTime now = DateTime.Now; Console.WriteLine("Add AddressesTypes..."); addressestypes addressestypesHome = new addressestypes() { addressestypes_name = "Home" }; _dentnedModel.AddressesTypes.Add(addressestypesHome); Console.WriteLine("Add ContactsTypes..."); contactstypes contactstypesEMail = new contactstypes() { contactstypes_name = ContactsTypesRepository.SystemAttributes.EMail.ToString(), }; _dentnedModel.ContactsTypes.Add(contactstypesEMail); contactstypes contactstypesMobile = new contactstypes() { contactstypes_name = "Telephone" }; _dentnedModel.ContactsTypes.Add(contactstypesMobile); Console.WriteLine("Add MedicalrecordsTypes..."); medicalrecordstypes[] medicalrecordstypes = new medicalrecordstypes[] { }; for (int i = 0; i < medicalrecordstypesNum; i++) { medicalrecordstypes medicalrecordstypestmp = new medicalrecordstypes() { medicalrecordstypes_name = "MedicalrecordsT " + (i + 1), }; _dentnedModel.MedicalrecordsTypes.Add(medicalrecordstypestmp); medicalrecordstypes = medicalrecordstypes.Concat(new medicalrecordstypes[] { medicalrecordstypestmp }).ToArray(); } Console.WriteLine("Add Taxes..."); taxes taxesT22 = new taxes() { taxes_name = "Tax 22%", taxes_rate = 22 }; _dentnedModel.Taxes.Add(taxesT22); taxes taxesT04 = new taxes() { taxes_name = "Tax 4%", taxes_rate = 4 }; _dentnedModel.Taxes.Add(taxesT04); Console.WriteLine("Add TaxesDeductions..."); taxesdeductions taxesdeductionsTD1 = new taxesdeductions() { taxesdeductions_name = "Ded Tax 01", taxesdeductions_rate = 20 }; _dentnedModel.TaxesDeductions.Add(taxesdeductionsTD1); Console.WriteLine("Add ComputedLines..."); _dentnedModel.ComputedLines.Add(new computedlines() { computedlines_code = "DS1", computedlines_name = "Discount 01", taxes_id = taxesT22.taxes_id, computedlines_rate = -10 }); _dentnedModel.ComputedLines.Add(new computedlines() { computedlines_code = "AD1", computedlines_name = "Addition 01", taxes_id = taxesT22.taxes_id, computedlines_rate = 20 }); Console.WriteLine("Add Doctors..."); doctors doctorsTest = new doctors() { doctors_name = "John", doctors_surname = "Doe", doctors_doctext = "Dr. John Doe\r\n123 Main Street\r\nTown, CA\r\nVAT 0123456789", doctors_username = "******", doctors_password = "******" }; _dentnedModel.Doctors.Add(doctorsTest); Console.WriteLine("Add Rooms..."); rooms[] rooms = new rooms[] { }; for (int i = 0; i < roomsNum; i++) { rooms roomstmp = new rooms() { rooms_name = "Room " + (i + 1), }; _dentnedModel.Rooms.Add(roomstmp); rooms = rooms.Concat(new rooms[] { roomstmp }).ToArray(); } Console.WriteLine("Add InvoicesFooters..."); invoicesfooters invoicesfooters01 = new invoicesfooters() { invoicesfooters_name = "Footer 01", invoicesfooters_doctext = "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat." }; _dentnedModel.InvoicesFooters.Add(invoicesfooters01); Console.WriteLine("Add EstimatesFooters..."); estimatesfooters estimatesfooters01 = new estimatesfooters() { estimatesfooters_name = "Footer 01", estimatesfooters_doctext = "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat." }; _dentnedModel.EstimatesFooters.Add(estimatesfooters01); Console.WriteLine("Add PaymentsTypes..."); paymentstypes paymentstypesCash = new paymentstypes() { paymentstypes_name = "Cash", paymentstypes_doctext = "Pay by cash" }; _dentnedModel.PaymentsTypes.Add(paymentstypesCash); Console.WriteLine("Add PatientsAttachmentsTypes..."); patientsattachmentstypes[] patientsattachmentstypes = new patientsattachmentstypes[] { }; for (int i = 0; i < patientsattachmentstypesNum; i++) { patientsattachmentstypes patientsattachmentstypestmp = new patientsattachmentstypes() { patientsattachmentstypes_name = "AttachmentsT " + (i + 1), patientsattachmentstypes_valueautofunc = PatientsAttachmentsTypesRepository.ValueAutoFuncCode.NUL.ToString() }; _dentnedModel.PatientsAttachmentsTypes.Add(patientsattachmentstypestmp); patientsattachmentstypes = patientsattachmentstypes.Concat(new patientsattachmentstypes[] { patientsattachmentstypestmp }).ToArray(); } Console.WriteLine("Add PatientsAttributesTypes..."); patientsattributestypes patientsattributestypesSendAppointmentsReminder = new patientsattributestypes() { patientsattributestypes_name = PatientsAttributesTypesRepository.SystemAttributes.SendAppointmentsReminder.ToString(), }; _dentnedModel.PatientsAttributesTypes.Add(patientsattributestypesSendAppointmentsReminder); patientsattributestypes patientsattributestypesAge = new patientsattributestypes() { patientsattributestypes_name = "Age", }; _dentnedModel.PatientsAttributesTypes.Add(patientsattributestypesAge); Console.WriteLine("Add TreatmentsTypes..."); treatmentstypes[] treatmentstypes = new treatmentstypes[] { }; for (int i = 0; i < treatmentstypesNum; i++) { treatmentstypes treatmentstypestmp = new treatmentstypes() { treatmentstypes_name = "TreatmentsT " + (i + 1), }; _dentnedModel.TreatmentsTypes.Add(treatmentstypestmp); treatmentstypes = treatmentstypes.Concat(new treatmentstypes[] { treatmentstypestmp }).ToArray(); } Console.WriteLine("Add TreatmentsPricesLists..."); treatmentspriceslists[] treatmentspriceslists = new treatmentspriceslists[] { }; for (int i = 0; i < treatmentspriceslistsNum; i++) { treatmentspriceslists treatmentspricesliststmp = new treatmentspriceslists() { treatmentspriceslists_name = "TreatmentsT " + (i + 1), treatmentspriceslists_multiplier = (decimal)(_r.NextDouble() * (2 - 1) + 1) }; _dentnedModel.TreatmentsPricesLists.Add(treatmentspricesliststmp); treatmentspriceslists = treatmentspriceslists.Concat(new treatmentspriceslists[] { treatmentspricesliststmp }).ToArray(); } Console.WriteLine("Add Treatments..."); treatments[] treatments = new treatments[] { }; for (int i = 0; i < treatmentsNum; i++) { treatments treatmentstmp = new treatments() { treatmentstypes_id = treatmentstypes[_r.Next(treatmentstypes.Count())].treatmentstypes_id, treatments_code = (i + 1).ToString().PadLeft(3, '0'), treatments_name = "Treatments " + (i + 1).ToString().PadLeft(3, '0'), treatments_mexpiration = (_r.Next(0, 100) >= 80 ? (Nullable <byte>)_r.Next(1, 12) : null), treatments_price = (decimal)(_r.NextDouble() * (300 - 1) + 300), taxes_id = taxesT22.taxes_id, treatments_isunitprice = (_r.Next(0, 100) >= 50 ? true : false) }; _dentnedModel.Treatments.Add(treatmentstmp); treatments = treatments.Concat(new treatments[] { treatmentstmp }).ToArray(); } Console.WriteLine("Add TreatmentsPrices..."); treatmentsprices[] treatmentsprices = new treatmentsprices[] { }; foreach (treatments treatment in treatments) { if (_r.Next(0, 100) >= 30) { treatmentspriceslists treatmentspriceslist = treatmentspriceslists[_r.Next(treatmentspriceslists.Count())]; treatmentsprices treatmentspricestmp = new treatmentsprices() { treatments_id = treatment.treatments_id, treatmentspriceslists_id = treatmentspriceslist.treatmentspriceslists_id, treatmentsprices_price = treatment.treatments_price + treatment.treatments_price * treatmentspriceslist.treatmentspriceslists_multiplier }; _dentnedModel.TreatmentsPrices.Add(treatmentspricestmp); treatmentsprices = treatmentsprices.Concat(new treatmentsprices[] { treatmentspricestmp }).ToArray(); } } Console.WriteLine("Add Patients..."); patients[] patients = new patients[] { }; for (int i = 0; i < _patientsNum; i++) { patients patientstmp = new patients() { patients_name = "Name " + (i + 1).ToString(), patients_surname = "Surname " + (i + 1).ToString(), patients_birthdate = GetRandomDate(new DateTime(1950, 1, 1), new DateTime(2010, 12, 31)), patients_birthcity = BuildRandomString(_r.Next(5, 20)), patients_doctext = "Name " + (i + 1).ToString() + " " + "Surname " + (i + 1).ToString() + "\r\n" + "Street " + BuildRandomString(_r.Next(5, 30)) + ", " + _r.Next(1, 100) + "\r\n" + BuildRandomString(_r.Next(5, 20)) + (_r.Next(0, 100) > 50 ? "\r\n" + "VAT " + BuildRandomString(10) : ""), patients_sex = (_r.Next(0, 100) > 50 ? "M" : "F"), patients_username = (i + 1).ToString().PadLeft(8, '0'), patients_password = (i + 1).ToString().PadLeft(6, '0'), patients_isarchived = (_r.Next(0, 100) > 5 ? false : true), treatmentspriceslists_id = (_r.Next(0, 100) > 20 ? (Nullable <int>)treatmentspriceslists[_r.Next(treatmentspriceslists.Count())].treatmentspriceslists_id : null) }; _dentnedModel.Patients.Add(patientstmp); patients = patients.Concat(new patients[] { patientstmp }).ToArray(); if (generatedatafiles) { if (_r.Next(0, 100) > 50) { if (!Directory.Exists(_patientsDatadir + "\\" + patientstmp.patients_id)) { Directory.CreateDirectory(_patientsDatadir + "\\" + patientstmp.patients_id); } GenerateImage(_patientsDatadir + "\\" + patientstmp.patients_id + "\\" + BuildRandomString(12) + ".png"); } } } Console.WriteLine("Add PatientsAddresses..."); foreach (patients patient in patients) { do { _dentnedModel.PatientsAddresses.Add(new patientsaddresses() { patients_id = patient.patients_id, addressestypes_id = addressestypesHome.addressestypes_id, patientsaddresses_state = BuildRandomString(2), patientsaddresses_city = BuildRandomString(_r.Next(5, 10)), patientsaddresses_street = BuildRandomString(_r.Next(5, 30)), patientsaddresses_zipcode = _r.Next(1, 99999).ToString().PadLeft(5, '0') }); } while (_r.Next(0, 100) > 80); } Console.WriteLine("Add PatientsAttributes..."); foreach (patients patient in patients) { do { _dentnedModel.PatientsAttributes.Add(new patientsattributes() { patients_id = patient.patients_id, patientsattributestypes_id = patientsattributestypesAge.patientsattributestypes_id, patientsattributes_value = _r.Next(10, 100).ToString() }); } while (_r.Next(0, 100) > 80); } Console.WriteLine("Add PatientsContacts..."); foreach (patients patient in patients) { do { _dentnedModel.PatientsContacts.Add(new patientscontacts() { patients_id = patient.patients_id, contactstypes_id = contactstypesMobile.contactstypes_id, patientscontacts_value = _r.Next(1, 999).ToString().PadLeft(3, '0') + "/" + _r.Next(1, 999).ToString().PadLeft(3, '0') + _r.Next(1, 999).ToString().PadLeft(3, '0') }); } while (_r.Next(0, 100) > 80); } Console.WriteLine("Add PatientsMedicalrecords..."); foreach (patients patient in patients) { do { _dentnedModel.PatientsMedicalrecords.Add(new patientsmedicalrecords() { patients_id = patient.patients_id, medicalrecordstypes_id = medicalrecordstypes[_r.Next(medicalrecordstypes.Count())].medicalrecordstypes_id, patientsmedicalrecords_value = BuildRandomString(_r.Next(10, 50)) }); } while (_r.Next(0, 100) > 50); } Console.WriteLine("Add PatientsNotes..."); foreach (patients patient in patients) { if (_r.Next(0, 100) > 50) { do { _dentnedModel.PatientsNotes.Add(new patientsnotes() { patients_id = patient.patients_id, patientsnotes_date = GetRandomDate(new DateTime(now.AddYears(-1).Year, 1, 1), now), patientsnotes_text = BuildRandomString(_r.Next(10, 200)) }); } while (_r.Next(0, 100) > 50); } } Console.WriteLine("Add PatientsAttachments..."); foreach (patients patient in patients) { if (_r.Next(0, 100) > 50) { do { string filename = null; if (generatedatafiles) { if (_r.Next(0, 100) > 50) { filename = BuildRandomString(12) + ".png"; if (!Directory.Exists(_patientsAttachmentsdir + "\\" + patient.patients_id)) { Directory.CreateDirectory(_patientsAttachmentsdir + "\\" + patient.patients_id); } GenerateImage(_patientsAttachmentsdir + "\\" + patient.patients_id + "\\" + filename); } } _dentnedModel.PatientsAttachments.Add(new patientsattachments() { patients_id = patient.patients_id, patientsattachmentstypes_id = patientsattachmentstypes[_r.Next(patientsattachmentstypes.Count())].patientsattachmentstypes_id, patientsattachments_value = BuildRandomString(_r.Next(10, 50)), patientsattachments_date = GetRandomDate(new DateTime(now.AddYears(-1).Year, 1, 1), now), patientsattachments_filename = filename }); } while (_r.Next(0, 100) > 50); } } Console.WriteLine("Add Appointments..."); foreach (patients patient in patients) { do { DateTime from = GetRandomDate(new DateTime(now.AddYears(-1).Year, 1, 1), now); from = new DateTime(from.Year, from.Month, from.Day, _r.Next(8, 19), (_r.Next(0, 100) > 50 ? 0 : 30), 0); DateTime to = (_r.Next(0, 100) > 50 ? from.AddMinutes(30) : from.AddHours(_r.Next(1, 2))); _dentnedModel.Appointments.Add(new appointments() { patients_id = patient.patients_id, doctors_id = doctorsTest.doctors_id, rooms_id = rooms[_r.Next(rooms.Count())].rooms_id, appointments_title = BuildRandomString(_r.Next(5, 25)), appointments_from = from, appointments_to = to }); } while (_r.Next(0, 100) > 3); } Console.WriteLine("Add PatientsTreatments..."); foreach (patients patient in patients) { do { treatments treatment = treatments[_r.Next(treatments.Count())]; DateTime creationdate = GetRandomDate(new DateTime(now.AddYears(-1).Year, 1, 1), now); _dentnedModel.PatientsTreatments.Add(new patientstreatments() { doctors_id = doctorsTest.doctors_id, patients_id = patient.patients_id, treatments_id = treatment.treatments_id, patientstreatments_id = treatment.treatments_id, patientstreatments_creationdate = creationdate, patientstreatments_price = treatment.treatments_price, patientstreatments_taxrate = taxesT22.taxes_rate, patientstreatments_description = treatment.treatments_code + " " + treatment.treatments_name, patientstreatments_notes = (_r.Next(0, 100) > 50 ? BuildRandomString(50) : null), patientstreatments_fulfilldate = (_r.Next(0, 100) > 50 ? (Nullable <DateTime>)creationdate.AddDays(_r.Next(0, 10)) : null), patientstreatments_expirationdate = (treatment.treatments_mexpiration != null ? (Nullable <DateTime>)creationdate.AddMonths((byte)treatment.treatments_mexpiration) : null), patientstreatments_ispaid = (_r.Next(0, 100) > 20 ? true : false), patientstreatments_isunitprice = treatment.treatments_isunitprice, patientstreatments_t11 = (_r.Next(0, 100) > 90 ? true : false), patientstreatments_t12 = (_r.Next(0, 100) > 90 ? true : false), patientstreatments_t13 = (_r.Next(0, 100) > 90 ? true : false), patientstreatments_t14 = (_r.Next(0, 100) > 90 ? true : false), patientstreatments_t15 = (_r.Next(0, 100) > 90 ? true : false), patientstreatments_t16 = (_r.Next(0, 100) > 90 ? true : false), patientstreatments_t17 = (_r.Next(0, 100) > 90 ? true : false), patientstreatments_t18 = (_r.Next(0, 100) > 90 ? true : false), patientstreatments_t21 = (_r.Next(0, 100) > 90 ? true : false), patientstreatments_t22 = (_r.Next(0, 100) > 90 ? true : false), patientstreatments_t23 = (_r.Next(0, 100) > 90 ? true : false), patientstreatments_t24 = (_r.Next(0, 100) > 90 ? true : false), patientstreatments_t25 = (_r.Next(0, 100) > 90 ? true : false), patientstreatments_t26 = (_r.Next(0, 100) > 90 ? true : false), patientstreatments_t27 = (_r.Next(0, 100) > 90 ? true : false), patientstreatments_t28 = (_r.Next(0, 100) > 90 ? true : false), patientstreatments_t31 = (_r.Next(0, 100) > 90 ? true : false), patientstreatments_t32 = (_r.Next(0, 100) > 90 ? true : false), patientstreatments_t33 = (_r.Next(0, 100) > 90 ? true : false), patientstreatments_t34 = (_r.Next(0, 100) > 90 ? true : false), patientstreatments_t35 = (_r.Next(0, 100) > 90 ? true : false), patientstreatments_t36 = (_r.Next(0, 100) > 90 ? true : false), patientstreatments_t37 = (_r.Next(0, 100) > 90 ? true : false), patientstreatments_t38 = (_r.Next(0, 100) > 90 ? true : false), patientstreatments_t41 = (_r.Next(0, 100) > 90 ? true : false), patientstreatments_t42 = (_r.Next(0, 100) > 90 ? true : false), patientstreatments_t43 = (_r.Next(0, 100) > 90 ? true : false), patientstreatments_t44 = (_r.Next(0, 100) > 90 ? true : false), patientstreatments_t45 = (_r.Next(0, 100) > 90 ? true : false), patientstreatments_t46 = (_r.Next(0, 100) > 90 ? true : false), patientstreatments_t47 = (_r.Next(0, 100) > 90 ? true : false), patientstreatments_t48 = (_r.Next(0, 100) > 90 ? true : false) }); } while (_r.Next(0, 100) > 30); } Console.WriteLine("Add Payments..."); foreach (patientstreatments patientstreatment in _dentnedModel.PatientsTreatments.List()) { if (patientstreatment.patientstreatments_fulfilldate != null) { if (_r.Next(0, 100) > 20) { int quantity = 1; if (patientstreatment.patientstreatments_isunitprice) { quantity = _dentnedModel.PatientsTreatments.GetNumberOfTooths(patientstreatment); if (quantity == 0) { quantity = 1; } } _dentnedModel.Payments.Add(new payments() { payments_amount = quantity * (patientstreatment.patientstreatments_price + (patientstreatment.patientstreatments_price * patientstreatment.patientstreatments_taxrate / 100)) + (_r.Next(0, 100) > 50 ? (decimal)(_r.NextDouble() * 2) : 0), payments_date = ((DateTime)patientstreatment.patientstreatments_fulfilldate).AddDays(_r.Next(1, 30)), patients_id = patientstreatment.patients_id }); } } } Console.WriteLine("Add Estimates and EstimatesLines..."); foreach (patients patient in patients) { do { DateTime date = GetRandomDate(new DateTime(now.AddYears(-1).Year, 1, 1), now); estimates estimate = new estimates() { estimates_date = date, estimates_number = (_dentnedModel.Estimates.List(r => r.estimates_date.Year == date.Year).Count + 1).ToString(), doctors_id = doctorsTest.doctors_id, patients_id = patient.patients_id, estimates_doctor = doctorsTest.doctors_doctext, estimates_patient = patient.patients_doctext, estimates_footer = estimatesfooters01.estimatesfooters_doctext, estimates_payment = paymentstypesCash.paymentstypes_doctext, estimates_totalnet = 0, estimates_totalgross = 0, estimates_totaldue = 0, estimates_deductiontaxrate = ((_r.Next(0, 100) > 50) ? taxesdeductionsTD1.taxesdeductions_rate : 0) }; _dentnedModel.Estimates.Add(estimate); do { treatments treatment = null; patientstreatments patientstreatment = null; int quantity = _r.Next(1, 3); if (_r.Next(0, 100) > 80) { patientstreatment = _dentnedModel.PatientsTreatments.FirstOrDefault(r => r.patients_id == patient.patients_id); if (patientstreatment != null) { treatment = _dentnedModel.Treatments.Find(patientstreatment.treatments_id); if (patientstreatment.patientstreatments_isunitprice) { quantity = _dentnedModel.PatientsTreatments.GetNumberOfTooths(patientstreatment); if (quantity == 0) { quantity = 1; } } } } if (treatment == null) { treatment = treatments[_r.Next(treatments.Count())]; } _dentnedModel.EstimatesLines.Add(new estimateslines() { estimates_id = estimate.estimates_id, estimateslines_code = treatment.treatments_code, estimateslines_description = treatment.treatments_code + " " + treatment.treatments_name, estimateslines_quantity = quantity, estimateslines_unitprice = treatment.treatments_price, estimateslines_taxrate = (_r.Next(0, 100) > 50 ? 0 : (_r.Next(0, 100) > 50 ? taxesT22.taxes_rate : taxesT04.taxes_rate)), estimateslines_istaxesdeductionsable = true, patientstreatments_id = (patientstreatment != null ? (Nullable <int>)patientstreatment.patientstreatments_id : null), }); } while (_r.Next(0, 100) > 30); } while (_r.Next(0, 100) > 30); } Console.WriteLine("Add Invoices and InvoicesLines..."); foreach (patients patient in patients) { do { DateTime date = GetRandomDate(new DateTime(now.AddYears(-1).Year, 1, 1), now); invoices invoice = new invoices() { invoices_date = date, invoices_number = (_dentnedModel.Invoices.List(r => r.invoices_date.Year == date.Year).Count + 1).ToString(), doctors_id = doctorsTest.doctors_id, patients_id = patient.patients_id, invoices_doctor = doctorsTest.doctors_doctext, invoices_patient = patient.patients_doctext, invoices_footer = invoicesfooters01.invoicesfooters_doctext, invoices_payment = paymentstypesCash.paymentstypes_doctext, invoices_totalnet = 0, invoices_totalgross = 0, invoices_totaldue = 0, invoices_deductiontaxrate = ((_r.Next(0, 100) > 50) ? taxesdeductionsTD1.taxesdeductions_rate : 0), invoices_ispaid = ((_r.Next(0, 100) > 20) ? false : true) }; _dentnedModel.Invoices.Add(invoice); do { treatments treatment = null; patientstreatments patientstreatment = null; int quantity = _r.Next(1, 3); if (_r.Next(0, 100) > 80) { patientstreatment = _dentnedModel.PatientsTreatments.FirstOrDefault(r => r.patients_id == patient.patients_id); if (patientstreatment != null) { if (patientstreatment.patientstreatments_isunitprice) { quantity = _dentnedModel.PatientsTreatments.GetNumberOfTooths(patientstreatment); if (quantity == 0) { quantity = 1; } } treatment = _dentnedModel.Treatments.Find(patientstreatment.treatments_id); } } if (treatment == null) { treatment = treatments[_r.Next(treatments.Count())]; } _dentnedModel.InvoicesLines.Add(new invoiceslines() { invoices_id = invoice.invoices_id, invoiceslines_code = treatment.treatments_code, invoiceslines_description = treatment.treatments_code + " " + treatment.treatments_name, invoiceslines_quantity = quantity, invoiceslines_unitprice = treatment.treatments_price, invoiceslines_taxrate = (_r.Next(0, 100) > 50 ? 0 : (_r.Next(0, 100) > 50 ? taxesT22.taxes_rate : taxesT04.taxes_rate)), invoiceslines_istaxesdeductionsable = true, patientstreatments_id = (patientstreatment != null ? (Nullable <int>)patientstreatment.patientstreatments_id : null), }); } while (_r.Next(0, 100) > 30); } while (_r.Next(0, 100) > 30); } }
public void Doctors_Test1() { string[] errors = new string[] { }; doctors t_doctors = null; _dentnedModel.Doctors.Remove(_dentnedModel.Doctors.List(r => r.doctors_name == "XX1" && r.doctors_surname == "XX1").ToArray()); _dentnedModel.Doctors.Remove(_dentnedModel.Doctors.List(r => r.doctors_name == "XX2" && r.doctors_surname == "XX2").ToArray()); t_doctors = new doctors() { //doctors_name = "XX1", doctors_surname = "XX1", doctors_doctext = "XXXXX", doctors_username = "******", doctors_password = "******" }; Assert.IsFalse(_dentnedModel.Doctors.CanAdd(t_doctors)); t_doctors = new doctors() { doctors_name = "XX1", //doctors_surname = "XX1", doctors_doctext = "XXXXX", doctors_username = "******", doctors_password = "******" }; Assert.IsFalse(_dentnedModel.Doctors.CanAdd(t_doctors)); t_doctors = new doctors() { doctors_name = "XX1", doctors_surname = "XX1", //doctors_doctext = "XXXXX", doctors_username = "******", doctors_password = "******" }; Assert.IsFalse(_dentnedModel.Doctors.CanAdd(t_doctors)); t_doctors = new doctors() { doctors_name = "XX1", doctors_surname = "XX1", doctors_doctext = "XXXXX", //doctors_username = "******", doctors_password = "******" }; Assert.IsFalse(_dentnedModel.Doctors.CanAdd(t_doctors)); t_doctors = new doctors() { doctors_name = "XX1", doctors_surname = "XX1", doctors_doctext = "XXXXX", doctors_username = "******", //doctors_password = "******" }; Assert.IsFalse(_dentnedModel.Doctors.CanAdd(t_doctors)); t_doctors = new doctors() { doctors_name = "XX1", doctors_surname = "XX1", doctors_doctext = "XXXXX", doctors_username = "******", doctors_password = "******" }; Assert.IsFalse(_dentnedModel.Doctors.CanAdd(t_doctors)); t_doctors = new doctors() { doctors_name = "XX1", doctors_surname = "XX1", doctors_doctext = "XXXXX", doctors_username = "******", doctors_password = "******" }; Assert.IsFalse(_dentnedModel.Doctors.CanAdd(t_doctors)); t_doctors = new doctors() { doctors_name = "XX1", doctors_surname = "XX1", doctors_doctext = "XXXXX", doctors_username = "******", doctors_password = "******" }; Assert.IsTrue(_dentnedModel.Doctors.CanAdd(t_doctors)); _dentnedModel.Doctors.Add(t_doctors); t_doctors = new doctors() { doctors_name = "XX1", doctors_surname = "XX1", doctors_doctext = "XXXXX", doctors_username = "******", doctors_password = "******" }; Assert.IsFalse(_dentnedModel.Doctors.CanAdd(t_doctors)); t_doctors = new doctors() { doctors_name = "XX2", doctors_surname = "XX1", doctors_doctext = "XXXXX", doctors_username = "******", doctors_password = "******" }; Assert.IsFalse(_dentnedModel.Doctors.CanAdd(t_doctors)); t_doctors = new doctors() { doctors_name = "XX2", doctors_surname = "XX1", doctors_doctext = "XXXXX", doctors_username = "******", doctors_password = "******" }; Assert.IsTrue(_dentnedModel.Doctors.CanAdd(t_doctors)); t_doctors = new doctors() { doctors_name = "XX2", doctors_surname = "XX2", doctors_doctext = "XXXXX", doctors_username = "******", doctors_password = "******" }; _dentnedModel.Doctors.Add(t_doctors); t_doctors = _dentnedModel.Doctors.FirstOrDefault(r => r.doctors_name == "XX1" && r.doctors_surname == "XX1"); t_doctors.doctors_name = "XX2"; t_doctors.doctors_surname = "XX2"; Assert.IsFalse(_dentnedModel.Doctors.CanUpdate(t_doctors)); t_doctors.doctors_name = "XX3"; t_doctors.doctors_surname = "XX3"; Assert.IsTrue(_dentnedModel.Doctors.CanUpdate(t_doctors)); _dentnedModel.Doctors.Remove(_dentnedModel.Doctors.List(r => r.doctors_name == "XX1" && r.doctors_surname == "XX1").ToArray()); _dentnedModel.Doctors.Remove(_dentnedModel.Doctors.List(r => r.doctors_name == "XX2" && r.doctors_surname == "XX2").ToArray()); }
public void InvoicesLines_Test1() { DateTime today = DateTime.Now; string[] errors = new string[] { }; invoices t_invoices = null; doctors t_doctors = null; patients t_patients = null; invoiceslines t_invoiceslines = null; treatments t_treatments = null; treatmentstypes t_treatmentstypes = null; patientstreatments t_patientstreatments = null; _dentnedModel.Invoices.Remove(_dentnedModel.Invoices.List(r => r.invoices_number == "XX1" && r.invoices_date == today.Date).ToArray()); _dentnedModel.Patients.Remove(_dentnedModel.Patients.List(r => r.patients_name == "XX1" && r.patients_surname == "XX1").ToArray()); _dentnedModel.Doctors.Remove(_dentnedModel.Doctors.List(r => r.doctors_name == "XX1" && r.doctors_surname == "XX1").ToArray()); _dentnedModel.Treatments.Remove(_dentnedModel.Treatments.List(r => r.treatments_code == "XX1").ToArray()); _dentnedModel.TreatmentsTypes.Remove(_dentnedModel.TreatmentsTypes.List(r => r.treatmentstypes_name == "XX1").ToArray()); t_doctors = new doctors() { doctors_name = "XX1", doctors_surname = "XX1", doctors_doctext = "XXXXX", doctors_username = "******", doctors_password = "******" }; _dentnedModel.Doctors.Add(t_doctors); t_patients = new patients() { patients_name = "XX1", patients_surname = "XX1", patients_birthdate = DateTime.Now, patients_birthcity = "xxx", patients_doctext = "xxx", patients_sex = "M", patients_username = "******", patients_password = "******" }; _dentnedModel.Patients.Add(t_patients); t_treatmentstypes = new treatmentstypes() { treatmentstypes_name = "XX1" }; _dentnedModel.TreatmentsTypes.Add(t_treatmentstypes); t_treatments = new treatments() { treatmentstypes_id = t_treatmentstypes.treatmentstypes_id, treatments_code = "XX1", treatments_name = "XX1", treatments_price = 10 }; _dentnedModel.Treatments.Add(t_treatments); t_patientstreatments = new patientstreatments() { doctors_id = t_doctors.doctors_id, patients_id = t_patients.patients_id, treatments_id = t_treatments.treatments_id, patientstreatments_creationdate = DateTime.Now, patientstreatments_price = 10 }; _dentnedModel.PatientsTreatments.Add(t_patientstreatments); t_invoices = new invoices() { invoices_date = today, invoices_number = "XX1", doctors_id = t_doctors.doctors_id, patients_id = t_patients.patients_id, invoices_doctor = "test", invoices_patient = "patient", invoices_footer = "footer", invoices_payment = "payment", invoices_totalnet = 0, invoices_totalgross = 0, invoices_totaldue = 0, invoices_deductiontaxrate = 20 }; _dentnedModel.Invoices.Add(t_invoices); t_invoiceslines = new invoiceslines() { invoices_id = t_invoices.invoices_id, invoiceslines_code = "XXX", invoiceslines_description = "test", invoiceslines_quantity = 1, invoiceslines_unitprice = 10, invoiceslines_taxrate = 22, invoiceslines_istaxesdeductionsable = true, patientstreatments_id = t_patientstreatments.patientstreatments_id }; Assert.IsTrue(_dentnedModel.InvoicesLines.CanAdd(t_invoiceslines)); t_invoiceslines = new invoiceslines() { //invoices_id = t_invoices.invoices_id, invoiceslines_code = "XXX", invoiceslines_description = "test", invoiceslines_quantity = 1, invoiceslines_unitprice = 10, invoiceslines_taxrate = 22, invoiceslines_istaxesdeductionsable = true, patientstreatments_id = t_patientstreatments.patientstreatments_id }; Assert.IsFalse(_dentnedModel.InvoicesLines.CanAdd(t_invoiceslines)); t_invoiceslines = new invoiceslines() { invoices_id = t_invoices.invoices_id, //invoiceslines_code = "XXX", invoiceslines_description = "test", invoiceslines_quantity = 1, invoiceslines_unitprice = 10, invoiceslines_taxrate = 22, invoiceslines_istaxesdeductionsable = true, patientstreatments_id = t_patientstreatments.patientstreatments_id }; Assert.IsFalse(_dentnedModel.InvoicesLines.CanAdd(t_invoiceslines)); t_invoiceslines = new invoiceslines() { invoices_id = t_invoices.invoices_id, invoiceslines_code = "XXX", //invoiceslines_description = "test", invoiceslines_quantity = 1, invoiceslines_unitprice = 10, invoiceslines_taxrate = 22, invoiceslines_istaxesdeductionsable = true, patientstreatments_id = t_patientstreatments.patientstreatments_id }; Assert.IsFalse(_dentnedModel.InvoicesLines.CanAdd(t_invoiceslines)); t_invoiceslines = new invoiceslines() { invoices_id = t_invoices.invoices_id, invoiceslines_code = "XXX", invoiceslines_description = "test", invoiceslines_quantity = -1, invoiceslines_unitprice = 10, invoiceslines_taxrate = 22, invoiceslines_istaxesdeductionsable = true, patientstreatments_id = t_patientstreatments.patientstreatments_id }; Assert.IsFalse(_dentnedModel.InvoicesLines.CanAdd(t_invoiceslines)); t_invoiceslines = new invoiceslines() { invoices_id = t_invoices.invoices_id, invoiceslines_code = "XXX", invoiceslines_description = "test", invoiceslines_quantity = 1, invoiceslines_unitprice = 10, invoiceslines_taxrate = 22, invoiceslines_istaxesdeductionsable = true, patientstreatments_id = -999 }; Assert.IsFalse(_dentnedModel.InvoicesLines.CanAdd(t_invoiceslines)); t_invoiceslines = new invoiceslines() { invoices_id = t_invoices.invoices_id, invoiceslines_code = "XXX", invoiceslines_description = "test", invoiceslines_quantity = 1, invoiceslines_unitprice = 10, invoiceslines_taxrate = 22, invoiceslines_istaxesdeductionsable = true, //patientstreatments_id = t_patientstreatments.patientstreatments_id }; Assert.IsTrue(_dentnedModel.InvoicesLines.CanAdd(t_invoiceslines)); t_invoiceslines = new invoiceslines() { invoices_id = t_invoices.invoices_id, invoiceslines_code = "XXX", invoiceslines_description = "test", invoiceslines_quantity = 1, invoiceslines_unitprice = 10, invoiceslines_taxrate = 22, invoiceslines_istaxesdeductionsable = true, patientstreatments_id = t_patientstreatments.patientstreatments_id }; Assert.IsTrue(_dentnedModel.InvoicesLines.CanAdd(t_invoiceslines)); _dentnedModel.InvoicesLines.Add(t_invoiceslines); t_invoiceslines = new invoiceslines() { invoices_id = t_invoices.invoices_id, invoiceslines_code = "XXY", invoiceslines_description = "test", invoiceslines_quantity = 2, invoiceslines_unitprice = 12, invoiceslines_taxrate = 22, invoiceslines_istaxesdeductionsable = true, patientstreatments_id = t_patientstreatments.patientstreatments_id }; Assert.IsTrue(_dentnedModel.InvoicesLines.CanAdd(t_invoiceslines)); _dentnedModel.InvoicesLines.Add(t_invoiceslines); t_invoiceslines = new invoiceslines() { invoices_id = t_invoices.invoices_id, invoiceslines_code = "XXY", invoiceslines_description = "test", invoiceslines_quantity = 1, invoiceslines_unitprice = -10, invoiceslines_taxrate = 22, invoiceslines_istaxesdeductionsable = true, patientstreatments_id = t_patientstreatments.patientstreatments_id }; Assert.IsTrue(_dentnedModel.InvoicesLines.CanAdd(t_invoiceslines)); _dentnedModel.InvoicesLines.Add(t_invoiceslines); t_invoiceslines = new invoiceslines() { invoices_id = t_invoices.invoices_id, invoiceslines_code = "XXY", invoiceslines_description = "test", invoiceslines_quantity = 1, invoiceslines_unitprice = -25, invoiceslines_taxrate = 22, invoiceslines_istaxesdeductionsable = true, patientstreatments_id = t_patientstreatments.patientstreatments_id }; Assert.IsFalse(_dentnedModel.InvoicesLines.CanAdd(t_invoiceslines)); t_invoiceslines = _dentnedModel.InvoicesLines.FirstOrDefault(r => r.invoiceslines_code == "XXX"); t_invoiceslines.patientstreatments_id = -999; Assert.IsFalse(_dentnedModel.InvoicesLines.CanUpdate(t_invoiceslines)); t_invoiceslines.patientstreatments_id = null; Assert.IsTrue(_dentnedModel.InvoicesLines.CanUpdate(t_invoiceslines)); _dentnedModel.Invoices.Remove(_dentnedModel.Invoices.List(r => r.invoices_number == "XX1" && r.invoices_date == today.Date).ToArray()); _dentnedModel.Patients.Remove(_dentnedModel.Patients.List(r => r.patients_name == "XX1" && r.patients_surname == "XX1").ToArray()); _dentnedModel.Doctors.Remove(_dentnedModel.Doctors.List(r => r.doctors_name == "XX1" && r.doctors_surname == "XX1").ToArray()); _dentnedModel.Treatments.Remove(_dentnedModel.Treatments.List(r => r.treatments_code == "XX1").ToArray()); _dentnedModel.TreatmentsTypes.Remove(_dentnedModel.TreatmentsTypes.List(r => r.treatmentstypes_name == "XX1").ToArray()); }