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();
}
