public DDDClass.CardIdentification Get_EF_Identification_CardIdentification(int dataBlockId)
{
SQLDB_Records sqldbRecords = new SQLDB_Records(connectionString, sqlDB.GETMYSQLCONNECTION());
string paramName = "ef_identification.cardIdentification";
string currentParamName;
DDDClass.CardIdentification cardIdentification = new DDDClass.CardIdentification();
string cardExpiryDate;
string cardIssueDate;
string cardIssuingAuthorityName;
string cardIssuingMemberState;
string cardValidityBegin;
DDDClass.CardNumber cardNumber = new DDDClass.CardNumber();
currentParamName = paramName + ".cardExpiryDate";
cardExpiryDate = sqldbRecords.Get_ParamValue(dataBlockId, currentParamName);
currentParamName = paramName + ".cardIssueDate";
cardIssueDate = sqldbRecords.Get_ParamValue(dataBlockId, currentParamName);
currentParamName = paramName + ".cardIssuingAuthorityName.name";
cardIssuingAuthorityName = sqldbRecords.Get_ParamValue(dataBlockId, currentParamName);
currentParamName = paramName + ".cardIssuingMemberState";
cardIssuingMemberState = sqldbRecords.Get_ParamValue(dataBlockId, currentParamName);
currentParamName = paramName + ".cardValidityBegin";
cardValidityBegin = sqldbRecords.Get_ParamValue(dataBlockId, currentParamName);
currentParamName = paramName + ".cardNumber";
cardNumber = GetCardNumber(dataBlockId, currentParamName)[0];//Зайти внутрь попалить
cardIdentification.cardExpiryDate = new DDDClass.TimeReal(Convert.ToInt64(cardExpiryDate));
cardIdentification.cardIssueDate = new DDDClass.TimeReal(Convert.ToInt64(cardIssueDate));
cardIdentification.cardIssuingAuthorityName.setName(cardIssuingAuthorityName);
cardIdentification.cardIssuingMemberState = new DDDClass.NationNumeric(Convert.ToByte(cardIssuingMemberState));
cardIdentification.cardValidityBegin = new DDDClass.TimeReal(cardValidityBegin);
cardIdentification.cardNumber = cardNumber;
return cardIdentification;
}
private List<DDDClass.CardNumber> GetCardNumber(int dataBlockId, string paramName)
{
SQLDB_Records sqldbRecords = new SQLDB_Records(connectionString, sqlDB.GETMYSQLCONNECTION());
string currentParamName;
List<DDDClass.CardNumber> cardNumberList = new List<DDDClass.CardNumber>();
DDDClass.CardNumber cardNumber = new DDDClass.CardNumber();
List<string> cardConsecutiveIndex = new List<string>();
List<string> cardRenewalIndex = new List<string>();
List<string> cardReplacementIndex = new List<string>();
List<string> driverIdentification = new List<string>();
List<string> ownerIdentification = new List<string>();
currentParamName = paramName + ".cardConsecutiveIndex";
cardConsecutiveIndex = sqldbRecords.Get_AllParamsArray(dataBlockId, currentParamName);
currentParamName = paramName + ".cardRenewalIndex";
cardRenewalIndex = sqldbRecords.Get_AllParamsArray(dataBlockId, currentParamName);
currentParamName = paramName + ".cardReplacementIndex";
cardReplacementIndex = sqldbRecords.Get_AllParamsArray(dataBlockId, currentParamName);
currentParamName = paramName + ".driverIdentification";
driverIdentification = sqldbRecords.Get_AllParamsArray(dataBlockId, currentParamName);
currentParamName = paramName + ".ownerIdentification";
ownerIdentification = sqldbRecords.Get_AllParamsArray(dataBlockId, currentParamName);
if (cardRenewalIndex.Count == ownerIdentification.Count && driverIdentification.Count == cardConsecutiveIndex.Count)
{
for (int i = 0; i < cardRenewalIndex.Count; i++)
{
cardNumber = new DDDClass.CardNumber();
cardNumber.cardConsecutiveIndex = new DDDClass.CardConsecutiveIndex(cardConsecutiveIndex[i]);
cardNumber.cardRenewalIndex = new DDDClass.CardRenewalIndex(cardRenewalIndex[i]);
cardNumber.cardReplacementIndex = new DDDClass.CardReplacementIndex(cardReplacementIndex[i]);
cardNumber.driverIdentification = driverIdentification[i];
cardNumber.ownerIdentification = ownerIdentification[i];
cardNumberList.Add(cardNumber);
}
}
return cardNumberList;
}
