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; }
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)); } }
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; }
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; }
private void GetEntityFromReader(SqlDataReader _dtr, Blocks obj) { PopulateBlocks(_dtr, obj); }
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; }
public static void Update(Blocks obj) { BlocksDataMapper objCaller = new BlocksDataMapper(); objCaller.Update(obj); }
public static int Add(Blocks obj) { BlocksDataMapper objCaller = new BlocksDataMapper(); return objCaller.Add(obj); }