/// <summary>
/// Fill datagrid with data
/// </summary>
private void FillDatagrid(DBGuid ID)
{
try
{
string sSortColumn = "dCreatedDate";
int nSelectedRow = -1;
// Storing the previous sort order
if (dtgMain.DataSource != null)
{
sSortColumn = ((DataTable) dtgMain.DataSource).DefaultView.Sort;
}
// Set filter
DesignerDrog filter = new DesignerDrog( Guid.Empty );
filter.FilterOnIsactive = DBInt.Null;
if (cmbStatus.SelectedIndex > 0)
{
bool bIsActive = (cmbStatus.SelectedValue.ToString() == "1" ? true : false);
filter.FilterOnIsactive = (DBInt)Convert.ToInt32( bIsActive );
filter.IsActive = bIsActive;
}
filter.FilterOnIsActual = DBInt.Null;
if (cmbActual.SelectedIndex > 0)
{
bool bIsActual = (cmbActual.SelectedValue.ToString() == "1" ? true : false);
filter.FilterOnIsActual = (DBInt) Convert.ToInt32(bIsActual);
filter.IsActual = bIsActual;
}
if (cmbCategoryRef != null && cmbCategoryRef.SelectedIndex > 0)
{
filter.CategoryRef = new Guid(cmbCategoryRef.SelectedValue.ToString());
}
// Retrieving data from BusinessServices
IDesignerDrogService srv = ServiceFactory.GetDesignerDrogService();
DataSet allData = srv.DesignerDrogSelectFiltered(filter);
DataTable dt = allData.Tables[0];
dt.DefaultView.Sort = sSortColumn;
dtgMain.DataSource = dt;
// Locates the row specified by ID param
if (!ID.IsNull)
{
BindingManagerBase bm = dtgMain.BindingContext[dtgMain.DataSource, dtgMain.DataMember];
DataRow dr;
for (int i = 0; i < bm.Count; i++)
{
dr = ((DataRowView) bm.Current).Row;
if (ID.Value.Equals(dr["uId"]))
{
nSelectedRow = i;
break;
}
bm.Position += 1;
}
}
// Makes the row selected
if (nSelectedRow <= ((DataTable) dtgMain.DataSource).DefaultView.Count && nSelectedRow > -1)
{
dtgMain.Select(nSelectedRow);
dtgMain.CurrentRowIndex = nSelectedRow;
}
else if (((DataTable) dtgMain.DataSource).DefaultView.Count != 0)
{
dtgMain.Select(0);
}
// Enabling or disabling the buttons according to record count.
// And is because of previous disable state.
bool bIsEmptyGrid = (((DataTable) dtgMain.DataSource).DefaultView.Count == 0);
tbbModify.Enabled = ! bIsEmptyGrid;
tbbInactivate.Enabled = ! bIsEmptyGrid;
}
catch (Exception ex)
{
// --- Log exception
ExceptionManager.Publish(ex);
// --- Display Exception
ErrorHandler.DisplayError("Nem várt hiba lépett fel a lista frissítése során.", ex);
}
}
protected void SetListControl( Guid categoryId, PlaceHolder plMain, string color )
{
IDesignerDrogService srvDesignerDrog = ServiceFactory.GetDesignerDrogService();
DesignerDrog filter = new DesignerDrog(new DBGuid());
filter.FilterOnIsActual = 1;
filter.FilterOnIsactive = 1;
filter.CategoryRef = categoryId;
DataSet dt = srvDesignerDrog.DesignerDrogSelectFiltered( filter );
if(dt.Tables.Count > 0)
{
DesignerDrogContainer dsCont = new DesignerDrogContainer(dt.Tables[0]);
IDesignerDrogCategoryService srvCategory = ServiceFactory.GetDesignerDrogCategoryService();
//DesignerDrogContainer dsCont =
// srvCategory.SelectChildrenByCategoryOfDesignerDrogItem( categoryId );
Controls.ListControl listControl = (Controls.ListControl) LoadControl("Controls/ListControl.ascx");
listControl.DataSource = dsCont;
listControl.Color = color;
plMain.Controls.Add(listControl);
}
}
protected void Page_Load( object sender, EventArgs e )
{
DesignerDrog itemSelected = new DesignerDrog(new DBGuid());
_itemSrv = ServiceFactory.GetDesignerDrogService();
_itemCatSrv = ServiceFactory.GetDesignerDrogCategoryService();
if (Application["DesignerDrogCategories"] == null)
{
_itemCatSrv = ServiceFactory.GetDesignerDrogCategoryService();
Categories = _itemCatSrv.DesignerDrogCategorySelectAll();
Application["DesignerDrogCategories"] = Categories;
}
else
{
Categories = (DesignerDrogCategoryContainer) Application["DesignerDrogCategories"];
}
Guid itemGuid = new Guid();
try
{
string itemId = Request.QueryString["id"];
if (itemId == null)
throw new ApplicationException("Hiányzó kötelező paraméter: elem azonosító.");
itemGuid = new Guid(itemId);
itemSelected = _itemSrv.DesignerDrogSelect(itemGuid);
SelectedItem = itemSelected;
}
catch (Exception ex)
{
}
var title = itemSelected.Title;
if (((NewsDetails)HttpContext.Current.Handler).Request.UrlReferrer.LocalPath.Contains( "Results.aspx" ))
{
title = string.Format("{0}: {1}",((DesignerDrogCategory)Categories[itemSelected.CategoryRef.ToString()]).Name,title);
}
base.CreateHeaderControl( new Guid(), title );
LiteralControl objAbstract = pnlAbstract.Controls[0] as LiteralControl;
LiteralControl objBody = pnlBody.Controls[0] as LiteralControl;
objAbstract.Text = itemSelected.Abstract.Replace("\r\n", "<br/>");
objBody.Text = itemSelected.Body.Replace("\r\n", "<br/>");
//lblDate.Text = newsSelected.CreatedDate.ToShortDateString();
lblAuthor.Text = itemSelected.Author;
lblDate.Text = itemSelected.CreatedDate.ToShortDateString();
lblSource.Text = itemSelected.Source;
// kép megjelenítése:
if (itemSelected.PictureUrl.IsNull)
{
imgNewsPicture.Visible = false;
rowImg.Visible = false;
}
else
{
imgNewsPicture.Visible = true;
rowImg.Visible = true;
imgNewsPicture.ImageUrl = string.Format("ShowPicture.aspx?mode=newslist&designerDrogId={0}",
itemSelected.ID.Value);
}
// hír további képei:
DesignerDrogPictureContainer pics = _itemSrv.SelectChildrenByPictureOfDesignerDrogItems(itemSelected.ID);
if (pics.AllCount > 1)
{
linkMorePictures.Visible = true;
pnlMorePics.Visible = true;
linkMorePictures.NavigateUrl = string.Format("MorePictures.aspx?id={0}", itemSelected.ID.Value);
linkMorePictures.Attributes.Add("class", Color);
}
else
{
pnlMorePics.Visible = false;
linkMorePictures.Visible = false;
}
DesignerDrogLinkContainer links = _itemSrv.SelectChildrenByLinkOfDesignerDrogItem(itemGuid);
DesignerDrogAttachmentContainer attachments = _itemSrv.SelectChildrenByAttachmentOfDesignerDrogItem(itemGuid);
if (attachments.AllCount > 0)
ShowAttachmentGrid( itemGuid, attachments );
if (links.AllCount > 0)
ShowLinkGrid(itemGuid, links);
pnlLinks.Visible = links.AllCount > 0;
pnlAttachment.Visible = attachments.AllCount > 0;
}
public virtual DesignerDrog DesignerDrogSelect(DBGuid IDVal)
{
TraceCallEnterEvent.Raise();
try
{
DesignerDrog result = null;
DataSet entitySet = m_DataContext.ndihdDesignerDrogSelect(IDVal);
if (entitySet.Tables[0].Rows.Count != 0)
{
result = new DesignerDrog(entitySet);
}
TraceCallReturnEvent.Raise();
return result;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
TraceCallReturnEvent.Raise(false);
throw;
}
}
public virtual void DesignerDrogUpdate(DesignerDrog entity)
{
TraceCallEnterEvent.Raise();
try
{
m_DataContext.BeginNestedTran();
try
{
int count;
m_DataContext.ndihdDesignerDrogUpdate(entity.ID,
entity.Title,
entity.Author,
entity.Source,
entity.Abstract,
entity.PictureUrl,
entity.Body,
entity.CategoryRef,
entity.CreatedDate,
entity.IsActive,
entity.IsActual, out count);
if (count == 0) throw new ServiceUpdateException();
m_DataContext.CommitNested();
}
catch
{
m_DataContext.RollbackNested();
throw;
}
TraceCallReturnEvent.Raise();
return;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
TraceCallReturnEvent.Raise(false);
throw;
}
}
public new void DesignerDrogInsert( DesignerDrog entity )
{
// check permission: admin
PrincipalPermission permAdmin = new PrincipalPermission( Thread.CurrentPrincipal.Identity.Name, "Administrator" );
permAdmin.Demand();
TraceCallEnterEvent.Raise();
try
{
// check required fields:
if (entity.Title.Length == 0) throw new ArgumentNullException( "DesignerDrog.Title", "A Designer drog elem címe nincs megadva." );
if (entity.Abstract.Length == 0)
throw new ArgumentNullException( "DesignerDrog.Abstract", "A Designer drog elem rövid összefoglalója nincs megadva." );
if (entity.Body.Length == 0)
throw new ArgumentNullException( "DesignerDrog.Body", "A Designer drog elem szövege nincs megadva." );
// logical checks:
if (entity.PictureUrl.Length > 0 && entity.PictureUrl != DBString.Null)
{
string ext = Path.GetExtension( entity.PictureUrl ).ToLower();
if (!(ext.Equals( ".gif" ) || ext.Equals( ".jpg" ) || ext.Equals( "jpeg" )))
throw new ApplicationException( "Csak jpeg vagy gif formátumú kép csatolható." );
if (entity.PictureData == null || entity.PictureData.Length == 0)
throw new ApplicationException( "A fájlnévhez nem tartozik adat." );
}
if (entity.PictureData != null && entity.PictureData.Length > 0)
{
if (entity.PictureUrl.Length == 0)
throw new ApplicationException( "A kép adathoz nem tartozik fájlnév." );
}
// save data
entity.CreatedDate = DBDateTime.Now;
DesignerDrogPictureService designerDrogPictureSrv = new DesignerDrogPictureService( m_DataContext );
m_DataContext.BeginNestedTran();
try
{
// DesignerDrog
base.DesignerDrogInsert( entity );
if (entity.PictureData != null && entity.PictureData.Length > 0)
{
FileDataContext fileDataContext = new FileDataContext();
fileDataContext.DesignerDrogInsert( entity.ID, entity.PictureData );
}
// DesignerDrogPictures
foreach (DesignerDrogPicture pic in entity.DesignerDrogPictures.Current)
{
if (/*pic.PicturePath.Length > 0 &&*/ entity.PictureUrl != DBString.Null && entity.PictureData != null && pic.PictureData.Length > 0)
designerDrogPictureSrv.DesignerDrogPictureInsert( pic );
}
DesignerDrogAttachmentService attSrv = new DesignerDrogAttachmentService( m_DataContext );
DesignerDrogLinkService linkSrv = new DesignerDrogLinkService( m_DataContext );
// EDocumentAttachments - insert:
foreach (DesignerDrogAttachment file in entity.DesignerDrogAttachments.Current)
{
file.ItemRef= entity.ID;
file.IsActive = true;
file.CreatedDate = DateTime.Now;
attSrv.DesignerDrogAttachmentInsert( file );
}
foreach (DesignerDrogLink link in entity.DesignerDrogLinks.Current)
{
link.ItemRef = entity.ID;
linkSrv.DesignerDrogLinkInsert( link );
}
m_DataContext.CommitNested();
}
catch
{
m_DataContext.RollbackNested();
throw;
}
BusinessAuditEvent.Success(
new EventParameter( "DesignerDrogID", entity.ID.ToString() ),
new EventParameter( "DesignerDrogTitle", entity.Title )
);
TraceCallReturnEvent.Raise();
return;
}
catch (Exception ex)
{
ExceptionManager.Publish( ex );
BusinessAuditEvent.Fail(
new EventParameter( "Exception", ex.ToString() ),
new EventParameter( "DesignerDrogID", entity.ID.ToString() ),
new EventParameter( "DesignerDrogTitle", entity.Title )
);
TraceCallReturnEvent.Raise( false );
throw;
}
}
public virtual void DesignerDrogDelete(DesignerDrog entity)
{
TraceCallEnterEvent.Raise();
try
{
m_DataContext.BeginNestedTran();
try
{
m_DataContext.ndihdDesignerDrogDelete(entity.ID);
m_DataContext.CommitNested();
}
catch
{
m_DataContext.RollbackNested();
throw;
}
TraceCallReturnEvent.Raise();
return;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
TraceCallReturnEvent.Raise(false);
throw;
}
}
public new void DesignerDrogUpdate( DesignerDrog entity )
{
// Check permission: Admin
PrincipalPermission permAdmin = new PrincipalPermission( Thread.CurrentPrincipal.Identity.Name, "Administrator" );
permAdmin.Demand();
TraceCallEnterEvent.Raise();
try
{
// Check required fields:
if (entity.Title.Length == 0) throw new ArgumentNullException( "DesignerDrog.Title", "A Designer drog elem címe nincs megadva." );
if (entity.Abstract.Length == 0)
throw new ArgumentNullException( "DesignerDrog.Abstract", "A Designer drog elem abstract nincs megadva." );
if (entity.Body.Length == 0)
throw new ArgumentNullException( "DesignerDrog.Body", "A Designer drog elem szövege nincs megadva." );
if (entity.PictureUrl.Length > 0 && entity.PictureUrl != DBString.Null)
{
string ext = Path.GetExtension( entity.PictureUrl ).ToLower();
if (!(ext.Equals( ".gif" ) || ext.Equals( ".jpg" ) || ext.Equals( ".jpeg" )))
throw new ApplicationException( "Csak jpeg vagy gif formátumú kép csatolható." );
if (entity.PictureData == null || entity.PictureData.Length == 0)
{
entity.PictureUrl = "";
//throw new ApplicationException("A fájlnévhez nem tartozik adat.");
}
if (entity.PictureData != null && entity.PictureData.Length > 0)
{
if (entity.PictureUrl.Length == 0)
throw new ApplicationException( "A kép adathoz nem tartozik fájlnév." );
}
}
// Logical checks
DesignerDrog selected = DesignerDrogSelect( entity.ID );
if (selected == null)
throw new ApplicationException( "A megadott azonosítóval nem létezik hír." );
//string oldFileName = selected.PictureUrl;
// Save data
selected.Title = entity.Title;
selected.Abstract = entity.Abstract;
selected.Body = entity.Body;
selected.Source = entity.Source;
selected.Author = entity.Author;
selected.IsActive = entity.IsActive;
selected.PictureUrl = entity.PictureUrl;
selected.IsActual = entity.IsActual;
selected.CategoryRef = entity.CategoryRef;
DesignerDrogPictureService designerDrogPictureSrv = new DesignerDrogPictureService( m_DataContext );
DesignerDrogLinkService designerDrogLinkSrv = new DesignerDrogLinkService( m_DataContext );
FileDataContext fileDataContext = new FileDataContext();
m_DataContext.BeginNestedTran();
try
{
// Clear old files:
DesignerDrogPictureContainer oldPics = base.SelectChildrenByPictureOfDesignerDrogItems( entity.ID );
foreach (DesignerDrogPicture oldPic in oldPics.All)
{
designerDrogPictureSrv.DesignerDrogPictureDelete( oldPic );
}
// DesignerDrogPicture - insert:
foreach (DesignerDrogPicture pic in entity.DesignerDrogPictures.Current)
{
if (/*pic.PicturePath.Length > 0 &&*/ entity.PictureUrl != DBString.Null && entity.PictureData != null && pic.PictureData.Length > 0)
designerDrogPictureSrv.DesignerDrogPictureInsert( pic );
}
#region Links
// Clear old files:
DesignerDrogLinkContainer oldLinks = base.SelectChildrenByLinkOfDesignerDrogItem( entity.ID );
foreach (DesignerDrogLink oldLink in oldLinks.All)
{
designerDrogLinkSrv.DesignerDrogLinkDelete( oldLink );
}
// DesignerDrogPicture - insert:
foreach (DesignerDrogLink link in entity.DesignerDrogLinks.Current)
{
designerDrogLinkSrv.DesignerDrogLinkInsert( link );
}
#endregion
selected.DesignerDrogLinks = entity.DesignerDrogLinks;
selected.DesignerDrogAttachments = entity.DesignerDrogAttachments;
DesignerDrogAttachmentService attSrv = new DesignerDrogAttachmentService( m_DataContext );
// Clear old files:
DesignerDrogAttachmentContainer oldFiles = base.SelectChildrenByAttachmentOfDesignerDrogItem( entity.ID );
foreach (DesignerDrogAttachment oldFile in oldFiles.All)
{
attSrv.DesignerDrogAttachmentDelete( oldFile );
}
DesignerDrogAttachment newFile;
// EDocumentAttachments - insert:
foreach (DesignerDrogAttachment file in selected.DesignerDrogAttachments.Current)
{
if (file.FileData.Length == 0)
{
newFile = attSrv.DesignerDrogAttachmentSelectFile( file.ID );
}
else
{
newFile = file;
}
newFile.ItemRef = selected.ID;
newFile.Name = file.Name;
newFile.Description = file.Description;
newFile.CreatedDate = DateTime.Now;
if (attSrv.DesignerDrogAttachmentSelect( newFile.ID ) != null)
{
attSrv.DesignerDrogAttachmentUpdate( newFile );
}
else
{
attSrv.DesignerDrogAttachmentInsert( newFile );
}
}
// DesignerDrog
base.DesignerDrogUpdate( selected );
// DesignerDrog base picture update
fileDataContext.DesignerDrogDelete( selected.ID );
if (entity.PictureData != null && entity.PictureData.Length > 0)
{
fileDataContext.DesignerDrogInsert( entity.ID, entity.PictureData );
}
m_DataContext.CommitNested();
}
catch
{
m_DataContext.RollbackNested();
throw;
}
BusinessAuditEvent.Success(
new EventParameter( "DesignerDrogID", entity.ID.ToString() ),
new EventParameter( "DesignerDrogTitle", entity.Title )
);
TraceCallReturnEvent.Raise();
return;
}
catch (Exception ex)
{
ExceptionManager.Publish( ex );
BusinessAuditEvent.Fail(
new EventParameter( "Exception", ex.ToString() ),
new EventParameter( "DesignerDrogID", entity.ID.ToString() ),
new EventParameter( "DesignerDrogTitle", entity.Title )
);
TraceCallReturnEvent.Raise( false );
throw;
}
}
public DataSet DesignerDrogSelectFiltered( DesignerDrog filter )
{
TraceCallEnterEvent.Raise();
try
{
DataSet result = m_DataContext.ndihdDesignerDrogSelectFiltered(
filter.CategoryRef,
filter.FilterOnIsactive,
filter.FilterOnIsActual );
TraceCallReturnEvent.Raise();
return result;
}
catch (Exception ex)
{
ExceptionManager.Publish( ex );
TraceCallReturnEvent.Raise( false );
throw;
}
}
// -------------------------------------------------------------------------------------
/// <summary>
/// Copy constructor.
/// </summary>
/// <param name="IDVal">Value of 'uID' field</param>
/// <param name="origInstance">Original document data to copy.</param>
// -------------------------------------------------------------------------------------
public DesignerDrog(DBGuid IDVal,
DesignerDrog origInstance)
: base(IDVal, origInstance)
{
}
// -------------------------------------------------------------------------------------
/// <summary>
/// Copy constructor.
/// </summary>
/// <param name="origInstance">Original document data to copy.</param>
// -------------------------------------------------------------------------------------
public DesignerDrog(DesignerDrog origInstance)
: base(origInstance)
{
}
public void SaveDesignerDrog( DesignerDrog entity )
{
TraceCallEnterEvent.Raise();
try
{
//megnézzük hogy van e már hozzá megadott keresõ szöveg .. mert akkor azt update -eljük
GlobalSearch search = base.GlobalSearchSelect( entity.ID, "DESIGNERDROG" );
bool hasItem = search != null;
var text = entity.Title.ToString() + " " + entity.Abstract.ToString()
+ " " +
entity.Body.ToString() + " " + entity.Author + " " + entity.Source;
if (hasItem)
{
search.SearchText = text;
//ha van ilyen UPDATE
base.GlobalSearchUpdate( search );
}
else //ha még nincs ilyen INSERT
{
search = new GlobalSearch( entity.ID, "DESIGNERDROG" );
search.SearchText = text;
base.GlobalSearchInsert( search );
}
}
catch (Exception ex)
{
ExceptionManager.Publish( ex );
BusinessAuditEvent.Fail(
new EventParameter( "Exception", ex.ToString() ),
new EventParameter( "IDRef", entity.ID.ToString() ),
new EventParameter( "SearchCategory", "NEWS" )
);
TraceCallReturnEvent.Raise( false );
throw;
}
}