BLL.Dao.TimelapseDao.UpdateSnapsCount C# (CSharp) Метод

        public static long UpdateSnapsCount(string code, long snaps)
        {
            string query = @"UPDATE [dbo].[Timelapses] " +
                           "SET [SnapsCount] = [SnapsCount] + (@Snaps) " +
                           "OUTPUT INSERTED.SnapsCount " +
                           "WHERE (Code = '" + code + "')";
            if (snaps > 1)
                query = @"UPDATE [dbo].[Timelapses] " +
                           "SET [SnapsCount] = @Snaps " +
                           "OUTPUT INSERTED.SnapsCount " +
                           "WHERE (Code = '" + code + "')";

            try
            {
                var p1 = new SqlParameter("@Snaps", (int)snaps);

                var cmd = new SqlCommand { CommandText = query, CommandType = CommandType.Text };
                cmd.Parameters.Add(p1);
                Connection.OpenConnection();
                cmd.Connection = Connection.DbConnection;
                long result = (int)cmd.ExecuteScalar();
                Connection.CloseConnection();
                cmd.Dispose();
                return result;
            }
            catch (Exception ex)
            {
                Utils.FileLog("TimelapseDao UpdateSnapsCount(string code, int snaps) " + ex.Message);
                return 0;
            }
            finally
            { Connection.CloseConnection(); }
        }