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}");
}
}
