private static void NotProceedReason(PanelMasterMVC5SeparateDbContext context)
{
var data = new List <NotProceedReason>();
data.AddRange(GetNotProceedReason());
context.NotProceedReason.AddOrUpdate(data.ToArray());
}
private static void SignOnPlans(PanelMasterMVC5SeparateDbContext context)
{
var data = new List <SignonPlans>();
data.AddRange(GetPlans());
context.SignonPlan.AddOrUpdate(data.ToArray());
}
//Master Data entry : QuoteCategories
private static void AddQuoteCategories(PanelMasterMVC5SeparateDbContext context)
{
var data = new List <QuoteCategories>();
data.AddRange(GetQuoteCategories());
context.QuoteCategories.AddOrUpdate(data.ToArray());
}
//Master Data entry : RepairTypes
private static void AddRepairTypes(PanelMasterMVC5SeparateDbContext context)
{
var data = new List <RepairTypes>();
data.AddRange(GetRepairTypes());
context.RepairTypes.AddOrUpdate(data.ToArray());
}
private static void CreateDefaultTowOperator(PanelMasterMVC5SeparateDbContext _context)
{
var data = new List <TowOperator>();
data.AddRange(GetDefaultTowOperators());
_context.TowOperators.AddOrUpdate(data.ToArray());
_context.SaveChanges();
}
private static void CreateDefaultVehicleModels(PanelMasterMVC5SeparateDbContext _context)
{
var data = new List <VehicleModels>();
data.AddRange(GetDefaultVehicleModelss());
_context.VehicleModel.AddOrUpdate(data.ToArray());
_context.SaveChanges();
}
private static void AddJobstatus(PanelMasterMVC5SeparateDbContext context)
{
var data = new List <Jobstatus>();
data.AddRange(GetStatuses());
context.Jobstatus.AddOrUpdate(data.ToArray());
}
private static void CreateDefaultVendorMain(PanelMasterMVC5SeparateDbContext _context)
{
var data = new List <VendorMain>();
data.AddRange(GetDefaultVendorMains());
_context.VendorMain.AddOrUpdate(data.ToArray());
_context.SaveChanges();
}
private static void CreateDefaultBanks(PanelMasterMVC5SeparateDbContext _context)
{
var data = new List <Banks>();
data.AddRange(GetDefaultBanks());
_context.Banks.AddOrUpdate(data.ToArray());
_context.SaveChanges();
}
private static void AddTowOperator(PanelMasterMVC5SeparateDbContext context)
{
var defaultTenant = context.Tenants.Select(x => x.Id).ToList();
var data = new List <TowOperator>();
// data.AddRange(GetTowOperators(1));
foreach (var s in defaultTenant)
{
data.AddRange(GetTowOperators(s, context));
}
context.TowOperators.AddOrUpdate(data.ToArray());
}
private static IEnumerable <TowOperator> GetTowOperators(int tenantId, PanelMasterMVC5SeparateDbContext context)
{
string allstatus = "1 TIME TOWING,112 AUTOROADSIDE,A1 ASSIST,AA TOWING,ABOVE TOWING,ABS TOWING,ABSOLUTE TOWING,ACJ TOWING," +
"ADNANCED RECOVERIES,AFRICA TOWING,AGT TOWING,ALBERTON TOWING,ALL WAYS TOWING,ALLTOW SERVICES,AM TOWING,ATS TOWING,AUTO ACCIDENT ASSIST," +
"AUTO TECH TOWING,AUTOHAUS TOWING,BAPELA TOWING,BEUKES TOWING,BIG D ROADSIDE ASSIST,CAS TOWING,CENTOW TOWING,CLASSIQUE TOWING,DA TOWING," +
"DAANTJIES TOWING,DC TOWING,DIVERSE TOWING &LOGISTICS,DOT TOWING,EAGLE TOWING,EASYWAY TOWING,EXCLUSIVE TOWING,EXECUTIVE CARRIERS,EXTREME TOWING," +
"FIRST ROAD EMERGENCY,FLEETSIDE TOWING,FREDS AUTOBODY,GLOBAL TOW ASSIST,GLYNMART TOWING,J.J TOWING,JIDZ RECOVERIES,JML TOWING,MAGALIES AUTO CENTRE," +
"MAGIC TOWING,METRO ACCIDENT ASSISTANCE,MILLENIUM TOWING,MIRACLE TOWING,MOMOS TOWING,NEWLANDS TOWING,NONE,ON CALL TOWING,OTHER,PJ'S TOWING,SEDS 24 HOUR TOWING," +
"SNAP 123 TOWING,SOUTHSIDE TOWING,UNIQUE TOWING";
string[] str = allstatus.Split(',');
for (int i = 0; i < str.Length; i++)
{
yield return(GetTowOperator(str[i], tenantId));
}
}
private static void AddInsurerMaster(PanelMasterMVC5SeparateDbContext _context)
{
var data = new List <InsurerMaster>();
data.AddRange(GetDefaultInsurerMasters());
_context.InsurerMasters.AddOrUpdate(data.ToArray());
_context.SaveChanges();
var pics = new List <InsurerPics>();
var Ids = (from f in data
select new InsurerMaster()
{
Id = f.Id, LogoPicture = f.LogoPicture
}).ToList();
pics.AddRange(GetDefaultInsurerMastersPics(Ids));
_context.InsurerPics.AddOrUpdate(pics.ToArray());
_context.SaveChanges();
}
private static void CreateDefaultVehicleMakes(PanelMasterMVC5SeparateDbContext _context)
{
var data = new List <VehicleMake>();
data.AddRange(GetDefaultVehicleMakess());
_context.VehicleMake.AddOrUpdate(data.ToArray());
_context.SaveChanges();
var pics = new List <VehicleModelLogos>();
var Ids = (from f in data
select new VehicleMake()
{
Id = f.Id, LogoPicture = f.LogoPicture
}).ToList();
pics.AddRange(GetDefaultVehicleMakeLogos(Ids));
_context.VehicleModelLogo.AddOrUpdate(pics.ToArray());
_context.SaveChanges();
}
protected override void Seed(PanelMasterMVC5SeparateDbContext context)
{
//You can add seed for tenant databases using Tenant property...
//new DefaultDataFirstTimeMigration(context).CreateTowOperators(); // Add default tow operators
new DefaultDataFirstTimeMigration(context).CreateBanks(); // Add default CreateBanks
new DefaultDataFirstTimeMigration(context).CreateBrokerMaster(); // Add default CreateBrokerMaster
new DefaultDataFirstTimeMigration(context).CreateInsurerMaster(); // Add default CreateInsurerMaster
new DefaultDataFirstTimeMigration(context).CreateTowOperator(); // Add default CreateTowOperator
new DefaultDataFirstTimeMigration(context).CreateVehicleMakes(); // Add default CreateVehicleMakes
new DefaultDataFirstTimeMigration(context).CreateVehicleModels(); // Add default CreateVehicleModels
new DefaultDataFirstTimeMigration(context).CreateVendorMain(); // Add default CreateVendorMain
base.Seed(context);
}
public DefaultDataFirstTimeMigration(PanelMasterMVC5SeparateDbContext context)
{
_context = context;
}
public DefaultEditionCreator(PanelMasterMVC5SeparateDbContext context)
{
_context = context;
}
public InitialHostDbBuilder(PanelMasterMVC5SeparateDbContext context)
{
_context = context;
}
public DefaultSettingsCreator(PanelMasterMVC5SeparateDbContext context)
{
_context = context;
}
public TestDataBuilder(PanelMasterMVC5SeparateDbContext context, int tenantId)
{
_context = context;
_tenantId = tenantId;
}
public TenantRoleAndUserBuilder(PanelMasterMVC5SeparateDbContext context, int tenantId)
{
_context = context;
_tenantId = tenantId;
}
static void Main(string[] args)
{
var context = new PanelMasterMVC5SeparateDbContext("Data Source=localhost;Initial Catalog=PanelMasterMVC5Separate;Integrated Security=True");
System.Console.WriteLine("Would you like to add master data to tblJobstatus? Y/N");
var anwser = System.Console.ReadLine();
if (anwser?.ToLower() == "Y".ToLower())
{
AddJobstatus(context);
}
System.Console.WriteLine("Would you like to add master data to CreateDefaultVehicleMakes? Y /N");
anwser = System.Console.ReadLine();
if (anwser?.ToLower() == "Y".ToLower())
{
CreateDefaultVehicleMakes(context);
}
System.Console.WriteLine("Would you like to add master data to CreateDefaultVehicleModels? Y /N");
anwser = System.Console.ReadLine();
if (anwser?.ToLower() == "Y".ToLower())
{
CreateDefaultVehicleModels(context);
}
System.Console.WriteLine("Would you like to add master data to CreateDefaultVendorMain? Y /N");
anwser = System.Console.ReadLine();
if (anwser?.ToLower() == "Y".ToLower())
{
CreateDefaultVendorMain(context);
}
System.Console.WriteLine("Would you like to add master data to tblInsurerMaster? Y /N");
anwser = System.Console.ReadLine();
if (anwser?.ToLower() == "Y".ToLower())
{
AddInsurerMaster(context);
}
System.Console.WriteLine("Would you like to add master data to CreateBrokerMaster? Y /N");
anwser = System.Console.ReadLine();
if (anwser?.ToLower() == "Y".ToLower())
{
CreateBrokerMaster(context);
}
System.Console.WriteLine("Would you like to add master data to tblCountries? Y /N");
anwser = System.Console.ReadLine();
if (anwser?.ToLower() == "Y".ToLower())
{
AddCountries();
}
System.Console.WriteLine("Would you like to add master data to CreateDefaultBanks ? Y /N");
anwser = System.Console.ReadLine();
if (anwser?.ToLower() == "Y".ToLower())
{
CreateDefaultBanks(context);
}
System.Console.WriteLine("Would you like to add master data to tblTowOperator? Y /N");
anwser = System.Console.ReadLine();
if (anwser?.ToLower() == "Y".ToLower())
{
CreateDefaultTowOperator(context);
}
System.Console.WriteLine("Would you like to add master data to tblJobstatusMask? Y /N");
anwser = System.Console.ReadLine();
if (anwser?.ToLower() == "Y".ToLower())
{
AddJobstatusMask(context);
}
System.Console.WriteLine("Would you like to create for tblNotProceedReason? Y/N");
anwser = System.Console.ReadLine();
if (anwser?.ToLower() == "Y".ToLower())
{
NotProceedReason(context);
}
System.Console.WriteLine("Would you like to create master SignOnPlans? Y/N");
anwser = System.Console.ReadLine();
if (anwser?.ToLower() == "Y".ToLower())
{
SignOnPlans(context);
}
System.Console.WriteLine("Would you like to create master Quote Status? Y/N");
anwser = System.Console.ReadLine();
if (anwser?.ToLower() == "Y".ToLower())
{
AddQuoteStatus(context);
}
System.Console.WriteLine("Would you like to create master repair types? Y/N");
anwser = System.Console.ReadLine();
if (anwser?.ToLower() == "Y".ToLower())
{
AddRepairTypes(context);
}
System.Console.WriteLine("Would you like to create master quote categories? Y/N");
anwser = System.Console.ReadLine();
if (anwser?.ToLower() == "Y".ToLower())
{
AddQuoteCategories(context);
}
try
{
context.SaveChanges();
}
catch (Exception e)
{
DisplayMessage(e.Message);
}
System.Console.WriteLine("complete");
System.Console.ReadLine();
}
public TestOrganizationUnitsBuilder(PanelMasterMVC5SeparateDbContext context, int tenantId)
{
_context = context;
_tenantId = tenantId;
}
public HostRoleAndUserCreator(PanelMasterMVC5SeparateDbContext context)
{
_context = context;
}
public DefaultTenantBuilder(PanelMasterMVC5SeparateDbContext context)
{
_context = context;
}
public DefaultLanguagesCreator(PanelMasterMVC5SeparateDbContext context)
{
_context = context;
}
