private void gunaButton1_Click(object sender, EventArgs e)
{
this.IsMdiContainer = true;
form_equipments form_equipments = new form_equipments(username);
form_equipments.MdiParent = this;
form_equipments.Show();
}
private void button1_Click(object sender, EventArgs e)
{
asset_format = "AU-" + cmb_branch.Text + DateTime.Now.ToString("-yyyy-MM-");
try
{
if (action == "add")
{
validate();
if (error == 0)
{
Account.executeSQL("INSERT INTO tblequipments VALUES ('" + asset_format + "' , ' ' ,'" + txtb_serial.Text +
"' , '" + cmb_branch.Text + "' , '" + cmb_model.Text + "' , '" + txtb_desc.Text + "' , '" + cmb_status.Text + "' , '" + cmb_available.Text + "')");
if (Account.rowAffected > 0)
{
//select inserted item
DataTable dt = Account.GetData("select concat(asset_number,num) as asset from tblequipments where asset_number = '" + asset_format + "' ");
string result = dt.Rows[0].Field <string>("asset");
//update asset number
Account.executeSQL(" update tblequipments set asset_number = '" + result + "' where asset_number = '" + asset_format + "' ");
MessageBox.Show("New equipment Added", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
Account.executeSQL("INSERT INTO tbllogs VALUES ('" + DateTime.Now.ToString() +
"' , 'added new equipment, asset number : " + result + "' , 'Equipments Management' , '" + username + "')");
this.Hide();
//refresh datagrid
form_equipments add = (form_equipments)Application.OpenForms["form_equipments"];
add.refresh();
}
}
}
else if (action == "update")
{
Account.executeSQL(" update tblequipments set serial_number = '" + txtb_serial.Text + "' , branch = '" + cmb_branch.Text + "' , model = '" + cmb_model.Text + "' , description = '" + txtb_desc.Text + "' , status = '" + cmb_status.Text + "' , available = '" + cmb_available.Text + "' where asset_number = '" + assset_number + "' ");
if (Account.rowAffected > 0)
{
MessageBox.Show(" equipment updated", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
Account.executeSQL("INSERT INTO tbllogs VALUES ('" + DateTime.Now.ToString() +
"' , 'updated equipment, asset number : " + asset_format + "' , 'Equipments Management' , '" +
username + "')");
this.Hide();
//refresh datagrid
form_equipments update = (form_equipments)Application.OpenForms["form_equipments"];
update.refresh();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
