/// <summary>
/// The get.
/// </summary>
/// <param name="passportObjectJson">
/// The passport Object Json.
/// </param>
/// <param name="sort">
/// The sort.
/// </param>
/// <param name="direction">
/// The direction.
/// </param>
/// <param name="skip">
/// The skip.
/// </param>
/// <returns>
/// The <see cref="List"/>.
/// </returns>
public List <Passport> GetPassports(string passportObjectJson, int sort, bool direction, int skip)
{
Passport passport = new JavaScriptSerializer().Deserialize <Passport>(passportObjectJson);
List <Passport> pas = new List <Passport>();
pas = PassportRepository.FindPassports(passport, sort, direction, skip);
return(pas);
}
public UnitOfWork(string connectionString)
{
this.connectionString = connectionString;
Persons = new PersonRepository(connectionString);
Educations = new EducationRepository(connectionString);
Insurances = new InsuranceRepository(connectionString);
Passports = new PassportRepository(connectionString);
PersonsPositions = new PersonPositionRepository(connectionString);
Positions = new PositionRepository(connectionString);
UserRole = new UserRoleRepository(connectionString);
}
static void Main(string[] args)
{
var passport = new Passport()
{
Address = "Звездная",
Birthday = new DateTime(1980, 4, 3),
Firstname = "Дарт",
IssuedBy = "Космос",
IssuedDepartment = "Космический Альянс",
IssuedOn = new DateTime(1980, 4, 3),
Lastname = "Вейдер",
Number = "01",
Secondname = "",
Series = "01",
Sex = SexType.Male
};
var repository = new PassportRepository("data source = (localdb)\\MSSQLLocalDB; Initial Catalog = PassportStore; Integrated Security = True;");
repository.CreateAsync(passport).Wait();
}
public async Task TestMethod()
{
var passport = new Passport()
{
Address = "Звездная",
Birthday = new DateTime(1980, 4, 3, new GregorianCalendar()),
Firstname = "Дарт",
IssuedBy = "Космос",
IssuedDepartment = "Космический Альянс",
IssuedOn = new DateTime(1980, 4, 3, new GregorianCalendar()),
Lastname = "Вейдер",
Number = "01",
Secondname = "",
Series = "01",
Sex = SexType.Male
};
var repository = new PassportRepository(ConfigurationManager.AppSettings["DBConnection"]);
await repository.CreateAsync(passport);
}
