-
Notifications
You must be signed in to change notification settings - Fork 2
/
Bassant's procedures and VS changes.txt
146 lines (123 loc) · 4.4 KB
/
Bassant's procedures and VS changes.txt
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
//Until I am familar with an editor as atom, please add the following to your version of the project along with the forms
//Here are my stored procedures
CREATE PROCEDURE AddSession @STypeName varchar(50),
@NumbOfNurses int,
@SPrice int,
@DoctorSalary int,
@NurseSalary int
AS
BEGIN
INSERT INTO Session_Type
( STypeName ,
NumbOfNurses ,
SPrice ,
DoctorSalary ,
NurseSalary
)
VALUES
( @STypeName ,
@NumbOfNurses ,
@SPrice ,
@DoctorSalary ,
@NurseSalary
)
END
GO
CREATE PROCEDURE EditSessions @STypeID int,
@STypeName varchar(50),
@NumbOfNurses int,
@SPrice int,
@DoctorSalary int,
@NurseSalary int
AS
BEGIN
UPDATE Session_Type SET STypeName = @STypeName,
NumbOfNurses = @NumbOfNurses ,
SPrice= @SPrice ,
DoctorSalary = @DoctorSalary ,
NurseSalary = @NurseSalary
WHERE STypeID = @STypeID
END
GO
CREATE PROCEDURE GetAllSessions
AS
BEGIN
Select * FROM Session_Type
END
GO
CREATE PROCEDURE GetClinicTypes
AS
BEGIN
SELECT ClinicTypeName FROM ClinicSetting
END
GO
CREATE PROCEDURE SetClinicType @ClinicTypeName varchar(30)
AS
BEGIN
UPDATE ClinicSetting SET Selected = 'T'
WHERE ClinicTypeName = @ClinicTypeName
END
GO
CREATE PROCEDURE RemoveSessions @STypeID int
AS
BEGIN
DELETE FROM Session_Type WHERE STypeID = @STypeID
END
GO
/////////////////////////////////////////////////////////////////////////
//functions to be added to DBmanager
public int AddSession(string type, int NoOfNurses, int price, int DSal, int NSal)
{
string StoredProcedureName = StoredProcedures.AddSession;
Dictionary<string, object> Parameters = new Dictionary<string, object>();
Parameters.Add("@STypeName", type);
Parameters.Add("@NumbOfNurses", NoOfNurses);
Parameters.Add("@SPrice", price);
Parameters.Add("@DoctorSalary", DSal);
Parameters.Add("@NurseSalary", NSal);
return ExecuteNonQuery(StoredProcedureName, Parameters);
}
public DataTable GetAllSessions()
{
string StoredProcedureName = StoredProcedures.GetAllSessions;
return ExecuteReader(StoredProcedureName, null);
}
public int RemoveSessions(int ID)
{
string StoredProcedureName = StoredProcedures.RemoveSessions;
Dictionary<string, object> Parameters = new Dictionary<string, object>();
Parameters.Add("@STypeID", ID);
return ExecuteNonQuery(StoredProcedureName, Parameters);
}
public int EditSessions(int ID, string type, int NoOfNurses, int price, int DSal, int NSal)
{
string StoredProcedureName = StoredProcedures.EditSessions;
Dictionary<string, object> Parameters = new Dictionary<string, object>();
Parameters.Add("@STypeID", ID);
Parameters.Add("@STypeName", type);
Parameters.Add("@NumbOfNurses", NoOfNurses);
Parameters.Add("@SPrice", price);
Parameters.Add("@DoctorSalary", DSal);
Parameters.Add("@NurseSalary", NSal);
return ExecuteNonQuery(StoredProcedureName, Parameters);
}
public DataTable GetClinicTypes()
{
string StoredProcedureName = StoredProcedures.GetClinicTypes;
return ExecuteReader(StoredProcedureName, null);
}
public int SetClinicType(string name)
{
string StoredProcedureName = StoredProcedures.SetClinicType;
Dictionary<string, object> Parameters = new Dictionary<string, object>();
Parameters.Add("@ClinicTypeName", name);
return ExecuteNonQuery(StoredProcedureName, Parameters);
}
////////////////////////////////////////////////////////////////////////////////////////////
//in the StoredProcedures Class
public static string AddSession = "AddSession";
public static string GetAllSessions = "GetAllSessions";
public static string RemoveSessions = "RemoveSessions" ;
public static string EditSessions = "EditSessions";
public static string GetClinicTypes = "GetClinicTypes";
public static string SetClinicType = "SetClinicType";