protected void BtnAjoutService_Click(object sender, EventArgs e)
{
try
{
string s = "00:00:05.4575699";
string type = DdlType.SelectedItem.Text;
if (type == "url")
{
s = "00:00:05.4575699";
}
else if (type == "sql")
{
s = "00:00:05.4575699";
}
else if (type == "ping")
{
s = "00:00:05.4575699";
}
else if (type == "port")
{
s = "00:00:05.4575699";
}
else if (type == "mail")
{
s = "00:00:05.4575699";
}
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Test"].ToString());
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "INSERT INTO Service(Type,Operation1,operation2,ResultatAttendu,seuil) VALUES (@type,@operation1,@operation2,@ResultatAttendu,@seuil)";
cmd.Parameters.AddWithValue("@type", type);
cmd.Parameters.AddWithValue("@operation1", txtOp1.Value);
if (TxtOp2.Text == "")
{
TxtOp2.Text = null;
}
cmd.Parameters.AddWithValue("@operation2", TxtOp2.Text);
cmd.Parameters.AddWithValue("@ResultatAttendu", txtres.Value);
cmd.Parameters.AddWithValue("@seuil", s);
cmd.ExecuteNonQuery();
ScriptManager.RegisterClientScriptBlock(this, GetType(), "alert message", @"alert('Ajout reussi')", true);
conn.Close();
}
catch (Exception ee)
{
ScriptManager.RegisterClientScriptBlock(this, GetType(), "alert message", @"alert('Echec Ajout" + ee.Message + "')", true);
}
}
protected void btnPort_Click(object sender, EventArgs e)
{
services.Service1 s = new services.Service1();
DataSet ds = s.wcfport(txtIpPort.Value, Convert.ToInt32(txtPort.Value));
string a = "";
foreach (DataRow p in ds.Tables[0].Rows)
{
a = Convert.ToString(p["resultat"]);
}
cp.Visible = false;
resultat.Visible = true;
aport.Visible = true;
aport.Text = a.ToString();
}
