/// <summary> /// Busca registros de ponto de uma determinado período e usuário /// </summary> /// <param name="startDate">Data em formato GMT</param> /// <param name="endDate">Data em formato GMT</param> /// <param name="userId">Id do usuário</param> /// <param name="desc">Verdadeiro para ordernar decrescente e Falso para ordernar crescente</param> /// <returns></returns> public List<RegisterModel> LoadBetween(DateTime startDate, DateTime endDate, int userId, bool desc) { using (var appontoContext = new AppontoContext()) { return Load(startDate, endDate.AddDays(1), userId, desc); } }
public bool Exist(string email) { using (var appontoContext = new AppontoContext()) { tb_user tbUser = appontoContext.tb_user.Where(x => x.ds_email == email).FirstOrDefault(); return (tbUser != null); } }
public CompanyModel Get(string token) { using (var appontoContext = new AppontoContext()) { tb_company tbCompany = appontoContext.tb_company.Where(x => x.ds_token == token).FirstOrDefault(); return ToModel(tbCompany); } }
public bool Authenticate(UserModel user) { using (var appontoContext = new AppontoContext()) { tb_user tbUser = appontoContext.tb_user.SingleOrDefault(x => x.ds_email == user.Email); return (tbUser != null && tbUser.ds_password == user.Password); } }
public UserModel GetByEmail(UserModel user) { using (var appontoContext = new AppontoContext()) { tb_user tbUser = appontoContext.tb_user.Where(x => x.ds_email == user.Email).FirstOrDefault(); return ToModel(tbUser); } }
public UserModel Get(int userId) { using (var appontoContext = new AppontoContext()) { tb_user tbUser = appontoContext.tb_user.Where(x => x.id_user == userId).FirstOrDefault(); return ToModel(tbUser); } }
public ConfigurationLimitationModel Add(ConfigurationLimitationModel configurationLimitation) { using (var appontoContext = new AppontoContext()) { tb_configuration_limitation tbConfiguracaoLimitacao= ToDbModel(configurationLimitation); appontoContext.tb_configuration_limitation.Add(tbConfiguracaoLimitacao); appontoContext.SaveChanges(); ConfigurationLimitationModel ret = ToModel(tbConfiguracaoLimitacao); return ret; } }
public List<AccessLevelModel> Get(int userId) { using (var appontoContext = new AppontoContext()) { tb_user tbUser = appontoContext.tb_user.Where(x => x.id_user == userId).FirstOrDefault(); List<AccessLevelModel> ret = new List<AccessLevelModel>(); foreach (tb_access_level accessLevel in tbUser.tb_access_level) ret.Add(ToModel(accessLevel)); return ret; } }
public List<AccessLevelModel> Get() { using (var appontoContext = new AppontoContext()) { List<tb_access_level> tbAccessLevels = appontoContext.tb_access_level.ToList(); List<AccessLevelModel> ret = new List<AccessLevelModel>(); foreach (tb_access_level tbAccessLevel in tbAccessLevels) ret.Add(ToModel(tbAccessLevel)); return ret; } }
public List<UserModel> Get() { using (var appontoContext = new AppontoContext()) { List<tb_user> tbUsers = appontoContext.tb_user.ToList(); List<UserModel> ret = new List<UserModel>(); foreach (tb_user tbUser in tbUsers) ret.Add(ToModel(tbUser)); return ret; } }
public CompanyModel Add(CompanyModel company) { using (var appontoContext = new AppontoContext()) { tb_company tbCompany = ToDbModel(company); appontoContext.tb_company.Add(tbCompany); appontoContext.SaveChanges(); CompanyModel ret = ToModel(tbCompany); return ret; } }
public List<UserModel> GetByCompany(int companyId) { using (var appontoContext = new AppontoContext()) { List<tb_user> tbUsers = appontoContext.tb_user.Where(x => x.tb_company_id_company == companyId).ToList(); List<UserModel> ret = new List<UserModel>(); foreach (tb_user tbUser in tbUsers) ret.Add(ToModel(tbUser)); return ret; } }
private List<RegisterModel> Load(DateTime startDate, DateTime endDate, int userId, bool desc) { using (var appontoContext = new AppontoContext()) { List<tb_register> tbRegisterList; List<RegisterModel> ret = new List<RegisterModel>(); tbRegisterList = appontoContext.tb_register.Where(x => x.tb_user.id_user == userId && DbFunctions.AddHours(x.dt_register, x.vl_gmt) >= startDate && DbFunctions.AddHours(x.dt_register, x.vl_gmt) < endDate).OrderBy(x => x.dt_register).ToList(); if(desc) tbRegisterList = tbRegisterList.OrderByDescending(x => x.dt_register).ToList(); foreach (tb_register reg in tbRegisterList) ret.Add(ToModel(reg)); return ret; } }
private bool Add(int userId, List<AccessLevelModel> accessLevels) { using (var appontoContext = new AppontoContext()) { tb_user tbUser = appontoContext.tb_user.Where(x => x.id_user == userId).FirstOrDefault(); foreach (AccessLevelModel accessLevel in accessLevels) { tb_access_level tbAccessLevel = ToDbModel(accessLevel); appontoContext.tb_access_level.Attach(tbAccessLevel); tbAccessLevel.tb_user.Add(tbUser); } appontoContext.SaveChanges(); return true; } }
public RegisterModel Add(RegisterModel register) { using (var appontoContext = new AppontoContext()) { RegisterModel lastRegister = LoadCurrentDay(register.Date, register.User.Id, true).FirstOrDefault(); if (lastRegister != null) { register.IdLastRegister = lastRegister.Id; } register.Gmt = register.User.Gmt; tb_register tbRegister = ToDbModel(register); appontoContext.tb_register.Add(tbRegister); appontoContext.SaveChanges(); RegisterModel ret = ToModel(tbRegister); return ret; } }
public UserModel Update(int userId, ConfigurationLimitationModel configurationLimitation) { using (var appontoContext = new AppontoContext()) { tb_user tbUser = appontoContext.tb_user.SingleOrDefault(x => x.id_user == userId); tbUser.tb_configuration.tb_configuration_limitation.tb_limitation_type_id_limitation_type = configurationLimitation.LimitationType.Id; if (configurationLimitation.LimitationType.Id == (int)LimitationTypeEnum.Gps) { tbUser.tb_configuration.tb_configuration_limitation.vl_latitude = configurationLimitation.Latitude; tbUser.tb_configuration.tb_configuration_limitation.vl_longitude = configurationLimitation.Longitude; } else if (configurationLimitation.LimitationType.Id == (int)LimitationTypeEnum.Wifi) { tbUser.tb_configuration.tb_configuration_limitation.ds_host = configurationLimitation.Host; } appontoContext.SaveChanges(); UserModel ret = new UserService().ToModel(tbUser); return ret; } }
public UserModel UpdatePersonalInformation(UserModel user) { using (var appontoContext = new AppontoContext()) { tb_user tbUser = appontoContext.tb_user.SingleOrDefault(x => x.id_user == user.Id); tbUser.ds_name = user.Name; tbUser.ds_lastname = user.LastName; tbUser.id_identification = user.Identification; appontoContext.SaveChanges(); UserModel ret = ToModel(tbUser); return ret; } }
public UserModel New(UserModel user) { using (var appontoContext = new AppontoContext()) { #region Configurações iniciais do usuário ConfigurationModel configuration = new ConfigurationModel(); ConfigurationLimitationModel configurationLimitation = new ConfigurationLimitationModel(); ConfigurationService configurationService = new ConfigurationService(); ConfigurationLimitationService configurationLimitationService = new ConfigurationLimitationService(); configurationLimitation.LimitationType = new LimitationTypeModel() { Id = (int)LimitationTypeEnum.Nenhuma }; configurationLimitation = configurationLimitationService.Add(configurationLimitation); configuration.ConfigurationLimitation = configurationLimitation; user.Configuration = configurationService.Add(configuration); user.Gmt = -3; #endregion tb_user tbUser = ToDbModel(user); #region Empresa bool newCompany = false; if (user.Company != null) { CompanyService companyService = new CompanyService(); if (string.IsNullOrEmpty(user.Company.Token)) { newCompany = true; user.Company.Token = Guid.NewGuid().ToString().Substring(0, 10); tbUser.tb_company = companyService.ToDbModel(user.Company); } else { tbUser.tb_company_id_company = companyService.Get(user.Company.Token).Id; } } #endregion #region Permissões iniciais do usuário AccessLevelService accessLevelService = new AccessLevelService(); List<AccessLevelModel> accessLevels = new List<AccessLevelModel>(); if (user.Company != null && newCompany) accessLevels.Add(new AccessLevelModel() { Id = (int)AccessLevelEnum.Administrator }); else accessLevels.Add(new AccessLevelModel() { Id = (int)AccessLevelEnum.User }); user.AccessLevel = accessLevels; foreach (AccessLevelModel accessLevel in accessLevels) { tb_access_level tbAccessLevel = accessLevelService.ToDbModel(accessLevel); appontoContext.tb_access_level.Attach(tbAccessLevel); tbUser.tb_access_level.Add(tbAccessLevel); } #endregion appontoContext.tb_user.Add(tbUser); appontoContext.SaveChanges(); UserModel ret = ToModel(tbUser); return ret; } }
private bool Remove(int userId) { using (var appontoContext = new AppontoContext()) { tb_user tbUser = appontoContext.tb_user.Where(x => x.id_user == userId).FirstOrDefault(); var accessLevels = tbUser.tb_access_level.ToList(); accessLevels.ForEach(x => tbUser.tb_access_level.Remove(x)); appontoContext.SaveChanges(); return true; } }
public bool UpdateAccessInformation(UserModel user) { using (var appontoContext = new AppontoContext()) { tb_user tbUser = appontoContext.tb_user.Where(x => x.id_user == user.Id).FirstOrDefault(); if (tbUser.ds_password != user.OldPassword) return false; tbUser.ds_password = user.Password; appontoContext.SaveChanges(); return true; } }