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