public static void Initialize(ClinicContext context) { if (!context.Patients.Any()) { context.Patients.AddRange( new Patient { FirstName = "Dauren", LastName = "Dossymbek", Address = "18/1 Syganak str. Apt. 376, Astana, Kazakhstan", }, new Patient { FirstName = "Frank", LastName = "Collins", Address = "401 Ringgold Rd. Apt. 400, Brownsville, Texas", }, new Patient { FirstName = "Anton", LastName = "Gribovskiy", Address = "34 University blvd Apt. 78, Edinburg, Texas", } ); context.SaveChanges(); } }
public AppliedDiagnosController(ClinicContext context) { _db = new SQLRepository <AppliedDiagnos>(context); _diagdb = new SQLRepository <Diagnos>(context); _appdb = new SQLRepository <Appointment>(context); _context = context; }
public List <int> SeedPatients(ClinicContext context) { Random random = new Random(); List <Patient> seedPatients = new List <Patient>(); seedPatients.Add(new Patient { FirstName = "Pedro", MiddleName = "Paricio", LastName = "Panzon", SecondLastName = "Picapiedra", DocumentID = "987654321", Email = "*****@*****.**", BloodType = (BloodType)random.Next(0, Enum.GetNames(typeof(BloodType)).Length), EnrollmentDate = DateTime.Now }); seedPatients.Add(new Patient { FirstName = "Juliana", MiddleName = "Solaris", LastName = "Nueva", SecondLastName = "Dehli", DocumentID = "11223344556", Email = "*****@*****.**", BloodType = (BloodType)random.Next(0, Enum.GetNames(typeof(BloodType)).Length), EnrollmentDate = DateTime.Now }); seedPatients.Add(new Patient { FirstName = "Pablo", MiddleName = "Clavo", LastName = "Clavito", SecondLastName = "Martillo", DocumentID = "99887766554", Email = "*****@*****.**", BloodType = (BloodType)random.Next(0, Enum.GetNames(typeof(BloodType)).Length), EnrollmentDate = DateTime.Now }); seedPatients.Add(new Patient { FirstName = "Kenny", MiddleName = "Bell", LastName = "Maribelle", SecondLastName = "Lit", DocumentID = "123987654", Email = "*****@*****.**", BloodType = (BloodType)random.Next(0, Enum.GetNames(typeof(BloodType)).Length), EnrollmentDate = DateTime.Now }); seedPatients.Add(new Patient { FirstName = "Diego", MiddleName = "Tortulio", LastName = "Parra", SecondLastName = "Ayala", DocumentID = "558822334", Email = "*****@*****.**", BloodType = (BloodType)random.Next(0, Enum.GetNames(typeof(BloodType)).Length), EnrollmentDate = DateTime.Now }); context.Patients.AddRange(seedPatients); context.SaveChanges(); return(context.Patients.Select(p => p.PatientId).ToList()); }
public void SeedAppointments(ClinicContext context, List <int> newPatients, List <string> newUsers) { Random random = new Random(); List <Appointment> seedAppointments = new List <Appointment>(); seedAppointments.Add(new Appointment { AppointmentDate = DateTime.Now.AddDays(1), AppointmentType = (AppointmentType)random.Next(0, Enum.GetNames(typeof(AppointmentType)).Length), PatientId = newPatients[random.Next(0, newPatients.Count)], UserId = newUsers[random.Next(0, newUsers.Count)] }); seedAppointments.Add(new Appointment { AppointmentDate = DateTime.Now.AddDays(3), AppointmentType = (AppointmentType)random.Next(0, Enum.GetNames(typeof(AppointmentType)).Length), PatientId = newPatients[random.Next(0, newPatients.Count)], UserId = newUsers[random.Next(0, newUsers.Count)] }); seedAppointments.Add(new Appointment { AppointmentDate = DateTime.Now.AddDays(5), AppointmentType = (AppointmentType)random.Next(0, Enum.GetNames(typeof(AppointmentType)).Length), PatientId = newPatients[random.Next(0, newPatients.Count)], UserId = newUsers[random.Next(0, newUsers.Count)] }); seedAppointments.Add(new Appointment { AppointmentDate = DateTime.Now.AddDays(7), AppointmentType = (AppointmentType)random.Next(0, Enum.GetNames(typeof(AppointmentType)).Length), PatientId = newPatients[random.Next(0, newPatients.Count)], UserId = newUsers[random.Next(0, newUsers.Count)] }); seedAppointments.Add(new Appointment { AppointmentDate = DateTime.Now.AddDays(11), AppointmentType = (AppointmentType)random.Next(0, Enum.GetNames(typeof(AppointmentType)).Length), PatientId = newPatients[random.Next(0, newPatients.Count)], UserId = newUsers[random.Next(0, newUsers.Count)] }); context.Appointments.AddRange(seedAppointments); context.SaveChanges(); }
public ActionResult Orders() { using (ClinicContext db = new ClinicContext()) { var orders = db.Orders .Where(o => o.Date.Year == DateTime.Now.Year) .Select(o => new { date = o.Date, value = db.OrderLines.Where(ol => ol.OrderID == o.ID).Sum(ol => ol.Quantity * ol.Price) }) .ToList(); return(Json( orders.GroupBy(o => o.date.Month) .Select(o => new { month = o.Key, value = o.Sum(x => x.value) }) .OrderBy(o => o.month) .ToList(), JsonRequestBehavior.AllowGet )); } }
private void ClinicForm_Load(object sender, EventArgs e) { using (ClinicContext ctx = new ClinicContext()) { if (!ctx.Database.Exists()) { MessageBox.Show("Possibly this is the first time the application is being used\n" + "You need to load the data from a csv file\n\n" + "GO to Menu bar -> File -> Open ( To open your csv file)\n" + "The file name: ModifiedHealthCare_2\nThe file location: In the same folder of the application"); } } SetupMenu(); // Setup menu when from load //Trigger Events for menu bar OpenMenu.Click += MenuActionHandler; AboutMenu.Click += MenuActionHandler; QuitMenu.Click += MenuActionHandler; // Call the even for each form on load form CreateProfileButton.Click += LoadForm; BookAppointmentButton.Click += LoadForm; EditAppointmentButton.Click += LoadForm; DoctorListButton.Click += LoadForm; CloseButton.Click += ExitButton_Click; }
private int IsAppointment() // ------- this method is to check that the new date and time the user is setting doesn't exit in the database. { int c = 0; try { using (var ctx = new ClinicContext()) { string appointmentTime = AppointmentGridView.Rows[0].Cells[4].Value.ToString(); //geting the appointment time and date string appointmentDate = AppointmentGridView.Rows[0].Cells[3].Value.ToString(); //query to check if doctor is available on the entered date and time var appointment = from doct in ctx.Doctors from appt in ctx.Appointments where appt.DoctorsId == doct.DoctorsId && appointmentDate == appt.AppointmentsDate && appointmentTime == appt.AppointmentsTime select appt; foreach (var item in appointment) { MessageBox.Show("Sorry, Appointment is not available for this date and time!"); c = 1; ChangesSavedLabel.Text = "Please check the appointment date and time"; break; } } } catch (Exception ex) { Console.WriteLine(ex.StackTrace); MessageBox.Show("There is appointment to be edited"); } return(c); }
public void Setup() { var doc = new List <Patient> { new Patient { PatientId = 1, Name = "Dummy 1", Email = "DD1", Password = "******" }, new Patient { PatientId = 2, Name = "Dummy 2", Email = "DD2", Password = "******" }, new Patient { PatientId = 3, Name = "Dummy 3", Email = "DD3", Password = "******" } }; var docdata = doc.AsQueryable(); var mockSet = new Mock <DbSet <Patient> >(); mockSet.As <IQueryable <Patient> >().Setup(m => m.Provider).Returns(docdata.Provider); mockSet.As <IQueryable <Patient> >().Setup(m => m.Expression).Returns(docdata.Expression); mockSet.As <IQueryable <Patient> >().Setup(m => m.ElementType).Returns(docdata.ElementType); mockSet.As <IQueryable <Patient> >().Setup(m => m.GetEnumerator()).Returns(docdata.GetEnumerator()); var mockContext = new Mock <ClinicContext>(); mockContext.Setup(c => c.Patients).Returns(mockSet.Object); db = mockContext.Object; }
public TruncatedPatient GetPatientById(int id) { using (ClinicContext context = ClinicContextProvider.GetContext()) { return(truncatedPatientMapper.Map(context.Patients.Where(x => x.Id == id).FirstOrDefault())); } }
private void CancelAppointment() //0-------method to cancel an appointment { try { int currentAppointmentId = Convert.ToInt32(PatientDatagridViewLookup.Rows[0].Cells[0].Value); using (ClinicContext clinicCtx = new ClinicContext()) { Appointments appointment = (from a in clinicCtx.Appointments where a.AppointmentId == currentAppointmentId select a).FirstOrDefault(); clinicCtx.Appointments.Remove(appointment); clinicCtx.SaveChanges(); ChangesSavedLabel.Visible = true; ChangesSavedLabel.Text = "The Appointment was successfully Removed!"; CancelAppointmentButton.Enabled = false; } } catch (Exception ex) { Console.WriteLine(ex.StackTrace); MessageBox.Show("No appointment to be cancelled"); } }
public IEnumerable <TruncatedPatient> GetAllPatients() { using (ClinicContext context = ClinicContextProvider.GetContext()) { return(context.Patients.ToList().Select(x => truncatedPatientMapper.Map(x))); } }
public ActionResult Sales() { using (ClinicContext db = new ClinicContext()) { var sales = db.Sales .Where(s => s.Date.Year == DateTime.Now.Year) .Select(s => new { date = s.Date, value = db.SaleLines.Where(sl => sl.SaleID == s.ID).Sum(sl => sl.Quantity * sl.Price) }) .ToList(); return(Json( sales.GroupBy(s => s.date.Month) .Select(s => new { month = s.Key, value = s.Sum(x => x.value) }) .OrderBy(s => s.month) .ToList(), JsonRequestBehavior.AllowGet )); } }
public ActionResult Items() { using (ClinicContext db = new ClinicContext()) { var items = db.Items .Select(i => new { name = i.Name, value = i.Count }) .ToList(); return(Json( items.GroupBy(i => i.name) .Select(i => new { name = i.Key, value = i.Sum(x => x.value) }) .OrderBy(i => i.name) .ToList(), JsonRequestBehavior.AllowGet )); } }
private void DoctorsListForm_Load(object sender, EventArgs e) { clinicCtx = new ClinicContext(); //Clinic Context instantiate as global for widely use PopulateDoctorListBox(); // Populate the doctor name in the list box //Set up the list view for the fitler SetUpListViewHeader(TimeFilterListView, "Time"); //<-------- for TIME filter SetUpListViewHeader(GenderFilterListView, "Gender"); //<-------- for GENDER filter //Populate the time filter list view PopulateTimeListView(); // Populate the gender filter list view PopulateGenderListView(); // Set check for all the items in gender filter listview SetItemListCheck(GenderFilterListView, "check"); // Set uncheck for all the items in gender filter listview SetItemListCheck(TimeFilterListView, "uncheck"); // Collect the checked item in the filter initially when the doctor form load checkedGender = GetCheckFilterItem(GenderFilterListView); checkedTime = GetCheckFilterItem(TimeFilterListView); EventHandlerToggle(true); ExitButton.Click += CloseForm; //Close form the exit click }
private List <string> SeedUsers(ClinicContext context) { List <(User user, String password)> seedUsers = new List <(User, string)>(); seedUsers.Add(new(new User { UserName = "******", Email = "*****@*****.**" }, "GAP123!")); seedUsers.Add(new(new User { UserName = "******", Email = "*****@*****.**" }, "GAP123!")); seedUsers.Add(new(new User { UserName = "******", Email = "*****@*****.**" }, "GAP123!")); seedUsers.Add(new(new User { UserName = "******", Email = "*****@*****.**" }, "GAP123!")); seedUsers.Add(new(new User { UserName = "******", Email = "*****@*****.**" }, "GAP123!")); var userStore = new UserStore <User>(context); var userManager = new UserManager <User>(userStore); foreach ((User, String)tuple in seedUsers) { userManager.Create(tuple.Item1, tuple.Item2); } context.SaveChanges(); return(context.Users.Select(sU => sU.Id).ToList()); }
public IdentityService(UserManager <IdentityUser> userManager, JwtSettings jwtSettings, TokenValidationParameters tokenValidationParameters, ClinicContext context, RoleManager <IdentityRole> roleManager) { _userManager = userManager; _jwtSettings = jwtSettings; _tokenValidationParameters = tokenValidationParameters; _context = context; _roleManager = roleManager; }
public static void ExecuteWithoutGuid(Action <ClinicContext> action) { using (var db = new ClinicContext()) { db.Database.Connection.Open(); action(db); } }
//public static void Execute(Action<ClinicContext> func, Guid guid) //{ // if (!ValidationService.IsValidToken(guid)) // throw new UnauthorizedAccessException("Доступ запрещен"); // using (var db = new ClinicContext()) // { // db.Database.Connection.Open(); // func(db); // } //} public static T ExecuteWithoutGuid <T>(Func <ClinicContext, T> func) { using (var db = new ClinicContext()) { db.Database.Connection.Open(); return(func(db)); } }
public TruncatedTreatPlan GetTreatPlan(int id) { using (ClinicContext context = ClinicContextProvider.GetContext()) { var y = context.TreatPlans.Where(x => x.Id == id).Select(x => new { x, x.Disease, x.Doctor, x.Medication, x.Patient }).SingleOrDefault(); y.x.Disease = y.Disease; y.x.Doctor = y.Doctor; y.x.Medication = y.Medication; y.x.Patient = y.Patient; return(truncatedTreatPlanMapper.Map(y.x)); } }
public AppointmentsController(ClinicContext context) { _db = new SQLRepository <Appointment>(context); _patdb = new SQLRepository <Patient>(context); _docDb = new SQLRepository <Doctor>(context); _diagdb = new SQLRepository <Diagnos>(context); _appDiagdb = new SQLRepository <AppliedDiagnos>(context); this.context = context; }
public IEnumerable <TruncatedTreatPlan> GetPatientTreatPlans(int id) { using (ClinicContext context = ClinicContextProvider.GetContext()) { var y = context.TreatPlans.Where(x => x.Patient_Id == id).Select(x => new { x, x.Disease, x.Doctor, x.Medication, x.Patient }).ToList(); y.ForEach(x => { x.x.Disease = x.Disease; x.x.Doctor = x.Doctor; x.x.Medication = x.Medication; x.x.Patient = x.Patient; }); var res = y.Select(t => truncatedTreatPlanMapper.Map(t.x)); return(res); } }
public AppointmentRepositoryTest() { ClinicContext context = new ClinicContext(); this.repository = new AppointmentRepository(context); context.Appointments.Add(new Appointment() { Date = new DateTime(2018, 11, 11, 11, 11, 11) }); }
public static T Execute <T>(Func <ClinicContext, T> func, Guid guid) { if (!ValidationService.IsValidToken(guid)) { throw new UnauthorizedAccessException("Доступ запрещен"); } using (var db = new ClinicContext()) { db.Database.Connection.Open(); return(func(db)); } }
public override string[] GetUsersInRole(string roleName) { _db = new ClinicContext(); var role = _db.Roles.Include(u => u.Users).FirstOrDefault(u => u.Name == roleName); if (role != null) { return (role.Users.Select(x => x.NT).ToArray()); } return(new string[] {}); }
public override string[] GetRolesForUser(string username) { _db = new ClinicContext(); var user = _db.Users.Include(u => u.Roles).FirstOrDefault(u => u.NT == username); if (user != null) { return (user.Roles.Select( x => x.Name).ToArray()); } return(new string[] { }); }
private void BookAppointmentForm_Load(object sender, EventArgs e) { //create new context object when the form loads ctx = new ClinicContext(); ctx.Patients.Add(newPatient); ctx.Doctors.Add(newDoctor); //turn event handler on BookButton.Click += CreateNewAppointment; ExitButton.Click += CloseForm; //change combobox style to make it read only SelectDoctorComboBox.DropDownStyle = ComboBoxStyle.DropDownList; AppointmentTimeBoxcomboBox.DropDownStyle = ComboBoxStyle.DropDownList; }
public override bool IsUserInRole(string username, string roleName) { _db = new ClinicContext(); var user = _db.Users.Include(u => u.Roles).FirstOrDefault(u => u.NT == username); if (user == null) { return(false); } return (user.Roles.Any( x => x.Name == roleName)); }
public void AnimalRepository_Add_NotName_Exception() { //Arrange (Preparación) ClinicContext context = new ClinicContext(); IRepository <Animal> repository = new AnimalRepository(context); Animal animal = new Animal() { Id = 1 }; //Act (Ejecución) Action testCode = () => repository.Add(animal); //Assert (Comprobación) Assert.Throws <ArgumentNullException>(testCode); }
public override string[] FindUsersInRole(string roleName, string usernameToMatch) { _db = new ClinicContext(); if (string.IsNullOrEmpty(usernameToMatch)) { return (_db.Roles.Include(r => r.Users).Where(x => x.Name == roleName).SelectMany( x => x.Users).Select(x => x.NT). ToArray()); } return (_db.Roles.Include(r => r.Users).Where(x => x.Name == roleName).SelectMany( x => x.Users).Where(x => x.NT.Contains(usernameToMatch)).Select(x => x.NT). ToArray()); }
protected void Application_AcquireRequestState(object sender, EventArgs e) { //It's important to check whether session object is ready if (HttpContext.Current.Session == null) { return; } CultureInfo ci; // A retirer pour Windows Authentification if (Session["Language"] == null) { var db = new ClinicContext(); var user = db.Users.First(x => x.NT == User.Identity.Name); if (!string.IsNullOrEmpty(user.Language.Name)) { Session["Language"] = user.Language.Name; ci = new CultureInfo(user.Language.Name); } else { var langName = "en"; //Try to get values from Accept lang HTTP header if (HttpContext.Current.Request.UserLanguages != null && HttpContext.Current.Request.UserLanguages.Length != 0) { //Gets accepted list langName = HttpContext.Current.Request.UserLanguages[0].Substring(0, 2); } ci = new CultureInfo(langName); user.Language.Name = ci.Name; Session["Language"] = ci.Name; } db.SaveChanges(User.Identity.Name); } else { ci = new CultureInfo((string)Session["Language"]); } Thread.CurrentThread.CurrentUICulture = ci; Thread.CurrentThread.CurrentCulture = CultureInfo.CreateSpecificCulture(ci.Name); }