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