public TaskTag(EventTask task, string id, object value)
{
if (task == null)
{
throw new ArgumentNullException(nameof(task));
}
if (String.IsNullOrWhiteSpace(id))
{
throw new ArgumentException("Cannot be null, emtpy or whitespate.", nameof(id));
}
this.Task = task;
this.Id = id;
this.Value = $"{value}";
}
public TaskAttribute(EventTask task, string key, string value, TaskAttributeType type)
{
if (task == null)
{
throw new ArgumentNullException(nameof(task));
}
if (String.IsNullOrWhiteSpace(key))
{
throw new ArgumentException("Cannot be null, emtpy or whitespate.", nameof(key));
}
if (String.IsNullOrWhiteSpace(value))
{
throw new ArgumentException("Cannot be null, emtpy or whitespate.", nameof(value));
}
this.Task = task;
this.Key = key;
this.Value = value;
this.Type = type;
}
public static string SelectSql(EventTask eventTask)
{
return($"SELECT * FROM [{typeof(ParticipantEventTask).GetScheme()}].[{typeof(ParticipantEventTask).GetTableName()}] WHERE [EventTask_Id]={eventTask.Id}");
}
public static string DeleteSql(Participant participant, EventTask eventTask)
{
return($"DELETE FROM [{typeof(ParticipantEventTask).GetScheme()}].[{typeof(ParticipantEventTask).GetTableName()}] WHERE [Participant_Id]={participant.Id} AND [EventTask_Id]={eventTask.Id};");
}
public static string InsertSql(Participant participant, EventTask eventTask)
{
return($"INSERT [{typeof(ParticipantEventTask).GetScheme()}].[{typeof(ParticipantEventTask).GetTableName()}] ([Participant_Id], [EventTask_Id]) VALUES ( {participant.Id}, {eventTask.Id} );");
}
//public ParticipantEventTask(int participantId, int eventTaskId)
//{
// this.ParticipantId = participantId;
// this.EventTaskId = eventTaskId;
//}
//public ParticipantEventTask(Participant participant, EventTask eventTask)
//{
// this.ParticipantId = participant.Id;
// this.EventTaskId = eventTask.Id;
//}
public ParticipantEventTask(Participant participant, EventTask eventTask)
{
this.Participant = participant;
this.EventTask = eventTask;
}
