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 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);
}
}
}
}
