public List <int> ListOfFreeFloors()
{
List <int> result = new List <int>();
try
{
using (MedicaClinicEntities2 context = new MedicaClinicEntities2())
{
int numOfFloors = (from p in context.Institutions where p.InstitutionId == 1 select p.NumberOfFloors).FirstOrDefault();
List <int> assignedFloors = (from a in context.vwManagers where a.IsDeleted == false select a.ClinicFloor).ToList();
for (int i = 1; i <= numOfFloors; i++)
{
if (!assignedFloors.Contains(i))
{
result.Add(i);
}
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exeption" + ex.Message.ToString());
return(result = null);
}
return(result);
}
public void ChackNumberOfMaintainanc()
{
try
{
using (MedicaClinicEntities2 context = new MedicaClinicEntities2())
{
Queue <ClinicUser> queueMaintainance = new Queue <ClinicUser>();
foreach (ClinicUser user in context.ClinicUsers)
{
if (user.RoleId == 2 && user.IsDeleted == false)
{
queueMaintainance.Enqueue(user);
}
}
if (queueMaintainance.Count > 3)
{
ClinicUser deletedUser = queueMaintainance.Dequeue();
DeleteUser(deletedUser.ClinicUserId);
context.SaveChanges();
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exep tion" + ex.Message.ToString());
}
}
public bool CheckMaximumNumberOfRooms(int minNumOfRooms)
{
try
{
using (MedicaClinicEntities2 context = new MedicaClinicEntities2())
{
int maxNumOfRoomPerFloor = (from d in context.Institutions where d.InstitutionId == 1 select d.NumberOfRoomsPerFloor).FirstOrDefault();
if (minNumOfRooms > maxNumOfRoomPerFloor)
{
MessageBox.Show("The minimum number of rooms is higher than the maximum number of rooms per floor!");
return(false);
}
else
{
return(true);
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(false);
}
}
public int AddInstitution(Institution institution)
{
try
{
using (MedicaClinicEntities2 context = new MedicaClinicEntities2())
{
if (institution.InstitutionId == 0)
{
Institution newInstitution = new Institution();
newInstitution.ClinicUserId = institution.ClinicUserId;
newInstitution.Name = institution.Name;
newInstitution.Owner = institution.Owner;
newInstitution.BuildDate = institution.BuildDate;
newInstitution.Address = institution.Address;
newInstitution.NumberOfFloors = institution.NumberOfFloors;
newInstitution.NumberOfRoomsPerFloor = institution.NumberOfRoomsPerFloor;
newInstitution.Terrace = institution.Terrace;
newInstitution.Backyard = institution.Backyard;
newInstitution.AccessPointsForAmbulances = institution.AccessPointsForAmbulances;
newInstitution.AccessPointsForhandicaps = institution.AccessPointsForhandicaps;
context.Institutions.Add(newInstitution);
context.SaveChanges();
institution.InstitutionId = newInstitution.InstitutionId;
return(institution.InstitutionId);
}
else
{
Institution editInstitution = (from p in context.Institutions where p.InstitutionId == institution.InstitutionId select p).First();
editInstitution.ClinicUserId = institution.ClinicUserId;
editInstitution.Name = institution.Name;
editInstitution.Owner = institution.Owner;
editInstitution.BuildDate = institution.BuildDate;
editInstitution.Address = institution.Address;
editInstitution.NumberOfFloors = institution.NumberOfFloors;
editInstitution.NumberOfRoomsPerFloor = institution.NumberOfRoomsPerFloor;
editInstitution.Terrace = institution.Terrace;
editInstitution.Backyard = institution.Backyard;
editInstitution.AccessPointsForAmbulances = institution.AccessPointsForAmbulances;
editInstitution.AccessPointsForhandicaps = institution.AccessPointsForhandicaps;
context.SaveChanges();
Logging.LoggAction("AddInstitutionViewModel", "Info", "Succesfull edited institution");
return(institution.InstitutionId);
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
Logging.LoggAction("MasterAminViewModel", "Error", ex.ToString());
return(0);
}
}
public int AddClinicUser(ClinicUser user)
{
bool uniqueUserName = CheckUserName(user.Username);
bool uniqueUserIdNumber = CheckIDNumber(user.IDNumber);
string password = HashPasswordHelper.HashPassword(user.Password);
try
{
using (MedicaClinicEntities2 context = new MedicaClinicEntities2())
{
if (user.ClinicUserId == 0 && uniqueUserName && uniqueUserIdNumber)
{
ClinicUser newClinicUser = new ClinicUser();
newClinicUser.FullName = user.FullName;
newClinicUser.IDNumber = user.IDNumber;
newClinicUser.GenderId = user.GenderId;
newClinicUser.DateOfBirth = user.DateOfBirth;
newClinicUser.Citizenship = user.Citizenship;
newClinicUser.Username = user.Username;
newClinicUser.IsDeleted = false;
newClinicUser.RoleId = user.RoleId;
newClinicUser.Password = password;
context.ClinicUsers.Add(newClinicUser);
context.SaveChanges();
user.ClinicUserId = newClinicUser.ClinicUserId;
return(user.ClinicUserId);
}
else
{
ClinicUser editUser = (from p in context.ClinicUsers where p.ClinicUserId == user.ClinicUserId select p).First();
editUser.FullName = user.FullName;
editUser.IDNumber = user.IDNumber;
editUser.GenderId = user.GenderId;
editUser.DateOfBirth = user.DateOfBirth;
editUser.Citizenship = user.Citizenship;
editUser.Username = user.Username;
editUser.IsDeleted = false;
editUser.RoleId = user.RoleId;
editUser.ClinicUserId = user.ClinicUserId;
context.SaveChanges();
return(user.ClinicUserId);
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
Logging.LoggAction("MasterAminViewModel", "Error", ex.ToString());
return(0);
}
}
public int GetDoctorUniqueNumberByDoctorId(int doctorId)
{
try
{
using (MedicaClinicEntities2 context = new MedicaClinicEntities2())
{
int result = (from p in context.ClinicDoctors where p.ClinicUserId == doctorId select p.UniqueNumber).FirstOrDefault();
return(result);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exeption" + ex.Message.ToString());
return(0);
}
}
public int AddNewDoctor(ClinicDoctor user)
{
try
{
using (MedicaClinicEntities2 context = new MedicaClinicEntities2())
{
if (user.ClinicDoctorId == 0)
{
ClinicDoctor newClinicUser = new ClinicDoctor();
newClinicUser.ClinicUserId = user.ClinicUserId;
newClinicUser.UniqueNumber = user.UniqueNumber;
newClinicUser.BancAccount = user.BancAccount;
newClinicUser.DepartmentId = user.DepartmentId;
newClinicUser.WorkShiftId = user.WorkShiftId;
newClinicUser.InChargeOfAdmission = user.InChargeOfAdmission;
newClinicUser.ClinicManagerId = user.ClinicManagerId;
context.ClinicDoctors.Add(newClinicUser);
context.SaveChanges();
user.ClinicDoctorId = newClinicUser.ClinicDoctorId;
return(user.ClinicDoctorId);
}
else
{
ClinicDoctor editClinicUser = (from p in context.ClinicDoctors where p.ClinicDoctorId == user.ClinicDoctorId select p).First();
editClinicUser.ClinicUserId = user.ClinicUserId;
editClinicUser.UniqueNumber = user.UniqueNumber;
editClinicUser.BancAccount = user.BancAccount;
editClinicUser.DepartmentId = user.DepartmentId;
editClinicUser.WorkShiftId = user.WorkShiftId;
editClinicUser.InChargeOfAdmission = user.InChargeOfAdmission;
editClinicUser.ClinicManagerId = user.ClinicManagerId;
editClinicUser.ClinicDoctorId = user.ClinicDoctorId;
context.SaveChanges();
Logging.LoggAction("AddDoctorViewModel", "Info", "Succesfull edited doctor");
return(user.ClinicDoctorId);
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
Logging.LoggAction("AddDoctorViweModel", "Error", ex.ToString());
return(0);
}
}
public List <Workshift> GetAllWorkshift()
{
try
{
using (MedicaClinicEntities2 context = new MedicaClinicEntities2())
{
List <Workshift> list = new List <Workshift>();
list = (from p in context.Workshifts select p).ToList();
return(list);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exeption" + ex.Message.ToString());
return(null);
}
}
public List <vwDoctor> GetAllDoctors()
{
try
{
using (MedicaClinicEntities2 context = new MedicaClinicEntities2())
{
List <vwDoctor> list = new List <vwDoctor>();
list = (from p in context.vwDoctors where p.IsDeleted == false select p).ToList();
return(list);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exeption" + ex.Message.ToString());
return(null);
}
}
public int GetAccesPointHandicaps()
{
int result = 0;
try
{
using (MedicaClinicEntities2 context = new MedicaClinicEntities2())
{
result = (from p in context.Institutions select p.AccessPointsForhandicaps).First();
return(result);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exep tion" + ex.Message.ToString());
}
return(result);
}
public bool DeleteUser(int userId)
{
try
{
using (MedicaClinicEntities2 context = new MedicaClinicEntities2())
{
ClinicUser resultToDelete = (from r in context.ClinicUsers where r.ClinicUserId == userId select r).First();
resultToDelete.IsDeleted = true;
context.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
Logging.LoggAction("DeleteUser", "Error", ex.ToString());
return(false);
}
}
public int AddNewManager(ClinicManager user)
{
try
{
using (MedicaClinicEntities2 context = new MedicaClinicEntities2())
{
if (user.ClinicManagerId == 0)
{
ClinicManager newClinicUser = new ClinicManager();
newClinicUser.ClinicUserId = user.ClinicUserId;
newClinicUser.ClinicFloor = user.ClinicFloor;
newClinicUser.MaxNumOfDoctorsSupervised = user.MaxNumOfDoctorsSupervised;
newClinicUser.MinNumOfRoomSupervised = user.MinNumOfRoomSupervised;
newClinicUser.NumberOfMistake = 0;
context.ClinicManagers.Add(newClinicUser);
context.SaveChanges();
user.ClinicManagerId = newClinicUser.ClinicManagerId;
return(user.ClinicManagerId);
}
else
{
ClinicManager editClinicUser = (from p in context.ClinicManagers where p.ClinicManagerId == user.ClinicManagerId select p).First();
editClinicUser.ClinicUserId = user.ClinicUserId;
editClinicUser.ClinicFloor = user.ClinicFloor;
editClinicUser.MinNumOfRoomSupervised = user.MinNumOfRoomSupervised;
editClinicUser.MaxNumOfDoctorsSupervised = user.MaxNumOfDoctorsSupervised;
editClinicUser.NumberOfMistake = user.NumberOfMistake;
editClinicUser.ClinicManagerId = user.ClinicManagerId;
context.SaveChanges();
Logging.LoggAction("AddManagerViewModel", "Info", "Succesfull edited manager");
return(user.ClinicManagerId);
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
Logging.LoggAction("AddManagerViweModel", "Error", ex.ToString());
return(0);
}
}
public ClinicUser LoginUser(string username, string password)
{
password = HashPasswordHelper.HashPassword(password);
try
{
using (MedicaClinicEntities2 context = new MedicaClinicEntities2())
{
ClinicUser user = (from d in context.ClinicUsers
where d.Username.Equals(username)
where d.Password.Equals(password)
where d.IsDeleted == false
select d).FirstOrDefault();
return(user);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public int AddNewMaintainance(ClinicMaintenance user)
{
try
{
using (MedicaClinicEntities2 context = new MedicaClinicEntities2())
{
if (user.ClinicMaintenanceId == 0)
{
ClinicMaintenance newClinicUser = new ClinicMaintenance();
newClinicUser.ClinicUserId = user.ClinicUserId;
newClinicUser.PermissionToExpandClinic = user.PermissionToExpandClinic;
newClinicUser.ResponsibleForAccessOfHandicaps = user.ResponsibleForAccessOfHandicaps;
newClinicUser.ResponsibleForVehicleAccessibility = user.ResponsibleForAccessOfHandicaps;
context.ClinicMaintenances.Add(newClinicUser);
context.SaveChanges();
user.ClinicMaintenanceId = newClinicUser.ClinicMaintenanceId;
return(user.ClinicMaintenanceId);
}
else
{
ClinicMaintenance editClinicUser = (from p in context.ClinicMaintenances where p.ClinicMaintenanceId == user.ClinicMaintenanceId select p).First();
editClinicUser.ClinicUserId = user.ClinicUserId;
editClinicUser.PermissionToExpandClinic = user.PermissionToExpandClinic;
editClinicUser.ResponsibleForAccessOfHandicaps = user.ResponsibleForAccessOfHandicaps;
editClinicUser.ResponsibleForVehicleAccessibility = user.ResponsibleForVehicleAccessibility;
editClinicUser.ClinicMaintenanceId = user.ClinicMaintenanceId;
context.SaveChanges();
Logging.LoggAction("AddMaintainancViewModel", "Info", "Succesfull edited maintenance");
return(user.ClinicMaintenanceId);
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
Logging.LoggAction("AddManagerViweModel", "Error", ex.ToString());
return(0);
}
}
public int AddNewPatient(ClinicPatient user)
{
try
{
using (MedicaClinicEntities2 context = new MedicaClinicEntities2())
{
if (user.ClinicPatientId == 0)
{
ClinicPatient newClinicUser = new ClinicPatient();
newClinicUser.ClinicUserId = user.ClinicUserId;
newClinicUser.InsuranceNumber = user.InsuranceNumber;
newClinicUser.InsuranceExpirationDate = user.InsuranceExpirationDate;
newClinicUser.UniqueDoctorNumber = user.UniqueDoctorNumber;
context.ClinicPatients.Add(newClinicUser);
context.SaveChanges();
user.ClinicPatientId = newClinicUser.ClinicPatientId;
return(user.ClinicPatientId);
}
else
{
ClinicPatient editClinicUser = (from p in context.ClinicPatients where p.ClinicPatientId == user.ClinicPatientId select p).First();
editClinicUser.ClinicUserId = user.ClinicUserId;
editClinicUser.InsuranceNumber = user.InsuranceNumber;
editClinicUser.InsuranceExpirationDate = user.InsuranceExpirationDate;
editClinicUser.UniqueDoctorNumber = user.UniqueDoctorNumber;
editClinicUser.ClinicPatientId = user.ClinicPatientId;
context.SaveChanges();
Logging.LoggAction("AddPatientViewModel", "Info", "Succesfull edited patient");
return(user.ClinicPatientId);
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
Logging.LoggAction("AddPatientIdViweModel", "Error", ex.ToString());
return(0);
}
}
public bool?FindeInstitutionByUser(int UserId)
{
try
{
using (MedicaClinicEntities2 context = new MedicaClinicEntities2())
{
Institution institution = (from p in context.Institutions where p.ClinicUserId == UserId select p).FirstOrDefault();
if (institution != null)
{
return(true);
}
else
{
return(false);
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exeption" + ex.Message.ToString());
return(null);
}
}
public bool CheckInsuranceNumber(int insuranceNumber)
{
try
{
using (MedicaClinicEntities2 context = new MedicaClinicEntities2())
{
ClinicPatient clinicUser = (from d in context.ClinicPatients where d.InsuranceNumber == insuranceNumber select d).FirstOrDefault();
if (clinicUser != null)
{
return(false);
}
else
{
return(true);
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(false);
}
}
public bool CheckBancAccount(long bancAccount)
{
try
{
using (MedicaClinicEntities2 context = new MedicaClinicEntities2())
{
ClinicDoctor clinicUser = (from d in context.ClinicDoctors where d.BancAccount == bancAccount select d).FirstOrDefault();
if (clinicUser != null)
{
return(false);
}
else
{
return(true);
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(false);
}
}
public bool CheckUserName(string username)
{
try
{
using (MedicaClinicEntities2 context = new MedicaClinicEntities2())
{
ClinicUser clinicUser = (from d in context.ClinicUsers where d.Username == username where d.IsDeleted == false select d).FirstOrDefault();
if (clinicUser != null)
{
return(false);
}
else
{
return(true);
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(false);
}
}
