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