public int Add(Settings obj) { _connection.ConnectionString = _ConnectionString; _command.Connection = _connection; _command.CommandType = CommandType.StoredProcedure; _command.CommandText = INSERTSettings; #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 parameterDefaultURL = new SqlParameter(PN_DEFAULTURL, SqlDbType.NVarChar); parameterDefaultURL.Value = obj.DefaultUrl; parameterDefaultURL.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterDefaultURL); SqlParameter parameterDefaultLanguageCode = new SqlParameter(PN_DEFAULTLANGUAGECODE, SqlDbType.NVarChar); parameterDefaultLanguageCode.Value = obj.DefaultLanguageCode; parameterDefaultLanguageCode.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterDefaultLanguageCode); SqlParameter parameterIsDefault = new SqlParameter(PN_ISDEFAULT, SqlDbType.Int); parameterIsDefault.Value = obj.IsDefault; parameterIsDefault.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterIsDefault); SqlParameter parameterPhysicalPath = new SqlParameter(PN_PHYSICALPATH, SqlDbType.NVarChar); parameterPhysicalPath.Value = obj.PhysicalPath; parameterPhysicalPath.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterPhysicalPath); SqlParameter parameterIsDeleted = new SqlParameter(PN_ISDELETED, SqlDbType.Int); parameterIsDeleted.Value = obj.IsDeleted; parameterIsDeleted.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterIsDeleted); #endregion; _connection.Open(); _command.ExecuteNonQuery(); _connection.Close(); obj.ID = Convert.ToInt32(parameterID.Value); return obj.ID; }
public Settings GetSettings(SqlDataReader _dtr, IList<Settings> colobj) { Settings obj = colobj.Where(t => t.ID == Convert.ToInt32(_dtr[CN_ID].ToString())).SingleOrDefault(); if (null == obj) { obj = new Settings(); colobj.Add(obj); } return obj; }
private void GetEntityFromReader(SqlDataReader _dtr, Settings obj) { PopulateSettings(_dtr, obj); }
public IList<Settings> GetAll() { Settings obj = null; IList<Settings> colobj = new List<Settings>(); _connection.ConnectionString = _ConnectionString; _command.Connection = _connection; _command.CommandType = CommandType.StoredProcedure; _command.CommandText = SELECTALLSettings; _connection.Open(); try { using (_dtreader = _command.ExecuteReader()) { if (_dtreader != null && _dtreader.HasRows) { obj = new Settings(); colobj = new List<Settings>(); while (_dtreader.Read()) { obj = GetSettings(_dtreader, colobj); GetEntityFromReader(_dtreader, obj); } } } } catch (Exception ex) { throw ex; } finally { _dtreader.Close(); _connection.Close(); } return colobj; }
public Settings GetDefault() { Settings obj = null; _connection.ConnectionString = _ConnectionString; _command.Connection = _connection; _command.CommandType = CommandType.StoredProcedure; _command.CommandText = "[usp_SelectDefSetting]"; _connection.Open(); try { using (_dtreader = _command.ExecuteReader()) { if (_dtreader != null && _dtreader.HasRows) { obj = new Settings(); if (_dtreader.Read()) GetEntityFromReader(_dtreader, obj); } } } catch (Exception ex) { throw ex; } finally { _dtreader.Close(); _connection.Close(); } return obj; }
public Settings GetByID(int ID) { Settings obj = null; _connection.ConnectionString = _ConnectionString; _command.Connection = _connection; _command.CommandType = CommandType.StoredProcedure; _command.CommandText = SELECTSettings; #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 Settings(); if (_dtreader.Read()) GetEntityFromReader(_dtreader, obj); } } } catch (Exception ex) { throw ex; } finally { _dtreader.Close(); _connection.Close(); } return obj; }
public void PopulateSettings(SqlDataReader _dtr, Settings obj) { int columnIndex = 0; columnIndex = _dtr.GetOrdinal(SettingsDataMapper.CN_ID); if (!_dtr.IsDBNull(columnIndex)) { obj.ID = _dtr.GetInt32((columnIndex)); } columnIndex = _dtr.GetOrdinal(SettingsDataMapper.CN_NAME); if (!_dtr.IsDBNull(columnIndex)) { obj.Name = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(SettingsDataMapper.CN_DEFAULTURL); if (!_dtr.IsDBNull(columnIndex)) { obj.DefaultUrl = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(SettingsDataMapper.CN_DEFAULTLANGUAGECODE); if (!_dtr.IsDBNull(columnIndex)) { obj.DefaultLanguageCode = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(SettingsDataMapper.CN_ISDEFAULT); if (!_dtr.IsDBNull(columnIndex)) { obj.IsDefault = _dtr.GetBoolean((columnIndex)); } columnIndex = _dtr.GetOrdinal(SettingsDataMapper.CN_PHYSICALPATH); if (!_dtr.IsDBNull(columnIndex)) { obj.PhysicalPath = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(SettingsDataMapper.CN_ISDELETED); if (!_dtr.IsDBNull(columnIndex)) { obj.IsDeleted = _dtr.GetBoolean((columnIndex)); } }
public static void Update(Settings obj) { SettingsDataMapper objCaller = new SettingsDataMapper(); objCaller.Update(obj); }
public static int Add(Settings obj) { SettingsDataMapper objCaller = new SettingsDataMapper(); return objCaller.Add(obj); }