private void metroButton2_Click(object sender, EventArgs e)
{
try
{
if (metroTextBox1.Text == "" || metroGrid1.Rows[0].Cells["Tag Name"].Value.ToString() == "" || metroGrid1.Rows[0].Cells["Tag Value"].Value.ToString() == "")
{
CheckEmpty();
}
else
{
DialogResult f = MetroMessageBox.Show(this, "Are you sure to save?", "WSH notify", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (f == DialogResult.OK)
{
access_data d = new access_data();
site s = new site();
s.url = metroTextBox1.Text;
s.description = textBox1.Text;
int site_id = d.InsertNweUrlData(s);
int i = metroGrid1.Rows.Count;
SqlDbDataAccess dr = new SqlDbDataAccess();
for (int j = 0; j < i; j++)
{
using (SqlCommand cmd = dr.GetCommand("insert into dbo.site_details (site_id,tag_name,tag_value) values(@site_id,@tag_name,@tag_value);"))
{
SqlParameter p = new SqlParameter("@site_id", SqlDbType.Int);
p.Value = site_id;
SqlParameter p1 = new SqlParameter("@tag_name", SqlDbType.VarChar, 200);
p1.Value = metroGrid1.Rows[j].Cells["Tag Name"].Value.ToString();
SqlParameter p2 = new SqlParameter("@tag_value", SqlDbType.VarChar, 500);
p2.Value = metroGrid1.Rows[j].Cells["Tag Value"].Value.ToString();
cmd.Parameters.Add(p);
cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
}
}
MetroMessageBox.Show(this, "Data successfully Saved", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
metroTextBox1.Text = "";
metroTextBox2.Text = "";
textBox1.Text = "";
textBox2.Text = "";
metroGrid1.DataSource = null;
}
}
}
catch (System.ArgumentOutOfRangeException)
{
CheckEmpty();
}
}
