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