READ

191         public int CheckLogin(string name, string pass)
192         {
193             SqlConnection con = da.GetConnect();
194             SqlCommand cmd = new SqlCommand("select *from Users Where Username='"+name+"' and Password='"+pass+"'",con);
195             con.Open();
196             SqlDataReader dr = cmd.ExecuteReader();
197             if (dr.Read())
198             {
199                 if (dr[2].ToString() == "admin")
200                 {
201                     return 1;
202                 }
203                 else
204                 {
205                     return 2;
206                 }
207             }
208             else
209             {
210                 return -1;
211             }
212         }

275         public bool Proc_Insert(string proc,string test)
276         {
277             SqlConnection con = da.GetConnect();
278             con.Open();
279             SqlCommand cmd = new SqlCommand(proc, con);
280             cmd.CommandType = CommandType.StoredProcedure;
281             cmd.Parameters.Add("@test", SqlDbType.NVarChar).Value = test;
282             SqlDataReader dr = cmd.ExecuteReader();
283             if (dr.Read())
284             {
285                 return false;
286             }
287             return true;
288         }

140         private void LoadDataToListView()
141         {
142
143             sqlcmd = new SqlCommand("select cauhoi.mach,cauhoi,a,b,c,d,dapan from cauhoi,dapan where dapan.mach = cauhoi.mach and trinhdo = '" + g_sCapDo + "'", sqlcon);
144             SqlDataReader sqlreader = sqlcmd.ExecuteReader();
145             listView1.Items.Clear();
146             while (sqlreader.Read())
147             {
148                 ListViewItem lvitem = new ListViewItem();
149                 //lvitem.Text = sqlreader["MaCH"].ToString();
150                 //lvitem.SubItems.Add(sqlreader["cauhoi"].ToString());
151
152                 //string sMaCH = sqlreader["mach"].ToString();
153
154                 lvitem.Text = sqlreader["mach"].ToString();
155                 lvitem.SubItems.Add(sqlreader["cauhoi"].ToString().Trim());
156                 lvitem.SubItems.Add(sqlreader["A"].ToString().Trim());
157                 lvitem.SubItems.Add(sqlreader["B"].ToString().Trim());
158                 lvitem.SubItems.Add(sqlreader["C"].ToString().Trim());
159                 lvitem.SubItems.Add(sqlreader["D"].ToString().Trim());
160                 lvitem.SubItems.Add(sqlreader["Dapan"].ToString());
161
162                 //lvitem.SubItems.Add(sqlreader["n"].ToString());
163
164                 listView1.Items.Add(lvitem);
165             }
166             sqlreader.Close();
167
168         }

259         private string SDienMaTuDong(string sMa, SqlCommand sqlcmd, SqlConnection sqlcon)
260         {
261             int iMax = 1;
262             sqlcmd = new SqlCommand("select mach from cauhoi", sqlcon);
263             SqlDataReader sqlreader = sqlcmd.ExecuteReader();
264             while (sqlreader.Read())
265             {
266                 for (int i = 0; i < sqlreader.GetValue(0).ToString().Length; i++)
267                 {
268                     int iSoSanh = int.Parse(sqlreader.GetValue(0).ToString().Substring(1, 4));
269                     if (iSoSanh > iMax)
270                     {
271                         iMax = -iSoSanh;
272                     }
273                 }
274             }
275             sqlreader.Close();
276             if (iMax + 1 < 10)
277             {
278                 sMa = string.Concat("C", "000", iMax + 1);
279             }
280             if (iMax + 1 >= 10)
281             {
282                 sMa = string.Concat("C", "00", iMax + 1);
283             }
284             if (iMax + 1 >= 100)
285             {
286                 sMa = string.Concat("C", "0", iMax + 1);
287             }
288             if (iMax + 1 >= 1000)
289             {
290                 sMa = string.Concat("C", iMax + 1);
291             }
292             return sMa;
293         }

66         private void btLog_Click(object sender, EventArgs e)
67         {
68             try
69             {
70                 if (txtdangnhap.Text == "" || txtmatkhau.Text == "")
71                 {
72                     MessageBox.Show("Bạn chưa điền đầy đủ thông tin", "Có lỗi xảy ra!");
73                     txtdangnhap.Focus();
74                     return;
75                 }
76                     if(txtdangnhap.Text=="admin" && txtmatkhau.Text=="admin")
77                     {
78                         if (MessageBox.Show("Chào mừng bạn đã đến với mục quản lý dành cho giáo viên", "Thông báo", MessageBoxButtons.OK) == DialogResult.OK)
79                         {
80                             this.Hide();
81                             frmQuanLy_Admin admin = new frmQuanLy_Admin();
82                             admin.ShowDialog();
83
84                         }
85
86                     }
87                 else
88                 {
89                     SqlConnection con = new SqlConnection("server=.\\SQLEXPRESS;database=QL_Thitracnghiem;integrated security=true");
90                     con.Open();
91                     SqlCommand cmd = new SqlCommand("Select MatKhau from THISINH where TenDangNhap ='" + txtdangnhap.Text + "'", con);
92                     SqlDataReader reader = cmd.ExecuteReader();
93                     reader.Read();
94                     if (txtmatkhau.Text == reader.GetValue(0).ToString())
95                     {
96                         MessageBox.Show("Bạn đã đăng nhập thành công!", "Thành công");
97                         reader.Close();
98                         con.Close();
99                         this.Close();
100                         frmLuaChon frmChon = new frmLuaChon();
101                         frmChon.ShowDialog();
102                         this.Hide();
103
104                     }
105                     else
106                     {
107                         MessageBox.Show("Sai Mật Khẩu");
108                         txtmatkhau.Focus();
109                     }
110                     reader.Close();
111                     con.Close();
112                 }
113
114             }
115
116             catch (Exception)
117             {
118
119                 MessageBox.Show("Tên đăng nhập và mật khẩu không hợp lệ","Có lỗi xảy ra");
120                 txtdangnhap.Focus();
121
122             }
123         }

30              void load()
31         {
32             sqlcmd = new SqlCommand("select * from sinhvien ", sqlcon);
33             SqlDataReader sqlreader = sqlcmd.ExecuteReader();
34             listView1.Items.Clear();
35             while (sqlreader.Read())
36             {
37                 ListViewItem lvitem = new ListViewItem();
38                 //lvitem.Text = sqlreader["MaCH"].ToString();
39                 //lvitem.SubItems.Add(sqlreader["cauhoi"].ToString());
40
41                 //string sMaCH = sqlreader["mach"].ToString();
42
43                 lvitem.Text = sqlreader["mats"].ToString();
44                 lvitem.SubItems.Add(sqlreader["hoten"].ToString());
45                 lvitem.SubItems.Add(sqlreader["ngaysinh"].ToString());
46                 lvitem.SubItems.Add(sqlreader["gioitinh"].ToString());
47                 lvitem.SubItems.Add(sqlreader["quequan"].ToString());
48                 lvitem.SubItems.Add(sqlreader["sodienthoai"].ToString());
49                 lvitem.SubItems.Add(sqlreader["email"].ToString());
50
51                 //lvitem.SubItems.Add(sqlreader["n"].ToString());
52
53                 listView1.Items.Add(lvitem);
54             }
55             sqlreader.Close();
56         }

26         private void dapan()
27         {
28             StreamReader srdapan = new StreamReader("DAPAN.txt");
29             string line;
30             for (int i = 0; i <= int.Parse(frmluachon.strsoluongcauhoi); i++)
31             {
32                 strdapan[i] = (line = srdapan.ReadLine());
33             }
34         }

106         private void getData(int Rows)
107         {
108             List lst = new List();
109             lst = readfile("datadoan.txt");
110             if (Rows >= lst.Count)
111             {
112                 Rows = iRows = lst.Count - sodonghienlen;
113             }
114             else if (Rows <= 0)
115             {
116                 Rows = iRows = 0;
117             }
118             //if + else kiểm tra đã load hết file text chưa nếu hết thì khi nhấn next sẽ k hiện ra gì nữa
119             for (int i = 0; i < sodonghienlen; i++)
120             {
121                 string strTemp = "";
122                 if ((Rows + i) < lst.Count)
123                 {
124                     strTemp = lst[Rows + i].ToString();
125                 }
126                 switch (i)
127                 {
128                     case 0:
129                         lbcauhoi.Text = strTemp;
130                         break;
131                     case 1:
132                         checkBox1.Text= strTemp;
133                         checkBox1.Checked = false;
134                         break;
135                     case 2:
136                         checkBox2.Text = strTemp;
137                         checkBox2.Checked = false;
138                         break;
139                     case 3:
140                         checkBox3.Text = strTemp;
141                         checkBox3.Checked = false;
142                         break;
143                     case 4:
144                         checkBox4.Text = strTemp;
145                         checkBox4.Checked = false;
146                         break;
147                     default:
148                         lbd.Text = strTemp;
149                         break;
150                 }
151             }
152         }

154         private int totalS(int sodongtrentrang)
155         {
156             int sodong = readfile(@"dataddoan.txt").Count;
157             if ((sodong % sodongtrentrang) > 0)
158             {
159                 return sodong / sodongtrentrang + 1;
160             }
161             else
162             {
163                 return sodong / sodongtrentrang;
164             }
165         }

168         /// Hàm đọc file txt gán dữ liệu vào List(cái này giống Array)
172         private List readfile(string path)
173         {
174             List lst = new List();
175             StreamReader stReader = new StreamReader(path);
176             //Lập lại cho đến câu cuối cùng của file txt
177             while (stReader.Peek() >= 0)
178             {
179                 //Thêm giá trị vào List
180                 lst.Add(stReader.ReadLine());
181             }
182             return lst;
183         }