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