//------------------------------------------
#endregion
#region --------------PopulateEntity--------------
private SiteSettingsEntity PopulateEntity(IDataReader reader)
{
//Create a new SiteSettings object
SiteSettingsEntity siteSettings = new SiteSettingsEntity();
//Fill the object with data
//SeetingID
if (reader["SeetingID"] != DBNull.Value)
{
siteSettings.SeetingID = (SiteSettingItems)reader["SeetingID"];
}
//Value
if (reader["Value"] != DBNull.Value)
{
siteSettings.Value = (string)reader["Value"];
}
//Comment
if (reader["Comment"] != DBNull.Value)
{
siteSettings.Comment = (string)reader["Comment"];
}
//Return the populated object
return(siteSettings);
}
//------------------------------------------
#endregion
#region --------------GetObject--------------
public static SiteSettingsEntity GetObject(SiteSettingItems seetingID)
{
SiteSettingsEntity siteSettings = SiteSettingsSqlDataPrvider.Instance.GetObject(seetingID);
//return the object
return(siteSettings);
}
//------------------------------------------
#endregion
#region --------------IncreaseVisitors--------------
public static void IncreaseVisitors()
{
SiteSettingsEntity siteSettings = new SiteSettingsEntity();
siteSettings.SeetingID = SiteSettingItems.Site_VisitorsCount;
siteSettings.Value = (SiteSettings.Site_VisitorsCount + 1).ToString();
SiteSettingsSqlDataPrvider.Instance.Save(siteSettings);
}
/// <summary>
/// Updates SiteSettings object by calling SiteSettings data provider update method.
/// <example>[Example]bool status=SiteSettingsFactory.Update(siteSettings);.</example>
/// </summary>
/// <param name="siteSettings">The SiteSettings object.</param>
/// <returns>Status of update operation.</returns>
public static bool Save(SiteSettingsEntity siteSettings)
{
bool status = SiteSettingsSqlDataPrvider.Instance.Save(siteSettings);
//Reload Site Settings
if (status)
{
LoadAllSettings();
}
//return result
return(status);
}
//------------------------------------------
#endregion
#region --------------Save--------------
public bool Save(SiteSettingsEntity siteSettings)
{
using (SqlConnection myConnection = GetSqlConnection())
{
SqlCommand myCommand = new SqlCommand("SiteOtherValues_Save", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
// Set the parameters
myCommand.Parameters.Add("@SeetingID", SqlDbType.Int, 4).Value = (int)siteSettings.SeetingID;
myCommand.Parameters.Add("@Value", SqlDbType.NVarChar).Value = siteSettings.Value;
myCommand.Parameters.Add("@Comment", SqlDbType.NVarChar).Value = siteSettings.Comment;
// Execute the command
bool status = false;
myConnection.Open();
if (myCommand.ExecuteNonQuery() > 0)
{
status = true;
}
myConnection.Close();
return(status);
}
}
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);
}
}
//------------------------------------------
#endregion
#region --------------GetVisitorsCount--------------
public static string GetVisitorsCount()
{
SiteSettingsEntity siteSettings = SiteSettingsSqlDataPrvider.Instance.GetObject(SiteSettingItems.Site_VisitorsCount);
return(siteSettings.Value);
}
