public async Task <HttpResponseMessage> QueryOneUserDailyQuestions(SearchModel varSearchModel)
{
Thread.CurrentThread.CurrentCulture = culture;
string userid = varSearchModel.parameters[0].Trim();
string datelocal = varSearchModel.parameters[1].Trim();
DateTime datelocalParse = Convert.ToDateTime(datelocal);
QueryUserDailyQuestionsModel dailyQuestion = new QueryUserDailyQuestionsModel();
try
{
using (SqlConnection connection1 = new SqlConnection(connetionString))
{
await connection1.OpenAsync();
SqlCommand command1 = new SqlCommand("SELECT " +
"d.userid, d.datelocal, d.sleeping, d.moodlike, d.sore, d.nutrition " +
"from DailyQuestions d " +
"where d.userid = @userid and d.datelocal = @datelocal", connection1);
SqlParameter parameter = new SqlParameter("@userid", SqlDbType.VarChar);
parameter.Value = userid;
command1.Parameters.Add(parameter);
parameter = new SqlParameter("@datelocal", SqlDbType.Date);
parameter.Value = datelocalParse.Date;
command1.Parameters.Add(parameter);
SqlDataReader reader = await command1.ExecuteReaderAsync();
while (await reader.ReadAsync())
{
dailyQuestion.userid = reader.GetString(0);
dailyQuestion.datelocal = reader.GetDateTime(1);
dailyQuestion.sleeping = reader.GetInt32(2);
dailyQuestion.moodlike = reader.GetInt32(3);
dailyQuestion.sore = reader.GetInt32(4);
dailyQuestion.nutrition = reader.GetInt32(5);
}
reader.Close();
}
}
catch (ApplicationException ex)
{
ErrorModel _errors = new ErrorModel();
_errors.message = ex.Message;
return(Request.CreateResponse(System.Net.HttpStatusCode.InternalServerError, _errors));
}
catch (Exception ex)
{
ErrorModel _errors = new ErrorModel();
_errors.message = ex.Message;
return(Request.CreateResponse(System.Net.HttpStatusCode.InternalServerError, _errors));
}
return(Request.CreateResponse(System.Net.HttpStatusCode.OK, dailyQuestion));
}
public async Task <HttpResponseMessage> AddUpdate(QueryUserDailyQuestionsModel model)
{
Thread.CurrentThread.CurrentCulture = culture;
try
{
model.datelocal = DateTime.Parse(model.datelocalN);
using (TransactionScope scope = new TransactionScope(TransactionScopeAsyncFlowOption.Enabled))
{
using (SqlConnection connection1 = new SqlConnection(connetionString))
{
await connection1.OpenAsync();
string commandText1 = "";
if (model.transactionType == 1)
{
commandText1 = "INSERT INTO DailyQuestions " +
"(userid, datelocal, dateserver, sleeping, moodlike, sore, nutrition) " +
"values (@userid, @datelocal, getdate(), @sleeping, @moodlike, @sore, @nutrition )";
}
else if (model.transactionType == 2)
{
commandText1 = "UPDATE DailyQuestions SET sleeping = @sleeping, moodlike = @moodlike, sore = @sore, nutrition = @nutrition " +
"WHERE userid = @userid AND datelocal = @datelocal";
}
SqlCommand command1 = new SqlCommand(commandText1, connection1);
SqlParameter parameter = new SqlParameter("@userid", SqlDbType.VarChar);
parameter.Value = model.userid;
command1.Parameters.Add(parameter);
parameter = new SqlParameter("@datelocal", SqlDbType.Date);
parameter.Value = model.datelocal;
command1.Parameters.Add(parameter);
parameter = new SqlParameter("@sleeping", SqlDbType.Int);
parameter.Value = model.sleeping;
command1.Parameters.Add(parameter);
parameter = new SqlParameter("@moodlike", SqlDbType.Int);
parameter.Value = model.moodlike;
command1.Parameters.Add(parameter);
parameter = new SqlParameter("@sore", SqlDbType.Int);
parameter.Value = model.sore;
command1.Parameters.Add(parameter);
parameter = new SqlParameter("@nutrition", SqlDbType.Int);
parameter.Value = model.nutrition;
command1.Parameters.Add(parameter);
await command1.ExecuteNonQueryAsync();
}
scope.Complete();
}
}
catch (TransactionAbortedException ex)
{
ErrorModel _errors = new ErrorModel();
_errors.message = ex.Message;
return(Request.CreateResponse(System.Net.HttpStatusCode.InternalServerError, _errors));
}
catch (ApplicationException ex)
{
ErrorModel _errors = new ErrorModel();
_errors.message = ex.Message;
return(Request.CreateResponse(System.Net.HttpStatusCode.InternalServerError, _errors));
}
catch (Exception ex)
{
ErrorModel _errors = new ErrorModel();
_errors.message = ex.Message;
return(Request.CreateResponse(System.Net.HttpStatusCode.InternalServerError, _errors));
}
return(Request.CreateResponse(System.Net.HttpStatusCode.OK));
}
