public bool CreateRequest(Request request)
{
var newRequest = new Requests
{
SenderFirstName = request.senderFirstName,
SenderLastName = request.senderLastName,
SenderEmail = request.senderEmail,
Subject = request.subject,
Question = request.question,
Date = request.date,
Answered = request.answered
};
try
{
// save request
db.Requests.Add(newRequest);
db.SaveChanges();
}
catch (Exception e)
{
writeToLog(e);
return false;
}
return true;
}
public bool UpdateRequest(int id, Request request)
{
Requests foundRequest = db.Requests.FirstOrDefault(r => r.ID == id);
if (foundRequest == null)
return false;
foundRequest.SenderFirstName = request.senderFirstName;
foundRequest.SenderLastName = request.senderLastName;
foundRequest.SenderEmail = request.senderEmail;
foundRequest.Subject = request.subject;
foundRequest.Question = request.question;
foundRequest.Date = request.date;
foundRequest.Answered = request.answered;
try
{
db.SaveChanges();
}
catch (Exception e)
{
writeToLog(e);
return false;
}
return true;
}
public Request GetRequest(int id)
{
try
{
Requests oneDbRequest = db.Requests.Find(id);
if (oneDbRequest == null)
return null;
var oneRequest = new Request()
{
id = oneDbRequest.ID,
senderFirstName = oneDbRequest.SenderFirstName,
senderLastName = oneDbRequest.SenderLastName,
senderEmail = oneDbRequest.SenderEmail,
subject = oneDbRequest.Subject,
question = oneDbRequest.Question,
date = oneDbRequest.Date,
answered = oneDbRequest.Answered
};
return oneRequest;
}
catch (Exception e)
{
writeToLog(e);
return null;
}
}