public void InsertMeterManagementData(MeterManagementData newData)
{
this.ConnectToDB();
try
{
String sqlCommand = @"INSERT INTO meter_management VALUES (@p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11)";
using (SqlCommand cmd = new SqlCommand(sqlCommand, connection))
{
String[] data = newData.GetData();
cmd.Parameters.AddWithValue("@p1", Int32.Parse(data[0]));
cmd.Parameters.AddWithValue("@p2", Int32.Parse(data[1]));
cmd.Parameters.AddWithValue("@p3", Int32.Parse(data[2]));
cmd.Parameters.AddWithValue("@p4", Int32.Parse(data[3]));
cmd.Parameters.AddWithValue("@p5", Int32.Parse(data[4]));
cmd.Parameters.AddWithValue("@p6", data[5]);
cmd.Parameters.AddWithValue("@p7", data[6]);
cmd.Parameters.AddWithValue("@p8", data[7]);
cmd.Parameters.AddWithValue("@p9", Int32.Parse(data[8]));
cmd.Parameters.AddWithValue("@p10", data[9]);
cmd.Parameters.AddWithValue("@p11", data[10]);
cmd.ExecuteNonQuery();
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
this.CloseConnection();
}
this.CloseConnection();
}
