public TimeActivityBE SearchCodeTimeActivity(int SEARTIMACTCOD)
{
EmploActiEntities BDEA = new EmploActiEntities();
TimeActivityBE idTimeacti = new TimeActivityBE();
try
{
idTimeacti = (from TimeActivity in BDEA.TimeActivity
where TimeActivity.CodeTimeActivity == SEARTIMACTCOD
select new TimeActivityBE
{
CodeTimeActivity = TimeActivity.CodeTimeActivity,
ActivitiesCode = TimeActivity.ActivitiesCode,
NameActivities = TimeActivity.Activities.NameActivities,
DateActivity = TimeActivity.DateActivity,
Hours = TimeActivity.Hours,
IdUser = TimeActivity.IdUser,
}).FirstOrDefault();
}
catch (Exception EX)
{
}
finally
{
BDEA.Dispose();
}
return(idTimeacti);
}
public AnswerResponseBE Updatetimeactivity(TimeActivityBE UPTIMEACT)
{
AnswerResponseBE AR = new AnswerResponseBE();
TimeActivityLogic TAL = new TimeActivityLogic();
AR = TAL.UpdateTimeActivity(UPTIMEACT);
return(AR);
}
public AnswerResponseBE InsertTimeActivity(TimeActivityBE ITIMAC)
{
AnswerResponseBE AR = new AnswerResponseBE();
TimeActivityLogic TAL = new TimeActivityLogic();
AR = TAL.InsertTimeActivity(ITIMAC);
return(AR);
}
public AnswerResponseBE InsertTimeActivity(TimeActivityBE ITIMAC)
{
AnswerResponseBE AR = new AnswerResponseBE();
EmploActiEntities BDEA = new EmploActiEntities();
try
{
int CountTimeActi = 0;
CountTimeActi = BDEA.TimeActivity.Where(x => x.CodeTimeActivity == ITIMAC.CodeTimeActivity).ToList().Count();
if (CountTimeActi == 0)
{
TimeActivity TIMACT = new TimeActivity();
TIMACT.ActivitiesCode = ITIMAC.ActivitiesCode;
TIMACT.DateActivity = ITIMAC.DateActivity;
TIMACT.Hours = ITIMAC.Hours;
TIMACT.IdUser = ITIMAC.IdUser;
BDEA.TimeActivity.Add(TIMACT);
BDEA.SaveChanges();
AR.CodeError = 0;
AR.DescriptionError = "Se ha insertado el tiempo / actividad correctamente";
}
else
{
AR.CodeError = 2;
AR.DescriptionError = "El registro ya existe, por favor verifique la información";
}
}
catch (Exception EX)
{
AR.CodeError = 1;
AR.DescriptionError = "Hubo un error";
}
finally
{
BDEA.Dispose();
}
return(AR);
}
public AnswerResponseBE UpdateTimeActivity(TimeActivityBE UPTIMEACT)
{
AnswerResponseBE AR = new AnswerResponseBE();
EmploActiEntities BDEA = new EmploActiEntities();
try
{
TimeActivity timeactivity = new TimeActivity();
timeactivity = BDEA.TimeActivity.Where(x => x.CodeTimeActivity == UPTIMEACT.CodeTimeActivity).FirstOrDefault();
if (timeactivity != null)
{
timeactivity.ActivitiesCode = UPTIMEACT.ActivitiesCode;
timeactivity.DateActivity = UPTIMEACT.DateActivity;
timeactivity.Hours = UPTIMEACT.Hours;
BDEA.SaveChanges();
AR.CodeError = 0;
AR.DescriptionError = "Se ha actualizado el tiempo / actividad correctamente";
}
else
{
AR.CodeError = 2;
AR.DescriptionError = "El registro no existe, por favor verifique la información";
}
}
catch (Exception EX)
{
AR.CodeError = 1;
AR.DescriptionError = "Hubo un error";
}
finally
{
BDEA.Dispose();
}
return(AR);
}
