private void button1_Click(object sender, EventArgs e) { bool erro = false; DataGridViewRow row = DShsgridview.SelectedRows[0]; string mail = row.Cells[4].Value.ToString(); HSB.GetMaHS(mail); string ML = ""; foreach (var i in clasDTO.lop) { if (Classcombo.SelectedItem.ToString() == i.TenL1) { ML = i.MaL1; } } string mct = ML + HocSinhDTO.id.ToString(); ChiTietClass ct = new ChiTietClass(mct, ML, HocSinhDTO.id, 0, 0); if (ML != "") { foreach (var m in ChiTietClass.ctclas) { if (mct == m.MaCT1) { erro = true; MessageBox.Show("mã chi tiết lớp đã tồn tại"); break; } else { if (m.MaHS1 == HocSinhDTO.id) { erro = true; MessageBox.Show("học sinh đã có lớp"); break; } } } if (erro == false) { HSB.InsertCT(ct); MessageBox.Show("successfull"); HSB.Load(); } } }
public void Get() { HocSinhDBDataContext hdb = new HocSinhDBDataContext(); try { HocSinhDTO.lisths.Clear(); var q0 = from s0 in hdb.Hoc_sinhs select s0; foreach (var x in q0) { DateTime oDate = Convert.ToDateTime(x.Date); bool kt; if (bool.Parse(x.Sex) == true) { kt = true; } else { kt = false; } HocSinhDTO hs = new HocSinhDTO(x.Name, x.Email, x.Address, kt, oDate); HocSinhDTO.lisths.Add(hs); } var q = from s in hdb.THAMSOs select s.TuoiToiThieu; var kq = q.FirstOrDefault(); HocSinhDTO.toithieu = int.Parse(kq.ToString()); var q2 = from s in hdb.THAMSOs select s.TuoiToiDa; var kq2 = q2.FirstOrDefault(); HocSinhDTO.toida = int.Parse(kq2.ToString()); ChiTietClass.ctclas.Clear(); var ct = from st in hdb.CHITIETDSLOPs select st; foreach (var x in ct) { string tb1 = x.TBHocKi1.ToString(); string tb2 = x.TBHocKi2.ToString(); ChiTietClass hsct = new ChiTietClass(x.MaChiTietDSLop, x.MaLop, x.MaHocSinh, float.Parse(tb1), float.Parse(tb2)); ChiTietClass.ctclas.Add(hsct); } } catch { } }
public bool InsertHStoClass(ChiTietClass CT) { try { HocSinhDBDataContext hdb = new HocSinhDBDataContext(); CHITIETDSLOP L = new CHITIETDSLOP { MaChiTietDSLop = CT.MaCT1, MaLop = CT.MaL1, MaHocSinh = CT.MaHS1, TBHocKi1 = CT.TB11, TBHocKi2 = CT.TB21 }; hdb.CHITIETDSLOPs.InsertOnSubmit(L); hdb.SubmitChanges(); return(true); } catch { return(false); } }
public bool InsertCT(ChiTietClass ct) { return(HS.InsertHStoClass(ct)); }