Ứng dụng quản lý tuyển dụng c#
1 using System;
2 using System.Collections.Generic;
3 using System.Linq;
4 using System.Text;
5 using System.Threading.Tasks;
6 using System.Data;
7 using System.Data.SqlClient;
8 using DTO;
9
10 namespace DAO
11 {
12 public class HoSo_DaTa
13 {
14 public static void ThemHoSo(HoSo_DTO hoso)
15 {
16 if (DataServices.testketnoi() == true)
17 {
18 SqlConnection cnn = DataServices.ketnoi();
19 SqlCommand cmd = new SqlCommand("sp_ThemHoSo", cnn);
20 cmd.CommandType = CommandType.StoredProcedure;
21 cmd.Parameters.Add("@mahs", SqlDbType.NChar, 5);
22 cmd.Parameters.Add("@ngaynop", SqlDbType.Date);
23 cmd.Parameters.Add("@mavitri", SqlDbType.NChar, 5);
24 cmd.Parameters.Add("@cmnd", SqlDbType.NChar, 9);
25 cmd.Parameters.Add("@hoten", SqlDbType.NVarChar, 30);
26 cmd.Parameters.Add("@ngaysinh", SqlDbType.Date);
27 cmd.Parameters.Add("@maloaihs", SqlDbType.NChar, 5);
28 cmd.Parameters.Add("@mahuyen", SqlDbType.NChar, 5);
29 cmd.Parameters.Add("@maqg", SqlDbType.NChar, 5);
30 cmd.Parameters.Add("@matinh", SqlDbType.NChar, 5);
31 cmd.Parameters.Add("@manv", SqlDbType.NChar, 10);
32
33 //add value to parameters
34 cmd.Parameters["@mahs"].Value = hoso.MaHS;
35 cmd.Parameters["@ngaynop"].Value = hoso.NgayNop;
36 cmd.Parameters["@mavitri"].Value = hoso.MaViTri;
37 cmd.Parameters["@cmnd"].Value = hoso.CMND;
38 cmd.Parameters["@hoten"].Value = hoso.HoTen;
39 cmd.Parameters["@ngaysinh"].Value = hoso.NgaySinh;
40 cmd.Parameters["@maloaihs"].Value = hoso.MaLoaiHS;
41 cmd.Parameters["@mahuyen"].Value = hoso.MaHuyen;
42 cmd.Parameters["@maqg"].Value = hoso.MaQG;
43 cmd.Parameters["@matinh"].Value = hoso.MaTinh;
44 cmd.Parameters["@manv"].Value = hoso.MaNV;
45
46 cnn.Open();
47 cmd.ExecuteNonQuery();
48 cnn.Close();
49 }
50 }
51
52 public static void SuaHoSo(HoSo_DTO hoso)
53 {
54 if (DataServices.testketnoi() == true)
55 {
56 SqlConnection cnn = DataServices.ketnoi();
57 SqlCommand cmd = new SqlCommand("sp_SuaHoSo", cnn);
58 cmd.CommandType = CommandType.StoredProcedure;
59 cmd.Parameters.Add("@mahs", SqlDbType.NChar, 5);
60 cmd.Parameters.Add("@ngaynop", SqlDbType.Date);
61 cmd.Parameters.Add("@mavitri", SqlDbType.NChar, 5);
62 cmd.Parameters.Add("@cmnd", SqlDbType.NChar, 9);
63 cmd.Parameters.Add("@hoten", SqlDbType.NVarChar, 30);
64 cmd.Parameters.Add("@ngaysinh", SqlDbType.Date);
65 cmd.Parameters.Add("@maloaihs", SqlDbType.NChar, 5);
66 cmd.Parameters.Add("@mahuyen", SqlDbType.NChar, 5);
67 cmd.Parameters.Add("@maqg", SqlDbType.NChar, 5);
68 cmd.Parameters.Add("@matinh", SqlDbType.NChar, 5);
69 cmd.Parameters.Add("@manv", SqlDbType.NChar, 10);
70
71 //add value to parameters
72 cmd.Parameters["@mahs"].Value = hoso.MaHS;
73 cmd.Parameters["@ngaynop"].Value = hoso.NgayNop;
74 cmd.Parameters["@mavitri"].Value = hoso.MaViTri;
75 cmd.Parameters["@cmnd"].Value = hoso.CMND;
76 cmd.Parameters["@hoten"].Value = hoso.HoTen;
77 cmd.Parameters["@ngaysinh"].Value = hoso.NgaySinh;
78 cmd.Parameters["@maloaihs"].Value = hoso.MaLoaiHS;
79 cmd.Parameters["@mahuyen"].Value = hoso.MaHuyen;
80 cmd.Parameters["@maqg"].Value = hoso.MaQG;
81 cmd.Parameters["@matinh"].Value = hoso.MaTinh;
82 cmd.Parameters["@manv"].Value = hoso.MaNV;
83
84 cnn.Open();
85 cmd.ExecuteNonQuery();
86 cnn.Close();
87 }
88 }
89
90 public static void XoaHoSo(HoSo_DTO hoso)
91 {
92 if (DataServices.testketnoi() == true)
93 {
94 SqlConnection cnn = DataServices.ketnoi();
95 SqlCommand cmd = new SqlCommand("sp_XoaHoSo", cnn);
96 cmd.CommandType = CommandType.StoredProcedure;
97 cmd.Parameters.Add("@mahs", SqlDbType.NChar, 5);
98
99 //add value to parameters
100 cmd.Parameters["@mahs"].Value = hoso.MaHS;
101
102 cnn.Open();
103 cmd.ExecuteNonQuery();
104 cnn.Close();
105 }
106 }
107 public static DataTable ListHoSo()
108 {
109 if (DataServices.testketnoi() == true)
110 {
111 SqlConnection cnn = DataServices.ketnoi();
112 SqlCommand cmd = new SqlCommand("sp_TatCaHoSo", cnn);
113 cmd.CommandType = CommandType.StoredProcedure;
114 DataTable dt = new DataTable();
115 SqlDataAdapter da = new SqlDataAdapter(cmd);
116 da.Fill(dt);
117 return dt;
118 }
119 else
120 {
121 DataTable dt = new DataTable();
122 return dt;
123 }
124 }
125 public static DataTable ListHoSoTheoTen(string hoten)
126 {
127 if (DataServices.testketnoi() == true)
128 {
129 SqlConnection cnn = DataServices.ketnoi();
130 SqlCommand cmd = new SqlCommand("sp_HoSoTheoTen", cnn);
131 cmd.CommandType = CommandType.StoredProcedure;
132 cmd.Parameters.Add("@hoten", SqlDbType.NChar, 5);
133
134 //add value to parameters
135 cmd.Parameters["@hoten"].Value = hoten;
136
137 DataTable dt = new DataTable();
138 SqlDataAdapter da = new SqlDataAdapter(cmd);
139 da.Fill(dt);
140 return dt;
141 }
142 else
143 {
144 DataTable dt = new DataTable();
145 return dt;
146 }
147 }
148 public static DataTable ListHoSoTheoTinTuyenDung(string hoten)
149 {
150 if (DataServices.testketnoi() == true)
151 {
152 SqlConnection cnn = DataServices.ketnoi();
153 SqlCommand cmd = new SqlCommand("sp_HoSoTheoTinTuyenDung", cnn);
154 cmd.CommandType = CommandType.StoredProcedure;
155 cmd.Parameters.Add("@matt", SqlDbType.NChar, 5);
156
157 //add value to parameters
158 cmd.Parameters["@matt"].Value = hoten;
159
160 DataTable dt = new DataTable();
161 SqlDataAdapter da = new SqlDataAdapter(cmd);
162 da.Fill(dt);
163 return dt;
164 }
165 else
166 {
167 DataTable dt = new DataTable();
168 return dt;
169 }
170 }
171 }
172 }
2 using System.Collections.Generic;
3 using System.Linq;
4 using System.Text;
5 using System.Threading.Tasks;
6 using System.Data;
7 using System.Data.SqlClient;
8 using DTO;
9
10 namespace DAO
11 {
12 public class HoSo_DaTa
13 {
14 public static void ThemHoSo(HoSo_DTO hoso)
15 {
16 if (DataServices.testketnoi() == true)
17 {
18 SqlConnection cnn = DataServices.ketnoi();
19 SqlCommand cmd = new SqlCommand("sp_ThemHoSo", cnn);
20 cmd.CommandType = CommandType.StoredProcedure;
21 cmd.Parameters.Add("@mahs", SqlDbType.NChar, 5);
22 cmd.Parameters.Add("@ngaynop", SqlDbType.Date);
23 cmd.Parameters.Add("@mavitri", SqlDbType.NChar, 5);
24 cmd.Parameters.Add("@cmnd", SqlDbType.NChar, 9);
25 cmd.Parameters.Add("@hoten", SqlDbType.NVarChar, 30);
26 cmd.Parameters.Add("@ngaysinh", SqlDbType.Date);
27 cmd.Parameters.Add("@maloaihs", SqlDbType.NChar, 5);
28 cmd.Parameters.Add("@mahuyen", SqlDbType.NChar, 5);
29 cmd.Parameters.Add("@maqg", SqlDbType.NChar, 5);
30 cmd.Parameters.Add("@matinh", SqlDbType.NChar, 5);
31 cmd.Parameters.Add("@manv", SqlDbType.NChar, 10);
32
33 //add value to parameters
34 cmd.Parameters["@mahs"].Value = hoso.MaHS;
35 cmd.Parameters["@ngaynop"].Value = hoso.NgayNop;
36 cmd.Parameters["@mavitri"].Value = hoso.MaViTri;
37 cmd.Parameters["@cmnd"].Value = hoso.CMND;
38 cmd.Parameters["@hoten"].Value = hoso.HoTen;
39 cmd.Parameters["@ngaysinh"].Value = hoso.NgaySinh;
40 cmd.Parameters["@maloaihs"].Value = hoso.MaLoaiHS;
41 cmd.Parameters["@mahuyen"].Value = hoso.MaHuyen;
42 cmd.Parameters["@maqg"].Value = hoso.MaQG;
43 cmd.Parameters["@matinh"].Value = hoso.MaTinh;
44 cmd.Parameters["@manv"].Value = hoso.MaNV;
45
46 cnn.Open();
47 cmd.ExecuteNonQuery();
48 cnn.Close();
49 }
50 }
51
52 public static void SuaHoSo(HoSo_DTO hoso)
53 {
54 if (DataServices.testketnoi() == true)
55 {
56 SqlConnection cnn = DataServices.ketnoi();
57 SqlCommand cmd = new SqlCommand("sp_SuaHoSo", cnn);
58 cmd.CommandType = CommandType.StoredProcedure;
59 cmd.Parameters.Add("@mahs", SqlDbType.NChar, 5);
60 cmd.Parameters.Add("@ngaynop", SqlDbType.Date);
61 cmd.Parameters.Add("@mavitri", SqlDbType.NChar, 5);
62 cmd.Parameters.Add("@cmnd", SqlDbType.NChar, 9);
63 cmd.Parameters.Add("@hoten", SqlDbType.NVarChar, 30);
64 cmd.Parameters.Add("@ngaysinh", SqlDbType.Date);
65 cmd.Parameters.Add("@maloaihs", SqlDbType.NChar, 5);
66 cmd.Parameters.Add("@mahuyen", SqlDbType.NChar, 5);
67 cmd.Parameters.Add("@maqg", SqlDbType.NChar, 5);
68 cmd.Parameters.Add("@matinh", SqlDbType.NChar, 5);
69 cmd.Parameters.Add("@manv", SqlDbType.NChar, 10);
70
71 //add value to parameters
72 cmd.Parameters["@mahs"].Value = hoso.MaHS;
73 cmd.Parameters["@ngaynop"].Value = hoso.NgayNop;
74 cmd.Parameters["@mavitri"].Value = hoso.MaViTri;
75 cmd.Parameters["@cmnd"].Value = hoso.CMND;
76 cmd.Parameters["@hoten"].Value = hoso.HoTen;
77 cmd.Parameters["@ngaysinh"].Value = hoso.NgaySinh;
78 cmd.Parameters["@maloaihs"].Value = hoso.MaLoaiHS;
79 cmd.Parameters["@mahuyen"].Value = hoso.MaHuyen;
80 cmd.Parameters["@maqg"].Value = hoso.MaQG;
81 cmd.Parameters["@matinh"].Value = hoso.MaTinh;
82 cmd.Parameters["@manv"].Value = hoso.MaNV;
83
84 cnn.Open();
85 cmd.ExecuteNonQuery();
86 cnn.Close();
87 }
88 }
89
90 public static void XoaHoSo(HoSo_DTO hoso)
91 {
92 if (DataServices.testketnoi() == true)
93 {
94 SqlConnection cnn = DataServices.ketnoi();
95 SqlCommand cmd = new SqlCommand("sp_XoaHoSo", cnn);
96 cmd.CommandType = CommandType.StoredProcedure;
97 cmd.Parameters.Add("@mahs", SqlDbType.NChar, 5);
98
99 //add value to parameters
100 cmd.Parameters["@mahs"].Value = hoso.MaHS;
101
102 cnn.Open();
103 cmd.ExecuteNonQuery();
104 cnn.Close();
105 }
106 }
107 public static DataTable ListHoSo()
108 {
109 if (DataServices.testketnoi() == true)
110 {
111 SqlConnection cnn = DataServices.ketnoi();
112 SqlCommand cmd = new SqlCommand("sp_TatCaHoSo", cnn);
113 cmd.CommandType = CommandType.StoredProcedure;
114 DataTable dt = new DataTable();
115 SqlDataAdapter da = new SqlDataAdapter(cmd);
116 da.Fill(dt);
117 return dt;
118 }
119 else
120 {
121 DataTable dt = new DataTable();
122 return dt;
123 }
124 }
125 public static DataTable ListHoSoTheoTen(string hoten)
126 {
127 if (DataServices.testketnoi() == true)
128 {
129 SqlConnection cnn = DataServices.ketnoi();
130 SqlCommand cmd = new SqlCommand("sp_HoSoTheoTen", cnn);
131 cmd.CommandType = CommandType.StoredProcedure;
132 cmd.Parameters.Add("@hoten", SqlDbType.NChar, 5);
133
134 //add value to parameters
135 cmd.Parameters["@hoten"].Value = hoten;
136
137 DataTable dt = new DataTable();
138 SqlDataAdapter da = new SqlDataAdapter(cmd);
139 da.Fill(dt);
140 return dt;
141 }
142 else
143 {
144 DataTable dt = new DataTable();
145 return dt;
146 }
147 }
148 public static DataTable ListHoSoTheoTinTuyenDung(string hoten)
149 {
150 if (DataServices.testketnoi() == true)
151 {
152 SqlConnection cnn = DataServices.ketnoi();
153 SqlCommand cmd = new SqlCommand("sp_HoSoTheoTinTuyenDung", cnn);
154 cmd.CommandType = CommandType.StoredProcedure;
155 cmd.Parameters.Add("@matt", SqlDbType.NChar, 5);
156
157 //add value to parameters
158 cmd.Parameters["@matt"].Value = hoten;
159
160 DataTable dt = new DataTable();
161 SqlDataAdapter da = new SqlDataAdapter(cmd);
162 da.Fill(dt);
163 return dt;
164 }
165 else
166 {
167 DataTable dt = new DataTable();
168 return dt;
169 }
170 }
171 }
172 }