private void btnThem_Click(object sender, EventArgs e) { maLop = txtMaLop.Text.Trim(); tenLop = txtTenLop.Text.Trim(); maKhoa = busLop.GetMaKhoa(cbbKhoa.Text.Trim()); DTO_Lop Lop = new DTO_Lop(maLop, maKhoa, tenLop); if (busLop.KiemTraMaTrung(maLop) == 1) { MessageBox.Show("Đã tồn tại mã lớp! Mời bạn nhập lại"); } else { try { MessageBox.Show(maLop + maKhoa + tenLop); MessageBox.Show("Bạn đã thêm thành công"); busLop.ThemLop(Lop); dataGridView1.DataSource = busLop.GetLop(); Xoa(); } catch (Exception A) { MessageBox.Show(A.Message); } } }
public bool suaLop(DTO_Lop pLop) { dbConn.Open(); string cmd = "UPDATE LOP SET TENLOP=N'" + pLop.TenLop + "',MAKHOA='" + pLop.MaKhoa + "' WHERE MALOP='" + pLop.MaLop + "'"; SqlCommand sqlCmd = new SqlCommand(cmd, dbConn); sqlCmd.ExecuteNonQuery(); dbConn.Close(); return(true); }
public bool themLop(DTO_Lop pLop) { dbConn.Open(); string cmd = "INSERT INTO LOP VALUES(N'" + pLop.MaLop + "',N'" + pLop.TenLop + "',N'" + pLop.MaKhoa + "')"; SqlCommand sqlCmd = new SqlCommand(cmd, dbConn); sqlCmd.ExecuteNonQuery(); dbConn.Close(); return(true); }
private void button2_Click(object sender, EventArgs e) { //themLop(txtMaLop.Text, txtTenLop.Text, comKhoa.SelectedValue.ToString()); DTO_Lop Lop = new DTO_Lop(txtMaLop.Text, txtTenLop.Text, comKhoa.SelectedValue.ToString()); bus_lop.themLop(Lop); txtMaLop.Text = ""; txtTenLop.Text = ""; this.Lop_Load(sender, e); }
private void button4_Click(object sender, EventArgs e) { try { DTO_Lop Lop = new DTO_Lop(txtMaLop.Text, txtTenLop.Text, comKhoa.SelectedValue.ToString()); bus_lop.suaLop(Lop); txtMaLop.Text = ""; txtTenLop.Text = ""; this.Lop_Load(sender, e); } catch { MessageBox.Show("Sửa không thành công. Vui lòng kiểm tra lại", "Thông báo"); } }
private void button4_Click(object sender, EventArgs e) { //adap.UpdateCommand = new SqlCommand("SP_LOP_Update", dbConn); //adap.UpdateCommand.CommandType = CommandType.StoredProcedure; //adap.UpdateCommand.Parameters.Add("@MALOP", SqlDbType.VarChar).SourceColumn = "MALOP"; //adap.UpdateCommand.Parameters.Add("@TENLOP", SqlDbType.NVarChar).SourceColumn = "TENLOP"; //adap.UpdateCommand.Parameters.Add("@MAKHOA", SqlDbType.NVarChar).SourceColumn = "MAKHOA"; //adap.Update(ds); //dbConn.Close(); //suaLop(txtMaLop.Text, txtTenLop.Text, comKhoa.SelectedValue.ToString()); DTO_Lop Lop = new DTO_Lop(txtMaLop.Text, txtTenLop.Text, comKhoa.SelectedValue.ToString()); bus_lop.suaLop(Lop); txtMaLop.Text = ""; txtTenLop.Text = ""; this.Lop_Load(sender, e); }
private void btnSua_Click(object sender, EventArgs e) { maLop = txtMaLop.Text.Trim(); tenLop = txtTenLop.Text.Trim(); maKhoa = busLop.GetMaKhoa(cbbKhoa.Text.Trim()); DTO_Lop Lop = new DTO_Lop(maLop, maKhoa, tenLop); try { MessageBox.Show("Bạn đã sửa thành công"); busLop.SuaLop(maLop, Lop); dataGridView1.DataSource = busLop.GetLop(); Xoa(); } catch (Exception A) { MessageBox.Show(A.Message); } }
public void SuaLop(string maLop, DTO_Lop Lop) { try { sqlCon.Open(); string strQuery = string.Format(@"Update dbo.Lop Set tenLop=N'{0}',maKhoa='{1}' Where maLop ='{2}'", Lop.TenLop, Lop.MaKhoa, maLop); SqlCommand sqlCom = new SqlCommand(strQuery, sqlCon); sqlCom.ExecuteNonQuery(); } catch (Exception e) { Console.WriteLine(e.Message); } finally { sqlCon.Close(); } }
public void ThemLop(DTO_Lop Lop) { try { sqlCon.Open(); string strQuery = string.Format(@"Insert Into dbo.Lop (maLop,maKhoa,tenLop) Values('{0}','{1}',N'{2}')", Lop.MaLop, Lop.MaKhoa, Lop.TenLop); SqlCommand sqlCom = new SqlCommand(strQuery, sqlCon); sqlCom.ExecuteNonQuery(); } catch (Exception e) { Console.WriteLine(e.Message); } finally { sqlCon.Close(); } }
public bool suaLop(DTO_Lop pLop) { return(dal_Lop.suaLop(pLop)); }
public bool themLop(DTO_Lop pLop) { return(dal_Lop.themLop(pLop)); }
public void SuaLop(string maLop, DTO_Lop Lop) { dalLop.SuaLop(maLop, Lop); }
public void ThemLop(DTO_Lop Lop) { dalLop.ThemLop(Lop); }