//Saves a request to the database. public void SaveUserRequest() { UserFreeRequest request = this; string sql = "INSERT INTO FreeRequestTable (start, end, text, username) values ('" + request._startTime.ToString() + "', '" + request._endTime.ToString() + "', '" + request._message + "', '" + request.User.UserName + "')"; Database.Instance.Execute(sql); Core.Instance.GetAllFreeRequests().Add(this); }
//First checks that all required fields are filled //Validates Dates and User, see RequestValitation method //If these checks pass, clean the error message. //Then cast the user from the combobox into a user object and removes all commas (,) from the text //Then create a UserFreeRequest with dates, message and username //Then saves user and clears messagebox. private void SendRequest_Click(object sender, RoutedEventArgs e) { if (Start_Date.SelectedDate.HasValue && End_Date.SelectedDate.HasValue && SelectUserComboBox.SelectedItem != null) { if (RequestValitation(Start_Date.SelectedDate.Value, End_Date.SelectedDate.Value, SelectUserComboBox.SelectedItem.ToString())) { ErrorMessage.Content = ""; User user = SelectUserComboBox.SelectedItem as User; string message = Message_Box.Text.Replace(",", ""); UserFreeRequest ResultRequest = new UserFreeRequest(Start_Date.SelectedDate.Value, End_Date.SelectedDate.Value, message, user.UserName); ResultRequest.SaveUserRequest(); Message_Box.Clear(); } else { ErrorMessage.Content = "The selected start date is after the end date"; } } }