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