public static Queue <tblClinicMaintenance> GetMaintenanceQueue() { try { using (MedicalInstitutionEntities4 context = new MedicalInstitutionEntities4()) { List <tblClinicMaintenance> list = GetMaintenanceList(); if (list.Count != 0) { Queue <tblClinicMaintenance> queue = new Queue <tblClinicMaintenance>(); for (int i = 0; i < list.Count; i++) { queue.Enqueue(list[i]); } return(queue); } return(null); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
public static tblClinicMaintenance AddMaintenance(tblClinicMaintenance m) { try { using (MedicalInstitutionEntities4 context = new MedicalInstitutionEntities4()) { if (m.maintenanceId == 0) { //add tblClinicMaintenance newM = new tblClinicMaintenance(); newM.name = m.name; newM.permissionToExpand = m.permissionToExpand; newM.accessibilityOfInvalids = m.accessibilityOfInvalids; context.tblClinicMaintenances.Add(newM); context.SaveChanges(); m.maintenanceId = newM.maintenanceId; return(m); } else { tblClinicMaintenance mToEdit = (from x in context.tblClinicMaintenances where x.maintenanceId == m.maintenanceId select x).FirstOrDefault(); mToEdit.name = m.name; mToEdit.accessibilityOfInvalids = m.accessibilityOfInvalids; mToEdit.permissionToExpand = m.permissionToExpand; context.SaveChanges(); return(m); } } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString()); return(null); } }
public static tblClinicAdministrator AddAdministrator(tblClinicAdministrator admin) { try { using (MedicalInstitutionEntities4 context = new MedicalInstitutionEntities4()) { if (admin.adminId == 0) { //add tblClinicAdministrator newAdmin = new tblClinicAdministrator(); //newAdmin.instituteId = editClinic.instituteId; newAdmin.userId = admin.userId; context.tblClinicAdministrators.Add(newAdmin); context.SaveChanges(); admin.adminId = newAdmin.adminId; return(admin); } else { tblClinicAdministrator adminToEdit = (from x in context.tblClinicAdministrators where x.adminId == admin.adminId select x).FirstOrDefault(); adminToEdit.userId = admin.userId; adminToEdit.instituteId = admin.instituteId; context.SaveChanges(); return(admin); } } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString()); return(null); } }
public static tblInstitute AddInstitute(tblInstitute clinic) { try { using (MedicalInstitutionEntities4 context = new MedicalInstitutionEntities4()) { if (clinic.instituteId == 0) { //add tblInstitute newInstitute = new tblInstitute(); newInstitute.instituteOwner = clinic.instituteOwner; newInstitute.name = clinic.name; newInstitute.numberOfAccessPointsForInvalids = clinic.numberOfAccessPointsForInvalids; newInstitute.numberOfAmbulanceAccessPoints = clinic.numberOfAmbulanceAccessPoints; newInstitute.numberOfFloors = clinic.numberOfFloors; newInstitute.numberOfRooms = clinic.numberOfRooms; newInstitute.terrace = clinic.terrace; newInstitute.yard = clinic.yard; newInstitute.address = clinic.address; newInstitute.constructionDate = clinic.constructionDate; context.tblInstitutes.Add(newInstitute); context.SaveChanges(); clinic.instituteId = newInstitute.instituteId; return(clinic); } else { tblInstitute instituteToEdit = (from x in context.tblInstitutes where x.instituteId == clinic.instituteId select x).FirstOrDefault(); instituteToEdit.address = clinic.address; instituteToEdit.constructionDate = clinic.constructionDate; instituteToEdit.instituteOwner = clinic.instituteOwner; instituteToEdit.name = clinic.name; instituteToEdit.numberOfAccessPointsForInvalids = clinic.numberOfAccessPointsForInvalids; instituteToEdit.numberOfAmbulanceAccessPoints = clinic.numberOfAmbulanceAccessPoints; instituteToEdit.numberOfFloors = clinic.numberOfFloors; instituteToEdit.numberOfRooms = clinic.numberOfRooms; instituteToEdit.terrace = clinic.terrace; instituteToEdit.yard = clinic.yard; instituteToEdit.instituteOwner = clinic.instituteOwner; context.SaveChanges(); return(clinic); } } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString()); return(null); } }
public static tblClinicDoctor DoctorById(int id) { try { using (MedicalInstitutionEntities4 context = new MedicalInstitutionEntities4()) { tblClinicDoctor result = (from x in context.tblClinicDoctors where x.doctorId == id select x).FirstOrDefault(); return(result); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception " + ex.Message.ToString()); return(null); } }
public static tblInstitute GetInstitute() { try { using (MedicalInstitutionEntities4 context = new MedicalInstitutionEntities4()) { tblInstitute result = (from x in context.tblInstitutes select x).FirstOrDefault(); return(result); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception " + ex.Message.ToString()); return(null); } }
public static bool UsedCardNumber(string number) { try { using (MedicalInstitutionEntities4 context = new MedicalInstitutionEntities4()) { bool b = (from x in context.tblClinicPatients where x.cardNumber == number select x).Any(); return(b); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception " + ex.Message.ToString()); return(true); } }
public static bool UsedAccount(string account) { try { using (MedicalInstitutionEntities4 context = new MedicalInstitutionEntities4()) { bool b = (from x in context.tblClinicDoctors where x.account == account select x).Any(); return(b); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception " + ex.Message.ToString()); return(true); } }
public static bool UsedUsername(string name) { try { using (MedicalInstitutionEntities4 context = new MedicalInstitutionEntities4()) { bool b = (from x in context.tblUsers where x.username == name select x).Any(); return(b); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception " + ex.Message.ToString()); return(true); } }
public static bool InstituteExist() { try { using (MedicalInstitutionEntities4 context = new MedicalInstitutionEntities4()) { bool r = (from x in context.tblInstitutes select x).Any(); return(r); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(false); } }
//null or return patient public static tblClinicPatient isPatient(tblUser e) { try { using (MedicalInstitutionEntities4 context = new MedicalInstitutionEntities4()) { tblClinicPatient result = (from x in context.tblClinicPatients where x.userId == e.userId select x).FirstOrDefault(); return(result); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception " + ex.Message.ToString()); return(null); } }
public static tblUser GetUser(string username, string password) { try { using (MedicalInstitutionEntities4 context = new MedicalInstitutionEntities4()) { tblUser result = (from x in context.tblUsers where x.username == username && x.password == password select x).FirstOrDefault(); return(result); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception " + ex.Message.ToString()); return(null); } }
public static void DeleteDoctor(tblClinicDoctor doctor) { try { using (MedicalInstitutionEntities4 context = new MedicalInstitutionEntities4()) { tblClinicDoctor toDelete = (from u in context.tblClinicDoctors where u.doctorId == doctor.doctorId select u).First(); context.tblClinicDoctors.Remove(toDelete); context.SaveChanges(); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); } }
public static void DeleteMaintenance(tblClinicMaintenance maintenance) { try { using (MedicalInstitutionEntities4 context = new MedicalInstitutionEntities4()) { tblClinicMaintenance toDelete = (from u in context.tblClinicMaintenances where u.maintenanceId == maintenance.maintenanceId select u).First(); context.tblClinicMaintenances.Remove(toDelete); context.SaveChanges(); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); } }
public static List <tblClinicMaintenance> GetMaintenanceList() { try { using (MedicalInstitutionEntities4 context = new MedicalInstitutionEntities4()) { List <tblClinicMaintenance> list = new List <tblClinicMaintenance>(); list = (from x in context.tblClinicMaintenances select x).ToList(); return(list); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
public static tblUser AddUser(tblUser user) { try { using (MedicalInstitutionEntities4 context = new MedicalInstitutionEntities4()) { if (user.userId == 0) { //add tblUser newUser = new tblUser(); newUser.username = user.username; newUser.password = user.password; newUser.ICnumber = user.ICnumber; newUser.gender = user.gender; newUser.dateOfBirth = user.dateOfBirth; newUser.citizenship = user.citizenship; newUser.fullname = user.fullname; context.tblUsers.Add(newUser); context.SaveChanges(); user.userId = newUser.userId; return(user); } else { tblUser userToEdit = (from x in context.tblUsers where x.userId == user.userId select x).FirstOrDefault(); userToEdit.username = user.username; userToEdit.password = user.password; userToEdit.gender = user.gender; userToEdit.fullname = user.fullname; userToEdit.citizenship = user.citizenship; userToEdit.dateOfBirth = user.dateOfBirth; userToEdit.ICnumber = user.ICnumber; context.SaveChanges(); return(user); } } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString()); return(null); } }
public static tblClinicDoctor AddDoctor(tblClinicDoctor doctor) { try { using (MedicalInstitutionEntities4 context = new MedicalInstitutionEntities4()) { if (doctor.doctorId == 0) { //add tblClinicDoctor newDoctor = new tblClinicDoctor(); newDoctor.account = doctor.account; newDoctor.admissionOfPatients = doctor.admissionOfPatients; newDoctor.department = doctor.department; newDoctor.managerId = doctor.managerId; newDoctor.shift = doctor.shift; newDoctor.userId = doctor.userId; context.tblClinicDoctors.Add(newDoctor); context.SaveChanges(); doctor.doctorId = newDoctor.doctorId; return(doctor); } else { tblClinicDoctor doctorToEdit = (from x in context.tblClinicDoctors where x.doctorId == doctor.doctorId select x).FirstOrDefault(); doctorToEdit.account = doctor.account; doctorToEdit.admissionOfPatients = doctor.admissionOfPatients; doctorToEdit.department = doctor.department; doctorToEdit.managerId = doctor.managerId; doctorToEdit.userId = doctor.userId; doctorToEdit.shift = doctor.shift; context.SaveChanges(); return(doctor); } } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString()); return(null); } }
public static tblClinicManager AddManager(tblClinicManager manager) { try { using (MedicalInstitutionEntities4 context = new MedicalInstitutionEntities4()) { if (manager.managerId == 0) { //add tblClinicManager newManager = new tblClinicManager(); newManager.floorNumber = manager.floorNumber; newManager.maxNumberOfDoctors = manager.maxNumberOfDoctors; newManager.minNumberOfRooms = manager.minNumberOfRooms; newManager.numberOfOmissions = manager.numberOfOmissions; newManager.userId = manager.userId; context.tblClinicManagers.Add(newManager); context.SaveChanges(); manager.managerId = newManager.managerId; return(manager); } else { tblClinicManager managerToEdit = (from x in context.tblClinicManagers where x.managerId == manager.managerId select x).FirstOrDefault(); managerToEdit.floorNumber = manager.floorNumber; managerToEdit.maxNumberOfDoctors = manager.maxNumberOfDoctors; managerToEdit.minNumberOfRooms = manager.minNumberOfRooms; managerToEdit.numberOfOmissions = manager.numberOfOmissions; managerToEdit.userId = manager.userId; context.SaveChanges(); return(manager); } } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString()); return(null); } }
public static tblClinicPatient AddPatient(tblClinicPatient patient) { try { using (MedicalInstitutionEntities4 context = new MedicalInstitutionEntities4()) { if (patient.patientId == 0) { //add tblClinicPatient newPatient = new tblClinicPatient(); newPatient.expiryDate = patient.expiryDate; newPatient.cardNumber = patient.cardNumber; newPatient.userId = patient.userId; context.tblClinicPatients.Add(newPatient); context.SaveChanges(); patient.patientId = newPatient.patientId; return(patient); } else { tblClinicPatient patientToEdit = (from x in context.tblClinicPatients where x.patientId == patient.patientId select x).FirstOrDefault(); patientToEdit.expiryDate = patient.expiryDate; patientToEdit.hasVirus = patient.hasVirus; patientToEdit.userId = patient.userId; patientToEdit.cardNumber = patient.cardNumber; patientToEdit.doctorId = patient.doctorId; context.SaveChanges(); return(patient); } } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString()); return(null); } }