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); } }