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); }