public bool Authenticate(string username, string passkey, string deviceid)
{
RedTrailEntities db = new RedTrailEntities();
passkey = Utility.GetMd5Hash(passkey);
return(db.RedUsers.Where(p => p.Username == username && p.PasswordHash == passkey).Any());
}
public bool Register(UserForm user)
{
try
{
RedTrailEntities db = new RedTrailEntities();
db.RedUsers.Add(new RedUser {
Address1 = user.Address1,
Address2 = user.Address2,
Age = user.Age,
BloodGroup = user.BloodGroup,
ContactNo = user.ContactNo,
CreatedAt = user.CreatedAt,
Email = user.Email,
Gender = user.Gender,
IsDonor = user.IsDonor,
PasswordHash = Utility.GetMd5Hash(user.Password),
Latitude = user.Latitude,
Longtitude = user.Longtitude,
Username = user.Username,
Location = Utility.GetLocation(user.Latitude, user.Longtitude)
});
db.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
/// <summary>
/// This Script uses the Haversine Formula (shown below) expressed in terms of a two-argument inverse tangent function to calculate the great circle distance between two points on the Earth.
/// This is the method recommended for calculating short distances by Bob Chamberlain ([email protected]) of Caltech and NASA's Jet Propulsion Laboratory as described on the U.S. Census Bureau Web site.
/// </summary>
/// <param name="latitude"></param>
/// <param name="longtitude"></param>
/// <returns></returns>
public static int GetLocation(string latitude, string longtitude)
{
RedTrailEntities db = new RedTrailEntities();
RedLocation[] redlocations = db.RedLocations.ToArray();
double dlat = Convert.ToDouble(latitude);
double dlon = Convert.ToDouble(longtitude);
int nearestId = 0;
double nearestdistance = -1;
foreach (var zone in redlocations)
{
double d = Calculate(dlat, dlon, Convert.ToDouble(zone.LatitudeMedian), Convert.ToDouble(zone.LongtitudeMedian));
if (nearestdistance > 0 || d < nearestdistance)
{
nearestId = zone.Id;
}
}
return(nearestId);
}
public UserForm[] SelectByZone(int Zoneid)
{
RedTrailEntities db = new RedTrailEntities();
return(db.RedUsers.Where(p => p.RedLocation.Id == Zoneid).Select(p => new UserForm()
{
Address1 = p.Address1,
Address2 = p.Address2,
Age = p.Age,
BloodGroup = p.BloodGroup,
ContactNo = p.ContactNo,
CreatedAt = p.CreatedAt,
Email = p.Email,
Gender = p.Gender,
IsDonor = p.IsDonor,
Zone = p.RedLocation.ZoneName,
ZoneId = p.RedLocation.Id,
Username = p.Username,
Longtitude = p.Longtitude,
Latitude = p.Latitude
}).ToArray());
}
public UserForm SelectOne(string username)
{
RedTrailEntities db = new RedTrailEntities();
return(db.RedUsers.Where(p => p.Username == username).Select(p => new UserForm()
{
Address1 = p.Address1,
Address2 = p.Address2,
Age = p.Age,
BloodGroup = p.BloodGroup,
ContactNo = p.ContactNo,
CreatedAt = p.CreatedAt,
Email = p.Email,
Gender = p.Gender,
IsDonor = p.IsDonor,
Zone = p.RedLocation.ZoneName,
ZoneId = p.RedLocation.Id,
Username = p.Username,
Longtitude = p.Longtitude,
Latitude = p.Latitude
}).SingleOrDefault());
}
public UserForm GetOne()
{
RedTrailEntities db = new RedTrailEntities();
RedUser user = db.RedUsers.FirstOrDefault();
return(new UserForm()
{
Address1 = user.Address1,
Username = user.Username,
Password = user.PasswordHash,
Address2 = user.Address2,
Age = user.Age,
BloodGroup = user.BloodGroup,
ContactNo = user.ContactNo,
CreatedAt = user.CreatedAt,
Email = user.Email,
Gender = user.Gender,
IsDonor = user.IsDonor,
Latitude = user.Latitude,
Longtitude = user.Longtitude
});
}
public UserForm[] Select()
{
//int pageSize = Convert.ToInt16(ConfigurationManager.AppSettings["paging"]);
RedTrailEntities db = new RedTrailEntities();
return(db.RedUsers.Select(p => new UserForm()
{
Address1 = p.Address1,
Address2 = p.Address2,
Age = p.Age,
BloodGroup = p.BloodGroup,
ContactNo = p.ContactNo,
CreatedAt = p.CreatedAt,
Email = p.Email,
Gender = p.Gender,
IsDonor = p.IsDonor,
Zone = p.RedLocation.ZoneName,
ZoneId = p.RedLocation.Id,
Username = p.Username,
Longtitude = p.Longtitude,
Latitude = p.Latitude,
Id = p.Id
}).ToArray());
}