protected void btnUpdate_Click(object sender, EventArgs e) { STD_ExamInfoDetail sTD_ExamInfoDetail = new STD_ExamInfoDetail (); sTD_ExamInfoDetail.ExamInfoDetailID= int.Parse(Request.QueryString["ID"].ToString()); sTD_ExamInfoDetail.ExamInfoID= int.Parse(ddlExamInfoID.SelectedValue); sTD_ExamInfoDetail.StudentID= ddlStudentID.SelectedValue; sTD_ExamInfoDetail.SubjectID= int.Parse(ddlSubjectID.SelectedValue); sTD_ExamInfoDetail.ExamStartTime= txtExamStartTime.Text; sTD_ExamInfoDetail.ExamDuration= int.Parse(txtExamDuration.Text); sTD_ExamInfoDetail.ExamDate= DateTime.Parse(txtExamDate.Text); sTD_ExamInfoDetail.ExamMarks= int.Parse(txtExamMarks.Text); sTD_ExamInfoDetail.ObtainMarks= decimal.Parse(txtObtainMarks.Text); sTD_ExamInfoDetail.ExtraField1= txtExtraField1.Text; sTD_ExamInfoDetail.ExtraField2= txtExtraField2.Text; sTD_ExamInfoDetail.ExtraField3= txtExtraField3.Text; sTD_ExamInfoDetail.ExtraField4= txtExtraField4.Text; sTD_ExamInfoDetail.ExtraField5= txtExtraField5.Text; sTD_ExamInfoDetail.AddedBy= "530038e1-cf38-4ddb-84a4-99b6974b4f9d"; sTD_ExamInfoDetail.AddedDate= DateTime.Now; sTD_ExamInfoDetail.UpdatedBy= "530038e1-cf38-4ddb-84a4-99b6974b4f9d"; sTD_ExamInfoDetail.UpdatedDate= DateTime.Now; sTD_ExamInfoDetail.RowStatusID= int.Parse(ddlRowStatusID.SelectedValue); bool resutl =STD_ExamInfoDetailManager.UpdateSTD_ExamInfoDetail(sTD_ExamInfoDetail); Response.Redirect("AdminDisplaySTD_ExamInfoDetail.aspx"); }
public static STD_ExamInfoDetail GetSTD_SubjectBySubjectID(int SubjectID) { STD_ExamInfoDetail sTD_ExamInfoDetail = new STD_ExamInfoDetail(); SqlSTD_ExamInfoDetailProvider sqlSTD_ExamInfoDetailProvider = new SqlSTD_ExamInfoDetailProvider(); sTD_ExamInfoDetail = sqlSTD_ExamInfoDetailProvider.GetSTD_ExamInfoDetailBySubjectID(SubjectID); return sTD_ExamInfoDetail; }
public static STD_ExamInfoDetail GetSTD_StudentByStudentID(string StudentID) { STD_ExamInfoDetail sTD_ExamInfoDetail = new STD_ExamInfoDetail(); SqlSTD_ExamInfoDetailProvider sqlSTD_ExamInfoDetailProvider = new SqlSTD_ExamInfoDetailProvider(); sTD_ExamInfoDetail = sqlSTD_ExamInfoDetailProvider.GetSTD_ExamInfoDetailByStudentID(StudentID); return sTD_ExamInfoDetail; }
public static STD_ExamInfoDetail GetSTD_RowStatusByRowStatusID(int RowStatusID) { STD_ExamInfoDetail sTD_ExamInfoDetail = new STD_ExamInfoDetail(); SqlSTD_ExamInfoDetailProvider sqlSTD_ExamInfoDetailProvider = new SqlSTD_ExamInfoDetailProvider(); sTD_ExamInfoDetail = sqlSTD_ExamInfoDetailProvider.GetSTD_ExamInfoDetailByRowStatusID(RowStatusID); return sTD_ExamInfoDetail; }
public static STD_ExamInfoDetail GetSTD_ExamInfoDetailByExamInfoDetailID(int ExamInfoDetailID) { STD_ExamInfoDetail sTD_ExamInfoDetail = new STD_ExamInfoDetail(); SqlSTD_ExamInfoDetailProvider sqlSTD_ExamInfoDetailProvider = new SqlSTD_ExamInfoDetailProvider(); sTD_ExamInfoDetail = sqlSTD_ExamInfoDetailProvider.GetSTD_ExamInfoDetailByExamInfoDetailID(ExamInfoDetailID); return sTD_ExamInfoDetail; }
public bool UpdateSTD_ExamInfoDetail(STD_ExamInfoDetail sTD_ExamInfoDetail) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateSTD_ExamInfoDetail", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ExamInfoDetailID", SqlDbType.Int).Value = sTD_ExamInfoDetail.ExamInfoDetailID; cmd.Parameters.Add("@ExamInfoID", SqlDbType.Int).Value = sTD_ExamInfoDetail.ExamInfoID; cmd.Parameters.Add("@StudentID", SqlDbType.NVarChar).Value = sTD_ExamInfoDetail.StudentID; cmd.Parameters.Add("@SubjectID", SqlDbType.Int).Value = sTD_ExamInfoDetail.SubjectID; cmd.Parameters.Add("@ExamStartTime", SqlDbType.NVarChar).Value = sTD_ExamInfoDetail.ExamStartTime; cmd.Parameters.Add("@ExamDuration", SqlDbType.Int).Value = sTD_ExamInfoDetail.ExamDuration; cmd.Parameters.Add("@ExamDate", SqlDbType.DateTime).Value = sTD_ExamInfoDetail.ExamDate; cmd.Parameters.Add("@ExamMarks", SqlDbType.Int).Value = sTD_ExamInfoDetail.ExamMarks; cmd.Parameters.Add("@ObtainMarks", SqlDbType.Float).Value = sTD_ExamInfoDetail.ObtainMarks; cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = sTD_ExamInfoDetail.ExtraField1; cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = sTD_ExamInfoDetail.ExtraField2; cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = sTD_ExamInfoDetail.ExtraField3; cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = sTD_ExamInfoDetail.ExtraField4; cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = sTD_ExamInfoDetail.ExtraField5; cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = sTD_ExamInfoDetail.UpdatedBy; cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = sTD_ExamInfoDetail.UpdatedDate; cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = sTD_ExamInfoDetail.RowStatusID; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public STD_ExamInfoDetail GetSTD_ExamInfoDetailFromReader(IDataReader reader) { try { STD_ExamInfoDetail sTD_ExamInfoDetail = new STD_ExamInfoDetail ( DataAccessObject.IsNULL<int>(reader["ExamInfoDetailID"]), DataAccessObject.IsNULL<int>(reader["ExamInfoID"]), DataAccessObject.IsNULL<string>(reader["StudentID"].ToString()), DataAccessObject.IsNULL<int>(reader["SubjectID"]), DataAccessObject.IsNULL<string>(reader["ExamStartTime"]), DataAccessObject.IsNULL<int>(reader["ExamDuration"]), DataAccessObject.IsNULL<DateTime>(reader["ExamDate"]), DataAccessObject.IsNULL<int>(reader["ExamMarks"]), DataAccessObject.IsNULL<float>(reader["ObtainMarks"]), DataAccessObject.IsNULL<string>(reader["ExtraField1"]), DataAccessObject.IsNULL<string>(reader["ExtraField2"]), DataAccessObject.IsNULL<string>(reader["ExtraField3"]), DataAccessObject.IsNULL<string>(reader["ExtraField4"]), DataAccessObject.IsNULL<string>(reader["ExtraField5"]), DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]), DataAccessObject.IsNULL<string>(reader["UpdatedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["UpdatedDate"]), DataAccessObject.IsNULL<int>(reader["RowStatusID"]) ); return sTD_ExamInfoDetail; } catch(Exception ex) { return null; } }
private void showSTD_ExamInfoDetailData() { STD_ExamInfoDetail sTD_ExamInfoDetail = new STD_ExamInfoDetail (); sTD_ExamInfoDetail = STD_ExamInfoDetailManager.GetSTD_ExamInfoDetailByExamInfoDetailID(Int32.Parse(Request.QueryString["ID"])); ddlExamInfoID.SelectedValue =sTD_ExamInfoDetail.ExamInfoID.ToString(); ddlStudentID.SelectedValue =sTD_ExamInfoDetail.StudentID.ToString(); ddlSubjectID.SelectedValue =sTD_ExamInfoDetail.SubjectID.ToString(); txtExamStartTime.Text =sTD_ExamInfoDetail.ExamStartTime.ToString(); txtExamDuration.Text =sTD_ExamInfoDetail.ExamDuration.ToString(); txtExamDate.Text =sTD_ExamInfoDetail.ExamDate.ToString(); txtExamMarks.Text =sTD_ExamInfoDetail.ExamMarks.ToString(); txtObtainMarks.Text =sTD_ExamInfoDetail.ObtainMarks.ToString(); txtExtraField1.Text =sTD_ExamInfoDetail.ExtraField1.ToString(); txtExtraField2.Text =sTD_ExamInfoDetail.ExtraField2.ToString(); txtExtraField3.Text =sTD_ExamInfoDetail.ExtraField3.ToString(); txtExtraField4.Text =sTD_ExamInfoDetail.ExtraField4.ToString(); txtExtraField5.Text =sTD_ExamInfoDetail.ExtraField5.ToString(); ddlRowStatusID.SelectedValue =sTD_ExamInfoDetail.RowStatusID.ToString(); }
public static int InsertSTD_ExamInfoDetail(STD_ExamInfoDetail sTD_ExamInfoDetail) { SqlSTD_ExamInfoDetailProvider sqlSTD_ExamInfoDetailProvider = new SqlSTD_ExamInfoDetailProvider(); return sqlSTD_ExamInfoDetailProvider.InsertSTD_ExamInfoDetail(sTD_ExamInfoDetail); }
public static bool UpdateSTD_ExamInfoDetail(STD_ExamInfoDetail sTD_ExamInfoDetail) { SqlSTD_ExamInfoDetailProvider sqlSTD_ExamInfoDetailProvider = new SqlSTD_ExamInfoDetailProvider(); return sqlSTD_ExamInfoDetailProvider.UpdateSTD_ExamInfoDetail(sTD_ExamInfoDetail); }