public void CtorParametersAreInitialized(IFixture fixture, Name name)
{
fixture.Inject <ParameterMeta>(ParameterMeta.Create <IParameter>(name));
var assertion = new ConstructorInitializedMemberAssertion(fixture);
assertion.Verify(typeof(CmdApplicationMeta));
}
public void NullForCtorArgumentsThrowsException(IFixture fixture, Name name)
{
fixture.Inject <ParameterMeta>(ParameterMeta.Create <IParameter>(name));
var assertion = new GuardClauseAssertion(fixture);
assertion.Verify(typeof(CmdApplicationMeta).GetConstructors());
}
public ActionResult Index(string path)
{
string query = this.Request?.Url?.Query.Or("");
string sourcePath = "/dashboard/reports/source/" + path + query;
var locator = new ReportLocator();
path = locator.GetPathToDisk(this.Tenant, path);
var parameters = ParameterHelper.GetParameters(this.Request?.QueryString);
var parser = new ReportParser(path, this.Tenant, parameters);
var report = parser.Get();
var dbParams = new List <DataSourceParameter>();
if (report.DataSources != null)
{
foreach (var dataSource in report.DataSources)
{
foreach (var parameter in dataSource.Parameters)
{
if (dbParams.Any(x => x.Name.ToLower() == parameter.Name.Replace("@", "").ToLower()))
{
continue;
}
if (parameter.HasMetaValue)
{
continue;
}
parameter.Name = parameter.Name.Replace("@", "");
var fromQueryString = report.Parameters.FirstOrDefault(x => x.Name.ToLower().Equals(parameter.Name.ToLower()));
if (fromQueryString != null)
{
parameter.DefaultValue = DataSourceParameterHelper.CastValue(fromQueryString.Value, parameter.Type);
}
if (string.IsNullOrWhiteSpace(parameter.FieldLabel))
{
parameter.FieldLabel = parameter.Name;
}
dbParams.Add(parameter);
}
}
}
var model = new ParameterMeta
{
ReportSourcePath = sourcePath,
Parameters = dbParams,
ReportTitle = report.Title
};
return(this.View("~/Areas/Frapid.Reports/Views/Index.cshtml", model));
}
public static ParameterMeta GetDefinition(string path, string query, string tenant, HttpRequestBase request)
{
string sourcePath = "/dashboard/reports/source/" + path + query;
var locator = new ReportLocator();
path = locator.GetPathToDisk(tenant, path);
var parameters = ParameterHelper.GetParameters(request?.QueryString);
var parser = new ReportParser(path, tenant, parameters);
var report = parser.Get();
var dbParams = new List <DataSourceParameter>();
if (report.DataSources != null)
{
foreach (var dataSource in report.DataSources)
{
foreach (var parameter in dataSource.Parameters)
{
if (dbParams.Any(x => x.Name.ToLower() == parameter.Name.Replace("@", "").ToLower()))
{
continue;
}
if (parameter.HasMetaValue)
{
continue;
}
parameter.Name = parameter.Name.Replace("@", "");
var fromQueryString = report.Parameters.FirstOrDefault(x => x.Name.ToLower().Equals(parameter.Name.ToLower()));
if (fromQueryString != null)
{
parameter.DefaultValue = DataSourceParameterHelper.CastValue(fromQueryString.Value, parameter.Type);
}
if (string.IsNullOrWhiteSpace(parameter.FieldLabel))
{
parameter.FieldLabel = parameter.Name;
}
dbParams.Add(parameter);
}
}
}
var model = new ParameterMeta
{
ReportSourcePath = sourcePath,
Parameters = dbParams,
ReportTitle = report.Title
};
return(model);
}
private CmdApplicationMeta GetApplicationConfigurationMeta()
{
return(new CmdApplicationMeta(
(Name)"FriendlyName",
(Name)"ApplicationName",
new List <ParameterMeta>()
{
ParameterMeta.Create <NameOnlyParameter>((Name)"aParameter"),
ParameterMeta.Create <NameValueParameter>((Name)"anotherParameter")
}));
}
ParameterMeta GetParameterMeta(ParameterInfo param)
{
var paramMeta = new ParameterMeta();
paramMeta.ParameterName = param.Name;
paramMeta.ParameterType = param.ParameterType.FullName;
if (param.HasDefaultValue)
{
paramMeta.DefaultValue = param.DefaultValue == null ? null : param.DefaultValue.ToString();
}
return(paramMeta);
}
public CommandBuilder AddParameter(string name, object value, ParameterMeta meta = null)
{
if (meta == null)
{
meta = new ParameterMeta
{
DbType = value?.GetType().GetDbType() ?? DbType.Object
};
}
return AddParameter(new CommandParameter
{
Name = name,
Value = value,
ParameterMeta = meta
});
}
public void CreateWithInvalidParameterMetaTypeThrowsException(
Name name,
Name applicationName,
Name parameterName,
IChannel <SaveCmdApplicationConfigurationCommand> channel,
CmdApplicationConfigurationViewModelFactory sut)
{
var parameter = new Mock <IParameter>();
var meta = new CmdApplicationMeta(
name,
applicationName,
new List <ParameterMeta>()
{
ParameterMeta.Create <IParameter>(parameterName)
});
Assert.Throws <ArgumentException>(() => sut.Create(meta));
}
protected FunctionMeta BuildFunction(SQLUserDefinedFunction udfDef, ref ArrayList grantList, ref ArrayList denyList)
{
if (ValidateVersion(udfDef) == DDLActionEnum.NONE) // not in range!
{
return(null);
}
// Always treated as rebuild or create...
// FunctionMeta funcTmp = new FunctionMeta( udfDef.FunctionName, udfDef.ReturnValue.ToString() );
FunctionMeta funcTmp = new FunctionMeta(udfDef.FunctionName, DataTypeEnum.NUMERIC, _context);
//funcTmp.DDLBodyText = udfDef..ToString();
foreach (SQLStoredProcedureParameter param in udfDef.Parameters)
{
ParameterMeta pramMeta = new ParameterMeta(param.Name, param.DataType, param.ParameterDirection, _dtMap);
pramMeta.DataType.StringLength = param.StringLength;
funcTmp.GetParameterList().Add(pramMeta);
}
SQLRoleAssignmentCollection roles = udfDef.Roles;
foreach (SQLRoleAssignment roleAssign in roles)
{
GranteeMeta roleGrantee = new GranteeMeta(udfDef.FunctionName);
roleGrantee.GranteeList.Add(roleAssign.RoleName);
roleGrantee.ObjPermissions.Add(roleAssign.GrantAssignments);
grantList.Add(roleGrantee);
GranteeMeta roleDenied = new GranteeMeta(udfDef.FunctionName);
roleDenied.GranteeList.Add(roleAssign.RoleName);
roleDenied.ObjPermissions.Add(roleAssign.DenyAssignments);
denyList.Add(roleDenied);
}
return(funcTmp);
}
protected StoredProcMeta BuildStoredProc(SQLStoredProcedure spDef, ref ArrayList grantList, ref ArrayList denyList)
{
if (ValidateVersion(spDef) == DDLActionEnum.NONE) // not in range!
{
return(null);
}
// Always treated as rebuild or create...
StoredProcMeta spTmp = new StoredProcMeta(spDef.ProcName, _context);
spTmp.DDLBodyText = spDef.ProcedureText.ToString();
foreach (SQLStoredProcedureParameter param in spDef.Parameters)
{
ParameterMeta pramMeta = new ParameterMeta(param.Name, param.DataType, param.ParameterDirection, _dtMap);
pramMeta.DataType.StringLength = param.StringLength;
spTmp.GetParameterList().Add(pramMeta);
}
SQLRoleAssignmentCollection roles = spDef.Roles;
foreach (SQLRoleAssignment roleAssign in roles)
{
GranteeMeta roleGrantee = new GranteeMeta(spDef.ProcName);
roleGrantee.GranteeList.Add(roleAssign.RoleName);
roleGrantee.ObjPermissions.Add(roleAssign.GrantAssignments);
grantList.Add(roleGrantee);
GranteeMeta roleDenied = new GranteeMeta(spDef.ProcName);
roleDenied.GranteeList.Add(roleAssign.RoleName);
roleDenied.ObjPermissions.Add(roleAssign.DenyAssignments);
denyList.Add(roleDenied);
}
return(spTmp);
}
public void CtorWithTypeIParameterCreatesSut(Name aName, Name aDisplayName)
{
var sut = new ParameterMeta(aName, typeof(ParameterTest), aDisplayName);
Assert.NotNull(sut);
}
public void SutWithDisplayNameReturnsName(Name aName, Name aDisplayName)
{
var sut = ParameterMeta.Create <ParameterTest>(aName, aDisplayName);
Assert.Equal(aDisplayName, sut.DisplayName);
}
public void CtorWithTypeIParameterCreatesSut(Name aName, Name aDisplayName)
{
var sut = new ParameterMeta(aName, typeof(ParameterTest), aDisplayName);
Assert.NotNull(sut);
}
public void SutWithDefaultDisplayNameReturnsEmptyName(Name aName)
{
var sut = ParameterMeta.Create <ParameterTest>(aName);
Assert.Equal(Name.EmptyName, sut.DisplayName);
}
public void ParameterTypeExposesTheCorrectType(Name name)
{
var sut = ParameterMeta.Create <ParameterTest>(name);
Assert.Equal(typeof(ParameterTest), sut.ParameterType);
}
public void NullForCtorArgumentsThrowsException(IFixture fixture)
{
Assert.Throws <ArgumentNullException>(() => ParameterMeta.Create <IParameter>(null));
}
