public override void LoadData(DataRow CurrentDataRow, IDbConnection conn)
		{
			IsLoaded = false;
			CurrentFRDBase = (GISADataset.FRDBaseRow)CurrentDataRow;
			
			IsLoaded = true;
		}
Ejemplo n.º 2
1
 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);
 }
Ejemplo n.º 4
0
 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);
        }
Ejemplo n.º 6
0
 private static void DisposeCommandAndReader(IDbConnection connection, IDbCommand command, IDataReader reader)
 {
     using (connection)
     using (command)
     using (reader)
     { /* NoOp */ }
 }
Ejemplo n.º 7
0
        public WellKnownCore(IDbConnection connection)
            : base(PATH)
        {
            _connection = connection;

            Get["/", runAsync: true] = GetCore;
        }
Ejemplo n.º 8
0
 public RuntimeContext(IDbConnection connection, IDbTransaction transaction, IDbCommandExecutor executor, IProviderMetadata providerMetadata, IMigrationStepMetadata stepMetadata)
     : base(providerMetadata, stepMetadata)
 {
     _connection = connection;
     _transaction = transaction;
     _executor = executor;
 }
Ejemplo n.º 9
0
        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>();
                }

            }
        }
Ejemplo n.º 10
0
 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>();
 }
Ejemplo n.º 12
0
        /// <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)");
			}
		}
Ejemplo n.º 13
0
 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);
        }
Ejemplo n.º 15
0
        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;
        }
Ejemplo n.º 16
0
 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;
 }
Ejemplo n.º 18
0
        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?
                }
            }
        }
Ejemplo n.º 20
0
 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();
 }
Ejemplo n.º 21
0
        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;
          }
      }
 }
Ejemplo n.º 23
0
        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();
 }
Ejemplo n.º 25
0
        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 ();
        }
Ejemplo n.º 26
0
 /// <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 = "Удаление возможно." };
     }
 }
Ejemplo n.º 27
0
        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>();
 }
Ejemplo n.º 30
0
    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));
    }
Ejemplo n.º 31
0
 /// <inheritdoc/>
 public override InsightBulkCopyOptions GetSupportedBulkCopyOptions(IDbConnection connection)
 {
     return(InsightBulkCopyOptions.UseInternalTransaction);
 }
 public ServiceFrecuencyRepository(IDbConnection connection)
 {
     this.connection = connection;
 }
Ejemplo n.º 33
0
 public SQLiteProcessor(IDbConnection connection, IMigrationGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options, IDbFactory factory)
     : base(connection, factory, generator, announcer, options)
 {
 }
Ejemplo n.º 34
0
 public ATMRepository()
 {
     _db = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);
 }
Ejemplo n.º 35
0
		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));
 }
Ejemplo n.º 38
0
 public ChildAotInsertionService(IServiceProvider services, IDbConnection db)
 {
     this.db = db;
     this.services = services;
 }
Ejemplo n.º 39
0
 /// <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));
 }
Ejemplo n.º 40
0
 public void SetUp()
 {
     db = appHost.TryResolve <IDbConnectionFactory>().OpenDbConnection();
     db.DropAndCreateTable <Reqstar>();
     db.Insert(ReqstarsService.SeedData);
 }
Ejemplo n.º 41
0
        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();
            }
        }
Ejemplo n.º 42
0
 /// <summary>
 /// Override the database connection
 /// </summary>
 /// <param name="databaseConnection">New database connection</param>
 public void OverrideDatabaseDriver(IDbConnection databaseConnection)
 {
     this.DatabaseManager.OverrideDriver(() => databaseConnection);
 }
Ejemplo n.º 43
0
 public MarketOrder(IDbConnection connection, IMemoryCache memoryCache) : base(connection, memoryCache)
 {
 }
Ejemplo n.º 44
0
 public SqlServerDataRepository(IDbConnection dbConnection)
 {
     _dbConnection = dbConnection;
 }
Ejemplo n.º 45
0
 public BaseUnitOfWork(IConnectionFactory factory)
 {
     Connection  = factory.Open();
     Transaction = Connection.BeginTransaction();
 }
Ejemplo n.º 46
0
 //Consturctor
 public DapperDepartmentRepository(IDbConnection connection)
 {
     _connection = connection;
 }
Ejemplo n.º 47
0
 public override bool IsCompatibleConnection(IDbConnection connection)
 {
     return(typeof(OdbcConnection).IsSameOrParentOf(Proxy.GetUnderlyingObject((DbConnection)connection).GetType()));
 }
Ejemplo n.º 48
0
        /// <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));
        }
Ejemplo n.º 49
0
        /// <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);
        }
Ejemplo n.º 50
0
 //Khởi tạo kết nối
 public DbconnectionV1()
 {
     _dbConnection = new MySqlConnection(_connectionString);
 }
Ejemplo n.º 51
0
 public SqlServerWithExistingConnectionPublisher(IDbConnection connection)
 {
     this.connection = connection;
 }
 public InvoiceRepository(IDbConnection connection) : base(connection)
 {
 }
Ejemplo n.º 53
0
        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);
        }
Ejemplo n.º 54
0
 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));
 }
Ejemplo n.º 56
0
 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);
 }
Ejemplo n.º 57
0
 public SoodaDataSource OpenDataSource(string name, IDbConnection connection)
 {
     return(OpenDataSource(Schema.GetDataSourceInfo(name), connection));
 }
Ejemplo n.º 58
0
 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);
 }
Ejemplo n.º 59
0
 public RetrieveResponse <MyRow> Retrieve(IDbConnection connection, RetrieveRequest request)
 {
     return(new MyRetrieveHandler().Process(connection, request));
 }
Ejemplo n.º 60
-1
        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);
        }