public static void Create(string username, string detail, int questionID)
{
IDbConnection db = new SqlConnection(server);
Answers answers = new Answers()
{
Username = username,
Detail = detail,
QuestionID = questionID,
Posted = DateTime.Now.ToString(),
UpVotes = 0
};
db.Insert(answers);
}
public static void Create(string username, string detail, int questionID)
{
IDbConnection db = new SqlConnection(server);
Answers answers = new Answers()
{
Username = username,
Detail = detail,
QuestionID = questionID,
Posted = DateTime.Now.ToString(),
UpVotes = 0
};
db.Query($"Insert Into Answers (Username, Detail, QuestionID, Posted, UpVotes) Values ('{username}', '{detail}', '{questionID}', '{answers.Posted}', '0')");
//db.Insert(answers);
}
public static void Update(Answers answers, string detail)
{
IDbConnection db = new SqlConnection(server);
answers.Detail = detail;
/*
* Answers answers = new Answers()
* {
* Detail = detail,
* ID = answerID,
* Posted = DateTime.Now.ToString()
* };
*/
db.Update(answers);
}
public static void Update(Answers answers, string detail)
{
IDbConnection db = new SqlConnection(server);
answers.Detail = detail;
/*
* Answers answers = new Answers()
* {
* Detail = detail,
* ID = answerID,
* Posted = DateTime.Now.ToString()
* };
*/
//db.Update(answers);
db.Query($"Update Answers SET Detail='{answers.Detail}' where ID='{answers.ID}'");
}