/// <summary>
/// Function to generate unique token with expiry against the provided userId.
/// Also add a record in database for generated token.
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public Token GenerateToken(int userId)
{
using (var _context = new AskUsDbContext())
{
string token = Guid.NewGuid().ToString();
DateTime issuedOn = DateTime.Now;
DateTime expiredOn = DateTime.Now.AddSeconds(3000);//(Convert.ToDouble(ConfigurationManager.AppSettings["AuthTokenExpiry"]));
var tokendomain = new Token
{
UserId = userId,
AuthToken = token,
IssuedOn = issuedOn,
ExpiresOn = expiredOn
};
List <Token> tokens = _context.Tokens.Where(x => x.UserId == userId).ToList();
foreach (Token t in tokens)
{
_context.Tokens.Remove(t);
}
_context.Tokens.Add(tokendomain);
_context.SaveChanges();
return(tokendomain);
}
}
public void AddQuestionAnswer(QuestionAnswer questoinAnswer)
{
using (var _context = new AskUsDbContext())
{
_context.QuestionAnswers.Add(questoinAnswer);
_context.SaveChanges();
}
}
public void AddServiceLocation(ServiceLocation serviceLocation)
{
using (var _context = new AskUsDbContext())
{
_context.ServiceLocations.Add(serviceLocation);
_context.SaveChanges();
}
}
public List <ServiceLocation> GetAllLocation()
{
using (var _context = new AskUsDbContext())
{
List <ServiceLocation> SList = _context.ServiceLocations.ToList();
return(SList);
}
}
public Customer GetCustomer(int _customerId)
{
using (var _context = new AskUsDbContext())
{
Customer _customer = _context.Customers.Where(x => x.Id == _customerId).FirstOrDefault();
return(_customer);
}
}
public void AddQuestionCategory(QuestionsCategory category)
{
using (var _context = new AskUsDbContext())
{
_context.QuestionsCategories.Add(category);
_context.SaveChanges();
}
}
public void UpdateUserRole(UserRole userRole)
{
using (var _context = new AskUsDbContext())
{
_context.Entry(userRole).State = System.Data.Entity.EntityState.Modified;
_context.SaveChanges();
}
}
public UserRole GetUserRoleById(int id)
{
using (var _context = new AskUsDbContext())
{
UserRole role = _context.UserRoles.Where(x => x.Id == id).FirstOrDefault();
return(role);
}
}
public List <User> GetAllUsers()
{
using (var _context = new AskUsDbContext())
{
List <User> userList = _context.Users.ToList();
return(userList);
}
}
public void UpdateQuestion(Question question)
{
using (var _context = new AskUsDbContext())
{
_context.Entry(question).State = EntityState.Modified;
_context.SaveChanges();
}
}
public Question GetQuestionById(long id)
{
using (var _context = new AskUsDbContext())
{
Question q = _context.Questions.Where(x => x.Id == id).FirstOrDefault();
return(q);
}
}
public void AddQuestion(Question question)
{
using (var _context = new AskUsDbContext())
{
_context.Questions.Add(question);
_context.SaveChanges();
}
}
public void UpdateQuestionAnswer(QuestionAnswer questionAnswer)
{
using (var _context = new AskUsDbContext())
{
_context.Entry(questionAnswer).State = System.Data.Entity.EntityState.Modified;
_context.SaveChanges();
}
}
public QuestionAnswer GetQuestionAnswerById(int id)
{
using (var _context = new AskUsDbContext())
{
QuestionAnswer questionAnswer = _context.QuestionAnswers.Where(x => x.Id == id).FirstOrDefault();
return(questionAnswer);
}
}
public void UpdateServiceLocation(ServiceLocation serviceLocation)
{
using (var _context = new AskUsDbContext())
{
_context.Entry(serviceLocation).State = System.Data.Entity.EntityState.Modified;
_context.SaveChanges();
}
}
public void AddUsers(User user)
{
using (var _context = new AskUsDbContext())
{
_context.Users.Add(user);
_context.SaveChanges();
}
}
public void AddUserRole(UserRole role)
{
using (var _context = new AskUsDbContext())
{
UserRole userRole = _context.UserRoles.Add(role);
_context.SaveChanges();
}
}
public User GetUserById(int id)
{
using (var _context = new AskUsDbContext())
{
User user = _context.Users.Where(x => x.Id == id).FirstOrDefault();
return(user);
}
}
public List <UserRole> GetAllUserRoles()
{
using (var _context = new AskUsDbContext())
{
List <UserRole> usersRole = _context.UserRoles.ToList();
return(usersRole);
}
}
public User Login(string _emailid, string _password)
{
using (var _context = new AskUsDbContext())
{
User user = _context.Users.Where(x => x.Email == _emailid && x.Password == _password).FirstOrDefault();
return(user);
}
}
public List <QuestionsCategory> GetAllCategory()
{
using (var _context = new AskUsDbContext())
{
List <QuestionsCategory> list = _context.QuestionsCategories.ToList();
return(list);
}
}
public ServiceLocation GetServiceLocationById(int id)
{
using (var _context = new AskUsDbContext())
{
ServiceLocation serviceLocation = _context.ServiceLocations.Where(x => x.Id == id).FirstOrDefault();
return(serviceLocation);
}
}
public void UpdateAnswerReview(AnswerReview answerReview)
{
using (var _context = new AskUsDbContext())
{
_context.Entry(answerReview).State = EntityState.Modified;
_context.SaveChanges();
}
}
public void AddAnswerReview(AnswerReview answerReview)
{
using (var _context = new AskUsDbContext())
{
_context.AnswerReviews.Add(answerReview);
_context.SaveChanges();
}
}
public List <QuestionAnswer> GetAllQuestionAnswer()
{
using (var _context = new AskUsDbContext())
{
List <QuestionAnswer> QList = _context.QuestionAnswers.ToList();
return(QList);
}
}
public AnswerReview GetAnswerReviewById(int id)
{
using (var _context = new AskUsDbContext())
{
AnswerReview answerReview = _context.AnswerReviews.Where(x => x.Id == id).FirstOrDefault();
return(answerReview);
}
}
public List <AnswerReview> GetAllAnswerReview()
{
using (var _context = new AskUsDbContext())
{
List <AnswerReview> Alist = _context.AnswerReviews.ToList();
return(Alist);
}
}
public void DeleteQuestoinsCategory(QuestionsCategory category)
{
using (var _context = new AskUsDbContext())
{
_context.QuestionsCategories.Remove(category);
_context.SaveChanges();
}
}
public void UpdateQuestionsCategory(QuestionsCategory category)
{
using (var _context = new AskUsDbContext())
{
_context.Entry(category).State = System.Data.Entity.EntityState.Modified;
_context.SaveChanges();
}
}
public QuestionsCategory GetCategoryById(int id)
{
using (var _context = new AskUsDbContext())
{
QuestionsCategory Qcategory = _context.QuestionsCategories.Where(x => x.Id == id).FirstOrDefault();
return(Qcategory);
}
}
