public override void OnBeforeDelete(IDeleteRequestHandler handler)
{
if (Target is null ||
(Target.Flags & FieldFlags.Updatable) != FieldFlags.Updatable)
{
return;
}
var idField = (handler.Row as IIdRow).IdField;
var row = new NoteRow();
var fld = NoteRow.Fields;
var deleteList = new List <long>();
new SqlQuery()
.From(row)
.Select(fld.NoteId)
.Where(
fld.EntityType == handler.Row.Table &
fld.EntityId == Convert.ToInt64(idField.AsObject(handler.Row),
CultureInfo.InvariantCulture))
.ForEach(handler.Connection, () =>
{
deleteList.Add(row.NoteId.Value);
});
foreach (var id in deleteList)
{
DeleteNote(handler.UnitOfWork, id);
}
}
public override void OnBeforeDelete(IDeleteRequestHandler handler)
{
if (ReferenceEquals(null, Target) ||
(Target.Flags & FieldFlags.Updatable) != FieldFlags.Updatable)
{
return;
}
var idField = (handler.Row as IIdRow).IdField;
var row = new NoteRow();
var fld = NoteRow.Fields;
var deleteList = new List <Int64>();
new SqlQuery()
.From(row)
.Select(fld.NoteId)
.Where(
fld.EntityType == handler.Row.Table &
fld.EntityId == idField[handler.Row].Value)
.ForEach(handler.Connection, () =>
{
deleteList.Add(row.NoteId.Value);
});
foreach (var id in deleteList)
{
DeleteNote(handler.UnitOfWork, id);
}
}
private void SaveNote(IUnitOfWork uow, NoteRow note, string entityType, Int64 entityId, Int64? noteId)
{
note = note.Clone();
note.NoteId = noteId;
note.EntityType = entityType;
note.EntityId = entityId;
note.InsertDate = null;
note.ClearAssignment(NoteRow.Fields.InsertDate);
var saveRequest = new SaveRequest<NoteRow> { Entity = note };
if (noteId == null)
new NoteRepository().Create(uow, saveRequest);
else
new NoteRepository().Update(uow, saveRequest);
}
void BuildRow(NoteRow row, int rowNumber)
{
int noteNum = 0;
foreach (int note in row.row)
{
if (note > 0)
{
GameObject obj = Instantiate(noteObj, spawnLocations[noteNum].position, Quaternion.identity);
obj.GetComponent <Note>().target = drums[noteNum];
obj.GetComponent <Note>().spawn = spawnLocations[noteNum].gameObject;
obj.GetComponent <Note>().type = note;
switch (note)
{
case 1:
for (int i = 0; i < songPair.song.subdivision; i++)
{
if ((rowNumber + 1) % (i + 1) == 0)
{
obj.GetComponent <MeshRenderer>().material = noteSubDivisionMaterials[i];
}
}
break;
case 2:
for (int i = 0; i < songPair.song.subdivision; i++)
{
if ((rowNumber + 1) % (i + 1) == 0)
{
obj.GetComponent <MeshRenderer>().material = noteAccentMaterials[i];
}
}
break;
}
drums[noteNum].GetComponent <Drum>().AddNote(obj);
}
noteNum++;
}
}
private void SaveNote(IUnitOfWork uow, NoteRow note, string entityType, Int64 entityId, Int64?noteId)
{
note = note.Clone();
note.NoteId = noteId;
note.EntityType = entityType;
note.EntityId = entityId;
note.InsertDate = null;
note.ClearAssignment(NoteRow.Fields.InsertDate);
var saveRequest = new SaveRequest <NoteRow> {
Entity = note
};
if (noteId == null)
{
new NoteRepository().Create(uow, saveRequest);
}
else
{
new NoteRepository().Update(uow, saveRequest);
}
}
public override void OnBeforeDelete(IDeleteRequestHandler handler)
{
if (ReferenceEquals(null, Target) ||
(Target.Flags & FieldFlags.Updatable) != FieldFlags.Updatable)
return;
var idField = (handler.Row as IIdRow).IdField;
var row = new NoteRow();
var fld = NoteRow.Fields;
var deleteList = new List<Int64>();
new SqlQuery()
.From(row)
.Select(fld.NoteId)
.Where(
fld.EntityType == handler.Row.Table &
fld.EntityId == idField[handler.Row].Value)
.ForEach(handler.Connection, () =>
{
deleteList.Add(row.NoteId.Value);
});
foreach (var id in deleteList)
DeleteNote(handler.UnitOfWork, id);
}
public NoteRowChangeEvent(NoteRow row, global::System.Data.DataRowAction action)
{
this.eventRow = row;
this.eventAction = action;
}
