Ejemplo n.º 1
0
        public int Add(Blocks obj)
        {
            _connection.ConnectionString = _ConnectionString;
            _command.Connection = _connection;
            _command.CommandType = CommandType.StoredProcedure;
            _command.CommandText = INSERTBlocks;

            #region [Parameters]
            SqlParameter parameterID = new SqlParameter(PN_ID, SqlDbType.Int);
            parameterID.Value = obj.ID;
            parameterID.Direction = ParameterDirection.Output;
            _command.Parameters.Add(parameterID);
            SqlParameter parameterName = new SqlParameter(PN_NAME, SqlDbType.NVarChar);
            parameterName.Value = obj.Name;
            parameterName.Direction = ParameterDirection.Input;
            _command.Parameters.Add(parameterName);
            SqlParameter parameterUseCategory = new SqlParameter(PN_USECATEGORY, SqlDbType.Int);
            parameterUseCategory.Value = obj.UseCategory;
            parameterUseCategory.Direction = ParameterDirection.Input;
            _command.Parameters.Add(parameterUseCategory);
            SqlParameter parameterUseXSL = new SqlParameter(PN_USEXSL, SqlDbType.Int);
            parameterUseXSL.Value = obj.UseXSL;
            parameterUseXSL.Direction = ParameterDirection.Input;
            _command.Parameters.Add(parameterUseXSL);
            SqlParameter parameterRegisterTag = new SqlParameter(PN_REGISTERTAG, SqlDbType.NVarChar);
            parameterRegisterTag.Value = obj.RegisterTag;
            parameterRegisterTag.Direction = ParameterDirection.Input;
            _command.Parameters.Add(parameterRegisterTag);
            SqlParameter parameterUseHtml = new SqlParameter(PN_USEHTML, SqlDbType.Int);
            parameterUseHtml.Value = obj.UseHtml;
            parameterUseHtml.Direction = ParameterDirection.Input;
            _command.Parameters.Add(parameterUseHtml);
            #endregion;

            _connection.Open();
            _command.ExecuteNonQuery();
            _connection.Close();
            obj.ID = Convert.ToInt32(parameterID.Value);
            return obj.ID;
        }
Ejemplo n.º 2
0
 public void PopulateBlocks(SqlDataReader _dtr, Blocks obj)
 {
     int columnIndex = 0;
     columnIndex = _dtr.GetOrdinal(BlocksDataMapper.CN_ID);
     if (!_dtr.IsDBNull(columnIndex))
     {
         obj.ID = _dtr.GetInt32((columnIndex));
     }
     columnIndex = _dtr.GetOrdinal(BlocksDataMapper.CN_NAME);
     if (!_dtr.IsDBNull(columnIndex))
     {
         obj.Name = _dtr.GetString((columnIndex));
     }
     columnIndex = _dtr.GetOrdinal(BlocksDataMapper.CN_USECATEGORY);
     if (!_dtr.IsDBNull(columnIndex))
     {
         obj.UseCategory = _dtr.GetBoolean((columnIndex));
     }
     columnIndex = _dtr.GetOrdinal(BlocksDataMapper.CN_USEXSL);
     if (!_dtr.IsDBNull(columnIndex))
     {
         obj.UseXSL = _dtr.GetBoolean((columnIndex));
     }
     columnIndex = _dtr.GetOrdinal(BlocksDataMapper.CN_REGISTERTAG);
     if (!_dtr.IsDBNull(columnIndex))
     {
         obj.RegisterTag = _dtr.GetString((columnIndex));
     }
     columnIndex = _dtr.GetOrdinal(BlocksDataMapper.CN_USEHTML);
     if (!_dtr.IsDBNull(columnIndex))
     {
         obj.UseHtml = _dtr.GetBoolean((columnIndex));
     }
 }
Ejemplo n.º 3
0
 public Blocks GetBlocks(SqlDataReader _dtr, IList<Blocks> colobj)
 {
     Blocks obj = colobj.Where(t => t.ID == Convert.ToInt32(_dtr[CN_ID].ToString())).SingleOrDefault();
     if (null == obj)
     {
         obj = new Blocks();
         colobj.Add(obj);
     }
     return obj;
 }
Ejemplo n.º 4
0
        public IList<Blocks> GetAll()
        {

            Blocks obj = null;

            IList<Blocks> colobj = new List<Blocks>();
            _connection.ConnectionString = _ConnectionString;
            _command.Connection = _connection;
            _command.CommandType = CommandType.StoredProcedure;
            _command.CommandText = SELECTALLBlocks;

            _connection.Open();
            try
            {
                using (_dtreader = _command.ExecuteReader())
                {
                    if (_dtreader != null && _dtreader.HasRows)
                    {
                        obj = new Blocks();
                        colobj = new List<Blocks>();
                        while (_dtreader.Read())
                        {
                            obj = GetBlocks(_dtreader, colobj);
                            GetEntityFromReader(_dtreader, obj);
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {

                _dtreader.Close();
                _connection.Close();
            }

            return colobj;
        }
Ejemplo n.º 5
0
 private void GetEntityFromReader(SqlDataReader _dtr, Blocks obj)
 {
     PopulateBlocks(_dtr, obj);
 }
Ejemplo n.º 6
0
        public Blocks GetByID(int ID)
        {

            Blocks obj = null;
            _connection.ConnectionString = _ConnectionString;
            _command.Connection = _connection;
            _command.CommandType = CommandType.StoredProcedure;
            _command.CommandText = SELECTBlocks;

            #region [Parameters]
            SqlParameter parameterID = new SqlParameter(PN_ID, SqlDbType.Int);
            parameterID.Value = ID;
            parameterID.Direction = ParameterDirection.Input;
            _command.Parameters.Add(parameterID);
            #endregion;

            _connection.Open();
            try
            {
                using (_dtreader = _command.ExecuteReader())
                {
                    if (_dtreader != null && _dtreader.HasRows)
                    {
                        obj = new Blocks();
                        if (_dtreader.Read())
                            GetEntityFromReader(_dtreader, obj);
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {

                _dtreader.Close();
                _connection.Close();
            }

            return obj;
        }
Ejemplo n.º 7
0
        public static void Update(Blocks obj)
        {
            BlocksDataMapper objCaller = new BlocksDataMapper();

            objCaller.Update(obj);
        }
Ejemplo n.º 8
0
        public static int Add(Blocks obj)
        {
            BlocksDataMapper objCaller = new BlocksDataMapper();

            return objCaller.Add(obj);
        }