public void CreateDatabase(string path)
{
try
{
SQLiteConnection sqLiteConnection = new SQLiteConnection(path);
sqLiteConnection.CreateTable <User>();
sqLiteConnection.CreateTable <VacationStatus>();
sqLiteConnection.CreateTable <VacationType>();
sqLiteConnection.CreateTable <SynchronizStatus>();
sqLiteConnection.CreateTable <Vacation>();
sqLiteConnection.DeleteAll <User>();
sqLiteConnection.DeleteAll <VacationStatus>();
sqLiteConnection.DeleteAll <VacationType>();
sqLiteConnection.DeleteAll <SynchronizStatus>();
sqLiteConnection.DeleteAll <Vacation>();
SynchronizStatus synchronizStatus = new SynchronizStatus();
synchronizStatus.Name = "Add";
sqLiteConnection.Insert(synchronizStatus);
synchronizStatus.Name = "Delete";
sqLiteConnection.Insert(synchronizStatus);
synchronizStatus.Name = "Update";
sqLiteConnection.Insert(synchronizStatus);
synchronizStatus.Name = "Synchroniz";
sqLiteConnection.Insert(synchronizStatus);
VacationType vacationType = new VacationType();
vacationType.Name = "Undefined";
sqLiteConnection.Insert(vacationType);
vacationType.Name = "Regular";
sqLiteConnection.Insert(vacationType);
vacationType.Name = "Sick";
sqLiteConnection.Insert(vacationType);
vacationType.Name = "Exceptional";
sqLiteConnection.Insert(vacationType);
vacationType.Name = "LeaveWithoutPay";
sqLiteConnection.Insert(vacationType);
vacationType.Name = "Overtime";
sqLiteConnection.Insert(vacationType);
VacationStatus vacationStatus = new VacationStatus();
vacationStatus.Name = "Draft";
sqLiteConnection.Insert(vacationStatus);
vacationStatus.Name = "Submitted";
sqLiteConnection.Insert(vacationStatus);
vacationStatus.Name = "Approved";
sqLiteConnection.Insert(vacationStatus);
vacationStatus.Name = "InProgress";
sqLiteConnection.Insert(vacationStatus);
vacationStatus.Name = "Closed";
sqLiteConnection.Insert(vacationStatus);
User user = new User();
user.Login = "******";
user.Password = "******";
sqLiteConnection.Insert(user);
var req1 = new Vacation
{
Id = new Guid("35055cea-59a5-43df-9d84-9f2bc8401008"),
Start = new DateTime(2017, 3, 20),
End = new DateTime(2017, 3, 30),
VacationTypeId = 1,
VacationStatusId = 3,
CreatedBy = "Someone",
Created = DateTime.Now,
IsSynchroniz = true,
SynchronizStatusId = 4
};
sqLiteConnection.Insert(req1);
var req2 = new Vacation
{
Id = new Guid("16954f5a-87cf-4030-8897-c8abe2e6d516"),
Start = new DateTime(2016, 12, 26),
End = new DateTime(2016, 12, 30),
VacationTypeId = 1,
VacationStatusId = 5,
CreatedBy = "Someone",
Created = DateTime.UtcNow,
IsSynchroniz = true,
SynchronizStatusId = 4
};
sqLiteConnection.Insert(req2);
var req3 = new Vacation
{
Id = new Guid("075bbbd8-4a50-4af0-beb7-96e89fc4f885"),
Start = new DateTime(2016, 11, 2),
End = new DateTime(2016, 11, 4),
VacationTypeId = 2,
VacationStatusId = 5,
CreatedBy = "Someone",
Created = DateTime.UtcNow,
IsSynchroniz = true,
SynchronizStatusId = 4
};
sqLiteConnection.Insert(req3);
var req4 = new Vacation
{
Id = new Guid("66d7d908-cb58-4fff-9a71-1067e148bdf5"),
Start = new DateTime(2016, 7, 11),
End = new DateTime(2016, 7, 13),
VacationTypeId = 3,
VacationStatusId = 5,
CreatedBy = "Someone",
Created = DateTime.UtcNow,
IsSynchroniz = true,
SynchronizStatusId = 4
};
sqLiteConnection.Insert(req4);
var req5 = new Vacation()
{
Id = new Guid("b3d47866-6ccb-46bc-8006-2b6ee7b7f168"),
Start = new DateTime(2016, 2, 6),
End = new DateTime(2016, 2, 7),
VacationTypeId = 5,
VacationStatusId = 5,
CreatedBy = "Someone",
Created = DateTime.UtcNow,
IsSynchroniz = true,
SynchronizStatusId = 4
};
sqLiteConnection.Insert(req5);
}
catch (Exception exception)
{
throw exception.InnerException;
}
}
