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);
}
