public bool deletePatient(patients patients)
{
db.patients.Remove(patients);
db.SaveChanges();
return(true);
}
public bool updatePatient(patients patients)
{
db.Entry(patients).State = EntityState.Modified;
db.SaveChanges();
return(true);
}
public ActionResult create(patients patient)
{
Nullable <int> ID = null;
var fname = "";
var mname = "";
var lname = "";
Nullable <int> gender = null;
var email = "";
Nullable <int> status = null;
Nullable <bool> Active = null;
var CreatedBy = 1;
if (ModelState.IsValid)
{
patients newpatient = new patients()
{
ID = 93095637,
fname = patient.fname,
mname = patient.mname,
lname = patient.lname,
gender = 2,
email = patient.email,
status = 1,
Active = true,
CreatedBy = 1
};
services.create(newpatient);
return(RedirectToAction("Index"));
}
return(View(patient));
}
public bool addPatient(patients patient)
{
db.patients.Add(patient);
db.SaveChanges();
return(true);
}
public async Task <IActionResult> updateData(patients patients, IFormFile imgUp)
{
if (imgUp != null)
{
if (patients.imageName == null)
{
patients.imageName = Guid.NewGuid().ToString() + Path.GetExtension(imgUp.FileName);
}
string savePath = Path.Combine(
Directory.GetCurrentDirectory(), "wwwroot/uploadImages", patients.imageName
);
using (var stream = new FileStream(savePath, FileMode.Create))
{
await imgUp.CopyToAsync(stream);
}
}
patients.createDate = DateTime.Now.toShamsi();
var result = await patientsRepository.editPatients(patients);
if (result == true)
{
await patientsRepository.saveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(int id)
{
patients patients = db.patients.Find(id);
db.patients.Remove(patients);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void PatientsMedicalrecords_Test1()
{
string[] errors = new string[] { };
patients t_patients = null;
medicalrecordstypes t_medicalrecordstypes = null;
patientsmedicalrecords t_patientsmedicalrecords = null;
_dentnedModel.Patients.Remove(_dentnedModel.Patients.List(r => r.patients_name == "XX1" && r.patients_surname == "XX1").ToArray());
_dentnedModel.MedicalrecordsTypes.Remove(_dentnedModel.MedicalrecordsTypes.List(r => r.medicalrecordstypes_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_medicalrecordstypes = new medicalrecordstypes()
{
medicalrecordstypes_name = "XX1"
};
_dentnedModel.MedicalrecordsTypes.Add(t_medicalrecordstypes);
t_patientsmedicalrecords = new patientsmedicalrecords()
{
//patients_id = t_patients.patients_id,
medicalrecordstypes_id = t_medicalrecordstypes.medicalrecordstypes_id,
patientsmedicalrecords_value = "ttt"
};
Assert.IsFalse(_dentnedModel.PatientsMedicalrecords.CanAdd(t_patientsmedicalrecords));
t_patientsmedicalrecords = new patientsmedicalrecords()
{
patients_id = t_patients.patients_id,
//medicalrecordstypes_id = t_medicalrecordstypes.medicalrecordstypes_id,
patientsmedicalrecords_value = "ttt"
};
Assert.IsFalse(_dentnedModel.PatientsMedicalrecords.CanAdd(t_patientsmedicalrecords));
t_patientsmedicalrecords = new patientsmedicalrecords()
{
patients_id = t_patients.patients_id,
medicalrecordstypes_id = t_medicalrecordstypes.medicalrecordstypes_id,
patientsmedicalrecords_value = "ttt"
};
Assert.IsTrue(_dentnedModel.PatientsMedicalrecords.CanAdd(t_patientsmedicalrecords));
_dentnedModel.PatientsMedicalrecords.Add(t_patientsmedicalrecords);
_dentnedModel.Patients.Remove(_dentnedModel.Patients.List(r => r.patients_name == "XX1" && r.patients_surname == "XX1").ToArray());
_dentnedModel.MedicalrecordsTypes.Remove(_dentnedModel.MedicalrecordsTypes.List(r => r.medicalrecordstypes_name == "XX1").ToArray());
}
public ActionResult Edit([Bind(Include = "id,FIO,phone,date_birth,address")] patients patients)
{
if (ModelState.IsValid)
{
db.Entry(patients).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(patients));
}
public ActionResult Create([Bind(Include = "id,FIO,phone,date_birth,address")] patients patients)
{
if (ModelState.IsValid)
{
db.patients.Add(patients);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(patients));
}
public async Task <bool> insertPatients(patients patients)
{
try
{
await db.Patients.AddAsync(patients);
return(true);
}
catch (Exception)
{
return(false);
}
}
public ActionResult Edit(int id, patients patient)
{
PatientMediator patientMediator = new PatientMediator();
if (patientMediator.EditCurrentPatient(id, patient))
{
return(RedirectToAction("CustomerPatients"));
}
else
{
return(View());
}
}
public async Task <bool> deletePatients(patients patients)
{
try
{
await Task.Run(() => db.Entry(patients).State = EntityState.Deleted);
return(true);
}
catch (Exception)
{
return(false);
}
}
public async Task <bool> deletePatients(int id)
{
try
{
patients find = await getPatientsById(id);
await deletePatients(find);
return(true);
}
catch (Exception)
{
return(false);
}
}
public patients edit(int id, patients editedpatient)
{
var patient = patientsList.Where(p => p.ID == id).SingleOrDefault();
patient.fname = editedpatient.fname;
patient.mname = editedpatient.mname;
patient.lname = editedpatient.lname;
patient.Active = editedpatient.Active;
patient.gender = editedpatient.gender;
patient.status = editedpatient.status;
patient.lastCheck = DateTime.Now;
return(patient);
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
patients patients = db.patients.Find(id);
if (patients == null)
{
return(HttpNotFound());
}
return(View(patients));
}
public void Payments_Test1()
{
string[] errors = new string[] { };
payments t_payments = null;
patients t_patients = null;
_dentnedModel.Patients.Remove(_dentnedModel.Patients.List(r => r.patients_name == "XX1" && r.patients_surname == "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_payments = new payments()
{
payments_amount = (decimal) - 20,
payments_date = DateTime.Now,
patients_id = t_patients.patients_id
};
Assert.IsFalse(_dentnedModel.Payments.CanAdd(t_payments));
t_payments = new payments()
{
payments_amount = (decimal)10.10,
payments_date = DateTime.Now,
//patients_id = t_patients.patients_id
};
Assert.IsFalse(_dentnedModel.Payments.CanAdd(t_payments));
t_payments = new payments()
{
payments_amount = (decimal)10.10,
payments_date = DateTime.Now,
patients_id = t_patients.patients_id
};
Assert.IsTrue(_dentnedModel.Payments.CanAdd(t_payments));
_dentnedModel.Payments.Add(t_payments);
_dentnedModel.Patients.Remove(_dentnedModel.Patients.List(r => r.patients_name == "XX1" && r.patients_surname == "XX1").ToArray());
}
public void PatientsNotes_Test1()
{
string[] errors = new string[] { };
patients t_patients = null;
patientsnotes t_patientsnotes = null;
_dentnedModel.Patients.Remove(_dentnedModel.Patients.List(r => r.patients_name == "XX1" && r.patients_surname == "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_patientsnotes = new patientsnotes()
{
//patients_id = t_patients.patients_id
patientsnotes_text = "XX",
patientsnotes_date = DateTime.Now
};
Assert.IsFalse(_dentnedModel.PatientsNotes.CanAdd(t_patientsnotes));
t_patientsnotes = new patientsnotes()
{
patients_id = t_patients.patients_id,
//contactstypes_id = t_contactstypes.contactstypes_id,
patientsnotes_date = DateTime.Now
};
Assert.IsFalse(_dentnedModel.PatientsNotes.CanAdd(t_patientsnotes));
t_patientsnotes = new patientsnotes()
{
patients_id = t_patients.patients_id,
patientsnotes_text = "XX",
patientsnotes_date = DateTime.Now
};
Assert.IsTrue(_dentnedModel.PatientsNotes.CanAdd(t_patientsnotes));
_dentnedModel.PatientsNotes.Add(t_patientsnotes);
_dentnedModel.Patients.Remove(_dentnedModel.Patients.List(r => r.patients_name == "XX1" && r.patients_surname == "XX1").ToArray());
}
public void AddressesTypes_Test2()
{
string[] errors = new string[] { };
patients t_patients = null;
addressestypes t_addressestypes = null;
patientsaddresses t_patientsaddresses = null;
_dentnedModel.Patients.Remove(_dentnedModel.Patients.List(r => r.patients_name == "XX1" && r.patients_surname == "XX1").ToArray());
_dentnedModel.AddressesTypes.Remove(_dentnedModel.AddressesTypes.List(r => r.addressestypes_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_addressestypes = new addressestypes()
{
addressestypes_name = "XX1"
};
_dentnedModel.AddressesTypes.Add(t_addressestypes);
t_patientsaddresses = new patientsaddresses()
{
patients_id = t_patients.patients_id,
addressestypes_id = t_addressestypes.addressestypes_id,
patientsaddresses_state = "XX",
patientsaddresses_city = "XX",
patientsaddresses_street = "XX",
patientsaddresses_zipcode = "XX"
};
_dentnedModel.PatientsAddresses.Add(t_patientsaddresses);
Assert.IsFalse(_dentnedModel.AddressesTypes.CanRemove(_dentnedModel.AddressesTypes.List(r => r.addressestypes_name == "XX1").ToArray()));
_dentnedModel.Patients.Remove(_dentnedModel.Patients.List(r => r.patients_name == "XX1" && r.patients_surname == "XX1").ToArray());
Assert.IsTrue(_dentnedModel.AddressesTypes.CanRemove(_dentnedModel.AddressesTypes.List(r => r.addressestypes_name == "XX1").ToArray()));
_dentnedModel.AddressesTypes.Remove(_dentnedModel.AddressesTypes.List(r => r.addressestypes_name == "XX1").ToArray());
}
public ActionResult AddPatient(patients patient)
{
PatientMediator patientMediator = new PatientMediator();
if (!patientMediator.AddNewPatient(patient))
{
ViewBag.DuplicateMessage = "Данный ИИН уже зарегистрирован";
return(RedirectToAction("AddPatient"));
}
else
{
ModelState.Clear();
ViewBag.SuccesMessage = "Registration succefusl";
return(View("AddPatient", patientMediator.AddNewPatientForm()));
}
}
public bool EditCurrentPatient(int id, patients patient)
{
try
{
using (DbModels model = new DbModels())
{
model.Entry(patient).State = System.Data.Entity.EntityState.Modified;
model.SaveChanges();
}
return(true);
}
catch
{
return(false);
}
}
public bool AddNewPatient(patients patient)
{
using (DbModels model = new DbModels())
{
if (model.patients.Any(p => p.uin == patient.uin))
{
return(false);
}
else
{
model.patients.Add(patient);
model.SaveChanges();
return(true);
}
}
}
public void PatientsAttachmentsTypes_Test2()
{
string[] errors = new string[] { };
patients t_patients = null;
patientsattachmentstypes t_patientsattachmentstypes = null;
patientsattachments t_patientsattachments = null;
_dentnedModel.Patients.Remove(_dentnedModel.Patients.List(r => r.patients_name == "XX1" && r.patients_surname == "XX1").ToArray());
_dentnedModel.PatientsAttachmentsTypes.Remove(_dentnedModel.PatientsAttachmentsTypes.List(r => r.patientsattachmentstypes_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_patientsattachmentstypes = new patientsattachmentstypes()
{
patientsattachmentstypes_name = "XX1",
patientsattachmentstypes_valueautofunc = PatientsAttachmentsTypesRepository.ValueAutoFuncCode.NUL.ToString()
};
_dentnedModel.PatientsAttachmentsTypes.Add(t_patientsattachmentstypes);
t_patientsattachments = new patientsattachments()
{
patients_id = t_patients.patients_id,
patientsattachmentstypes_id = t_patientsattachmentstypes.patientsattachmentstypes_id,
patientsattachments_value = "XX",
patientsattachments_date = DateTime.Now
};
_dentnedModel.PatientsAttachments.Add(t_patientsattachments);
Assert.IsFalse(_dentnedModel.PatientsAttachmentsTypes.CanRemove(_dentnedModel.PatientsAttachmentsTypes.List(r => r.patientsattachmentstypes_name == "XX1").ToArray()));
_dentnedModel.Patients.Remove(_dentnedModel.Patients.List(r => r.patients_name == "XX1" && r.patients_surname == "XX1").ToArray());
Assert.IsTrue(_dentnedModel.PatientsAttachmentsTypes.CanRemove(_dentnedModel.PatientsAttachmentsTypes.List(r => r.patientsattachmentstypes_name == "XX1").ToArray()));
_dentnedModel.PatientsAttachmentsTypes.Remove(_dentnedModel.PatientsAttachmentsTypes.List(r => r.patientsattachmentstypes_name == "XX1").ToArray());
}
public bool DeleteCurrentUser(int id, FormCollection collection)
{
try
{
using (DbModels model = new DbModels())
{
patients patientToDelete = model.patients.Where(x => x.id == id).FirstOrDefault();
model.patients.Remove(patientToDelete);
model.SaveChanges();
}
return(true);
}
catch
{
return(false);
}
}
public void ContactsTypes_Test2()
{
string[] errors = new string[] { };
patients t_patients = null;
contactstypes t_contactstypes = null;
patientscontacts t_patientscontacts = null;
_dentnedModel.Patients.Remove(_dentnedModel.Patients.List(r => r.patients_name == "XX1" && r.patients_surname == "XX1").ToArray());
_dentnedModel.ContactsTypes.Remove(_dentnedModel.ContactsTypes.List(r => r.contactstypes_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_contactstypes = new contactstypes()
{
contactstypes_name = "XX1"
};
_dentnedModel.ContactsTypes.Add(t_contactstypes);
t_patientscontacts = new patientscontacts()
{
patients_id = t_patients.patients_id,
contactstypes_id = t_contactstypes.contactstypes_id,
patientscontacts_value = "XX"
};
_dentnedModel.PatientsContacts.Add(t_patientscontacts);
Assert.IsFalse(_dentnedModel.ContactsTypes.CanRemove(_dentnedModel.ContactsTypes.List(r => r.contactstypes_name == "XX1").ToArray()));
_dentnedModel.Patients.Remove(_dentnedModel.Patients.List(r => r.patients_name == "XX1" && r.patients_surname == "XX1").ToArray());
Assert.IsTrue(_dentnedModel.ContactsTypes.CanRemove(_dentnedModel.ContactsTypes.List(r => r.contactstypes_name == "XX1").ToArray()));
_dentnedModel.ContactsTypes.Remove(_dentnedModel.ContactsTypes.List(r => r.contactstypes_name == "XX1").ToArray());
}
public async Task <IActionResult> createPatients(patients patients, string Password, string confpassword, IFormFile imgUp)
{
var newUser = new IdentityUser()
{
Email = patients.Email,
UserName = patients.Email
};
if (Password == confpassword)
{
var UserResult = await authorizationRepository.createUser(newUser, Password);
if (UserResult.Succeeded)
{
var userCreated = await _userManager.FindByEmailAsync(newUser.Email);
await authorizationRepository.userBindToRole(userCreated, "patients");
if (imgUp != null)
{
patients.imageName = Guid.NewGuid().ToString() + Path.GetExtension(imgUp.FileName);
string savePath = Path.Combine(
Directory.GetCurrentDirectory(), "wwwroot/uploadImages", patients.imageName
);
using (var stream = new FileStream(savePath, FileMode.Create))
{
await imgUp.CopyToAsync(stream);
}
}
patients.createDate = DateTime.Now.toShamsi();
var result = await patientsRepository.insertPatients(patients);
if (result == true)
{
await patientsRepository.saveChanges();
}
}
}
return(Redirect("/Identity/Account/Login?ReturnUrl="));
}
public void CleanDir_CleanPatientDir()
{
if (Directory.Exists("test"))
{
Directory.Delete("test", true);
}
Directory.CreateDirectory("test");
string[] messages = new string[] { };
string[] errors = new string[] { };
patients t_patients1 = null;
patients t_patients2 = null;
_dentnedModel.Patients.Remove(_dentnedModel.Patients.List(r => r.patients_name == "XX1" && r.patients_surname == "XX1").ToArray());
_dentnedModel.Patients.Remove(_dentnedModel.Patients.List(r => r.patients_name == "XX2" && r.patients_surname == "XX2").ToArray());
t_patients1 = 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_patients1);
Directory.CreateDirectory("test\\" + t_patients1.patients_id);
Directory.CreateDirectory("test\\" + t_patients1.patients_id + "\\test");
File.Create("test\\" + t_patients1.patients_id + "\\test1.txt").Dispose();
File.Create("test\\" + t_patients1.patients_id + "\\test\\test1.txt").Dispose();
t_patients2 = new patients()
{
patients_name = "XX2",
patients_surname = "XX2",
patients_birthdate = DateTime.Now,
patients_birthcity = "xxx",
patients_doctext = "xxx",
patients_sex = "M",
patients_username = "******",
patients_password = "******"
};
_dentnedModel.Patients.Add(t_patients2);
Directory.CreateDirectory("test\\" + t_patients2.patients_id);
Directory.CreateDirectory("test\\" + t_patients2.patients_id + "\\test");
File.Create("test\\" + t_patients2.patients_id + "\\test1.txt").Dispose();
File.Create("test\\" + t_patients2.patients_id + "\\test\\test1.txt").Dispose();
Assert.IsTrue(Directory.Exists("test\\" + t_patients1.patients_id));
Assert.IsTrue(File.Exists("test\\" + t_patients1.patients_id + "\\test1.txt"));
Assert.IsTrue(File.Exists("test\\" + t_patients1.patients_id + "\\test\\test1.txt"));
Assert.IsTrue(Directory.Exists("test\\" + t_patients2.patients_id));
Assert.IsTrue(File.Exists("test\\" + t_patients2.patients_id + "\\test1.txt"));
Assert.IsTrue(File.Exists("test\\" + t_patients2.patients_id + "\\test\\test1.txt"));
CleanDir.CleanPatientDir("test", false, ref messages, ref errors);
Assert.That(messages.Length, Is.EqualTo(0));
Assert.That(errors.Length, Is.EqualTo(0));
_dentnedModel.Patients.Remove(_dentnedModel.Patients.List(r => r.patients_name == "XX2" && r.patients_surname == "XX2").ToArray());
CleanDir.CleanPatientDir("test", false, ref messages, ref errors);
Assert.That(messages.Length, Is.Not.EqualTo(0));
Assert.That(errors.Length, Is.EqualTo(0));
Assert.IsTrue(Directory.Exists("test\\" + t_patients1.patients_id));
Assert.IsTrue(File.Exists("test\\" + t_patients1.patients_id + "\\test1.txt"));
Assert.IsTrue(File.Exists("test\\" + t_patients1.patients_id + "\\test\\test1.txt"));
Assert.IsFalse(Directory.Exists("test\\" + t_patients2.patients_id));
Assert.IsFalse(File.Exists("test\\" + t_patients2.patients_id + "\\test1.txt"));
Assert.IsFalse(File.Exists("test\\" + t_patients2.patients_id + "\\test\\test1.txt"));
_dentnedModel.Patients.Remove(_dentnedModel.Patients.List(r => r.patients_name == "XX1" && r.patients_surname == "XX1").ToArray());
_dentnedModel.Patients.Remove(_dentnedModel.Patients.List(r => r.patients_name == "XX2" && r.patients_surname == "XX2").ToArray());
CleanDir.CleanPatientDir("test", true, ref messages, ref errors);
Assert.That(messages.Length, Is.Not.EqualTo(0));
Assert.That(errors.Length, Is.EqualTo(0));
Assert.IsFalse(Directory.Exists("test\\" + t_patients1.patients_id));
Assert.IsFalse(File.Exists("test\\" + t_patients1.patients_id + "\\test1.txt"));
Assert.IsFalse(File.Exists("test\\" + t_patients1.patients_id + "\\test\\test1.txt"));
Assert.IsFalse(Directory.Exists("test\\" + t_patients2.patients_id));
Assert.IsFalse(File.Exists("test\\" + t_patients2.patients_id + "\\test1.txt"));
Assert.IsFalse(File.Exists("test\\" + t_patients2.patients_id + "\\test\\test1.txt"));
Directory.Delete("test", true);
}
public patients getOne(int?id)
{
patients patients = db.patients.Find(id);
return(patients);
}
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 create(patients patient)
{
patientsList.Add(patient);
}
