Devart Forums

Code: Select all

' this query will work
Dim results = From p In dc.Payments _
			     Where Not (From t In dc.OnlineTransactions Where t.TxRefNum = p.TxRefNum).Any()
Console.WriteLine("result count: " & results.Count())

' this query will throw:
' "System.NotSupportedException: Constant cannot be sequences."
Dim allTransactions = dc.OnlineTransactions
Dim results2 = From p In dc.Payments _
			      Where Not (From t In allTransactions Where t.TxRefNum = p.TxRefNum).Any()
Console.WriteLine("result count: " & results2.Count())

Code: Select all

foreach (KeyValuePair> pathExceptions in paths)
{
List tests = new List();

foreach (string pathException in pathExceptions.Value)
              tests.Add(new Test() { Value = pathException });

var fla =  (from ds in global.DirectoryScans
							  join dse in global.DirectoryScanEntries on ds.DirectoryScanId equals dse.DirectoryScanId
							  join sq1 in tests on dse.DirectoryPath.ToLower() equals sq1.Value.ToLower() into lj1
							  from p in lj1
							  select dse.DirectorySize).Sum();
}

Code: Select all

foreach (KeyValuePair> pathExceptions in paths)
{
List tests = new List();

foreach (string pathException in pathExceptions.Value)
         tests.Add(new Test() { Value = pathException });			
	var fla =  (from ds in global.DirectoryScans
							  join dse in global.DirectoryScanEntries on ds.DirectoryScanId equals dse.DirectoryScanId
							  join sq1 in tests on dse.DirectoryPath.ToLower() equals sq1.Value.ToLower() into lj1
							  from p in lj1
							  select dse.DirectorySize);
}

Code: Select all

private static void getDDL_fiscYrs(ref DropDownList ddl)
{

            //Gets last year, this year, next year:
            int[] addlYrs = { System.DateTime.Today.Year - 1, System.DateTime.Today.Year, System.DateTime.Today.Year + 1 };

            //Gets all the years from past distributions
            var FYs = from c in DB.Distributions
                      select c.Initiatedondatetime.Value.Year;

            FYs = FYs.Union(addlYrs).Distinct();

            FYs = from yr in FYs
                  orderby yr descending
                  select yr;

            ddl.DataSource = FYs.ToList(); //array didn't work here

            try
            {
                ddl.DataBind();
                ddl.Items.Insert(0, " - Select Fiscal Year - "); //add spacer at top

                ddl.SelectedIndex = 0;
                if (!string.IsNullOrEmpty(UserSession.Fy))
                    ddl.SelectedValue = UserSession.Fy;
            }
            catch (Exception ex)
            {
                throw ex;
            }
}

Code: Select all

private static void getDDL_fiscYrs(ref DropDownList ddl) 
{ 

            //Gets last year, this year, next year: 
            int[] addlYrs = { System.DateTime.Today.Year - 1, System.DateTime.Today.Year, System.DateTime.Today.Year + 1 }; 

            //Gets all the years from past distributions 
            var FYs = (from c in DB.Distributions 
                      select c.Initiatedondatetime.Value.Year).ToList(); 

            FYs = FYs.Union(addlYrs).Distinct(); 

            FYs = from yr in FYs 
                  orderby yr descending 
                  select yr; 
            //...

Code: Select all

                //Gets all the ordered, non-redundant years from past distributions
                int[] FYs = (from c in DB.Distributions
                          orderby c.Initiatedondatetime.Value.Year descending
                          select c.Initiatedondatetime.Value.Year).ToArray();

                  /*********************************************/
                 /** need to add other years if they don't exist in dist **/
                /*********************************************/
                int[] addlYrs = {
                                    System.DateTime.Today.Year - 1,     //Last year
                                    System.DateTime.Today.Year,          //This year
                                    System.DateTime.Today.Year + 1 }; //Nextyear
                FYs = FYs.Union(addlYrs).Distinct().ToArray();        //Combine, non-redundant
                ddl.DataSource =  //Sort Desc
                                (from yr in FYs orderby yr descending select yr);
                ddl.Items.Insert(0, " - Select Fiscal Year - ");          //Add Select Spacer
                ddl.DataBind();
                ddl.SelectedIndex = 0;

                //Preselect Enumerated Fiscal Year
                if (!string.IsNullOrEmpty(UserSession.Fy))
                    if (ddl.Items.Contains(new ListItem(UserSession.Fy)))
                        ddl.SelectedValue = UserSession.Fy;