public static ModelBuilder BuildTruck(this ModelBuilder modelBuilder) { var builder = BaseModelBuilder.Build <Truck>(modelBuilder, SchemaName); builder.HasKey(m => new { m.Id }); builder.Property(p => p.Id) .HasMaxLength(36) .HasConversion <Guid>() .IsRequired(); builder.Property(p => p.TruckType) .IsRequired(); builder.Property(p => p.ModelYear) .IsRequired(); builder.Property(p => p.FabricationYear) .IsRequired(); builder.Property(p => p.Name) .HasMaxLength(255); builder.Property(p => p.Plate) .HasMaxLength(10); return(modelBuilder); }
protected override void OnModelCreating(ModelBuilder builder) { // base model building BaseModelBuilder.BuildCommon <UserProfile>(builder); BaseModelBuilder.BuildCommon <UserPermission>(builder); BaseModelBuilder.BuildCommon <MyTask>(builder); BaseModelBuilder.BuildCommon <Notification>(builder); BaseModelBuilder.BuildCommon <NotificationTiming>(builder); BaseModelBuilder.BuildCommon <NotificationType>(builder); BaseModelBuilder.BuildCommon <NotificationLocation>(builder); BaseModelBuilder.BuildCommon <MyTaskStatus>(builder); // custom model building UserProfileModelBuilder.Build(builder); TasksModelBuilder.Build(builder); }
public override string CreateQuery(TableModel table) { var sql = new StringBuilder(); var alterSql = new StringBuilder(); var baseModelFields = BaseModelBuilder.CreateBaseModel(table.EntityType); sql.AppendFormat("CREATE TABLE [{1}].[{0}] (", table.Name, table.EntityType); foreach (var item in baseModelFields) { sql.AppendFormat(" [{0}]", item.Name); switch (item.DataType.Trim()) { case "uniqueidentifier": sql.Append(" uniqueidentifier"); break; case "datetime": sql.Append(" datetime"); break; case "nvarchar": sql.AppendFormat(" nvarchar({0})", item.MaxLenght); break; case "bit": sql.Append(" bit"); break; default: sql.AppendFormat(" nvarchar({0})", item.MaxLenght); break; } if (!item.AllowNull) { sql.Append(" NOT NULL"); } sql.Append(","); } sql.AppendFormat(" CONSTRAINT PK_{0} PRIMARY KEY ({1})", table.Name, "Id"); sql.AppendFormat("{0})", alterSql); return(sql.ToString()); }
public JsonResult GetSpecialSkillsWithChart() { return(Json(BaseModelBuilder.GetSpecialSkillsWithChart(BaseService))); }
public JsonResult GetExpertise() { return(Json(BaseModelBuilder.GetAllExpertise(BaseService))); }
public JsonResult GetAllPublications() { return(Json(BaseModelBuilder.GetAllPublications(BaseService))); }
public JsonResult GetEducationHistory() { return(Json(BaseModelBuilder.GetEducationHistory(BaseService))); }
public JsonResult GetWorkHistory() { return(Json(BaseModelBuilder.GetWorkHistory(BaseService))); }
public JsonResult GetGeneralSkills() { return(Json(BaseModelBuilder.GetGeneralSkills(BaseService))); }
public JsonResult GetMottos() { return(Json(BaseModelBuilder.GetMottos(BaseService))); }
public JsonResult GetSocialLinksForSideBar() { return(Json(BaseModelBuilder.GetSocialLinksForSidebar(BaseService))); }
public JsonResult GetAllAddresses() { return(Json(BaseModelBuilder.GetAddresses(BaseService))); }
public JsonResult GetAllEmails() { return(Json(BaseModelBuilder.GetEmails(BaseService))); }
public JsonResult GetAllPhones() { return(Json(BaseModelBuilder.GetPhones(BaseService))); }
public static EntityTypeBuilder <T> Build <T>(ModelBuilder modelBuilder) where T : class, new() { return(BaseModelBuilder.Build <T>(modelBuilder, SchemaName)); }