-
Notifications
You must be signed in to change notification settings - Fork 0
/
Employee.vb
373 lines (335 loc) · 10.8 KB
/
Employee.vb
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
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
Imports System.Data.SqlClient
Public Class Employee
Private mEmployeeID as Integer
Private mLastName as String
Private mFirstName as String
Private mTitle as String
Private mTitleOfCourtesy as String
Private mBirthDate as Date
Private mHireDate as Date
Private mAddress as String
Private mCity as String
Private mRegion as String
Private mPostalCode as String
Private mCountry as String
Private mHomePhone as String
Private mExtension as String
Private mPhoto as Byte()
Private mNotes as String
Private mReportsTo as Integer
Private mPhotoPath as String
#Region "Propertyler"
Public Property EmployeeID as Integer
Get
Return mEmployeeID
End Get
Set(ByVal Value As Integer)
mEmployeeID=Value
End Set
End Property
Public Property LastName as String
Get
Return mLastName
End Get
Set(ByVal Value As String)
mLastName=Value
End Set
End Property
Public Property FirstName as String
Get
Return mFirstName
End Get
Set(ByVal Value As String)
mFirstName=Value
End Set
End Property
Public Property Title as String
Get
Return mTitle
End Get
Set(ByVal Value As String)
mTitle=Value
End Set
End Property
Public Property TitleOfCourtesy as String
Get
Return mTitleOfCourtesy
End Get
Set(ByVal Value As String)
mTitleOfCourtesy=Value
End Set
End Property
Public Property BirthDate as Date
Get
Return mBirthDate
End Get
Set(ByVal Value As Date)
mBirthDate=Value
End Set
End Property
Public Property HireDate as Date
Get
Return mHireDate
End Get
Set(ByVal Value As Date)
mHireDate=Value
End Set
End Property
Public Property Address as String
Get
Return mAddress
End Get
Set(ByVal Value As String)
mAddress=Value
End Set
End Property
Public Property City as String
Get
Return mCity
End Get
Set(ByVal Value As String)
mCity=Value
End Set
End Property
Public Property Region as String
Get
Return mRegion
End Get
Set(ByVal Value As String)
mRegion=Value
End Set
End Property
Public Property PostalCode as String
Get
Return mPostalCode
End Get
Set(ByVal Value As String)
mPostalCode=Value
End Set
End Property
Public Property Country as String
Get
Return mCountry
End Get
Set(ByVal Value As String)
mCountry=Value
End Set
End Property
Public Property HomePhone as String
Get
Return mHomePhone
End Get
Set(ByVal Value As String)
mHomePhone=Value
End Set
End Property
Public Property Extension as String
Get
Return mExtension
End Get
Set(ByVal Value As String)
mExtension=Value
End Set
End Property
Public Property Photo as Byte()
Get
Return mPhoto
End Get
Set(ByVal Value As Byte())
mPhoto=Value
End Set
End Property
Public Property Notes as String
Get
Return mNotes
End Get
Set(ByVal Value As String)
mNotes=Value
End Set
End Property
Public Property ReportsTo as Integer
Get
Return mReportsTo
End Get
Set(ByVal Value As Integer)
mReportsTo=Value
End Set
End Property
Public Property PhotoPath as String
Get
Return mPhotoPath
End Get
Set(ByVal Value As String)
mPhotoPath=Value
End Set
End Property
#End Region
#Region "Methodlar"
Public Shared Sub Ekle(ByVal LastName as String,ByVal FirstName as String,ByVal Title as String,ByVal TitleOfCourtesy as String,ByVal BirthDate as Date,ByVal HireDate as Date,ByVal Address as String,ByVal City as String,ByVal Region as String,ByVal PostalCode as String,ByVal Country as String,ByVal HomePhone as String,ByVal Extension as String,ByVal Photo as Byte(),ByVal Notes as String,ByVal ReportsTo as Integer,ByVal PhotoPath as String)
Dim Con As New SqlConnection(Tools.ConStr)
Dim Com As new SqlCommand("INSERT Employees (LastName,FirstName,Title,TitleOfCourtesy,BirthDate,HireDate,Address,City,Region,PostalCode,Country,HomePhone,Extension,Photo,Notes,ReportsTo,PhotoPath) VALUES (@LastName,@FirstName,@Title,@TitleOfCourtesy,@BirthDate,@HireDate,@Address,@City,@Region,@PostalCode,@Country,@HomePhone,@Extension,@Photo,@Notes,@ReportsTo,@PhotoPath)",Con)
With Com.Parameters
.Add("@LastName",LastName)
.Add("@FirstName",FirstName)
.Add("@Title",Title)
.Add("@TitleOfCourtesy",TitleOfCourtesy)
.Add("@BirthDate",BirthDate)
.Add("@HireDate",HireDate)
.Add("@Address",Address)
.Add("@City",City)
.Add("@Region",Region)
.Add("@PostalCode",PostalCode)
.Add("@Country",Country)
.Add("@HomePhone",HomePhone)
.Add("@Extension",Extension)
.Add("@Photo",Photo)
.Add("@Notes",Notes)
.Add("@ReportsTo",ReportsTo)
.Add("@PhotoPath",PhotoPath)
End With
Con.Open()
Com.ExecuteNonQuery()
Con.Close()
End Sub
Public Shared Sub Sil(ByVal EmployeeID as Integer)
Dim Con As New SqlConnection(Tools.ConStr)
Dim Com As New SqlCommand("DELETE Employees WHERE EmployeeID=@EmployeeID")
Com.Parameters.Add("@EmployeeID",EmployeeID)
Con.Open()
Com.ExecuteNonQuery()
Con.Close()
End Sub
Public Shared Sub Guncelle(ByVal EmployeeID as Integer,ByVal LastName as String,ByVal FirstName as String,ByVal Title as String,ByVal TitleOfCourtesy as String,ByVal BirthDate as Date,ByVal HireDate as Date,ByVal Address as String,ByVal City as String,ByVal Region as String,ByVal PostalCode as String,ByVal Country as String,ByVal HomePhone as String,ByVal Extension as String,ByVal Photo as Byte(),ByVal Notes as String,ByVal ReportsTo as Integer,ByVal PhotoPath as String)
Dim Con As New SqlConnection(Tools.ConStr)
Dim Com As new SqlCommand("UPDATE [Employees] SET LastName=@LastName,FirstName=@FirstName,Title=@Title,TitleOfCourtesy=@TitleOfCourtesy,BirthDate=@BirthDate,HireDate=@HireDate,Address=@Address,City=@City,Region=@Region,PostalCode=@PostalCode,Country=@Country,HomePhone=@HomePhone,Extension=@Extension,Photo=@Photo,Notes=@Notes,ReportsTo=@ReportsTo,PhotoPath=@PhotoPath WHERE EmployeeID=@EmployeeID",Con)
With Com.Parameters
.Add("@EmployeeID",EmployeeID)
.Add("@LastName",LastName)
.Add("@FirstName",FirstName)
.Add("@Title",Title)
.Add("@TitleOfCourtesy",TitleOfCourtesy)
.Add("@BirthDate",BirthDate)
.Add("@HireDate",HireDate)
.Add("@Address",Address)
.Add("@City",City)
.Add("@Region",Region)
.Add("@PostalCode",PostalCode)
.Add("@Country",Country)
.Add("@HomePhone",HomePhone)
.Add("@Extension",Extension)
.Add("@Photo",Photo)
.Add("@Notes",Notes)
.Add("@ReportsTo",ReportsTo)
.Add("@PhotoPath",PhotoPath)
End With
Con.Open()
Com.ExecuteNonQuery()
Con.Close()
End Sub
Public Shared Function GetEmployeeByID(ByVal EmployeeID as Integer) As Employee
Dim e As Employee
Dim Con As New SqlConnection(Tools.ConStr)
Dim Com As New SqlCommand("SELECT * FROM Employees WHERE EmployeeID=@EmployeeID",Con)
Dim Dr as SqlDataReader
Com.Parameters.Add("@EmployeeID",EmployeeID)
Con.Open()
Dr=Com.ExecuteReader
While Dr.Read()
e= New Employee
With e
e.EmployeeID=IIF(IsDBNull(dr("EmployeeID")), 0,dr("EmployeeID"))
e.LastName=IIF(IsDBNull(dr("LastName")), "",dr("LastName"))
e.FirstName=IIF(IsDBNull(dr("FirstName")), "",dr("FirstName"))
e.Title=IIF(IsDBNull(dr("Title")), "",dr("Title"))
e.TitleOfCourtesy=IIF(IsDBNull(dr("TitleOfCourtesy")), "",dr("TitleOfCourtesy"))
e.BirthDate=IIF(IsDBNull(dr("BirthDate")), #1/1/2000#,dr("BirthDate"))
e.HireDate=IIF(IsDBNull(dr("HireDate")), #1/1/2000#,dr("HireDate"))
e.Address=IIF(IsDBNull(dr("Address")), "",dr("Address"))
e.City=IIF(IsDBNull(dr("City")), "",dr("City"))
e.Region=IIF(IsDBNull(dr("Region")), "",dr("Region"))
e.PostalCode=IIF(IsDBNull(dr("PostalCode")), "",dr("PostalCode"))
e.Country=IIF(IsDBNull(dr("Country")), "",dr("Country"))
e.HomePhone=IIF(IsDBNull(dr("HomePhone")), "",dr("HomePhone"))
e.Extension=IIF(IsDBNull(dr("Extension")), "",dr("Extension"))
'e.Photo=IIF(IsDBNull(dr("Photo")), ,dr("Photo"))
e.Notes=IIF(IsDBNull(dr("Notes")), "",dr("Notes"))
e.ReportsTo=IIF(IsDBNull(dr("ReportsTo")), 0,dr("ReportsTo"))
e.PhotoPath=IIF(IsDBNull(dr("PhotoPath")), "",dr("PhotoPath"))
End With
End While
Con.Close()
Return e
End Function
Public Shared Function GetAllEmployee() As Employee()
Dim al As New ArrayList
Dim Con As New SqlConnection(Tools.ConStr)
Dim Com As New SqlCommand("SELECT * FROM [Employees] ",Con)
Dim Dr as SqlDataReader
Con.Open()
Dr=Com.ExecuteReader
While Dr.Read()
Dim e As New Employee
With e
e.EmployeeID=IIF(IsDBNull(dr("EmployeeID")), 0,dr("EmployeeID"))
e.LastName=IIF(IsDBNull(dr("LastName")), "",dr("LastName"))
e.FirstName=IIF(IsDBNull(dr("FirstName")), "",dr("FirstName"))
e.Title=IIF(IsDBNull(dr("Title")), "",dr("Title"))
e.TitleOfCourtesy=IIF(IsDBNull(dr("TitleOfCourtesy")), "",dr("TitleOfCourtesy"))
e.BirthDate=IIF(IsDBNull(dr("BirthDate")), #1/1/2000#,dr("BirthDate"))
e.HireDate=IIF(IsDBNull(dr("HireDate")), #1/1/2000#,dr("HireDate"))
e.Address=IIF(IsDBNull(dr("Address")), "",dr("Address"))
e.City=IIF(IsDBNull(dr("City")), "",dr("City"))
e.Region=IIF(IsDBNull(dr("Region")), "",dr("Region"))
e.PostalCode=IIF(IsDBNull(dr("PostalCode")), "",dr("PostalCode"))
e.Country=IIF(IsDBNull(dr("Country")), "",dr("Country"))
e.HomePhone=IIF(IsDBNull(dr("HomePhone")), "",dr("HomePhone"))
e.Extension=IIF(IsDBNull(dr("Extension")), "",dr("Extension"))
'e.Photo=IIF(IsDBNull(dr("Photo")), ,dr("Photo"))
e.Notes=IIF(IsDBNull(dr("Notes")), "",dr("Notes"))
e.ReportsTo=IIF(IsDBNull(dr("ReportsTo")), 0,dr("ReportsTo"))
e.PhotoPath=IIF(IsDBNull(dr("PhotoPath")), "",dr("PhotoPath"))
End With
Al.Add(e)
End While
Con.Close()
Return al.ToArray(GetType(Employee))
End Function
Public Shared Function GetAllEmployeeDs() As DataSet
Dim Con As New SqlConnection(Tools.ConStr)
Dim Com As New SqlCommand("SELECT * FROM [Employees] ",Con)
Dim Da as New SqlDataAdapter
Da.SelectCommand=Com
Dim Ds as New DataSet
Da.Fill(Ds)
Return Ds
End Function
Public Shared Function GetAllEmployeeDt() As DataTable
Dim Con As New SqlConnection(Tools.ConStr)
Dim Com As New SqlCommand("SELECT * FROM [Employees] ",Con)
Dim Da as New SqlDataAdapter
Da.SelectCommand=Com
Dim Ds as New DataSet
Da.Fill(Ds)
Return Ds.Tables(0)
End Function
Public Shared Sub UpdateEmployeeDs(ByVal Ds As DataSet)
Dim Con As New SqlConnection(Tools.ConStr)
Dim Com As New SqlCommand("SELECT * FROM [Employees] ",Con)
Dim Da As New SqlDataAdapter
Da.SelectCommand = Com
Dim Cb As New SqlCommandBuilder(Da)
Da.Update(Ds)
End Sub
Public Shared Sub UpdateEmployeeDt(ByVal Dt As DataTable)
Dim Con As New SqlConnection(Tools.ConStr)
Dim Com As New SqlCommand("SELECT * FROM [Employees] ",Con)
Dim Da As New SqlDataAdapter
Da.SelectCommand = Com
Dim Cb As New SqlCommandBuilder(Da)
Da.Update(Dt)
End Sub
#End Region
Public Overrides Function toString() As String
Return mFirstName
End Function
End Class