UserId from the table is null when controller is called?

Question

Hi team

 

I have procedure for Usp_UserNamebyUserId and has UserId, but on the controller for login, its state as null. How can i fix this issue? Here is my logic from the controller.

 

// login.cshtml

<div class="form-group">
<input id="BtnLogin" type="submit" class="btn btn-success btn-pressure" name="BtnLogin" value="Login" />
<input id ="btnSubmit" type ="submit" class="btn btn-info btn-pressure" name="btnSubmit" value="Create" />
</div>
</div>

// controller.cs

[HttpPost]
[AllowAnonymous]
[ValidateAntiForgeryToken]
public ActionResult CreateLogin(LoginCreateModel objSubmit)
{
if(objSubmit.btnSubmit == "Create")
{
ViewBag.Message = "Details saved successfully";
}
return View(objSubmit);
}
[HttpPost]
[AllowAnonymous]
[ValidateAntiForgeryToken]
public ActionResult Login(Login login)
{
if (ModelState.IsValid)
{
bool success = WebSecurity.Login(login.username, login.password, false);
var UserID = GetUserID_By_UserName(login.username);
var LoginType = GetRoleBy_UserID(Convert.ToString(UserID)); // its null when its debugged
if (success == true)
{
if (string.IsNullOrEmpty(Convert.ToString(LoginType)))
{
ModelState.AddModelError("Error", "Rights to User are not Provide Contact to Admin");
return View(login);
}
else
{
Session["Name"] = login.username;
Session["UserID"] = UserID;
Session["LoginType"] = LoginType;
if (Roles.IsUserInRole(login.username, "Admin"))
{
return RedirectToAction("AdminDashboard", "Dashboard");
}
else
{
return RedirectToAction("UserDashboard", "Dashboard");
}
}
}
else
{
ModelState.AddModelError("Error", "Please enter valid Username and Password");
return View(login);
}
}
else
{
ModelState.AddModelError("Error", "Please enter Username and Password");
return View(login);
}
}

Answer 1

Jignesh no its not

 

CREATE proc [dbo].[Usp_getRoleByUserID]

@UserId int

as

begin

select R.RoleName FROM webpages_UsersInRoles WR

inner JOIN webpages_Roles R on WR.RoleId = R.RoleId

where WR.UserId =@UserId

end

GO

 

Answer 2

Hey,

Please check you store procedure is retruning data or not ?  if not then Share your store procedure here?

Answer 3

Should this before @using(Html.BeginForm() {.......}?

Answer 4

Please try to keep the UserId in hidden field or in any hidden text, so while submit button you can pass that UserId to controller, so you can easily get UserId in the controller.

 

In view store the UserId in hidden fields 

@Html.HiddenFor(x => x.UserId)

 

 

Let me know below 

1) Are you calling action from jquery to submit data? or are you calling @BeginForm in the .cshtml page  directly. 

2) How can you get User id in controller?? 

Answer 5

[NonAction]

public string GetRoleBy_UserID(string UserId)

{

return objIAccountData.GetRoleByUserID(UserId);

}

Answer 6

Hi,

Can you post GetUserID_By_UserName , GetRoleBy_UserID method details ?