public Users FindUser(string username)
{
SensorMonitoringSystemEntities SMSE = new SensorMonitoringSystemEntities();
var UserEntity = (from p in SMSE.Users where p.Username == username select p).FirstOrDefault();
if (UserEntity != null)
{
return(new Users
{
UserID = UserEntity.UserID,
CompanyID = UserEntity.CompanyID,
Name = UserEntity.Name,
Surname = UserEntity.Surname,
PhoneNumber = UserEntity.PhoneNumber,
Username = UserEntity.Username,
Password = UserEntity.Password,
IsActivated = UserEntity.IsActivated,
RegistrationCode = UserEntity.RegistrationCode
});
}
else
{
return(null);
}
}
public List <SensorsDatas> FindDatasBetweenDates(string sensorid, string startdate, string enddate)
{
SensorMonitoringSystemEntities SMSE = new SensorMonitoringSystemEntities();
List <SensorsDatas> results = new List <SensorsDatas>();
int SensorID = Int32.Parse(sensorid);
DateTime StartDate = DateTime.Parse(startdate);
DateTime EndDate = DateTime.Parse(enddate);
var SensorDatasEntity = (from p in SMSE.DatasBetweenDates(SensorID, StartDate, EndDate) select p);
if (SensorDatasEntity != null)
{
foreach (var datas in SensorDatasEntity)
{
results.Add(new SensorsDatas()
{
DataID = datas.DataID,
SensorID = datas.SensorID,
ReadValue = datas.ReadValue,
ReadValueTime = datas.ReadValueTime
});
}
return(results);
}
else
{
return(null);
}
}
public void SendInfoMail(UsersDetails RegisteredUserDetail)
{
SensorMonitoringSystemEntities SMSE = new SensorMonitoringSystemEntities();
var UserEntity = (from p in SMSE.Users where p.UserID == RegisteredUserDetail.UserID select p).FirstOrDefault();
var UserDetailEntity = (from p in SMSE.UsersDetails where p.UserID == RegisteredUserDetail.UserID select p).FirstOrDefault();
var fromAddress = new MailAddress("*****@*****.**", "TechExpert Officer");
var toAddress = new MailAddress(UserDetailEntity.Email, UserEntity.Name + " " + UserEntity.Surname);
const string fromPassword = "******";
const string subject = "Sensor Monitoring System Registration";
string body = "Your username is " + UserEntity.Username +
" and your password is " + UserEntity.Password +
" and your activation code is " + UserEntity.RegistrationCode;
var smtp = new SmtpClient
{
Host = "smtp.gmail.com",
Port = 587,
EnableSsl = true,
DeliveryMethod = SmtpDeliveryMethod.Network,
Credentials = new NetworkCredential(fromAddress.Address, fromPassword),
Timeout = 20000
};
using (var message = new MailMessage(fromAddress, toAddress)
{
Subject = subject,
Body = body
})
{
smtp.Send(message);
}
}
public List <SensorsDatas> FindAllSensorDatas(string sensorid)
{
SensorMonitoringSystemEntities SMSE = new SensorMonitoringSystemEntities();
List <SensorsDatas> results = new List <SensorsDatas>();
int IntID = Int32.Parse(sensorid);
var SensorDatasEntity = (from p in SMSE.SensorsDatas where p.SensorID == IntID select p);
if (SensorDatasEntity != null)
{
foreach (SensorsDatasEntity SensorDatas in SensorDatasEntity)
{
results.Add(new SensorsDatas()
{
DataID = SensorDatas.DataID,
SensorID = SensorDatas.SensorID,
ReadValue = SensorDatas.ReadValue,
ReadValueTime = SensorDatas.ReadValueTime
});
}
return(results);
}
else
{
return(null);
}
}
public Sensors FindSensor(string sensorid)
{
SensorMonitoringSystemEntities SMSE = new SensorMonitoringSystemEntities();
int IntID = Int32.Parse(sensorid);
var SensorEntity = (from p in SMSE.Sensors where p.SensorID == IntID select p).FirstOrDefault();
if (SensorEntity != null)
{
return(new Sensors()
{
SensorID = SensorEntity.SensorID,
CompanyID = SensorEntity.CompanyID,
SensorDescription = SensorEntity.SensorDescription,
SensorAddress = SensorEntity.SensorAddress,
GraphicalMinValue = SensorEntity.GraphicalMinValue,
GraphicalMaxValue = SensorEntity.GraphicalMaxValue,
LowestCriticalValue = SensorEntity.LowestCriticalValue,
HighestCriticalValue = SensorEntity.HighestCriticalValue,
SensorUnit = SensorEntity.SensorUnit
});
}
else
{
return(null);
}
}
public List <Sensors> FindCompaniesAllSensors(string companyid)
{
SensorMonitoringSystemEntities SMSE = new SensorMonitoringSystemEntities();
List <Sensors> results = new List <Sensors>();
int IntID = Int32.Parse(companyid);
var SensorsEntity = (from p in SMSE.Sensors where p.CompanyID == IntID select p);
if (SensorsEntity != null)
{
foreach (SensorsEntity Sensors in SensorsEntity)
{
results.Add(new Sensors()
{
SensorID = Sensors.SensorID,
CompanyID = Sensors.CompanyID,
SensorDescription = Sensors.SensorDescription,
SensorAddress = Sensors.SensorAddress,
GraphicalMinValue = Sensors.GraphicalMinValue,
GraphicalMaxValue = Sensors.GraphicalMaxValue,
LowestCriticalValue = Sensors.LowestCriticalValue,
HighestCriticalValue = Sensors.HighestCriticalValue,
SensorUnit = Sensors.SensorUnit
});
}
return(results);
}
else
{
return(null);
}
}
public void RegisterUserDetail(UsersDetails RegisteredUserDetail)
{
SensorMonitoringSystemEntities SMSE = new SensorMonitoringSystemEntities();
SMSE.UsersDetails.Add(new UsersDetailsEntity
{
UserID = RegisteredUserDetail.UserID,
City = RegisteredUserDetail.City,
Adress = RegisteredUserDetail.Address,
DateOfBirth = RegisteredUserDetail.DateOfBirth,
Email = RegisteredUserDetail.Email,
});
SMSE.SaveChanges();
}
public bool UsernameControl(string username)
{
SensorMonitoringSystemEntities SMSE = new SensorMonitoringSystemEntities();
var UserEntity = (from p in SMSE.Users where p.Username == username select p).FirstOrDefault();
if (UserEntity != null)
{
return(true);
}
else
{
return(false);
}
}
public bool SensorDataControl(string sensorid)
{
SensorMonitoringSystemEntities SMSE = new SensorMonitoringSystemEntities();
int IntID = Int32.Parse(sensorid);
var SensorDataEntity = (from p in SMSE.SensorsDatas where p.SensorID == IntID select p).FirstOrDefault();
if (SensorDataEntity != null)
{
return(true);
}
else
{
return(false);
}
}
public List <Companies> FindAllCompanies()
{
SensorMonitoringSystemEntities SMSE = new SensorMonitoringSystemEntities();
List <Companies> results = new List <Companies>();
foreach (CompaniesEntity Companies in SMSE.Companies)
{
results.Add(new Companies()
{
CompanyID = Companies.CompanyID,
CompanyName = Companies.CompanyName,
});
}
return(results);
}
public bool UserDetailControl(string userid)
{
SensorMonitoringSystemEntities SMSE = new SensorMonitoringSystemEntities();
int IntID = int.Parse(userid);
var UserDetailEntity = (from p in SMSE.UsersDetails where p.UserID == IntID select p).FirstOrDefault();
if (UserDetailEntity != null)
{
return(true);
}
else
{
return(false);
}
}
public void Activation(Users ActivatedUser)
{
SensorMonitoringSystemEntities SMSE = new SensorMonitoringSystemEntities();
var UserEntity = (from p in SMSE.Users where p.UserID == ActivatedUser.UserID select p).FirstOrDefault();
SMSE.Entry(UserEntity).CurrentValues.SetValues(new UsersEntity()
{
UserID = UserEntity.UserID,
CompanyID = UserEntity.CompanyID,
Name = UserEntity.Name,
Surname = UserEntity.Surname,
PhoneNumber = UserEntity.PhoneNumber,
Username = UserEntity.Username,
Password = UserEntity.Password,
IsActivated = true,
RegistrationCode = UserEntity.RegistrationCode
});
SMSE.SaveChanges();
}
public void RegisterUser(Users RegisteredUser)
{
SensorMonitoringSystemEntities SMSE = new SensorMonitoringSystemEntities();
bool Activation = false;
Random rnd = new Random();
long RandomCodeNumber = rnd.Next(111111, 999999);
SMSE.Users.Add(new UsersEntity
{
CompanyID = RegisteredUser.CompanyID,
Name = RegisteredUser.Name,
Surname = RegisteredUser.Surname,
PhoneNumber = RegisteredUser.PhoneNumber,
Username = RegisteredUser.Username,
Password = RegisteredUser.Password,
IsActivated = Activation,
RegistrationCode = RandomCodeNumber
});
SMSE.SaveChanges();
}
public void ChangeCode(Users ChangedCodeUser)
{
SensorMonitoringSystemEntities SMSE = new SensorMonitoringSystemEntities();
Random rnd = new Random();
long RandomCodeNumber = rnd.Next(111111, 999999);
var UserEntity = (from p in SMSE.Users where p.UserID == ChangedCodeUser.UserID select p).FirstOrDefault();
SMSE.Entry(UserEntity).CurrentValues.SetValues(new UsersEntity()
{
UserID = UserEntity.UserID,
CompanyID = UserEntity.CompanyID,
Name = UserEntity.Name,
Surname = UserEntity.Surname,
PhoneNumber = UserEntity.PhoneNumber,
Username = UserEntity.Username,
Password = UserEntity.Password,
IsActivated = UserEntity.IsActivated,
RegistrationCode = RandomCodeNumber
});
SMSE.SaveChanges();
}
public UsersDetails FindUserDetail(string userid)
{
SensorMonitoringSystemEntities SMSE = new SensorMonitoringSystemEntities();
int ID = int.Parse(userid);
var UserDetailEntity = (from p in SMSE.UsersDetails where p.UserID == ID select p).FirstOrDefault();
if (UserDetailEntity != null)
{
return(new UsersDetails
{
DetailID = UserDetailEntity.DetailID,
UserID = UserDetailEntity.UserID,
City = UserDetailEntity.City,
Address = UserDetailEntity.Adress,
DateOfBirth = UserDetailEntity.DateOfBirth,
Email = UserDetailEntity.Email
});
}
else
{
return(null);
}
}