public static Quiz_Chapter GetQuiz_SubjectBySubjectID(int SubjectID) { Quiz_Chapter quiz_Chapter = new Quiz_Chapter(); SqlQuiz_ChapterProvider sqlQuiz_ChapterProvider = new SqlQuiz_ChapterProvider(); quiz_Chapter = sqlQuiz_ChapterProvider.GetQuiz_ChapterBySubjectID(SubjectID); return quiz_Chapter; }
public static Quiz_Chapter GetQuiz_CourseByCourseID(int CourseID) { Quiz_Chapter quiz_Chapter = new Quiz_Chapter(); SqlQuiz_ChapterProvider sqlQuiz_ChapterProvider = new SqlQuiz_ChapterProvider(); quiz_Chapter = sqlQuiz_ChapterProvider.GetQuiz_ChapterByCourseID(CourseID); return quiz_Chapter; }
protected void btnUpdate_Click(object sender, EventArgs e) { Quiz_Chapter quiz_Chapter = new Quiz_Chapter (); quiz_Chapter.ChapterID= int.Parse(Request.QueryString["ID"].ToString()); quiz_Chapter.SubjectID= int.Parse(ddlSubjectID.SelectedValue); quiz_Chapter.CourseID= int.Parse(ddlCourseID.SelectedValue); quiz_Chapter.ChapterName= txtChapterName.Text; quiz_Chapter.AddedBy= Profile.card_id; quiz_Chapter.AddedDate= DateTime.Now; quiz_Chapter.ModifiedBy= Profile.card_id; quiz_Chapter.ModifiedDate= DateTime.Now; bool resutl =Quiz_ChapterManager.UpdateQuiz_Chapter(quiz_Chapter); Response.Redirect("AdminDisplayQuiz_Chapter.aspx"); }
protected void btnAdd_Click(object sender, EventArgs e) { Quiz_Chapter quiz_Chapter = new Quiz_Chapter (); // quiz_Chapter.ChapterID= int.Parse(ddlChapterID.SelectedValue); quiz_Chapter.SubjectID= int.Parse(ddlSubjectID.SelectedValue); quiz_Chapter.CourseID= int.Parse(ddlCourseID.SelectedValue); quiz_Chapter.ChapterName= txtChapterName.Text; quiz_Chapter.AddedBy= Profile.card_id; quiz_Chapter.AddedDate= DateTime.Now; quiz_Chapter.ModifiedBy= Profile.card_id; quiz_Chapter.ModifiedDate= DateTime.Now; int resutl =Quiz_ChapterManager.InsertQuiz_Chapter(quiz_Chapter); Response.Redirect("AdminDisplayQuiz_Chapter.aspx"); }
private void showQuiz_ChapterData() { try { Quiz_Chapter quiz_Chapter = new Quiz_Chapter(); quiz_Chapter = Quiz_ChapterManager.GetQuiz_ChapterByChapterID(Int32.Parse(Request.QueryString["ID"])); ddlCourseID.SelectedValue = quiz_Chapter.CourseID.ToString(); _loadSubject(quiz_Chapter.CourseID); ddlSubjectID.SelectedValue = quiz_Chapter.SubjectID.ToString(); txtChapterName.Text = quiz_Chapter.ChapterName.ToString(); } catch (Exception ex) { } }
public bool UpdateQuiz_Chapter(Quiz_Chapter quiz_Chapter) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateQuiz_Chapter", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ChapterID", SqlDbType.Int).Value = quiz_Chapter.ChapterID; cmd.Parameters.Add("@SubjectID", SqlDbType.Int).Value = quiz_Chapter.SubjectID; cmd.Parameters.Add("@CourseID", SqlDbType.Int).Value = quiz_Chapter.CourseID; cmd.Parameters.Add("@ChapterName", SqlDbType.NVarChar).Value = quiz_Chapter.ChapterName; cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = quiz_Chapter.ModifiedBy; cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = quiz_Chapter.ModifiedDate; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public Quiz_Chapter GetQuiz_ChapterFromReader(IDataReader reader) { try { Quiz_Chapter quiz_Chapter = new Quiz_Chapter ( DataAccessObject.IsNULL<int>(reader["ChapterID"]), DataAccessObject.IsNULL<int>(reader["SubjectID"]), DataAccessObject.IsNULL<int>(reader["CourseID"]), DataAccessObject.IsNULL<string>(reader["ChapterName"]), DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]), DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"]) ); return quiz_Chapter; } catch(Exception ex) { return null; } }
public static int InsertQuiz_Chapter(Quiz_Chapter quiz_Chapter) { SqlQuiz_ChapterProvider sqlQuiz_ChapterProvider = new SqlQuiz_ChapterProvider(); return sqlQuiz_ChapterProvider.InsertQuiz_Chapter(quiz_Chapter); }
public static bool UpdateQuiz_Chapter(Quiz_Chapter quiz_Chapter) { SqlQuiz_ChapterProvider sqlQuiz_ChapterProvider = new SqlQuiz_ChapterProvider(); return sqlQuiz_ChapterProvider.UpdateQuiz_Chapter(quiz_Chapter); }