/// <summary>
/// Initializes a new instance of the <see cref="UserMap"/> class.
/// </summary>
public UserMap()
{
this.Map(x => x.FirstName).Length(100).Not.Nullable();
this.Map(x => x.LastName).Length(100).Nullable();
this.Map(x => x.Password).Length(100).Nullable();
this.Map(x => x.Email).Nullable();
this.Map(x => x.SessionToken).Nullable();
this.Map(x => x.SessionTokenExpirationDate).Nullable();
this.Map(x => x.DateCreated).Not.Nullable();
this.Map(x => x.DateModified).Not.Nullable();
this.Map(x => x.Status).Default(1.ToString());
this.References(x => x.Logo).Nullable().LazyLoad().Column("logoId");
this.References(x => x.ModifiedBy).Nullable().LazyLoad().Column(Inflector.Uncapitalize(Lambda.Property <User>(x => x.ModifiedBy)));
this.HasMany(x => x.Activations).Cascade.Delete().Inverse().ExtraLazyLoad();
this.HasMany(x => x.ACSessions).Cascade.Delete().Inverse().ExtraLazyLoad();
this.HasMany(x => x.LoginHistory).Cascade.Delete().Inverse().ExtraLazyLoad();
this.HasMany(x => x.Files).Cascade.Delete().Inverse().ExtraLazyLoad().KeyColumn("createdBy");
this.HasMany(x => x.DistractorsCreated).ExtraLazyLoad().KeyColumn("createdBy");
this.HasMany(x => x.DistractorsModified).ExtraLazyLoad().KeyColumn("modifiedBy");
this.HasMany(x => x.ThemeAttributesCreated).ExtraLazyLoad().KeyColumn("createdBy");
this.HasMany(x => x.ThemeAttributesModified).ExtraLazyLoad().KeyColumn("modifiedBy");
this.HasMany(x => x.SubModuleCategories).Cascade.Delete().Inverse().ExtraLazyLoad().KeyColumn("userId");
this.HasMany(x => x.SubModuleCategoriesModified).ExtraLazyLoad().KeyColumn("modifiedBy");
this.References(x => x.UserRole).Not.Nullable();
this.References(x => x.Company).Not.Nullable().LazyLoad();
this.References(x => x.Language).Not.Nullable().LazyLoad();
this.References(x => x.TimeZone).Not.Nullable().LazyLoad();
this.Map(x => x.IsUnsubscribed).Nullable();
}
private bool UpdateFileWithStatus(string connectionString, Guid id, UploadFileStatus status, ILogger log)
{
var typeName = typeof(Domain.Entities.File).Name;
string updateStatusCommand = string.Format("update [{0}] set {1} = @status where {2} = @id", typeName,
Inflector.Uncapitalize(Lambda.Property <Domain.Entities.File>(x => x.UploadFileStatus)),
Inflector.Uncapitalize(typeName + Lambda.Property <Domain.Entities.File>(x => x.Id)));
using (var con = new SqlConnection(connectionString))
{
try
{
con.Open();
using (var cmd = new SqlCommand(updateStatusCommand, con))
{
cmd.Parameters.AddWithValue("@status", (int)status);
cmd.Parameters.AddWithValue("@id", id);
int effected = cmd.ExecuteNonQuery();
return(effected == 1);
}
}
catch (Exception ex)
{
try
{
log.Error("Converter. Failed to update status of file: id=" + id + ", status=" + (int)status, ex);
}
// ReSharper disable once EmptyGeneralCatchClause
catch
{
}
}
}
return(false);
}
public void Uncapitalize()
{
foreach (var pair in TestData)
{
Assert.AreEqual(Inflector.Uncapitalize(pair.Key), pair.Value);
}
}
/// <summary>
/// The get key name.
/// </summary>
/// <param name="property">
/// The property.
/// </param>
/// <param name="type">
/// The type.
/// </param>
/// <returns>
/// The <see cref="string"/>.
/// </returns>
protected override string GetKeyName(Member property, Type type)
{
return(property != null && this.exceptions.Contains(property.Name)
? Inflector.Uncapitalize(property.Name)
: string.Format(
CultureInfo.InvariantCulture,
FluentConfiguration.ForeignKeyNameTemplate,
Inflector.Uncapitalize(type.Name)));
}
/// <summary>
/// Initializes a new instance of the <see cref="ThemeMap"/> class.
/// </summary>
public ThemeMap()
{
this.Map(x => x.ThemeName).Length(50).Not.Nullable();
this.Map(x => x.DateCreated).Not.Nullable();
this.Map(x => x.DateModified).Not.Nullable();
this.Map(x => x.IsActive).Nullable();
this.References(x => x.CreatedBy).Nullable().LazyLoad().Column(Inflector.Uncapitalize(Lambda.Property <Theme>(x => x.CreatedBy)));
this.References(x => x.ModifiedBy).Nullable().LazyLoad().Column(Inflector.Uncapitalize(Lambda.Property <Theme>(x => x.ModifiedBy)));
}
/// <summary>
/// Initializes a new instance of the <see cref="CompanyMap"/> class.
/// </summary>
public CompanyMap()
{
this.Map(x => x.CompanyName).Length(50).Not.Nullable();
this.Map(x => x.Status).Not.Nullable();
this.Map(x => x.DateCreated).Not.Nullable();
this.Map(x => x.UseEventMapping).Not.Nullable();
this.Map(x => x.DateModified).Not.Nullable();
this.References(x => x.Address).Nullable().Cascade.Delete();
this.References(x => x.Theme).Nullable().Cascade.Delete();
this.References(x => x.PrimaryContact).Nullable().Column(Inflector.Uncapitalize(Lambda.Property <Company>(x => x.PrimaryContact)) + "Id");
this.HasMany(x => x.Users).Cascade.Delete().Inverse();
this.HasMany(x => x.Licenses).Cascade.Delete().Inverse();
}
/// <summary>
/// The apply.
/// </summary>
/// <param name="instance">
/// The instance.
/// </param>
public void Apply(IPropertyInstance instance)
{
const string NamePattern = "Name";
bool isEntityTypeName = !Exceptions.Contains(instance.Property.Name) &&
instance.Property.Name.EndsWith(NamePattern) &&
instance.Property.Name == instance.EntityType.Name + NamePattern;
string column = string.Format(
CultureInfo.InvariantCulture,
FluentConfiguration.ColumnNameTemplate,
Inflector.Uncapitalize(isEntityTypeName ? instance.EntityType.Name : instance.Property.Name));
instance.Column(column);
}
/// <summary>
/// Initializes a new instance of the <see cref="SubModuleCategoryMap"/> class.
/// </summary>
public SubModuleCategoryMap()
{
this.Map(x => x.CategoryName).Length(255).Nullable();
this.Map(x => x.IsActive).Nullable();
this.Map(x => x.DateModified).Not.Nullable();
this.Map(x => x.LmsCourseId).Nullable();
this.Map(x => x.CompanyLmsId).Nullable();
this.HasMany(x => x.SubModuleItems).ExtraLazyLoad().Cascade.Delete().Inverse();
this.References(x => x.User);
this.References(x => x.SubModule);
this.References(x => x.ModifiedBy).Nullable().LazyLoad().Column(Inflector.Uncapitalize(Lambda.Property <SubModuleCategory>(x => x.ModifiedBy)));
}
/// <summary>
/// Initializes a new instance of the <see cref="CompanyLicenseMap"/> class.
/// </summary>
public CompanyLicenseMap()
{
this.Map(x => x.Domain).Nullable();
this.Map(x => x.LicenseStatus).CustomType <CompanyLicenseStatus>().Not.Nullable();
this.Map(x => x.ExpiryDate);
this.Map(x => x.LicenseNumber).Length(50).Not.Nullable();
this.Map(x => x.TotalLicensesCount).Not.Nullable().Default("(1)");
this.Map(x => x.TotalParticipantsCount).Not.Nullable().Default("(100)");
this.Map(x => x.DateStart).Not.Nullable();
this.Map(x => x.DateCreated).Not.Nullable();
this.Map(x => x.DateModified).Not.Nullable();
this.References(x => x.Company).Nullable();
this.References(x => x.CreatedBy).Nullable().LazyLoad().Column(Inflector.Uncapitalize(Lambda.Property <CompanyLicense>(x => x.CreatedBy)));
this.References(x => x.ModifiedBy).Nullable().LazyLoad().Column(Inflector.Uncapitalize(Lambda.Property <CompanyLicense>(x => x.ModifiedBy)));
this.Map(x => x.HasApi).Not.Nullable();
}
/// <summary>
/// Initializes a new instance of the <see cref="ThemeAttributeMap"/> class.
/// </summary>
public ThemeAttributeMap()
{
this.References(x => x.Theme).Not.Nullable();
this.Map(x => x.ThemeOrder).Nullable();
this.Map(x => x.BgColor).Length(6).Nullable();
this.Map(x => x.TitleColor).Length(6).Nullable();
this.Map(x => x.CategoryColor).Length(6).Nullable();
this.Map(x => x.SelectionColor).Length(6).Nullable();
this.Map(x => x.QuestionHintColor).Length(6).Nullable();
this.Map(x => x.QuestionTextColor).Length(6).Nullable();
this.Map(x => x.QuestionInstructionColor).Length(6).Nullable();
this.Map(x => x.ResponseCorrectColor).Length(6).Nullable();
this.Map(x => x.ResponseIncorrectColor).Length(6).Nullable();
this.Map(x => x.DistractorTextColor).Length(6).Nullable();
this.Map(x => x.DateCreated).Not.Nullable();
this.Map(x => x.DateModified).Not.Nullable();
this.Map(x => x.IsActive).Nullable();
this.References(x => x.CreatedBy).Nullable().LazyLoad().Column(Inflector.Uncapitalize(Lambda.Property <Theme>(x => x.CreatedBy)));
this.References(x => x.ModifiedBy).Nullable().LazyLoad().Column(Inflector.Uncapitalize(Lambda.Property <Theme>(x => x.ModifiedBy)));
}
/// <summary>
/// Initializes a new instance of the <see cref="SubModuleItemMap"/> class.
/// </summary>
public SubModuleItemMap()
{
this.Map(x => x.IsActive).Nullable();
this.Map(x => x.IsShared).Nullable();
this.Map(x => x.DateModified).Not.Nullable();
this.Map(x => x.DateCreated).Not.Nullable();
this.HasMany(x => x.AppletItems).ExtraLazyLoad().Cascade.Delete().Inverse();
this.HasMany(x => x.Questions).ExtraLazyLoad().Cascade.Delete().Inverse();
this.HasMany(x => x.Quizes).LazyLoad().Cascade.Delete().Inverse();
this.HasMany(x => x.Surveys).LazyLoad().Cascade.Delete().Inverse();
this.HasMany(x => x.Tests).ExtraLazyLoad().Cascade.Delete().Inverse();
this.HasMany(x => x.SNProfiles).ExtraLazyLoad().Cascade.Delete().Inverse();
this.HasMany(x => x.ACSessions).ExtraLazyLoad().Cascade.Delete().Inverse();
this.HasMany(x => x.Themes).Cascade.Delete().Inverse();
this.References(x => x.SubModuleCategory);
this.References(x => x.ModifiedBy).Nullable().LazyLoad().Column(Inflector.Uncapitalize(Lambda.Property <SubModuleItem>(x => x.ModifiedBy)));
this.References(x => x.CreatedBy).Nullable().LazyLoad().Column(Inflector.Uncapitalize(Lambda.Property <SubModuleItem>(x => x.CreatedBy)));
}
/// <summary>
/// Initializes a new instance of the <see cref="DistractorMap"/> class.
/// </summary>
public DistractorMap()
{
this.Map(x => x.DistractorName).Not.Nullable();
this.Map(x => x.DistractorOrder).Not.Nullable();
this.Map(x => x.Score).Length(50).Nullable();
this.Map(x => x.IsCorrect).Nullable();
this.Map(x => x.IsActive).Nullable();
this.Map(x => x.DistractorType).Nullable();
this.Map(x => x.DateCreated).Not.Nullable();
this.Map(x => x.DateModified).Not.Nullable();
this.Map(x => x.LmsAnswer).Length(100).Nullable();
this.Map(x => x.LmsAnswerId).Nullable();
this.Map(x => x.LmsProviderId).Nullable();
this.References(x => x.Question).Nullable();
this.References(x => x.Image).Column("imageId").Nullable();
this.References(x => x.LeftImage).Column("leftImageId").Nullable();
this.References(x => x.RightImage).Column("rightImageId").Nullable();
this.References(x => x.CreatedBy).Nullable().LazyLoad().Column(Inflector.Uncapitalize(Lambda.Property <Distractor>(x => x.CreatedBy)));
this.References(x => x.ModifiedBy).Nullable().LazyLoad().Column(Inflector.Uncapitalize(Lambda.Property <Distractor>(x => x.ModifiedBy)));
}
/// <summary>
/// Initializes a new instance of the <see cref="QuestionMap"/> class.
/// </summary>
public QuestionMap()
{
this.Map(x => x.QuestionName).Length(2000).Not.Nullable();
this.Map(x => x.HtmlText).Length(2000).Nullable();
this.Map(x => x.QuestionOrder).Not.Nullable();
this.Map(x => x.Instruction).Nullable();
this.Map(x => x.CorrectMessage).Nullable();
this.Map(x => x.CorrectReference).Length(2000).Nullable();
this.Map(x => x.IncorrectMessage).Nullable();
this.Map(x => x.Hint).Nullable();
this.Map(x => x.IsActive).Nullable();
this.Map(x => x.ScoreValue).Not.Nullable().Default(0.ToString(CultureInfo.InvariantCulture));
this.Map(x => x.DateModified).Not.Nullable();
this.Map(x => x.DateCreated).Not.Nullable();
this.Map(x => x.LmsQuestionId).Nullable();
this.Map(x => x.RandomizeAnswers).Nullable();
this.Map(x => x.Rows).Nullable();
this.Map(x => x.LmsProviderId).Nullable().Column("lmsProviderId");
this.HasMany(x => x.QuizQuestionResults).ExtraLazyLoad().Cascade.DeleteOrphan().Inverse();
this.HasMany(x => x.SurveyQuestionResults).ExtraLazyLoad().Cascade.DeleteOrphan().Inverse();
this.HasMany(x => x.TestQuestionResults).ExtraLazyLoad().Cascade.DeleteOrphan().Inverse();
this.HasMany(x => x.Distractors).ExtraLazyLoad().Cascade.DeleteOrphan().Inverse();
this.HasMany(x => x.LikertQuestions).ExtraLazyLoad().Cascade.DeleteOrphan().Inverse();
this.HasMany(x => x.RateQuestions).ExtraLazyLoad().Cascade.DeleteOrphan().Inverse();
this.HasMany(x => x.TrueFalseQuestions).ExtraLazyLoad().Cascade.DeleteOrphan().Inverse();
this.HasMany(x => x.WeightBucketQuestions).ExtraLazyLoad().Cascade.DeleteOrphan().Inverse();
this.HasMany(x => x.OpenAnswerQuestions).ExtraLazyLoad().Cascade.DeleteOrphan().Inverse();
this.HasMany(x => x.SingleMultipleChoiceQuestions).ExtraLazyLoad().Cascade.DeleteOrphan().Inverse();
this.References(x => x.QuestionType);
this.References(x => x.SubModuleItem);
this.References(x => x.Image).Column("imageId");
this.References(x => x.ModifiedBy).Nullable().LazyLoad().Column(Inflector.Uncapitalize(Lambda.Property <Question>(x => x.ModifiedBy)));
this.References(x => x.CreatedBy).Nullable().LazyLoad().Column(Inflector.Uncapitalize(Lambda.Property <Question>(x => x.CreatedBy)));
}
/// <summary>
/// The apply.
/// </summary>
/// <param name="instance">
/// The instance.
/// </param>
public void Apply(IIdentityInstance instance)
{
instance.Column(Inflector.Uncapitalize(instance.EntityType.Name) + "Id");
}
