16,004,686 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View .NET questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by dawood abbas (Top 19 by date)
dawood abbas
11-Jan-19 7:58am
View
@shawn patil I can join but cannot get data by grouping.
dawood abbas
11-Jan-19 7:56am
View
below just grouping which is in Ctroller.cs working and getting data..fine
var res = _objRefCustomerBS.GetAllRefCustomer().GroupBy(x => x.MobileNo).Select(x => x.ToList().OrderByDescending(y => y.cuRefID).First()).ToList();
but this below code is not working in DAL class file.
var res = CRMEntites.RefCustomers.GroupBy(x => x.MobileNo).Select(x => x.ToList().OrderByDescending(y => y.cuRefID).First()).ToList();
dawood abbas
11-Jan-19 7:54am
View
I got they query but throwing an error null exception...whereas in MVC controller it's coming, in DAL cant...
var res = from users in CRMEntites.Users
join cust in CRMEntites.Customers on users.uID equals cust.uID
join refCust in (
from refC in CRMEntites.RefCustomers
group refC by refC.MobileNo into grp
select grp.OrderByDescending(g => g.cuRefID).FirstOrDefault()
) on users.MobileNo equals refCust.MobileNo
where users.IsDelete != true && users.rID == 3 && cust.Status == "INV" && cust.Status == "VIS"
select new DashboardGrid
{
Name = users.Name,
CreatedOn = refCust.CreatedOn,
MobileNo = refCust.MobileNo,
Extension = refCust.Extension
};
dawood abbas
10-Jan-19 2:35am
View
I cant complete my linq query as per above sql query.
dawood abbas
8-Jul-15 0:51am
View
Deleted
I got the right answer..
CREATE TABLE #result
(
PackagePeriod varchar(20),
UserId INT,
OldExpiryDate DATE,
AmountToPay FLOAT,
PyingAmount FLOAT,
Balance FLOAT,
LastPaidDate DATE,
Company_Id INT
)
declare @PackagePeriod varchar(20)
declare @UserId int
declare @OldExpiryDate DATE
declare @AmountToPay FLOAT
declare @PyingAmount FLOAT
declare @Balance FLOAT
declare @LastPaidDate DATE
declare @Company_Id INT
declare result_cursor cursor for
SELECT PackagePeriod, UserId, OldExpiryDate, AmountToPay, PyingAmount, Balance, LastPaidDate, Company_Id from #result
OPEN result_cursor
FETCH NEXT FROM result_cursor INTO @PackagePeriod, @UserId, @OldExpiryDate, @AmountToPay, @PyingAmount, @Balance, @LastPaidDate, @Company_Id
WHILE @@FETCH_STATUS = 0
BEGIN
if(@PackagePeriod='Monthly')
begin
-- update your table
end
else if(@PackagePeriod='Quarterly')
begin
--update table
end
FETCH NEXT FROM result_cursor INTO @PackagePeriod, @UserId, @OldExpiryDate, @AmountToPay, @PyingAmount, @Balance, @LastPaidDate, @Company_Id
END
CLOSE result_cursor
DEALLOCATE result_cursor
dawood abbas
2-Jul-15 8:30am
View
i dnt have any condition to retrieve data from column in loop..
dawood abbas
20-Jun-15 7:13am
View
its not working
dawood abbas
20-Jun-15 6:41am
View
where to write it? in under qoutes or "+Server.MapPath("~/LoginPage.aspx")+" like this
dawood abbas
20-Jun-15 6:33am
View
http://localhost:10562/Admin/~/LoginPage.aspx
Server Error in '/' Application.
The resource cannot be found.
dawood abbas
20-Jun-15 6:31am
View
so how to give path which is out side of the folder?
dawood abbas
19-Jun-15 5:26am
View
in logout page i want to null it..
dawood abbas
19-Jun-15 5:26am
View
thanq but how to set null value to this coockie?
dawood abbas
18-Jun-15 8:21am
View
I have one demo project which was developed in php in that happening na.
dawood abbas
18-Jun-15 6:32am
View
then how to do it?
dawood abbas
5-May-15 8:44am
View
please read properly my post.
dawood abbas
22-Apr-15 2:43am
View
I used it but at many places displaying error (red mark)
dawood abbas
21-Apr-15 5:31am
View
@Maciej Los I tried with many times then only to came here for result.I did with view state.some are said its not a good way thats why i ddnt post my code.
dawood abbas
15-Apr-15 4:34am
View
dont you get?
dawood abbas
15-Apr-15 3:31am
View
yes
Show More