private void buttonDelete_Click(object sender, EventArgs e) { try { User_Location_Purpose ulp = new User_Location_Purpose(); DataGridViewRow selectedRow = dataGridViewMyCities.CurrentRow; if (selectedRow != null) { ulp.City = selectedRow.Cells[0].Value.ToString().Trim(); ulp.Purposetype = selectedRow.Cells[2].Value.ToString().Trim(); ulp.FromDate = Convert.ToDateTime(selectedRow.Cells[3].Value.ToString().Trim()); ulp.ToDate = Convert.ToDateTime(selectedRow.Cells[4].Value.ToString().Trim()); ulp.Username = currentUser.Username; Controller.DeleteUserLocationPurpose(ulp); UsersLocationsTimesToDataGrid(); labelFeedback.Text = "Successfully deleted a preference from your account"; } else { labelFeedback.Text = "Please select a preference from the table."; } } catch (DbUpdateException ex) { labelFeedback.Text = ErrorHandler.HandleError(ex); } catch (EntityException ex) { labelFeedback.Text = ErrorHandler.HandleError(ex); } }
public static void AddUserLocationPurpose(User_Location_Purpose ulp) { using (FriendlyDBEntities context = new FriendlyDBEntities()) { context.User_Location_Purpose.Add(ulp); context.SaveChanges(); } }
public static void DeleteUserLocationPurpose(User_Location_Purpose ulp) { using (FriendlyDBEntities context = new FriendlyDBEntities()) { context.User_Location_Purpose.Attach(ulp); context.User_Location_Purpose.Remove(ulp); context.SaveChanges(); } }
private void buttonAddLocation_Click(object sender, EventArgs e) { User_Location_Purpose ulp = new User_Location_Purpose(); ulp.Username = currentUser.Username; if (cueComboBoxInterestedIn.SelectedIndex >= 0 && cueComboBoxCity.SelectedIndex >= 0) { try { ulp.Purposetype = cueComboBoxInterestedIn.SelectedValue.ToString().Trim(); ulp.City = cueComboBoxCity.SelectedValue.ToString().Trim(); ulp.FromDate = dateTimePickerFrom.Value.Date; ulp.ToDate = dateTimePickerTo.Value.Date; Controller.AddUserLocationPurpose(ulp); UsersLocationsTimesToDataGrid(); DefaultValuesLocation(); this.errorProvider.SetError(cueComboBoxCity, string.Empty); labelFeedback.Text = "Successfully added a new preference to your account"; } catch (DbUpdateException ex) { labelFeedback.Text = ErrorHandler.HandleError(ex); } catch (EntityException ex) { labelFeedback.Text = ErrorHandler.HandleError(ex); } catch (ArgumentNullException ex) { labelFeedback.Text = ErrorHandler.HandleError(ex); } } else { labelFeedback.Text = "Please select an interest and a city."; this.errorProvider.SetError(cueComboBoxCity, "Please enter an interest and a city."); } }
public static void DeleteUserLocationPurpose(User_Location_Purpose ulp) { Dal.DeleteUserLocationPurpose(ulp); }
public static void AddUserLocationPurpose(User_Location_Purpose ulp) { Dal.AddUserLocationPurpose(ulp); }