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