private void ReOrder(MediaSubjects unorderedMedias, string draggedPriority, string targetPriority, bool direction)
{
try
{
string initFilter = "";
if (!string.IsNullOrEmpty(unorderedMedias.Filter))
{
initFilter = unorderedMedias.Filter + " AND ";
}
unorderedMedias.Filter = initFilter + string.Format("{0}={1}", MediaSubjects.ColumnNames.Priority, draggedPriority);
unorderedMedias.pPriority = -1;
if (direction)
{
unorderedMedias.Filter = initFilter + string.Format("{0}>={1} AND {0} < {2}", MediaSubjects.ColumnNames.Priority, targetPriority, draggedPriority);
if (unorderedMedias.RowCount > 0)
{
do
{
unorderedMedias.pPriority += 1;
} while (unorderedMedias.MoveNext());
}
}
else
{
unorderedMedias.Filter = initFilter + string.Format("{0}>{1} AND {0} <= {2}", MediaSubjects.ColumnNames.Priority, draggedPriority, targetPriority);
if (unorderedMedias.RowCount > 0)
{
do
{
unorderedMedias.pPriority -= 1;
} while (unorderedMedias.MoveNext());
}
}
unorderedMedias.Filter = initFilter + string.Format("{0}={1}", MediaSubjects.ColumnNames.Priority, "-1");
unorderedMedias.pPriority = Convert.ToInt32(targetPriority);
pMediaSubjects = unorderedMedias;
MediaSubjects mediaSubjects = new MediaSubjects();
mediaSubjects = pMediaSubjects;
mediaSubjects.Save();
mLoadAllPageMedias();
pMessage.Add(Farschidus.Translator.AppTranslate["general.message.reordered"], Farschidus.Web.UI.Message.MessageTypes.Success);
}
catch (Exception ex)
{
pMessage.Add(ex.Message, Farschidus.Web.UI.Message.MessageTypes.Error);
}
finally
{
mShowMessage(pMessage);
uplAddEdit.Update();
}
}
private bool mValidateDelete(int iDMedia)
{
pMessage.Clear();
bool isValid = true;
MediaSubjects mediaSubject = new MediaSubjects();
mediaSubject.LoadByIDMedia(iDMedia);
mediaSubject.Sort = MediaSubjects.ColumnNames.IDMediaSubjectType;
if (mediaSubject.RowCount > 0)
{
isValid = false;
pMessage.Add(Farschidus.Translator.AppTranslate["mediaManaging.default.message.subjectMediaRelation"], Farschidus.Web.UI.Message.MessageTypes.Warning);
Subjects subject = new Subjects();
SubjectTypes subjectType = new SubjectTypes();
MediaSubjectTypes mediaSubjectType = new MediaSubjectTypes();
BLL.Hardcodes.Tables hcTables = new BLL.Hardcodes.Tables();
string moduleName = string.Empty;
string usageType = string.Empty;
do
{
subject.LoadByPrimaryKey(mediaSubject.pIDSubject);
subjectType.LoadByPrimaryKey(subject.pIDSubjectType);
mediaSubjectType.LoadByPrimaryKey(mediaSubject.pIDMediaSubjectType);
moduleName = hcTables.SubjectTypes.Find(item => item.ID.ToString() == ((byte)((SubjectTypes.Enum)Enum.Parse(typeof(SubjectTypes.Enum), subjectType.pTitle, true))).ToString()).Title;
usageType = hcTables.MediaSubjectTypes.Find(item => item.ID.ToString() == ((byte)((MediaSubjectTypes.Enum)Enum.Parse(typeof(MediaSubjectTypes.Enum), mediaSubjectType.pTitle, true))).ToString()).Title;
pMessage.Add(string.Format("{0}, {1}: {2}", moduleName, mediaSubject.Subjects.pTitle, usageType), Farschidus.Web.UI.Message.MessageTypes.Information);
}while (mediaSubject.MoveNext());
}
return(isValid);
}
private int mSetPriority()
{
MediaSubjects mediaSubjects = new MediaSubjects();
mediaSubjects.LoadByIDSubjectAndIDMediaSubjectType(pSubjectID, pMediaSubjectTypeID);
mediaSubjects.Sort = MediaSubjects.ColumnNames.Priority;
if (mediaSubjects.RowCount > 0)
{
mediaSubjects.MoveTo(mediaSubjects.RowCount - 1);
if (!mediaSubjects.IsColumnNull(MediaSubjects.ColumnNames.Priority))
{
return(mediaSubjects.pPriority + 1);
}
else
{
mediaSubjects.Rewind();
int i = 1;
if (mediaSubjects.RowCount > 0)
{
do
{
mediaSubjects.pPriority = i;
i++;
}while (mediaSubjects.MoveNext());
mediaSubjects.Save();
}
return(i++);
}
}
else
{
return(1);
}
}
private void mLoadMedias()
{
StringBuilder sb = new StringBuilder();
MediaSubjects medias = new MediaSubjects();
medias.LoadByIDSubjectAndIDMediaSubjectType(pSubject.pIDSubject, (byte)MediaSubjectTypes.Enum.gallery);
if (medias.RowCount > 0)
{
medias.Sort = MediaSubjects.ColumnNames.Priority;
sb.Append("<ul class='thumbItems'>");
do
{
string fileUrl, Thumbnail = string.Empty;
if (medias.pFileExtention.Contains("flv"))
{
fileUrl = System.IO.Directory.GetFiles(MapPath(Global.Constants.FOLDER_MEDIAS), medias.pIDMedia.ToString() + medias.pFileExtention)[0];
sb.Append(string.Format(flashObject, fileUrl, medias.pFileName, Global.Constants.FOLDER_VIDEOPLAYER.Substring(1), Global.Constants.FILE_PLAYER_SWF.Substring(1)));
}
else
{
fileUrl = string.Format("{0}{1}{2}", Global.Constants.FOLDER_MEDIAS.Substring(1), medias.pIDMedia.ToString(), medias.pFileExtention);
Thumbnail = string.Format("<img src='{0}{1}{2}' width='150px' height='150px' />", Global.Constants.FOLDER_THUMBS.Substring(1), medias.pIDMedia.ToString(), medias.pFileExtention);
sb.Append(string.Format(otherFiles, fileUrl, Thumbnail));
}
}while (medias.MoveNext());
sb.Append("</ul>");
}
else
{
sb.Append("");
}
litImages.Text = sb.ToString();
}
private void reorderMediaSubjects(MediaSubjects mediaSubjects)
{
mediaSubjects.LoadByIDSubjectAndIDMediaSubjectType(pSubjectID, pMediaSubjectTypeID);
mediaSubjects.Sort = MediaSubjects.ColumnNames.Priority;
int i = 1;
if (mediaSubjects.RowCount > 0)
{
do
{
mediaSubjects.pPriority = i;
i++;
}while (mediaSubjects.MoveNext());
mediaSubjects.Save();
}
}
public string mGetThumbnails(string IDSubject)
{
StringBuilder result = new StringBuilder();
string thumbItem = "<li><a href='{0}{1}{2}' rel='lightbox[Thumbnail]'><img src='{3}{4}{5}' style='width: 50px; height: 50px; border:1px solid #555; padding:5px'></a></li>";
MediaSubjects ThumbNails = new MediaSubjects();
ThumbNails.LoadByIDSubjectAndIDMediaSubjectType(new Guid(IDSubject), (byte)MediaSubjectTypes.Enum.attachment);
if (ThumbNails.RowCount > 0)
{
result.Append("<ul id='Thumbnails' class='jcarousel-skin-tango'>");
do
{
result.AppendFormat(thumbItem, Global.Constants.FOLDER_MEDIAS.Substring(1), ThumbNails.pIDMedia, ThumbNails.pFileExtention, Global.Constants.FOLDER_THUMBS.Substring(1), ThumbNails.pIDMedia, ThumbNails.pFileExtention);
}while (ThumbNails.MoveNext());
result.Append("</ul>");
}
return(result.ToString());
}
private void mInitializing(Subjects.BannerTypes bannerType)
{
switch (bannerType)
{
case Subjects.BannerTypes.inActive:
{
imgPageBanner.Visible = false;
rptGallery.Visible = false;
break;
}
case Subjects.BannerTypes.picture:
{
imgPageBanner.Visible = true;
rptGallery.Visible = false;
MediaSubjects mediaSubject = new MediaSubjects();
mediaSubject.LoadByIDSubjectAndIDMediaSubjectType(Subject.pIDSubject, (byte)MediaSubjectTypes.Enum.headerImage);
if (mediaSubject.RowCount > 0)
{
string strImageDestinationFolder = Global.Constants.FOLDER_MEDIAS;
string[] files = System.IO.Directory.GetFiles(MapPath(strImageDestinationFolder), mediaSubject.pIDMedia.ToString() + ".*");
if (files.Length > 0)
{
imgPageBanner.ImageUrl = string.Format("{0}{1}", Global.Constants.FOLDER_MEDIAS.Substring(1), System.IO.Path.GetFileName(files[0]));
}
}
break;
}
case Subjects.BannerTypes.gallery:
{
imgPageBanner.Visible = false;
rptGallery.Visible = true;
Subjects subjectGallery = new Subjects(Subject.pIDGallery);
if (subjectGallery.RowCount > 0)
{
MediaSubjects mediaSubjects = new MediaSubjects();
mediaSubjects.LoadByIDSubjectAndIDMediaSubjectType(subjectGallery.pIDSubject, (byte)MediaSubjectTypes.Enum.gallery);
mediaSubjects.Sort = MediaSubjects.ColumnNames.Priority;
if (mediaSubjects.RowCount > 0)
{
System.Data.DataColumn dc = mediaSubjects.AddColumn("FilePath", Type.GetType("System.String"));
do
{
string[] files = System.IO.Directory.GetFiles(MapPath(Global.Constants.FOLDER_MEDIAS), mediaSubjects.pIDMedia.ToString() + ".*");
if (files.Length > 0)
{
mediaSubjects.SetColumn("FilePath", Global.Constants.FOLDER_MEDIAS.Substring(1) + System.IO.Path.GetFileName(files[0]));
}
}while (mediaSubjects.MoveNext());
mSetGalleryScript();
rptGallery.DataSource = mediaSubjects.DefaultView;
rptGallery.DataBind();
}
}
break;
}
}
uplBanner.Update();
}
