private void btnUpdate_Click(object sender, EventArgs e) { if (button == "Add") { client = new ObjSupplier(txtSupplierCode.Text, txtName.Text, txtNote.Text); server = new LogicSupplier(); DataSet dataset_Check = server.getDataBase(client); if (dataset_Check.Tables[0].Rows.Count > 0) { MessageBox.Show("Nhà cung cấp này đã tồn tại trong danh sách", "", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { server.setDataBase(client, button); dataset_Check = server.getDataBase("NguonCungCap"); dataGridView.DataSource = dataset_Check.Tables[0]; } enable_button(0); button = ""; return; } if (button == "Edit") { client_edited = new ObjSupplier(txtSupplierCode.Text, txtName.Text, txtNote.Text); server = new LogicSupplier(); server.editDataBase(client, client_edited); DataSet dataset_edit = server.getDataBase("NguonCungCap"); dataGridView.DataSource = dataset_edit.Tables[0]; enable_button(0); button = ""; return; } }
private void btnDelete_Click(object sender, EventArgs e) { DialogResult res = MessageBox.Show("Bạn có chắc muốn xóa loại sản phẩm này?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question); button = "Delete"; if (res == DialogResult.Yes) { client = new ObjSupplier(txtSupplierCode.Text, txtName.Text, txtNote.Text); server = new LogicSupplier(); server.setDataBase(client, button); DataSet dataset_AfterDeleting = server.getDataBase("NguonCungCap"); dataGridView.DataSource = dataset_AfterDeleting.Tables[0]; } }
public void setDataBase(ObjSupplier client, string button) { if (button == "Add") { bool ok = Connection.Instance.setData("INSERT INTO" + nameOfTable + "VALUES('" + client.Suppliercode + "', N'" + client.Name + "', N'" + client.Note + "');"); if (ok) { MessageBox.Show("Thêm thông tin thành công", "", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Thêm thông tin thất bại", "", MessageBoxButtons.OK, MessageBoxIcon.Error); } return; } if (button == "Delete") { Connection.Instance.setData("DELETE FROM" + nameOfTable + "WHERE MaNguon = '" + client.Suppliercode + "'"); return; } }
private void btnEdit_Click(object sender, EventArgs e) { enable_button(1); button = "Edit"; client = new ObjSupplier(txtSupplierCode.Text, txtName.Text, txtNote.Text); }
public void editDataBase(ObjSupplier client_initial, ObjSupplier client_edited) { Connection.Instance.setData("UPDATE" + nameOfTable + "SET MaNguon = '" + client_edited.Suppliercode + "', TenNguon = N'" + client_edited.Name + "', GhiChu = N'" + client_edited.Note + "' WHERE MaNguon = '" + client_initial.Suppliercode + "';"); return; }
public DataSet getDataBase(ObjSupplier client) { return(Connection.Instance.getData("SELECT * FROM" + nameOfTable + "WHERE MaNguon = '" + client.Suppliercode + "'")); }