public static MessageResult createEvalResult(EvalResults evalResults)
{
MessageResult messageResult = new MessageResult();
try
{
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
builder.DataSource = DBControl.DataSource;
builder.UserID = DBControl.UserID;
builder.Password = DBControl.Password;
builder.InitialCatalog = DBControl.InitialCatalog;
using (SqlConnection connection = new SqlConnection(builder.ConnectionString))
{
connection.Open();
SqlCommand command;
SqlDataAdapter adapter = new SqlDataAdapter();
String sql = "";
sql = String.Format("INSERT INTO EvalResult_01 (Username, EvalDate, ANS_1B, ANS_1B_OTHER, ANS_04U1, ANS_04U2, ANS_04U3, ANS_04U4, ANS_11, ANS_12) VALUES(N'{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}'); ",
evalResults.username, evalResults.evalDate.ToString("MM/dd/yyyy hh:mm:ss"), evalResults.ans_1b, evalResults.ans_1b_oth, evalResults.ans_04u1, evalResults.ans_04u2, evalResults.ans_04u3, evalResults.ans_04u4, evalResults.ans_11, evalResults.ans_12);
command = new SqlCommand(sql, connection);
adapter.UpdateCommand = new SqlCommand(sql, connection);
adapter.UpdateCommand.ExecuteNonQuery();
command.Dispose();
connection.Close();
messageResult.ErrorCode = ErrorCode.S;
messageResult.Message = "บันทึกข้อมูลสำเร็จ";
}
}
catch (SqlException e2)
{
messageResult.ErrorCode = ErrorCode.E;
messageResult.Message = "เกิดข้อผิดพลาด! กรุณาติดต่อผู้ดูแลระบบ";
}
return(messageResult);
}
public static EvalResults getEval(string userSearch)
{
EvalResults evalResults = new EvalResults();
if (userSearch == "")
{
return(evalResults);
}
try
{
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
builder.DataSource = DBControl.DataSource;
builder.UserID = DBControl.UserID;
builder.Password = DBControl.Password;
builder.InitialCatalog = DBControl.InitialCatalog;
using (SqlConnection connection = new SqlConnection(builder.ConnectionString))
{
connection.Open();
StringBuilder sb = new StringBuilder();
sb.Append(String.Format("SELECT TOP 1 * FROM dbo.EvalResult_01 WHERE Username = '******' ORDER BY EvalDate DESC;", userSearch));
String sql = sb.ToString();
using (SqlCommand command = new SqlCommand(sql, connection))
{
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
string ans_04u1, ans_04u2, ans_04u3, ans_04u4;
ans_04u1 = reader["ANS_04U1"].ToString();
ans_04u2 = reader["ANS_04U2"].ToString();
ans_04u3 = reader["ANS_04U3"].ToString();
ans_04u4 = reader["ANS_04U4"].ToString();
evalResults.username = reader["Username"].ToString();
evalResults.evalDate = Convert.ToDateTime(reader["EvalDate"].ToString());
evalResults.ans_04u1_01 = ans_04u1[0].ToString();
evalResults.ans_04u1_02 = ans_04u1[1].ToString();
evalResults.ans_04u1_03 = ans_04u1[2].ToString();
evalResults.ans_04u1_04 = ans_04u1[3].ToString();
evalResults.ans_04u1_05 = ans_04u1[4].ToString();
evalResults.ans_04u1_06 = ans_04u1[5].ToString();
evalResults.ans_04u1_07 = ans_04u1[6].ToString();
evalResults.ans_04u1_08 = ans_04u1[7].ToString();
evalResults.ans_04u1_09 = ans_04u1[8].ToString();
evalResults.ans_04u1_10 = ans_04u1[9].ToString();
evalResults.ans_04u1_11 = ans_04u1[10].ToString();
evalResults.ans_04u1_12 = ans_04u1[11].ToString();
evalResults.ans_04u1_13 = ans_04u1[12].ToString();
evalResults.ans_04u1_14 = ans_04u1[13].ToString();
evalResults.ans_04u1_15 = ans_04u1[14].ToString();
evalResults.ans_04u1_16 = ans_04u1[15].ToString();
evalResults.ans_04u1_17 = ans_04u1[16].ToString();
evalResults.ans_04u1_18 = ans_04u1[17].ToString();
evalResults.ans_04u1_19 = ans_04u1[18].ToString();
evalResults.ans_04u1_20 = ans_04u1[19].ToString();
evalResults.ans_04u2_01 = ans_04u2[0].ToString();
evalResults.ans_04u2_02 = ans_04u2[1].ToString();
evalResults.ans_04u2_03 = ans_04u2[2].ToString();
evalResults.ans_04u2_04 = ans_04u2[3].ToString();
evalResults.ans_04u2_05 = ans_04u2[4].ToString();
evalResults.ans_04u2_06 = ans_04u2[5].ToString();
evalResults.ans_04u3_01 = ans_04u3[0].ToString();
evalResults.ans_04u3_02 = ans_04u3[1].ToString();
evalResults.ans_04u3_03 = ans_04u3[2].ToString();
evalResults.ans_04u3_04 = ans_04u3[3].ToString();
evalResults.ans_04u3_05 = ans_04u3[4].ToString();
evalResults.ans_04u3_06 = ans_04u3[5].ToString();
evalResults.ans_04u3_07 = ans_04u3[6].ToString();
evalResults.ans_04u4_01 = ans_04u4[0].ToString();
evalResults.ans_04u4_02 = ans_04u4[1].ToString();
evalResults.ans_04u4_03 = ans_04u4[2].ToString();
evalResults.ans_04u4_04 = ans_04u4[3].ToString();
evalResults.ans_04u4_05 = ans_04u4[4].ToString();
evalResults.ans_04u4_06 = ans_04u4[5].ToString();
evalResults.ans_04u4_07 = ans_04u4[6].ToString();
evalResults.ans_04u4_08 = ans_04u4[7].ToString();
evalResults.ans_04u4_09 = ans_04u4[8].ToString();
evalResults.ans_04u4_10 = ans_04u4[9].ToString();
evalResults.ans_04u4_11 = ans_04u4[10].ToString();
evalResults.ans_04u4_12 = ans_04u4[11].ToString();
evalResults.ans_04u4_13 = ans_04u4[12].ToString();
evalResults.ans_04u4_14 = ans_04u4[13].ToString();
evalResults.ans_04u4_15 = ans_04u4[14].ToString();
}
}
}
}
}
catch (SqlException e2)
{
}
return(evalResults);
}