public static string K4(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 <K4> K4Records = K4DataManipulation.GetMulti(idCompanyMiddleman);
List <TableK4ToSend> K4Table = new List <TableK4ToSend>();
//Uncomment for auto generate conditions
//ConditionGeneration.K4(idCompanyMiddleman);
//K4Records = K4DataManipulation.GetMulti(idCompanyMiddleman);
foreach (var k in K4Records)
{
TableK4ToSend tempTableRow = new TableK4ToSend();
tempTableRow.CarZoneOfRegistration = InsuranceZoneOfRegistrationDataManipulation.GetInsuranceZoneOfRegistrationStr(k.IdInsuranceZoneOfReg);
tempTableRow.IsLegalEntity = k.IsLegalEntity ? "Юр" : "Фіз";
tempTableRow.Franchise = FranchiseDataManipulation.GetFranchiseSum(k.ContractFranchise.IdFranchise);
tempTableRow.Value = k.Value;
K4Table.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: "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", K4Table);
return(js.Serialize(dataToSend));
}
static public string K4(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>();
try
{
idContractType = ContractTypeDataManipulation.GetId("ГО");
idCompanyContractType = CompanyContractTypeDataManipulation.GetId(idCompanyMiddleman, idContractType);
franchise = FranchiseDataManipulation.GetFranchises(ContractFranchiseDataManipulation.GetFranchiseIds(idCompanyContractType));
insuranceZoneOfReg = InsuranceZoneOfRegistrationDataManipulation.GetMulti();
isLegal = new List <bool> {
true, false
};
}
catch
{
responseToClient.responseType = ResponseType.Bad;
responseToClient.responseText = "Виникла помилка при генерації умов.";
return(js.Serialize(responseToClient));
}
foreach (var izor in insuranceZoneOfReg)
{
foreach (var il in isLegal)
{
foreach (var f in franchise)
{
var idContractFranchise = ContractFranchiseDataManipulation.GetId(idCompanyContractType, f.Id);
try
{
if (K4DataManipulation.IsConditionExist(izor.Id, il, idContractFranchise, idCompanyMiddleman))
{
var newRowK4 = new K4()
{
IdInsuranceZoneOfReg = izor.Id,
IsLegalEntity = il,
IdContractFranchise = idContractFranchise,
Value = 0,
IdCompanyMiddleman = idCompanyMiddleman,
};
try
{
K4DataManipulation.Insert(newRowK4);
}
catch
{
responseToClient.responseType = ResponseType.Bad;
responseToClient.responseText = $"Виникла помилка при генерації запису для умов: \"{izor.Name}\"; \"{il}\"; \"{f.Sum}\".";
return(js.Serialize(responseToClient));
}
}
}
catch
{
responseToClient.responseType = ResponseType.Bad;
responseToClient.responseText = $"Виникла помилка при генерації запису.";
return(js.Serialize(responseToClient));
}
}
}
}
responseToClient.responseType = ResponseType.Good;
responseToClient.responseText = "Генерація даних пройшла успішно.";
return(js.Serialize(responseToClient));
}
