public static DbProviderFactory GetInstance(string dbConnectionName) { if (_instance != null && _currentDbName == dbConnectionName) return _instance; var connectionStrings = GetDbConnection(dbConnectionName); _instance = new DbProviderFactory(connectionStrings); _currentDbName = dbConnectionName; return _instance; }
public static IDatabase GetPetaPocoDb(string connectionString, Boolean profiled = true) { MigrationsHelper.Run(connectionString, true); var factory = new DbProviderFactory { IsProfiled = profiled }; var db = new Database(connectionString, factory, Database.DBType.SqlServerCE) { KeepConnectionAlive = true, ForceDateTimesToUtc = false, }; return db; }
public CountryTableDataService() { _connectionString = ConfigurationManager.ConnectionStrings["mainAppConnectionString"].ConnectionString; _providerFactory = DbProviderFactories.GetFactory(ConfigurationManager.ConnectionStrings["mainAppConnectionString"].ProviderName); }
private void Page_Load(object sender, System.EventArgs e) { SetPageTitle(L10n.Term(m_sMODULE + ".LBL_LIST_FORM_TITLE")); // 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, "list") >= 0); if (!this.Visible) { return; } try { if (this.IsMobile && grdMain.Columns.Count > 0) { grdMain.Columns[0].Visible = false; } DbProviderFactory dbf = DbProviderFactories.GetFactory(); using (IDbConnection con = dbf.CreateConnection()) { string sSQL; sSQL = "select * " + ControlChars.CrLf + " from vwQUOTES_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, m_sMODULE, "list"); ctlSearchView.SqlSearchClause(cmd); if (bDebug) { RegisterClientScriptBlock("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) { // 06/09/2006 Paul. Remove data binding in the user controls. Binding is required, but only do so in the ASPX pages. //Page.DataBind(); } }
/// <summary> /// Initializes a new instance of the <see cref="InstrumentedDbProviderFactory"/> class. /// A proxy provider factory /// </summary> /// <param name="factory">The provider factory to wrap.</param> /// <param name="instrumentationHandler"></param> /// <remarks> /// </remarks> public InstrumentedDbProviderFactory(DbProviderFactory factory, IInstrumentationHandler instrumentationHandler) { this._factory = factory; this._instrumentationHandler = instrumentationHandler; }
public void TestMigration() { //arrange DbProviderFactory factory = null; try { factory = DbProviderFactories.GetFactory(ProviderName); } catch (ArgumentException) { Assert.Inconclusive("Unable to find System.Data.SqlServerCe.4.0 Data Provider. It may not be installed."); } if (!File.Exists(FilePath)) { Assert.Inconclusive("SqlServerCe4 test requires database file " + FilePath); } const string connectionString = "Data Source=\"" + FilePath + "\""; ProviderChecker.Check(ProviderName, connectionString); var tableName = MigrationCommon.FindFreeTableName(ProviderName, connectionString); var migration = new DdlGeneratorFactory(SqlType.SqlServerCe).MigrationGenerator(); var table = MigrationCommon.CreateTestTable(tableName); var newColumn = MigrationCommon.CreateNewColumn(); var unqiueConstraint = MigrationCommon.CreateUniqueConstraint(newColumn); var fk = MigrationCommon.CreateForeignKey(table); var index = MigrationCommon.CreateUniqueIndex(newColumn, tableName); var createTable = migration.AddTable(table); var addColumn = migration.AddColumn(table, newColumn); var addUniqueConstraint = migration.AddConstraint(table, unqiueConstraint); var addForeignKey = migration.AddConstraint(table, fk); var addUniqueIndex = migration.AddIndex(table, index); var dropUniqueIndex = migration.DropIndex(table, index); var dropForeignKey = migration.DropConstraint(table, fk); var dropUniqueConstraint = migration.DropConstraint(table, unqiueConstraint); var dropColumn = migration.DropColumn(table, newColumn); var dropTable = migration.DropTable(table); using (new TransactionScope()) { using (var con = factory.CreateConnection()) { con.ConnectionString = connectionString; using (var cmd = con.CreateCommand()) { con.Open(); Execute(cmd, createTable); Execute(cmd, addColumn); Execute(cmd, addUniqueConstraint); Execute(cmd, addForeignKey); Execute(cmd, dropForeignKey); Execute(cmd, dropUniqueConstraint); Execute(cmd, addUniqueIndex); Execute(cmd, dropUniqueIndex); Execute(cmd, dropColumn); Execute(cmd, dropTable); } } } }
protected void Page_Command(Object sender, CommandEventArgs e) { if (e.CommandName == "Save") { // 01/16/2006 Paul. Enable validator before validating page. this.ValidateEditViewFields(m_sMODULE + ".EditView"); this.ValidateEditViewFields(m_sMODULE + ".EditAddress"); this.ValidateEditViewFields(m_sMODULE + ".EditDescription"); if (Page.IsValid) { string sCUSTOM_MODULE = "LEADS"; DataTable dtCustomFields = SplendidCache.FieldsMetaData_Validated(sCUSTOM_MODULE); DbProviderFactory dbf = DbProviderFactories.GetFactory(); using (IDbConnection con = dbf.CreateConnection()) { con.Open(); // 11/18/2007 Paul. Use the current values for any that are not defined in the edit view. DataRow rowCurrent = null; DataTable dtCurrent = new DataTable(); if (!Sql.IsEmptyGuid(gID)) { string sSQL; sSQL = "select * " + ControlChars.CrLf + " from vwLEADS_Edit" + ControlChars.CrLf; using (IDbCommand cmd = con.CreateCommand()) { cmd.CommandText = sSQL; Security.Filter(cmd, m_sMODULE, "edit"); Sql.AppendParameter(cmd, gID, "ID", false); using (DbDataAdapter da = dbf.CreateDataAdapter()) { ((IDbDataAdapter)da).SelectCommand = cmd; da.Fill(dtCurrent); if (dtCurrent.Rows.Count > 0) { rowCurrent = dtCurrent.Rows[0]; } else { // 11/19/2007 Paul. If the record is not found, clear the ID so that the record cannot be updated. // It is possible that the record exists, but that ACL rules prevent it from being selected. gID = Guid.Empty; } } } } using (IDbTransaction trn = con.BeginTransaction()) { try { // 04/24/2006 Paul. Upgrade to SugarCRM 4.2 Schema. // 11/18/2007 Paul. Use the current values for any that are not defined in the edit view. // 12/29/2007 Paul. TEAM_ID is now in the stored procedure. SqlProcs.spLEADS_Update (ref gID , new DynamicControl(this, rowCurrent, "ASSIGNED_USER_ID").ID , new DynamicControl(this, rowCurrent, "SALUTATION").SelectedValue , new DynamicControl(this, rowCurrent, "FIRST_NAME").Text , new DynamicControl(this, rowCurrent, "LAST_NAME").Text , new DynamicControl(this, rowCurrent, "TITLE").Text , new DynamicControl(this, rowCurrent, "REFERED_BY").Text , new DynamicControl(this, rowCurrent, "LEAD_SOURCE").SelectedValue , new DynamicControl(this, rowCurrent, "LEAD_SOURCE_DESCRIPTION").Text , new DynamicControl(this, rowCurrent, "STATUS").SelectedValue , new DynamicControl(this, rowCurrent, "STATUS_DESCRIPTION").Text , new DynamicControl(this, rowCurrent, "DEPARTMENT").Text , Guid.Empty // 06/24/2005. REPORTS_TO_ID is not used in version 3.0. , new DynamicControl(this, rowCurrent, "DO_NOT_CALL").Checked , new DynamicControl(this, rowCurrent, "PHONE_HOME").Text , new DynamicControl(this, rowCurrent, "PHONE_MOBILE").Text , new DynamicControl(this, rowCurrent, "PHONE_WORK").Text , new DynamicControl(this, rowCurrent, "PHONE_OTHER").Text , new DynamicControl(this, rowCurrent, "PHONE_FAX").Text , new DynamicControl(this, rowCurrent, "EMAIL1").Text , new DynamicControl(this, rowCurrent, "EMAIL2").Text , new DynamicControl(this, rowCurrent, "EMAIL_OPT_OUT").Checked , new DynamicControl(this, rowCurrent, "INVALID_EMAIL").Checked , new DynamicControl(this, rowCurrent, "PRIMARY_ADDRESS_STREET").Text , new DynamicControl(this, rowCurrent, "PRIMARY_ADDRESS_CITY").Text , new DynamicControl(this, rowCurrent, "PRIMARY_ADDRESS_STATE").Text , new DynamicControl(this, rowCurrent, "PRIMARY_ADDRESS_POSTALCODE").Text , new DynamicControl(this, rowCurrent, "PRIMARY_ADDRESS_COUNTRY").Text , new DynamicControl(this, rowCurrent, "ALT_ADDRESS_STREET").Text , new DynamicControl(this, rowCurrent, "ALT_ADDRESS_CITY").Text , new DynamicControl(this, rowCurrent, "ALT_ADDRESS_STATE").Text , new DynamicControl(this, rowCurrent, "ALT_ADDRESS_POSTALCODE").Text , new DynamicControl(this, rowCurrent, "ALT_ADDRESS_COUNTRY").Text , new DynamicControl(this, rowCurrent, "DESCRIPTION").Text , new DynamicControl(this, rowCurrent, "ACCOUNT_NAME").Text , new DynamicControl(this, rowCurrent, "CAMPAIGN_ID").ID , new DynamicControl(this, rowCurrent, "TEAM_ID").ID , trn ); SplendidDynamic.UpdateCustomFields(this, trn, gID, sCUSTOM_MODULE, dtCustomFields); trn.Commit(); } catch (Exception ex) { trn.Rollback(); SplendidError.SystemError(new StackTrace(true).GetFrame(0), ex); ctlEditButtons.ErrorText = ex.Message; return; } } } Response.Redirect("view.aspx?ID=" + gID.ToString()); } } else if (e.CommandName == "Cancel") { if (Sql.IsEmptyGuid(gID)) { Response.Redirect("default.aspx"); } else { Response.Redirect("view.aspx?ID=" + gID.ToString()); } } }
private void Page_Load(object sender, System.EventArgs e) { gID = Sql.ToGuid(Request["ID"]); Guid gOPPORTUNITY_ID = Sql.ToGuid(txtOPPORTUNITY_ID.Value); if (!Sql.IsEmptyGuid(gOPPORTUNITY_ID)) { try { SqlProcs.spACCOUNTS_OPPORTUNITIES_Update(gID, gOPPORTUNITY_ID); Response.Redirect("view.aspx?ID=" + gID.ToString()); } catch (Exception ex) { SplendidError.SystemError(new StackTrace(true).GetFrame(0), ex.Message); lblError.Text = ex.Message; } } DbProviderFactory dbf = DbProviderFactories.GetFactory(); using (IDbConnection con = dbf.CreateConnection()) { string sSQL; sSQL = "select * " + ControlChars.CrLf + " from vwACCOUNTS_OPPORTUNITIES" + ControlChars.CrLf + " where ACCOUNT_ID = @ACCOUNT_ID" + ControlChars.CrLf + " order by DATE_CLOSED desc " + ControlChars.CrLf; using (IDbCommand cmd = con.CreateCommand()) { cmd.CommandText = sSQL; Sql.AddParameter(cmd, "@ACCOUNT_ID", gID); #if DEBUG Page.RegisterClientScriptBlock("vwACCOUNTS_OPPORTUNITIES", Sql.ClientScriptBlock(cmd)); #endif try { using (DbDataAdapter da = dbf.CreateDataAdapter()) { ((IDbDataAdapter)da).SelectCommand = cmd; using (DataTable dt = new DataTable()) { da.Fill(dt); vwMain = dt.DefaultView; grdMain.DataSource = vwMain; // 09/05/2005 Paul. LinkButton controls will not fire an event unless the the grid is bound. //if ( !IsPostBack ) { grdMain.DataBind(); } } } } catch (Exception ex) { SplendidError.SystemError(new StackTrace(true).GetFrame(0), ex.Message); lblError.Text = ex.Message; } } } if (!IsPostBack) { // 06/09/2006 Paul. Remove data binding in the user controls. Binding is required, but only do so in the ASPX pages. //Page.DataBind(); } }
public Page() { providerFactory = Utils.DB.CreateDBProviderFactory(); cn = Utils.DB.CreateConnection(); cmd = providerFactory.CreateCommand(); cmd.Connection = cn; }
/// <summary> /// Contrutor Init com parametros /// </summary> /// <param name="providerName"></param> /// <param name="connString"></param> public static void Init(string providerName, string connString) { providerFactory = DbProviderFactories.GetFactory(providerName); connStr = connString; initialized = true; }
public UserStore(IConfiguration connStr, DbProviderFactory factory) { _connectionString = connStr.GetConnectionString("DefaultConnection"); _factory = factory; }
public TestDbProvider() { IDbProvider provider = DbProviderFactory.GetDbProvider("System.Data.SqlClient"); dbMetadata = provider.DbMetadata; }
/// <summary> /// 初始化数据库类 /// </summary> /// <param name="connectionString">数据库连接字符串</param> /// <param name="dbProvider">数据库提供者</param> internal SqlServerDatabase(DbProviderFactory dbProvider, String connectionString) : base(dbProvider, connectionString) { }
public EdmMetadataRepository(InternalContext usersContext, string connectionString, DbProviderFactory providerFactory) : base(usersContext, connectionString, providerFactory) { _existingTransaction = usersContext.TryGetCurrentStoreTransaction(); }
public EnviromentConnectionFactory(string envDatabaseName, string providerInvariantName) { _envVarKey = "NEventStore.{0}".FormatWith(envDatabaseName); _dbProviderFactory = DbProviderFactories.GetFactory(providerInvariantName); }
public Database(string connectionString, DbProviderFactory factory) { this.ConnectionString = connectionString; this.Factory = factory; }
/// <summary> /// Initializes a new instance of the <see cref="OracleServerExecuter"/> class. /// </summary> /// <param name="provider">驱动</param> /// <param name="connectionString">连接字符串.</param> public OracleServerExecuter(DbProviderFactory provider, string connectionString) : base(provider, connectionString) { }
public UmbracoDatabase(string connectionString, DbProviderFactory provider) : base(connectionString, provider) { }
public void Actualizar(Perfil persona) { DbProviderFactory factory = DbProviderFactories.GetFactory(Settings.Default.proveedor); DbConnection conn = null; DbCommand comm = null; try { conn = factory.CreateConnection(); conn.ConnectionString = Settings.Default.connection; comm = factory.CreateCommand(); DbParameter param0 = factory.CreateParameter(); DbParameter param1 = factory.CreateParameter(); DbParameter param2 = factory.CreateParameter(); DbParameter param3 = factory.CreateParameter(); DbParameter param4 = factory.CreateParameter(); DbParameter param5 = factory.CreateParameter(); DbParameter param6 = factory.CreateParameter(); DbParameter param7 = factory.CreateParameter(); DbParameter param8 = factory.CreateParameter(); DbParameter param9 = factory.CreateParameter(); DbParameter param10 = factory.CreateParameter(); DbParameter param11 = factory.CreateParameter(); DbParameter param12 = factory.CreateParameter(); DbParameter param13 = factory.CreateParameter(); DbParameter param14 = factory.CreateParameter(); DbParameter param15 = factory.CreateParameter(); DbParameter param16 = factory.CreateParameter(); param0.ParameterName = "@ID"; param0.DbType = DbType.Int32; param0.Value = persona._ID; param1.ParameterName = "@Nombre"; param1.DbType = DbType.String; param1.Value = persona._Nombre; param2.ParameterName = "@Cedula"; param2.DbType = DbType.Int32; param2.Value = persona._Cedula; param3.ParameterName = "@ProfesionPrinc"; param3.DbType = DbType.String; param3.Value = persona._ProfesionPrinc; param4.ParameterName = "@CantidadTitulos"; param4.DbType = DbType.Int32; param4.Value = persona._CantidadTitulos; param5.ParameterName = "@ConocimientoAdic"; param5.DbType = DbType.String; param5.Value = persona._ConocimientosAdic; param6.ParameterName = "@Telefono"; param6.DbType = DbType.Int32; param6.Value = persona._Telefono; param7.ParameterName = "@Mail"; param7.DbType = DbType.String; param7.Value = persona._Mail; param8.ParameterName = "@Fecha_Nacimiento"; param8.DbType = DbType.Date; param8.Value = persona._Fecha_Nacimiento; param9.ParameterName = "@Residencia"; param9.DbType = DbType.String; param9.Value = persona._Residencia; param10.ParameterName = "@Universidad"; param10.DbType = DbType.String; param10.Value = persona._Universidad; param11.ParameterName = "@AnoGraduacion"; param11.DbType = DbType.Date; param11.Value = persona._AnoGraduacion; param12.ParameterName = "@AnoExperiencia"; param12.DbType = DbType.Int32; param12.Value = persona._AnoExperiencia; param13.ParameterName = "@CantidadEmpleos"; param13.DbType = DbType.Int32; param13.Value = persona._CantidadEmpleos; param14.ParameterName = "@CantidadDespidos"; param14.DbType = DbType.Int32; param14.Value = persona._CantidadDespidos; param15.ParameterName = "@Idiomas"; param15.DbType = DbType.String; param15.Value = persona._Idiomas; param16.ParameterName = "@Pasaporte"; param16.DbType = DbType.String; param16.Value = persona._Pasaporte; //Abrir Conx comm.Connection = conn; conn.Open(); //Ejecutar SP y pasar parametros comm.CommandType = CommandType.StoredProcedure; comm.CommandText = "ActualizarPerfil"; comm.Parameters.Add(param0); comm.Parameters.Add(param1); comm.Parameters.Add(param2); comm.Parameters.Add(param3); comm.Parameters.Add(param4); comm.Parameters.Add(param5); comm.Parameters.Add(param6); comm.Parameters.Add(param7); comm.Parameters.Add(param8); comm.Parameters.Add(param9); comm.Parameters.Add(param10); comm.Parameters.Add(param11); comm.Parameters.Add(param12); comm.Parameters.Add(param13); comm.Parameters.Add(param14); comm.Parameters.Add(param15); comm.Parameters.Add(param16); comm.ExecuteNonQuery(); } catch (Exception ee) { throw; } finally { comm.Dispose(); conn.Dispose(); } }
/// <summary> /// 创建一个数据提供程序实例 /// </summary> /// <param name="connectionStringName"></param> /// <returns></returns> public static Database Create(string connectionStringName) { CheckUtil.ArgumentNotNullOrEmpty(connectionStringName, "connectionStringName"); ConnectionStringSettings css = ConfigurationManager.ConnectionStrings[connectionStringName]; if (css == null) { throw new Exception(string.Format(Resources.Data.ConnectionStringNameNotFound, connectionStringName)); } string connectionString = css.ConnectionString; string providerName = css.ProviderName; Database db = new SqlServerDatabase(connectionString); DbProviderFactory providerFactory = null; if (string.IsNullOrEmpty(providerName)) { return(db); } providerFactory = DbProviderFactories.GetFactory(css.ProviderName); if (providerFactory == null) { throw new Exception(string.Format(Resources.Data.DataProviderNotFound, css.ProviderName)); } switch (providerName) { //case "System.Data.SqlClient": // break; case "System.Data.Odbc": db = new OdbcDatabase(connectionString); break; case "System.Data.OleDb": db = new OleDbDatabase(connectionString); break; case "System.Data.OracleClient": db = new OracleDatabase(connectionString); break; case "System.Data.SQLite": db = new SQLiteDatabase(connectionString, providerFactory); break; case "MySql.Data.MySqlClient": db = new MySqlDatabase(connectionString, providerFactory); break; case "IBM.Data.DB2": db = new DB2Database(connectionString, providerFactory); break; case "FirebirdSql.Data.FirebirdClient": db = new FirebirdDatabase(connectionString, providerFactory); break; default: break; } return(db); }
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, "edit") >= 0); if (!this.Visible) { return; } try { gID = Sql.ToGuid(Request["ID"]); if (!IsPostBack) { Guid gDuplicateID = Sql.ToGuid(Request["DuplicateID"]); if (!Sql.IsEmptyGuid(gID) || !Sql.IsEmptyGuid(gDuplicateID)) { DbProviderFactory dbf = DbProviderFactories.GetFactory(); using (IDbConnection con = dbf.CreateConnection()) { string sSQL; sSQL = "select * " + ControlChars.CrLf + " from vwLEADS_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, "edit"); if (!Sql.IsEmptyGuid(gDuplicateID)) { Sql.AppendParameter(cmd, gDuplicateID, "ID", false); gID = Guid.Empty; } else { Sql.AppendParameter(cmd, gID, "ID", false); } con.Open(); if (bDebug) { RegisterClientScriptBlock("SQLCode", Sql.ClientScriptBlock(cmd)); } using (IDataReader rdr = cmd.ExecuteReader(CommandBehavior.SingleRow)) { if (rdr.Read()) { ctlModuleHeader.Title = Sql.ToString(rdr["SALUTATION"]) + " " + Sql.ToString(rdr["FIRST_NAME"]) + " " + Sql.ToString(rdr["LAST_NAME"]); SetPageTitle(L10n.Term(".moduleList." + m_sMODULE) + " - " + ctlModuleHeader.Title); Utils.UpdateTracker(Page, m_sMODULE, gID, ctlModuleHeader.Title); ViewState["ctlModuleHeader.Title"] = ctlModuleHeader.Title; this.AppendEditViewFields(m_sMODULE + ".EditView", tblMain, rdr); this.AppendEditViewFields(m_sMODULE + ".EditAddress", tblAddress, rdr); this.AppendEditViewFields(m_sMODULE + ".EditDescription", tblDescription, rdr); } else { // 11/25/2006 Paul. If item is not visible, then don't allow save ctlEditButtons.DisableAll(); ctlEditButtons.ErrorText = L10n.Term("ACL.LBL_NO_ACCESS"); } } } } } else { this.AppendEditViewFields(m_sMODULE + ".EditView", tblMain, null); this.AppendEditViewFields(m_sMODULE + ".EditAddress", tblAddress, null); this.AppendEditViewFields(m_sMODULE + ".EditDescription", tblDescription, null); } } else { // 12/02/2005 Paul. When validation fails, the header title does not retain its value. Update manually. ctlModuleHeader.Title = Sql.ToString(ViewState["ctlModuleHeader.Title"]); SetPageTitle(L10n.Term(".moduleList." + m_sMODULE) + " - " + ctlModuleHeader.Title); } } catch (Exception ex) { SplendidError.SystemError(new StackTrace(true).GetFrame(0), ex); ctlEditButtons.ErrorText = ex.Message; } }
private void flightDoneButton_Click(object sender, RoutedEventArgs e) { factory = DbProviderFactories.GetFactory("System.Data.OracleClient"); connection = factory.CreateConnection(); connection.ConnectionString = "Data Source=localhost;Persist Security Info=True;User ID=system;Password=0326;Unicode=True"; connection.Open(); DbCommand command = factory.CreateCommand(); command.CommandText = strQuery; //make the query command.Connection = connection; //connect the command switch (usersChoice) { case "add": id = Int32.Parse(flight_id.Text); take_off = takeOffDatePicker.Text; airplaneId = Int32.Parse(airplane_id.Text); flightLineId = Int32.Parse(flight_line_id.Text); // create insert functions to tacbels credit_card and passanger strQuery = "insert into SYSTEM.FLIGHT(FLIGHTID, TAKE_OFF_DATE, AIRPLANEID, FLIGHT_LINE_ID) values (" + id + ",to_date('" + take_off + " " + rand.Next(10, 23) + ":" + rand.Next(10, 59) + ":" + rand.Next(10, 59) + "', 'dd-mm-yyyy hh24:mi:ss')," + airplaneId + "," + flightLineId + ")"; command.CommandText = strQuery; break; case "update": id = Int32.Parse(flight_id.Text); take_off = takeOffDatePicker.Text; airplaneId = Int32.Parse(airplane_id.Text); flightLineId = Int32.Parse(flight_line_id.Text); // create update functions to a row in ticket table strQuery = "update SYSTEM.FLIGHT SET TAKE_OFF_DATE = to_date('" + take_off + " " + rand.Next(10, 23) + ":" + rand.Next(10, 59) + ":" + rand.Next(10, 59) + "', 'dd-mm-yyyy hh24:mi:ss'), AIRPLANEID = " + airplaneId + ", FLIGHT_LINE_ID = " + flightLineId + " where FLIGHTID = " + id; command.CommandText = strQuery; break; case "delete": id = Int32.Parse(flight_id.Text); // create delete query from tickets strQuery = "delete from SYSTEM.FLIGHT where FLIGHTID = " + id; command.CommandText = strQuery; break; default: break; } try { int check = command.ExecuteNonQuery(); if (check == 1) { MessageBox.Show("FLIGHT " + usersChoice + "ed successfully! \n "); } this.Close(); } catch (Exception ex) { MessageBox.Show("ERROR: " + ex.Message); } connection.Close(); }
private void Page_Load(object sender, System.EventArgs e) { try { Guid 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()) { string sSQL; sSQL = "select * " + ControlChars.CrLf + " from vwTHREADS_POSTS" + ControlChars.CrLf; using (IDbCommand cmd = con.CreateCommand()) { cmd.CommandText = sSQL; // 11/27/2006 Paul. Make sure to filter relationship data based on team access rights. Security.Filter(cmd, m_sMODULE, "list"); cmd.CommandText += " and THREAD_ID = @THREAD_ID" + ControlChars.CrLf; cmd.CommandText += " order by DATE_ENTERED asc " + ControlChars.CrLf; Sql.AddParameter(cmd, "@THREAD_ID", gID); if (bDebug) { RegisterClientScriptBlock("vwTHREADS_POSTS", Sql.ClientScriptBlock(cmd)); } using (DbDataAdapter da = dbf.CreateDataAdapter()) { ((IDbDataAdapter)da).SelectCommand = cmd; using (DataTable dt = new DataTable()) { da.Fill(dt); foreach (DataRow rdr in dt.Rows) { PostView ctlPost = LoadControl("PostView.ascx") as PostView; plcPosts.Controls.Add(ctlPost); ctlPost.POST_ID = Sql.ToGuid(rdr["ID"]); ctlPost.TITLE = Sql.ToString(rdr["TITLE"]); ctlPost.CREATED_BY = Sql.ToString(rdr["CREATED_BY"]); ctlPost.DATE_ENTERED = Sql.ToString(rdr["DATE_ENTERED"]); ctlPost.MODIFIED_BY = Sql.ToString(rdr["MODIFIED_BY"]); ctlPost.DATE_MODIFIED = Sql.ToString(rdr["DATE_MODIFIED"]); ctlPost.DESCRIPTION = Sql.ToString(rdr["DESCRIPTION_HTML"]); if (Sql.ToDateTime(rdr["DATE_ENTERED"]) != Sql.ToDateTime(rdr["DATE_MODIFIED"])) { ctlPost.Modified = true; } Guid gCREATED_BY_ID = Sql.ToGuid(rdr["CREATED_BY_ID"]); ctlPost.ShowEdit = Security.IS_ADMIN || gCREATED_BY_ID == Security.USER_ID; ctlPost.ShowDelete = Security.IS_ADMIN || gCREATED_BY_ID == Security.USER_ID; } } } } } } } // 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); } }
protected void Page_Command(Object sender, CommandEventArgs e) { if (e.CommandName == "Save") { // 01/16/2006 Paul. Enable validator before validating page. this.ValidateEditViewFields(m_sMODULE + ".EditView"); string sCATEGORY = new DynamicControl(this, "CATEGORY").Text; if (Page.IsValid && !Sql.IsEmptyString(sCATEGORY)) { DbProviderFactory dbf = DbProviderFactories.GetFactory(); using (IDbConnection con = dbf.CreateConnection()) { con.Open(); // 11/18/2007 Paul. Use the current values for any that are not defined in the edit view. DataRow rowCurrent = null; DataTable dtCurrent = new DataTable(); if (!Sql.IsEmptyGuid(gID)) { string sSQL; sSQL = "select * " + ControlChars.CrLf + " from vwFORUMS_Edit" + ControlChars.CrLf; using (IDbCommand cmd = con.CreateCommand()) { cmd.CommandText = sSQL; Security.Filter(cmd, m_sMODULE, "edit"); Sql.AppendParameter(cmd, gID, "ID", false); using (DbDataAdapter da = dbf.CreateDataAdapter()) { ((IDbDataAdapter)da).SelectCommand = cmd; da.Fill(dtCurrent); if (dtCurrent.Rows.Count > 0) { rowCurrent = dtCurrent.Rows[0]; } else { // 11/19/2007 Paul. If the record is not found, clear the ID so that the record cannot be updated. // It is possible that the record exists, but that ACL rules prevent it from being selected. gID = Guid.Empty; } } } } using (IDbTransaction trn = con.BeginTransaction()) { try { // 12/29/2007 Paul. TEAM_ID is now in the stored procedure. SqlProcs.spFORUMS_Update (ref gID , new DynamicControl(this, "TITLE").Text , new DynamicControl(this, "CATEGORY").Text , new DynamicControl(this, "DESCRIPTION").Text , new DynamicControl(this, "TEAM_ID").ID , trn ); trn.Commit(); } catch (Exception ex) { trn.Rollback(); SplendidError.SystemError(new StackTrace(true).GetFrame(0), ex); ctlEditButtons.ErrorText = ex.Message; return; } } } Response.Redirect("view.aspx?ID=" + gID.ToString()); } } else if (e.CommandName == "Cancel") { if (Sql.IsEmptyGuid(gID)) { Response.Redirect("default.aspx"); } else { Response.Redirect("view.aspx?ID=" + gID.ToString()); } } }
public ConnectionBuilder(DbProviderFactory providerFactory) { this.dbFactory = providerFactory; }
/// <summary> /// Funkcja stworzona tylko po to by nie można było tworzyć nowych SzpifDatabase'ów /// </summary> private SzpifDatabase() { provider = "System.Data.SqlClient"; factory = DbProviderFactories.GetFactory(provider); connection = factory.CreateConnection(); }
/// <summary> /// Allow to re-initialize the provider factory. /// </summary> /// <param name="tail">The tail.</param> public void InitProfiledDbProviderFactory(DbProviderFactory tail) => this._factory = tail;
public VehicleRepository() { _connectionString = DBHelper.GetConnectionString(); _dbProviderName = DBHelper.GetConnectionProvider(); _dbProviderFactory = DbProviderFactories.GetFactory(_dbProviderName); }
protected void Page_Command(object sender, CommandEventArgs e) { try { if (e.CommandName == "Search") { // 10/13/2005 Paul. Make sure to clear the page index prior to applying search. grdMain.CurrentPageIndex = 0; grdMain.ApplySort(); grdMain.DataBind(); } // 12/14/2007 Paul. We need to capture the sort event from the SearchView. else if (e.CommandName == "SortGrid") { grdMain.SetSortFields(e.CommandArgument as string[]); } else if (e.CommandName == "MassUpdate") { string[] arrID = Request.Form.GetValues("chkMain"); if (arrID != null) { // 10/26/2007 Paul. Use a stack to run the update in blocks of under 200 IDs. //string sIDs = Utils.ValidateIDs(arrID); System.Collections.Stack stk = Utils.FilterByACL_Stack(m_sMODULE, "edit", arrID, "QUOTES"); if (stk.Count > 0) { DbProviderFactory dbf = DbProviderFactories.GetFactory(); using (IDbConnection con = dbf.CreateConnection()) { con.Open(); using (IDbTransaction trn = con.BeginTransaction()) { try { while (stk.Count > 0) { string sIDs = Utils.BuildMassIDs(stk); // 07/09/2006 Paul. The date conversion was moved out of the MassUpdate control. // 09/11/2007 Paul. Mass update of teams is now available. SqlProcs.spQUOTES_MassUpdate(sIDs, ctlMassUpdate.ASSIGNED_USER_ID, ctlMassUpdate.PAYMENT_TERMS, ctlMassUpdate.QUOTE_STAGE, T10n.ToServerTime(ctlMassUpdate.ORIGINAL_PO_DATE), T10n.ToServerTime(ctlMassUpdate.DATE_QUOTE_EXPECTED_CLOSED), ctlMassUpdate.BILLING_ACCOUNT_ID, ctlMassUpdate.BILLING_CONTACT_ID, ctlMassUpdate.SHIPPING_ACCOUNT_ID, ctlMassUpdate.SHIPPING_CONTACT_ID, ctlMassUpdate.TEAM_ID, trn); } trn.Commit(); } catch (Exception ex) { trn.Rollback(); throw(new Exception(ex.Message, ex.InnerException)); } } } Response.Redirect("default.aspx"); } } } else if (e.CommandName == "MassDelete") { string[] arrID = Request.Form.GetValues("chkMain"); if (arrID != null) { // 10/26/2007 Paul. Use a stack to run the update in blocks of under 200 IDs. //string sIDs = Utils.ValidateIDs(arrID); System.Collections.Stack stk = Utils.FilterByACL_Stack(m_sMODULE, "delete", arrID, "QUOTES"); if (stk.Count > 0) { DbProviderFactory dbf = DbProviderFactories.GetFactory(); using (IDbConnection con = dbf.CreateConnection()) { con.Open(); using (IDbTransaction trn = con.BeginTransaction()) { try { while (stk.Count > 0) { string sIDs = Utils.BuildMassIDs(stk); SqlProcs.spQUOTES_MassDelete(sIDs, trn); } trn.Commit(); } catch (Exception ex) { trn.Rollback(); throw(new Exception(ex.Message, ex.InnerException)); } } } Response.Redirect("default.aspx"); } } } else if (e.CommandName == "Export") { // 11/03/2006 Paul. Apply ACL rules to Export. int nACLACCESS = SplendidCRM.Security.GetUserAccess(m_sMODULE, "export"); if (nACLACCESS >= 0) { if (nACLACCESS == ACL_ACCESS.OWNER) { vwMain.RowFilter = "ASSIGNED_USER_ID = '" + Security.USER_ID.ToString() + "'"; } string[] arrID = Request.Form.GetValues("chkMain"); SplendidExport.Export(vwMain, m_sMODULE, ctlExportHeader.ExportFormat, ctlExportHeader.ExportRange, grdMain.CurrentPageIndex, grdMain.PageSize, arrID); } } } catch (Exception ex) { SplendidError.SystemError(new StackTrace(true).GetFrame(0), ex); lblError.Text = ex.Message; } }
//------------------------------------------------------------------------------- public QuestRepository() { _connectionString = constr.ConnectionString; _factory = DbProviderFactories.GetFactory(constr.ProviderName); }
public static IDbProviderFactory AsIDbProviderFactory(this DbProviderFactory dbProviderFactory) { return(new DbProviderFactoryAdapter(dbProviderFactory)); }
/// <summary> /// 初始化 <see cref="Database"/> 类的新实例 /// </summary> /// <param name="providerFactory">数据源提供者</param> /// <param name="connectionString">数据库连接字符串</param> public Database(DbProviderFactory providerFactory, string connectionString) { _connString = connectionString; _dbProviderFactory = providerFactory; }
public DynamicModel(string connectionStringName, string tableName = "", string primaryKeyField = "", string descriptorField = "") { TableName = tableName == "" ? this.GetType().Name : tableName; PrimaryKeyField = string.IsNullOrEmpty(primaryKeyField) ? "ID" : primaryKeyField; DescriptorField = descriptorField; var _providerName = "System.Data.SqlClient"; if (ConfigurationManager.ConnectionStrings[connectionStringName].ProviderName != null) _providerName = ConfigurationManager.ConnectionStrings[connectionStringName].ProviderName; _factory = DbProviderFactories.GetFactory(_providerName); ConnectionString = ConfigurationManager.ConnectionStrings[connectionStringName].ConnectionString; }
public RawDb(IRandom random, DbProviderFactory dbProviderFactory, IOptions <AppSettings> appSettings) { _random = random; _dbProviderFactory = dbProviderFactory; _connectionString = appSettings.Value.ConnectionString; }
protected DbFactoryBase(DbProviderFactory factory) { this.factory = factory; }
/// <summary> /// Determines the correct provider to use and sets up the connection and command /// objects for use in other methods /// </summary> /// <param name="connectString">The full connection string to the database</param> /// <param name="providerlist">The enum value of providers from dbutilities.Providers</param> public void CreateDBObjects(string connectString, Providers providerList) { //CreateDBObjects(connectString, providerList, null); switch (providerList) { case Providers.SqlServer: _factory = SqlClientFactory.Instance; break; case Providers.Oracle: _factory = OracleClientFactory.Instance; break; case Providers.OleDB: _factory = OleDbFactory.Instance; break; case Providers.ODBC: _factory = OdbcFactory.Instance; break; } _connection = _factory.CreateConnection(); _command = _factory.CreateCommand(); _connection.ConnectionString = connectString; _command.Connection = connection; }