Exemplo n.º 1
0
        /// <summary>
        /// Returns an array of the immutable LSSInfo objects that correspond to the supplied lssInfo IDs. 
        /// </summary>
        /// <param name="lssInfoIds"></param>
        /// <returns></returns>
        public static LSSInfo[] GetLSSInfos(int[] lssInfoIds)
        {
            LSSInfo[] lssInfos=new LSSInfo[lssInfoIds.Length];
            for(int i=0; i<lssInfoIds.Length;i++)
            {
                lssInfos[i]=new LSSInfo();
            }
            // create sql connection
            DbConnection connection = FactoryDB.GetConnection();

            // create sql command
            // command executes the "RetrieveLSSInfoByID" stored procedure
            DbCommand cmd = FactoryDB.CreateCommand("RetrieveLSSInfoByID", connection);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add(FactoryDB.CreateParameter(cmd,"@lssInfoId", null, DbType.Int32));
            //execute the command
            try
            {
                connection.Open();
                for(int i=0;i<lssInfoIds.Length;i++)
                {
                    // populate the parameters
                    cmd.Parameters["@lssInfoId"].Value = lssInfoIds[i];
                    DbDataReader dataReader = null;
                    dataReader=cmd.ExecuteReader();
                    while(dataReader.Read())
                    {
                        lssInfos[i].lssInfoId=lssInfoIds[i];
                        if(dataReader[0] != System.DBNull.Value )
                            lssInfos[i].lssGuid=dataReader.GetString(0);
                        if(dataReader[1] != System.DBNull.Value )
                            lssInfos[i].lssName=dataReader.GetString(1);
                        if(dataReader[2] != System.DBNull.Value )
                            lssInfos[i].lssUrl=dataReader.GetString(2);
                    }
                    dataReader.Close();
                }
            }

            catch (Exception ex)
            {
                throw new Exception("Exception thrown in get lssInfo",ex);
            }
            finally
            {
                connection.Close();
            }
            return lssInfos;
        }
        /// <summary>
        /// Returns a LSSInfo object that correspond to the supplied lssInfo Guid. 
        /// </summary>
        /// <param name="connection">An open connection</param>
        /// <param name="lssguid"></param>
        /// <returns></returns>
        public LSSInfo GetLSSInfo( DbConnection connection, string lssGuid)
        {
            LSSInfo lssInfo = null;

            // create sql command
            DbCommand cmd = FactoryDB.CreateCommand("RetrieveLSSInfoByGUID", connection);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add(FactoryDB.CreateParameter("@lssGuid", lssGuid, DbType.AnsiString, 50));

            //execute the command
            try
            {
                DbDataReader dataReader = null;
                dataReader = cmd.ExecuteReader();
                while (dataReader.Read())
                {
                    lssInfo = new LSSInfo();
                    lssInfo.lssInfoId = dataReader.GetInt32(0);
                    if (!dataReader.IsDBNull(1))
                        lssInfo.lssGuid = dataReader.GetString(1);
                    if (!dataReader.IsDBNull(2))
                        lssInfo.lssName = dataReader.GetString(2);
                    if (!dataReader.IsDBNull(3))
                        lssInfo.lssUrl = dataReader.GetString(3);
                    lssInfo.revokeCouponID = dataReader.GetInt64(4);
                    if (!dataReader.IsDBNull(5))
                        lssInfo.domainGuid = dataReader.GetString(5);
                }
                dataReader.Close();
            }

            catch (Exception ex)
            {
                throw new Exception("Exception thrown in get lssInfo", ex);
            }
            return lssInfo;
        }
Exemplo n.º 3
0
        /// <summary>
        /// Returns an array of the immutable LSSInfo objects that correspond to the supplied lssInfo IDs. 
        /// </summary>
        /// <param name="lssInfoIds"></param>
        /// <returns></returns>
        public static LSSInfo GetLSSInfo(string lssGuid)
        {
            LSSInfo lssInfo = new LSSInfo();

            // create sql connection
            DbConnection connection = FactoryDB.GetConnection();

            // create sql command
            DbCommand cmd = FactoryDB.CreateCommand("RetrieveLSSInfoByGUID", connection);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add(FactoryDB.CreateParameter(cmd,"@lssGuid", lssGuid, DbType.AnsiString, 50));

            //execute the command
            try
            {
                connection.Open();
                DbDataReader dataReader = null;
                dataReader = cmd.ExecuteReader();
                while (dataReader.Read())
                {
                    lssInfo.lssInfoId = dataReader.GetInt32(0);
                    if (dataReader[1] != System.DBNull.Value)
                        lssInfo.lssGuid = dataReader.GetString(1);
                    if (dataReader[2] != System.DBNull.Value)
                        lssInfo.lssName = dataReader.GetString(2);
                    if (dataReader[3] != System.DBNull.Value)
                        lssInfo.lssUrl = dataReader.GetString(3);
                }
                dataReader.Close();
            }

            catch (Exception ex)
            {
                throw new Exception("Exception thrown in get lssInfo", ex);
            }
            finally
            {
                connection.Close();
            }
            return lssInfo;
        }
Exemplo n.º 4
0
 /// <summary>
 /// This method fires when the LSS dropdown changes.
 /// If the index is greater than zero, the specified LSS will be looked up
 /// and its values will be used to populate the text fields on the form.
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 protected void ddlLSS_SelectedIndexChanged(object sender, System.EventArgs e)
 {
     if (ddlLSS.SelectedIndex == 0)
     // prepare for a new record
     {
         ClearFormFields();
         SetReadOnly(false);
     }
     else
     //retrieve an existing record
     {
         LSSInfo ui = new LSSInfo();
         ui = lssInfos[ddlLSS.SelectedIndex - 1];
         txtLSSID.Text = ui.lssGuid;
         txtLSSName.Text = ui.lssName;
         txtLSSURL.Text = ui.lssUrl;
         // Make the LSSID field ReadOnly
         SetReadOnly(true);
     }
 }