private static void GetPreconfiguredTitelSet(InsuranceDbContext context)
{
var titel = Stammdaten.GetTitel();
string firstDimension = "";
string secondDimension = "";
for (int i = 0; i < titel.GetLength(0); ++i)
{
for (int j = 0; j < titel.GetLength(1); ++j)
{
if (j == 0)
{
firstDimension = titel[i, j];
}
else
{
secondDimension = titel[i, j];
}
}
context.TitelSet.Add(new Titel
{
Id = i + 1,
BezeichnungKurz = firstDimension,
Beschreibung = secondDimension
});
}
}
private static void GetPreconfiguredVermittlerGesellschaften(InsuranceDbContext context)
{
var vermittlerList = context.Vermittler.ToList();
var gesellschaftList = context.GesellschaftSet.ToList();
if (vermittlerList.Count <= 0 || gesellschaftList.Count <= 0)
{
return;
}
foreach (var vermittler in vermittlerList)
{
foreach (var gesellschaft in gesellschaftList)
{
context.VermittlerGesellschafften.Add(new VermittlerGesellschafft
{
VermittlerId = vermittler.Id,
GesellschaftId = gesellschaft.Id,
VermittlerNo = vermittler.VermittlerNo,
Abschlussvergütung = 0.08,
Bestandsvergütung = 0.08,
MaxLaufzeitVergütung = 40
});
}
}
}
public InsuranceCalculatorService(
IProductApiClient productApiClient,
InsuranceDbContext dbContext)
{
_productApiClient = productApiClient;
_dbContext = dbContext;
}
public void Cleanup()
{
InsuranceDbContext context = new InsuranceDbContext(ConnectionString);
context.Database.Delete();
File.Delete(_tempFile);
}
//DONT DELETE Bestandsdaten: DokumentArt, Berufe, Berufsstatus, Länder und Titel
private static void DeleteAllData(InsuranceDbContext context)
{
if (context.Adressen.Any())
{
context.Adressen.RemoveRange(context.Adressen);
}
if (context.Ausweise.Any())
{
context.Ausweise.RemoveRange(context.Ausweise);
}
if (context.Bankverbindungen.Any())
{
context.Bankverbindungen.RemoveRange(context.Bankverbindungen);
}
if (context.Dokumente.Any())
{
context.Dokumente.RemoveRange(context.Dokumente);
}
if (context.DokumentArtSet.Any())
{
context.DokumentArtSet.RemoveRange(context.DokumentArtSet);
}
if (context.GesellschaftSet.Any())
{
context.GesellschaftSet.RemoveRange(context.GesellschaftSet);
}
if (context.Kunden.Any())
{
context.Kunden.RemoveRange(context.Kunden);
}
if (context.ProvisionssätzeGesellschaft.Any())
{
context.ProvisionssätzeGesellschaft.RemoveRange(context.ProvisionssätzeGesellschaft);
}
if (context.Users.Any())
{
context.Users.RemoveRange(context.Users);
}
if (context.Versicherungsnehmer.Any())
{
context.Versicherungsnehmer.RemoveRange(context.Versicherungsnehmer);
}
if (context.Vermittler.Any())
{
context.Vermittler.RemoveRange(context.Vermittler);
}
}
public AgentValidator(InsuranceDbContext context) : base(context)
{
RuleFor(x => x.Branch)
.NotNull().WithMessage("Branch must be not Null")
.MustAsync(IsExist).WithMessage("The entered Branch dosnt`t exist");
RuleFor(x => x.FirstName)
.NotNull().WithMessage("First Name must be not Null");
RuleFor(x => x.SecondName).NotNull().WithMessage("Second Name must be not null");
}
private static void GetPreconfiguredGesellschaften(InsuranceDbContext context)
{
context.GesellschaftSet.AddRange(new Gesellschaft
{
Id = 1,
Name = "Bsp. Gesellschaft Bayerische"
}, new Gesellschaft
{
Id = 2,
Name = "Bsp. Gesellschaft Allianz"
});
}
public InsuranceDbContext CreateContext()
{
InsuranceDbContext context = new InsuranceDbContext(ConnectionString);
if (!_initialized)
{
context.Database.CreateIfNotExists();
_initialized = true;
}
return(context);
}
public bool CheckExistUsername(string username)
{
using (var ctx = new InsuranceDbContext())
{
var item = ctx.Customer_Info.Where(c => c.username.Equals(username)).FirstOrDefault();
if (item == null)
{
return(true);
}
}
return(false);
}
public ActionResult RegisterDb(CustomerinfoViewModel uv)
{
using (var ctx = new InsuranceDbContext())
{
if (Session["id"] == null)
{
if (CheckNullField(uv))
{
if (CheckExistUsername(uv.username))
{
if (CheckPasswordMatch(uv.password, Request.Params["pwRePassword"]))
{
if (uv.active == true)
{
CustomerinfoDAORequest request = new CustomerinfoDAORequest();
//Usertype: Customer
uv.user_type_id = 2;
request.Add(uv);
return(RedirectToAction("Index", "Home"));
}
else
{
TempData["Alert"] = "Please Check to Accept Policy";
return(RedirectToAction("Register", "Register"));
}
}
else
{
TempData["Alert"] = "The Password Not Match";
return(RedirectToAction("Register", "Register"));
}
}
else
{
TempData["Alert"] = "This Username Already Exist ";
return(RedirectToAction("Register", "Register"));
}
}
else
{
TempData["Alert"] = "Please Enter Full Of Field";
return(RedirectToAction("Register", "Register"));
}
}
else
{
TempData["Alert"] = "Please Use Another Acount";
return(RedirectToAction("Register", "Register"));
}
}
}
private static void GetPreconfiguredDokumentArt(InsuranceDbContext context)
{
string[] dokumentArtList = Stammdaten.GetDokumentArtList();
for (int i = 0; i < dokumentArtList.Length; ++i)
{
context.DokumentArtSet.Add(new DokumentArt()
{
Id = i + 1,
Name = dokumentArtList[i]
});
}
}
private static void GetPreconfiguredBerufe(InsuranceDbContext context)
{
string[] berufe = Stammdaten.GetBerufe();
for (int i = 0; i < berufe.Length; ++i)
{
context.Berufe.Add(new Beruf
{
Id = i + 1,
Name = berufe[i]
});
}
}
private static void GetPreconfiguredLänder(InsuranceDbContext context)
{
string[] länder = Stammdaten.GetLänder();
for (int i = 0; i < länder.Length; ++i)
{
context.Länder.Add(new Land()
{
Id = i + 1,
Name = länder[i]
});
}
}
public async Task <MinMaxDTO> GetSumInuredRange()
{
using (InsuranceDbContext context = _contextFactory.CreateContext())
{
List <CoverOption> options = await context.CoverOptions.ToListAsync();
MinMaxDTO result = new MinMaxDTO
{
MinValue = options.Min(x => x.MinimumAgreedValue),
MaxValue = options.Max(x => x.MaximumAgreedValue)
};
return(result);
}
}
public static void EnsureSeedDataForContext(this InsuranceDbContext context)
{
DeleteAllData(context);
context.SaveChanges();
//Seed Stammdaten
if (!context.Länder.Any())
{
GetPreconfiguredLänder(context);
}
if (!context.Berufe.Any())
{
GetPreconfiguredBerufe(context);
}
if (!context.DokumentArtSet.Any())
{
GetPreconfiguredDokumentArt(context);
}
if (!context.TitelSet.Any())
{
GetPreconfiguredTitelSet(context);
}
context.SaveChanges();
GetPreconfiguredGesellschaften(context);
context.SaveChanges();
GetPreconfiguredVersicherungsnehmer(context);
context.SaveChanges();
GetPreconfiguredVermittler(context);
context.SaveChanges();
GetPreconfiguredVermittlerGesellschaften(context);
context.SaveChanges();
GetPreconfiguredDokumenteFürVermittler(context);
context.SaveChanges();
GetPreconfiguredProvisionssätzeGesellschaft(context);
context.SaveChanges();
}
