public static aspnet_Tab GetTabPathByTabId(int TabId)
{
using (TabDataContext tabDC = new TabDataContext(Settings.ConnectionString))
{
tabDC.ObjectTrackingEnabled = false;
aspnet_Tab entity = (from x in tabDC.aspnet_Tabs
where x.TabId == TabId
select x).SingleOrDefault();
return entity;
}
}
public List<aspnet_Tab> GetListByPortalIdIsSecure(int PortalId, bool IsSecure)
{
using (TabDataContext tabDC = new TabDataContext(Settings.ConnectionString))
{
tabDC.ObjectTrackingEnabled = false;
var query = from x in tabDC.aspnet_Tabs where x.IsSecure == IsSecure select x;
if(PortalId >= 0)
query = query.Where(x=>x.PortalId == PortalId);
List<aspnet_Tab> list = query.ToList();
int count = list.Count;
return list;
}
}
public static List<aspnet_Tab> GetListByPortalId_ContentItemId_IsSecure(int PortalId, int ContentItemId, bool IsSecure)
{
using (TabDataContext dbContext = new TabDataContext(Settings.ConnectionString))
{
dbContext.CommandTimeout = Settings.CommandTimeout;
var query = from x in dbContext.aspnet_Tabs
where x.PortalId == PortalId
&& x.ContentItemId == ContentItemId
&& x.IsSecure == IsSecure
select x;
return query.ToList();
}
}
public DataTable GetActiveListByPortalIdIsSecure(int PortalId, bool IsSecure)
{
using (TabDataContext tabDC = new TabDataContext(Settings.ConnectionString))
{
tabDC.ObjectTrackingEnabled = false;
List<aspnet_Tab> list = (from x in tabDC.aspnet_Tabs
where x.PortalId == PortalId && x.IsSecure == IsSecure && x.IsVisible == true
select x).ToList();
DataTable dt = LinqHelper.ToDataTable(list);
return dt;
}
}
