public override void LoadData(DataRow CurrentDataRow, IDbConnection conn) { IsLoaded = false; CurrentFRDBase = (GISADataset.FRDBaseRow)CurrentDataRow; IsLoaded = true; }
private static void _addRptParams(IDbConnection conn, String rptUID, Params prms, String userUID, String remoteIP) { var v_prms = new Params(); v_prms.SetValue("p_rpt_uid", rptUID); var v_sql = "begin xlr.clear_rparams(:p_rpt_uid); end;"; SQLCmd.ExecuteScript(conn, v_sql, v_prms, 120); v_sql = "begin xlr.add_rparam(:p_rpt_uid, :p_prm_name, :p_prm_type, :p_prm_val, :p_usr_uid, :p_remote_ip); end;"; foreach (var v_prm in prms) { v_prms.SetValue("p_prm_name", v_prm.Name); String v_prmValue; var v_prmTypeStr = "A"; if (v_prm.Value != null) { var v_prmType = v_prm.ParamType ?? v_prm.Value.GetType(); if (Utl.TypeIsNumeric(v_prmType)) { v_prmTypeStr = "N"; v_prmValue = "" + v_prm.Value; v_prmValue = v_prmValue.Replace(",", "."); } else if (v_prmType == typeof(DateTime)) { v_prmTypeStr = "D"; v_prmValue = ((DateTime)v_prm.Value).ToString("yyyy.MM.dd HH:mm:ss"); } else v_prmValue = "" + v_prm.Value; } else continue; v_prms.SetValue("p_prm_type", v_prmTypeStr); v_prms.SetValue("p_prm_val", v_prmValue); v_prms.SetValue("p_usr_uid", userUID); v_prms.SetValue("p_remote_ip", remoteIP); SQLCmd.ExecuteScript(conn, v_sql, v_prms, 120); } }
public void ExecuteWithTransaction(IDbConnection db, IDbTransaction transaction) { db.Execute(@"IF @EndPointType = 3 BEGIN UPDATE dbo.Company SET QueueId = @QueueId WHERE Company.CompanyId = @EndPointId END ELSE IF @EndPointType = 0 BEGIN UPDATE dbo.Agent SET QueueId = @QueueId WHERE Agent.AgentId = @EndPointId END ELSE IF @EndPointType = 1 BEGIN UPDATE dbo.Team SET QueueId = @QueueId WHERE Team.TeamId = @EndPointId END ELSE IF @EndPointType = 2 BEGIN UPDATE dbo.Department SET QueueId = @QueueId WHERE Department.DepartmentId = @EndPointId END", new { EndPointType = _endPoint.EndPointType, EndPointId = _endPoint.EndpointId, QueueId = _endPoint.QueueId }, transaction); }
private static DateTimeObject InsertAndSelectDateTime(IDbConnection db, DateTime dateTime) { db.DropAndCreateTable<DateTimeObject>(); db.Insert(new DateTimeObject {Test = dateTime}); var x = db.Select<DateTimeObject>().First(); return x; }
public void TestFixtureSetUp() { db = base.OpenDbConnection(); db.DropAndCreateTable<Person>(); db.InsertAll(Person.Rockstars); }
private static void DisposeCommandAndReader(IDbConnection connection, IDbCommand command, IDataReader reader) { using (connection) using (command) using (reader) { /* NoOp */ } }
public WellKnownCore(IDbConnection connection) : base(PATH) { _connection = connection; Get["/", runAsync: true] = GetCore; }
public RuntimeContext(IDbConnection connection, IDbTransaction transaction, IDbCommandExecutor executor, IProviderMetadata providerMetadata, IMigrationStepMetadata stepMetadata) : base(providerMetadata, stepMetadata) { _connection = connection; _transaction = transaction; _executor = executor; }
private static IList<string> CreateCommandStringsFromTemplate(IDbConnection connection, string template) { using (var command = connection.CreateCommand()) { try { var commandStrings = new List<string>(); command.CommandText = template; using (var reader = command.ExecuteReader(CommandBehavior.SingleResult)) { while (reader.Read()) { commandStrings.Add(reader.GetString(0)); } } return commandStrings; } catch (Exception exception) { Console.Error.WriteLine("Command \"{0}\" produced an error:", command.CommandText); Console.Error.WriteLine(exception.Message); return new List<string>(); } } }
public void Add(IDbConnection connection) { lock (connections) { connections[connection.ConnectionString] = new WeakReference(connection); } }
public void SetUp() { SuppressIfOracle("SQL Server tests"); db = CreateSqlServerDbFactory().OpenDbConnection(); db.DropAndCreateTable<Person>(); db.DropAndCreateTable<PersonWithAutoId>(); }
/// <summary> /// Initializes a new instance of the <see cref="TShockAPI.DB.BanManager"/> class. /// </summary> /// <param name="db">A valid connection to the TShock database</param> public BanManager(IDbConnection db) { database = db; var table = new SqlTable("Bans", new SqlColumn("IP", MySqlDbType.String, 16) {Primary = true}, new SqlColumn("Name", MySqlDbType.Text), new SqlColumn("UUID", MySqlDbType.Text), new SqlColumn("Reason", MySqlDbType.Text), new SqlColumn("BanningUser", MySqlDbType.Text), new SqlColumn("Date", MySqlDbType.Text), new SqlColumn("Expiration", MySqlDbType.Text) ); var creator = new SqlTableCreator(db, db.GetSqlType() == SqlType.Sqlite ? (IQueryBuilder) new SqliteQueryCreator() : new MysqlQueryCreator()); try { creator.EnsureTableStructure(table); } catch (DllNotFoundException) { System.Console.WriteLine("Possible problem with your database - is Sqlite3.dll present?"); throw new Exception("Could not find a database library (probably Sqlite3.dll)"); } }
internal IDbCommand Create(IDbConnection connection, CommandBuilder commandBuilder) { var command = connection.CreateCommand(); command.CommandText = commandBuilder.Text; PrepareCommand(commandBuilder, command); return command; }
protected override IList<IDataTableColumn> ReadColumns(IDbConnection connectionString, string databaseName) { const string sql = @" select 'Foo' ""TableSchema"" , rf.RDB$RELATION_NAME ""TableName"" , rf.RDB$FIELD_NAME ""ColumnName"" , case when rf.RDB$NULL_FLAG is null then 1 else 0 end ""Nullable"" , t.RDB$TYPE_NAME ""Type"" , case when f.RDB$COMPUTED_SOURCE is null then 0 else 1 end ""Generated"" , case when exists(select * from RDB$RELATION_CONSTRAINTS rc inner join RDB$INDEX_SEGMENTS xs on xs.RDB$INDEX_NAME = rc.RDB$INDEX_NAME where rc.RDB$RELATION_NAME = rf.RDB$RELATION_NAME and xs.RDB$FIELD_NAME = rf.RDB$FIELD_NAME and rc.RDB$CONSTRAINT_TYPE = 'PRIMARY KEY') then 1 else 0 end ""PrimaryKey"" , f.RDB$FIELD_LENGTH ""Length"" , f.RDB$FIELD_PRECISION ""Precision"" , f.RDB$FIELD_SCALE ""Scale"" , rf.RDB$DEFAULT_VALUE ""DefaultValue"" from RDB$RELATION_FIELDS rf inner join RDB$FIELDS f on f.RDB$FIELD_NAME = rf.RDB$FIELD_SOURCE inner join RDB$TYPES t on t.RDB$TYPE = f.RDB$FIELD_TYPE and t.RDB$FIELD_NAME = 'RDB$FIELD_TYPE' where rf.RDB$SYSTEM_FLAG = 0 order by rf.RDB$RELATION_NAME, rf.RDB$FIELD_POSITION "; return DataCommand.Find<IDataTableColumn>(connectionString, sql, "@db", databaseName, ReadColumn); }
public static int AffectData(string TSQL, IDbConnection myConn, IDbTransaction myTrans, List<IDbDataParameter> myParams) { bool mustClose = false; if (myConn == null) { mustClose = true; myConn = clsConn.getConnOLE(); } if (myConn.State != ConnectionState.Open) myConn.Open(); OleDbCommand myCMD = new OleDbCommand(); // myCMD.Connection = myConn as OleDbConnection; if (myTrans != null) myCMD.Transaction = myTrans as OleDbTransaction; // myCMD.CommandType = CommandType.Text; myCMD.CommandText = TSQL; myCMD.CommandTimeout = 180000;//3 phut // if (myParams != null) AttachParameters(myCMD, myParams); int CMDResult = myCMD.ExecuteNonQuery(); // if (mustClose) myConn.Close(); return CMDResult; }
public static bool CheckExist(string TSQL, IDbConnection myConn) { //Hàm checkexist này còn dùng cho cả đối với trường hợp check duplicate //Nếu là duplicate sẽ có dạng: SELECT COUNT(*) FROM TABLE WHERE ID=@ID AND xID<>@xID //Nếu là exist sẽ có dạng: SELECT COUNT(*) FROM TABLE WHERE ID=@ID return CheckExist(TSQL, myConn, null); }
public IDbConnection Open() { if (++this.openCount != 1) return this.connection; this.connection = new SqlConnection(this.connectionString); this.connection.Open(); return connection; }
public static ResponsePackage Save(RequestObjectPackage<EventTypeModel> request, IDbConnection connectionID, IDbTransaction transactionID) { EventTypeModel obj = request.requestData; string sql = string.Empty; if (obj.ID > 0) { sql = string.Format( " update EVENT_TYPES set NAME = {0} " + Environment.NewLine + " where ID = {1} returning ID", SQL.FromString(obj.name), SQL.FromNumber(obj.ID) ); } else { sql = string.Format( " insert into EVENT_TYPES (NAME) " + Environment.NewLine + " values ({0}) returning ID", SQL.FromString(obj.name) ); } ResponseTablePackage res = DBUtils.ExecuteSQL(sql, connectionID, true, transactionID); res.ThrowExceptionIfError(); return new ResponsePackage() { resultID = res.resultID }; }
/// <summary> /// Initializes a new instance of the <see cref="DifferentDatabaseScope"/> class. /// </summary> /// <param name="connection">The connection.</param> /// <param name="flushAction">The flush action.</param> public DifferentDatabaseScope(IDbConnection connection, FlushAction flushAction) : base(flushAction, SessionScopeType.Custom) { if (connection == null) throw new ArgumentNullException("connection"); this.connection = connection; ISessionScope parentScope = ScopeUtil.FindPreviousScope(this, true); if (parentScope != null) { if (parentScope.ScopeType == SessionScopeType.Simple) { parentSimpleScope = (SessionScope) parentScope; } else if (parentScope.ScopeType == SessionScopeType.Transactional) { parentTransactionScope = (TransactionScope) parentScope; parentTransactionScope.OnTransactionCompleted += OnTransactionCompleted; } else { // Not supported? } } }
public MyWorldDbAccess() { var config = Store.config; /* Params: Host, port, database, user, password */ conn = new MySqlConnection("Server=" + config.dbParams.Host + ";" + "Database=" + config.dbParams.DatabaseName + ";" + "User ID=" + config.dbParams.Username + ";" + "Password="******";" + "Pooling=false;"); conn.Open(); }
public List<MTableDesc> GetTableList(IDbConnection conn, string creater) { string strSql = @"select NAME, CREATOR,CTIME,REMARKS from sysibm.systables where type='T' "; if (!string.IsNullOrEmpty(creater)) { strSql += string.Format("and creator='{0}'", creater); } DB2Command cmd = new DB2Command(strSql, (DB2Connection)conn); List<MTableDesc> ret = new List<MTableDesc>(); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { MTableDesc model = new MTableDesc(); model.TableName = reader["NAME"] == DBNull.Value ? string.Empty : reader["NAME"].ToString(); model.Creator = reader["CREATOR"] == DBNull.Value ? string.Empty : reader["CREATOR"].ToString(); model.CreateDateTime = reader["CTIME"] == DBNull.Value ? DateTime.Parse("1990-01-01") : Convert.ToDateTime(reader["CTIME"].ToString()); model.Remarks = reader["REMARKS"] == DBNull.Value ? string.Empty : reader["REMARKS"].ToString(); ret.Add(model); } } return ret; }
public static List<MeetingRoomCheckin> List(IDbConnection db, string email, long day) { using (IDbCommand command = db.CreateCommand()) { command.CommandText = "select id, day, timestamp, _user, _meetingroom, _booking form checkin where _user = @Email and day = @Day order by timestamp"; List<MeetingRoomCheckin> MRC = new List<MeetingRoomCheckin>(); IDbDataParameter p = command.CreateParameter(); p.ParameterName = "@Email"; p.Value = email; command.Parameters.Add(p); IDbDataParameter p2 = command.CreateParameter(); p2 = command.CreateParameter(); p2.ParameterName = "@Day"; p2.Value = day; command.Parameters.Add(p2); using (IDataReader reader = command.ExecuteReader()) { while (reader.Read()) { MRC.Add(new MeetingRoomCheckin(reader)); } return MRC; } } }
public Result<customer_account> Login(IDbConnection db, string userName, string pwd, IPAddress ip) { string userNameLC = userName.ToLower(); var loginInfo = db.Query<customer_login_password>("SELECT * FROM customer_login_password WHERE lower(username)=@userName OR lower(email)=@userName ", new { userName = userNameLC }).FirstOrDefault(); if (loginInfo == null || string.Compare(loginInfo.unhashed_password, pwd, StringComparison.OrdinalIgnoreCase) != 0) { return Result<customer_account>.Null(ErrorCodes.InvalidUserNameOrPassword); } var user = GetCustomerById(db, loginInfo.customer_account_id); int id = user.Data.id; // Change country code only IF the database has not store this value before // if (string.IsNullOrEmpty(user.Data.country_code) || string.IsNullOrEmpty(user.Data.country_name)) { ip.GetCountryCode(c => user.Data.country_code = c, n => user.Data.country_name = n); } // TODO: Update user.Data.last_login_at = DateTime.UtcNow; db.Execute("UPDATE customer_account SET last_login_at=@last_login_at, country_code=@country_code, country_name=@country_name", user.Data); return user; }
/// <summary>Instancia a DbFactory "setando a string de conexao" /// </summary> public DAOFactory(string connectionStringValue, string provider) { AppSettingsReader apps = new AppSettingsReader(); objProvider = DbProviderFactories.GetFactory(provider); connectionString = connectionStringValue; objConn = objProvider.CreateConnection(); }
public BebidasCalientesView(Label labelTotalMainWindow,Button botonNP) : base(Gtk.WindowType.Toplevel) { this.Build (); labelBebidasCalientes.Markup = "<span size='xx-large' weight='bold'>Bebidas Calientes</span>"; botonNuevoPedidoMainWindow = botonNP; totalMainWindow = labelTotalMainWindow; dbConnection = ApplicationContext.Instance.DbConnection; //hacer la consulta bd IDbCommand dbCommand = dbConnection.CreateCommand (); dbCommand.CommandText = "select * from bebidascalientes "; IDataReader dataReader = dbCommand.ExecuteReader (); //Aquí creamos un objeto de la clase RellenarTreeView y le pasamos a la clase el treeView y el dataReader RellenarTreeView rellenar =new RellenarTreeView(); rellenar.llenarTreeView(treeView, dataReader); //recogemos el listStore que usamos en la clase RellenarTreeView, para ser usada en los los métodos en esa clase listStore = rellenar.get_ListStore(); dataReader.Close (); }
/// <summary> /// Проверить возможность удаления компонента /// </summary> /// <param name="request">бъект-оболочка RequestPackage, содержащая в поле requestID ID компонента</param> /// <param name="connectionID">Объект подключения к базе данных</param> /// <returns>Объект-оболочка ResponsePackagе</returns> public ResponsePackage CheckDeleteControl(RequestPackage request, IDbConnection connectionID, IDbTransaction transactionID) { string sql = string.Format( " select id from CONTROL_QUERY_MAPPING where control_id = {0} " + " union " + " select id from FORM_IN_PARAMETERS where control_id = {0} " + " union " + " select id from FORM_OUT_PARAMETERS where control_id = {0} " + " union " + " select id from ACTION_PARAMETERS where control_id = {0} " + " union " + " select id from QUERY_QUERY_IN_PARAMETER where control_id = {0} ", request.requestID ); ResponseTablePackage res = DBUtils.OpenSQL(sql, connectionID, transactionID); res.ThrowExceptionIfError(); if (res.resultData.Rows.Count > 0) { return new ResponsePackage() { resultCode = -1, resultMessage = "Удаление компонента невозможно. Проверьте все ссылки на него." }; } else { return new ResponsePackage() { resultCode = 0, resultMessage = "Удаление возможно." }; } }
public List<MColumn> GetColumnList(IDbConnection conn, string tableName) { string sql = string.Format(@"SELECT NAME,TBNAME,TBCREATOR,REMARKS,COLTYPE,LENGTH, NULLS,DEFAULT,KEYSEQ FROM sysibm.syscolumns where tbname ='{0}'", tableName); DB2Command cmd = new DB2Command(sql, (DB2Connection)conn); List<MColumn> ret = new List<MColumn>(); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { MColumn model = new MColumn(); model.ColumnName = DBUtil.GetDBValueStr(reader, "NAME"); model.Creator = DBUtil.GetDBValueStr(reader, "TBCREATOR"); model.Remarks = DBUtil.GetDBValueStr(reader, "REMARKS"); model.ColType = DBUtil.GetDBValueStr(reader, "COLTYPE"); model.Length = DBUtil.GetDBValueInt(reader, "LENGTH"); model.IsNullable = DBUtil.GetDBValueBool(reader, "NULLS"); model.DefaultValue = DBUtil.GetDBValueStr(reader, "DEFAULT"); model.KeySeq = DBUtil.GetDBValueInt(reader, "KEYSEQ"); ret.Add(model); } } return ret; }
protected override bool TryPrepareValue(IDbConnection connection, ColumnMapper columnMapper, TableInfo table, string columnName, ref object value) { //we insert tenant as suspended so it can't be accessed before restore operation is finished if (table.Name.Equals("tenants_tenants", StringComparison.InvariantCultureIgnoreCase) && columnName.Equals("status", StringComparison.InvariantCultureIgnoreCase)) { value = (int)TenantStatus.Restoring; return true; } if (table.Name.Equals("tenants_quotarow", StringComparison.InvariantCultureIgnoreCase) && columnName.Equals("last_modified", StringComparison.InvariantCultureIgnoreCase)) { value = DateTime.UtcNow; return true; } if ((table.Name == "core_user" || table.Name == "core_group") && columnName == "last_modified") { value = DateTime.UtcNow.AddMinutes(2); return true; } return base.TryPrepareValue(connection, columnMapper, table, columnName, ref value); }
public void Setup() { _connectionString = ConfigurationManager.ConnectionStrings["Database"].ConnectionString; var dbFactory = new OrmLiteConnectionFactory(_connectionString, SqlServerDialect.Provider); _connection = dbFactory.Open(); _connection.DropAndCreateTable<AzureTraceMessage>(); }
public bool RemoveEmpComDeptDetail(IDbConnection conn, IDbTransaction trx, int emp_ref_id) { Dac_EmpComDeptDetails empComDeptDetail = new Dac_EmpComDeptDetails(); return(empComDeptDetail.RemoveEmpComDeptDetail(conn, trx, emp_ref_id)); }
/// <inheritdoc/> public override InsightBulkCopyOptions GetSupportedBulkCopyOptions(IDbConnection connection) { return(InsightBulkCopyOptions.UseInternalTransaction); }
public ServiceFrecuencyRepository(IDbConnection connection) { this.connection = connection; }
public SQLiteProcessor(IDbConnection connection, IMigrationGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options, IDbFactory factory) : base(connection, factory, generator, announcer, options) { }
public ATMRepository() { _db = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString); }
private void Page_Load(object sender, System.EventArgs e) { SetPageTitle(L10n.Term(".moduleList." + m_sMODULE)); // 06/04/2006 Paul. Visibility is already controlled by the ASPX page, but it is probably a good idea to skip the load. this.Visible = (SplendidCRM.Security.GetUserAccess(m_sMODULE, "view") >= 0); if ( !this.Visible ) return; ctlDetailButtons.Visible = Security.IS_ADMIN; tblMain.Visible = Security.IS_ADMIN; try { gID = Sql.ToGuid(Request["ID"]); // 11/28/2005 Paul. We must always populate the table, otherwise it will disappear during event processing. //if ( !IsPostBack ) { if ( !Sql.IsEmptyGuid(gID) ) { DbProviderFactory dbf = DbProviderFactories.GetFactory(); using ( IDbConnection con = dbf.CreateConnection() ) { con.Open(); string sSQL ; sSQL = "select count(*) " + ControlChars.CrLf + " from vwFORUMS_THREADS " + ControlChars.CrLf + " where FORUM_ID = @FORUM_ID" + ControlChars.CrLf; using ( IDbCommand cmd = con.CreateCommand() ) { cmd.CommandText = sSQL; Sql.AddParameter(cmd, "@FORUM_ID", gID); // 07/17/2007 Paul. Only show delete button if there are no threads. ctlDetailButtons.ShowDelete = Sql.ToInteger(cmd.ExecuteScalar()) == 0; } sSQL = "select * " + ControlChars.CrLf + " from vwFORUMS_Edit" + ControlChars.CrLf; using ( IDbCommand cmd = con.CreateCommand() ) { cmd.CommandText = sSQL; // 11/24/2006 Paul. Use new Security.Filter() function to apply Team and ACL security rules. Security.Filter(cmd, m_sMODULE, "view"); Sql.AppendParameter(cmd, gID, "ID", false); if ( bDebug ) RegisterClientScriptBlock("SQLCode", Sql.ClientScriptBlock(cmd)); using ( IDataReader rdr = cmd.ExecuteReader(CommandBehavior.SingleRow) ) { if ( rdr.Read() ) { ctlModuleHeader.Title = Sql.ToString(rdr["TITLE"]); SetPageTitle(L10n.Term(".moduleList." + m_sMODULE) + " - " + ctlModuleHeader.Title); Utils.UpdateTracker(Page, m_sMODULE, gID, ctlModuleHeader.Title); this.AppendDetailViewFields(m_sMODULE + ".DetailView", tblMain, rdr); } else { // 11/25/2006 Paul. If item is not visible, then don't show its sub panel either. plcSubPanel.Visible = false; ctlDetailButtons.DisableAll(); ctlDetailButtons.ErrorText = L10n.Term("ACL.LBL_NO_ACCESS"); } } } } } } // 06/09/2006 Paul. Remove data binding in the user controls. Binding is required, but only do so in the ASPX pages. //Page.DataBind(); } catch(Exception ex) { SplendidError.SystemError(new StackTrace(true).GetFrame(0), ex); ctlDetailButtons.ErrorText = ex.Message; } }
public ListResponse <MyRow> List(IDbConnection connection, ListRequest request) { return(new MyRepository().List(connection, request)); }
public RetrieveResponse <MyRow> Retrieve(IDbConnection connection, RetrieveRequest request) { return(new MyRepository().Retrieve(connection, request)); }
public ChildAotInsertionService(IServiceProvider services, IDbConnection db) { this.db = db; this.services = services; }
/// <summary> /// Returns SQL that queries a table for the schema only, no rows. /// </summary> /// <param name="connection">The connection to use.</param> /// <param name="tableName">The name of the table to query.</param> /// <returns>SQL that queries a table for the schema only, no rows.</returns> public override string GetTableSchemaSql(IDbConnection connection, string tableName) { return(String.Format(CultureInfo.InvariantCulture, "SELECT * FROM {0} WHERE rownum = 0", tableName)); }
public void SetUp() { db = appHost.TryResolve <IDbConnectionFactory>().OpenDbConnection(); db.DropAndCreateTable <Reqstar>(); db.Insert(ReqstarsService.SeedData); }
private void Page_Load(object sender, System.EventArgs e) { SetPageTitle(L10n.Term("Products.LBL_LIST_FORM_TITLE")); try { DbProviderFactory dbf = DbProviderFactories.GetFactory(); using (IDbConnection con = dbf.CreateConnection()) { string sSQL; sSQL = "select * " + ControlChars.CrLf + " from vwPRODUCTS_List" + ControlChars.CrLf; using (IDbCommand cmd = con.CreateCommand()) { cmd.CommandText = sSQL; // 11/24/2006 Paul. Use new Security.Filter() function to apply Team and ACL security rules. Security.Filter(cmd, "Products", "list"); ctlSearchView.SqlSearchClause(cmd); Guid gACCOUNT_ID = Sql.ToGuid(Request["ACCOUNT_ID"]); if (!Sql.IsEmptyGuid(gACCOUNT_ID)) { Sql.AppendParameter(cmd, gACCOUNT_ID, "ACCOUNT_ID"); } if (bDebug) { Page.ClientScript.RegisterClientScriptBlock(System.Type.GetType("System.String"), "SQLCode", Sql.ClientScriptBlock(cmd)); } using (DbDataAdapter da = dbf.CreateDataAdapter()) { ((IDbDataAdapter)da).SelectCommand = cmd; using (DataTable dt = new DataTable()) { da.Fill(dt); vwMain = dt.DefaultView; grdMain.DataSource = vwMain; if (!IsPostBack) { // 12/14/2007 Paul. Only set the default sort if it is not already set. It may have been set by SearchView. if (String.IsNullOrEmpty(grdMain.SortColumn)) { grdMain.SortColumn = "NAME"; grdMain.SortOrder = "asc"; } grdMain.ApplySort(); grdMain.DataBind(); } } } } } } catch (Exception ex) { SplendidError.SystemError(new StackTrace(true).GetFrame(0), ex); lblError.Text = ex.Message; } if (!IsPostBack) { Page.DataBind(); } }
/// <summary> /// Override the database connection /// </summary> /// <param name="databaseConnection">New database connection</param> public void OverrideDatabaseDriver(IDbConnection databaseConnection) { this.DatabaseManager.OverrideDriver(() => databaseConnection); }
public MarketOrder(IDbConnection connection, IMemoryCache memoryCache) : base(connection, memoryCache) { }
public SqlServerDataRepository(IDbConnection dbConnection) { _dbConnection = dbConnection; }
public BaseUnitOfWork(IConnectionFactory factory) { Connection = factory.Open(); Transaction = Connection.BeginTransaction(); }
//Consturctor public DapperDepartmentRepository(IDbConnection connection) { _connection = connection; }
public override bool IsCompatibleConnection(IDbConnection connection) { return(typeof(OdbcConnection).IsSameOrParentOf(Proxy.GetUnderlyingObject((DbConnection)connection).GetType())); }
/// <summary> /// Inserts an entity into table "Ts" asynchronously using .NET 4.5 Task and returns identity id. /// </summary> /// <param name="connection">Open SqlConnection</param> /// <param name="entityToInsert">Entity to insert</param> /// <param name="transaction">The transaction to run under, null (the default) if none</param> /// <param name="commandTimeout">Number of seconds before command execution timeout</param> /// <param name="sqlAdapter">The specific ISqlAdapter to use, auto-detected based on connection if null</param> /// <returns>Identity of inserted entity</returns> public static Task <int> InsertAsync <T>(this IDbConnection connection, T entityToInsert, IDbTransaction transaction = null, int?commandTimeout = null, ISqlAdapter sqlAdapter = null) where T : class { var type = typeof(T); if (sqlAdapter == null) { sqlAdapter = GetFormatter(connection); } var isList = false; if (type.IsArray) { isList = true; type = type.GetElementType(); } else if (type.IsGenericType) { isList = true; type = type.GetGenericArguments()[0]; } var name = GetTableName(type); var sbColumnList = new StringBuilder(null); var allProperties = TypePropertiesCache(type); var keyProperties = KeyPropertiesCache(type); var computedProperties = ComputedPropertiesCache(type); var allPropertiesExceptKeyAndComputed = allProperties.Except(keyProperties.Union(computedProperties)).ToList(); for (var i = 0; i < allPropertiesExceptKeyAndComputed.Count; i++) { var property = allPropertiesExceptKeyAndComputed.ElementAt(i); sqlAdapter.AppendColumnName(sbColumnList, property.Name); if (i < allPropertiesExceptKeyAndComputed.Count - 1) { sbColumnList.Append(", "); } } var sbParameterList = new StringBuilder(null); for (var i = 0; i < allPropertiesExceptKeyAndComputed.Count; i++) { var property = allPropertiesExceptKeyAndComputed.ElementAt(i); sbParameterList.AppendFormat("@{0}", property.Name); if (i < allPropertiesExceptKeyAndComputed.Count - 1) { sbParameterList.Append(", "); } } if (!isList) //single entity { return(sqlAdapter.InsertAsync(connection, transaction, commandTimeout, name, sbColumnList.ToString(), sbParameterList.ToString(), keyProperties, entityToInsert)); } //insert list of entities var cmd = $"INSERT INTO {name} ({sbColumnList}) values ({sbParameterList})"; return(connection.ExecuteAsync(cmd, entityToInsert, transaction, commandTimeout)); }
/// <summary> /// Updates entity in table "Ts" asynchronously using .NET 4.5 Task, checks if the entity is modified if the entity is tracked by the Get() extension. /// </summary> /// <typeparam name="T">Type to be updated</typeparam> /// <param name="connection">Open SqlConnection</param> /// <param name="entityToUpdate">Entity to be updated</param> /// <param name="transaction">The transaction to run under, null (the default) if none</param> /// <param name="commandTimeout">Number of seconds before command execution timeout</param> /// <returns>true if updated, false if not found or not modified (tracked entities)</returns> public static async Task <bool> UpdateAsync <T>(this IDbConnection connection, T entityToUpdate, IDbTransaction transaction = null, int?commandTimeout = null) where T : class { var proxy = entityToUpdate as SqlMapperExtensions.IProxy; if (proxy != null) { if (!proxy.IsDirty) { return(false); } } var type = typeof(T); if (type.IsArray) { type = type.GetElementType(); } else if (type.IsGenericType) { type = type.GetGenericArguments()[0]; } var keyProperties = KeyPropertiesCache(type); var explicitKeyProperties = ExplicitKeyPropertiesCache(type); if (!keyProperties.Any() && !explicitKeyProperties.Any()) { throw new ArgumentException("Entity must have at least one [Key] or [ExplicitKey] property"); } var name = GetTableName(type); var sb = new StringBuilder(); sb.AppendFormat("update {0} set ", name); var allProperties = TypePropertiesCache(type); keyProperties.AddRange(explicitKeyProperties); var computedProperties = ComputedPropertiesCache(type); var nonIdProps = allProperties.Except(keyProperties.Union(computedProperties)).ToList(); var adapter = GetFormatter(connection); for (var i = 0; i < nonIdProps.Count; i++) { var property = nonIdProps.ElementAt(i); adapter.AppendColumnNameEqualsValue(sb, property.Name); if (i < nonIdProps.Count - 1) { sb.AppendFormat(", "); } } sb.Append(" where "); for (var i = 0; i < keyProperties.Count; i++) { var property = keyProperties.ElementAt(i); adapter.AppendColumnNameEqualsValue(sb, property.Name); if (i < keyProperties.Count - 1) { sb.AppendFormat(" and "); } } var updated = await connection.ExecuteAsync(sb.ToString(), entityToUpdate, commandTimeout : commandTimeout, transaction : transaction).ConfigureAwait(false); return(updated > 0); }
//Khởi tạo kết nối public DbconnectionV1() { _dbConnection = new MySqlConnection(_connectionString); }
public SqlServerWithExistingConnectionPublisher(IDbConnection connection) { this.connection = connection; }
public InvoiceRepository(IDbConnection connection) : base(connection) { }
public SoodaDataSource OpenDataSource(Sooda.Schema.DataSourceInfo dataSourceInfo, IDbConnection connection) { foreach (SoodaDataSource dataSource in _dataSources) { if (dataSource.Name == dataSourceInfo.Name) { return(dataSource); } } SoodaDataSource ds = (SoodaDataSource)dataSourceInfo.CreateDataSource(); _dataSources.Add(ds); ds.Statistics = this.Statistics; ds.IsolationLevel = IsolationLevel; if (connection != null) { ds.Connection = connection; } else { ds.Open(); } if (_savingObjects) { ds.BeginSaveChanges(); } return(ds); }
public ListResponse <MyRow> List(IDbConnection connection, ListRequest request) { return(new MyListHandler().Process(connection, request)); }
public static IDbCommand CreateCommand(string sql, IDbConnection conn) { return(new Npgsql.NpgsqlCommand(sql, (Npgsql.NpgsqlConnection)conn)); }
private async Task DeleteEmployeeRoles(IDbConnection conn, Guid EmployeeId, IList <Guid> RoleIds, IDbTransaction tran) { string sql = "DELETE FROM EmployeeRoles WHERE EmployeeId = @EmployeeId AND RoleId IN @RoleIds"; await conn.ExecuteAsync(sql, new { EmployeeId = EmployeeId, RoleIds = RoleIds }, tran); }
public SoodaDataSource OpenDataSource(string name, IDbConnection connection) { return(OpenDataSource(Schema.GetDataSourceInfo(name), connection)); }
private async Task UpdateEmployeeRoles(IDbConnection conn, Guid EmployeeId, IList <EmployeeRole> Roles, IDbTransaction tran) { string sql = "UPDATE EmployeeRoles SET ContributionGroupId = @ContributionGroupId WHERE EmployeeId = @EmployeeId AND RoleId = @RoleId"; await conn.ExecuteAsync(sql, Roles.Select(r => new { EmployeeId = EmployeeId, RoleId = r.Id, ContributionGroupId = r.ContributionGroup.Id }), tran); }
public RetrieveResponse <MyRow> Retrieve(IDbConnection connection, RetrieveRequest request) { return(new MyRetrieveHandler().Process(connection, request)); }
public async Task<Project> ProjectQueryAsync(IDbConnection connection, object param = null) { var p = AnonymousObjectToDictionary(param); var id = (int) p["id"]; var project = new Project { ProjectId = id, ProjectManagerId = id }; switch (id) { case 1: project.Status = "Current"; break; case 2: project.Status = "Current"; project.Features = "No"; break; case 3: project.Status = "Cancelled"; break; case 4: project.Status = "Completed"; break; } return await Task.Factory.StartNew(() => project); }