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