public UserBE SearchIdUser(int SEARIDUSE)
{
EmploActiEntities BDEA = new EmploActiEntities();
UserBE idus = new UserBE();
try
{
idus = (from User in BDEA.User
where User.IdUser == SEARIDUSE
select new UserBE
{
IdUser = User.IdUser,
NameUser = User.NameUser,
Password = User.Password
}).FirstOrDefault();
}
catch (Exception EX)
{
}
finally
{
BDEA.Dispose();
}
return(idus);
}
public AnswerResponseBE ValidatioUserPassword(string USERNAME, string PASSWORD)
{
AnswerResponseBE AR = new AnswerResponseBE();
EmploActiEntities BDEA = new EmploActiEntities();
try
{
User user = new User();
user = BDEA.User.Where(x => x.NameUser == USERNAME && x.Password == PASSWORD).FirstOrDefault();
if (user != null)
{
AR.CodeError = 0;
AR.DescriptionError = "Usuario correcto";
}
else
{
AR.CodeError = 2;
AR.DescriptionError = "Usuario y contraseña incorrecta, favor verifique la información";
}
}
catch (Exception EX)
{
AR.CodeError = 1;
AR.DescriptionError = "Hubo un error";
}
finally
{
BDEA.Dispose();
}
return(AR);
}
public AnswerResponseBE UpdateActivities(ActivitiesBE UPACTI)
{
AnswerResponseBE AR = new AnswerResponseBE();
EmploActiEntities BDEA = new EmploActiEntities();
try
{
Activities activities = new Activities();
activities = BDEA.Activities.Where(x => x.ActivitiesCode == UPACTI.ActivitiesCode).FirstOrDefault();
if (activities != null)
{
activities.NameActivities = UPACTI.NameActivities;
BDEA.SaveChanges();
AR.CodeError = 0;
AR.DescriptionError = "Se ha actualizado la 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);
}
public List <TimeActivityBE> SearchTimActiIdUse(int SEARTIMACTIDUS)
{
List <TimeActivityBE> ltstimeactiidus = new List <TimeActivityBE>();
EmploActiEntities BDEA = new EmploActiEntities();
try
{
ltstimeactiidus = (from TimeActivity in BDEA.TimeActivity
where TimeActivity.IdUser == SEARTIMACTIDUS
select new TimeActivityBE
{
CodeTimeActivity = TimeActivity.CodeTimeActivity,
ActivitiesCode = TimeActivity.ActivitiesCode,
NameActivities = TimeActivity.Activities.NameActivities,
DateActivity = TimeActivity.DateActivity,
Hours = TimeActivity.Hours,
IdUser = TimeActivity.IdUser
}).ToList();
}
catch (Exception EX)
{
}
finally
{
BDEA.Dispose();
}
return(ltstimeactiidus);
}
public List <TimeActivityBE> GetTimeActivityAll()
{
List <TimeActivityBE> ltstimeacti = new List <TimeActivityBE>();
EmploActiEntities BDEA = new EmploActiEntities();
try
{
ltstimeacti = (from TimeActivity in BDEA.TimeActivity
select new TimeActivityBE
{
CodeTimeActivity = TimeActivity.CodeTimeActivity,
ActivitiesCode = TimeActivity.ActivitiesCode,
NameActivities = TimeActivity.Activities.NameActivities,
DateActivity = TimeActivity.DateActivity,
Hours = TimeActivity.Hours,
IdUser = TimeActivity.IdUser
}).ToList();
}
catch (Exception EX)
{
}
finally
{
BDEA.Dispose();
}
return(ltstimeacti);
}
public List <TimeActivityBE> SearchActivityCode(int SEARTACTICOD)
{
EmploActiEntities BDEA = new EmploActiEntities();
List <TimeActivityBE> idTimeacti = new List <TimeActivityBE>();
try
{
idTimeacti = (from TimeActivity in BDEA.TimeActivity
where TimeActivity.ActivitiesCode == SEARTACTICOD
select new TimeActivityBE
{
CodeTimeActivity = TimeActivity.CodeTimeActivity,
ActivitiesCode = TimeActivity.ActivitiesCode,
NameActivities = TimeActivity.Activities.NameActivities,
DateActivity = TimeActivity.DateActivity,
Hours = TimeActivity.Hours,
IdUser = TimeActivity.IdUser,
}).ToList();
}
catch (Exception EX)
{
}
finally
{
BDEA.Dispose();
}
return(idTimeacti);
}
public AnswerResponseBE DeleteTimeActivity(int TIMEACTIVITECODE)
{
AnswerResponseBE AR = new AnswerResponseBE();
EmploActiEntities BDEA = new EmploActiEntities();
try
{
var idTimeacti = BDEA.TimeActivity.Where(x => x.CodeTimeActivity == TIMEACTIVITECODE).FirstOrDefault();
if (idTimeacti != null)
{
BDEA.TimeActivity.Remove(idTimeacti);
BDEA.SaveChanges();
AR.CodeError = 0;
AR.DescriptionError = "Se eliminó con éxito";
}
else
{
AR.CodeError = 1;
AR.DescriptionError = "El registro no existe";
}
}
catch (Exception EX)
{
AR.CodeError = 2;
AR.DescriptionError = "Hubo un error";
}
finally
{
BDEA.Dispose();
}
return(AR);
}
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 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 InsertUser(UserBE IUSER)
{
AnswerResponseBE AR = new AnswerResponseBE();
EmploActiEntities BDEA = new EmploActiEntities();
try
{
int CountUser = 0;
CountUser = BDEA.User.Where(x => x.IdUser == IUSER.IdUser).ToList().Count();
if (CountUser == 0)
{
User US = new User();
US.NameUser = IUSER.NameUser;
US.Password = IUSER.Password;
BDEA.User.Add(US);
BDEA.SaveChanges();
AR.CodeError = 0;
AR.DescriptionError = "Se ha insertado el usuario 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 InsertActivities(ActivitiesBE IACT)
{
AnswerResponseBE AR = new AnswerResponseBE();
EmploActiEntities BDEA = new EmploActiEntities();
try
{
int CountActi = 0;
CountActi = BDEA.Activities.Where(x => x.ActivitiesCode == IACT.ActivitiesCode).ToList().Count();
if (CountActi == 0)
{
Activities ACTIV = new Activities();
ACTIV.NameActivities = IACT.NameActivities;
ACTIV.IdUser = IACT.IdUser;
BDEA.Activities.Add(ACTIV);
BDEA.SaveChanges();
AR.CodeError = 0;
AR.DescriptionError = "Se ha insertado la 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 List <ActivitiesBE> GetActivitiesAll()
{
List <ActivitiesBE> ltsactivi = new List <ActivitiesBE>();
EmploActiEntities BDEA = new EmploActiEntities();
try
{
ltsactivi = (from Activities in BDEA.Activities
select new ActivitiesBE
{
ActivitiesCode = Activities.ActivitiesCode,
NameActivities = Activities.NameActivities
}).ToList();
}
catch (Exception EX)
{
}
finally
{
BDEA.Dispose();
}
return(ltsactivi);
}
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);
}
public AnswerResponseBE UpdateUser(UserBE UPUSER)
{
AnswerResponseBE AR = new AnswerResponseBE();
EmploActiEntities BDEA = new EmploActiEntities();
try
{
User user = new User();
user = BDEA.User.Where(x => x.IdUser == UPUSER.IdUser).FirstOrDefault();
if (user != null)
{
user.NameUser = UPUSER.NameUser;
user.Password = UPUSER.Password;
BDEA.SaveChanges();
AR.CodeError = 0;
AR.DescriptionError = "Se ha actualizado el usuario 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);
}
public List <UserBE> GetUserAll()
{
List <UserBE> ltsuser = new List <UserBE>();
EmploActiEntities BDEA = new EmploActiEntities();
try
{
ltsuser = (from User in BDEA.User
select new UserBE
{
IdUser = User.IdUser,
NameUser = User.NameUser,
Password = User.Password
}).ToList();
}
catch (Exception EX)
{
}
finally
{
BDEA.Dispose();
}
return(ltsuser);
}
public ActivitiesBE SearchCodeActivities(int SEARACTCOD)
{
EmploActiEntities BDEA = new EmploActiEntities();
ActivitiesBE idacti = new ActivitiesBE();
try
{
idacti = (from Activities in BDEA.Activities
where Activities.ActivitiesCode == SEARACTCOD
select new ActivitiesBE
{
ActivitiesCode = Activities.ActivitiesCode,
NameActivities = Activities.NameActivities
}).FirstOrDefault();
}
catch (Exception EX)
{
}
finally
{
BDEA.Dispose();
}
return(idacti);
}