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