/// <summary> /// Get /// </summary> /// <param name="userId"></param> /// <returns></returns> public UserModel Get(int userId) { try { using (var e = new EntitiesModel()) { if (e.Users.Where(u => u.UserId == userId).Count() != 0) { var user = e.Users.Where(u => u.UserId == userId).FirstOrDefault(); return new UserModel() { EmailAddress = user.EmailAddress, IrcHostName = user.IrcHostName, IrcRealName = user.IrcRealName, IrcServerName = user.IrcServerName, IrcUser = user.IrcUser, Password = user.Password, UserId = user.UserId, Nickname = user.Nickname, EmailVerified = user.EmailVerified, RegistrationGuid = user.RegistrationGuid }; } return null; } } catch (Exception ex) { throw ex; } }
/// <summary> /// Create /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Create(SendDataModel model) { try { using (var e = new EntitiesModel()) { var item = new SendData(); item.ConnectionId = model.ConnectionId; item.Data = model.Data; item.Timestamp = model.Timestamp; return true; } } catch (Exception ex) { throw ex; } }
/// <summary> /// Authenticate /// </summary> /// <param name="emailAddress"></param> /// <param name="password"></param> /// <returns></returns> public int Authenticate(string emailAddress, string password) { try { using (var e = new EntitiesModel()) { if (e.Users.Where(u => u.EmailAddress == emailAddress && u.Password == password && u.EmailVerified).Count() != 0) { var user = e.Users.Where(u => u.EmailAddress == emailAddress && u.Password == password && u.EmailVerified).FirstOrDefault(); return user.UserId; } else { return 0; } } } catch (Exception ex) { throw ex; } }
/// <summary> /// Create /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Create(DataArrivalLogModel model) { try { using (var e = new EntitiesModel()) { var item = new DataArrivalLog(); item.Data = model.Data; item.ConnectionId = model.ConnectionId; item.Timestamp = model.Timestamp; e.Add(item); e.SaveChanges(); return true; } } catch (Exception ex) { throw ex; } }
/// <summary> /// Get /// </summary> /// <param name="serviceTypeId"></param> /// <returns></returns> public ServiceTypeModel Get(int serviceTypeId) { try { using (var e = new EntitiesModel()) { var item = new ServiceTypeModel(); return new ServiceTypeModel() { Description = item.Description, IsActive = item.IsActive, ServiceTypeEnumId = item.ServiceTypeEnumId, ServiceTypeId = item.ServiceTypeId }; } } catch (Exception ex) { throw ex; } }
/// <summary> /// Email Verify /// </summary> /// <param name="guid"></param> /// <returns></returns> public int EmailVerify(string guid) { try { using (var e = new EntitiesModel()) { if (e.Users.Where(u => u.RegistrationGuid == guid).Count() != 0) { var user = e.Users.Where(u => u.RegistrationGuid == guid).LastOrDefault(); user.EmailVerified = true; user.RegistrationGuid = ""; e.SaveChanges(); return user.UserId; } else { return 0; } } } catch (Exception ex) { throw ex; } }
/// <summary> /// Get All /// </summary> /// <returns></returns> public List<ServiceTypeModel> GetAll() { try { var result = new List<ServiceTypeModel>(); using (var e = new EntitiesModel()) { foreach (var item in e.ServiceTypes) { result.Add(new ServiceTypeModel() { Description = item.Description, IsActive = item.IsActive, ServiceTypeEnumId = item.ServiceTypeEnumId, ServiceTypeId = item.ServiceTypeId }); } } return result; } catch (Exception ex) { throw ex; } }
/// <summary> /// Create /// </summary> /// <param name="model"></param> /// <returns></returns> public int Create(ConnectionModel model) { try { using (var e = new EntitiesModel()) { var connection = new Connection(); connection.UserId = model.UserId; connection.Server = model.Server; connection.Port = model.Port; connection.Connected = model.Connected; connection.Description = model.Description; connection.Monitoring = model.Monitoring; connection.ServiceType = model.ServiceType; e.Add(connection); e.SaveChanges(); return connection.ConnectionId; } } catch (Exception ex) { throw ex; } }
/// <summary> /// Update /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Update(ConnectionModel model) { try { using (var e = new EntitiesModel()) { if (e.Connections.Where(c => c.ConnectionId == model.ConnectionId).Count() != 0) { var connection = e.Connections.Where(c => c.ConnectionId == model.ConnectionId).FirstOrDefault(); connection.Connected = model.Connected; connection.Description = model.Description; connection.Port = model.Port; connection.Server = model.Server; connection.UserId = model.UserId; connection.Monitoring = model.Monitoring; connection.ServiceType = model.ServiceType; e.SaveChanges(); return true; } else { return false; } } } catch (Exception ex) { throw ex; } }
/// <summary> /// Get /// </summary> /// <param name="userId"></param> /// <returns></returns> public List<ConnectionModel> Get(int userId) { try { using (var e = new EntitiesModel()) { var connections = e.Connections.Where(c => c.UserId == userId).ToList(); var result = new List<ConnectionModel>(); foreach (var item in connections) { result.Add(new ConnectionModel() { ConnectionId = item.ConnectionId, Port = item.Port, Server = item.Server, UserId = item.UserId, Connected = item.Connected, Description = item.Description, Monitoring = item.Monitoring, ServiceType = item.ServiceType }); } return result; } } catch (Exception ex) { throw ex; } }
/// <summary> /// Register /// </summary> /// <param name="emailAddress"></param> /// <param name="password"></param> /// <returns></returns> public int Register(string emailAddress, string password) { try { using (var e = new EntitiesModel()) { if (e.Users.Where(u => u.EmailAddress == emailAddress).Count() == 0) { var user = new User(); user.EmailAddress = emailAddress; user.Password = Crypto.EncryptStringAES(password, ; user.EmailVerified = false; user.IrcHostName = ""; user.IrcRealName = ""; user.IrcUser = ""; user.Nickname = ""; user.RegistrationGuid = ""; user.IrcServerName = ""; e.Add(user); e.SaveChanges(); return user.UserId; } else { return 0; } } } catch (Exception ex) { throw ex; } }
/// <summary> /// Set Registration Guid /// </summary> /// <param name="userId"></param> /// <param name="registrationGuid"></param> /// <returns></returns> public bool SetRegistrationGuid(int userId, string registrationGuid) { try { using (var e = new EntitiesModel()) { if (e.Users.Where(u => u.UserId == userId).Count() != 0) { var item = e.Users.Where(u => u.UserId == userId).LastOrDefault(); item.RegistrationGuid = registrationGuid; e.SaveChanges(); return true; } else { return false; } } } catch (Exception ex) { throw ex; } }