What is the preferred way to handle this? Delegates? I have a dropdown box of comparison operators = <, <=, > , >=, == which is used to set up a filter. The filter expression is exactly the same for every case other than the operator. I can do it through a switch, but I am sure there is a one liner that can handle to entire problem. Just not sure what it is?
case <
If a < b
case > [code]....
I'm creating a repository and service layer in my app, and my repo has a very simple function
Public Function GetRegions() As IQueryable(Of Region) Implements IRegionRepository.GetRegions
Dim region = (From r In dc.Regions
Select r)
Return region.AsQueryable
End Function
Now in my Service layer I've got a function like this
Public Function GetRegionById(ByVal id As Integer) As Region Implements IRegionService.GetRegionById
Return _RegionRepository.GetRegions().Where(Function(r) r.ID = id).FirstOrDefault
End Function
But i can't figure out how to add And r.isActive = True
how to have multiple operators in this query?
I have a local collection of record Id's (integers).I need to retrieve records that have every one of their child records' ids in that local collection.
Here is my query:
public List<int> OwnerIds { get; private set; }
...
filteredPatches = from p in filteredPatches
where OwnerIds.All(o => p.PatchesOwners.Select(x => x.OwnerId).Contains(o))
select p;
[code]...
I am getting this error:Local sequence cannot be used in Linq to SQL mplementation of query operators except the Contains() operator.I understand that.All() isn't supported by Linq to SQL, but is there a way to do what I am trying to do?
I need to know one Comparisons in CSV like this...
These are the columns in CSV 1 and CSV 2 :
Dekking id; Dekking; Acnv_id; Acnv description; From ; To; Value
Sample From CSV 1 Data :
Columns 1
499; Algemene Contractspecificaties; 122; Periodiciteit; 15/01/16; 15/01/16; 48
Columns 2
500; Opbouw Pensioenreserve; 130; Premietaks Tak 24; 15/01/16; 15/06/32; 29
Sample From CSV 2 Data :
Columns 1499; Algemene Contractspecificaties; 122; Commerciële; 08/01/16; 08/06/32; 12
Columns 2
500; Opbouw Pensioenreserve; 130; Waarborg 23; 08/01/16; 08/06/32; 29
I need to know how to compare these two columns from the column "Acnv description;" to "Value" as mostly the values from "Dekking id" to "Acnv_id" would be mostly common.
How to compare the values sepately FROM "Acnv description;" to "Value" Columns values IF the Columns "Dekking id; Dekking; Acnv_id;" MATCHES.
Dekking id; Dekking; Acnv_id; Acnv description; From ; To; Value
How to compare only these columns in the CSV ...
I have a function that compares each row in a database table with its relevant entry in the relevant file. When comparison is done its send back the results to client(browser window). If the count of rows to compare is smaller smaller like 200, its works fine, but when count is greater the comparison take time sometimes 4 or 5 minutes depending upon the rows to compare.
View 1 Repliesdeveloping an application or simple script in asp.net which basically checks the md5 checksum of a file which will be my web application, and i want it to be compared with the original and be able to alert me of any changes ie defacement.
View 3 RepliesQuestion: Anybody has experience with ZedGraph / MS-Chart controls ?
I am thinking about which to use ?
Basically, I have a tendency to ZedGraph, because I need .NET framework 2.0 while MS-Chart is 3.5 (and I don't know how well a 3.5 assembly works on 2.0) and because I could use it privately, too (I use Linux privately).
But I don't know if MS-Charts offers more. Does ZedGraph for example offer reasonable quality 3d piecharts ?
And reasonable color design, like gradient colors ? And if it does, is it as simple (or nearly as simple) as MS-Chart controls ? And does ZedGraph offer databinding, e.g. a datatable from a database ?
SELECT Sum(ABS([Minimum Installment])) AS SumOfMonthlyPayments FROM tblAccount
INNER JOIN tblAccountOwner ON tblAccount.[Creditor Registry ID] = tblAccountOwner.
[Creditor Registry ID] AND tblAccount.[Account No] = tblAccountOwner.[Account No]
WHERE (tblAccountOwner.[Account Owner Registry ID] = 731752693037116688)
AND (tblAccount.[Account Type] NOT IN
('CA00', 'CA01', 'CA03', 'CA04', 'CA02', 'PA00', 'PA01', 'PA02', 'PA03', 'PA04'))
AND (DATEDIFF(mm, tblAccount.[State Change Date], GETDATE()) <=
4 OR tblAccount.[State Change Date] IS NULL)
AND ((tblAccount.[Account Type] IN ('CL10','CL11','PL10','PL11')) OR
CONTAINS(tblAccount.[Account Type], 'Mortgage')) AND (tblAccount.[Account Status ID] <> 999)
[code]....
I hate webform that no matter what action is done with a client side page(such as clicking a dropdownlist to only see the Items), it cause a postback&re-rendering of the whole page and all of the page events is raised( page_init,page_load....complete....).
We know that the server side .cs page shoudnt have to go through all the events and many methods(such as "IsPostback",viewstate), in fact,it just have to do only one thing:get data from DB for the dropdownlist and show it to us, other part of the page just doesnt have to change.
We may achieve this effect using Ajax, but the key is I dont wanna raise too many useless event .
seems MVC can handle such a problem, one action of browser side is replied by exactly one method,and time isnot waste by raise event...
Is this the biggest advantage of MVC?
I am looking for an open source CMS for ASP.NET MVC. I have found MvcCms, N2, and AtomicCMS. I'm looking for any advice, anecdotes, resources or articles comparing the different open source projects so I can find the best one for my project. I'd like to find information about the features, extensibility, relative reliability and continued development of the different projects.
View 2 Repliesmy db record encryptbypassphrase value,like
0x010000000F54469460C6585D39B371536529ABEADE776E5758902946, when I login, input password "1234",
how to comparison with db encryptbypassphrase value?
id passphrasepwd
test1 0x010000000F54469460C6585D39B371536529ABEADE776E5758902946
test2 0x010000004F3E009572D8633335E09F223C98E0A4C2E1401EDCD29A4E
I have two data tables, Results1 and Results2. Results1 are used to hold records that matches with the user selection criteria. Results2 holds records that matches with the user selection criteria with one search criteria omitted.
The two tables have identical fields. I need to get all the records that match Field 2, Filed 3 and Field 4 in both of the tables.
Can compare one record at a time with all the ohers but would like to find a more computationally easier method to do this....
what MVC stands for,but if I'm already developing .NET websites without it,is there any reason I would need/want to use it?is it designed for people who already have experience with developing in an MVC environment and wanted a ".net"version of it?Is there some "head-to-head" comparison of MVC against other programming environments or techniques that have been written? It seems like what I might gain in development speed I might lose in flexibility.maybe I just don't understand what all the fuss is about.hence this post!
View 6 Repliesi m searching a way to compare the password in hash formatting. the saved password in database is in hash formatting and trying to change password. the changed password should be save in hash formatting as well. plz tell me the solution.protected
{
HashedPassword =
void btnSubmit_Click(object sender,
[code]...
Is there a function similar to CopyWebsite that would allow me to compare the files between my laptop and the hosted webserver? Tonight I deleted all the files off of my computer and downloaded the complete website from the hosted server just to ensure that I had the most recent copy. It would have been nice to have run a comparison routine to see if the files were identical. I have using Visual Studio 2010 Pro
View 3 RepliesI'm in the process of migrating a web application from a DBase III backend to mySql. During the process, I am going to be running simultaneous update queries to two datasources, one being the original dbase III structures, and the other the mySql schema/tables. I need a way to determine that when any data updates occur, that the two data sources match each other.
I found this piece of code:
[URL]
However, I hvae the same error as another user, in that when I add items to the comparison, I'm limited to 32 columns, and some of the DBASE III structures have 120+ columns. I'm somewhat of a C# n00b, so I need some /pointers. I tried playing around with the MERGE functions for datatables, but couldn't get it to work the way I wanted it to.
I have a table with userID's stored in it and I want to SELECT a user out of that table to see if it's the current logged in user. I'm using this as logic to determine what action a button click will do. For example the button click will do something like this:
[Code]....
My broblem is getting the UserName from my table of data. I've tried it like this:[Code]....
But when I try debugging it shows that CurrentUser's value = Nothing
My UserNames (ToUser) contain letters and numbers (nvarchar(30)).
anybody comment on the differences between IIS & Cassini in terms of performance and memory consumption?am using VS 2010 on a Windows XP SP2 developing a silverlight app.My machine has a 3 GB DDR2 RAM but still debugging is a pain and cassini keeps on crashing and I need to restart my machine 3-4times a day which is a considerable loss of productivity.
View 1 Repliescomparing integer values which are actually in string (varchar(9)) right now...I'm trying to do the following in a stored procedure..
SET @MinProjectYear = SELECT ProjYear FROM P_A WHERE ID = @ID
SET @MaxProjectYear = SELECT ProjYear FROM P_A WHERE UserId = @UserID AND...
IF EXISTS(SELECT 1 FROM P_A WHERE MinProjectYear <= MaxProjectYear)
return true
The MinProjectYear and MaxProjectYear are varchar(9) values stored as "2007-2008", "2009-2010", etc.
How do I split and compare the years?? i.e. check if 2007-2008 <= 2009-2010 ??
I want to limit the selecting of data records to only the user who created the record, OR a users who's email address belongs to the domain of the record being edited. So, if the producer has a value in the URL of "[URL]" and their email address in the Membership is [URL] they will be able to see the record.
I have the following table:
Table - Producer
Field: ProducerID
Field: ItemUserID
Field: URL
I have figured out how to select based on the ItemUserID (see code below), but I don't know how to compair the email address values of URL and the Membership.
protected void SqlDataSource1_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
{
if (Page.User.Identity.IsAuthenticated)
{
//get id of user logged in
e.Command.Parameters["@ItemUserID"].Value = Membership.GetUser().ProviderUserKey;
}
}
how to code my requirements?
I have this code in a button click event:
[Code]....
When the page is first opened, Session("LeverancieFilterExpression")) is supposed to be blank or empty so the next statement should be executed but this is not happening. Can anyone explain why? I have the .IsNullOrEmpty method elsewhere in the program and it seems to work. Also, I have
[Code]....
in the page load.
I am a .net developer and soon going to try my hands in mobile development.
I am searching for, what are the differences in developing a application for windows mobile and blackberry in terms of:
1. System/Software requirement.
2. Languages we can use for both
3. Can we use .net for blackberry apps development and Java for windows mobile.
I am trying to reconstruct a date/time period from five data elements Year, StartMonth, StartDate, EndMonth, EndDate If the event starts on June 5 and ends on June 6, 2010 - The label would read June 5 thru 6, 2010. If the event starts on June 30 and ends on July 2, 2010 - the Label would read June 30 thru July 2, 2010. and if the event starts on June 5 and ends on June 5, 2010 - The label would read June 5, 2010. I've tried a few variations without success. This one comes closest to what I'm aiming for.
[Code]....
I would like to allow the user to be able to perform searches on a large list of objects. They will be able to search for keywords and use 'and' and 'or' operators. I am having trouble finding the best way to implement those operators in my LINQ query.
View 4 RepliesIs there a better way to do this than to check for Exception string?
I would rather have this catch-all error handled on the page, but for SOAP exceptions (web-service calls) I need to log the details of the actual exception that occured on the server, not the client.
The ".Detail.InnerText" property isn't in a generic exception, and can only be gotten after casting a generic exception to a SOAP exception.
[Code]....
I would think there is a way to get at the underlying Exception's type without using string comparison.
