public bool Create()
{
try
{
if (Id != 0)
{
log.Error("Se intentó crear LoopTaskSchedule con Id ya existente. ID: " + Id);
throw new Exception();
}
else
{
Data.LOOP_TASK_SCHEDULE loopTaskSchedule = new Data.LOOP_TASK_SCHEDULE();
loopTaskSchedule.ID_LOOP_TASK = LoopTask.Id;
loopTaskSchedule.ID_DAYOFWEEK = DayOfWeek;
loopTaskSchedule.DAYOFMONTH = DayOfMonth;
loopTaskSchedule.NUMBEROFWEEK = NumberOfWeek;
loopTaskSchedule.ID_MONTH = IdMonth;
Connection.ProcessSA_DB.LOOP_TASK_SCHEDULE.Add(loopTaskSchedule);
Connection.ProcessSA_DB.SaveChanges();
Id = (int)loopTaskSchedule.ID;
return(true);
}
}
catch (Exception e)
{
log.Error("Ha ocurrido un error durante la creación de LoopTaskSchedule. Id Loop Task: " + LoopTask.Id, e);
return(false);
}
}
public bool Delete()
{
try
{
Data.LOOP_TASK_SCHEDULE loopTaskSchedule = Connection.ProcessSA_DB.LOOP_TASK_SCHEDULE.First(lts => lts.ID == Id);
UpdateProcessedTaskToNull();
Connection.ProcessSA_DB.LOOP_TASK_SCHEDULE.Remove(loopTaskSchedule);
Connection.ProcessSA_DB.SaveChanges();
return(true);
}
catch (Exception e)
{
log.Error("Ha ocurrido un error durante el update de LoopTaskSchedule. Id: " + Id, e);
return(false);
}
}
public bool Update()
{
try
{
Data.LOOP_TASK_SCHEDULE loopTaskSchedule = Connection.ProcessSA_DB.LOOP_TASK_SCHEDULE.First(lts => lts.ID == Id);
loopTaskSchedule.ID_LOOP_TASK = LoopTask.Id;
loopTaskSchedule.ID_DAYOFWEEK = DayOfWeek;
loopTaskSchedule.DAYOFMONTH = DayOfMonth;
loopTaskSchedule.NUMBEROFWEEK = NumberOfWeek;
loopTaskSchedule.ID_MONTH = IdMonth;
Connection.ProcessSA_DB.SaveChanges();
return(true);
}
catch (Exception e)
{
log.Error("Ha ocurrido un error durante el update de LoopTaskSchedule. Id: " + Id, e);
return(false);
}
}
public bool ReadById()
{
try
{
Data.LOOP_TASK_SCHEDULE loopTaskSchedule = Connection.ProcessSA_DB.LOOP_TASK_SCHEDULE.First(lts => lts.ID == Id);
Id = (int)loopTaskSchedule.ID;
LoopTask = new LoopTask((int)loopTaskSchedule.ID);
DayOfWeek = (int?)loopTaskSchedule.ID_DAYOFWEEK;
DayOfMonth = (int?)loopTaskSchedule.DAYOFMONTH;
IdMonth = (int?)loopTaskSchedule.ID_MONTH;
NumberOfWeek = (int?)loopTaskSchedule.NUMBEROFWEEK;
return(true);
}
catch (Exception e)
{
log.Error("Ha ocurrido un error durante la lectura de LoopTaskSchedule, Id: " + Id, e);
return(false);
}
}
