public JsonResponse ValidateId(string id)
{
try
{
_iDbHandler = new DbHandler();
if (IsIdLengthValid(id))
{
IsSequenceCorrect(id);
IsCitizenshipValid(_id.Citizenship);
IsDateFormatValid(_id.Date);
IsGenderTypeCorrect(_id.Gender);
ControlDigitTest(id);
}
if (_errorList.Count == 0)
{
_iDbHandler.SaveUserDetails(_userDetails);
return(new JsonResponse {
ErrorLists = _errorList, UserDetails = _userDetails, Valid = true
});
}
else
{
return(new JsonResponse {
ErrorLists = _errorList, UserDetails = null, Valid = false
});
}
}
catch (Exception ex)
{
Logger.Fatal(ex.Message);
throw;
}
}
private MonthExpenses()
{
_statsAndGraphs = new StatsAndGraphs();
_dBhandler = DbHandler.Instance;
Expenses = new ObservableCollection <ExpensesObj>();
CalcStats();
}
public IDbHandler CreateDatabase()
{
//var y = _configuration.GetSection("ConnectionStrings:ConnectionString:ProviderName").Value;
//var s = _configuration.GetSection("ConnectionStrings:ConnectionString:ConnectionString").Value;
IDbHandler database = null;
switch (connectionStringSettings.ProviderName.ToLower())
{
case "system.data.sqlclient":
database = new SqlDataAccess(connectionStringSettings.ConnectionString);
break;
case "system.data.oracleclient":
database = new OracleDataAccess(connectionStringSettings.ConnectionString);
break;
case "system.data.odbc":
database = new OracleDataAccess(connectionStringSettings.ConnectionString);
break;
}
//IDbHandler database = null;
//var z = _configuration.GetConnectionString("Default");
// database = new SqlDataAccess(_configuration.GetConnectionString("Default"));
return(database);
}
internal ObModelInfo SelectById(long obId)
{
//初始化
ObModelInfo om = new ObModelInfo();
IDbHandler dbh = om.CreateHandler(); //创建数据库操作句柄接口
//设置返回的实体字段，相当于EF的Select字段
dbh.SetFields(om.Fields); //om.Fields为所有字段
//dbh.SetFields(om.ObId, om.ObName, om.ObEnabled); //自定义返回的实体字段
//组装Where条件语句
dbh.Where(om.ObId.Equals(obId));
//执行查询
DataReader dr = dbh.Select();
//获取结果集方法一（自动关闭读取器）
om = dr.ReadFirst <ObModelInfo>();
//获取结果集方法二（手动关闭读取器，更灵活）
/*
* if (dr.Read())
* {
* dr.ReadTo(om);
* }
* else
* {
* om = null;
* }
* dr.Close();
*/
return(om);
}
public FruitMixer(IFruitProvider provider, IFruitPrompter prompter, IFruitPicker picker, IOutputService outputService, IDbHandler dbHandler)
{
_provider = provider;
_prompter = prompter;
_picker = picker;
_outputService = outputService;
_dbHandler = dbHandler;
}
public FruitMixer(IFruitProvider provider, IFruitPrompter prompter, IFruitPicker picker, IOutputService outputService, IDbHandler dbHandler)
{
_provider = provider;
_prompter = prompter;
_picker = picker;
_outputService = outputService;
_dbHandler = dbHandler;
}
//public DBManager(string connectionString)
//{
// dbFactory = new DataBaseHandlerFactory(connectionString);
// database = dbFactory.CreateDatabase();
// providerName = dbFactory.GetProviderName();
//}
public DBManager(IConfiguration configuration)
{
var y = configuration.GetSection("ConnectionStrings:ConnectionString:ProviderName").Value;
var s = configuration.GetSection("ConnectionStrings:ConnectionString:ConnectionString").Value;
dbFactory = new DataBaseHandlerFactory("ConnectionString", configuration);
database = dbFactory.CreateDatabase();
providerName = dbFactory.GetProviderName();
}
public Importer(ILogger logger, IDbHandler dbHandler)
{
_logger = logger;
_dbHandler = dbHandler;
Parser parser = new Parser(logger);
if (Config.RecordTicksToFile)
{
_fileHandler = new FileHandler(_logger);
}
}
// Chathub the method
public ChatHub(IChat chat, IDbHandler dbHandler)
{
if (chat == null) {
throw new ArgumentNullException("chat");
}
_chat = chat;
if (dbHandler == null) {
throw new ArgumentNullException("dbHandler");
}
_dbHandler = dbHandler;
}
public CmcCommunicator(ILogger logger, IDbHandler dbHandler) : base(logger, dbHandler)
{
_logger = logger;
_dbHandler = dbHandler;
_logger.Info(" Starting CMC Importer...");
_logger.Info("=================================");
_logger.Info("CMC Importer Started Successfully");
_logger.Info("=================================\n");
_logger.Info("Loading configuration...");
Config.LoadConfiguration(_logger);
parser = new Parser(logger);
}
public ActionResult Index()
{
try
{
_IDbHandler = new DbHandler();
var results = _IDbHandler.GetUserDetails();
return(Json(results, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
Logger.Fatal(ex.Message);
throw;
}
}
internal ObModelInfo SelectByName(string obName)
{
ObModelInfo om = new ObModelInfo();
IDbHandler dbh = om.CreateHandler();
dbh.SetFields(om.Fields);
dbh.Where(om.ObName.Like(obName));
DataReader dr = dbh.Select();
om = dr.ReadFirst <ObModelInfo>();
return(om);
}
internal ObModelInfo SelectByUserId(long obId, long userId)
{
ObModelInfo om = new ObModelInfo();
IDbHandler dbh = om.CreateHandler();
dbh.SetFields(om.Fields);
dbh.Where(om.ObId.Equals(obId));
dbh.Where(om.UserId.Equals(userId));
DataReader dr = dbh.Select();
om = dr.ReadFirst <ObModelInfo>();
return(om);
}
//string Source { get; set; }
#endregion
public BnbCommunicator(ILogger logger, IDbHandler dbHandler, IRabbitHandler rabbit, IFileHandler fileHandler) : base(logger, dbHandler)
{
_logger = logger;
_dbHandler = dbHandler;
_rabbit = rabbit;
_fileHandler = fileHandler;
StartupComplete = false;
_logger.Info(" Starting Binance Importer...");
_logger.Info("=====================================");
_logger.Info("Binance Importer Started Successfully");
_logger.Info("=====================================\n");
_logger.Info("Loading configuration...");
Config.LoadConfiguration(_logger);
parser = new Parser(logger);
_logger.Info("Parser Initialized Successfully");
metaData = new MetaData();
_logger.Info("Metadata Lists Initialized Successfully");
CoinPairs = new Dictionary <string, CoinPair>();
_rabbit.Connect();
}
public FitnessPickerService(IDbHandler dbHandler) : base(dbHandler)
{
}
public ContactHandler(IDbHandler dbHandler)
{
_dbHandler = dbHandler;
}
public FitnessPickerService(IDbHandler dbHandler)
: base(dbHandler)
{
}
public MonitorController(IDbHandler dbHandler)
{
DbHandler = dbHandler;
}
public VisualCronHubHandler(IDbHandler dbHandler)
{
VisualCronHubContext = GlobalHost.ConnectionManager.GetHubContext<VisualCronHubHandler>();
DbHandler = dbHandler;
}
internal List <ObModelInfo> SelectList(ObModelQuery query, out ListAttrInfo listAttr)
{
//初始化
ObModelInfo om = new ObModelInfo();
IDbHandler dbh = om.CreateHandler(); //创建数据库操作句柄接口
dbh.SetFields(om.Fields); //设置返回的实体字段
//[BEGIN]::组装Where条件语句
//组装日期时间条件
string startTime; //开始时间
string endTime; //结束时间
string dtFormat = "yyyy-MM-dd HH:mm:ss";
if (!query.StartTime.IsNull && (!query.StartTime.IsMinValue))
{
startTime = query.StartTime.Value.ToString(dtFormat);
dbh.Where(om.ObCreated.Compare(">=", startTime));
}
if (!query.EndTime.IsNull && (!query.EndTime.IsMinValue))
{
endTime = query.EndTime.Value.ToString(dtFormat);
dbh.Where(om.ObCreated.Compare("<=", endTime));
}
//组装记录ID串条件
if (!query.Ids.IsNull && query.Ids.Count > 0)
{
dbh.Where(om.ObId.In(query.Ids.Value));
}
//组装关键字条件
if (!query.Keyword.IsNullOrWhiteSpace)
{
dbh.Where(om.ObName.Like(query.Keyword.Value));
}
//组装复合条件（如果需要）
/*
* if (!query.Keyword.IsNullOrWhiteSpace)
* {
* string keyword = query.Keyword.Value;
* CompoundCondition ccd = new CompoundCondition(); //复合条件类
* ccd.And(om.ObName.Like(keyword))
* .Or(om.ObDescri.Like(keyword));
* dbh.Where(ccd);
* }
*/
//
if (!query.Level.IsNull)
{
dbh.Where(om.ObLevel.Equals(query.Level));
}
//组装记录状态条件
if (!query.Enabled.IsNull)
{
dbh.Where(om.ObEnabled.Equals(query.Enabled.Value));
}
//组装JOIN条件
if (!query.GetRelation.IsTrue())
{
ObRelationInfo ori = new ObRelationInfo();
dbh.SetFields(ori.Fields); //设置返回的关联实体字段
dbh.Join(ori).On(om.ObId.Equals(ori.ObId)); //关联条件
}
//组装排序条件（放在Where子句最后，分页时，必须有OrderBy）
if (!query.OrderBy.IsNull && query.OrderBy.Count > 0)
{
OrderInfo[] oiArray = query.OrderBy.GetArray();
//拼装的order by条件，case条件字段值需要和ObModelQuery查询实体的OrderByFields属性一致
foreach (OrderInfo oi in oiArray)
{
switch (oi.FieldAlias)
{
case "obLevel":
dbh.OrderBy(om.ObLevel, oi.OrderType);
break;
case "obName":
dbh.OrderBy(om.ObName, oi.OrderType);
break;
case "obEnabled":
dbh.OrderBy(om.ObEnabled, oi.OrderType);
break;
case "obMoney":
dbh.OrderBy(om.ObMoney, oi.OrderType);
break;
case "obScore":
dbh.OrderBy(om.ObScore, oi.OrderType);
break;
case "obCreated":
dbh.OrderBy(om.ObCreated, oi.OrderType);
break;
case "obId":
default:
dbh.OrderBy(om.ObId, oi.OrderType);
break;
}
}
}
else
{
//默认排序条件
dbh.OrderBy(om.ObId, OrderType.DESC);
}
//[END]::组装Where条件语句
List <ObModelInfo> list = new List <ObModelInfo>();
DataReader dr = dbh.Select(query, out listAttr);
//获取结果集方法一（自动关闭读取器）
list = dr.ReadList <ObModelInfo>();
//获取结果集方法二（手动关闭读取器，更灵活）
while (dr.Read())
{
ObModelInfo ei = new ObModelInfo();
dr.ReadTo(ei);
list.Add(ei);
}
dr.Close();
return(list);
}
protected SuperPicker(IDbHandler dbHandler)
{
_dbHandler = dbHandler;
}
public OutputService(IDbHandler dbHandler)
{
_dbHandler = dbHandler;
}
public CategoryController(IDbHandler ticket, ILogger <CategoryController> logger)
{
_dbHandler = ticket;
_logger = logger;
}
public ConfigHandler(IDbHandler dbHandler)
{
_dbHandler = dbHandler;
}
public ReadController(IDbHandler dbHandler)
{
_dbHandler = dbHandler;
}
public OutputService(IDbHandler dbHandler)
{
_dbHandler = dbHandler;
}
public ReviewController(IDbHandler dbHandler)
{
_dbHandler = dbHandler;
}
public ProductHandler(IProductsRepo prodRep)
{
_prodRepo = prodRep;
_productOptionHandler = prodRep.GetProductOptionHandler();
_dbHandler = prodRep.GetDbHandler();
}
public ExactPickerService(IDbHandler dbHandler) : base(dbHandler)
{
}
public ProfileController(IDbHandler db)
{
this.Db = db;
}
public WriteController(IDbHandler dbHandler)
{
_dbHandler = dbHandler;
}
public TicketController(IDbHandler ticket, ILogger <CategoryController> logger, IConfiguration config)
{
_dbHandler = ticket;
_logger = logger;
_configuration = config;
}
public ExactPickerService(IDbHandler dbHandler)
: base(dbHandler)
{
}
public HealthController(IDbHandler ticket, ILogger <HealthController> logger)
{
_ticket = ticket;
_logger = logger;
}
public HomeController(IDbHandler dbHandler)
{
_dbHandler = dbHandler;
}
public ApiController(IDbHandler dbHandler, IConfiguration configuration)
{
_dbHandler = dbHandler;
_configuration = configuration;
}
protected SuperPicker(IDbHandler dbHandler)
{
_dbHandler = dbHandler;
}
