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