public void AddSalaryQA(SalaryQA salaryQA) { try { string commandString = "INSERT INTO usta_salaryQA(userId, salaryId, qaContent, salaryType, createdTime) Values(@userId, @salaryId, @qaContent, @salaryType, @createdTime)"; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@userId", salaryQA.teacher.teacherNo), new SqlParameter("@salaryId", salaryQA.salaryId), new SqlParameter("@qaContent", salaryQA.qaContent), new SqlParameter("@salaryType", salaryQA.salaryType), new SqlParameter("@createdTime", DateTime.Now) }; SqlHelper.ExecuteNonQuery(conn, CommandType.Text, commandString, parameters); } catch (Exception ex) { MongoDBLog.LogRecord(ex); CommonUtility.RedirectUrl(); } finally { conn.Close(); } }
protected void TeacherSalaryQA_Click(object sender, EventArgs e) { SalaryQA salaryQa = new SalaryQA(); salaryQa.qaContent = this.newTeacherSalaryQA.Text.Trim(); salaryQa.salaryId = int.Parse(this.hf_SalaryId.Value.Trim()); salaryQa.salaryType = int.Parse(this.hf_SalaryType.Value.Trim()); TeachersList teacher = new TeachersList(); UserCookiesInfo userCookiesInfo = BllOperationAboutUser.GetUserCookiesInfo(); teacher.teacherNo = userCookiesInfo.userNo; salaryQa.teacher = teacher; DalOperationAboutSalaryQA dalqa = new DalOperationAboutSalaryQA(); dalqa.AddSalaryQA(salaryQa); Javascript.JavaScriptLocationHref("/Teacher/TeacherSalaryQA.aspx?salaryType=" + salaryQa.salaryType + "&salaryId=" + salaryQa.salaryId, Page); }
private List<SalaryQA> BuildSalaryQA(SqlDataReader reader, List<SalaryQA> salaryQAs) { SalaryQA salaryQA; while (reader.Read()) { salaryQA = new SalaryQA(); salaryQA.salaryQaId = int.Parse(reader["salaryqaId"].ToString().Trim()); TeachersList teacher = new TeachersList(); teacher.teacherNo = reader["userId"].ToString().Trim(); teacher.teacherName = reader["teacherName"].ToString().Trim(); salaryQA.teacher = teacher; salaryQA.salaryId = int.Parse(reader["salaryId"].ToString().Trim()); salaryQA.qaContent = reader["qaContent"].ToString().Trim(); salaryQA.salaryType = int.Parse(reader["salaryType"].ToString().Trim()); salaryQA.createdTime = DateTime.Parse(reader["createdTime"].ToString().Trim()); salaryQAs.Add(salaryQA); } return salaryQAs; }