public static CitizenSql FromCsvToSql(CitizenCsv citizenCsv) { var provider = CultureInfo.InvariantCulture; var citizenSql = new CitizenSql { Name = citizenCsv.Name, Surname = citizenCsv.Surname, Patronymic = citizenCsv.Patronymic, }; citizenSql.DateOfBirth = DateTime.ParseExact(citizenCsv.DateOfBirth, "yyyy'-'MM'-'dd", provider); if (!string.IsNullOrEmpty(citizenCsv.DateOfDeath)) { citizenSql.DateOfDeath = DateTime.ParseExact(citizenCsv.DateOfDeath, "yyyy'-'MM'-'dd", provider); } if (!string.IsNullOrEmpty(citizenCsv.Snils)) { var snilsNumbersString = StringConverter.GetNumbers(citizenCsv.Snils); citizenSql.Snils = long.Parse(snilsNumbersString); } if (!string.IsNullOrEmpty(citizenCsv.Inn)) { var innNumbersString = StringConverter.GetNumbers(citizenCsv.Inn); citizenSql.Inn = long.Parse(innNumbersString); } return(citizenSql); }
public static CitizenCsv FromSqlToCsv(CitizenSql citizenSql) { var provider = CultureInfo.InvariantCulture; var citizenCsv = new CitizenCsv { Name = citizenSql.Name, Surname = citizenSql.Surname, Patronymic = citizenSql.Patronymic, DateOfBirth = citizenSql.DateOfBirth.ToString("yyyy'-'MM'-'dd", provider) }; if (citizenSql.Snils != null) { citizenCsv.Snils = citizenSql.Snils.Value.ToString(); } if (citizenSql.Inn != null) { citizenCsv.Inn = citizenSql.Inn.Value.ToString(); } if (citizenSql.DateOfDeath != null) { citizenCsv.DateOfDeath = citizenSql.DateOfDeath.Value.ToString("yyyy'-'MM'-'dd", provider); } return(citizenCsv); }
/*public Task ImportCsv(List<CitizenSql> citizenSql) * { * * }*/ public void ValidateCitizenCsv(CitizenCsv citizenCsv) { if (string.IsNullOrEmpty(citizenCsv.Name) || citizenCsv.Name.Length > 30) { throw new ArgumentException($"Name not valid: {citizenCsv.Name}"); } if (string.IsNullOrEmpty(citizenCsv.Surname) || citizenCsv.Surname.Length > 30) { throw new ArgumentException($"Surname not valid: {citizenCsv.Surname}"); } if (string.IsNullOrEmpty(citizenCsv.Patronymic) || citizenCsv.Patronymic.Length > 30) { throw new ArgumentException($"Patronymic not valid: {citizenCsv.Patronymic}"); } if (!string.IsNullOrEmpty(citizenCsv.Inn) && !ValidationsCollection.Validations.IsValidInnForIndividual(citizenCsv.Inn)) { throw new ArgumentException($"Inn not valid: {citizenCsv.Inn}"); } if (!string.IsNullOrEmpty(citizenCsv.Snils) && !ValidationsCollection.Validations.IsValidSnils(StringConverter.GetNumbers(citizenCsv.Snils))) { throw new ArgumentException($"Snils not valid: {citizenCsv.Snils}"); } }