public void AddUserRequest(UserRequest userRequest)
{
using (KrisDbContext context = new KrisDbContext(csKris))
{
context.UserRequests.Add(userRequest);
context.SaveChanges();
}
}
public void AddMessage(ContactMessage message)
{
using (KrisDbContext context = new KrisDbContext(csKris))
{
context.ContactMessages.Add(message);
context.SaveChanges();
}
}
public void AddUser(User user)
{
using (KrisDbContext context = new KrisDbContext(csKris))
{
context.Users.Add(user);
context.SaveChanges();
}
}
public void EditAnswer(RekruAnswer answer)
{
using (KrisDbContext context = new KrisDbContext(csKris))
{
context.Entry<RekruAnswer>(answer).State = EntityState.Modified;
context.SaveChanges();
}
}
public void EditQuestion(RekruQuestion question)
{
using (KrisDbContext context = new KrisDbContext(csKris))
{
context.Entry<RekruQuestion>(question).State = EntityState.Modified;
context.SaveChanges();
}
}
public void AddQuestion(RekruQuestion question)
{
using (KrisDbContext context = new KrisDbContext(csKris))
{
context.RekruQuestions.Add(question);
context.SaveChanges();
}
}
public int DeleteAnswer(int answerID)
{
using (KrisDbContext context = new KrisDbContext(csKris))
{
context.Entry(new RekruAnswer { ID = answerID }).State = EntityState.Deleted;
return context.SaveChanges();
}
}
public void AddAnswer(RekruAnswer answer)
{
using (KrisDbContext context = new KrisDbContext(csKris))
{
context.Answers.Add(answer);
context.SaveChanges();
}
}
public void UpdatePageContent(PageContent pageContent)
{
using (KrisDbContext context = new KrisDbContext(csKris))
{
context.Entry(pageContent).State = EntityState.Modified;
context.SaveChanges();
}
}
public void Add(PageContent pageContent)
{
using (KrisDbContext context = new KrisDbContext(csKris))
{
context.PageContents.Add(pageContent);
context.SaveChanges();
}
}
/// <summary>
/// Adds article do DB
/// </summary>
public void AddArticle(Article article)
{
using (KrisDbContext context = new KrisDbContext(csKris))
{
context.Articles.Add(article);
context.SaveChanges();
}
}
/// <summary>
/// Updates given article
/// </summary>
public void UpdateArticle(Article article)
{
using (KrisDbContext context = new KrisDbContext(csKris))
{
//context.Articles.Attach(article);
context.Entry(article).State = EntityState.Modified;
context.SaveChanges();
}
}
public Result UpdateUserRequestToGhost(int id)
{
Result result = new Result();
using (KrisDbContext context = new KrisDbContext(csKris))
{
UserRequest req = context.UserRequests.Where(x => x.Id == id).FirstOrDefault();
if (req != null)
{
req.Ghost = true;
int rowsAffected = context.SaveChanges();
result.IsOK = true;
}
else
{
result.Message = $"User Request of ID = '{id}' not existing in DB.";
}
}
return(result);
}