-
Notifications
You must be signed in to change notification settings - Fork 0
/
ResolutionsSystem.cs
168 lines (144 loc) · 5.69 KB
/
ResolutionsSystem.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
namespace ResolutionsPsych
{
public class ResolutionsSystem
{
#region Appointments
public SqlCode BookAppointment(Classes.Appointment Appointment)
{
SqlClasses.Appointments appHelper = new SqlClasses.Appointments();
SqlCode code = appHelper.CreateAppointment(Appointment);
return code;
}
public SqlCode UpdateAppointment(Classes.Appointment Appointment)
{
SqlClasses.Appointments appHelper = new SqlClasses.Appointments();
SqlCode code = appHelper.UpdateAppointment(Appointment);
return code;
}
public SqlCode DeleteAppointment(int AppointmentID)
{
SqlClasses.Appointments appHelper = new SqlClasses.Appointments();
SqlCode code = appHelper.DeleteAppoinment(AppointmentID);
return code;
}
public Classes.Appointment GetAppointment(int AppointmentID)
{
SqlClasses.Appointments appHelper = new SqlClasses.Appointments();
Classes.Appointment appointment = appHelper.GetAppointment(AppointmentID);
return appointment;
}
public List<Classes.Appointment> GetAppointments()
{
SqlClasses.Appointments appHelper = new SqlClasses.Appointments();
List<Classes.Appointment> appointments = appHelper.GetAppointments();
return appointments;
}
#endregion
#region Clients
public SqlCode CreateClient(Classes.Client Client)
{
SqlClasses.Clients clientHelper = new SqlClasses.Clients();
SqlCode code = clientHelper.CreateClient(Client);
return code;
}
public SqlCode DeleteClient(Classes.Client Client)
{
SqlClasses.Clients clientHelper = new SqlClasses.Clients();
SqlCode code = clientHelper.DeleteClient(Client);
return code;
}
public Classes.Client GetClient(int ClientID)
{
SqlClasses.Clients clientHelper = new SqlClasses.Clients();
Classes.Client client = clientHelper.GetClientByID(ClientID);
return client;
}
public Classes.Client GetClient(string FirstName, string LastName)
{
SqlClasses.Clients clientHelper = new SqlClasses.Clients();
Classes.Client client = clientHelper.GetClientByName(FirstName, string.Empty, LastName);
return client;
}
public Classes.Client GetClient(string FirstName, string MiddleName, string LastName)
{
SqlClasses.Clients clientHelper = new SqlClasses.Clients();
Classes.Client client = clientHelper.GetClientByName(FirstName, MiddleName, LastName);
return client;
}
public List<Classes.Client> GetClients()
{
SqlClasses.Clients clientHelper = new SqlClasses.Clients();
List<Classes.Client> clients = clientHelper.GetClients();
return clients;
}
#endregion
#region Counsellors
public SqlCode CreateCounsellor(Classes.Counsellor Counsellor)
{
SqlClasses.Counsellors counsellorHelper = new SqlClasses.Counsellors();
SqlCode code = counsellorHelper.CreateCounsellor(Counsellor);
return code;
}
public SqlCode UpdateCounsellor(Classes.Counsellor Counsellor)
{
SqlClasses.Counsellors counsellorHelper = new SqlClasses.Counsellors();
SqlCode code = counsellorHelper.UpdateCounsellor(Counsellor);
return code;
}
public SqlCode DeleteCounsellor (int CounsellorID)
{
SqlClasses.Counsellors counsellorHelper = new SqlClasses.Counsellors();
SqlCode code = counsellorHelper.DeleteCounsellor(CounsellorID);
return code;
}
public Classes.Counsellor GetCounsellor(int CounsellorID)
{
SqlClasses.Counsellors counsellorHelper = new SqlClasses.Counsellors();
Classes.Counsellor counsellor = counsellorHelper.GetCounsellor(CounsellorID);
return counsellor;
}
public List<Classes.Counsellor> GetCounsellors()
{
SqlClasses.Counsellors counsellorHelper = new SqlClasses.Counsellors();
List<Classes.Counsellor> counsellors = counsellorHelper.GetCounsellors();
return counsellors;
}
#endregion
#region Logins
public SqlCode CreateLogin(Classes.Login Login)
{
SqlClasses.Logins loginHelper = new SqlClasses.Logins();
SqlCode code = loginHelper.CreateLogin(Login);
return code;
}
public SqlCode UpdateLogin(Classes.Login Login)
{
SqlClasses.Logins loginHelper = new SqlClasses.Logins();
SqlCode code = loginHelper.UpdateLogin(Login);
return code;
}
public SqlCode DeleteLogin(string Username)
{
SqlClasses.Logins loginHelper = new SqlClasses.Logins();
SqlCode code = loginHelper.DeleteLogin(Username);
return code;
}
public Classes.Login GetLogin(string Username)
{
SqlClasses.Logins loginHelper = new SqlClasses.Logins();
Classes.Login login = loginHelper.GetLogin(Username);
return login;
}
public List<Classes.Login> GetLogins()
{
SqlClasses.Logins loginHelper = new SqlClasses.Logins();
List<Classes.Login> logins = loginHelper.GetLogins();
return logins;
}
#endregion
}
}