// Publish UnPublish IsUnhandled : internal static string GetGallerysPublishXML(int CategoryID, CMSEnums.GalleryType GalleryType, int RowFrom, int RowTo, ref int TotalCount) { string galleryXML = string.Empty; TotalCount = 0; using (SqlConnection sqlConnection = new SqlConnection(CMSCoreBase.CMSCoreConnectionString)) { SqlCommand sqlCommand = new SqlCommand(SN_GALLERY_GET_BY_CATEGORY_XML, sqlConnection); sqlCommand.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter sqlParameter = null; sqlParameter = new SqlParameter(PN_GALLERY_CATEGORY_ID, System.Data.SqlDbType.Int); sqlParameter.Direction = System.Data.ParameterDirection.Input; sqlParameter.Value = CategoryID; sqlCommand.Parameters.Add(sqlParameter); sqlParameter = new SqlParameter(PN_GALLERY_TYPE, System.Data.SqlDbType.Int); sqlParameter.Direction = System.Data.ParameterDirection.Input; sqlParameter.Value = (int)GalleryType; sqlCommand.Parameters.Add(sqlParameter); sqlParameter = new SqlParameter(CMSCoreBase.PN_ROW_FROM, System.Data.SqlDbType.Int); sqlParameter.Direction = System.Data.ParameterDirection.Input; sqlParameter.Value = RowFrom; sqlCommand.Parameters.Add(sqlParameter); sqlParameter = new SqlParameter(CMSCoreBase.PN_ROW_TO, System.Data.SqlDbType.Int); sqlParameter.Direction = System.Data.ParameterDirection.Input; sqlParameter.Value = RowTo; sqlCommand.Parameters.Add(sqlParameter); sqlParameter = new SqlParameter(CMSCoreBase.PN_TOTAL_COUNT, System.Data.SqlDbType.Int); sqlParameter.Direction = System.Data.ParameterDirection.Output; sqlParameter.Value = 0; sqlCommand.Parameters.Add(sqlParameter); sqlParameter = new SqlParameter(PublishDataMapper.PN_PUBLISH_MODULE_ID, System.Data.SqlDbType.Int); sqlParameter.Direction = System.Data.ParameterDirection.Input; sqlParameter.Value = (int)CMSEnums.Modules.Gallery; sqlCommand.Parameters.Add(sqlParameter); sqlParameter = new SqlParameter(PublishDataMapper.PN_PUBLISH_TYPE_ID, System.Data.SqlDbType.Int); sqlParameter.Direction = System.Data.ParameterDirection.Input; sqlParameter.Value = (int)CMSEnums.PublishType.PublishNow; sqlCommand.Parameters.Add(sqlParameter); sqlCommand.Connection.Open(); using (SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection)) { SqlXml sqlXML = null; while (sqlDataReader.Read()) { sqlXML = sqlDataReader.GetSqlXml(0); } sqlDataReader.Close(); sqlCommand.Connection.Close(); if (!sqlXML.IsNull) { galleryXML = sqlXML.Value; TotalCount = Convert.ToInt32(sqlCommand.Parameters[CMSCoreBase.PN_TOTAL_COUNT].Value); } } } return galleryXML; }
internal static List<Gallery> GetGallerys(int PortalID, int LanguageID, CMSEnums.GalleryType GalleryType) { List<Gallery> colGallerys = null; Gallery gallery = null; using (SqlConnection sqlConnection = new SqlConnection(CMSCoreBase.CMSCoreConnectionString)) { SqlCommand sqlCommand = new SqlCommand(SN_GALLERY_GET_BY_PORTAL_LANGUAGE, sqlConnection); sqlCommand.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter sqlParameter = null; sqlParameter = new SqlParameter(PN_GALLERY_PORTAL_ID, System.Data.SqlDbType.Int); sqlParameter.Direction = System.Data.ParameterDirection.Input; sqlParameter.Value = PortalID; sqlCommand.Parameters.Add(sqlParameter); sqlParameter = new SqlParameter(PN_GALLERY_LANGUAGE_ID, System.Data.SqlDbType.Int); sqlParameter.Direction = System.Data.ParameterDirection.Input; sqlParameter.Value = LanguageID; sqlCommand.Parameters.Add(sqlParameter); sqlParameter = new SqlParameter(PN_GALLERY_TYPE, System.Data.SqlDbType.Int); sqlParameter.Direction = System.Data.ParameterDirection.Input; sqlParameter.Value = (int)GalleryType; sqlCommand.Parameters.Add(sqlParameter); sqlParameter = new SqlParameter(PublishDataMapper.PN_PUBLISH_MODULE_ID, System.Data.SqlDbType.Int); sqlParameter.Direction = System.Data.ParameterDirection.Input; sqlParameter.Value = (int)AJH.CMS.Core.Enums.CMSEnums.Modules.Gallery; sqlCommand.Parameters.Add(sqlParameter); sqlCommand.Connection.Open(); using (SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection)) { colGallerys = new List<Gallery>(); while (sqlDataReader.Read()) { gallery = GetGallery(colGallerys, sqlDataReader); FillFromReader(gallery, sqlDataReader); } sqlDataReader.Close(); sqlCommand.Connection.Close(); } } return colGallerys; }