private void buttonActivationGroup_MouseLeftButtonDown(object sender, MouseButtonEventArgs e)
{
int id = Convert.ToInt32(((sender as Label).Name).Replace("ID_", ""));
int indexImage = 1;
bool ifActivation = false;
for (int i = 0; i < activationGroup.Length; i++)
{
if (activationGroup[i].Name.Replace("ID_", "") == id.ToString())
{
indexImage = i;
}
}
ifActivation = (activationGroup[indexImage].Source.ToString().Contains("checkSymbol.png")) ? false : true;
if (Membership_db.ActivationGroup(id.ToString(), ifActivation))
{
BitmapImage src = new BitmapImage();
src.BeginInit();
if (ifActivation)
{
src.UriSource = new Uri("Pictures/checkSymbol.png", UriKind.Relative);
}
else
{
src.UriSource = new Uri("Pictures/cancel.png", UriKind.Relative);
}
src.EndInit();
activationGroup[indexImage].Source = src;
}
}
private void LoadGroup()
{
addFiltrPlus.Visibility = System.Windows.Visibility.Visible;
addFiltrButton.Visibility = System.Windows.Visibility.Visible;
int allInGroup = Convert.ToInt32(Membership_db.GetNumberApplicationInGroup(selectGroupId));
int inGroupWithFilter = Convert.ToInt32(Membership_db.GetNumberApplicationInGroupWithFilter(selectGroupId));
applicationInGroup.SetContent(allInGroup.ToString());
addingByFilter.SetContent(inGroupWithFilter.ToString());
effectivenessFilter.SetContent((ActionOnNumbers.DivisionD(inGroupWithFilter, allInGroup) * 100).ToString("0.00") + " %");
CommandParameters parameters = new CommandParameters();
parameters.ID.Add(selectGroupId);
List <Membership> groups = Membership_db.GetAllGroups(parameters);
if (!string.IsNullOrEmpty(groups[0].Filter))
{
contentsOfFilter.Text = groups[0].Filter;
contentsOfFilter.Visibility = System.Windows.Visibility.Visible;
}
if (groups[0].IfActiveConfiguration)
{
ifActivity.Visibility = System.Windows.Visibility.Visible;
buttonChangeActivity.Foreground = new SolidColorBrush(Color.FromArgb(255, 0, 155, 0));
}
if (groups[0].IfAsOneApplication)
{
treatAsOne.Visibility = System.Windows.Visibility.Visible;
buttonTreatAsOne.Foreground = new SolidColorBrush(Color.FromArgb(255, 0, 155, 0));
}
}
private void LoadGroupName()
{
Dictionary <string, string> namesGroup = Membership_db.GetNameGroupsDictionaryWithConfiguration();
int nextIndex = 0;
contentCanvas.Height = 316;
foreach (KeyValuePair <string, string> name in namesGroup)
{
Label group = ButtonCreator.CreateButton(contentCanvas, name.Value, 250, 29, 12, 20, 0 + (nextIndex * 32),
Color.FromArgb(255, 255, 255, 255), Color.FromArgb(255, 155, 155, 155));
group.Background = new SolidColorBrush(Color.FromArgb((byte)(50 + (nextIndex % 2 * 30)), 0, 125, 255));
group.Name = "ID_" + name.Key;
group.MouseEnter += buttonContent_MouseEnter;
group.MouseLeave += buttonContent_MouseLeave;
group.MouseLeftButtonDown += buttonEditGroup_MouseLeftButtonDown;
ButtonCreator.SetToolTip(group, "Edytuj");
contentCanvas.Height += 32;
nextIndex++;
}
contentCanvas.Height = ((contentCanvas.Height - 316) < 316) ? 316 : contentCanvas.Height - 315;
if (!namesGroup.Any())
{
new MyLabel(contentCanvas, "Brak konfiguracji", 120, 40, 12, 90, 10, Color.FromArgb(200, 255, 255, 255), Color.FromArgb(255, 230, 0, 0));
}
}
private void changeFiltrButton_MouseLeftButtonDown(object sender, MouseButtonEventArgs e)
{
if (!string.IsNullOrEmpty(contentsOfFilter.Text) && (contentsOfFilter.Text).Length > 3)
{
if (Membership_db.AddFilterToConfiguration(selectGroupId, contentsOfFilter.Text))
{
addFiltrAccept.Visibility = System.Windows.Visibility.Hidden;
applyFilterButton.Visibility = System.Windows.Visibility.Visible;
}
}
else
{
if (Membership_db.DeleteFilterToConfiguration(selectGroupId))
{
addFiltrAccept.Content = "Dodaj";
addFiltrAccept.MouseLeftButtonDown += addFiltrButton_MouseLeftButtonDown;
addFiltrAccept.MouseLeftButtonDown -= changeFiltrButton_MouseLeftButtonDown;
addFiltrPlus.Visibility = System.Windows.Visibility.Visible;
addFiltrButton.Visibility = System.Windows.Visibility.Visible;
contentsOfFilter.Visibility = System.Windows.Visibility.Hidden;
contentsOfFilter.Text = string.Empty;
addFiltrAccept.Visibility = System.Windows.Visibility.Hidden;
applyFilterButton.Visibility = System.Windows.Visibility.Hidden;
}
}
}
public WindowAddTo(Canvas parent, AddTo addTo)
{
InitializeComponent();
IsClosed = false;
parentCanvas = parent;
windowAddTo = addTo;
if (parent.Tag is int)
{
idMembership = Convert.ToInt32(parent.Tag);
}
if (idMembership == 0)
{
idApplication = parent.Name.Replace("ID_", "");
}
timerAnimation = new DispatcherTimer();
timerAnimation.Interval = new TimeSpan(0, 0, 0, 0, 10);
repeatIntervals = 0;
Canvas activity = new Canvas()
{
Width = 150, Height = 200,
};
ScrollViewer sv = ScrollViewerCreator.CreateScrollViewer(addToCanvas, 150, 200, 0, 0, activity);
Dictionary <string, string> names = new Dictionary <string, string>();
if (addTo == AddTo.Activity)
{
names = NameActivity_db.GetNameActivityDictionary();
}
else if (addTo == AddTo.Group)
{
names = Membership_db.GetNameGroupsDictionaryIfIsActive();
}
int nextIndex = 0;
foreach (KeyValuePair <string, string> name in names)
{
Label button = ButtonCreator.CreateButton(activity, name.Value, 150, 30, 12, 0, 29 * nextIndex,
Color.FromArgb(255, 255, 255, 255), Color.FromArgb(200, 255, 255, 255), 1);
activity.Height += 29;
button.MouseEnter += button_MouseEnter;
button.MouseLeave += button_MouseLeave;
button.MouseLeftButtonDown += button_MouseLeftButtonDown;
button.Name = "ID_" + name.Key;
nextIndex++;
}
activity.Height = ((activity.Height - 200) < 200) ? 200 : activity.Height - 199;
timerAnimation.Tick += new EventHandler(AnimationAddShow);
timerAnimation.Start();
}
private void DeleteGroup()
{
if (ActiveApplication_db.DeleteAllApplicationsWithGroup(activeGroupId))
{
if (Membership_db.DeleteGroup(activeGroupId))
{
contentCanvas.Children.Clear();
LoadGroups();
}
}
}
private void buttonSaveGroup_MouseLeftButtonDown(object sender, MouseButtonEventArgs e)
{
if (!Membership_db.CheckIfExistName(nameGroup.Text))
{
Membership_db.Add(nameGroup.Text);
CloseAddingGroup();
}
else
{
nameGroup.Background = new SolidColorBrush(Color.FromArgb(220, 255, 55, 55));
}
}
private void deleteConfigurationButton_MouseLeftButtonDown(object sender, MouseButtonEventArgs e)
{
if (selectGroupId != 0)
{
if (Membership_db.DeleteConfiguration(selectGroupId))
{
ExitConfigure();
}
else
{
(sender as Label).Background = new SolidColorBrush(Color.FromArgb(220, 255, 0, 0));
}
}
}
private bool FindApplication()
{
if (nameApplicationToException.Text.Length > 2)
{
Regex regex = new Regex(nameApplicationToException.Text.Trim(), RegexOptions.IgnoreCase);
Dictionary <string, string> titleApplication = ActiveApplication_db.GetNameApplicationDictionaryWithoutGroup();
Dictionary <string, string> titleMembership = Membership_db.GetNameGroupsDictionaryWithConfiguration();
Dictionary <string, string> titleFindApplication = new Dictionary <string, string>();
foreach (KeyValuePair <string, string> title in titleApplication)
{
if (regex.Matches(title.Value).Count > 0)
{
titleFindApplication[title.Key] = title.Value;
}
}
foreach (KeyValuePair <string, string> title in titleMembership)
{
if (regex.Matches(title.Value).Count > 0)
{
titleFindApplication[title.Key + "M"] = title.Value;
}
}
searchApplicationCanvas.Children.Clear();
searchApplicationCanvas.Height = 252;
int nextIndex = 0;
foreach (KeyValuePair <string, string> name in titleFindApplication)
{
Label application = ButtonCreator.CreateButton(searchApplicationCanvas, name.Value, 250, 29, 12, 20, 0 + (nextIndex * 32),
Color.FromArgb(255, 255, 255, 255), Color.FromArgb(255, 155, 155, 155), horizontalAlignment: HorizontalAlignment.Left);
application.Background = new SolidColorBrush(Color.FromArgb(155, 0, 125, 255));
application.Name = "ID_" + name.Key;
application.MouseEnter += buttonContent_MouseEnter;
application.MouseLeave += buttonContent_MouseLeave;
application.MouseLeftButtonDown += findApplication_MouseLeftButtonDown;
searchApplicationCanvas.Height += 32;
nextIndex++;
}
searchApplicationCanvas.Height = ((searchApplicationCanvas.Height - 252) < 252) ? 252 : searchApplicationCanvas.Height - 251;
idAddExceptionApplication = 0;
return(nextIndex > 0);
}
return(false);
}
private void buttonOpenChooseGroup(object sender, MouseButtonEventArgs e)
{
Dictionary <string, string> namesGroup = Membership_db.GetNameGroupsDictionaryWithoutConfiguration();
chooseGroup.MouseLeftButtonDown -= buttonOpenChooseGroup;
chooseGroup.MouseLeftButtonDown += buttonCloseChooseGroup;
chooseGroup.Content = "Ukryj grupy";
int nextIndex = 0;
chooseGroupCanvas.Height = 126;
contentsOfFilter.Visibility = System.Windows.Visibility.Hidden;
contentsOfFilter.Text = string.Empty;
addFiltrAccept.Visibility = System.Windows.Visibility.Hidden;
applyFilterButton.Visibility = System.Windows.Visibility.Hidden;
resultsApplyFilter.Visibility = System.Windows.Visibility.Hidden;
resultsDeleteApplication.Visibility = System.Windows.Visibility.Hidden;
ifActivity.Visibility = System.Windows.Visibility.Hidden;
buttonChangeActivity.Foreground = new SolidColorBrush(Color.FromArgb(255, 155, 155, 155));
treatAsOne.Visibility = System.Windows.Visibility.Hidden;
buttonTreatAsOne.Foreground = new SolidColorBrush(Color.FromArgb(255, 155, 155, 155));
applicationInGroup.SetContent("0");
addingByFilter.SetContent("0");
effectivenessFilter.SetContent("0.00 %");
foreach (KeyValuePair <string, string> name in namesGroup)
{
Label group = ButtonCreator.CreateButton(chooseGroupCanvas, name.Value, 200, 29, 12, 0, 0 + (nextIndex * 32),
Color.FromArgb(255, 255, 255, 255), Color.FromArgb(255, 155, 155, 155));
group.Background = new SolidColorBrush(Color.FromArgb((byte)(50 + (nextIndex % 2 * 30)), 0, 125, 255));
group.Name = "ID_" + name.Key;
group.MouseEnter += buttonContent_MouseEnter;
group.MouseLeave += buttonContent_MouseLeave;
group.MouseLeftButtonDown += buttonChooseGroup_MouseLeftButtonDown;
chooseGroupCanvas.Height += 32;
nextIndex++;
}
chooseGroupCanvas.Height = ((chooseGroupCanvas.Height - 126) < 126) ? 126 : chooseGroupCanvas.Height - 125;
}
private void buttonChangeActivity_MouseLeftButtonDown(object sender, MouseButtonEventArgs e)
{
if (selectGroupId > 0)
{
if (ifActivity.Visibility == System.Windows.Visibility.Hidden)
{
if (Membership_db.SetActivityConfiguration(selectGroupId, true))
{
ifActivity.Visibility = System.Windows.Visibility.Visible;
(sender as Label).Foreground = new SolidColorBrush(Color.FromArgb(255, 0, 155, 0));
}
}
else
{
if (Membership_db.SetActivityConfiguration(selectGroupId, false))
{
ifActivity.Visibility = System.Windows.Visibility.Hidden;
(sender as Label).Foreground = new SolidColorBrush(Color.FromArgb(255, 155, 155, 155));
}
}
}
}
private void buttonChangeTreatAsOne_MouseLeftButtonDown(object sender, MouseButtonEventArgs e)
{
if (selectGroupId > 0)
{
if (treatAsOne.Visibility == System.Windows.Visibility.Hidden)
{
if (Membership_db.SetAsOneApplication(selectGroupId, true))
{
ActiveApplication_db.DeleteNameActivityForIdMembership(selectGroupId);
treatAsOne.Visibility = System.Windows.Visibility.Visible;
(sender as Label).Foreground = new SolidColorBrush(Color.FromArgb(255, 0, 155, 0));
}
}
else
{
if (Membership_db.SetAsOneApplication(selectGroupId, false))
{
treatAsOne.Visibility = System.Windows.Visibility.Hidden;
(sender as Label).Foreground = new SolidColorBrush(Color.FromArgb(255, 155, 155, 155));
}
}
}
}
private void AddNameTitleToTableDailyUse()
{
string contentCommand = string.Empty;
if (!ActiveApplication_db.CheckIfExistTitle(nameTitle))
{
contentCommand = "INSERT INTO activeapplications (Title, IdNameActivity) VALUES ( "
+ nameTitle + " , " + 1 + " )";
DataBase.ExecuteNonQuery(contentCommand);
}
contentCommand = "INSERT INTO dailyuseofapplication (IdTitle, ActivityTime) " +
"SELECT activeapplications.ID, 1 " +
"FROM activeapplications WHERE activeapplications.Title = " + nameTitle;
DataBase.ExecuteNonQuery(contentCommand);
Dictionary <string, string> filters = Membership_db.GetFilterDictionaryIfIsFullConfiguration();
if (filters.Any())
{
Regex regex;
int idNameTitle = 0;
foreach (KeyValuePair <string, string> filter in filters)
{
regex = new Regex(filter.Value, RegexOptions.IgnoreCase);
if (regex.Matches(nameTitle).Count > 0)
{
idNameTitle = (Convert.ToInt32(ActiveApplication_db.GetIdActivityByName(nameTitle)));
ActiveApplication_db.AddGroupToApplications(new List <int> {
idNameTitle
}, (filter.Key).ToString());
ActiveApplication_db.AddActivityToApplicationWithGroup((filter.Key).ToString(), idNameTitle.ToString());
ExceptionApplication_db.AddExceptionApplication(idNameTitle);
}
}
}
}
private void GetAllConfiguredGroups()
{
numberOfConfiguredGroups.SetContent(Membership_db.GetNumberAllConfiguredGroups());
}
private void LoadNonAssignedApplication()
{
List <ActiveApplication> titlesAllNotAssignedApplication = ActiveApplication_db.GetNonAssignedApplication();
titlesAllNotAssignedApplication.AddRange(ActiveApplication_db.GetNonAssignedApplicationWithGroup());
titlesAllNotAssignedApplication = titlesAllNotAssignedApplication.OrderByDescending(x => x.Date).ToList();
Dictionary <string, string> titleMembership = Membership_db.GetNameGroupsDictionaryIfIsActive(false);
titleMembership["0"] = "Brak przynależności";
for (int i = 0; i < titlesAllNotAssignedApplication.Count; i++)
{
Thread.Sleep(10);
Application.Current.Dispatcher.Invoke(() => {
nonAssignedAppCanvas = new Canvas();
nonAssignedAppCanvas = CanvasCreator.CreateCanvas(nonAssignedApplications, 560, 60,
Color.FromArgb(0, 110, 0, 0), 0, 59 * i);
});
string titleApplication = string.Empty;
titleApplication = (titlesAllNotAssignedApplication[i].Title.Length > 40) ?
titlesAllNotAssignedApplication[i].Title.Remove(40, titlesAllNotAssignedApplication[i].Title.Length - 40) : titlesAllNotAssignedApplication[i].Title;
Application.Current.Dispatcher.Invoke(() =>
{
new MyCircle(nonAssignedAppCanvas, 46, 2, Color.FromArgb(255, 150, 150, 150), 8, 8, 1, true);
MyLabel l = new MyLabel(nonAssignedAppCanvas, "\t" + titleApplication,
560, 60, 14, 0, 0, Color.FromArgb(255, 120, 120, 120), Color.FromArgb(30, 100, 100, 100), 1,
HorizontalAlignment.Left, fontWeight: FontWeights.Bold);
l.ToolTip(titlesAllNotAssignedApplication[i].Title);
new MyLabel(nonAssignedAppCanvas, ActionOnString.GetFirstLetterFromString(titleApplication), 50, 50, 20, 6, 11, Color.FromArgb(255, 240, 240, 240),
Color.FromArgb(0, 100, 100, 100), 0, HorizontalAlignment.Center, fontWeight: FontWeights.ExtraBold);
new MyLabel(nonAssignedAppCanvas, titleMembership[titlesAllNotAssignedApplication[i].IdMembership.ToString()], 300, 30, 12, 60, 30,
Color.FromArgb(255, 120, 120, 120), Color.FromArgb(30, 100, 100, 100), horizontalAlignment: HorizontalAlignment.Left);
new MyLabel(nonAssignedAppCanvas, ActionOnTime.GetNumberDayAgo(titlesAllNotAssignedApplication[i].Date), 100, 30, 13, 466, 0, Color.FromArgb(255, 120, 120, 120),
Color.FromArgb(30, 100, 100, 100), horizontalAlignment: HorizontalAlignment.Left);
new MyLabel(nonAssignedAppCanvas, "(" + (titlesAllNotAssignedApplication.Count - i) + ")", 100, 30, 9, 420, 0, Color.FromArgb(255, 120, 120, 120),
Color.FromArgb(30, 100, 100, 100), horizontalAlignment: HorizontalAlignment.Left);
new MyCircle(nonAssignedAppCanvas, 25, 1, (Color.FromArgb(255, 0, 123, 255)), 525, 28, setFill: true);
Label buttonAddActivity = ButtonCreator.CreateButton(nonAssignedAppCanvas, "+", 25, 34, 20, 525, 28,
Color.FromArgb(255, 255, 255, 255), Color.FromArgb(200, 255, 0, 0), 0, fontWeight: FontWeights.ExtraBold);
buttonAddActivity.Margin = new Thickness(0, -8, 0, 0);
nonAssignedAppCanvas.Name = "ID_" + titlesAllNotAssignedApplication[i].ID;
nonAssignedAppCanvas.Tag = titlesAllNotAssignedApplication[i].IdMembership;
buttonAddActivity.MouseLeftButtonDown += buttonAddActivity_MouseLeftButtonDown;
nonAssignedApplications.Height += 59;
});
}
Application.Current.Dispatcher.Invoke(() =>
{
nonAssignedApplications.Height = ((nonAssignedApplications.Height - 300) < 300) ? 300 : nonAssignedApplications.Height - 299;
});
loadingWindow.notClose = false;
Thread.Sleep(200);
backgroundWorkerLoadingWindow.DoWork -= loadingWindow.Load;
backgroundWorkerLoadingWindow.DoWork += loadingWindow.Close;
backgroundWorkerLoadingWindow.RunWorkerAsync();
}
private void LoadGroups()
{
List <Membership> allGroups = Membership_db.GetAllGroups(new CommandParameters());
Application.Current.Dispatcher.Invoke(() => {
activationGroup = new Image[allGroups.Count];
contentCanvas.Height = 310;
for (int i = 0; i < allGroups.Count; i++)
{
new MyRectangle(contentCanvas, 600, 40, Color.FromArgb((byte)(50 + (i % 2 * 30)), 0, 125, 255), 0, i * 39, 2).SetStroke(Color.FromArgb(255, 30, 39, 93));
new MyLabel(contentCanvas, (i + 1).ToString(), 30, 30, 12, 7, 7 + (i * 39), Color.FromArgb(200, 220, 220, 220), Color.FromArgb(230, 230, 0, 0));
new MyLabel(contentCanvas, allGroups[i].Title, 200, 30, 12, 35, 7 + (i * 39), Color.FromArgb(200, 220, 220, 220), Color.FromArgb(230, 230, 0, 0));
new MyLabel(contentCanvas, allGroups[i].Date.Remove(16), 100, 30, 10, 445, 9 + (i * 39), Color.FromArgb(200, 220, 220, 220), Color.FromArgb(230, 230, 0, 0));
ImageCreator.CreateImage(contentCanvas, 20, 20, 245, 10 + (i * 39), "Pictures/rubbishBin.png");
buttonDeleteGroup = ButtonCreator.CreateButton(contentCanvas, "", 30, 30, 10, 240, 5 + (i * 39), Color.FromArgb(0, 0, 0, 0), Color.FromArgb(0, 0, 0, 0));
buttonDeleteGroup.Name = "ID_" + allGroups[i].ID.ToString();
buttonDeleteGroup.MouseEnter += buttonGroup_MouseEnter;
buttonDeleteGroup.MouseLeave += buttonGroup_MouseLeave;
buttonDeleteGroup.MouseLeftButtonDown += buttonDeleteGroup_MouseLeftButtonDown;
ImageCreator.CreateImage(contentCanvas, 20, 20, 295, 10 + (i * 39), "Pictures/eye.png");
buttonShowApplications = ButtonCreator.CreateButton(contentCanvas, "", 30, 30, 10, 290, 5 + (i * 39), Color.FromArgb(0, 0, 0, 0), Color.FromArgb(0, 0, 0, 0));
buttonShowApplications.Name = "ID_" + allGroups[i].ID.ToString();
buttonShowApplications.MouseEnter += buttonGroup_MouseEnter;
buttonShowApplications.MouseLeave += buttonGroup_MouseLeave;
buttonShowApplications.MouseLeftButtonDown += buttonShowApplications_MouseLeftButtonDown;
string loadPictures = string.Empty;
if (allGroups[i].IfConfiguration)
{
loadPictures = "Pictures/checkSymbol.png";
}
else
{
loadPictures = "Pictures/cancel.png";
}
ImageCreator.CreateImage(contentCanvas, 20, 20, 380, 10 + (i * 39), loadPictures);
if (allGroups[i].IfActive)
{
loadPictures = "Pictures/checkSymbol.png";
}
else
{
loadPictures = "Pictures/cancel.png";
}
activationGroup[i] = ImageCreator.CreateImage(contentCanvas, 20, 20, 565, 10 + (i * 39), loadPictures);
activationGroup[i].Name = "ID_" + allGroups[i].ID.ToString();
buttonActivationGroup = ButtonCreator.CreateButton(contentCanvas, "", 30, 30, 10, 560, 5 + (i * 39), Color.FromArgb(0, 0, 0, 0), Color.FromArgb(0, 0, 0, 0));
buttonActivationGroup.Name = "ID_" + allGroups[i].ID.ToString();
buttonActivationGroup.MouseEnter += buttonGroup_MouseEnter;
buttonActivationGroup.MouseLeave += buttonGroup_MouseLeave;
buttonActivationGroup.MouseLeftButtonDown += buttonActivationGroup_MouseLeftButtonDown;
contentCanvas.Height += 39;
}
});
Application.Current.Dispatcher.Invoke(() =>
{
contentCanvas.Height = ((contentCanvas.Height - 310) < 310) ? 310 : contentCanvas.Height - 309;
});
}
private void GetAllGroups()
{
numberGroups.SetContent(Membership_db.GetNumberAllGroups());
}
