Beispiel #1
0
        //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";
         }
     }
 }