public static int SetExtinguishers(String[,] values) { String connString = Properties.Settings.Default.FAFOS; SqlConnection con = new SqlConnection(connString); SqlCommand command; int temp = 1; int nExt = (values.Length / 9); con.Open(); for (int i = 0; i < nExt; i++) { MRoom r; if (values[i, 0] == null) { r = new MRoom(); values[i, 0] = r.getNewID("extinguisher_id", "Extinguisher"); if (values[i, 0] == null) { temp = 0; } if (values[i, 1] == null) { temp = 0; } if (values[i, 2] == null) { temp = 0; } if (values[i, 3] == null) { temp = 0; } if (values[i, 4] == null) { temp = 0; } if (values[i, 5] == null) { temp = 0; } if (values[i, 6] == null) { temp = 0; } if (values[i, 7] == null) { temp = 0; } if (values[i, 8] == null) { temp = 0; } if (temp == 0) { MessageBox.Show("please fill in all fields"); } else if (temp == 1) { command = new SqlCommand("INSERT INTO Extinguisher VALUES (" + values[i, 0] + ",'" + values[i, 1] + "','" + values[i, 2] + "','" + values[i, 3] + "','" + values[i, 4] + "'," + values[i, 5] + "," + values[i, 6] + "," + values[i, 7] + ",'" + values[i, 8] + "')", con); command.ExecuteNonQuery(); } } else { if (values[i, 0] == null) { temp = 0; } if (values[i, 1] == null) { temp = 0; } if (values[i, 2] == null) { temp = 0; } if (values[i, 3] == null) { temp = 0; } if (values[i, 4] == null) { temp = 0; } if (values[i, 5] == null) { temp = 0; } if (values[i, 6] == null) { temp = 0; } if (values[i, 7] == null) { temp = 0; } if (values[i, 8] == null) { temp = 0; } if (temp == 0) { MessageBox.Show("please fill in all fields"); } else if (temp == 1) { command = new SqlCommand("UPDATE Extinguisher SET location = '" + values[i, 1] + "', size = '" + values[i, 2] + "', type = '" + values[i, 3] + "', model = '" + values[i, 4] + "', serial = " + values[i, 5] + ", room_id = " + values[i, 6] + ", bar_code = " + values[i, 7] + ", manufacture_date = '" + values[i, 8] + "' WHERE extinguisher_id = " + values[i, 0], con); command.ExecuteNonQuery(); } } } con.Close(); return(temp); }
public static int SetExtinguishers(String[,] values) { String connString = Properties.Settings.Default.FAFOS; SqlConnection con = new SqlConnection(connString); SqlCommand command; int temp = 1; int nExt = (values.Length / 9); con.Open(); for (int i = 0; i < nExt; i++) { MRoom r; if (values[i, 0] == null) { r = new MRoom(); values[i, 0] = r.getNewID("extinguisher_id", "Extinguisher"); if (values[i, 0] == null) { temp = 0; } if (values[i, 1] == null) { temp = 0; } if (values[i, 2] == null) { temp = 0; } if (values[i, 3] == null) { temp = 0; } if (values[i, 4] == null) { temp = 0; } if (values[i, 5] == null) { temp = 0; } if (values[i, 6] == null) { temp = 0; } if (values[i, 7] == null) { temp = 0; } if (values[i, 8] == null) { temp = 0; } if (temp == 0) { MessageBox.Show("please fill in all fields"); } else if (temp == 1) { command = new SqlCommand("INSERT INTO Extinguisher VALUES (" + values[i, 0] + ",'" + values[i, 1] + "','" + values[i, 2] + "','" + values[i, 3] + "','" + values[i, 4] + "'," + values[i, 5] + "," + values[i, 6] + "," + values[i, 7] + ",'" + values[i, 8] + "')", con); command.ExecuteNonQuery(); } } else { if (values[i, 0] == null) { temp = 0; } if (values[i, 1] == null) { temp = 0; } if (values[i, 2] == null) { temp = 0; } if (values[i, 3] == null) { temp = 0; } if (values[i, 4] == null) { temp = 0; } if (values[i, 5] == null) { temp = 0; } if (values[i, 6] == null) { temp = 0; } if (values[i, 7] == null) { temp = 0; } if (values[i, 8] == null) { temp = 0; } if (temp == 0) { MessageBox.Show("please fill in all fields"); } else if (temp == 1) { command = new SqlCommand("UPDATE Extinguisher SET location = '" + values[i, 1] + "', size = '" + values[i, 2] + "', type = '" + values[i, 3] + "', model = '" + values[i, 4] + "', serial = " + values[i, 5] + ", room_id = " + values[i, 6] + ", bar_code = " + values[i, 7] + ", manufacture_date = '" + values[i, 8] + "' WHERE extinguisher_id = " + values[i, 0], con); command.ExecuteNonQuery(); } } } con.Close(); return temp; }
public static int SetLights(String[,] values) { String connString = Properties.Settings.Default.FAFOS; SqlConnection con = new SqlConnection(connString); SqlCommand command; int temp = 1; int nLight = (values.Length / 12); MRoom r; con.Open(); for (int i = 0; i < nLight; i++) { if (values[i, 0] == null) { r = new MRoom(); values[i, 0] = r.getNewID("light_id", "Light"); if (values[i, 0] == null) { temp = 0; } if (values[i, 1] == null) { temp = 0; } if (values[i, 2] == null) { temp = 0; } if (values[i, 3] == null) { temp = 0; } if (values[i, 4] == null) { temp = 0; } if (values[i, 5] == null) { temp = 0; } if (values[i, 6] == null) { temp = 0; } if (values[i, 8] == null) { temp = 0; } if (values[i, 9] == null) { temp = 0; } if (values[i, 10] == null) { temp = 0; } if (values[i, 11] == null) { temp = 0; } if (temp == 0) { MessageBox.Show("please fill in all fields"); } else if (temp == 1) { if (values[i, 7] == null) { values[i, 7] = "F"; } command = new SqlCommand("INSERT INTO Light VALUES (" + values[i, 0] + ",'" + values[i, 1] + "','" + values[i, 2] + "','" + values[i, 3] + "','" + values[i, 4] + "','" + values[i, 5] + "','" + values[i, 6] + "','" + values[i, 7][0] + "'," + values[i, 8] + "," + values[i, 9] + "," + values[i, 10] + ",'" + values[i, 11] + "')", con); command.ExecuteNonQuery(); } } else { if (values[i, 0] == null) { temp = 0; } if (values[i, 1] == null) { temp = 0; } if (values[i, 2] == null) { temp = 0; } if (values[i, 3] == null) { temp = 0; } if (values[i, 4] == null) { temp = 0; } if (values[i, 5] == null) { temp = 0; } if (values[i, 6] == null) { temp = 0; } if (values[i, 8] == null) { temp = 0; } if (values[i, 9] == null) { temp = 0; } if (values[i, 10] == null) { temp = 0; } if (values[i, 11] == null) { temp = 0; } if (temp == 0) { MessageBox.Show("please fill in all fields"); } else if (temp == 1) { if (values[i, 7] == null) { values[i, 7] = "F"; } command = new SqlCommand("UPDATE Light SET location = '" + values[i, 1] + "', model = '" + values[i, 2] + "', make = '" + values[i, 3] + "', heads = '" + values[i, 4] + "', power = '" + values[i, 5] + "', voltage = '" + values[i, 6] + "', require_service = '" + values[i, 7][0] + "', serial = " + values[i, 8] + ", room_id = " + values[i, 9] + ", bar_code = " + values[i, 10] + ", manufacture_date = '" + values[i, 11] + "' WHERE light_id = " + values[i, 0], con); command.ExecuteNonQuery(); } } } con.Close(); return(temp); }
public static int SetLights(String[,] values) { String connString = Properties.Settings.Default.FAFOS; SqlConnection con = new SqlConnection(connString); SqlCommand command; int temp = 1; int nLight = (values.Length / 12); MRoom r; con.Open(); for (int i = 0; i < nLight; i++) { if (values[i, 0] == null) { r = new MRoom(); values[i, 0] = r.getNewID("light_id", "Light"); if (values[i, 0] == null) { temp = 0; } if (values[i, 1] == null) { temp = 0; } if (values[i, 2] == null) { temp = 0; } if (values[i, 3] == null) { temp = 0; } if (values[i, 4] == null) { temp = 0; } if (values[i, 5] == null) { temp = 0; } if (values[i, 6] == null) { temp = 0; } if (values[i, 8] == null) { temp = 0; } if (values[i, 9] == null) { temp = 0; } if (values[i, 10] == null) { temp = 0; } if (values[i, 11] == null) { temp = 0; } if (temp == 0) { MessageBox.Show("please fill in all fields"); } else if (temp == 1) { if (values[i, 7] == null) values[i, 7] = "F"; command = new SqlCommand("INSERT INTO Light VALUES (" + values[i, 0] + ",'" + values[i, 1] + "','" + values[i, 2] + "','" + values[i, 3] + "','" + values[i, 4] + "','" + values[i, 5] + "','" + values[i, 6] + "','" + values[i, 7][0] + "'," + values[i, 8] + "," + values[i, 9] + "," + values[i, 10] + ",'" + values[i, 11] + "')", con); command.ExecuteNonQuery(); } } else { if (values[i, 0] == null) { temp = 0; } if (values[i, 1] == null) { temp = 0; } if (values[i, 2] == null) { temp = 0; } if (values[i, 3] == null) { temp = 0; } if (values[i, 4] == null) { temp = 0; } if (values[i, 5] == null) { temp = 0; } if (values[i, 6] == null) { temp = 0; } if (values[i, 8] == null) { temp = 0; } if (values[i, 9] == null) { temp = 0; } if (values[i, 10] == null) { temp = 0; } if (values[i, 11] == null) { temp = 0; } if (temp == 0) { MessageBox.Show("please fill in all fields"); } else if (temp == 1) { if (values[i, 7] == null) values[i, 7] = "F"; command = new SqlCommand("UPDATE Light SET location = '" + values[i, 1] + "', model = '" + values[i, 2] + "', make = '" + values[i, 3] + "', heads = '" + values[i, 4] + "', power = '" + values[i, 5] + "', voltage = '" + values[i, 6] + "', require_service = '" + values[i, 7][0] + "', serial = " + values[i, 8] + ", room_id = " + values[i, 9] + ", bar_code = " + values[i, 10] + ", manufacture_date = '" + values[i, 11] + "' WHERE light_id = " + values[i, 0], con); command.ExecuteNonQuery(); } } } con.Close(); return temp; }