public void UpdateSinhvien(Sinhvien sv)
{
string query = "UPDATE sinhvien SET tensinhvien = '" + sv.ten + "', passwords = '" + sv.password + "', gioitinh = '" + sv.gioi_tinh + "', namsinh = '" + sv.ngay_sinh.ToString("MM/dd/yyyy") + "', sdt = '" + sv.sdt + "', diachi = '" + sv.diachi + "', dahoc ='"+ khlisttoidstring(sv.da_hoc) +"', danghoc = '"+khlisttoidstring(sv.dang_hoc) + "', dangky = '" + khlisttoidstring(sv.dang_ki) + "' WHERE idsinhvien = '" + sv.id + "';";
//open connection
if (this.OpenConnection() == true)
{
//create command and assign the query and connection from the constructor
MySqlCommand cmd = new MySqlCommand(query, connection);
//Execute command
cmd.ExecuteNonQuery();
//close connection
CloseConnection();
update();
}
}
public void InsertSinhvien(Sinhvien sv)
{
string query = "INSERT INTO sinhvien (tensinhvien, passwords, gioitinh, namsinh, sdt, diachi) VALUES('"
+ sv.ten + "','" + sv.password + "','" + sv.gioi_tinh + "','" + sv.ngay_sinh.ToString("MM/dd/yyyy") + "','" + sv.sdt + "','" + sv.diachi + "');";
//open connection
if (this.OpenConnection() == true)
{
//create command and assign the query and connection from the constructor
MySqlCommand cmd = new MySqlCommand(query, connection);
//Execute command
cmd.ExecuteNonQuery();
//close connection
CloseConnection();
update();
}
}
private void b_save_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(tb_hoten.Text) || string.IsNullOrEmpty(tb_password.Text) || string.IsNullOrEmpty(tb_diachi.Text))
{
throw new Exception();
}
string sex = "nam";
if (rb_nam.Checked)
{
sex = "nam";
}
else if (rb_nu.Checked)
{
sex = "nu";
}
if (sv == null)
{
sv = new Sinhvien(tb_hoten.Text, tb_password.Text, sex, int.Parse(tb_sdt.Text), tb_diachi.Text, DateTime.Parse(tb_ngaysinh.Text));
sql.InsertSinhvien(sv);
}
else
{
sv.ten = tb_hoten.Text;
sv.password = tb_password.Text;
sv.gioi_tinh = sex;
sv.sdt = int.Parse(tb_sdt.Text);
sv.diachi = tb_diachi.Text;
sv.ngay_sinh = DateTime.Parse(tb_ngaysinh.Text);
sql.UpdateSinhvien(sv);
}
gui.updatebroad("Sinhvien");
this.Dispose();
}
catch (Exception ex)
{
l_error.Text = "Error";
Console.WriteLine(ex.Message);
}
}
public void Readhanle()
{
string str;
try
{
while ((str = reader.ReadLine()) != null)
{
Console.WriteLine(str);
string[] data = Regex.Split(str, "#@#");
if (data[0].Equals("Bang"))
{
if (data[1].Equals("Khoahoc"))
{
listKhoahoc(data[2]);
}
else if (data[1].Equals("Danghoc"))
{
listDanghoc(data[2]);
}
else if (data[1].Equals("Dahoc"))
{
listDahoc(data[2]);
}
else if (data[1].Equals("Dangki"))
{
listDangki(data[2]);
}
else if (data[1].Equals("Sinhvien"))
{
listSinhvien(data[2], data[3]);
}
else if (data[1].Equals("Diem"))
{
listDiem(data[2]);
}
}
else if (data[0].Equals("Dangky"))
{
int idkh = int.Parse(data[1]);
Console.WriteLine(sql.SelectDiem(sinhvien.id, idkh).Count);
if (sql.SelectDiem(sinhvien.id, idkh).Count > 0)
{
sql.DeleteDiem(sql.SelectDiem(sinhvien.id, idkh)[0]);
foreach (Khoahoc kh in sinhvien.dang_ki)
{
if (kh.id == idkh)
{
if (kh.danh_sach.Count() < kh.max_danhsach)
{
kh.trang_thai = "OPEN";
}
sinhvien.dang_ki.Remove(kh);
sql.UpdateSinhvien(sinhvien);
kh.danh_sach.Remove(sinhvien);
sql.UpdateKhoahoc(kh);
}
}
}
else
{
foreach (Khoahoc kh in sql.SearchKhoahoc(""))
{
if (kh.id == idkh && kh.trang_thai.Equals("OPEN"))
{
Diem diem = new Diem(sinhvien.id, kh.id, 0, 0, 0, 0);
sql.InsertDiem(diem);
Console.WriteLine("**");
kh.danh_sach.Add(sinhvien);
if (kh.danh_sach.Count() >= kh.max_danhsach)
{
kh.trang_thai = "CLOSE";
}
sql.UpdateKhoahoc(kh);
sinhvien.dang_ki.Add(kh);
sql.UpdateSinhvien(sinhvien);
}
}
}
listKhoahoc(data[2]);
updatesv();
}
else if (data[0].Equals("Login"))
{
bool t = false;
foreach (Sinhvien sv in sql.SearchSinhvien(""))
{
if (int.Parse(data[1]) == sv.id && sv.password.Equals(data[2]))
{
sinhvien = sv;
listKhoahoc("");
t = true;
}
}
if (t == false)
{
send("LoginFail");
throw new Exception();
}
}
}
}
catch (Exception ex)
{
writer.Close();
reader.Close();
stream.Close();
Console.WriteLine(ex);
Clientclose();
}
}
