public static string K2(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 <K2> K2Records = K2DataManipulation.GetMulti(idCompanyMiddleman); List <TableK2ToSend> K2Table = new List <TableK2ToSend>(); //Uncomment for auto generate conditions //ConditionGeneration.K2(idCompanyMiddleman); //K2Records = K2DataManipulation.GetMulti(idCompanyMiddleman); K2Records = K2DataManipulation.GetMulti(idCompanyMiddleman); foreach (var k in K2Records) { TableK2ToSend tempTableRow = new TableK2ToSend(); tempTableRow.CarZoneOfRegistration = InsuranceZoneOfRegistrationDataManipulation.GetInsuranceZoneOfRegistrationStr(k.IdInsuranceZoneOfReg); tempTableRow.IsLegalEntity = k.IsLegalEntity ? "Юр" : "Фіз"; tempTableRow.InsuranceTypeOfCar = CarInsuranceTypeDataManipulation.GetCarInsuranceTypeStr(k.IdCarInsuranceType); tempTableRow.Franchise = FranchiseDataManipulation.GetFranchiseSum(k.ContractFranchise.IdFranchise); tempTableRow.Value = k.Value; K2Table.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", K2Table); return(js.Serialize(dataToSend)); }
static public string K2(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 (K2DataManipulation.IsConditionExist(izor.Id, il, itoc.Id, idContractFranchise, idCompanyContractType, idCompanyMiddleman)) { var newRowK2 = new K2() { IdInsuranceZoneOfReg = izor.Id, IsLegalEntity = il, IdCarInsuranceType = itoc.Id, IdContractFranchise = idContractFranchise, Value = 0, IdCompanyMiddleman = idCompanyMiddleman, }; try { K2DataManipulation.Insert(newRowK2); } 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)); }