public bool insertLop(Entities.tblLop lp)
{
bool check = false;
string sql = "sp_tblLop_Insert";
try
{
con = ds.getConnect();
cmd = new SqlCommand(sql, con);
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = sql;
cmd.Connection = con;
cmd.Parameters.Add("@idkhoa", SqlDbType.Int).Value = lp.Idkhoa;
cmd.Parameters.Add("@idnienkhoa", SqlDbType.Int).Value = lp.Idnienkhoa;
cmd.Parameters.Add("@malop", SqlDbType.NVarChar).Value = lp.Malop;
cmd.Parameters.Add("@tenlop", SqlDbType.NVarChar).Value = lp.Tenlop;
cmd.Parameters.Add("@siso", SqlDbType.Int).Value = lp.Siso;
cmd.ExecuteNonQuery();
check = true;
}
catch (Exception ex)
{
ex.ToString();
}
finally
{
cmd.Dispose();
con.Close();
}
return(check);
}
public bool deleteLop(Entities.tblLop lp)
{
bool check = false;
string sql = "sp_tblLop_Delete";
try
{
con = ds.getConnect();
cmd = new SqlCommand(sql, con);
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = sql;
cmd.Connection = con;
cmd.Parameters.Add("@id", SqlDbType.Int).Value = lp.Id;
cmd.ExecuteNonQuery();
check = true;
}
catch (Exception ex)
{
ex.ToString();
}
finally
{
cmd.Dispose();
con.Close();
}
return(check);
}
public bool deleteLop(Entities.tblLop lp)
{
return(dal.deleteLop(lp));
}
public bool updateLop(Entities.tblLop lp)
{
return(dal.updateLop(lp));
}
public bool insertLop(Entities.tblLop lp)
{
return(dal.insertLop(lp));
}
private void btnSave_Click(object sender, EventArgs e)
{
if (int.TryParse(lblIdTrangThai.Text, out _Idtt))
{
}
if (int.TryParse(lblsiso.Text, out _ss))
{
}
if (int.TryParse(lblidtaikhoan.Text, out _Idtk))
{
}
if (int.TryParse(lblidchuongtrinh.Text, out _Idct))
{
}
if (int.TryParse(lblmakhoa.Text, out _Idkh))
{
}
if (int.TryParse(lblidtinchi.Text, out _Idtc))
{
}
if (int.TryParse(lblidsinhvien.Text, out _Idsv))
{
}
if (int.TryParse(lblidnienkhoa.Text, out _Idnk))
{
}
if (int.TryParse(lblidmonhoc.Text, out _Idmh))
{
}
if (int.TryParse(lblidketqua.Text, out _Idkq))
{
}
if (int.TryParse(lblIdLop.Text, out _Idlp))
{
}
if (int.TryParse(lblIdHocKy.Text, out _Idhk))
{
}
if (int.TryParse(lblidnhom.Text, out _Idnh))
{
}
if (float.TryParse(txtDiemThiLan1.Text, out dtl1))
{
}
if (float.TryParse(txtDiemThiLan2.Text, out dtl2))
{
}
if (float.TryParse(lbldiemtongket.Text, out dtk))
{
}
if (DateTime.TryParse(lblnamsinh.Text, out _ns))
{
}
if (float.TryParse(txtDiemThiLan1.Text, out dtl1))
{
}
if (float.TryParse(txtDiemThiLan2.Text, out dtl2))
{
}
dtb = DiemTrungBinh(dtl1, dtl2);
Entities.tblKetQua kq = new Entities.tblKetQua();
kq.Id = _Idkq;
kq.Idsinhvien = _Idsv;
kq.Idmonhoc = _Idmh;
kq.Diemthilan1 = dtl1;
kq.Diemthilan2 = dtl2;
kq.Diemtrungbinh = dtb;
kq.Diemtongket = dtk;
kq.Hanhkiem = lblhanhkiem.Text;
kq.Ghichu = lblghichu.Text;
Entities.tblMonHoc mh = new Entities.tblMonHoc();
mh.Id = _Idmh;
mh.Idchuongtrinh = _Idct;
mh.Idhocky = _Idhk;
mh.Idtinchi = _Idtc;
mh.Mamonhoc = lblmamonhoc.Text;
mh.Tenmonhoc = lbltenmonhoc.Text;
Entities.tblLop lp = new Entities.tblLop();
lp.Id = _Idlp;
lp.Idkhoa = _Idkh;
lp.Malop = lblmalop.Text;
lp.Tenlop = label5.Text;
lp.Siso = _ss;
Entities.tblSinhVien sv = new Entities.tblSinhVien();
sv.Id = _Idsv;
sv.Idlop = _Idlp;
sv.Idtaikhoan = _Idtk;
sv.Idtrangthai = _Idtt;
Entities.tblTaiKhoan tk = new Entities.tblTaiKhoan();
tk.Id = _Idtk;
tk.Idnhom = _Idnh;
tk.Tentaikhoan = lbltentaikhoan.Text;
tk.Matkhau = lblmatkhau.Text;
tk.Hoten = cbxTenSinhVien.Text;
tk.Namsinh = _ns;
tk.Gioitinh = lblgioitinh.Text;
tk.Diachi = lbldiachi.Text;
tk.Email = lblemail.Text;
tk.Dienthoai = lbldienthoai.Text;
Entities.tblHocKy hk = new Entities.tblHocKy();
hk.Id = _Idhk;
hk.Mahocky = lblmahocky.Text;
hk.Tenhocky = label5.Text;
Entities.tblKhoa kh = new Entities.tblKhoa();
kh.Id = _Idkh;
kh.Makhoa = lblmakhoa.Text;
kh.Tenkhoa = lblTenKhoa.Text;
if (flag == "update")
{
bool check = bllKetQua.updateKetQua(kq);
bllMonHoc.updateMonHoc(mh);
bllSinhVien.updateSinhVien(sv);
bllTaiKhoan.updateTaiKhoan(tk);
if (check)
{
MessageBox.Show("Cập nhật thành công.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
ReLoad();
}
ReLoad();
dgvKetQua_SelectionChanged(sender, e);
}
