Inheritance: INotifyPropertyChanged, INotifyPropertyChanging
 public static void insertRow(Row temp)
 {
     DB.Rows.InsertOnSubmit(temp);
     DB.SubmitChanges();
 }
        private void SaveLocation_DoubleTap(object sender, System.Windows.Input.GestureEventArgs e)
        {
            user_feedback.VibrateOnItemSelected();
            String temp_Radius = "0";
            String temp_Note = "";
            String temp_RingTones = "";
            String temp_icon_light = "";
            String temp_icon_dark = "";
            String error = "";
            if (Title.Text == "" && error == "") error = "Title";

            // check if radius contains more than one "."
            int count = 0;
            if (Radius.Visibility == Visibility.Visible && error == "")
            {
                for (int i = 0; i < Radius.Text.Count(); i++)
                {
                    if (Radius.Text.ElementAt(i).Equals('.'))
                    {
                        count++;
                    }
                }
                if (count > 1)
                {
                    error = "Radius";
                }
                else if (Radius.Text == "." || Radius.Text == "")
                {
                    error = "Radius";
                }
                else if (Convert.ToDouble(Radius.Text) > 0)
                {
                    // do nothing, radius is greater than 0
                }
                else
                {
                    error = "Radius";
                }
            }

            if (Radius.Visibility == Visibility.Visible && (Radius.Text == "" || Radius.Text == "0" || Radius.Text == "." || Radius.Text == "0.0" || Radius.Text == "0." || Radius.Text == ".0") && error == "") error = "Radius";
            if (Note.Visibility == Visibility.Visible && Note.Text == "" && error == "") error = "Note";
            if (Location.Visibility == Visibility.Visible)
            {
                if (Location.Text == "" && error == "") error = "Location";
            }

            if (error != "")
            {
                if (error != "Radius")
                {
                    MessageBox.Show(error + " cannot be empty ", "", MessageBoxButton.OK);
                }
                else
                {
                    MessageBox.Show(error + " cannot be empty or 0", "", MessageBoxButton.OK);
                }
            }
            else
            {
                if (Radius.Visibility == Visibility.Visible) temp_Radius = Radius.Text;
                if (Ring_Tones.Visibility == Visibility.Visible) temp_RingTones = (String)Ring_Tones.SelectedItem;
                if (Note.Visibility == Visibility.Visible) temp_Note = Note.Text;
                switch ((String)Type.SelectedItem)
                {
                    case "Alarm":
                        temp_icon_dark = "/Images/Mode.png/";
                        temp_icon_light = "/Images/Mode_Dark.png/";
                        break;
                    case "Car Locator":
                        temp_icon_dark = "/Images/PushpinCar.png/";
                        temp_icon_light = "/Images/PushpinCar_Dark.png/";
                        break;
                    case "Ring Tones":
                        temp_icon_dark = "/Images/Location.png/";
                        temp_icon_light = "/Images/Location_Dark.png/";
                        break;
                    default:
                        temp_icon_dark = "/Images/PushpinCar.png/";
                        temp_icon_light = "/Images/PushpinCar_Dark.png/";
                        break;
                }
                if (!new_page)//Edit Page
                {
                    if ((old_title != Title.Text) || (old_radius != temp_Radius) || (old_ringtones != temp_RingTones) || (old_type != (String)Type.SelectedItem) || (old_note != temp_Note))
                    {
                        Table.Remove(Edit_Query[0]);
                        DB_Helper.deleteRow(Edit_Query[0]);

                        // Create a new to-do item based on the text box.
                        Row newRow = new Row { Title = Title.Text, longitude = longitude, latitude = latitude, Radius = Double.Parse(temp_Radius), Ring_Tones = temp_RingTones, Type = (String)Type.SelectedItem, Note = temp_Note, Icon_Source_Dark = temp_icon_dark, Icon_Source_Light = temp_icon_light };

                        // Add a to-do item to the observable collection.
                        Table.Add(newRow);

                        DB_Helper.insertRow(newRow);
                        NavigationService.Navigate(new Uri("/MainPage.xaml", UriKind.RelativeOrAbsolute));
                    }
                    else
                    {
                        NavigationService.Navigate(new Uri("/MainPage.xaml", UriKind.RelativeOrAbsolute));
                    }
                }
                else// New Page
                {
                    if (DB_Helper.getRowsbyTitle(Title.Text).Count != 0)
                    {
                        MessageBox.Show("The title is already used ", "", MessageBoxButton.OK);
                    }
                    else
                    {
                        Row newRow = new Row { Title = Title.Text, longitude = longitude, latitude = latitude, Radius = Double.Parse(temp_Radius), Ring_Tones = temp_RingTones, Type = (String)Type.SelectedItem, Note = temp_Note, Icon_Source_Dark = temp_icon_dark, Icon_Source_Light = temp_icon_light };

                        Table.Add(newRow);
                        DB_Helper.insertRow(newRow);

                        NavigationService.Navigate(new Uri("/MainPage.xaml", UriKind.RelativeOrAbsolute));
                    }
                }
            }

            user_feedback.Speak("Location Saved");
            avoiddouble = true;
        }
 public static void deleteRow(Row temp)
 {
     DB.Rows.DeleteOnSubmit(temp);
     DB.SubmitChanges();
 }