public static string BM(string companyName, string middlemanName)
{
int idCompany, idMiddleman, idCompanyMiddleman;
try
{
idCompany = CompanyDataManipulation.GetId(companyName);
idMiddleman = MiddlemanDataManipulation.GetId(middlemanName);
idCompanyMiddleman = CompanyMiddlemanDataManipulation.GetId(companyName, middlemanName);
}
catch
{
responseToClient.responseType = ResponseType.Bad;
responseToClient.responseText = "Виникли проблеми з отриманням даних.";
return(js.Serialize(responseToClient));
}
List <BonusMalus> BMRecords = BonusMalusDataManipulation.GetMulti(idCompanyMiddleman);
List <TableBMToSend> BMTable = new List <TableBMToSend>();
//Uncomment for auto generate conditions
//ConditionGeneration.BM(idCompanyMiddleman);
//BMRecords = BMDataManipulation.GetMulti(idCompanyMiddleman);
BMRecords = BonusMalusDataManipulation.GetMulti(idCompanyMiddleman);
foreach (var k in BMRecords)
{
TableBMToSend tempTableRow = new TableBMToSend();
tempTableRow.CarZoneOfRegistration = InsuranceZoneOfRegistrationDataManipulation.GetInsuranceZoneOfRegistrationStr(k.IdInsuranceZoneOfReg);
tempTableRow.IsLegalEntity = k.IsLegalEntity ? "Юр" : "Фіз";
tempTableRow.InsuranceTypeOfCar = CarInsuranceTypeDataManipulation.GetCarInsuranceTypeStr((int)k.IdCarInsuranceType);
tempTableRow.Franchise = FranchiseDataManipulation.GetFranchiseSum(k.ContractFranchise.IdFranchise);
tempTableRow.Value = k.Value;
BMTable.Add(tempTableRow);
}
List <TitlesToSend> titles = new List <TitlesToSend>();
titles.Add(FillTitleToSend(name: "CarZoneOfRegistration", titleUkr: "Зона регестрації", titleRus: "Зона регистрации"));
titles.Add(FillTitleToSend(name: "IsLegalEntity", titleUkr: "Юр / Фіз", titleRus: "Юр / Физ"));
titles.Add(FillTitleToSend(name: "InsuranceTypeOfCar", titleUkr: "Тип транспорту", titleRus: "Тип транспорта"));
titles.Add(FillTitleToSend(name: "Franchise", titleUkr: "Франшиза", titleRus: "Франшиза"));
titles.Add(FillTitleToSend(name: "Value", titleUkr: "Значення", titleRus: "Значение"));
Dictionary <string, object> dataToSend = new Dictionary <string, object>();
dataToSend.Add("titles", titles);
dataToSend.Add("data", BMTable);
return(js.Serialize(dataToSend));
}
public static string BM(int idCompanyMiddleman)
{
int idContractType = 0, idCompanyContractType = 0;
List <Franchise> franchise = new List <Franchise>();
List <InsuranceZoneOfRegistration> insuranceZoneOfReg = new List <InsuranceZoneOfRegistration>();
List <bool> isLegal = new List <bool>();
List <CarInsuranceType> insuranceTypeOfCar = new List <CarInsuranceType>();
try
{
idContractType = ContractTypeDataManipulation.GetId("ГО");
idCompanyContractType = CompanyContractTypeDataManipulation.GetId(idCompanyMiddleman, idContractType);
franchise = FranchiseDataManipulation.GetFranchises(ContractFranchiseDataManipulation.GetFranchiseIds(idCompanyContractType));
insuranceZoneOfReg = InsuranceZoneOfRegistrationDataManipulation.GetMulti();
isLegal = new List <bool> {
true, false
};
insuranceTypeOfCar = CarInsuranceTypeDataManipulation.GetMulti();
}
catch
{
responseToClient.responseType = ResponseType.Bad;
responseToClient.responseText = "Виникла помилка при генерації умов.";
return(js.Serialize(responseToClient));
}
foreach (var izor in insuranceZoneOfReg)
{
foreach (var il in isLegal)
{
foreach (var itoc in insuranceTypeOfCar)
{
foreach (var f in franchise)
{
var idContractFranchise = ContractFranchiseDataManipulation.GetId(idCompanyContractType, f.Id);
if (BonusMalusDataManipulation.IsConditionExist(izor.Id, il, itoc.Id, idContractFranchise, idCompanyContractType, idCompanyMiddleman))
{
var newRowBM = new BonusMalus()
{
IdInsuranceZoneOfReg = izor.Id,
IsLegalEntity = il,
IdCarInsuranceType = itoc.Id,
IdContractFranchise = idContractFranchise,
Value = 0,
IdCompanyMiddleman = idCompanyMiddleman,
};
try
{
BonusMalusDataManipulation.Insert(newRowBM);
}
catch
{
responseToClient.responseType = ResponseType.Bad;
responseToClient.responseText = $"Виникла помилка при генерації запису для умов: \"{izor.Name}\"; \"{il}\"; \"{itoc.Type}\"; \"{f.Sum}\".";
return(js.Serialize(responseToClient));
}
}
}
}
}
}
responseToClient.responseType = ResponseType.Good;
responseToClient.responseText = "Генерація даних пройшла успішно.";
return(js.Serialize(responseToClient));
}
