.Net MVC C# SQL

Question

Hello sir..jst a beginner in MVC..so jst started doing coding..trying to build one application but i am stuck in one logic. i want that my Login page should check three condition 1.UserName matches from Login table 2. Password Matches from Login Table 3. StatusID of Login table == StatusID of Status_Master_table == 1 because my status will be active when StatusID will be 1 and rest in any StatudID page will not login... I have successuly made Username and Password matched but for third condition i have tried a lot but could not able to do it... It will be an honoured for me sir if you could able to take me out from this query..your help is urgently required...

kalu singh rao · Answer

You can make query this way. It is very easy so don't create confusion. select usernamepasswordstatusid from logintable inner joinStatus_Master_table on logintable.statusid = Status_Master_table where logintable.username = 'test' and logintable.password = '123' and Status_Master_table.statusid = 1

Bikesh Srivastava · Answer

You can visit my blog to find your solution . https://bikeshsrivastava.blogspot.in/2016/02/part-13-basic-crud-operation-in.html

Vinay Singh · Answer

Hi you just need to change the query check the given below var _objuserdetail = ( from data in objentity.UserDetails where data.UserId == _objuserloginmodel.UserId && data.Password == _objuserloginmodel.Password && data.Status=1 select data); You just need to add more line the code of given article link

Vinay Singh · Answer

Hi Try the below link Insert Update Delete Operation In Asp.Net MVC Using Entity Framework C#.Net CRUD Functionality for login Simple Login From in Asp.Net MVC Using C#.Net

Nilesh Sawardekar · Answer

if your beginner and want to know everythin about MVC then follow https://www.youtube.com/watch?v=-pzwRwYlXMw&list=PL6n9fhu94yhVm6S8I2xd6nYz2ZORd7X2v

Kunal Gupta · Answer

Thanks a lot sir for making me out from a long back query....and the way u expressed it is excellent....

Vinay Singh · Answer

Hi Please try the below tutorial Login From With Active User Validation in Asp.Net MVC Using C#.Net

Vinay Singh · Answer

Ok So u r using 2 entity files. But i am not able to understand why u r using 2 entity files. When it can be done only by one entity file But no issue use it in the shown manner //StatusIs : 1 =Active //StatusIs : 0 =InActive FTDatabaseEntities dc = new FTDatabaseEntities(); FTDatabaseEntities2 dc1 = new FTDatabaseEntities2(); string userId= Your User Id ; string Password= Your Password ; var _objuserdetail = (from d in dc.Login from s in dc1.Status_Master_table where d.UserId == UserId && d.Password == Password && d.StatusId=1 && s.StatusId=d.StatusId select new { UserId =d.UserId  UserName =d.UserName  StatusId=d.StatusId StatusName=s.StatusName statusDescription=s.statusDescription }); if (_objuserdetail.Count()>0) { //---login success } else { //---login fail } just make changes in the hilighted part

Kunal Gupta · Answer

But i have made FTDatabaseEntities2 dc = new FTDatabaseEntities2() ; for Status_Master_Table Then how will i add?

Vinay Singh · Answer

It clearly shows that your entity file does not have StatusMaster table. Please add the statusMaster Table into you entity file which is FTDatabaseEntities . and then rename the entity table in your query.

Kunal Gupta · Answer

This error is coming now sir....

Vinay Singh · Answer

It shows that your status master table is of different name and for second you can error you can null will also work. For second error you can use if(_ objuserdetail !=null) { } i have send you a message plz check and revert back to me.

Kunal Gupta · Answer

Thanks for the reply and ur effort for helping me in my application.. Sir again getting an error as pasted below:

Vinay Singh · Answer

Hi Try the query in given manner in your code //StatusIs : 1 =Active //StatusIs : 0 =InActive FTDatabaseEntities dc = new FTDatabaseEntities(); string userId= Your User Id ; string Password= Your Password ; var _objuserdetail = (from d in dc.Login from s in dc.Status_Master_table where d.UserId == UserId && d.Password == Password && d.StatusId=1 && s.StatusId=d.StatusId select new { UserId =d.UserId  UserName =d.UserName  StatusId=d.StatusId StatusName=s.StatusName statusDescription=s.statusDescription }); if (_objuserdetail.Count()>0) { //---login success } else { //---login fail }

Kunal Gupta · Answer

sir u have checked an attached zip file?

Kunal Gupta · Answer

In my database i have made two tables Login && Status_Master_table 1.UserId 1.StatusId 2.UserName 2. StatusName 3.Password 3. status Description 4.StatusId FTDatabaseEntities dc = new FTDatabaseEntities() [ for Login ] FTDatabaseEntities2 dc = new FTDatabaseEntities2() [ for Status_Master_table ] i want that my Login page should check three condition 1.UserName matches from Login table 2. Password Matches from Login Table 3. StatusID of Login table == StatusID of Status_Master_table == 1 because my status will be active when StatusID will be 1 and rest in any StatudID page will not login... I have successuly made Username and Password matched but for third condition i have tried a lot but could not able to do it... StatusId of Status_Master_Table is primary key in Status_Master_Table and foreign key in Login table

Kunal Gupta · Answer

Waiting for ur reply sir.

Kunal Gupta · Answer

sir I have attached an application in a zip file...just a begining application..u can see from there also..

Kunal Gupta · Answer

In my database i have made two tables Login && Status_Master_table 1.UserId 1.StatusId 2.UserName 2. StatusName 3.Password 3. status Description 4.StatusId FTDatabaseEntities dc = new FTDatabaseEntities() [ for Login ] FTDatabaseEntities2 dc = new FTDatabaseEntities2() [ for Status_Master_table ] i want that my Login page should check three condition 1.UserName matches from Login table 2. Password Matches from Login Table 3. StatusID of Login table == StatusID of Status_Master_table == 1 because my status will be active when StatusID will be 1 and rest in any StatudID page will not login... I have successuly made Username and Password matched but for third condition i have tried a lot but could not able to do it... StatusId of Status_Master_Table is primary key in Status_Master_Table and foreign key in Login table

Vinay Singh · Answer

Hi please let me know the fields in name in your entity table.

Kunal Gupta · Answer

Sir trying a lot...now data.StatusId = 1  error is coming here...Please see the codes from the application that i have attached

Vinay Singh · Answer

Hi The hilighted part[ objentity.UserDetails ]is the entity table. which you need to create in your DB and import it. in your project entity.

Kunal Gupta · Answer

var _objuserdetail = (from data in objentity.UserDetails where data.UserName == u.UserName && data.Password == u.Password && data.StatusId = 1 Sir a red line is coming in the highligted bold[ objentity.UserDetails ]...due to which i could not able to debug..error is coming...instead of this what should i write...sir u can check this through my zip file also...as attached

Kunal Gupta · Answer

Thanks Vinay for your support...But sir this is not working..I have uploded that apllication in Zip file..u can check from there sir.

.Net MVC, C#, SQL