public static string CheckParameters(CommandParameters parameters)
{
string query = string.Empty;
if (parameters.ID.Any())
{
query += SqlValidator.AND + ColumnNames.ID + SqlValidator.Validate_IN(parameters.ID);
}
if (parameters.Name.Any())
{
query += SqlValidator.AND + ColumnNames.Name + SqlValidator.Validate_IN(parameters.Name);
}
if (!string.IsNullOrEmpty(parameters.ActivityTimeFrom) && !string.IsNullOrEmpty(parameters.ActivityTimeTo))
{
query += SqlValidator.AND + SqlValidator.Validate_BETWEEN(ColumnNames.ActivityTime, parameters.ActivityTimeFrom, parameters.ActivityTimeTo);
}
if (!string.IsNullOrEmpty(parameters.ActivityTimeFrom) && string.IsNullOrEmpty(parameters.ActivityTimeTo))
{
query += SqlValidator.AND + ColumnNames.ActivityTime + SqlValidator.FromValue + parameters.ActivityTimeFrom;
}
if (string.IsNullOrEmpty(parameters.ActivityTimeFrom) && !string.IsNullOrEmpty(parameters.ActivityTimeTo))
{
query += SqlValidator.AND + ColumnNames.ActivityTime + SqlValidator.ToValue + parameters.ActivityTimeTo;
}
if (!string.IsNullOrEmpty(parameters.StartDate) && !string.IsNullOrEmpty(parameters.EndDate))
{
query += SqlValidator.AND + SqlValidator.Validate_BETWEEN(ColumnNames.Date, parameters.StartDate, parameters.EndDate);
}
if (!string.IsNullOrEmpty(parameters.StartDate) && string.IsNullOrEmpty(parameters.EndDate))
{
query += SqlValidator.AND + ColumnNames.Date + SqlValidator.FromValue + SqlValidator.Validate(parameters.StartDate);
}
if (string.IsNullOrEmpty(parameters.StartDate) && !string.IsNullOrEmpty(parameters.EndDate))
{
query += SqlValidator.AND + ColumnNames.Date + SqlValidator.ToValue + SqlValidator.Validate(parameters.EndDate);
}
if (!string.IsNullOrEmpty(parameters.IfActive))
{
query += SqlValidator.AND + ColumnNames.IfActive + SqlValidator.ToValue + parameters.IfActive;
}
if (!string.IsNullOrEmpty(parameters.IfConfiguration))
{
query += SqlValidator.AND + ColumnNames.IfConfiguration + SqlValidator.ToValue + parameters.IfConfiguration;
}
if (!string.IsNullOrEmpty(parameters.IfActiveConfiguration))
{
query += SqlValidator.AND + ColumnNames.IfActiveConfiguration + SqlValidator.ToValue + parameters.IfActiveConfiguration;
}
if (parameters.IdMembership > 0)
{
query += SqlValidator.AND + ColumnNames.IdMembership + SqlValidator.ToValue + parameters.IdMembership;
}
if (parameters.IdMembership == -1)
{
query += SqlValidator.AND + ColumnNames.IdMembership + SqlValidator.ISNULL;
}
if (parameters.IdNameActivity > 0)
{
query += SqlValidator.AND + ColumnNames.IdNameActivity + SqlValidator.ToValue + (int)parameters.IdNameActivity;
}
return(query);
}
public static bool AddGroupToApplications(List <int> idApplications, string idGroup)
{
string contentCommand = "UPDATE activeapplications SET IdMembership = " + idGroup + ", AutoGrouping = 1 WHERE Id " + SqlValidator.Validate_IN(idApplications);
return(DataBase.ExecuteNonQuery(contentCommand));
}