private void btnLuu_Click(object sender, EventArgs e)
{
NhaCungCapObj nccObj = new NhaCungCapObj();
addData(nccObj);
if (flagLuu == 0)
{
if (nccCtr.AddData(nccObj))
{
MessageBox.Show("Thêm thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Thêm không thành công!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
if (nccCtr.UpdData(nccObj))
{
MessageBox.Show("Sửa thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Sửa không thành công!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
frmNhaCungCap_Load(sender, e);
}
private void addData(NhaCungCapObj ncc)
{
ncc.MaNhaCungCap = txtMaNCC.Text.Trim();
ncc.TenNhaCungCap = txtTenNCC.Text.Trim();
ncc.DiaChi = txtDiaChi.Text.Trim();
ncc.Email = txtEmail.Text.Trim();
ncc.SoDT = txtSoDT.Text.Trim();
}
public bool UpdData(NhaCungCapObj nccObj)
{
cmd.CommandText = "Update NhaCungCap set TenNCC = N'" + nccObj.TenNhaCungCap + "', DiaChi = N'" + nccObj.DiaChi + "', Email = N'" + nccObj.Email + "',SoDT = '" + nccObj.SoDT + "' Where MaNCC = '" + nccObj.MaNhaCungCap + "'";
cmd.CommandType = CommandType.Text;
cmd.Connection = con.Connection;
try
{
con.OpenConn();
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
string mex = ex.Message;
cmd.Dispose();
con.CloseConn();
}
return(false);
}
public bool AddData(NhaCungCapObj nccObj)
{
cmd.CommandText = "Insert into NhaCungCap values ('" + nccObj.MaNhaCungCap + "',N'" + nccObj.TenNhaCungCap + "',N'" + nccObj.DiaChi + "',N'" + nccObj.Email + "','" + nccObj.SoDT + "')";
cmd.CommandType = CommandType.Text;
cmd.Connection = con.Connection;
try
{
con.OpenConn();
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
string mex = ex.Message;
cmd.Dispose();
con.CloseConn();
}
return(false);
}
public bool UpdDataNCC(NhaCungCapObj nccObj)
{
cmd.CommandText = "Update NCC set tenncc = N'" + nccObj.TenNhaCungCap + "', diachi = N'" + nccObj.DiaChi + "', sdt = '" + nccObj.SoDienThoai + "', ghichu =N'" + nccObj.GhiChu + "' Where mancc = '" + nccObj.MaNhaCungCap + "'";
cmd.CommandType = CommandType.Text;
cmd.Connection = con.Connection;
try
{
con.OpenConn();
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
string mex = ex.Message;
cmd.Dispose();
con.CloseConn();
}
return(false);
}
//Sửa dữ liệu
public bool UpdateData(NhaCungCapObj nccObj)
{
cmd.CommandText = string.Format("UPDATE tblNhaCC SET MANHACC = '{0}', TENNHACC = N'{1}', DIACHI = N'{2}', DIENTHOAI = '{3}', EMAIL = '{4}' WHERE (MANHACC = '{0}')", nccObj.MaNCC, nccObj.TenNCC, nccObj.DiaChi, nccObj.Sdt, nccObj.Email);
cmd.CommandType = CommandType.Text;
cmd.Connection = con.Connection;
//Lấy dữ liệu về
try
{
con.openCon();
cmd.ExecuteNonQuery();
con.closeCon();
return(true);
}
catch (Exception ex)
{
string mes = ex.Message;
cmd.Dispose();
con.closeCon();
}
return(false);
}
//Thêm dữ liệu
public bool AddData(NhaCungCapObj nccObj)
{
cmd.CommandText = string.Format("INSERT INTO tblNhaCC (MANHACC, TENNHACC, DIACHI, DIENTHOAI, EMAIL) VALUES ('{0}', N'{1}', N'{2}', '{3}', '{4}')", nccObj.MaNCC, nccObj.TenNCC, nccObj.DiaChi, nccObj.Sdt, nccObj.Email);
cmd.CommandType = CommandType.Text;
cmd.Connection = con.Connection;
//Lấy dữ liệu về
try
{
con.openCon();
cmd.ExecuteNonQuery();
con.closeCon();
return(true);
}
catch (Exception ex)
{
string mes = ex.Message;
cmd.Dispose();
con.closeCon();
}
return(false);
}
public bool updateData(NhaCungCapObj nccObj)
{
return(nccMod.UpdateData(nccObj));
}
public bool addData(NhaCungCapObj nccObj)
{
return(nccMod.AddData(nccObj));
}
public bool updDateNCC(NhaCungCapObj nccObj)
{
return(nccMod.UpdDataNCC(nccObj));
}
