public int MedicineUpdateRecord(Medicine medicine, string name, string type, bool?ssi, string description)
{
if (!string.IsNullOrEmpty(name) && !string.IsNullOrWhiteSpace(name) && !string.IsNullOrEmpty(type) && !string.IsNullOrWhiteSpace(type) && medicine != null)
{
string tempDescription;
if (string.IsNullOrEmpty(description.Trim()))
{
tempDescription = null;
}
else
{
tempDescription = description;
}
using (RepositoryMedicine repositoryMedicine = new RepositoryMedicine())
{
if (!repositoryMedicine.AnyWithExplicitLoad(I => I.Id != medicine.Id && I.Name == name))
{
medicine.Name = name;
medicine.Type = BLLHelper.GetEnumValueFromDescription <MedicineEnumType>(type);
medicine.Ssi = ssi;
medicine.Description = tempDescription;
medicine.UpdateTime = DateTime.Now;
repositoryMedicine.CUDOperation(medicine, EntityState.Modified);
return(repositoryMedicine.SaveChanges());
}
return(-103);
}
}
else
{
return(-1);
}
}
public int ForgotPassword(string ssn, string name, string surname, string phone, string mail, DateTime birthday, string newPassword, string newPasswordRepeat)
{
if (!string.IsNullOrEmpty(ssn) && !string.IsNullOrWhiteSpace(ssn) && !string.IsNullOrEmpty(name) && !string.IsNullOrWhiteSpace(name) && !string.IsNullOrEmpty(surname) && !string.IsNullOrWhiteSpace(surname) && !string.IsNullOrEmpty(newPassword) && !string.IsNullOrWhiteSpace(newPassword) && !string.IsNullOrEmpty(newPasswordRepeat) && !string.IsNullOrWhiteSpace(newPasswordRepeat) && birthday != null)
{
string tempPhone;
string tempMail;
if (string.IsNullOrEmpty(phone.Trim()))
{
tempPhone = null;
}
else
{
tempPhone = phone;
}
if (string.IsNullOrEmpty(mail.Trim()))
{
tempMail = null;
}
else
{
tempMail = mail;
}
using (RepositoryMember repositoryMember = new RepositoryMember())
{
Member member = repositoryMember.FirstWithExplicitLoad(I => I.Ssn == ssn);
if (member != null)
{
if (member.Name == BLLHelper.TrimName(name) && member.Surname == BLLHelper.TrimSurname(surname) && member.Phone == tempPhone && member.Mail == tempMail && member.Birthday.ToString("dd.MM.yyyy") == birthday.ToString("dd.MM.yyyy"))
{
if (newPassword == newPasswordRepeat)
{
member.Password = PasswordCrypto.EncryptToSha512(newPassword);
repositoryMember.CUDOperation(member, EntityState.Modified);
return(repositoryMember.SaveChanges());
}
else
{
return(-4);
}
}
else
{
return(-6);
}
}
else
{
return(-5);
}
}
}
else
{
return(-1);
}
}
public List <Doctor> GetSelectedHospitalExpertiseDoctors(Hospital hospital, DoctorEnumExpertise expertise, Member member)
{
DoctorEnumAgeRange ageRange = BLLHelper.GetAgeRange(member);
List <Doctor> doctors = hospital.Doctors.Where(I => I.AgeRange == ageRange && I.Expertise == expertise).ToList();
foreach (var item in doctors)
{
item.Age = (DateTime.Now.Year - item.Birthday.Year);
}
return(doctors);
}
public int MedicineNewRecord(string name, string type, bool?ssi, string description)
{
if (!string.IsNullOrEmpty(name) && !string.IsNullOrWhiteSpace(name) && !string.IsNullOrEmpty(type) && !string.IsNullOrWhiteSpace(type))
{
string tempDescription;
if (string.IsNullOrEmpty(description.Trim()))
{
tempDescription = null;
}
else
{
tempDescription = description;
}
using (RepositoryMedicine repositoryMedicine = new RepositoryMedicine())
{
if (!repositoryMedicine.AnyWithExplicitLoad(I => I.Name == name))
{
Medicine medicine = new Medicine()
{
Id = Guid.NewGuid(),
Name = name,
Type = BLLHelper.GetEnumValueFromDescription <MedicineEnumType>(type),
Description = tempDescription,
Ssi = ssi
};
repositoryMedicine.CUDOperation(medicine, EntityState.Added);
return(repositoryMedicine.SaveChanges());
}
else
{
return(-103);
}
}
}
else
{
return(-1);
}
}
public int DoctorUpdateRecord(Doctor doctor, Hospital hospital, string ssn, string appellation, string expertise, string ageRange, string name, string surname, DateTime birthday, string phone, string mail, string city, string county)
{
if (!string.IsNullOrEmpty(ssn) && !string.IsNullOrWhiteSpace(ssn) && ssn.Length == 11 && !string.IsNullOrEmpty(appellation) && !string.IsNullOrWhiteSpace(appellation) && !string.IsNullOrEmpty(expertise) && !string.IsNullOrWhiteSpace(expertise) && !string.IsNullOrEmpty(ageRange) && !string.IsNullOrWhiteSpace(ageRange) && !string.IsNullOrEmpty(surname) && !string.IsNullOrWhiteSpace(surname) && !string.IsNullOrEmpty(name) && !string.IsNullOrWhiteSpace(name) && birthday != null && doctor != null && hospital != null)
{
string tempPhone;
string tempMail;
string tempCity;
string tempCounty;
if (string.IsNullOrEmpty(phone.Trim()))
{
tempPhone = null;
}
else
{
tempPhone = phone;
}
if (string.IsNullOrEmpty(mail.Trim()))
{
tempMail = null;
}
else
{
tempMail = mail;
}
if (string.IsNullOrEmpty(city.Trim()))
{
tempCity = null;
}
else
{
tempCity = city;
}
if (string.IsNullOrEmpty(county.Trim()))
{
tempCounty = null;
}
else
{
tempCounty = county;
}
using (RepositoryDoctor repositoryDoctor = new RepositoryDoctor())
{
if (!repositoryDoctor.AnyWithExplicitLoad(I => I.Id != doctor.Id && I.Ssn == ssn))
{
if (!repositoryDoctor.AnyWithExplicitLoad(I => I.Id != doctor.Id && I.Phone == phone))
{
if (!repositoryDoctor.AnyWithExplicitLoad(I => I.Id != doctor.Id && I.Mail == mail))
{
doctor.Ssn = ssn;
doctor.Appellation = BLLHelper.GetEnumValueFromDescription <DoctorEnumAppellation>(appellation);
doctor.Expertise = BLLHelper.GetEnumValueFromDescription <DoctorEnumExpertise>(expertise);
doctor.AgeRange = BLLHelper.GetEnumValueFromDescription <DoctorEnumAgeRange>(ageRange);
doctor.Name = BLLHelper.TrimName(name);
doctor.Surname = BLLHelper.TrimSurname(surname);
doctor.Birthday = birthday;
doctor.Phone = tempPhone;
doctor.Mail = tempMail;
doctor.City = tempCity;
doctor.County = tempCounty;
doctor.UpdateTime = DateTime.Now;
doctor.HospitalId = hospital.Id;
repositoryDoctor.CUDOperation(doctor, EntityState.Modified);
return(repositoryDoctor.SaveChanges());
}
else
{
return(-112);
}
}
else
{
return(-111);
}
}
else
{
return(-110);
}
}
}
else
{
return(-1);
}
}
public int HospitalNewRecord(string name, decimal numberOfBed, string phoneI, string phoneII, string phoneIII, string mail, string website, string city, string county, string address)
{
if (!string.IsNullOrEmpty(name) && !string.IsNullOrWhiteSpace(name) && !string.IsNullOrEmpty(city) && !string.IsNullOrWhiteSpace(city) && !string.IsNullOrEmpty(county) && !string.IsNullOrWhiteSpace(county))
{
string tempPhoneI;
string tempPhoneII;
string tempPhoneIII;
string tempMail;
string tempWebsite;
string tempAddress;
if (string.IsNullOrEmpty(phoneI.Trim()))
{
tempPhoneI = null;
}
else
{
tempPhoneI = phoneI;
}
if (string.IsNullOrEmpty(phoneII.Trim()))
{
tempPhoneII = null;
}
else
{
tempPhoneII = phoneII;
}
if (string.IsNullOrEmpty(phoneIII.Trim()))
{
tempPhoneIII = null;
}
else
{
tempPhoneIII = phoneIII;
}
if (string.IsNullOrEmpty(mail.Trim()))
{
tempMail = null;
}
else
{
tempMail = mail;
}
if (string.IsNullOrEmpty(website.Trim()))
{
tempWebsite = null;
}
else
{
tempWebsite = website;
}
if (string.IsNullOrEmpty(address.Trim()))
{
tempAddress = null;
}
else
{
tempAddress = address;
}
using (RepositoryHospital repositoryHospital = new RepositoryHospital())
{
if (!repositoryHospital.AnyWithExplicitLoad(I => I.Name == name))
{
if (!repositoryHospital.AnyWithExplicitLoad(I => I.PhoneI == phoneI))
{
if (!repositoryHospital.AnyWithExplicitLoad(I => I.PhoneII == phoneII))
{
if (!repositoryHospital.AnyWithExplicitLoad(I => I.PhoneIII == phoneIII))
{
if (!repositoryHospital.AnyWithExplicitLoad(I => I.Mail == mail))
{
if (!repositoryHospital.AnyWithExplicitLoad(I => I.Address == address))
{
Hospital hospital = new Hospital()
{
Id = Guid.NewGuid(),
Name = name,
NumberOfBed = (int)numberOfBed,
PhoneI = tempPhoneI,
PhoneII = tempPhoneII,
PhoneIII = tempPhoneIII,
Mail = tempMail,
Website = tempWebsite,
City = city,
County = county,
Address = tempAddress,
Picture = BLLHelper.DefaultHospitalPic()
};
repositoryHospital.CUDOperation(hospital, EntityState.Added);
return(repositoryHospital.SaveChanges());
}
else
{
return(-109);
}
}
else
{
return(-108);
}
}
else
{
return(-107);
}
}
else
{
return(-106);
}
}
else
{
return(-105);
}
}
else
{
return(-104);
}
}
}
else
{
return(-1);
}
}
public int DoctorNewRecord(Hospital hospital, string ssn, string appellation, string expertise, string ageRange, string name, string surname, DateTime birthday, string phone, string mail, string city, string county)
{
if (!string.IsNullOrEmpty(ssn) && !string.IsNullOrWhiteSpace(ssn) && ssn.Length == 11 && !string.IsNullOrEmpty(appellation) && !string.IsNullOrWhiteSpace(appellation) && !string.IsNullOrEmpty(expertise) && !string.IsNullOrWhiteSpace(expertise) && !string.IsNullOrEmpty(ageRange) && !string.IsNullOrWhiteSpace(ageRange) && !string.IsNullOrEmpty(surname) && !string.IsNullOrWhiteSpace(surname) && !string.IsNullOrEmpty(name) && !string.IsNullOrWhiteSpace(name) && birthday != null && hospital != null)
{
string tempPhone;
string tempMail;
string tempCity;
string tempCounty;
if (string.IsNullOrEmpty(phone.Trim()))
{
tempPhone = null;
}
else
{
tempPhone = phone;
}
if (string.IsNullOrEmpty(mail.Trim()))
{
tempMail = null;
}
else
{
tempMail = mail;
}
if (string.IsNullOrEmpty(city.Trim()))
{
tempCity = null;
}
else
{
tempCity = city;
}
if (string.IsNullOrEmpty(county.Trim()))
{
tempCounty = null;
}
else
{
tempCounty = county;
}
using (RepositoryDoctor repositoryDoctor = new RepositoryDoctor())
{
if (!repositoryDoctor.AnyWithExplicitLoad(I => I.Ssn == ssn))
{
if (!repositoryDoctor.AnyWithExplicitLoad(I => I.Phone == phone))
{
if (!repositoryDoctor.AnyWithExplicitLoad(I => I.Mail == mail))
{
Doctor doctor = new Doctor()
{
Id = Guid.NewGuid(),
Ssn = ssn,
Appellation = BLLHelper.GetEnumValueFromDescription <DoctorEnumAppellation>(appellation),
Expertise = BLLHelper.GetEnumValueFromDescription <DoctorEnumExpertise>(expertise),
AgeRange = BLLHelper.GetEnumValueFromDescription <DoctorEnumAgeRange>(ageRange),
Name = BLLHelper.TrimName(name),
Surname = BLLHelper.TrimSurname(surname),
Birthday = birthday,
Phone = tempPhone,
Mail = tempMail,
City = tempCity,
County = tempCounty,
Picture = BLLHelper.DefaultDoctorPic(),
Password = PasswordCrypto.EncryptToSha512(ssn),
UpdateTime = DateTime.Now,
HospitalId = hospital.Id
};
repositoryDoctor.CUDOperation(doctor, EntityState.Added);
return(repositoryDoctor.SaveChanges());
}
else
{
return(-112);
}
}
else
{
return(-111);
}
}
else
{
return(-110);
}
}
}
else
{
return(-1);
}
}
public int MemberRegister(MemberEnumGender gender, string ssn, string password, string name, string surname, string phone, string mail, DateTime birthday)
{
int returnValueInt = 0;
if (!string.IsNullOrEmpty(ssn) && !string.IsNullOrWhiteSpace(ssn) && !string.IsNullOrEmpty(password) && !string.IsNullOrWhiteSpace(password) && !string.IsNullOrEmpty(name) && !string.IsNullOrWhiteSpace(name) && !string.IsNullOrEmpty(surname) && !string.IsNullOrWhiteSpace(surname) && ssn.Length == 11 && birthday != null)
{
string tempPhone;
string tempMail;
if (string.IsNullOrEmpty(phone.Trim()))
{
tempPhone = null;
}
else
{
tempPhone = phone;
}
if (string.IsNullOrEmpty(mail.Trim()))
{
tempMail = null;
}
else
{
tempMail = mail;
}
using (RepositoryMember repositoryMember = new RepositoryMember())
{
if (!repositoryMember.AnyWithExplicitLoad(I => I.Ssn == ssn))
{
if (!repositoryMember.AnyWithExplicitLoad(I => I.Phone == phone))
{
if (!repositoryMember.AnyWithExplicitLoad(I => I.Mail == mail))
{
repositoryMember.CUDOperation(new Member()
{
Id = Guid.NewGuid(),
Ssn = ssn,
Name = BLLHelper.TrimName(name),
Surname = BLLHelper.TrimSurname(surname),
Gender = gender,
Birthday = birthday,
Phone = tempPhone,
Mail = tempMail,
Password = PasswordCrypto.EncryptToSha512(password),
Picture = BLLHelper.DefaultUserPic()
}, EntityState.Added);
returnValueInt = repositoryMember.SaveChanges();
}
else
{
returnValueInt = -102;
}
}
else
{
returnValueInt = -101;
}
}
else
{
returnValueInt = -100;
}
}
}
else
{
returnValueInt = -1;
}
return(returnValueInt);
}
