private void buttonAcceptAddException_MouseLeftButtonDown(object sender, MouseButtonEventArgs e)
{
if (idAddExceptionApplication > 0 || idAddExceptionApplication == -1)
{
if (!string.IsNullOrEmpty(nameApplicationToException.Text) && !nameApplicationToException.Text.Equals(defaultContentnameApplicationToException))
{
if (idAddExceptionApplication > 0)
{
if (!ExceptionApplication_db.CheckIfExistApplication(idAddExceptionApplication))
{
ExceptionApplication_db.AddExceptionApplication(idAddExceptionApplication);
}
}
else
{
foreach (string application in idAddExceptionApplicationList)
{
if (!ExceptionApplication_db.CheckIfExistApplication(Convert.ToInt32(application)))
{
ExceptionApplication_db.AddExceptionApplication(Convert.ToInt32(application));
}
}
}
SetDefaultDesignForException();
LoadExceptionApplication();
}
}
else
{
if (FindApplication())
{
buttonAcceptAddException.Content = "Dodaj";
}
}
}
private void deleteExceptionButton_MouseLeftButtonDown(object sender, MouseButtonEventArgs e)
{
if ((sender as Label).Name.Contains("M"))
{
idAddExceptionApplication = Convert.ToInt32((sender as Label).Name.Replace("ID_", string.Empty).Replace("M", string.Empty));
idAddExceptionApplicationList = ActiveApplication_db.GetNameApplicationDictionaryWithGroup(idAddExceptionApplication).Select(x => x.Key).ToList();
foreach (string element in idAddExceptionApplicationList)
{
ExceptionApplication_db.DeleteExceptionApplication(element);
}
}
else
{
idAddExceptionApplication = Convert.ToInt32((sender as Label).Name.Replace("ID_", string.Empty));
ExceptionApplication_db.DeleteExceptionApplication(idAddExceptionApplication.ToString());
}
idAddExceptionApplication = 0;
idAddExceptionApplicationList.Clear();
LoadExceptionApplication();
}
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 LoadExceptionApplication()
{
exceptionApplicationCanvas.Children.Clear();
exceptionApplicationCanvas.Height = 220;
int nextIndex = 0;
Dictionary <string, string> nameApplicationDictionary = ExceptionApplication_db.GetNameApplicationDictionary();
Dictionary <string, string> temp = ExceptionApplication_db.GetNameApplicationWitGroupDictionary();
foreach (var element in temp)
{
nameApplicationDictionary.Add(element.Key + "M", element.Value);
}
foreach (KeyValuePair <string, string> name in nameApplicationDictionary)
{
Label application = ButtonCreator.CreateButton(exceptionApplicationCanvas, (nextIndex + 1) + ". " + (name.Value + " ").Remove((name.Value.Length > 25) ? 25 : name.Value.Length), 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((byte)(50 + (nextIndex % 2 * 30)), 0, 125, 255));
application.MouseEnter += buttonContent_MouseEnter;
application.MouseLeave += buttonContent_MouseLeave;
Label deleteButton = ButtonCreator.CreateButton(exceptionApplicationCanvas, "X", 22, 22, 8, 244, 3 + (nextIndex * 32),
Color.FromArgb(255, 255, 255, 255), Color.FromArgb(255, 155, 155, 155), 1);
deleteButton.Background = new SolidColorBrush(Color.FromArgb(100, 250, 0, 0));
deleteButton.Name = "ID_" + name.Key;
deleteButton.MouseEnter += deleteButton_MouseEnter;
deleteButton.MouseLeave += deleteButton_MouseLeave;
deleteButton.MouseLeftButtonDown += deleteExceptionButton_MouseLeftButtonDown;
exceptionApplicationCanvas.Height += 32;
nextIndex++;
}
exceptionApplicationCanvas.Height = ((exceptionApplicationCanvas.Height - 220) < 220) ? 220 : exceptionApplicationCanvas.Height - 219;
idAddExceptionApplication = 0;
}