internal (int?, HttpStatusCode) WriteRTVote(RTVoteModel rTVote)
{
try
{
string sql = @"INSERT INTO rtvotes(title, firstContent, secondContent, startDatetime, endDatetime, createDatetime) " +
"VALUES(@title, @firstContent, @secondContent,@startDatetime, @endDatetime, @createDatetime) " +
"RETURNING idx";
using (var db = new MySqlHelper())
{
return(db.QuerySingle <int>(sql, new { title = rTVote.Title, firstContent = rTVote.FirstContent,
secondContent = rTVote.SecondContent, startDatetime = MysqlFormatHelper.ConvertDatetime(rTVote.StartDatetime),
endDatetime = MysqlFormatHelper.ConvertDatetime(rTVote.EndDatetime),
createDatetime = MysqlFormatHelper.ConvertDatetime(rTVote.CreateDatetime) }), HttpStatusCode.OK);
}
}
catch
{
return(null, HttpStatusCode.InternalServerError);
}
}
internal (int?, HttpStatusCode) WriteSurvey(SurveyEntity survey)
{
try
{
DynamicParameters param = new DynamicParameters();
string sql = "insert into surveys (title, creatorIdx, createDatetime, startDatetime, endDatetime)" +
$"values (@title, @creatorIdx, @createDatetime, @startDatetime, @endDatetime); select LAST_INSERT_ID();";
param.Add("@title", survey.Title);
param.Add("@creatorIdx", survey.CreatorIdx);
param.Add("@createDatetime", MysqlFormatHelper.ConvertDatetime(survey.CreateDatetime));
param.Add("@startDatetime", MysqlFormatHelper.ConvertDatetime(survey.StartDatetime));
param.Add("@endDatetime", MysqlFormatHelper.ConvertDatetime(survey.EndDatetime));
using (var db = new MySqlHelper())
{
return(db.QuerySingle <int>(sql, param), HttpStatusCode.OK);
}
}
catch
{
return(null, HttpStatusCode.InternalServerError);
}
}