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 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 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 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 void mLoadAllPageMedias()
{
MediaSubjects mediaSubjects = new MediaSubjects();
mediaSubjects.LoadByIDSubjectAndIDMediaSubjectType(pSubjectID, pMediaSubjectTypeID);
mediaSubjects.Sort = MediaSubjects.ColumnNames.Priority;
grvPageList.DataSource = mediaSubjects.DefaultView;
grvPageList.DataBind();
uplPageList.Update();
}
private void mDeleteMediaSubject()
{
MediaSubjects mediaSubject = new MediaSubjects();
mediaSubject.LoadByIDSubjectAndIDMediaSubjectType(pSubjectID, pMediaSubjectTypeID);
if (mediaSubject.RowCount > 0)
{
mediaSubject.MarkAsDeleted(false);
mediaSubject.Save();
}
}
private string mGetImage(MediaSubjects media)
{
if (media.RowCount > 0)
{
return(string.Format("{0}{1}{2}", Global.Constants.FOLDER_MEDIAS.Substring(1), media.Medias.pIDMedia.ToString(), media.Medias.pFileExtention));
}
else
{
return(Global.Constants.IMAGE_NOAVAILABLE_SMALL);
}
}
public string mGetCoverImage(object IDSubject)
{
string imageUrl = string.Empty;
MediaSubjects media = new MediaSubjects();
media.LoadByIDSubjectAndIDMediaSubjectType(new Guid(IDSubject.ToString()), (byte)MediaSubjectTypes.Enum.thumbnail);
if (media.RowCount > 0)
{
imageUrl = string.Format("{0}{1}{2}", Global.Constants.FOLDER_MEDIAS.Substring(1), media.Medias.pIDMedia.ToString(), media.Medias.pFileExtention);
}
return(imageUrl);
}
private void mLoadSubject()
{
StringBuilder sb = new StringBuilder();
Subjects widgetSubject = new Subjects(subjectID);
MediaSubjects medias = new MediaSubjects();
medias.LoadByIDSubjectAndIDMediaSubjectType(widgetSubject.pIDSubject, (byte)MediaSubjectTypes.Enum.thumbnail);
sb.Append(string.Format(widget, mGetURL(widgetSubject.pAlias), mGetImage(medias), widgetSubject.pBody));
litWidget.Text = sb.ToString();
}
public string mCheckMediaSebject(int mediaID)
{
MediaSubjects mediaSubjects = new MediaSubjects(mediaID, pSubjectID, pMediaSubjectTypeID);
if (mediaSubjects.RowCount > 0)
{
return(Global.Constants.HTML_IMAGE_CHECK);
}
else
{
return(Global.Constants.HTML_IMAGE_ERROR);
}
}
protected void grvList_Select(object sender, CommandEventArgs e)
{
mDeleteMediaSubject();
MediaSubjects mediaSubject = new MediaSubjects();
mediaSubject.AddNew();
mediaSubject.pIDMedia = Convert.ToInt32(e.CommandArgument);
mediaSubject.pIDSubject = pSubjectID;
mediaSubject.pIDMediaSubjectType = pMediaSubjectTypeID;
mediaSubject.Save();
mSave();
}
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();
}
}
private string mGetCoverImage(string IDSubject)
{
string result = "{0}{1}";
MediaSubjects cover = new MediaSubjects();
cover.LoadByIDSubjectAndIDMediaSubjectType(new Guid(IDSubject), (byte)MediaSubjectTypes.Enum.thumbnail);
if (cover.RowCount > 0)
{
result = string.Format(result, Global.Constants.FOLDER_MEDIAS.Substring(1), cover.pIDMedia + cover.pFileExtention);
}
else
{
result = string.Format(result, Global.Constants.IMAGE_NOAVAILABLE_SMALL, string.Empty);
}
return(result);
}
private void mDelete(Guid iDSubject, bool loadList = true)
{
if (mValidateDelete(iDSubject))
{
DAL.GlobalCore.TransactionMgr tx = DAL.GlobalCore.TransactionMgr.ThreadTransactionMgr();
try
{
tx.BeginTransaction();
MediaSubjects mediaSubjects = new MediaSubjects();
mediaSubjects.LoadByIDSubject(iDSubject);
mediaSubjects.DeleteAll();
mediaSubjects.Save();
SubjectPlugins subjectPlugin = new SubjectPlugins();
subjectPlugin.LoadByIDSubject(iDSubject);
subjectPlugin.DeleteAll();
subjectPlugin.Save();
GalleryPlugins GalleryPlugins = new GalleryPlugins();
GalleryPlugins.LoadByIDSubject(iDSubject);
GalleryPlugins.DeleteAll();
GalleryPlugins.Save();
Subjects subject = new Subjects(iDSubject);
subject.MarkAsDeleted(false);
subject.Save();
tx.CommitTransaction();
if (loadList)
{
pMessage.Clear();
pMessage.Add(Farschidus.Translator.AppTranslate["general.message.deleted"], Farschidus.Web.UI.Message.MessageTypes.Success);
mShowMessage(pMessage);
mLoadList();
}
}
catch (Exception ex)
{
tx.RollbackTransaction();
pMessage.Clear();
pMessage.Add(ex.Message, Farschidus.Web.UI.Message.MessageTypes.Error);
}
}
mShowMessage(pMessage);
}
private void mReloadImagePath()
{
MediaSubjects mediaSubjects = new MediaSubjects();
mediaSubjects.LoadByIDSubjectAndIDMediaSubjectType(pSubjectID, pMediaSubjectTypeID);
if (mediaSubjects.RowCount > 0)
{
string[] imageFile = System.IO.Directory.GetFiles(MapPath(Global.Constants.FOLDER_MEDIAS), mediaSubjects.pIDMedia.ToString() + ".*");
if (imageFile.Length > 0)
{
litImage.Text = string.Format(@"<a href='javascript:void(0)' onclick=""window.open('/{0}?{1}', 'Banner Image', 'height=515,width=990,top=120,left=10,scrollbars=yes,resizable=yes')"">{2}</a>",
Global.Constants.FOLDER_MEDIAS.Substring(2) + System.IO.Path.GetFileName(imageFile[0]),
DateTime.Now.ToString(),
Farschidus.Translator.AppTranslate["ascx.media.popupLinks.title"]);
}
}
}
protected void btnAddToPage_Click(object sender, EventArgs e)
{
try
{
pMessage.Clear();
bool hasSelect = false;
int item;
MediaSubjects mediaSubjects = new MediaSubjects();
foreach (GridViewRow grvRow in grvList.Rows)
{
if (((CheckBox)grvRow.FindControl("chkList")).Checked)
{
item = Convert.ToInt32(grvList.DataKeys[grvRow.RowIndex][Medias.ColumnNames.IDMedia].ToString());
mediaSubjects.LoadByPrimaryKey(item, pSubjectID, pMediaSubjectTypeID);
if (mediaSubjects.RowCount == 0)
{
mediaSubjects.AddNew();
mediaSubjects.pIDMedia = item;
mediaSubjects.pIDSubject = pSubjectID;
mediaSubjects.pIDMediaSubjectType = pMediaSubjectTypeID;
mediaSubjects.pPriority = mSetPriority();
mediaSubjects.Save();
hasSelect = true;
}
else
{
pMessage.Add(Farschidus.Translator.AppTranslate["thumbnail.popup.message.alreadyExist"] + ": " + mediaSubjects.Medias.pFileName, Farschidus.Web.UI.Message.MessageTypes.Information);
}
}
}
if (hasSelect)
{
mLoadAll();
pMessage.Add(Farschidus.Translator.AppTranslate["general.message.success"], 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 void mDelete(Guid iDUser)
{
DAL.GlobalCore.TransactionMgr tx = DAL.GlobalCore.TransactionMgr.ThreadTransactionMgr();
try
{
Subjects subjects = new Subjects();
subjects.LoadBySubjectAliasAndIDSubjectType(pIDUser.Value.ToString(), (byte)SubjectTypes.Enum.userPage);
if (subjects.RowCount > 0)
{
tx.BeginTransaction();
MediaSubjects mediaSubjects = new MediaSubjects();
mediaSubjects.LoadByIDSubject(subjects.pIDSubject);
mediaSubjects.DeleteAll();
mediaSubjects.Save();
SubjectPlugins subjectPlugin = new SubjectPlugins();
subjectPlugin.LoadByIDSubject(subjects.pIDSubject);
subjectPlugin.DeleteAll();
subjectPlugin.Save();
GalleryPlugins GalleryPlugins = new GalleryPlugins();
GalleryPlugins.LoadByIDSubject(subjects.pIDSubject);
GalleryPlugins.DeleteAll();
GalleryPlugins.Save();
Subjects subject = new Subjects(subjects.pIDSubject);
subject.MarkAsDeleted(false);
subject.Save();
tx.CommitTransaction();
pMessage.Clear();
pMessage.Add(Farschidus.Translator.AppTranslate["general.message.deleted"], Farschidus.Web.UI.Message.MessageTypes.Success);
mShowMessage(pMessage);
mLoadList();
}
}
catch (Exception ex)
{
tx.RollbackTransaction();
pMessage.Clear();
pMessage.Add(ex.Message, Farschidus.Web.UI.Message.MessageTypes.Error);
mShowMessage(pMessage);
}
}
private void mInitializing()
{
MediaSubjects medias = new MediaSubjects();
medias.LoadByIDSubjectAndIDMediaSubjectType(Subject.pIDSubject, (byte)MediaSubjectTypes.Enum.attachment);
if (medias.RowCount > 0)
{
rptMedia.Visible = true;
medias.Sort = MediaSubjects.ColumnNames.Priority;
rptMedia.DataSource = medias.DefaultView;
rptMedia.DataBind();
}
else
{
rptMedia.Visible = false;
}
uplMedia.Update();
}
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 mLoadItems()
{
StringBuilder sb = new StringBuilder();
Subjects ListItems = new Subjects();
ListItems.LoadByIDParentAndIDLanguage(subjectID, language);
ListItems.Sort = Subjects.ColumnNames.Priority;
MediaSubjects medias = new MediaSubjects();
int columnCounter = 1;
do
{
if (columnCounter == 1)
{
sb.Append("<div class='row'>");
}
medias.LoadByIDSubjectAndIDMediaSubjectType(ListItems.pIDSubject, (byte)MediaSubjectTypes.Enum.thumbnail);
if (medias.RowCount > 0)
{
if (generateAjaxUrl)
{
sb.Append(string.Format(item, string.Format(@"javascript:__doPostBack(""{0}"", ""{1}"")", updatePaneClientID, ListItems.pIDSubject.ToString()), mGetImage(medias), ListItems.pTitle));
}
else
{
sb.Append(string.Format(item, mGetURL(ListItems.pAlias), mGetImage(medias), ListItems.pTitle));
}
}
if (columnCounter == 3)
{
sb.Append("</div>");
columnCounter = 0;
}
columnCounter++;
}while (ListItems.MoveNext());
litItems.Text = sb.ToString();
}
protected void btnRemoveFromPage_Click(object sender, EventArgs e)
{
try
{
pMessage.Clear();
bool hasSelect = false;
int item;
MediaSubjects mediaSubjects = new MediaSubjects();
foreach (GridViewRow grvRow in grvPageList.Rows)
{
if (((CheckBox)grvRow.FindControl("chkPageList")).Checked)
{
item = Convert.ToInt32(grvPageList.DataKeys[grvRow.RowIndex][Medias.ColumnNames.IDMedia].ToString());
mediaSubjects.LoadByPrimaryKey(item, pSubjectID, pMediaSubjectTypeID);
if (mediaSubjects.RowCount > 0)
{
mediaSubjects.MarkAsDeleted(false);
mediaSubjects.Save();
hasSelect = true;
}
}
}
if (hasSelect)
{
reorderMediaSubjects(mediaSubjects);
mLoadAll();
pMessage.Add(Farschidus.Translator.AppTranslate["general.message.deleted"], 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 void mLoadItems()
{
StringBuilder sb = new StringBuilder();
Subjects ListItems = new Subjects();
ListItems.LoadByIDParentAndIDLanguage(subjectID, language);
ListItems.Sort = Subjects.ColumnNames.Date + " DESC";
MediaSubjects medias = new MediaSubjects();
sb.Append("<ul class='SideBar-SlideContainer'>");
do
{
medias.LoadByIDSubjectAndIDMediaSubjectType(ListItems.pIDSubject, (byte)MediaSubjectTypes.Enum.thumbnail);
if (medias.RowCount > 0)
{
sb.Append(string.Format(item, mGetURL(ListItems.pAlias), mGetImage(medias), ListItems.pTitle));
}
}while (ListItems.MoveNext());
sb.Append("</ul>");
litItems.Text = sb.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();
}
private string mGetImage(MediaSubjects media)
{
return(string.Format("{0}{1}{2}", Global.Constants.FOLDER_MEDIAS.Substring(1), media.Medias.pIDMedia.ToString(), media.Medias.pFileExtention));
}
