Instructions for setting up a developer environment

To use the DoctorVisitingSystem you need to do the following: 1. Install “Microsoft SQL Server 2014 Express” and “Microsoft Server 2014 Management Studio”: https://www.microsoft.com/en-US/download/details.aspx?id=42299. Open it and connect to server. 2. Install “Microsoft Visual Studio 2015”: https://www.visualstudio.com/en-us/downloads/download-visual-studio-vs.aspx 3. Go to folder “DoctorVisitingSystem.Database”. Open files “create.sql”, “insert.sql” and “procs.sql”. Execute that files (first “create.sql” then “insert.sql” then “procs.sql”) in “Microsoft Server 2014 Management Studio” (press F5).

!!! IF YOU ARE DOING THIS AFTER the 30TH OF MARCH ALTER “insert.sql” CHANGING the DATE

of appointment in tblAppointment to the following date (for example if you are starting the work on the 1st of April then you need to change the date to 2nd April or more). Otherwise you will now be able to do the insert because of constraint check. INSERT INTO tblAppointment (Id, DoctorId, PatientId, AppointmentDateTimeStart, AppointmentDateTimeFinish) VALUES (1, 5, 2, '2016-03-30 15:00', '2016-03-30 16:00')... 4. Open solution “DoctorVisitingSystem.sln”. Go to project “DoctorVisitingSystem.DesktopUI” and open file “app.config”. There you can find at the 7th line code “<add name="DoctorVisitingSystemConnection" connectionString="Server=.\SQLEXPRESS;Database=DoctorVisitingSystem;Integrated Security=SSPI;"/>”. Change connection string depending on your server connection using this template: “Server=myServerAddress;Initial Catalog=DoctorVisitingSystem;Integrated Security=SSPI; User ID=myDomain\myUsername;Password=myPassword;”.

   5.	Go to the solution and right click on the project “DoctorVisitingSystem.DesktopUI”. Choose “Set as StartUp Project”.
   6.	Start the project.  In login and password text boxes type one of the options:
*Login: supersophia, password: sophia123
*Login: OksanaTheBest, password: oksa52
*Login: i, password: 1