private void btnAddCounter2_Click(object sender, EventArgs e) { this.TopMost = false; try { using (frmMomentalCounter f = new frmMomentalCounter()) { if (f.ShowDialog() == DialogResult.OK) { using (SqlConnection cn = new SqlConnection(prop.Connection_string)) { cn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = cn; cmd.CommandTimeout = 9000; cmd.CommandText = "INSERT INTO [dbo].[mcounters] ([mcounter],[date_mcounter],[id_user],[name_user]) VALUES (" + ((long)f.txtCounter.Value).ToString() + ",getdate()," + usr.Id_user + ",'" + usr.Name + "')"; cmd.ExecuteNonQuery(); } FillCounters(); } } } catch { } this.TopMost = prop.Mod_operator_top_most; }
private void gridCounter2_DoubleClick(object sender, EventArgs e) { this.TopMost = false; if (gridCounter2.Row > 0) { if (gridCounter2.GetData(gridCounter2.Row, gridCounter2.Selection.LeftCol) != null) { if (int.Parse(gridCounter2.Rows[gridCounter2.Row][1].ToString()) > 0) { using (frmMomentalCounter f = new frmMomentalCounter(int.Parse(gridCounter2.Rows[gridCounter2.Row][3].ToString()))) { if (f.ShowDialog() == DialogResult.OK) { using (SqlConnection cn = new SqlConnection(prop.Connection_string)) { cn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = cn; cmd.CommandTimeout = 9000; cmd.CommandText = "UPDATE [dbo].[mcounters] SET [mcounter] = " + ((long)f.txtCounter.Value).ToString() + ", [id_user] = " + usr.Id_user + ", [name_user] = '" + usr.Name + "', [exported] = 0 WHERE id_mcounter = " + int.Parse(gridCounter2.Rows[gridCounter2.Row][1].ToString()); cmd.ExecuteNonQuery(); } FillCounters(); } } } } } this.TopMost = prop.Mod_operator_top_most; }