public void AddNewCoordinates(double lat, double lon, string user)
{
using (var context = new CheckInEntities())
{
context.Coordinates.Add(new Coordinates {
Latitude = lat, Longitude = lon, UserFK = user
});
context.SaveChanges();
}
}
/*Establish connection with database*/
private void Connection()
{
using (var context = new CheckInEntities())
{
foreach (var log in context.LoginInfoes)
{
SetValue(new LoginInfo {
Login = log.Login, Password = log.Password, Email = log.Email
});
}
}
}
public object[] GetCoordinates(string login)
{
using (var context = new CheckInEntities())
{
var coords = from coord in context.Coordinates
join log in context.LoginInfoes
on coord.UserFK equals log.Email
where log.Email.Equals(login)
select new TripleL()
{
Latitude = coord.Latitude,
Longitude = coord.Longitude,
Login = coord.UserFK
};
return(coords.ToArray <TripleL>());
}
}
/*Adding new user to database*/
public bool SignUpUser(string log, string pas, string mail)
{
using (var context = new CheckInEntities())
{
try
{
context.LoginInfoes.Add(new CheckInEF.LoginInfo()
{
Login = log, Password = pas, Email = mail
});
context.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
}
