public bool Create()
{
try
{
if (Id != 0)
{
log.Error("Se intentó crear objeto TaskAssignment con Id ya existente. ID: " + Id);
throw new Exception();
}
else
{
Data.TASK_ASSIGNMENT taskAssignment = new Data.TASK_ASSIGNMENT();
taskAssignment.ID_TASK = Task.Id;
taskAssignment.ID_ASSIGNERUSER = AssignerUser.Id;
if (ReceiverUser != null)
{
taskAssignment.ID_RECEIVERUSER = ReceiverUser.Id;
}
else
{
taskAssignment.ID_RECEIVERUSER = null;
}
Connection.ProcessSA_DB.TASK_ASSIGNMENT.Add(taskAssignment);
Connection.ProcessSA_DB.SaveChanges();
Id = (int)taskAssignment.ID;
return(true);
}
}
catch (Exception e)
{
log.Error("Ha ocurrido un error durante la creación de Task assignment de Id tarea: " + Task.Id, e);
return(false);
}
}
public bool ReadById()
{
try
{
Data.TASK_ASSIGNMENT taskAssignment = Connection.ProcessSA_DB.TASK_ASSIGNMENT.First(ta => ta.ID == Id);
Id = (int)taskAssignment.ID;
Task = new Task((int)taskAssignment.TASK.ID);
AssignerUser = new User((int)taskAssignment.ID_ASSIGNERUSER);
if (taskAssignment.ID_RECEIVERUSER != null)
{
ReceiverUser = new User((int)taskAssignment.ID_RECEIVERUSER);
}
else
{
ReceiverUser = null;
}
return(true);
}
catch (Exception e)
{
log.Error("Ha ocurrido un error durante la lectura de Task assignment de Id: " + Id, e);
return(false);
}
}
public bool Update()
{
try
{
Data.TASK_ASSIGNMENT taskAssignment = Connection.ProcessSA_DB.TASK_ASSIGNMENT.First(ta => ta.ID == Id);
taskAssignment.ID_TASK = Task.Id;
taskAssignment.ID_ASSIGNERUSER = AssignerUser.Id;
if (ReceiverUser != null)
{
taskAssignment.ID_RECEIVERUSER = ReceiverUser.Id;
}
else
{
taskAssignment.ID_RECEIVERUSER = null;
}
Connection.ProcessSA_DB.SaveChanges();
return(true);
}
catch (Exception e)
{
log.Error("Ha ocurrido un error durante el update de Task assignment con Id " + Id, e);
return(false);
}
}
