public void Insert(User user)
{
var sql = $@"INSERT INTO {CoreCommon.Table_User}({nameof(User.UserID)},{nameof(User.Password)},{nameof(User.Salt)})
VALUES('{user.UserID}','{user.Password}','{user.Salt}'); ";
SQLiteCore.ExecuteNonQuery(sql);
}
public void Insert(UserSecret model)
{
model.Id = Guid.NewGuid().ToString().Replace("-", "");
var sql = $@"INSERT INTO {CoreCommon.Table_Secret}({nameof(UserSecret.Id)},{nameof(UserSecret.UserID)},{nameof(UserSecret.Password)},{nameof(UserSecret.Salt)},{nameof(UserSecret.Type)},{nameof(UserSecret.Remark)})
VALUES('{model.Id}','{model.UserID}','{model.Password}','{model.Salt}','{model.Type}','{model.Remark}'); ";
SQLiteCore.ExecuteNonQuery(sql);
}
public void Update(UserSecret model)
{
var sql = $@"UPDATE {CoreCommon.Table_Secret} SET
{nameof(UserSecret.UserID)} = '{model.UserID}',
{nameof(UserSecret.Password)} = '{model.Password}',
{nameof(UserSecret.Salt)} = '{model.Salt}',
{nameof(UserSecret.Type)} = '{model.Type}',
{nameof(UserSecret.Remark)} = '{model.Remark}'
WHERE {nameof(UserSecret.Id)} = '{model.Id}'
";
SQLiteCore.ExecuteNonQuery(sql);
}
public void Delete(string id)
{
var sql = $" DELETE FROM {CoreCommon.Table_Secret} WHERE {nameof(UserSecret.Id)} = '{id}'";
SQLiteCore.ExecuteNonQuery(sql);
}
