public static bool ValidateUserNotExists(String clientId)
{
var dataProvider = DataProviderFactory.GetDataProvider();
var users = dataProvider.SelectByFilter <Users>($"Login = '******'");
return(!users.Any());
}
public ItemsControllerTests()
{
var webHostBuilder = new WebHostBuilder()
.UseStartup <Startup>();
server = new TestServer(webHostBuilder);
dataProvider = DataProviderFactory.GetDataProvider();
}
public static void CreateUser(String clientId, String clientSecret, String email)
{
var dataProvider = DataProviderFactory.GetDataProvider();
var user = new Users();
user.Email = email;
user.Login = clientId;
user.Password = HashPassword(clientSecret);
dataProvider.Insert(user);
}
public static bool DeleteItem(int itemId, int userId)
{
var dataProvider = DataProviderFactory.GetDataProvider();
var items = dataProvider.SelectByFilter <Items>(String.Format(IdFilter, userId, itemId));
if (!items.Any())
{
return(false);
}
dataProvider.DeleteById <Items>(itemId);
return(true);
}
public ServiceConfiguration GetInitialConfiguration()
{
var currencyDataReader = CurrencyDataReaderFactory.GetCurrencyDataReader(Bootstrapper.CurrencyDataAccessType);
var currencyDataWriter = CurrencyDataWriterFactory.GetCurrencyDataWriter(Bootstrapper.CurrencyDataAccessType);
return(new ServiceConfiguration
{
CurrencyProcessor = CurrencyProcessorFactory.GetCurrencyProcessor(Bootstrapper.CurrencyProcessorType, currencyDataReader, currencyDataWriter),
DataProvider = DataProviderFactory.GetDataProvider(Bootstrapper.DataProviderType),
CurrencyDataReader = currencyDataReader,
CurrencyDataWriter = currencyDataWriter
});
}
public static void InsertItem(int userId, String name, String description, int sort, String url)
{
var item = new Items();
item.Name = name;
item.Description = description;
item.Sort = sort;
item.Url = url;
item.UserId = userId;
var dataProvider = DataProviderFactory.GetDataProvider();
dataProvider.Insert(item);
}
public Startup(IHostingEnvironment env)
{
var builder = new ConfigurationBuilder()
.SetBasePath(env.ContentRootPath)
.AddJsonFile("appsettings.json", optional: true, reloadOnChange: true)
.AddJsonFile($"appsettings.{env.EnvironmentName}.json", optional: true)
.AddEnvironmentVariables();
Configuration = builder.Build();
AppRecoveryServer.Configuration.InitConfiguration(Configuration);
var provider = DataProviderFactory.GetDataProvider();
provider.CreateTables();
}
public static int ValidateUser(String clientId, String clientSecret)
{
var dataProvider = DataProviderFactory.GetDataProvider();
var users = dataProvider.SelectByFilter <Users>($"Login = '******' and Password = '******'");
if (!users.Any())
{
return(0);
}
else
{
return(users.Single().Id);
}
}
public static IDictionary <string, decimal> GetData(string id, DateTime startTime, DateTime stopTime, int timeSpanInMin = 5)
{
// id 由三部分按顺序组成，分别为组织机构ID、变量名称、变量类型，之间用'>'字符隔开。
string[] variableParams = id.Split('>');
// 检测参数是否有效
if (variableParams.Length != 3)
{
throw new ArgumentException("锚点提供的参数无效。id：" + id);
}
// 由简单工厂按变量类型实例化数据提供器
IDataProvider dataProvider = DataProviderFactory.GetDataProvider(id);
return(dataProvider.GetData(id, startTime, stopTime, timeSpanInMin));
}
public static bool UpdateItem(int itemId, int userId, String name, String description, int sort, String url)
{
var dataProvider = DataProviderFactory.GetDataProvider();
var items = dataProvider.SelectByFilter <Items>(String.Format(IdFilter, userId, itemId));
if (!items.Any())
{
return(false);
}
var item = items.Single();
item.Name = name;
item.Description = description;
item.Sort = sort;
item.Url = url;
dataProvider.UpdateById(item);
return(true);
}
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
DataProviderFactory.GetDataProvider(_dataSettings.DbProvider).UseDb(optionsBuilder, _dataSettings.ConnectionString);
base.OnConfiguring(optionsBuilder);
}
public static IEnumerable <Items> GetItems(int userId)
{
var dataProvider = DataProviderFactory.GetDataProvider();
return(dataProvider.SelectByFilter <Items>(String.Format(UserIdFilter, userId)));
}
