public static Postmen GetPostman(string token)
{
using (Post_DbEntities db = new Post_DbEntities())
{
var model = db.PostmanSessions.FirstOrDefault(u => u.Token == token);
return(model?.Postmen);
}
}
private static void GetRequest(object result)
{
using (Post_DbEntities db = new Post_DbEntities())
{
int id = (int)result;
var request = db.UserRequests.Find(id);
if (request != null)
{
var nears = AsyncSocket._Postman
.Select(u => new
{
distance = Math.Pow(Convert.ToDouble(u.PostmanModel.Latitude.Replace('.', '/')) -
Convert.ToDouble(request.OriginLatitude.Replace('.', '/')), 2) +
Math.Pow(Convert.ToDouble(u.PostmanModel.Longitiude.Replace('.', '/')) -
Convert.ToDouble(request.OriginLongitiude.Replace('.', '/')), 2),
id = u.PostmanModel.Token
}).OrderBy(u => u.distance).ToList();
}
}
}
public static void SaveData(string data)
{
string query = "";
object cmm = null;
try
{
//var test = Properties.Settings.Default.__connection;
//using (SqlConnection con = new SqlConnection(test))
//{
// string aquery = "INSERT INTO [dbo].[TruckLocations]" +
// "([TruckId],[Latitude],[Longitiude])" +
// "VALUES(19,'from clinet','" + data.ToString() + "')";
// con.Open();
// SqlCommand aCommand = new SqlCommand(aquery, con);
// cmm = aCommand.ExecuteScalar();
// SqlCommand command = new SqlCommand(query, con);
// command.ExecuteNonQuery();
//}
using (Post_DbEntities db = new Post_DbEntities())
{
db.TruckLocations.Add(new TruckLocation()
{
Latitude = "From client",
TruckId = 19,
Longitiude = data
});
db.SaveChanges();
}
}
catch (Exception e)
{
}
}
