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