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