private void button1_Click(object sender, EventArgs e) { int ID = Int32.Parse(label4.Text); if (ID != -1) { tbl_DangNhap theOne = (from s in SV.tbl_DangNhap where s.ID == ID select s).FirstOrDefault <tbl_DangNhap>(); theOne.TenDangNhap = textBox1.Text; theOne.MatKhau = textBox2.Text; theOne.MaKhoa = comboBox1.SelectedValue.ToString(); SV.SaveChanges(); MessageBox.Show("Edited successfully!"); } else { tbl_DangNhap dn = new tbl_DangNhap(); dn.MaKhoa = comboBox1.SelectedValue.ToString(); dn.MatKhau = textBox2.Text; dn.TenDangNhap = textBox1.Text; SV.tbl_DangNhap.Add(dn); SV.SaveChanges(); MessageBox.Show("Added successfully!"); } Main.ReloadND(); this.Close(); }
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { if (dataGridView1.CurrentCell.ColumnIndex == 2) { DCTTK edit = new DCTTK(); QLDSK_MaKhoa = dataGridView1.Rows[e.RowIndex].Cells["MaKhoa"].Value.ToString(); edit.Show(); } else if (dataGridView1.CurrentCell.ColumnIndex == 3) { DialogResult confirm = MessageBox.Show("Are you f*****g sure - This will delete the corresponding Sinh Vien, Diem and Login!", "Warning", MessageBoxButtons.YesNo); if (confirm == DialogResult.Yes) { string MaKhoa = dataGridView1.Rows[e.RowIndex].Cells["MaKhoa"].Value.ToString(); var o = (from s in SV.tbl_DangNhap where s.MaKhoa == MaKhoa select s).ToList(); for (int i = 0; i < o.Count; i++) { SV.tbl_DangNhap.Remove(o[i]); } var p = (from s in SV.tbl_SinhVien where s.MaKhoa == MaKhoa select s).ToList(); for (int i = 0; i < p.Count; i++) { string mssv = p[i].MSSV; var l = (from s in SV.tbl_Diem where s.MSSV == mssv select s).ToList(); for (int g = 0; g < l.Count; g++) { SV.tbl_Diem.Remove(l[g]); } SV.tbl_SinhVien.Remove(p[i]); } SV.tbl_Khoa.Remove((from s in SV.tbl_Khoa where s.MaKhoa == MaKhoa select s).FirstOrDefault()); SV.SaveChanges(); MessageBox.Show("Deleted successfully!"); Main.ReloadKhoa(); } } }
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { if (dataGridView1.CurrentCell.ColumnIndex == 4) { DCTTTK edit = new DCTTTK(); QLDSND_ID = Int32.Parse(dataGridView1.Rows[e.RowIndex].Cells["ID"].Value.ToString()); edit.Show(); } else if (dataGridView1.CurrentCell.ColumnIndex == 5) { DialogResult confirm = MessageBox.Show("Are you f*****g sure ?", "Warning", MessageBoxButtons.YesNo); if (confirm == DialogResult.Yes) { int ID = Int32.Parse(dataGridView1.Rows[e.RowIndex].Cells["ID"].Value.ToString()); SV.tbl_DangNhap.Remove((from s in SV.tbl_DangNhap where s.ID == ID select s).FirstOrDefault()); SV.SaveChanges(); MessageBox.Show("Deleted successfully!"); Main.ReloadND(); } } }
private void Save_Click(object sender, EventArgs e) { try { foreach (DataGridViewRow rw in this.dataGridView1.Rows) { tbl_Khoa khoa = new tbl_Khoa(); if (rw.Cells[0].Value == null || rw.Cells[0].Value == DBNull.Value || String.IsNullOrWhiteSpace(rw.Cells[0].Value.ToString())) { continue; } khoa.MaKhoa = rw.Cells[0].Value.ToString(); khoa.TenKhoa = rw.Cells[1].Value.ToString(); SV.tbl_Khoa.Add(khoa); } SV.SaveChanges(); MessageBox.Show("Added successfully"); } catch (Exception) { MessageBox.Show("Added unsuccessfully"); } }
private void button3_Click(object sender, EventArgs e) { bool success = true; foreach (DataGridViewRow rw in this.dataGridView1.Rows) { tbl_SinhVien SinhVien = new tbl_SinhVien(); tbl_Diem Diem = new tbl_Diem(); if (rw.Cells["MSSV"].Value == null || rw.Cells["MSSV"].Value == DBNull.Value || String.IsNullOrWhiteSpace(rw.Cells["MSSV"].Value.ToString())) { continue; } //Check ton tai trong tbl_SinhVien string valueCheck = rw.Cells["MSSV"].Value.ToString(); var check = (from s in SV.tbl_SinhVien where s.MSSV == valueCheck select s).FirstOrDefault(); if (check == null) { //Check MSSV bool kh = false; string temp = rw.Cells["MSSV"].Value.ToString(); string temp2 = ""; int i = 0; do { temp2 += temp[i]; i++; } while (i < temp.Length && !Char.IsDigit(temp[i])); var khoa = (from s in SV.tbl_Khoa select s.MaKhoa).ToList(); if (Login.MaKhoa == "QT") { for (int r = 0; r < khoa.Count; r++) { if (khoa[r] == temp2) { kh = true; break; } } } else { if (Login.MaKhoa == temp2) { kh = true; } } //Add if (kh == true) { SinhVien.MSSV = rw.Cells["MSSV"].Value.ToString(); SinhVien.Ho = rw.Cells["Ho"].Value.ToString(); SinhVien.Ten = rw.Cells["Ten"].Value.ToString(); SinhVien.MaKhoa = temp2; SV.tbl_SinhVien.Add(SinhVien); //Check MaMH var mamh = (from s in SV.tbl_DMMonHoc where s.MaKhoa == temp2 select s.MaMH).ToList(); bool checkMaMH = false; for (int r = 0; r < mamh.Count; r++) { if (mamh[r] == rw.Cells["MaMH"].Value.ToString()) { checkMaMH = true; break; } } if (checkMaMH == true) { Diem.MSSV = rw.Cells["MSSV"].Value.ToString(); Diem.MaMH = rw.Cells["MaMH"].Value.ToString(); Double k; if (Double.TryParse(rw.Cells["Diem"].Value.ToString(), out k)) { Diem.Diem = k; } else if (rw.Cells["Diem"].Value.ToString() != "") { MessageBox.Show("Student " + rw.Cells["MSSV"].Value.ToString() + " does not have valid score!"); success = false; } SV.tbl_Diem.Add(Diem); } else { MessageBox.Show("Student " + rw.Cells["MSSV"].Value.ToString() + " does not have valid MaMH!"); success = false; } } else { MessageBox.Show("Student " + rw.Cells["MSSV"].Value.ToString() + " does not have valid MSSV!"); success = false; } } else { //Update check.Ho = rw.Cells["Ho"].Value.ToString(); check.Ten = rw.Cells["Ten"].Value.ToString(); //Check ton tai trong tbl_Diem string valueCheck2 = rw.Cells["MSSV"].Value.ToString(); string MaMH = rw.Cells["MaMH"].Value.ToString(); var check2 = (from s in SV.tbl_Diem where s.MSSV == valueCheck2 && s.MaMH == MaMH select s).FirstOrDefault(); //Update if (check2 != null) { double score; if (Double.TryParse(rw.Cells["Diem"].Value.ToString(), out score)) { check2.Diem = score; } else if (rw.Cells["Diem"].Value.ToString() != "") { MessageBox.Show("Student " + rw.Cells["MSSV"].Value.ToString() + " does not have valid score!"); success = false; } } else { //Check MaMh string temp = rw.Cells["MSSV"].Value.ToString(); string temp2 = ""; int i = 0; do { temp2 += temp[i]; i++; } while (i < temp.Length && !Char.IsDigit(temp[i])); var mamh = (from s in SV.tbl_DMMonHoc where s.MaKhoa == temp2 select s.MaMH).ToList(); bool checkMaMH = false; for (int r = 0; r < mamh.Count; r++) { if (mamh[r] == rw.Cells["MaMH"].Value.ToString()) { checkMaMH = true; break; } } //Add if (checkMaMH == true) { Diem.MSSV = rw.Cells["MSSV"].Value.ToString(); Diem.MaMH = rw.Cells["MaMH"].Value.ToString(); Double k; if (Double.TryParse(rw.Cells["Diem"].Value.ToString(), out k)) { Diem.Diem = k; } else if (rw.Cells["Diem"].Value.ToString() != "") { MessageBox.Show("Student " + rw.Cells["MSSV"].Value.ToString() + " does not have valid score!"); success = false; } SV.tbl_Diem.Add(Diem); } else { MessageBox.Show("Student " + rw.Cells["MSSV"].Value.ToString() + " does not have valid MaMH!"); success = false; } } } } SV.SaveChanges(); if (success == true) { MessageBox.Show("Saved successfully"); } if (Login.MaKhoa == "QT") { comboBox2.Enabled = true; } ReloadSV(); }
private void button1_Click(object sender, EventArgs e) { string MaKhoa = label4.Text; if (MaKhoa != "Them") { //Check var k = (from s in SV.tbl_Khoa where s.MaKhoa == textBox1.Text && s.TenKhoa == textBox2.Text select s).ToList(); if (k.Count == 0) { //Change TenKhoa tbl_Khoa theOne = (from s in SV.tbl_Khoa where s.MaKhoa == MaKhoa select s).FirstOrDefault <tbl_Khoa>(); theOne.TenKhoa = textBox2.Text; //Check if MaKhoa was changed if (theOne.MaKhoa != textBox1.Text) { tbl_Khoa dn = new tbl_Khoa(); dn.MaKhoa = textBox1.Text; dn.TenKhoa = textBox2.Text; SV.tbl_Khoa.Add(dn); SV.SaveChanges(); var o = (from s in SV.tbl_DangNhap where s.MaKhoa == MaKhoa select s).ToList(); for (int i = 0; i < o.Count; i++) { o[i].MaKhoa = textBox1.Text; } var p = (from s in SV.tbl_SinhVien where s.MaKhoa == MaKhoa select s).ToList(); for (int i = 0; i < p.Count; i++) { p[i].MaKhoa = textBox1.Text; } SV.tbl_Khoa.Remove((from s in SV.tbl_Khoa where s.MaKhoa == MaKhoa select s).FirstOrDefault()); /* * tbl_Khoa theOne = (from s in SV.tbl_Khoa * where s.MaKhoa == MaKhoa * select s).FirstOrDefault<tbl_Khoa>(); * theOne.MaKhoa = textBox1.Text; * theOne.TenKhoa = textBox2.Text; * SV.SaveChanges(); */ } SV.SaveChanges(); MessageBox.Show("Edited successfully!"); } else { MessageBox.Show("You didn't edit anything!"); } } else { var o = (from s in SV.tbl_Khoa where s.MaKhoa == textBox1.Text && s.TenKhoa == textBox2.Text select s).ToList(); if (o.Count == 0) { tbl_Khoa dn = new tbl_Khoa(); dn.MaKhoa = textBox1.Text; dn.TenKhoa = textBox2.Text; SV.tbl_Khoa.Add(dn); SV.SaveChanges(); MessageBox.Show("Added successfully!"); } else { MessageBox.Show("Added unsuccessfully!"); } } Main.ReloadKhoa(); this.Close(); }