//------------------------------------------
#endregion
#region --------------GetObject--------------
public static SiteOtherValuesEntity GetObject(SiteOtherValuesItems seetingID)
{
SiteOtherValuesEntity siteOtherValues = SiteOtherValuesSqlDataPrvider.Instance.GetObject(seetingID);
//return the object
return(siteOtherValues);
}
public SiteOtherValuesEntity GetObject(SiteOtherValuesItems seetingID)
{
SiteOtherValuesEntity siteOtherValues = null;
using (SqlConnection myConnection = GetSqlConnection())
{
SqlCommand myCommand = new SqlCommand("SiteOtherValues_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())
{
siteOtherValues = PopulateEntity(dr);
}
dr.Close();
}
myConnection.Close();
return(siteOtherValues);
}
}
