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 static CitizenSql FromApiV1ToSql(CitizenV1 citizenV1)
{
var citizenSql = new CitizenSql
{
Name = citizenV1.Name,
Surname = citizenV1.Surname,
Patronymic = citizenV1.Patronymic,
DateOfBirth = citizenV1.DateOfBirth,
DateOfDeath = citizenV1.DateOfDeath,
};
if (!string.IsNullOrEmpty(citizenV1.Snils))
{
var snilsNumbersString = StringConverter.GetNumbers(citizenV1.Snils);
citizenSql.Snils = long.Parse(snilsNumbersString);
}
if (!string.IsNullOrEmpty(citizenV1.Inn))
{
var innNumbersString = StringConverter.GetNumbers(citizenV1.Inn);
citizenSql.Inn = long.Parse(innNumbersString);
}
return(citizenSql);
}
public async Task <Guid> AddCitizen(CitizenSql citizenSql)
{
//citizenSql.Guid = new Guid();
var rrr = Context.Citizens.AddAsync(citizenSql);
await Context.SaveChangesAsync();
return(citizenSql.Guid);
}
public static CitizenV1 FromSqlToApiV1(CitizenSql citizenSql)
{
var citizenV1 = new CitizenV1
{
Inn = citizenSql.Inn.ToString(),
Name = citizenSql.Name,
Surname = citizenSql.Surname,
Patronymic = citizenSql.Patronymic,
Snils = citizenSql.Snils.ToString(),
DateOfBirth = citizenSql.DateOfBirth,
DateOfDeath = citizenSql.DateOfDeath,
Guid = citizenSql.Guid
};
return(citizenV1);
}
public async Task <bool> DeleteCitizen(Guid guid)
{
var isRecordExist = Context.Citizens.Any(x => x.Guid == guid);
if (!isRecordExist)
{
return(false);
}
var citizen = new CitizenSql()
{
Guid = guid
};
Context.Citizens.Attach(citizen);
Context.Citizens.Remove(citizen);
await Context.SaveChangesAsync();
return(true);
}
public async Task <ActionResult <RpAddCitizen> > AddCitizen([FromBody] RqAddCitizen rqAddCitizen)
{
try
{
if (!string.IsNullOrEmpty(rqAddCitizen.Citizen.Inn) && !ValidationsCollection.Validations.IsValidInnForIndividual(rqAddCitizen.Citizen.Inn))
{
return(Json(ResponseHelper.ReturnBadRequest("Inn not valid")));
}
if (!string.IsNullOrEmpty(rqAddCitizen.Citizen.Snils) && !ValidationsCollection.Validations.IsValidSnils(StringConverter.GetNumbers(rqAddCitizen.Citizen.Snils)))
{
return(Json(ResponseHelper.ReturnBadRequest("Snils not valid")));
}
var citizenSql = new CitizenSql();
try
{
citizenSql = CitizenConverter.FromApiV1ToSql(rqAddCitizen.Citizen);
}
catch (Exception exception)
{
LoggerStatic.Logger.Warn("Exception: " + exception);
return(Json(ResponseHelper.ReturnBadRequest(exception.Message)));
}
var guid = await _peopleService.AddCitizen(citizenSql);
var rpAddCitizen = new RpAddCitizen
{
Guid = guid
};
return(Json(rpAddCitizen));
}
catch (Exception exception)
{
LoggerStatic.Logger.Error("Exception: " + exception);
return(Json(ResponseHelper.ReturnInternalServerError(exception.Message)));
}
}
private CitizenSql GetRandomCitizenSql()
{
var citizen = new CitizenSql()
{
Guid = Guid.NewGuid(),
Name = StringConverter.GetRandomString(10),
Patronymic = StringConverter.GetRandomString(10),
Surname = StringConverter.GetRandomString(10),
//Inn =
//Snils =
DateOfBirth = StringConverter.RandomDay(1850),
};
if (citizen.DateOfBirth.Year > 100)
{
var dateOfDeath = StringConverter.RandomDay(1950);
if (dateOfDeath.Year > citizen.DateOfBirth.Year)
{
citizen.DateOfDeath = dateOfDeath;
}
}
return(citizen);
}
public async Task UpdateCitizen(CitizenSql citizenSql)
{
Context.Update(citizenSql);
await Context.SaveChangesAsync();
}
