public IActionResult AddUserVotes(UserVotingRequest userVoting)
{
var user = HttpContext.User;
if (user.HasClaim(c => c.Type == "Typetoken"))
{
if (user.Claims.FirstOrDefault(c => c.Type == "Typetoken").Value == "Login")
{
var result = userVotingBL.AddUserVotes(userVoting);
if (result != null)
{
var success = true;
var message = "User vote successfully added";
return(Ok(new { success, message, result }));
}
else
{
var success = false;
var message = "User vote added failed";
return(Ok(new { success, message }));
}
}
}
return(BadRequest("Used Invakid token"));
}
/// <summary>
/// this is the method for add user votes.
/// </summary>
/// <param name="userVoting"></param>
/// <returns></returns>
public UserVotingResponse AddUserVotes(UserVotingRequest userVoting)
{
try
{
if (userVoting != null)
{
return(userVotingRL.AddUserVotes(userVoting));
}
else
{
return(null);
}
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// This is the method for add user votes.
/// </summary>
/// <param name="userVoting"></param>
/// <returns></returns>
public UserVotingResponse AddUserVotes(UserVotingRequest userVoting)
{
try
{
SqlConnection sqlConnection = new SqlConnection(_configuration["connectionstring:ElectionDb"]);
SqlCommand sqlCommand = new SqlCommand("sp_AddUserVotes", sqlConnection);
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@FirstName", userVoting.FirstName);
sqlCommand.Parameters.AddWithValue("@LastName", userVoting.LastName);
sqlCommand.Parameters.AddWithValue("@MobileNumber", userVoting.MobileNumber);
sqlCommand.Parameters.AddWithValue("@CandidateId", userVoting.CandidateId);
sqlCommand.Parameters.AddWithValue("@CreatedDate", DateTime.Now);
sqlCommand.Parameters.AddWithValue("@ModifiedDate", DateTime.Now);
sqlConnection.Open();
SqlDataReader sdr = sqlCommand.ExecuteReader();
while (sdr.Read())
{
votingResponse = new UserVotingResponse();
votingResponse.UserId = Convert.ToInt32(sdr["UserId"]);
votingResponse.FirstName = sdr["FirstName"].ToString();
votingResponse.LastName = sdr["LastName"].ToString();
votingResponse.MobileNumber = sdr["MobileNumber"].ToString();
votingResponse.CandidateId = Convert.ToInt32(sdr["CandidateId"]);
votingResponse.CreatedDate = Convert.ToDateTime(sdr["CreatedDate"]);
votingResponse.ModifiedDate = Convert.ToDateTime(sdr["ModifiedDate"]);
}
sdr.Close();
if (votingResponse != null)
{
return(votingResponse);
}
else
{
return(null);
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}