Example #1
0
        public static void DeleteInsurance(int insID, ProjectContext db)
        {
            Insurance insToDelete = db.Insurances.FirstOrDefault(i => i.InsuranceId == insID);

            db.Remove(insToDelete);
            db.SaveChanges();
            return;
        }
Example #2
0
        public static Insurance EditInsurance(Insurance editedIns, ProjectContext db)
        {
            Insurance insToEdit = db.Insurances.FirstOrDefault(i => i.InsuranceId == editedIns.InsuranceId);

            insToEdit.Name      = editedIns.Name;
            insToEdit.UpdatedAt = DateTime.Now;
            db.SaveChanges();
            return(db.Insurances
                   .Include(i => i.Customers)
                   .Include(i => i.Practitioners)
                   .FirstOrDefault(i => i.InsuranceId == insToEdit.InsuranceId));
        }
Example #3
0
        public static bool CreateCustomers(ProjectContext db)
        {
            CreateInsurances(db);
            Customer newCust = new Customer();

            newCust.Address1  = "123 Fake St";
            newCust.Address2  = "Apt 4";
            newCust.City      = "Boston";
            newCust.Email     = "*****@*****.**";
            newCust.FirstName = "Bob";
            newCust.LastName  = "Barker";
            newCust.Notes     = "this guy always cancels";
            newCust.Phone     = "1234567890";
            newCust.State     = "MA";
            newCust.Zip       = 02115;
            Insurance newCustInsurance = new Insurance();

            newCust.InsuranceId   = 2;
            newCust.Insurance     = newCustInsurance;
            newCustInsurance.Name = "Aetna";
            Customer newCust2 = new Customer();

            newCust2.Address1  = "4324 bleh ave";
            newCust2.Address2  = "Apt 1";
            newCust2.City      = "San Francisco";
            newCust2.Email     = "*****@*****.**";
            newCust2.FirstName = "Mary";
            newCust2.LastName  = "Sue";
            newCust2.Notes     = "so friendly!";
            newCust2.Phone     = "9087654321";
            newCust2.State     = "CA";
            newCust2.Zip       = 94611;
            Insurance newCust2Insurance = new Insurance();

            newCust2.InsuranceId   = 2;
            newCust2.Insurance     = newCust2Insurance;
            newCust2Insurance.Name = "Premera";

            if (db.Customers.Any(c => c.CustomerId == newCust.CustomerId))
            { //Name already in use
                return(false);
            }
            else
            {
                db.Add(newCust);
                db.Add(newCust2);
                db.SaveChanges();
            }
            return(true);
        }
Example #4
0
        public static void GenerateFakeContent(ProjectContext dbContext)
        {
            Insurance newIns = new Insurance();

            newIns.Name = "Cash";
            dbContext.Add(newIns);
            dbContext.SaveChanges();
            Insurance newIns2 = new Insurance();

            newIns2.Name = "Blue Cross/Blue Shield";
            dbContext.Add(newIns2);
            dbContext.SaveChanges();
            Customer newCust = new Customer();

            newCust.Address1  = "123 Fake St";
            newCust.Address2  = "Apt 4";
            newCust.City      = "Boston";
            newCust.Email     = "*****@*****.**";
            newCust.FirstName = "Bob";
            newCust.LastName  = "Barker";
            newCust.Notes     = "this guy always cancels";
            newCust.Phone     = "1234567890";
            newCust.State     = "MA";
            newCust.Zip       = 02115;
            newCust.Insurance = newIns;
            dbContext.Add(newCust);
            dbContext.SaveChanges();
            Customer newCust2 = new Customer();

            newCust2.Address1  = "4324 bleh ave";
            newCust2.Address2  = "Apt 1";
            newCust2.City      = "San Francisco";
            newCust2.Email     = "*****@*****.**";
            newCust2.FirstName = "Mary";
            newCust2.LastName  = "Sue";
            newCust2.Notes     = "so friendly!";
            newCust2.Phone     = "9087654321";
            newCust2.State     = "CA";
            newCust2.Zip       = 94611;
            newCust2.Insurance = newIns2;
            dbContext.Add(newCust2);
            dbContext.SaveChanges();
            User pract1 = new User();

            pract1.Password  = "******"; // password hash for Password1!
            pract1.FirstName = "John";
            pract1.LastName  = "Smith";
            pract1.Role      = 1;
            pract1.UserName  = "******";
            dbContext.Add(pract1);
            dbContext.SaveChanges();
            User pract2 = new User();

            pract2.Password  = "******"; // password hash for Password1!
            pract2.FirstName = "Chris";
            pract2.LastName  = "Rodger";
            pract2.Role      = 1;
            pract2.UserName  = "******";
            dbContext.Add(pract2);
            dbContext.SaveChanges();
            User recep1 = new User();

            recep1.Password  = "******"; // password hash for Password1!
            recep1.FirstName = "Jane";
            recep1.LastName  = "Doe";
            recep1.Role      = 2;
            recep1.UserName  = "******";
            dbContext.Add(recep1);
            dbContext.SaveChanges();
            User recep2 = new User();

            recep2.Password  = "******"; // password hash for Password1!
            recep2.FirstName = "Jane";
            recep2.LastName  = "Doe";
            recep2.Role      = 2;
            recep2.UserName  = "******";
            dbContext.Add(recep2);
            dbContext.SaveChanges();
            Service serv1 = new Service();

            serv1.Name = "Deep Tissue Massage";
            dbContext.Add(serv1);
            dbContext.SaveChanges();
            Service serv2 = new Service();

            serv2.Name = "Foot Massage";
            dbContext.Add(serv2);
            dbContext.SaveChanges();
            Service serv3 = new Service();

            serv3.Name = "Accupuncture";
            dbContext.Add(serv3);
            dbContext.SaveChanges();

            //Create Rooms
            Room room1 = new Room();

            dbContext.Add(room1);
            dbContext.SaveChanges();
            Room room2 = new Room();

            dbContext.Add(room2);
            dbContext.SaveChanges();
            Room room3 = new Room();

            dbContext.Add(room3);
            dbContext.SaveChanges();
            Room room4 = new Room();

            dbContext.Add(room4);
            dbContext.SaveChanges();
            Room room5 = new Room();

            dbContext.Add(room5);
            dbContext.SaveChanges();
            Room room6 = new Room();

            dbContext.Add(room6);
            dbContext.SaveChanges();

            //Associate Rooms with Service
            List <Room> allRooms = new List <Room>()
            {
                room1, room2, room3, room4, room5, room6
            };
            List <Service> allServices = new List <Service>()
            {
                serv1, serv2, serv3
            };

            foreach (Room room in allRooms)
            {
                foreach (Service serv in allServices)
                {
                    RoomService rs = new RoomService();
                    rs.RoomId    = room.RoomId;
                    rs.ServiceId = serv.ServiceId;
                    dbContext.Add(rs);
                    dbContext.SaveChanges();
                }
            }
            dbContext.SaveChanges();

            //Associate Practitioners with Service
            PService ps = new PService();

            ps.ServiceId      = serv1.ServiceId;
            ps.PractitionerId = pract1.UserId;
            dbContext.Add(ps);
            dbContext.SaveChanges();
            PService ps2 = new PService();

            ps2.ServiceId      = serv2.ServiceId;
            ps2.PractitionerId = pract1.UserId;
            dbContext.Add(ps2);
            dbContext.SaveChanges();
            PService ps3 = new PService();

            ps3.ServiceId      = serv3.ServiceId;
            ps3.PractitionerId = pract1.UserId;
            dbContext.Add(ps3);
            dbContext.SaveChanges();
            PService ps4 = new PService();

            ps4.ServiceId      = serv2.ServiceId;
            ps4.PractitionerId = pract2.UserId;
            dbContext.Add(ps4);
            dbContext.SaveChanges();
            PService ps5 = new PService();

            ps5.ServiceId      = serv3.ServiceId;
            ps5.PractitionerId = pract2.UserId;
            dbContext.Add(ps5);
            dbContext.SaveChanges();

            //Associate Practitioner with Insurance
            PInsurance pi1 = new PInsurance();

            pi1.PractitionerId = pract1.UserId;
            pi1.InsuranceId    = newIns.InsuranceId;
            dbContext.Add(pi1);
            dbContext.SaveChanges();
            PInsurance pi2 = new PInsurance();

            pi2.PractitionerId = pract1.UserId;
            pi2.InsuranceId    = newIns2.InsuranceId;
            dbContext.Add(pi2);
            dbContext.SaveChanges();
            PInsurance pi3 = new PInsurance();

            pi3.PractitionerId = pract2.UserId;
            pi3.InsuranceId    = newIns.InsuranceId;
            dbContext.Add(pi3);
            dbContext.SaveChanges();

            //Query for One schedule for practitioner1, then same for practitioner2
            Query.OnePsSchedules(pract1.UserId, dbContext);
            Query.OnePsSchedules(pract2.UserId, dbContext);
            //Check last timeslot, generate timeslot based off of last timeslot
            Generate.CheckTimeslots(dbContext);
            Timeslot tsToday = dbContext.Timeslots.OrderByDescending(t => t.Hour).FirstOrDefault(t => t.Date == DateTime.Today);

            //Create new reservation
            //Associaton: CreaterId, CustomerId, PractitionerId, RoomId, ServiceId, TimeslotId
            Reservation newResToday = new Reservation();

            newResToday.CreatorId      = recep1.UserId;
            newResToday.CustomerId     = newCust.CustomerId;
            newResToday.Notes          = "Important VIP Reservation!!!!!!";
            newResToday.PractitionerId = pract1.UserId;
            newResToday.RoomId         = room1.RoomId;
            newResToday.ServiceId      = serv1.ServiceId;
            newResToday.TimeslotId     = tsToday.TimeslotId;
            dbContext.Add(newResToday);
            dbContext.SaveChanges();

            Reservation newResToday2 = new Reservation();

            newResToday2.CreatorId      = recep2.UserId;
            newResToday2.CustomerId     = newCust2.CustomerId;
            newResToday2.Notes          = "Will they show up?";
            newResToday2.PractitionerId = pract2.UserId;
            newResToday2.RoomId         = room2.RoomId;
            newResToday2.ServiceId      = serv3.ServiceId;
            newResToday2.TimeslotId     = tsToday.TimeslotId;
            dbContext.Add(newResToday2);
            dbContext.SaveChanges();

            //Create another Reservation based of off the tstomorrow timeslot
            Timeslot    tsTomorrow     = dbContext.Timeslots.OrderByDescending(t => t.Hour).FirstOrDefault(t => t.Date == DateTime.Today.AddDays(1));
            Reservation newResTomorrow = new Reservation();

            newResTomorrow.CreatorId      = recep1.UserId;
            newResTomorrow.CustomerId     = newCust.CustomerId;
            newResTomorrow.Notes          = "Important VIP Reservation!!!!!!";
            newResTomorrow.PractitionerId = pract1.UserId;
            newResTomorrow.RoomId         = room1.RoomId;
            newResTomorrow.ServiceId      = serv1.ServiceId;
            newResTomorrow.TimeslotId     = tsTomorrow.TimeslotId;
            dbContext.Add(newResTomorrow);
            dbContext.SaveChanges();

            Reservation newResTomorrow2 = new Reservation();

            newResTomorrow2.CreatorId      = recep2.UserId;
            newResTomorrow2.CustomerId     = newCust2.CustomerId;
            newResTomorrow2.Notes          = "Will they show up?";
            newResTomorrow2.PractitionerId = pract2.UserId;
            newResTomorrow2.RoomId         = room2.RoomId;
            newResTomorrow2.ServiceId      = serv3.ServiceId;
            newResTomorrow2.TimeslotId     = tsTomorrow.TimeslotId;
            dbContext.Add(newResTomorrow2);
            dbContext.SaveChanges();
            return;
        }
Example #5
0
 public static Insurance CreateInsurance(Insurance newIns, ProjectContext db)
 {
     db.Add(newIns);
     db.SaveChanges();
     return(newIns);
 }