public MainWindow() { InitializeComponent(); #region call service to test connectivity //// Create a Proxy Object to communicate with the wcf service. //NorthwindServiceContractClient proxy = new NorthwindServiceContractClient(); //// Call the Select Employeee Method of the service and handle the return. //NorthwindEmployee[] employees = proxy.SelectEmployees(); //// always close the proxy object //proxy.Close(); ////Display the Lastname of th First Employee in a messagebox //// MessageBox.Show("Last Name {0}", employees[0].LastName); //MessageBox.Show(employees[0].LastName); #endregion string[] titles = DataGateway.SelectEmployeeTitles(); foreach (string tl in titles) { combobox1.Items.Add(tl); } }
/// <summary> /// 判断表是否已存在 /// </summary> /// <param name="connString">普通用户</param> /// <param name="table"></param> /// <returns></returns> public static bool IsExists(ConnectString connString, string tableName) { string sql = $"select 1 from dba_tables where table_name = '{tableName}'"; object result = new DataGateway(OracleProvider.ManagedDataAccess).ExecuteScalar(connString, sql); return(result != null && Convert.ToInt16(result) == 1); }
/// <summary> /// 获取表的约束信息 /// </summary> /// <param name="connString"></param> /// <param name="tableName"></param> /// <returns></returns> public static IEnumerable <Constraint> GetConstraints(ConnectString connString, string tableName) { DataGateway gateway = new DataGateway(OracleProvider.ManagedDataAccess); string sql = "select owner, constraint_name, constraint_type, TABLE_NAME, r_constraint_name, delete_rule, " + "case when (status='ENABLED') then 1 else 0 end as enabled, " + "case when (index_name is not null) then 1 else 0 end as using_index " + $"from user_constraints where constraint_type!='C' and table_name='{tableName}'"; IEnumerable <Constraint> result = gateway.Query <Constraint>(connString, sql); sql = $"select * from USER_CONS_COLUMNS where table_name='{tableName}' order by column_name,position"; IEnumerable <ConstraintColumns> cols = gateway.Query <ConstraintColumns>(connString, sql); foreach (var con in result) { con.Columns = string.Join(",", cols.Where(item => item.Name == con.Name).OrderBy(item => item.Position).Select(item => item.ColumnName)); if (con.Type == "R") { con.RefConstraint = gateway.Query <ConstraintColumns>(connString, $"select * from USER_CONS_COLUMNS where constraint_name='{con.RefName}'").FirstOrDefault(); } } return(result); }
/// <summary> /// 用户是否存在 /// </summary> /// <param name="connString"></param> /// <param name="userName"></param> /// <returns></returns> public static bool IsExists(ConnectString connString, string userName) { string sql = $"select 1 from all_users where username='******'"; object result = new DataGateway(OracleProvider.ManagedDataAccess).ExecuteScalar(connString, sql); return(result != null && Convert.ToInt16(result) == 1); }
private void buttonEmployees_Click_1(object sender, RoutedEventArgs e) { EmployeeViewModel[] employees = DataGateway.SelectEmployees(); foreach (EmployeeViewModel emp in employees) { listboxEmployeData.Items.Add(emp.FullName); } }
public void SubmitBenefitInquiry(int employerId, int cchId) { DataGateway.ExecuteCommand( "270_CallConsoleApp", new { EmployerId = employerId, CCHID = cchId }, DataSource.Platform, employerId); }
public EVMInterpreter(byte[] byteCode) { m_byteCode = byteCode; m_pc = 0; m_memory = new List <byte>(); m_stack = new List <uint256>(); m_log = new List <EVMLog>(); m_storage = new Dictionary <uint256, uint256>(); edg = new EtherscanDataGateway(); }
private void ButtonInsertEmployee_Click_1(object sender, RoutedEventArgs e) { EmployeeViewModel emp = new EmployeeViewModel(); emp.FirstName = txtFirstName.Text; emp.LastName = txtLastName.Text; emp.Title = txtTitle.Text; emp.HomePhone = txtHomePhone.Text; DataGateway.InsertEmployee(emp); }
public async Task <HealthPlanSummary> GetHealthPlanSummaryAsync(int employerId, int cchId) { return(await DataGateway.QueryScalarAsync <HealthPlanSummary>( "p_GetHealthPlanSummary", new { CCHID = cchId }, DataSource.Employer, employerId )); }
private void combobox1_SelectionChanged_1(object sender, SelectionChangedEventArgs e) { listboxEmployeData.Items.Clear(); string title; title = combobox1.SelectedValue.ToString(); EmployeeViewModel[] employees = DataGateway.SelectEmployeesByTitle(title); foreach (EmployeeViewModel emp in employees) { listboxEmployeData.Items.Add(emp.FullName); } }
public GameConsole() { gameState = new GameState { Running = true }; var rewardsRepo = new RewardRepository(@".\Resources\Dat\rewards.csv"); var achievementsRepo = new AchievementRepository(@".\Resources\Dat\achievements.csv", gameState); var gameItemsRepo = new GameItemRepository(@".\Resources\Dat\gameItems.csv"); var storeInventoryRepo = new StoryInventoryRepository(@".\Resources\Dat\storeInventory.csv"); gateway = new DataGateway(rewardsRepo, gameItemsRepo, achievementsRepo, storeInventoryRepo); commandsGroup = new TopCommandGroupFactory().Build(); gameState.Lobby = new LobbyRoom(gameState, new[] { "Welcome to the Lobby" }, GameMode.Lobby, commandsGroup); gameState.Store = gameState.Store ?? new MinerStoreFactory(gameState, commandsGroup, gateway).Build(); gameState.ControlRoom = new ControlRoomFactory(gameState, commandsGroup).Build(); gameState.ClaimsOffice = new ClaimsOfficeRoomFactory(gameState, commandsGroup, gateway).Build(); gameState.SaveDirectory = @"c:\chipMiner\saves"; gameState.GameTime.Start(); IsVisible = true; IsFocused = true; StartGame(); hud = new HudConsole(gameState) { Position = new Point(0, 0) }; input = new InputConsole(this, gameState) { Position = new Point(1, 34) }; output = new OutputConsole(this, 83) { Position = new Point(1, 1) }; events = new GameEventsConsole(this, 83) { Position = new Point(85, 1) }; Children.Add(hud); Children.Add(input); Children.Add(output); Children.Add(events); Global.FocusedConsoles.Set(input); }
public MemberDetail GetKeyEmployeeInfo(int employerId, int cchId) { //var keyEmployeeInfo = DataGateway.Query( // "GetKeyEmployeeInfoByCchId", // new // { // CCHID = cchId // }, // DataSource.Employer, // employerId //); //return keyEmployeeInfo; MemberDetail keyEmployeeInfo = null; using (var connection = ConnectionFactory.Get(DataSource.Employer, employerId)) { try { connection.Open(); var multiple = connection.QueryMultiple( "GetKeyEmployeeInfoByCchId", new { CCHID = cchId }, commandType: CommandType.StoredProcedure); keyEmployeeInfo = multiple.Read <MemberDetail>().AsList().ToArray()[0]; keyEmployeeInfo.Dependents.AddRange(multiple.Read <DependentDetail>()); } catch (Exception ex) { DataGateway.LogError(ex); } finally { if (connection.State != ConnectionState.Closed) { connection.Close(); } } } return(keyEmployeeInfo); }
/// <summary> /// 获取表的详细信息(包括字段) /// </summary> /// <param name="connString">普通用户</param> /// <param name="tableName"></param> /// <returns></returns> public static Table GetTableDetails(ConnectString connString, string tableName) { string sql = "select t.object_id, t.OBJECT_NAME, p.tablespace_name, c.comments, t.created " + "from user_objects t, user_all_tables p, user_tab_comments c " + "where t.object_name= p.table_name and t.object_name= c.table_name " + $"and t.object_type = 'TABLE' and t.OBJECT_NAME = '{tableName}'"; Debug.WriteLine(sql); Table result = new DataGateway(OracleProvider.ManagedDataAccess).Query <Table>(connString, sql).FirstOrDefault(); if (result != null) { result.Columns = GetColumns(connString, tableName); } return(result); }
public ClaimsOfficeRoomFactory(GameState gameState, CommandsGroup baseCommandsGroup, DataGateway gateway) { _gateway = gateway; _gameState = gameState; _baseCommandsGroup = baseCommandsGroup; }
public GeneralController(ExploreCaliforniaContext context) { db = context; dataGateway = new DataGateway <T>(context); }
protected override void EstablishContext() { string connectionString = ConfigurationManager.ConnectionStrings["TestDb"].ConnectionString; _gateway = new DataGateway(connectionString); using (var dc = new TestDataRepositoryDataContext()) dc.spTruncate(); }
public LoanController() { DataGateway = new LoanGateway(); }
public BookController() { DataGateway = new BookGateway(); }
public MinerStoreFactory(GameState gameState, CommandsGroup baseCommandsGroup, DataGateway gateway) { _gateway = gateway; _gameState = gameState; _baseCommandsGroup = baseCommandsGroup; }
public DataController(IRedisCacheClient cacheClient) { rediscacheClient = cacheClient; dataGateway = new DataGateway(); }