///<Summary>
        ///Insert a new row
        ///This method saves a new object to the table IdentityUserLogin
        ///</Summary>
        ///<returns>
        ///void
        ///</returns>
        ///<parameters>
        ///
        ///</parameters>
        public virtual void Insert()
        {
            Doing(this);
            SqlCommand command = new SqlCommand();

            command.CommandText = InlineProcs.ctprIdentityUserLogin_InsertOne;
            command.CommandType = CommandType.Text;
            command.Connection  = _connectionProvider.Connection;
            command.Transaction = _connectionProvider.CurrentTransaction;

            try
            {
                command.Parameters.Add(CtSqlParameter.Get("@LoginProvider", SqlDbType.NVarChar, 128, ParameterDirection.InputOutput, false, 0, 0, "", DataRowVersion.Proposed, (object)_loginProvider ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@ProviderKey", SqlDbType.NVarChar, 128, ParameterDirection.InputOutput, false, 0, 0, "", DataRowVersion.Proposed, (object)_providerKey ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@UserId", SqlDbType.Int, 4, ParameterDirection.InputOutput, false, 10, 0, "", DataRowVersion.Proposed, (object)_userId ?? (object)DBNull.Value));

                command.ExecuteNonQuery();
                Done(this);

                _loginProvider = Convert.IsDBNull(command.Parameters["@LoginProvider"].Value) ? null : (string)command.Parameters["@LoginProvider"].Value;
                _providerKey   = Convert.IsDBNull(command.Parameters["@ProviderKey"].Value) ? null : (string)command.Parameters["@ProviderKey"].Value;
                _userId        = Convert.IsDBNull(command.Parameters["@UserId"].Value) ? (Int32?)null : (Int32?)command.Parameters["@UserId"].Value;
            }
            catch (Exception ex)
            {
                Failed(this, ex);
                Handle(this, ex);
            }
            finally
            {
                command.Dispose();
            }
        }
示例#2
0
        ///<Summary>
        ///Delete one row by primary key(s)
        ///this method allows the object to delete itself from the table CustomerDemographics based on its primary key
        ///</Summary>
        ///<returns>
        ///void
        ///</returns>
        ///<parameters>
        ///
        ///</parameters>
        public virtual void Delete()
        {
            Doing(this);
            SqlCommand command = new SqlCommand();

            command.CommandText = InlineProcs.ctprCustomerDemographics_DeleteOne;
            command.CommandType = CommandType.Text;
            command.Connection  = _connectionProvider.Connection;
            command.Transaction = _connectionProvider.CurrentTransaction;

            try
            {
                command.Parameters.Add(CtSqlParameter.Get("@CustomerTypeID", SqlDbType.NChar, 10, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, (object)_customerTypeID ?? (object)DBNull.Value));

                command.ExecuteNonQuery();
                Done(this);
            }
            catch (Exception ex)
            {
                Failed(this, ex);
                Handle(this, ex);
            }
            finally
            {
                command.Dispose();
            }
        }
        ///<Summary>
        ///Delete all by foreign key
        ///This method deletes all rows in the table CustomerCustomerDemo with a given foreign key
        ///</Summary>
        ///<returns>
        ///void
        ///</returns>
        ///<parameters>
        ///IzNorthwindRestApiConn_TxConnectionProvider connectionProvider, string customerTypeID
        ///</parameters>
        public static void DeleteAllByCustomerTypeID(IzNorthwindRestApiConn_TxConnectionProvider connectionProvider, string customerTypeID)
        {
            Doing(null);
            SqlCommand command = new SqlCommand();

            command.CommandText = InlineProcs.ctprCustomerCustomerDemo_DeleteAllByCustomerTypeID;
            command.CommandType = CommandType.Text;
            command.Connection  = connectionProvider.Connection;
            command.Transaction = connectionProvider.CurrentTransaction;

            try
            {
                command.Parameters.Add(CtSqlParameter.Get("@CustomerTypeID", SqlDbType.NChar, 10, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, (object)customerTypeID ?? (object)DBNull.Value));

                command.ExecuteNonQuery();
                Done(null);
            }
            catch (Exception ex)
            {
                Failed(null, ex);
                Handle(null, ex);
            }
            finally
            {
                command.Dispose();
            }
        }
        ///<Summary>
        ///Update one row by primary key(s)
        ///This method allows the object to update itself in the table IdentityRole based on its primary key(s)
        ///</Summary>
        ///<returns>
        ///void
        ///</returns>
        ///<parameters>
        ///
        ///</parameters>
        public virtual void Update()
        {
            Doing(this);
            SqlCommand command = new SqlCommand();

            command.CommandText = InlineProcs.ctprIdentityRole_UpdateOne;
            command.CommandType = CommandType.Text;
            command.Connection  = _connectionProvider.Connection;
            command.Transaction = _connectionProvider.CurrentTransaction;

            try
            {
                command.Parameters.Add(CtSqlParameter.Get("@Id", SqlDbType.Int, 4, ParameterDirection.InputOutput, false, 10, 0, "", DataRowVersion.Proposed, (object)_ıd ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@Name", SqlDbType.NVarChar, 256, ParameterDirection.InputOutput, false, 0, 0, "", DataRowVersion.Proposed, (object)_name ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@ctr_version", SqlDbType.Int, 4, ParameterDirection.InputOutput, false, 10, 0, "", DataRowVersion.Proposed, (object)_ctrVersion ?? (object)DBNull.Value));

                command.ExecuteNonQuery();
                Done(this);

                _ıd         = Convert.IsDBNull(command.Parameters["@Id"].Value) ? (Int32?)null : (Int32?)command.Parameters["@Id"].Value;
                _name       = Convert.IsDBNull(command.Parameters["@Name"].Value) ? null : (string)command.Parameters["@Name"].Value;
                _ctrVersion = Convert.IsDBNull(command.Parameters["@ctr_version"].Value) ? (Int32?)null : (Int32?)command.Parameters["@ctr_version"].Value;
            }
            catch (Exception ex)
            {
                Failed(this, ex);
                Handle(this, ex);
            }
            finally
            {
                command.Dispose();
            }
        }
        ///<Summary>
        ///Delete all by foreign key
        ///This method deletes all rows in the table IdentityUserClaim with a given foreign key
        ///</Summary>
        ///<returns>
        ///void
        ///</returns>
        ///<parameters>
        ///IzNorthwindRestApiConn_TxConnectionProvider connectionProvider, Int32? userId
        ///</parameters>
        public static void DeleteAllByUserId(IzNorthwindRestApiConn_TxConnectionProvider connectionProvider, Int32?userId)
        {
            Doing(null);
            SqlCommand command = new SqlCommand();

            command.CommandText = InlineProcs.ctprIdentityUserClaim_DeleteAllByUserId;
            command.CommandType = CommandType.Text;
            command.Connection  = connectionProvider.Connection;
            command.Transaction = connectionProvider.CurrentTransaction;

            try
            {
                command.Parameters.Add(CtSqlParameter.Get("@UserId", SqlDbType.Int, 4, ParameterDirection.Input, true, 10, 0, "", DataRowVersion.Proposed, (object)userId ?? (object)DBNull.Value));

                command.ExecuteNonQuery();
                Done(null);
            }
            catch (Exception ex)
            {
                Failed(null, ex);
                Handle(null, ex);
            }
            finally
            {
                command.Dispose();
            }
        }
示例#6
0
        ///<Summary>
        ///Delete one row by primary key(s)
        ///this method allows the object to delete itself from the table IdentityUserRole based on its primary key
        ///</Summary>
        ///<returns>
        ///void
        ///</returns>
        ///<parameters>
        ///
        ///</parameters>
        public virtual void Delete()
        {
            Doing(this);
            SqlCommand command = new SqlCommand();

            command.CommandText = InlineProcs.ctprIdentityUserRole_DeleteOne;
            command.CommandType = CommandType.Text;
            command.Connection  = _connectionProvider.Connection;
            command.Transaction = _connectionProvider.CurrentTransaction;

            try
            {
                command.Parameters.Add(CtSqlParameter.Get("@UserId", SqlDbType.Int, 4, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, (object)_userId ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@RoleId", SqlDbType.Int, 4, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, (object)_roleId ?? (object)DBNull.Value));

                command.ExecuteNonQuery();
                Done(this);
            }
            catch (Exception ex)
            {
                Failed(this, ex);
                Handle(this, ex);
            }
            finally
            {
                command.Dispose();
            }
        }
示例#7
0
        ///<Summary>
        ///Insert a new row
        ///This method saves a new object to the table Categories
        ///</Summary>
        ///<returns>
        ///void
        ///</returns>
        ///<parameters>
        ///
        ///</parameters>
        public virtual void Insert()
        {
            Doing(this);
            SqlCommand command = new SqlCommand();

            command.CommandText = InlineProcs.ctprCategories_InsertOne;
            command.CommandType = CommandType.Text;
            command.Connection  = _connectionProvider.Connection;
            command.Transaction = _connectionProvider.CurrentTransaction;

            try
            {
                command.Parameters.Add(CtSqlParameter.Get("@Description", SqlDbType.NText, 8000, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Proposed, (object)_description ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@Picture", SqlDbType.Image, 16, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Proposed, (object)_picture ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@CategoryID", SqlDbType.Int, 4, ParameterDirection.Output, false, 10, 0, "", DataRowVersion.Proposed, _categoryID));
                command.Parameters.Add(CtSqlParameter.Get("@CategoryName", SqlDbType.NVarChar, 15, ParameterDirection.InputOutput, false, 0, 0, "", DataRowVersion.Proposed, (object)_categoryName ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@ctr_version", SqlDbType.Int, 4, ParameterDirection.Output, false, 10, 0, "", DataRowVersion.Proposed, _ctrVersion));

                command.ExecuteNonQuery();
                Done(this);

                _categoryID   = Convert.IsDBNull(command.Parameters["@CategoryID"].Value) ? (Int32?)null : (Int32?)command.Parameters["@CategoryID"].Value;
                _categoryName = Convert.IsDBNull(command.Parameters["@CategoryName"].Value) ? null : (string)command.Parameters["@CategoryName"].Value;
                _ctrVersion   = Convert.IsDBNull(command.Parameters["@ctr_version"].Value) ? (Int32?)null : (Int32?)command.Parameters["@ctr_version"].Value;
            }
            catch (Exception ex)
            {
                Failed(this, ex);
                Handle(this, ex);
            }
            finally
            {
                command.Dispose();
            }
        }
示例#8
0
        ///<Summary>
        ///Insert a new row
        ///This method saves a new object to the table EmployeeTerritories
        ///</Summary>
        ///<returns>
        ///void
        ///</returns>
        ///<parameters>
        ///
        ///</parameters>
        public virtual void Insert()
        {
            Doing(this);
            SqlCommand command = new SqlCommand();

            command.CommandText = InlineProcs.ctprEmployeeTerritories_InsertOne;
            command.CommandType = CommandType.Text;
            command.Connection  = _connectionProvider.Connection;
            command.Transaction = _connectionProvider.CurrentTransaction;

            try
            {
                command.Parameters.Add(CtSqlParameter.Get("@EmployeeID", SqlDbType.Int, 4, ParameterDirection.InputOutput, false, 10, 0, "", DataRowVersion.Proposed, (object)_employeeID ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@TerritoryID", SqlDbType.NVarChar, 20, ParameterDirection.InputOutput, false, 0, 0, "", DataRowVersion.Proposed, (object)_territoryID ?? (object)DBNull.Value));

                command.ExecuteNonQuery();
                Done(this);

                _employeeID  = Convert.IsDBNull(command.Parameters["@EmployeeID"].Value) ? (Int32?)null : (Int32?)command.Parameters["@EmployeeID"].Value;
                _territoryID = Convert.IsDBNull(command.Parameters["@TerritoryID"].Value) ? null : (string)command.Parameters["@TerritoryID"].Value;
            }
            catch (Exception ex)
            {
                Failed(this, ex);
                Handle(this, ex);
            }
            finally
            {
                command.Dispose();
            }
        }
        ///<Summary>
        ///</Summary>
        ///<returns>
        ///Int32
        ///</returns>
        ///<parameters>
        ///Int32? userId
        ///</parameters>
        public static Int32 SelectAllByUserIdCount(Int32?userId)
        {
            Doing(null);
            SqlCommand command = new SqlCommand();

            command.CommandText = InlineProcs.ctprIdentityUserClaim_SelectAllByUserIdCount;
            command.CommandType = CommandType.Text;
            SqlConnection staticConnection = StaticSqlConnection;

            command.Connection = staticConnection;

            try
            {
                command.Parameters.Add(CtSqlParameter.Get("@UserId", SqlDbType.Int, 4, ParameterDirection.Input, true, 10, 0, "", DataRowVersion.Proposed, (object)userId ?? (object)DBNull.Value));

                staticConnection.Open();
                Int32 retCount = (Int32)command.ExecuteScalar();
                Done(null);

                return(retCount);
            }
            catch (Exception ex)
            {
                Failed(null, ex);
                Handle(null, ex);
                return(-1);
            }
            finally
            {
                staticConnection.Close();
                command.Dispose();
            }
        }
示例#10
0
        ///<Summary>
        ///Update one row by primary key(s)
        ///This method allows the object to update itself in the table CustomerDemographics based on its primary key(s)
        ///</Summary>
        ///<returns>
        ///void
        ///</returns>
        ///<parameters>
        ///
        ///</parameters>
        public virtual void Update()
        {
            Doing(this);
            SqlCommand command = new SqlCommand();

            command.CommandText = InlineProcs.ctprCustomerDemographics_UpdateOne;
            command.CommandType = CommandType.Text;
            command.Connection  = _connectionProvider.Connection;
            command.Transaction = _connectionProvider.CurrentTransaction;

            try
            {
                command.Parameters.Add(CtSqlParameter.Get("@CustomerDesc", SqlDbType.NText, 8000, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Proposed, (object)_customerDesc ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@CustomerTypeID", SqlDbType.NChar, 10, ParameterDirection.InputOutput, false, 0, 0, "", DataRowVersion.Proposed, (object)_customerTypeID ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@ctr_version", SqlDbType.Int, 4, ParameterDirection.InputOutput, false, 10, 0, "", DataRowVersion.Proposed, (object)_ctrVersion ?? (object)DBNull.Value));

                command.ExecuteNonQuery();
                Done(this);

                _customerTypeID = Convert.IsDBNull(command.Parameters["@CustomerTypeID"].Value) ? null : (string)command.Parameters["@CustomerTypeID"].Value;
                _ctrVersion     = Convert.IsDBNull(command.Parameters["@ctr_version"].Value) ? (Int32?)null : (Int32?)command.Parameters["@ctr_version"].Value;
            }
            catch (Exception ex)
            {
                Failed(this, ex);
                Handle(this, ex);
            }
            finally
            {
                command.Dispose();
            }
        }
        ///<Summary>
        ///</Summary>
        ///<returns>
        ///Int32
        ///</returns>
        ///<parameters>
        ///string customerTypeID
        ///</parameters>
        public static Int32 SelectAllByCustomerTypeIDCount(string customerTypeID)
        {
            Doing(null);
            SqlCommand command = new SqlCommand();

            command.CommandText = InlineProcs.ctprCustomerCustomerDemo_SelectAllByCustomerTypeIDCount;
            command.CommandType = CommandType.Text;
            SqlConnection staticConnection = StaticSqlConnection;

            command.Connection = staticConnection;

            try
            {
                command.Parameters.Add(CtSqlParameter.Get("@CustomerTypeID", SqlDbType.NChar, 10, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, (object)customerTypeID ?? (object)DBNull.Value));

                staticConnection.Open();
                Int32 retCount = (Int32)command.ExecuteScalar();
                Done(null);

                return(retCount);
            }
            catch (Exception ex)
            {
                Failed(null, ex);
                Handle(null, ex);
                return(-1);
            }
            finally
            {
                staticConnection.Close();
                command.Dispose();
            }
        }
示例#12
0
        ///<Summary>
        ///Select one row by primary key(s)
        ///This method returns one row from the table Suppliers based on the primary key(s)
        ///</Summary>
        ///<returns>
        ///IDAOSuppliers
        ///</returns>
        ///<parameters>
        ///Int32? supplierID
        ///</parameters>
        public static IDAOSuppliers SelectOne(Int32?supplierID)
        {
            Doing(null);
            SqlCommand command = new SqlCommand();

            command.CommandText = InlineProcs.ctprSuppliers_SelectOne;
            command.CommandType = CommandType.Text;
            SqlConnection staticConnection = StaticSqlConnection;

            command.Connection = staticConnection;

            DataTable      dt         = new DataTable("Suppliers");
            SqlDataAdapter sqlAdapter = new SqlDataAdapter(command);

            try
            {
                command.Parameters.Add(CtSqlParameter.Get("@SupplierID", SqlDbType.Int, 4, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, (object)supplierID ?? (object)DBNull.Value));

                staticConnection.Open();
                sqlAdapter.Fill(dt);
                Done(null);

                DAOSuppliers retObj = null;
                if (dt.Rows.Count > 0)
                {
                    retObj               = new DAOSuppliers();
                    retObj._supplierID   = Convert.IsDBNull(dt.Rows[0]["SupplierID"]) ? (Int32?)null : (Int32?)dt.Rows[0]["SupplierID"];
                    retObj._companyName  = Convert.IsDBNull(dt.Rows[0]["CompanyName"]) ? null : (string)dt.Rows[0]["CompanyName"];
                    retObj._contactName  = Convert.IsDBNull(dt.Rows[0]["ContactName"]) ? null : (string)dt.Rows[0]["ContactName"];
                    retObj._contactTitle = Convert.IsDBNull(dt.Rows[0]["ContactTitle"]) ? null : (string)dt.Rows[0]["ContactTitle"];
                    retObj._address      = Convert.IsDBNull(dt.Rows[0]["Address"]) ? null : (string)dt.Rows[0]["Address"];
                    retObj._city         = Convert.IsDBNull(dt.Rows[0]["City"]) ? null : (string)dt.Rows[0]["City"];
                    retObj._region       = Convert.IsDBNull(dt.Rows[0]["Region"]) ? null : (string)dt.Rows[0]["Region"];
                    retObj._postalCode   = Convert.IsDBNull(dt.Rows[0]["PostalCode"]) ? null : (string)dt.Rows[0]["PostalCode"];
                    retObj._country      = Convert.IsDBNull(dt.Rows[0]["Country"]) ? null : (string)dt.Rows[0]["Country"];
                    retObj._phone        = Convert.IsDBNull(dt.Rows[0]["Phone"]) ? null : (string)dt.Rows[0]["Phone"];
                    retObj._fax          = Convert.IsDBNull(dt.Rows[0]["Fax"]) ? null : (string)dt.Rows[0]["Fax"];
                    retObj._homePage     = Convert.IsDBNull(dt.Rows[0]["HomePage"]) ? null : (string)dt.Rows[0]["HomePage"];
                    retObj._ctrVersion   = Convert.IsDBNull(dt.Rows[0]["ctr_version"]) ? (Int32?)null : (Int32?)dt.Rows[0]["ctr_version"];
                }
                return(retObj);
            }
            catch (Exception ex)
            {
                Failed(null, ex);
                Handle(null, ex);
                return(null);
            }
            finally
            {
                staticConnection.Close();
                command.Dispose();
            }
        }
示例#13
0
        ///<Summary>
        ///Select one row by primary key(s)
        ///This method returns one row from the table IdentityUser based on the primary key(s)
        ///</Summary>
        ///<returns>
        ///IDAOIdentityUser
        ///</returns>
        ///<parameters>
        ///Int32? userId
        ///</parameters>
        public static IDAOIdentityUser SelectOne(Int32?userId)
        {
            Doing(null);
            SqlCommand command = new SqlCommand();

            command.CommandText = InlineProcs.ctprIdentityUser_SelectOne;
            command.CommandType = CommandType.Text;
            SqlConnection staticConnection = StaticSqlConnection;

            command.Connection = staticConnection;

            DataTable      dt         = new DataTable("IdentityUser");
            SqlDataAdapter sqlAdapter = new SqlDataAdapter(command);

            try
            {
                command.Parameters.Add(CtSqlParameter.Get("@UserId", SqlDbType.Int, 4, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, (object)userId ?? (object)DBNull.Value));

                staticConnection.Open();
                sqlAdapter.Fill(dt);
                Done(null);

                DAOIdentityUser retObj = null;
                if (dt.Rows.Count > 0)
                {
                    retObj                       = new DAOIdentityUser();
                    retObj._userId               = Convert.IsDBNull(dt.Rows[0]["UserId"]) ? (Int32?)null : (Int32?)dt.Rows[0]["UserId"];
                    retObj._email                = Convert.IsDBNull(dt.Rows[0]["Email"]) ? null : (string)dt.Rows[0]["Email"];
                    retObj._emailConfirmed       = Convert.IsDBNull(dt.Rows[0]["EmailConfirmed"]) ? (bool?)null : (bool?)dt.Rows[0]["EmailConfirmed"];
                    retObj._passwordHash         = Convert.IsDBNull(dt.Rows[0]["PasswordHash"]) ? null : (string)dt.Rows[0]["PasswordHash"];
                    retObj._securityStamp        = Convert.IsDBNull(dt.Rows[0]["SecurityStamp"]) ? null : (string)dt.Rows[0]["SecurityStamp"];
                    retObj._phoneNumber          = Convert.IsDBNull(dt.Rows[0]["PhoneNumber"]) ? null : (string)dt.Rows[0]["PhoneNumber"];
                    retObj._phoneNumberConfirmed = Convert.IsDBNull(dt.Rows[0]["PhoneNumberConfirmed"]) ? (bool?)null : (bool?)dt.Rows[0]["PhoneNumberConfirmed"];
                    retObj._twoFactorEnabled     = Convert.IsDBNull(dt.Rows[0]["TwoFactorEnabled"]) ? (bool?)null : (bool?)dt.Rows[0]["TwoFactorEnabled"];
                    retObj._lockoutEndDateUtc    = Convert.IsDBNull(dt.Rows[0]["LockoutEndDateUtc"]) ? (DateTime?)null : (DateTime?)dt.Rows[0]["LockoutEndDateUtc"];
                    retObj._lockoutEnabled       = Convert.IsDBNull(dt.Rows[0]["LockoutEnabled"]) ? (bool?)null : (bool?)dt.Rows[0]["LockoutEnabled"];
                    retObj._accessFailedCount    = Convert.IsDBNull(dt.Rows[0]["AccessFailedCount"]) ? (Int32?)null : (Int32?)dt.Rows[0]["AccessFailedCount"];
                    retObj._username             = Convert.IsDBNull(dt.Rows[0]["Username"]) ? null : (string)dt.Rows[0]["Username"];
                    retObj._ctrVersion           = Convert.IsDBNull(dt.Rows[0]["ctr_version"]) ? (Int32?)null : (Int32?)dt.Rows[0]["ctr_version"];
                }
                return(retObj);
            }
            catch (Exception ex)
            {
                Failed(null, ex);
                Handle(null, ex);
                return(null);
            }
            finally
            {
                staticConnection.Close();
                command.Dispose();
            }
        }
示例#14
0
        ///<Summary>
        ///Update one row by primary key(s)
        ///This method allows the object to update itself in the table IdentityUser based on its primary key(s)
        ///</Summary>
        ///<returns>
        ///void
        ///</returns>
        ///<parameters>
        ///
        ///</parameters>
        public virtual void Update()
        {
            Doing(this);
            SqlCommand command = new SqlCommand();

            command.CommandText = InlineProcs.ctprIdentityUser_UpdateOne;
            command.CommandType = CommandType.Text;
            command.Connection  = _connectionProvider.Connection;
            command.Transaction = _connectionProvider.CurrentTransaction;

            try
            {
                command.Parameters.Add(CtSqlParameter.Get("@UserId", SqlDbType.Int, 4, ParameterDirection.InputOutput, false, 10, 0, "", DataRowVersion.Proposed, (object)_userId ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@Email", SqlDbType.NVarChar, 256, ParameterDirection.InputOutput, true, 0, 0, "", DataRowVersion.Proposed, (object)_email ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@EmailConfirmed", SqlDbType.Bit, 1, ParameterDirection.InputOutput, false, 0, 0, "", DataRowVersion.Proposed, (object)_emailConfirmed ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@PasswordHash", SqlDbType.NVarChar, -1, ParameterDirection.InputOutput, true, 0, 0, "", DataRowVersion.Proposed, (object)_passwordHash ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@SecurityStamp", SqlDbType.NVarChar, -1, ParameterDirection.InputOutput, true, 0, 0, "", DataRowVersion.Proposed, (object)_securityStamp ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@PhoneNumber", SqlDbType.NVarChar, -1, ParameterDirection.InputOutput, true, 0, 0, "", DataRowVersion.Proposed, (object)_phoneNumber ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@PhoneNumberConfirmed", SqlDbType.Bit, 1, ParameterDirection.InputOutput, false, 0, 0, "", DataRowVersion.Proposed, (object)_phoneNumberConfirmed ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@TwoFactorEnabled", SqlDbType.Bit, 1, ParameterDirection.InputOutput, false, 0, 0, "", DataRowVersion.Proposed, (object)_twoFactorEnabled ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@LockoutEndDateUtc", SqlDbType.DateTime, 8, ParameterDirection.InputOutput, true, 0, 0, "", DataRowVersion.Proposed, (object)_lockoutEndDateUtc ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@LockoutEnabled", SqlDbType.Bit, 1, ParameterDirection.InputOutput, false, 0, 0, "", DataRowVersion.Proposed, (object)_lockoutEnabled ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@AccessFailedCount", SqlDbType.Int, 4, ParameterDirection.InputOutput, false, 10, 0, "", DataRowVersion.Proposed, (object)_accessFailedCount ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@Username", SqlDbType.NVarChar, 256, ParameterDirection.InputOutput, false, 0, 0, "", DataRowVersion.Proposed, (object)_username ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@ctr_version", SqlDbType.Int, 4, ParameterDirection.InputOutput, false, 10, 0, "", DataRowVersion.Proposed, (object)_ctrVersion ?? (object)DBNull.Value));

                command.ExecuteNonQuery();
                Done(this);

                _userId               = Convert.IsDBNull(command.Parameters["@UserId"].Value) ? (Int32?)null : (Int32?)command.Parameters["@UserId"].Value;
                _email                = Convert.IsDBNull(command.Parameters["@Email"].Value) ? null : (string)command.Parameters["@Email"].Value;
                _emailConfirmed       = Convert.IsDBNull(command.Parameters["@EmailConfirmed"].Value) ? (bool?)null : (bool?)command.Parameters["@EmailConfirmed"].Value;
                _passwordHash         = Convert.IsDBNull(command.Parameters["@PasswordHash"].Value) ? null : (string)command.Parameters["@PasswordHash"].Value;
                _securityStamp        = Convert.IsDBNull(command.Parameters["@SecurityStamp"].Value) ? null : (string)command.Parameters["@SecurityStamp"].Value;
                _phoneNumber          = Convert.IsDBNull(command.Parameters["@PhoneNumber"].Value) ? null : (string)command.Parameters["@PhoneNumber"].Value;
                _phoneNumberConfirmed = Convert.IsDBNull(command.Parameters["@PhoneNumberConfirmed"].Value) ? (bool?)null : (bool?)command.Parameters["@PhoneNumberConfirmed"].Value;
                _twoFactorEnabled     = Convert.IsDBNull(command.Parameters["@TwoFactorEnabled"].Value) ? (bool?)null : (bool?)command.Parameters["@TwoFactorEnabled"].Value;
                _lockoutEndDateUtc    = Convert.IsDBNull(command.Parameters["@LockoutEndDateUtc"].Value) ? (DateTime?)null : (DateTime?)command.Parameters["@LockoutEndDateUtc"].Value;
                _lockoutEnabled       = Convert.IsDBNull(command.Parameters["@LockoutEnabled"].Value) ? (bool?)null : (bool?)command.Parameters["@LockoutEnabled"].Value;
                _accessFailedCount    = Convert.IsDBNull(command.Parameters["@AccessFailedCount"].Value) ? (Int32?)null : (Int32?)command.Parameters["@AccessFailedCount"].Value;
                _username             = Convert.IsDBNull(command.Parameters["@Username"].Value) ? null : (string)command.Parameters["@Username"].Value;
                _ctrVersion           = Convert.IsDBNull(command.Parameters["@ctr_version"].Value) ? (Int32?)null : (Int32?)command.Parameters["@ctr_version"].Value;
            }
            catch (Exception ex)
            {
                Failed(this, ex);
                Handle(this, ex);
            }
            finally
            {
                command.Dispose();
            }
        }
示例#15
0
        ///<Summary>
        ///Update one row by primary key(s)
        ///This method allows the object to update itself in the table Suppliers based on its primary key(s)
        ///</Summary>
        ///<returns>
        ///void
        ///</returns>
        ///<parameters>
        ///
        ///</parameters>
        public virtual void Update()
        {
            Doing(this);
            SqlCommand command = new SqlCommand();

            command.CommandText = InlineProcs.ctprSuppliers_UpdateOne;
            command.CommandType = CommandType.Text;
            command.Connection  = _connectionProvider.Connection;
            command.Transaction = _connectionProvider.CurrentTransaction;

            try
            {
                command.Parameters.Add(CtSqlParameter.Get("@HomePage", SqlDbType.NText, 8000, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Proposed, (object)_homePage ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@SupplierID", SqlDbType.Int, 4, ParameterDirection.InputOutput, false, 10, 0, "", DataRowVersion.Proposed, (object)_supplierID ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@CompanyName", SqlDbType.NVarChar, 40, ParameterDirection.InputOutput, false, 0, 0, "", DataRowVersion.Proposed, (object)_companyName ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@ContactName", SqlDbType.NVarChar, 30, ParameterDirection.InputOutput, true, 0, 0, "", DataRowVersion.Proposed, (object)_contactName ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@ContactTitle", SqlDbType.NVarChar, 30, ParameterDirection.InputOutput, true, 0, 0, "", DataRowVersion.Proposed, (object)_contactTitle ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@Address", SqlDbType.NVarChar, 60, ParameterDirection.InputOutput, true, 0, 0, "", DataRowVersion.Proposed, (object)_address ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@City", SqlDbType.NVarChar, 15, ParameterDirection.InputOutput, true, 0, 0, "", DataRowVersion.Proposed, (object)_city ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@Region", SqlDbType.NVarChar, 15, ParameterDirection.InputOutput, true, 0, 0, "", DataRowVersion.Proposed, (object)_region ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@PostalCode", SqlDbType.NVarChar, 10, ParameterDirection.InputOutput, true, 0, 0, "", DataRowVersion.Proposed, (object)_postalCode ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@Country", SqlDbType.NVarChar, 15, ParameterDirection.InputOutput, true, 0, 0, "", DataRowVersion.Proposed, (object)_country ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@Phone", SqlDbType.NVarChar, 24, ParameterDirection.InputOutput, true, 0, 0, "", DataRowVersion.Proposed, (object)_phone ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@Fax", SqlDbType.NVarChar, 24, ParameterDirection.InputOutput, true, 0, 0, "", DataRowVersion.Proposed, (object)_fax ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@ctr_version", SqlDbType.Int, 4, ParameterDirection.InputOutput, false, 10, 0, "", DataRowVersion.Proposed, (object)_ctrVersion ?? (object)DBNull.Value));

                command.ExecuteNonQuery();
                Done(this);

                _supplierID   = Convert.IsDBNull(command.Parameters["@SupplierID"].Value) ? (Int32?)null : (Int32?)command.Parameters["@SupplierID"].Value;
                _companyName  = Convert.IsDBNull(command.Parameters["@CompanyName"].Value) ? null : (string)command.Parameters["@CompanyName"].Value;
                _contactName  = Convert.IsDBNull(command.Parameters["@ContactName"].Value) ? null : (string)command.Parameters["@ContactName"].Value;
                _contactTitle = Convert.IsDBNull(command.Parameters["@ContactTitle"].Value) ? null : (string)command.Parameters["@ContactTitle"].Value;
                _address      = Convert.IsDBNull(command.Parameters["@Address"].Value) ? null : (string)command.Parameters["@Address"].Value;
                _city         = Convert.IsDBNull(command.Parameters["@City"].Value) ? null : (string)command.Parameters["@City"].Value;
                _region       = Convert.IsDBNull(command.Parameters["@Region"].Value) ? null : (string)command.Parameters["@Region"].Value;
                _postalCode   = Convert.IsDBNull(command.Parameters["@PostalCode"].Value) ? null : (string)command.Parameters["@PostalCode"].Value;
                _country      = Convert.IsDBNull(command.Parameters["@Country"].Value) ? null : (string)command.Parameters["@Country"].Value;
                _phone        = Convert.IsDBNull(command.Parameters["@Phone"].Value) ? null : (string)command.Parameters["@Phone"].Value;
                _fax          = Convert.IsDBNull(command.Parameters["@Fax"].Value) ? null : (string)command.Parameters["@Fax"].Value;
                _ctrVersion   = Convert.IsDBNull(command.Parameters["@ctr_version"].Value) ? (Int32?)null : (Int32?)command.Parameters["@ctr_version"].Value;
            }
            catch (Exception ex)
            {
                Failed(this, ex);
                Handle(this, ex);
            }
            finally
            {
                command.Dispose();
            }
        }
示例#16
0
        ///<Summary>
        ///Select all rows by foreign key
        ///This method returns all data rows in the table Order Details based on a foreign key
        ///</Summary>
        ///<returns>
        ///IList-IDAOOrderDetails.
        ///</returns>
        ///<parameters>
        ///Int32? productID
        ///</parameters>
        public static IList <IDAOOrderDetails> SelectAllByProductID(Int32?productID)
        {
            Doing(null);
            SqlCommand command = new SqlCommand();

            command.CommandText = InlineProcs.ctprOrderDetails_SelectAllByProductID;
            command.CommandType = CommandType.Text;
            SqlConnection staticConnection = StaticSqlConnection;

            command.Connection = staticConnection;

            DataTable      dt         = new DataTable("Order Details");
            SqlDataAdapter sqlAdapter = new SqlDataAdapter(command);

            try
            {
                command.Parameters.Add(CtSqlParameter.Get("@ProductID", SqlDbType.Int, 4, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, (object)productID ?? (object)DBNull.Value));

                staticConnection.Open();
                sqlAdapter.Fill(dt);
                Done(null);

                List <IDAOOrderDetails> objList = new List <IDAOOrderDetails>();
                if (dt.Rows.Count > 0)
                {
                    foreach (DataRow row in dt.Rows)
                    {
                        DAOOrderDetails retObj = new DAOOrderDetails();
                        retObj._orderID    = Convert.IsDBNull(row["OrderID"]) ? (Int32?)null : (Int32?)row["OrderID"];
                        retObj._productID  = Convert.IsDBNull(row["ProductID"]) ? (Int32?)null : (Int32?)row["ProductID"];
                        retObj._unitPrice  = Convert.IsDBNull(row["UnitPrice"]) ? (decimal?)null : (decimal?)row["UnitPrice"];
                        retObj._quantity   = Convert.IsDBNull(row["Quantity"]) ? (Int16?)null : (Int16?)row["Quantity"];
                        retObj._discount   = Convert.IsDBNull(row["Discount"]) ? (float?)null : (float?)row["Discount"];
                        retObj._ctrVersion = Convert.IsDBNull(row["ctr_version"]) ? (Int32?)null : (Int32?)row["ctr_version"];
                        objList.Add(retObj);
                    }
                }
                return(objList);
            }
            catch (Exception ex)
            {
                Failed(null, ex);
                Handle(null, ex);
                return(null);
            }
            finally
            {
                staticConnection.Close();
                command.Dispose();
            }
        }
        ///<Summary>
        ///Select all rows by foreign key
        ///This method returns all data rows in the table IdentityUserClaim based on a foreign key
        ///</Summary>
        ///<returns>
        ///IList-IDAOIdentityUserClaim.
        ///</returns>
        ///<parameters>
        ///Int32? userId
        ///</parameters>
        public static IList <IDAOIdentityUserClaim> SelectAllByUserId(Int32?userId)
        {
            Doing(null);
            SqlCommand command = new SqlCommand();

            command.CommandText = InlineProcs.ctprIdentityUserClaim_SelectAllByUserId;
            command.CommandType = CommandType.Text;
            SqlConnection staticConnection = StaticSqlConnection;

            command.Connection = staticConnection;

            DataTable      dt         = new DataTable("IdentityUserClaim");
            SqlDataAdapter sqlAdapter = new SqlDataAdapter(command);

            try
            {
                command.Parameters.Add(CtSqlParameter.Get("@UserId", SqlDbType.Int, 4, ParameterDirection.Input, true, 10, 0, "", DataRowVersion.Proposed, (object)userId ?? (object)DBNull.Value));

                staticConnection.Open();
                sqlAdapter.Fill(dt);
                Done(null);

                List <IDAOIdentityUserClaim> objList = new List <IDAOIdentityUserClaim>();
                if (dt.Rows.Count > 0)
                {
                    foreach (DataRow row in dt.Rows)
                    {
                        DAOIdentityUserClaim retObj = new DAOIdentityUserClaim();
                        retObj._ıd         = Convert.IsDBNull(row["Id"]) ? (Int32?)null : (Int32?)row["Id"];
                        retObj._userId     = Convert.IsDBNull(row["UserId"]) ? (Int32?)null : (Int32?)row["UserId"];
                        retObj._claimType  = Convert.IsDBNull(row["ClaimType"]) ? null : (string)row["ClaimType"];
                        retObj._claimValue = Convert.IsDBNull(row["ClaimValue"]) ? null : (string)row["ClaimValue"];
                        retObj._ctrVersion = Convert.IsDBNull(row["ctr_version"]) ? (Int32?)null : (Int32?)row["ctr_version"];
                        objList.Add(retObj);
                    }
                }
                return(objList);
            }
            catch (Exception ex)
            {
                Failed(null, ex);
                Handle(null, ex);
                return(null);
            }
            finally
            {
                staticConnection.Close();
                command.Dispose();
            }
        }
示例#18
0
        ///<Summary>
        ///Select all rows by foreign key
        ///This method returns all data rows in the table Territories based on a foreign key
        ///</Summary>
        ///<returns>
        ///IList-IDAOTerritories.
        ///</returns>
        ///<parameters>
        ///Int32? regionID
        ///</parameters>
        public static IList <IDAOTerritories> SelectAllByRegionID(Int32?regionID)
        {
            Doing(null);
            SqlCommand command = new SqlCommand();

            command.CommandText = InlineProcs.ctprTerritories_SelectAllByRegionID;
            command.CommandType = CommandType.Text;
            SqlConnection staticConnection = StaticSqlConnection;

            command.Connection = staticConnection;

            DataTable      dt         = new DataTable("Territories");
            SqlDataAdapter sqlAdapter = new SqlDataAdapter(command);

            try
            {
                command.Parameters.Add(CtSqlParameter.Get("@RegionID", SqlDbType.Int, 4, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, (object)regionID ?? (object)DBNull.Value));

                staticConnection.Open();
                sqlAdapter.Fill(dt);
                Done(null);

                List <IDAOTerritories> objList = new List <IDAOTerritories>();
                if (dt.Rows.Count > 0)
                {
                    foreach (DataRow row in dt.Rows)
                    {
                        DAOTerritories retObj = new DAOTerritories();
                        retObj._territoryID          = Convert.IsDBNull(row["TerritoryID"]) ? null : (string)row["TerritoryID"];
                        retObj._territoryDescription = Convert.IsDBNull(row["TerritoryDescription"]) ? null : (string)row["TerritoryDescription"];
                        retObj._regionID             = Convert.IsDBNull(row["RegionID"]) ? (Int32?)null : (Int32?)row["RegionID"];
                        retObj._ctrVersion           = Convert.IsDBNull(row["ctr_version"]) ? (Int32?)null : (Int32?)row["ctr_version"];
                        objList.Add(retObj);
                    }
                }
                return(objList);
            }
            catch (Exception ex)
            {
                Failed(null, ex);
                Handle(null, ex);
                return(null);
            }
            finally
            {
                staticConnection.Close();
                command.Dispose();
            }
        }
        ///<Summary>
        ///Select all rows by foreign key
        ///This method returns all data rows in the table CustomerCustomerDemo based on a foreign key
        ///</Summary>
        ///<returns>
        ///IList-IDAOCustomerCustomerDemo.
        ///</returns>
        ///<parameters>
        ///string customerTypeID
        ///</parameters>
        public static IList <IDAOCustomerCustomerDemo> SelectAllByCustomerTypeID(string customerTypeID)
        {
            Doing(null);
            SqlCommand command = new SqlCommand();

            command.CommandText = InlineProcs.ctprCustomerCustomerDemo_SelectAllByCustomerTypeID;
            command.CommandType = CommandType.Text;
            SqlConnection staticConnection = StaticSqlConnection;

            command.Connection = staticConnection;

            DataTable      dt         = new DataTable("CustomerCustomerDemo");
            SqlDataAdapter sqlAdapter = new SqlDataAdapter(command);

            try
            {
                command.Parameters.Add(CtSqlParameter.Get("@CustomerTypeID", SqlDbType.NChar, 10, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, (object)customerTypeID ?? (object)DBNull.Value));

                staticConnection.Open();
                sqlAdapter.Fill(dt);
                Done(null);

                List <IDAOCustomerCustomerDemo> objList = new List <IDAOCustomerCustomerDemo>();
                if (dt.Rows.Count > 0)
                {
                    foreach (DataRow row in dt.Rows)
                    {
                        DAOCustomerCustomerDemo retObj = new DAOCustomerCustomerDemo();
                        retObj._customerID     = Convert.IsDBNull(row["CustomerID"]) ? null : (string)row["CustomerID"];
                        retObj._customerTypeID = Convert.IsDBNull(row["CustomerTypeID"]) ? null : (string)row["CustomerTypeID"];
                        objList.Add(retObj);
                    }
                }
                return(objList);
            }
            catch (Exception ex)
            {
                Failed(null, ex);
                Handle(null, ex);
                return(null);
            }
            finally
            {
                staticConnection.Close();
                command.Dispose();
            }
        }
示例#20
0
        ///<Summary>
        ///Select one row by primary key(s)
        ///This method returns one row from the table Categories based on the primary key(s)
        ///</Summary>
        ///<returns>
        ///IDAOCategories
        ///</returns>
        ///<parameters>
        ///Int32? categoryID
        ///</parameters>
        public static IDAOCategories SelectOne(Int32?categoryID)
        {
            Doing(null);
            SqlCommand command = new SqlCommand();

            command.CommandText = InlineProcs.ctprCategories_SelectOne;
            command.CommandType = CommandType.Text;
            SqlConnection staticConnection = StaticSqlConnection;

            command.Connection = staticConnection;

            DataTable      dt         = new DataTable("Categories");
            SqlDataAdapter sqlAdapter = new SqlDataAdapter(command);

            try
            {
                command.Parameters.Add(CtSqlParameter.Get("@CategoryID", SqlDbType.Int, 4, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, (object)categoryID ?? (object)DBNull.Value));

                staticConnection.Open();
                sqlAdapter.Fill(dt);
                Done(null);

                DAOCategories retObj = null;
                if (dt.Rows.Count > 0)
                {
                    retObj               = new DAOCategories();
                    retObj._categoryID   = Convert.IsDBNull(dt.Rows[0]["CategoryID"]) ? (Int32?)null : (Int32?)dt.Rows[0]["CategoryID"];
                    retObj._categoryName = Convert.IsDBNull(dt.Rows[0]["CategoryName"]) ? null : (string)dt.Rows[0]["CategoryName"];
                    retObj._description  = Convert.IsDBNull(dt.Rows[0]["Description"]) ? null : (string)dt.Rows[0]["Description"];
                    retObj._picture      = Convert.IsDBNull(dt.Rows[0]["Picture"]) ? null : (byte[])dt.Rows[0]["Picture"];
                    retObj._ctrVersion   = Convert.IsDBNull(dt.Rows[0]["ctr_version"]) ? (Int32?)null : (Int32?)dt.Rows[0]["ctr_version"];
                }
                return(retObj);
            }
            catch (Exception ex)
            {
                Failed(null, ex);
                Handle(null, ex);
                return(null);
            }
            finally
            {
                staticConnection.Close();
                command.Dispose();
            }
        }
        ///<Summary>
        ///Select one row by primary key(s)
        ///This method returns one row from the table IdentityUserLogin based on the primary key(s)
        ///</Summary>
        ///<returns>
        ///IDAOIdentityUserLogin
        ///</returns>
        ///<parameters>
        ///string loginProvider, string providerKey, Int32? userId
        ///</parameters>
        public static IDAOIdentityUserLogin SelectOne(string loginProvider, string providerKey, Int32?userId)
        {
            Doing(null);
            SqlCommand command = new SqlCommand();

            command.CommandText = InlineProcs.ctprIdentityUserLogin_SelectOne;
            command.CommandType = CommandType.Text;
            SqlConnection staticConnection = StaticSqlConnection;

            command.Connection = staticConnection;

            DataTable      dt         = new DataTable("IdentityUserLogin");
            SqlDataAdapter sqlAdapter = new SqlDataAdapter(command);

            try
            {
                command.Parameters.Add(CtSqlParameter.Get("@LoginProvider", SqlDbType.NVarChar, 128, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, (object)loginProvider ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@ProviderKey", SqlDbType.NVarChar, 128, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, (object)providerKey ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@UserId", SqlDbType.Int, 4, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, (object)userId ?? (object)DBNull.Value));

                staticConnection.Open();
                sqlAdapter.Fill(dt);
                Done(null);

                DAOIdentityUserLogin retObj = null;
                if (dt.Rows.Count > 0)
                {
                    retObj = new DAOIdentityUserLogin();
                    retObj._loginProvider = Convert.IsDBNull(dt.Rows[0]["LoginProvider"]) ? null : (string)dt.Rows[0]["LoginProvider"];
                    retObj._providerKey   = Convert.IsDBNull(dt.Rows[0]["ProviderKey"]) ? null : (string)dt.Rows[0]["ProviderKey"];
                    retObj._userId        = Convert.IsDBNull(dt.Rows[0]["UserId"]) ? (Int32?)null : (Int32?)dt.Rows[0]["UserId"];
                }
                return(retObj);
            }
            catch (Exception ex)
            {
                Failed(null, ex);
                Handle(null, ex);
                return(null);
            }
            finally
            {
                staticConnection.Close();
                command.Dispose();
            }
        }
        ///<Summary>
        ///Select one row by primary key(s)
        ///This method returns one row from the table IdentityUserClaim based on the primary key(s)
        ///</Summary>
        ///<returns>
        ///IDAOIdentityUserClaim
        ///</returns>
        ///<parameters>
        ///Int32? ıd
        ///</parameters>
        public static IDAOIdentityUserClaim SelectOne(Int32?ıd)
        {
            Doing(null);
            SqlCommand command = new SqlCommand();

            command.CommandText = InlineProcs.ctprIdentityUserClaim_SelectOne;
            command.CommandType = CommandType.Text;
            SqlConnection staticConnection = StaticSqlConnection;

            command.Connection = staticConnection;

            DataTable      dt         = new DataTable("IdentityUserClaim");
            SqlDataAdapter sqlAdapter = new SqlDataAdapter(command);

            try
            {
                command.Parameters.Add(CtSqlParameter.Get("@Id", SqlDbType.Int, 4, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, (object)ıd ?? (object)DBNull.Value));

                staticConnection.Open();
                sqlAdapter.Fill(dt);
                Done(null);

                DAOIdentityUserClaim retObj = null;
                if (dt.Rows.Count > 0)
                {
                    retObj             = new DAOIdentityUserClaim();
                    retObj._ıd         = Convert.IsDBNull(dt.Rows[0]["Id"]) ? (Int32?)null : (Int32?)dt.Rows[0]["Id"];
                    retObj._userId     = Convert.IsDBNull(dt.Rows[0]["UserId"]) ? (Int32?)null : (Int32?)dt.Rows[0]["UserId"];
                    retObj._claimType  = Convert.IsDBNull(dt.Rows[0]["ClaimType"]) ? null : (string)dt.Rows[0]["ClaimType"];
                    retObj._claimValue = Convert.IsDBNull(dt.Rows[0]["ClaimValue"]) ? null : (string)dt.Rows[0]["ClaimValue"];
                    retObj._ctrVersion = Convert.IsDBNull(dt.Rows[0]["ctr_version"]) ? (Int32?)null : (Int32?)dt.Rows[0]["ctr_version"];
                }
                return(retObj);
            }
            catch (Exception ex)
            {
                Failed(null, ex);
                Handle(null, ex);
                return(null);
            }
            finally
            {
                staticConnection.Close();
                command.Dispose();
            }
        }
示例#23
0
        ///<Summary>
        ///Select one row by primary key(s)
        ///This method returns one row from the table EmployeeTerritories based on the primary key(s)
        ///</Summary>
        ///<returns>
        ///IDAOEmployeeTerritories
        ///</returns>
        ///<parameters>
        ///Int32? employeeID, string territoryID
        ///</parameters>
        public static IDAOEmployeeTerritories SelectOne(Int32?employeeID, string territoryID)
        {
            Doing(null);
            SqlCommand command = new SqlCommand();

            command.CommandText = InlineProcs.ctprEmployeeTerritories_SelectOne;
            command.CommandType = CommandType.Text;
            SqlConnection staticConnection = StaticSqlConnection;

            command.Connection = staticConnection;

            DataTable      dt         = new DataTable("EmployeeTerritories");
            SqlDataAdapter sqlAdapter = new SqlDataAdapter(command);

            try
            {
                command.Parameters.Add(CtSqlParameter.Get("@EmployeeID", SqlDbType.Int, 4, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, (object)employeeID ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@TerritoryID", SqlDbType.NVarChar, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, (object)territoryID ?? (object)DBNull.Value));

                staticConnection.Open();
                sqlAdapter.Fill(dt);
                Done(null);

                DAOEmployeeTerritories retObj = null;
                if (dt.Rows.Count > 0)
                {
                    retObj              = new DAOEmployeeTerritories();
                    retObj._employeeID  = Convert.IsDBNull(dt.Rows[0]["EmployeeID"]) ? (Int32?)null : (Int32?)dt.Rows[0]["EmployeeID"];
                    retObj._territoryID = Convert.IsDBNull(dt.Rows[0]["TerritoryID"]) ? null : (string)dt.Rows[0]["TerritoryID"];
                }
                return(retObj);
            }
            catch (Exception ex)
            {
                Failed(null, ex);
                Handle(null, ex);
                return(null);
            }
            finally
            {
                staticConnection.Close();
                command.Dispose();
            }
        }
示例#24
0
        ///<Summary>
        ///Update one row by primary key(s)
        ///This method allows the object to update itself in the table Order Details based on its primary key(s)
        ///</Summary>
        ///<returns>
        ///void
        ///</returns>
        ///<parameters>
        ///
        ///</parameters>
        public virtual void Update()
        {
            Doing(this);
            SqlCommand command = new SqlCommand();

            command.CommandText = InlineProcs.ctprOrderDetails_UpdateOne;
            command.CommandType = CommandType.Text;
            command.Connection  = _connectionProvider.Connection;
            command.Transaction = _connectionProvider.CurrentTransaction;

            try
            {
                command.Parameters.Add(CtSqlParameter.Get("@OrderID", SqlDbType.Int, 4, ParameterDirection.InputOutput, false, 10, 0, "", DataRowVersion.Proposed, (object)_orderID ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@ProductID", SqlDbType.Int, 4, ParameterDirection.InputOutput, false, 10, 0, "", DataRowVersion.Proposed, (object)_productID ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@UnitPrice", SqlDbType.Money, 8, ParameterDirection.InputOutput, false, 19, 4, "", DataRowVersion.Proposed, (object)_unitPrice ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@Quantity", SqlDbType.SmallInt, 2, ParameterDirection.InputOutput, false, 5, 0, "", DataRowVersion.Proposed, (object)_quantity ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@Discount", SqlDbType.Real, 4, ParameterDirection.InputOutput, false, 24, 0, "", DataRowVersion.Proposed, (object)_discount ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@ctr_version", SqlDbType.Int, 4, ParameterDirection.InputOutput, false, 10, 0, "", DataRowVersion.Proposed, (object)_ctrVersion ?? (object)DBNull.Value));

                command.ExecuteNonQuery();
                Done(this);

                _orderID    = Convert.IsDBNull(command.Parameters["@OrderID"].Value) ? (Int32?)null : (Int32?)command.Parameters["@OrderID"].Value;
                _productID  = Convert.IsDBNull(command.Parameters["@ProductID"].Value) ? (Int32?)null : (Int32?)command.Parameters["@ProductID"].Value;
                _unitPrice  = Convert.IsDBNull(command.Parameters["@UnitPrice"].Value) ? (decimal?)null : (decimal?)command.Parameters["@UnitPrice"].Value;
                _quantity   = Convert.IsDBNull(command.Parameters["@Quantity"].Value) ? (Int16?)null : (Int16?)command.Parameters["@Quantity"].Value;
                _discount   = Convert.IsDBNull(command.Parameters["@Discount"].Value) ? (float?)null : (float?)command.Parameters["@Discount"].Value;
                _ctrVersion = Convert.IsDBNull(command.Parameters["@ctr_version"].Value) ? (Int32?)null : (Int32?)command.Parameters["@ctr_version"].Value;
            }
            catch (Exception ex)
            {
                Failed(this, ex);
                Handle(this, ex);
            }
            finally
            {
                command.Dispose();
            }
        }
        ///<Summary>
        ///Insert a new row
        ///This method saves a new object to the table IdentityUserProfile
        ///</Summary>
        ///<returns>
        ///void
        ///</returns>
        ///<parameters>
        ///
        ///</parameters>
        public virtual void Insert()
        {
            Doing(this);
            SqlCommand command = new SqlCommand();

            command.CommandText = InlineProcs.ctprIdentityUserProfile_InsertOne;
            command.CommandType = CommandType.Text;
            command.Connection  = _connectionProvider.Connection;
            command.Transaction = _connectionProvider.CurrentTransaction;

            try
            {
                command.Parameters.Add(CtSqlParameter.Get("@UserId", SqlDbType.Int, 4, ParameterDirection.InputOutput, false, 10, 0, "", DataRowVersion.Proposed, (object)_userId ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@FirstName", SqlDbType.VarChar, 50, ParameterDirection.InputOutput, true, 0, 0, "", DataRowVersion.Proposed, (object)_firstName ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@LastName", SqlDbType.VarChar, 50, ParameterDirection.InputOutput, true, 0, 0, "", DataRowVersion.Proposed, (object)_lastName ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@FullName", SqlDbType.VarChar, 100, ParameterDirection.InputOutput, true, 0, 0, "", DataRowVersion.Proposed, (object)_fullName ?? (object)DBNull.Value));
                command.Parameters.Add(CtSqlParameter.Get("@ctr_version", SqlDbType.Int, 4, ParameterDirection.Output, false, 10, 0, "", DataRowVersion.Proposed, _ctrVersion));

                command.ExecuteNonQuery();
                Done(this);

                _userId     = Convert.IsDBNull(command.Parameters["@UserId"].Value) ? (Int32?)null : (Int32?)command.Parameters["@UserId"].Value;
                _firstName  = Convert.IsDBNull(command.Parameters["@FirstName"].Value) ? null : (string)command.Parameters["@FirstName"].Value;
                _lastName   = Convert.IsDBNull(command.Parameters["@LastName"].Value) ? null : (string)command.Parameters["@LastName"].Value;
                _fullName   = Convert.IsDBNull(command.Parameters["@FullName"].Value) ? null : (string)command.Parameters["@FullName"].Value;
                _ctrVersion = Convert.IsDBNull(command.Parameters["@ctr_version"].Value) ? (Int32?)null : (Int32?)command.Parameters["@ctr_version"].Value;
            }
            catch (Exception ex)
            {
                Failed(this, ex);
                Handle(this, ex);
            }
            finally
            {
                command.Dispose();
            }
        }