public static int Add(Gallery gallery)
{
if (gallery.ParentObjectID > 0)
{
Gallery gallery2 = GetGalleryByParentObjIdAndLanguageId(gallery.ParentObjectID, gallery.LanguageID);
if (gallery2 != null)
throw new Exception("Gallery is exists in the same language, please choose another language");
}
return GalleryDataMapper.Add(gallery);
}
internal static void FillFromReader(Gallery gallery, SqlDataReader reader)
{
int colIndex = 0;
colIndex = reader.GetOrdinal(CN_GALLERY_CATEGORY_ID);
if (!reader.IsDBNull(colIndex))
gallery.CategoryID = reader.GetInt32(colIndex);
int days = 0, seconds = 0;
colIndex = reader.GetOrdinal(CN_GALLERY_CREATION_DAY);
if (!reader.IsDBNull(colIndex))
days = reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_GALLERY_CREATION_SEC);
if (!reader.IsDBNull(colIndex))
seconds = reader.GetInt32(colIndex);
gallery.CreationDate = CMSCoreHelper.GetDateTime(days, seconds);
colIndex = reader.GetOrdinal(CN_GALLERY_DESCRIPTION);
if (!reader.IsDBNull(colIndex))
gallery.Description = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(CN_GALLERY_DETAILS);
if (!reader.IsDBNull(colIndex))
gallery.Details = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(CN_GALLERY_ID);
if (!reader.IsDBNull(colIndex))
gallery.ID = reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_GALLERY_FILE);
if (!reader.IsDBNull(colIndex))
gallery.File = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(CN_GALLERY_IS_DELETED);
if (!reader.IsDBNull(colIndex))
gallery.IsDeleted = reader.GetBoolean(colIndex);
colIndex = reader.GetOrdinal(CN_GALLERY_KEYWORDS);
if (!reader.IsDBNull(colIndex))
gallery.KeyWords = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(CN_GALLERY_LANGUAGE_ID);
if (!reader.IsDBNull(colIndex))
gallery.LanguageID = reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_GALLERY_NAME);
if (!reader.IsDBNull(colIndex))
gallery.Name = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(CN_GALLERY_SUMMARY);
if (!reader.IsDBNull(colIndex))
gallery.Summary = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(CN_GALLERY_PORTAL_ID);
if (!reader.IsDBNull(colIndex))
gallery.PortalID = reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_GALLERY_SEO_NAME);
if (!reader.IsDBNull(colIndex))
gallery.SEOName = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(CN_GALLERY_URL);
if (!reader.IsDBNull(colIndex))
gallery.URL = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(CN_GALLERY_TYPE);
if (!reader.IsDBNull(colIndex))
gallery.GalleryType = (CMSEnums.GalleryType)reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_GALLERY_ITEM_TYPE);
if (!reader.IsDBNull(colIndex))
gallery.GalleryItemType = (CMSEnums.GalleryItemType)reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_GALLERY_ORDER);
if (!reader.IsDBNull(colIndex))
gallery.Order = reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_GALLERY_CREATED_BY);
if (!reader.IsDBNull(colIndex))
gallery.CreatedBy = reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_GALLERY_PARENT_OBJ_ID);
if (!reader.IsDBNull(colIndex))
gallery.ParentObjectID = reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(PublishDataMapper.CN_PUBLISH_TYPE_ID);
if (!reader.IsDBNull(colIndex))
gallery.IsPublished = reader.GetInt32(colIndex) == (int)AJH.CMS.Core.Enums.CMSEnums.PublishType.PublishNow;
}
internal static Gallery GetGallery(List<Gallery> gallerys, SqlDataReader reader)
{
int colIndex = 0;
colIndex = reader.GetOrdinal(CN_GALLERY_ID);
int value = reader.GetInt32(colIndex);
Gallery gallery = gallerys.Where(c => c.ID == value).FirstOrDefault();
if (gallery == null)
{
gallery = new Gallery();
gallerys.Add(gallery);
}
return gallery;
}
internal static Gallery GetGalleryByParentObjIdAndLanguageId(int parentObjID, int languageID)
{
Gallery gallery = null;
using (SqlConnection sqlConnection = new SqlConnection(CMSCoreBase.CMSCoreConnectionString))
{
SqlCommand sqlCommand = new SqlCommand(SN_GALLERY_GET_BY_PARENT_OBJ_ID_AND_LANGUAGE_ID, sqlConnection);
sqlCommand.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter sqlParameter = null;
sqlParameter = new SqlParameter(PN_GALLERY_PARENT_OBJ_ID, System.Data.SqlDbType.Int);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = parentObjID;
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(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))
{
while (sqlDataReader.Read())
{
if (gallery == null)
gallery = new Gallery();
FillFromReader(gallery, sqlDataReader);
}
sqlDataReader.Close();
sqlCommand.Connection.Close();
}
}
return gallery;
}
protected string GetGalleryFile(Gallery gallery)
{
switch (gallery.GalleryType)
{
case CMSEnums.GalleryType.Document:
return "~/App_Themes/Image/Document.png";
case CMSEnums.GalleryType.Photo:
if (gallery.GalleryItemType == CMSEnums.GalleryItemType.Internal)
return CMSWebHelper.GetGalleryThumbnailFile(gallery.File);
else
return gallery.URL;
case CMSEnums.GalleryType.Video:
return "~/App_Themes/Image/Video.png";
}
return "~/App_Themes/Image/UnknowType.png";
}
public static void Update(Gallery gallery)
{
GalleryDataMapper.Update(gallery);
}
