UserId from the table is null when controller is called?

Guest User

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

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

// 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);
}
}

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Guest User6y ago
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

0
Jignesh Kumar6y ago
Hey,
Please check you store procedure is retruning data or not ? if not then Share your store procedure here?
0
Guest User6y ago
Should this before @using(Html.BeginForm() {.......}?
0
Rupesh Kahane6y ago
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??
0
Guest User6y ago
[NonAction]
public string GetRoleBy_UserID(string UserId)
{
return objIAccountData.GetRoleByUserID(UserId);
}
0
Ramachandran M6y ago
Hi,
Can you post GetUserID_By_UserName , GetRoleBy_UserID method details ?
0