//------------------------------------------
#endregion
#region --------------GetObject--------------
public static SiteSettingsEntity GetObject(SiteSettingItems seetingID)
{
SiteSettingsEntity siteSettings = SiteSettingsSqlDataPrvider.Instance.GetObject(seetingID);
//return the object
return(siteSettings);
}
public SiteSettingsEntity GetObject(SiteSettingItems seetingID)
{
SiteSettingsEntity siteSettings = null;
using (SqlConnection myConnection = GetSqlConnection())
{
SqlCommand myCommand = new SqlCommand("SiteSettings_GetOneByID", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
// Set the parameters
myCommand.Parameters.Add("@SeetingID", SqlDbType.Int, 4).Value = (int)seetingID;
// Execute the command
myConnection.Open();
using (SqlDataReader dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection))
{
if (dr.Read())
{
siteSettings = PopulateEntity(dr);
}
dr.Close();
}
myConnection.Close();
return(siteSettings);
}
}
