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