internal static void UpdateTrack(string Token, GeoTag GTag)
{
List <GeoTag> tGTags;
if (TrackingDetails.TryGetValue(Token, out tGTags))
{
if (GTag.TimeStamp < tGTags.Last().TimeStamp)
{
tGTags.Add(GTag);
tGTags = tGTags.OrderBy(x => x.TimeStamp).ToList();
}
else
{
tGTags.Add(GTag);
}
}
else
{
tGTags = new List <GeoTag>();
tGTags.Add(GTag);
TrackingDetails.Add(Token, tGTags);
//BroadCaster
//1.1 Queue command
//1.2 DB Delegate update DB - should go to track Table
//if (Dummies4SOS.Members == null) Dummies4SOS.InitializeAllDataSet();
//Profile pr = Dummies4SOS.Members.Find(x => x.SOSToken == Token);
//if (pr != null)
//{
// pr.IsTrackingOn = true;
//}
//Triangulation
}
}
public List <TrackingDetails> getTrackingDetails(string docketno)
{
List <TrackingDetails> model = new List <TrackingDetails>();
// string dktno = TempData["dcktno"].ToString();
DataSet ds = GetTrackingData(docketno, "C");
try
{
foreach (DataRow dr in ds.Tables[1].Rows)
{
TrackingDetails del2 = new TrackingDetails();
del2.locationcode = dr["locationcode"].ToString();
del2.ArrivalDate = dr["ArrivalDate"].ToString();
del2.arrivalTime = dr["arrivalTime"].ToString();
del2.EntryDate = dr["EntryDate"].ToString();
del2.Origin = dr["Origin"].ToString();
del2.Status = dr["Status"].ToString();
model.Add(del2);
}
}
catch (Exception)
{
return(null);
}
return(model);
}
internal static void RemoveTracking(string Token)
{
if (TrackingDetails.ContainsKey(Token)) //TODO:Can Remove for Optimize
{
TrackingDetails.Remove(Token);
}
}
internal static List <GeoTag> FetchTrack(string Token)
{
List <GeoTag> tGTags = null;
TrackingDetails.TryGetValue(Token, out tGTags);
return(tGTags);
}
public ActionResult TrackByCity(string city)
{
TrackingDetails track = TrackingBM.GetTrackByCity(city);
ViewData["track"] = track;
return(View());
}
public ActionResult Uform(int id)
{
TrackingDetails td = TrackingBM.GetTrackById(id);
ViewData["track"] = td;
return(View());
}
public bool UpdateTrackingDetails(TrackingDetails det)
{
try
{
var client = new MongoClient(@"mongodb+srv://weathersparkdbadmin:[email protected]");
var db = client.GetDatabase("RadicalECartProducts");
var collection = db.GetCollection <TrackingDetails>("TrackingDetails");
collection.InsertOneAsync(det);
return(true);
}
catch (System.Exception ex)
{
return(false);
}
}
public static List <TrackingDetails> GetAllTrackingDeatils()
{
List <TrackingDetails> trackListOfAllTrucks = new List <TrackingDetails>();
IDbConnection conn = new MySqlConnection();
conn.ConnectionString = connectionString;
string qery = "select * from tracking_details;";
IDbCommand cmd = new MySqlCommand();
cmd.CommandText = qery;
cmd.Connection = conn;
MySqlDataAdapter ad = new MySqlDataAdapter(cmd as MySqlCommand);
DataSet ds = new DataSet();
try
{
ad.Fill(ds);
DataRowCollection rows = ds.Tables[0].Rows;
foreach (DataRow row in rows)
{
TrackingDetails thisDetails = new TrackingDetails();
thisDetails.trackingId = int.Parse(row["tracking_id"].ToString());
thisDetails.TruckRegNo = (row["truck_reg_no"].ToString());
thisDetails.currentMessage = (row["current_message"].ToString());
thisDetails.destinationCity = (row["destination_city"].ToString());
thisDetails.dispatchedDateTime = DateTime.Parse(row["dispatched_date_time"].ToString());
thisDetails.estimatedArrivalDateTime = DateTime.Parse(row["estimated_arrival_date_time"].ToString());
thisDetails.sourceCity = (row["source_city"].ToString());
thisDetails.status = (Status)Enum.Parse(typeof(Status), row["status"].ToString());
trackListOfAllTrucks.Add(thisDetails);
}
}
catch (MySqlException e)
{
string message = e.Message;
}
conn.Close();
return(trackListOfAllTrucks);
}
public bool EditTrackingDates(TrackingDetails det)
{
try
{
var client = new MongoClient(@"mongodb+srv://weathersparkdbadmin:[email protected]");
var db = client.GetDatabase("RadicalECartProducts");
var collection = db.GetCollection <TrackingDetails>("TrackingDetails");
if (det.ColumnToBeUpdated.Contains("InPackingDate"))
{
var info = Builders <TrackingDetails> .Update.Set(x => x.InPackingDate, det.InPackingDate);
collection.UpdateOne <TrackingDetails>(o => o.OrderId == det.OrderId, info);
}
else if (det.ColumnToBeUpdated.Contains("InLocalShopDate"))
{
var info = Builders <TrackingDetails> .Update.Set(x => x.InLocalShopDate, det.InLocalShopDate);
collection.UpdateOne <TrackingDetails>(o => o.OrderId == det.OrderId, info);
}
else if (det.ColumnToBeUpdated.Contains("DeliveredDate"))
{
var info = Builders <TrackingDetails> .Update.Set(x => x.DeliveredDate, det.DeliveredDate);
collection.UpdateOne <TrackingDetails>(o => o.OrderId == det.OrderId, info);
}
else if (det.ColumnToBeUpdated.Contains("ShippedDate"))
{
var info = Builders <TrackingDetails> .Update.Set(x => x.ShippedDate, det.ShippedDate);
collection.UpdateOne <TrackingDetails>(o => o.OrderId == det.OrderId, info);
}
return(true);
}
catch (System.Exception ex)
{
return(false);
}
}
