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 + "'"));
}
