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); }