public static void UpdateGoogleMilesUri(int originKey, Dictionary <int, string> lookupDestinationDict, bool updateAll = false) { int destKey = 0; //bool updateAll = UpdateAll.IsChecked.Value; using (var mdc = new MilesDataContext()) { foreach (var dest in lookupDestinationDict) { destKey = dest.Key; //Get the Mile Record var mRec = from mtable in mdc.Miles where mtable.FromId == originKey && mtable.ToId == destKey select mtable; foreach (Mile mile in mRec) { mile.GoogleUri = GoogleHelper.CreateGoogleMilesTableLink(originKey, mile.ToId); } //Submit changes to table try { mdc.SubmitChanges(); } catch (Exception exceptUpdate) { MessageBox.Show(exceptUpdate.Message.ToString()); } } } }
/// <summary> /// Method that updates the miles in the miles table /// </summary> /// <param name="originKey"></param> /// <param name="lookupOrigin"></param> /// <param name="lookupDestinationDict"></param> public static void UpdateMileage(int originKey, string lookupOrigin, Dictionary <int, string> lookupDestinationDict, bool updateAll = false) { int destKey = 0; using (var mdc = new MilesDataContext()) { foreach (var dest in lookupDestinationDict) { destKey = dest.Key; if (updateAll) { //Get the Mile Record var mRec = from mtable in mdc.Miles where mtable.FromId == originKey && mtable.ToId == destKey select mtable; foreach (Mile mile in mRec) { mile.Miles = (Int32)GoogleHelper.GetMileage(lookupOrigin, dest.Value); } } else { //Get the Mile Record var mRec = from mtable in mdc.Miles where mtable.FromId == originKey && mtable.ToId == destKey && mtable.Miles == 0 select mtable; foreach (Mile mile in mRec) { mile.Miles = (Int32)GoogleHelper.GetMileage(lookupOrigin, dest.Value); } } //Submit changes to table try { mdc.SubmitChanges(); } catch (Exception exceptUpdate) { MessageBox.Show(exceptUpdate.Message.ToString()); } } } }