private void OnNoteOff(int channel, MidiEvent @event)
{
byte note = @event.MidiMessage.GetBytes()[1];
TempNote tempNote = noteCache?[channel]?[note];
if (tempNote == null)
{
// A note was turned off when that note was never indicated as having been turned on
return;
}
noteCache[channel].Remove(note);
CheckTime(tempNote.StartTick);
long durationInTicks = @event.AbsoluteTicks - tempNote.StartTick;
double durationInBeats = GetDurationInBeats(durationInTicks);
byte noteOffVelocity = @event.MidiMessage.GetBytes()[2];
expectedTimeInBeats[currentChannel] = currentTimeInBeats[currentChannel] + durationInBeats;
Note noteObject = new Note(note)
{
Duration = GetDurationInBeats(durationInTicks),
OnVelocity = tempNote.NoteOnVelocity,
OffVelocity = noteOffVelocity
};
OnNoteReleased(new Note(note)
{
OffVelocity = noteOffVelocity
});
OnNoteParsed(noteObject);
}
public bool Create()
{
AppLog.Info("CREATE BUG - Starting...");
//Checks that data is valid before attempting upload
AppLog.Info("CREATE BUG - Validating...");
if (!Validate())
{
AppLog.Info("CREATE BUG - Bug failed validation");
return(false);
}
AppLog.Info("CREATE BUG - Bug validated successfully");
_DateTimeCreated = DateTime.Now;
_DateTimeEdited = DateTime.Now;
_EditedByUserId = Data.ActiveUser.Id;
//Need to check for offline mode here. Also need to do GET for TagType
AppLog.Info("CREATE BUG - Attempting to CREATE BUG on online database...");
try //Online
{
using (SqlConnection conn = new SqlConnection(OnlineConnStr))
{
AppLog.Info("CREATE BUG - Attempting to open connection to online database...");
conn.Open();
AppLog.Info("CREATE BUG - Connection to online database opened successfully");
//This is a check to see weather the bug already exists on the database. Obviously
//if it's already there, it doesn't need creating again, but this might be called
//if for example the bug did not exist on the local database, so the Create() function
//needed to be able to account for that.
AppLog.Info("CREATE BUG - Checking that bug doesn't already exist on online database");
bool OnlineBugExists;
SqlCommand CheckOnlineDb = new SqlCommand("SELECT * FROM t_Bugs WHERE Id = @Id", conn);
CheckOnlineDb.Parameters.Add(new SqlParameter("Id", Id));
using (SqlDataReader reader = CheckOnlineDb.ExecuteReader())
{
if (reader.Read())
{
OnlineBugExists = true;
AppLog.Info("CREATE BUG - Bug already exists in online database!");
}
else
{
OnlineBugExists = false;
}
}
if (!OnlineBugExists)
{
AppLog.Info("CREATE BUG - Bug does not exist in online database. Creating bug on " +
"online database");
SqlCommand CreateBug = new SqlCommand("INSERT INTO t_Bugs (Id, ProductId, RaisedByUserId, Title, " +
"Severity, DateTimeCreated, DateTimeEdited, EditedByUserId) VALUES (@Id, @ProductId, @RaisedByUserId, " +
"@Title, @Severity, @DateTimeCreated, @DateTimeEdited, @EditedByUserId);", conn);
CreateBug.Parameters.Add(new SqlParameter("Id", _Id));
CreateBug.Parameters.Add(new SqlParameter("ProductId", _ProductId));
CreateBug.Parameters.Add(new SqlParameter("RaisedByUserId", _RaisedById));
CreateBug.Parameters.Add(new SqlParameter("Title", _Title));
CreateBug.Parameters.Add(new SqlParameter("Severity", _Severity));
CreateBug.Parameters.Add(new SqlParameter("DateTimeCreated", _DateTimeCreated));
CreateBug.Parameters.Add(new SqlParameter("DateTimeEdited", _DateTimeEdited));
CreateBug.Parameters.Add(new SqlParameter("EditedByUserId", _EditedByUserId));
CreateBug.ExecuteNonQuery();
if (_Description != null && _Description != "")
{
SqlCommand CreateBug_Description = new SqlCommand("UPDATE t_Bugs SET Description = " +
"@Description WHERE Id = @Id", conn);
CreateBug_Description.Parameters.Add(new SqlParameter("Description", _Description));
CreateBug_Description.Parameters.Add(new SqlParameter("Id", _Id));
CreateBug_Description.ExecuteNonQuery();
}
}
}
Uploaded = true;
AppLog.Info(String.Format("CREATE BUG - Bug {0} created on online database successfully", Title));
}
catch (SqlException e)
{
_ErrMsg = "Error whilst creating bug on the online database";
AppLog.Error("CREATE BUG - " + _ErrMsg + ": " + e);
return(false);
}
/*AppLog.Info("CREATE BUG - Attempting to create bug on local database...");
* try //Local
* {
* using (SqlConnection conn = new SqlConnection(LocalConnStr))
* {
* AppLog.Info("CREATE BUG - Attempting to open connection to local database...");
* conn.Open();
* AppLog.Info("CREATE BUG - Connection to local database opened successfully");
*
* //This is a check to see weather the bug already exists on the database. Obviously
* //if it's already there, it doesn't need creating again, but this might be called
* //if for example the bug did not exist on the local database, so the Create() function
* //needed to be able to account for that.
* AppLog.Info("CREATE BUG - Checking that bug doesn't already exist on local database");
* bool LocalBugExists;
*
* SqlCommand CheckLocalDb = new SqlCommand("SELECT * FROM Bugs WHERE Id = @Id", conn);
* CheckLocalDb.Parameters.Add(new SqlParameter("Id", Id));
* using (SqlDataReader reader = CheckLocalDb.ExecuteReader())
* {
* if (reader.Read())
* {
* LocalBugExists = true;
* AppLog.Info("CREATE BUG - Bug already exists in local database!");
* }
* else
* {
* LocalBugExists = false;
* }
* }
* if (!LocalBugExists)
* {
* SqlCommand CreateBug = new SqlCommand("INSERT INTO Bugs (Id, ProductId, RaisedByUserId, Title, Severity, " +
* "DateTimeCreated, DateTimeEdited, EditedByUserId) VALUES (@Id, @ProductId, @RaisedByUserId, @Title, " +
* "@Severity, @DateTimeCreated, @DateTimeEdited, @EditedByUserId);", conn);
* CreateBug.Parameters.Add(new SqlParameter("Id", _Id));
* CreateBug.Parameters.Add(new SqlParameter("ProductId", _ProductId));
* CreateBug.Parameters.Add(new SqlParameter("RaisedByUserId", _RaisedById));
* CreateBug.Parameters.Add(new SqlParameter("Title", _Title));
* CreateBug.Parameters.Add(new SqlParameter("Severity", _Severity));
* CreateBug.Parameters.Add(new SqlParameter("DateTimeCreated", _DateTimeCreated));
* CreateBug.Parameters.Add(new SqlParameter("DateTimeEdited", _DateTimeEdited));
* CreateBug.Parameters.Add(new SqlParameter("EditedByUserId", _EditedByUserId));
*
* CreateBug.ExecuteNonQuery();
*
* if (_Description != null && _Description != "")
* {
* SqlCommand CreateBug_Description = new SqlCommand("UPDATE Bugs SET Description = @Description " +
* "WHERE Id = @Id",conn);
* CreateBug_Description.Parameters.Add(new SqlParameter("Description", _Description));
* CreateBug_Description.Parameters.Add(new SqlParameter("Id", _Id));
*
* CreateBug_Description.ExecuteNonQuery();
* }
* }
* }
* AppLog.Info(String.Format("CREATE BUG - Bug {0} created on local database successfully", Title));
* }
* catch (SqlException e)
* {
* _ErrMsg = "Error while creating bug on local database. Changes were not saved";
* AppLog.Error("CREATE BUG - " + _ErrMsg + ": " + e);
* return false;
* }*/
//### New Functionality
foreach (Note TempNote in Data.Notes)
{
if (TempNote.BugId.ToString() == Id.ToString())
{
TempNote.Create();
}
}
foreach (Assignee TempAssignee in Data.Assignees)
{
if (TempAssignee.BugId.ToString() == Id.ToString())
{
TempAssignee.Create();
}
}
foreach (Tag TempTag in Data.Tags)
{
if (TempTag.BugId.ToString() == Id.ToString())
{
TempTag.Create();
}
}
AppLog.Debug("CREATE BUG - Attempting to add bug to DATA...");
Data.Bugs.Add(this);
AppLog.Debug("CREATE BUG - ...Success! Added bug to DATA");
AppLog.Info("CREATE BUG - Success!");
return(true);
}