public void SaveQueryHelper(string name, string query, string groupId)
{
var savedGroupIdString = ObjectId.GenerateNewId();
try
{
savedGroupIdString = GroupsCollection.Find(q => q.Name == "Saved").FirstOrDefault().Id;
}
catch (Exception)
{
savedGroupIdString = ObjectId.Parse("5c7416681c9d4400004a9cb0");
}
var outGroupId = ObjectId.GenerateNewId();
var isParseSuccess = ObjectId.TryParse(groupId, out outGroupId);
if (!string.IsNullOrEmpty(query))
{
query = query.Replace("/", @"\\");
query = "{\"query\":\"" + query + "\"}";
}
QueriesCollection.InsertOne(new QueryModel
{
Name = name,
Query = query,
GroupId = isParseSuccess ? outGroupId : savedGroupIdString
});
}
// Handle query saving
private void SaveQueryBtn_Click(object sender, RoutedEventArgs e)
{
Query queryToSave = QueriesCollection.FirstOrDefault(i => i.Name == QueryNameTextbox.Text);
if (queryToSave == null)
{
QueryNameTextbox.BorderBrush = BorderBrush;
Query q = new Query()
{
Name = QueryNameTextbox.Text,
Tags = DlQueryBox.Text,
QueryStr = BuildQuery(),
MinScore = (MinimumScore_Numeric.Value != null) ? (int)MinimumScore_Numeric.Value : 0,
MaxScore = (MaximumScore_Numeric.Value != null) ? (int)MaximumScore_Numeric.Value : 0,
Ratings = new[]
{
Safe_Switch.IsChecked != null && (bool)Safe_Switch.IsChecked,
Questionable_Switch.IsChecked != null && (bool)Questionable_Switch.IsChecked,
Explicit_Switch.IsChecked != null && (bool)Explicit_Switch.IsChecked
}
};
QueriesCollection.Insert(0, q);
q.SaveQuery();
}
else
{
QueryNameTextbox.BorderBrush = System.Windows.Media.Brushes.Red;
testBox.Text = "There already is a query with this name";
}
}
// Delete query
private void DeleteQueryBtn_Click(object sender, RoutedEventArgs e)
{
Query queryToDelete = QueriesCollection.FirstOrDefault(i => i.Name == (string)(sender as Button)?.Tag);
if (queryToDelete != null)
{
QueriesCollection.Remove(queryToDelete);
queryToDelete.DeleteQuery();
}
}
public RedmineServiceContext(Uri serviceUri, string apiKey)
{
_serviceUri = serviceUri;
_apiKey = apiKey;
_news = new NewsCollection(this);
_projects = new ProjectsCollection(this);
_issues = new IssuesCollection(this);
_users = new UsersCollection(this);
_userRoles = new UserRolesCollection(this);
_relations = new IssueRelationsCollection(this);
_trackers = new IssueTrackersCollection(this);
_statuses = new IssueStatusesCollection(this);
_priorities = new IssuePrioritiesCollection(this);
_categories = new IssueCategoriesCollection(this);
_versions = new ProjectVersionsCollection(this);
_attachments = new AttachmentsCollection(this);
_customFields = new CustomFieldsCollection(this);
_queries = new QueriesCollection(this);
_syncRoot = new object();
}
public void DeleteById(string id) => QueriesCollection.FindOneAndDelete(q => q.Id == ObjectId.Parse(id));
public QueryModel GetByIdHelper(string id) => QueriesCollection.Find(q => q.Id == ObjectId.Parse(id)).FirstOrDefault();
public List <QueryModel> GetQueriesByGroupHelper(string id) => QueriesCollection.Find(q => q.GroupId == ObjectId.Parse(id)).ToList();
