private void btnUpdate_Click(object sender, EventArgs e)
{
if (button == "Add")
{
client = new ObjProductType(txtTypeCode.Text, txtTypeName.Text);
server = new LogicProductType();
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("LoaiSP");
dataGridView.DataSource = dataset_Check.Tables[0];
}
enable_button(0);
button = "";
return;
}
if (button == "Edit")
{
client_edited = new ObjProductType(txtTypeCode.Text, txtTypeName.Text);
server = new LogicProductType();
server.editDataBase(client, client_edited);
DataSet dataset_edit = server.getDataBase("LoaiSP");
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 ObjProductType(txtTypeCode.Text, txtTypeName.Text);
server = new LogicProductType();
server.setDataBase(client, button);
DataSet dataset_AfterDeleting = server.getDataBase("LoaiSP");
dataGridView.DataSource = dataset_AfterDeleting.Tables[0];
}
}
public void setDataBase(ObjProductType client, string button)
{
if (button == "Add")
{
bool ok = Connection.Instance.setData("INSERT INTO LoaiSP VALUES('" + client.Code + "', N'" + client.Name + "')");
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 LoaiSP WHERE MaLoai = '" + client.Code + "'");
return;
}
}
private void btnEdit_Click(object sender, EventArgs e)
{
enable_button(1);
button = "Edit";
client = new ObjProductType(txtTypeCode.Text, txtTypeName.Text);
}
public void editDataBase(ObjProductType client_initial, ObjProductType client_edited)
{
Connection.Instance.setData("UPDATE LoaiSP SET MaLoai = '" + client_edited.Code + "', TenLoai = N'" + client_edited.Name + "' WHERE MaLoai = '" + client_initial.Code + "'");
return;
}
public DataSet getDataBase(ObjProductType client)
{
return(Connection.Instance.getData("SELECT * FROM LoaiSP WHERE MaLoai = '" + client.Code + "'"));
}
