private void btnUpdate_Click(object sender, EventArgs e) { if (button == "Add") { client = new ObjCustomer(txtCustomerCode.Text, txtCustomerName.Text, txtPhone.Text, txtNote.Text); server = new LogicCustomer(); DataSet dataset_Check = server.getDataBase(client); if (dataset_Check.Tables[0].Rows.Count > 0) { MessageBox.Show("Sản phẩm này đã tồn tại trong danh sách", "", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { server.setDataBase(client, button); dataset_Check = server.getDataBase("KhachHang"); dataGridView.DataSource = dataset_Check.Tables[0]; } enable_button(0); button = ""; return; } if (button == "Edit") { client_edited = new ObjCustomer(txtCustomerCode.Text, txtCustomerName.Text, txtPhone.Text, txtNote.Text); server = new LogicCustomer(); server.editDataBase(client, client_edited); DataSet dataset_edit = server.getDataBase("KhachHang"); 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 ObjCustomer(txtCustomerCode.Text, txtCustomerName.Text, txtPhone.Text, txtNote.Text); server = new LogicCustomer(); server.setDataBase(client, button); DataSet dataset_AfterDeleting = server.getDataBase("KhachHang"); dataGridView.DataSource = dataset_AfterDeleting.Tables[0]; } }
public void setDataBase(ObjCustomer client, string button) { if (button == "Add") { bool ok = Connection.Instance.setData("INSERT INTO" + nameOfTable + "VALUES('" + client.Customercode + "', N'" + client.Name + "', '" + client.Phone + "', 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 MaKhach = '" + client.Customercode + "'"); return; } }
public void editDataBase(ObjCustomer client_initial, ObjCustomer client_edited) { Connection.Instance.setData("UPDATE" + nameOfTable + "SET MaKhach = '" + client_edited.Customercode + "', TenKhach = N'" + client_edited.Name + "', SoDT = '" + client_edited.Phone + "', GhiChu = N'" + client_edited.Note + "' WHERE MaKhach = '" + client_initial.Customercode + "';"); return; }
public DataSet getDataBase(ObjCustomer client) { return(Connection.Instance.getData("SELECT * FROM" + nameOfTable + "WHERE MaKhach = '" + client.Customercode + "'")); }
private void btnEdit_Click(object sender, EventArgs e) { enable_button(1); button = "Edit"; client = new ObjCustomer(txtCustomerCode.Text, txtCustomerName.Text, txtPhone.Text, txtNote.Text); }