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 AnswerResponseBE UpdateActivities(ActivitiesBE UPACTI) { AnswerResponseBE AR = new AnswerResponseBE(); ActivitiesLogic AL = new ActivitiesLogic(); AR = AL.UpdateActivities(UPACTI); return(AR); }
public AnswerResponseBE InsertActivities(ActivitiesBE IACT) { AnswerResponseBE AR = new AnswerResponseBE(); ActivitiesLogic AL = new ActivitiesLogic(); AR = AL.InsertActivities(IACT); 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 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); }