private void addData(NCCObj ncc)
{
ncc.MaNCC = txtmancc.Text.Trim();
ncc.DiaChi = txtdiachi.Text.Trim();
ncc.Sdt = txtsdt.Text.Trim();
ncc.TenNCC = txttenncc.Text.Trim();
}
public bool UpdData(NCCObj nccObj)
{
cmd.CommandText = "UPDATE NHACC SET TENNCC = N'" + nccObj.TenNCC + "', SDT = '" + nccObj.Sdt + "', DIACHI = N'" + nccObj.DiaChi + "' WHERE MANCC = '" + nccObj.MaNCC + "'";
cmd.CommandType = CommandType.Text;
cmd.Connection = con.Connection;
try
{
con.OpenConn();
cmd.ExecuteNonQuery();
con.CloseConn();
return(true);
}
catch (Exception ex)
{
string mex = ex.Message;
cmd.Dispose();
con.CloseConn();
}
return(false);
}
public bool AddData(NCCObj nccObj)
{
cmd.CommandText = "INSERT INTO NHACC VALUES ('" + nccObj.MaNCC + "', N'" + nccObj.TenNCC + "', N'" + nccObj.DiaChi + "', N'" + nccObj.Sdt + "')";
cmd.CommandType = CommandType.Text;
cmd.Connection = con.Connection;
try
{
con.OpenConn();
cmd.ExecuteNonQuery();
con.CloseConn();
return(true);
}
catch (Exception ex)
{
string mex = ex.Message;
cmd.Dispose();
con.CloseConn();
}
return(false);
}
public bool updData(NCCObj nccObj)
{
return(nccMod.UpdData(nccObj));
}
public bool addData(NCCObj nccObj)
{
return(nccMod.AddData(nccObj));
}
