private void showSTD_ExamStudentData() { STD_ExamStudent sTD_ExamStudent = new STD_ExamStudent (); sTD_ExamStudent = STD_ExamStudentManager.GetSTD_ExamStudentByExamStudentID(Int32.Parse(Request.QueryString["ID"])); txtExamStudent.Text =sTD_ExamStudent.ExamStudent.ToString(); ddlExamID.SelectedValue =sTD_ExamStudent.ExamID.ToString(); ddlStudentID.SelectedValue =sTD_ExamStudent.StudentID.ToString(); txtObtainedMark.Text =sTD_ExamStudent.ObtainedMark.ToString(); }
protected void btnUpdate_Click(object sender, EventArgs e) { STD_ExamStudent sTD_ExamStudent = new STD_ExamStudent (); sTD_ExamStudent.ExamStudentID= int.Parse(Request.QueryString["ID"].ToString()); sTD_ExamStudent.ExamStudent= txtExamStudent.Text; sTD_ExamStudent.ExamID= int.Parse(ddlExamID.SelectedValue); sTD_ExamStudent.StudentID= ddlStudentID.SelectedValue; sTD_ExamStudent.ObtainedMark= decimal.Parse(txtObtainedMark.Text); sTD_ExamStudent.AddedBy= "530038e1-cf38-4ddb-84a4-99b6974b4f9d"; sTD_ExamStudent.AddedDate= DateTime.Now; sTD_ExamStudent.UpdatedBy= "530038e1-cf38-4ddb-84a4-99b6974b4f9d"; sTD_ExamStudent.UpdateDate= DateTime.Now; bool resutl =STD_ExamStudentManager.UpdateSTD_ExamStudent(sTD_ExamStudent); Response.Redirect("AdminDisplaySTD_ExamStudent.aspx"); }
public bool UpdateSTD_ExamStudent(STD_ExamStudent sTD_ExamStudent) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateSTD_ExamStudent", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ExamStudentID", SqlDbType.Int).Value = sTD_ExamStudent.ExamStudentID; cmd.Parameters.Add("@ExamStudent", SqlDbType.NVarChar).Value = sTD_ExamStudent.ExamStudent; cmd.Parameters.Add("@ExamID", SqlDbType.Int).Value = sTD_ExamStudent.ExamID; cmd.Parameters.Add("@StudentID", SqlDbType.NVarChar).Value = sTD_ExamStudent.StudentID; cmd.Parameters.Add("@ObtainedMark", SqlDbType.Decimal).Value = sTD_ExamStudent.ObtainedMark; //cmd.Parameters.Add("@ObtainedMark", SqlDbType.Decimal).Value = sTD_ExamStudent.ObtainedMark; //cmd.Parameters.Add("@ObtainedMark", SqlDbType.Decimal).Value = sTD_ExamStudent.ObtainedMark; cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = sTD_ExamStudent.UpdatedBy; cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = sTD_ExamStudent.UpdateDate; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public STD_ExamStudent GetSTD_ExamStudentFromReader(IDataReader reader) { try { STD_ExamStudent sTD_ExamStudent = new STD_ExamStudent ( DataAccessObject.IsNULL<int>(reader["ExamStudentID"]), DataAccessObject.IsNULL<string>(reader["ExamStudent"]), DataAccessObject.IsNULL<int>(reader["ExamID"]), DataAccessObject.IsNULL<string>(reader["StudentID"].ToString()), DataAccessObject.IsNULL<decimal>(reader["ObtainedMark"]), DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]), DataAccessObject.IsNULL<string>(reader["UpdatedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["UpdateDate"]) ); return sTD_ExamStudent; } catch(Exception ex) { return null; } }