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