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