public static void Insert(UserDataDto user)
{
using (var connection = new SQLiteConnection(connectionStringBuilder.ConnectionString))
{
connection.Open();
var command = connection.CreateCommand();
command.CommandText = $@"DELETE FROM [UserData]
WHERE Sequence = {user.Sequence} and EXISTS (select * from [UserData] where Sequence = {user.Sequence})";
command.ExecuteNonQuery();
command.CommandText = $@"INSERT INTO [UserData]
([Token], [BgImagePosX], [BgImagePosY], [EzdImagePosX], [EzdImagePosY], [Sequence], [Login], [Password], [Url], [FullImage], [BgImage], [EzdImage])
VALUES ('{user.Token}'
,{user.BgImagePosX}
,{user.BgImagePosY}
,{user.EzdImagePosX}
,{user.EzdImagePosY}
,{user.Sequence},
'{user.Login}',
'{user.Password}',
'{user.Url}',
'{user.FullImage}',
'{user.BgImage}',
'{user.EzdImage}');";
command.ExecuteNonQuery();
}
}
public static UserDataDto GetByTabIndex(long index)
{
UserDataDto user = new UserDataDto();
try
{
using (var connection = new SQLiteConnection(connectionStringBuilder.ConnectionString))
{
connection.Open();
var command = connection.CreateCommand();
command.CommandText = $@"SELECT * FROM UserData Where Sequence = {index}";
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
user = new UserDataDto
{
Id = (long)reader["Id"],
Token = (string)reader["Token"],
Login = (string)reader["Login"],
Password = (string)reader["Password"],
Url = (string)reader["Url"],
FullImage = (string)reader["FullImage"],
BgImage = (string)reader["BgImage"],
EzdImage = (string)reader["EzdImage"],
Sequence = (long)reader["Sequence"],
BgImagePosX = (long)reader["BgImagePosX"],
BgImagePosY = (long)reader["BgImagePosY"],
EzdImagePosX = (long)reader["EzdImagePosX"],
EzdImagePosY = (long)reader["EzdImagePosY"],
};
}
}
}
}
catch (Exception e)
{
throw e;
}
return(user);
}
