public TokenDto GenerateUserJwt(UserDefn userDefn) { var key = configuration.GetValue <string>("SecretKey"); var symmetricToken = new SymmetricSecurityKey(Encoding.UTF8.GetBytes(key)); var SigningCredentials = new SigningCredentials(symmetricToken, SecurityAlgorithms.HmacSha256Signature); var claims = new List <Claim>(); claims.Add(new Claim("UserName", userDefn.UserName)); claims.Add(new Claim("UserId", userDefn.Id.ToString())); claims.Add(new Claim("EmailId", userDefn.EmailId.ToString())); claims.Add(new Claim("MobileNumber", userDefn.MobileNumber)); var tokenDescriptor = new JwtSecurityToken( issuer: "StoreAdmin", audience: "StoreUser", signingCredentials: SigningCredentials, expires: DateTime.Now.AddHours(2), claims: claims ); var token = new JwtSecurityTokenHandler().WriteToken(tokenDescriptor); TokenDto returnToken = new TokenDto(); returnToken.token = token; return(returnToken); }
public void EditTask(int taskId, TaskDetails taskModel) { try { var user = (from u in _context.UserDefn where u.Email == taskModel.Email select u).FirstOrDefault(); if (user == null) { UserDefn newUser = new UserDefn { Email = taskModel.Email }; _context.UserDefn.Add(newUser); _context.SaveChanges(); } user = (from u in _context.UserDefn where u.Email == taskModel.Email select u).FirstOrDefault(); _context.Database.ExecuteSqlRaw("UPDATE Tasks SET TaskName = '" + taskModel.Name + "', TaskDescription='" + taskModel.Description + "', TaskDate='" + taskModel.Date + "', UserId='" + user.UserId + "' where TaskId='" + taskId + "'"); _context.SaveChanges(); } catch (Exception ex) { throw ex; } }
public string PostSignupDetails(SignupDetails signupDetails) { try { var result = (from r in appDbContext.UserDefn where (r.UserName == signupDetails.UserName && r.MobileNumber == signupDetails.MobileNumber) select r).ToList(); if (result.Count == 0) { var user = new UserDefn { UserName = signupDetails.UserName, MobileNumber = signupDetails.MobileNumber, Password = signupDetails.Password, EmailId = signupDetails.EmailId, RoleName = "User" }; appDbContext.UserDefn.Add(user); appDbContext.SaveChanges(); return("Posted"); } else { return("Failed"); } } catch (Exception ex) { throw ex; } }
public UserDefn UserLogin(UserDetails userDetails) { try { var results = (from u in _context.UserDefn where u.UserName == userDetails.UserName || u.Email == userDetails.Email select u).FirstOrDefault(); if (results == null) { var newUser = new UserDefn { UserName = userDetails.UserName, Email = userDetails.Email }; _context.UserDefn.Add(newUser); _context.SaveChanges(); } results = (from u in _context.UserDefn where u.UserName == null && u.Email == userDetails.Email select u).FirstOrDefault(); if (results != null) { _context.Database.ExecuteSqlRaw("UPDATE User_DEFN SET UserName = '******' WHERE Email = '" + userDetails.Email + "'"); _context.SaveChanges(); } var user = (from u in _context.UserDefn where u.Email == userDetails.Email select u).FirstOrDefault(); return(user); } catch (Exception ex) { throw ex; } }
public void AddTask(TaskDetails taskModel) { try { var user = (from u in _context.UserDefn where u.Email == taskModel.Email select u).FirstOrDefault(); if (user == null) { UserDefn newUser = new UserDefn { Email = taskModel.Email }; _context.UserDefn.Add(newUser); _context.SaveChanges(); } user = (from u in _context.UserDefn where u.Email == taskModel.Email select u).FirstOrDefault(); Tasks newTask = new Tasks { TaskName = taskModel.Name, TaskDescription = taskModel.Description, TaskDate = taskModel.Date, StatusId = 1, UserId = user.UserId }; _context.Tasks.Add(newTask); _context.SaveChanges(); } catch (Exception ex) { throw ex; } }