public static STD_ExamInfo GetSTD_RowStatusByRowStatusID(int RowStatusID) { STD_ExamInfo sTD_ExamInfo = new STD_ExamInfo(); SqlSTD_ExamInfoProvider sqlSTD_ExamInfoProvider = new SqlSTD_ExamInfoProvider(); sTD_ExamInfo = sqlSTD_ExamInfoProvider.GetSTD_ExamInfoByRowStatusID(RowStatusID); return sTD_ExamInfo; }
public static STD_ExamInfo GetSTD_CampusByCampusID(int CampusID) { STD_ExamInfo sTD_ExamInfo = new STD_ExamInfo(); SqlSTD_ExamInfoProvider sqlSTD_ExamInfoProvider = new SqlSTD_ExamInfoProvider(); sTD_ExamInfo = sqlSTD_ExamInfoProvider.GetSTD_ExamInfoByCampusID(CampusID); return sTD_ExamInfo; }
public static STD_ExamInfo GetSTD_ExamTypeByExamTypeID(int ExamTypeID) { STD_ExamInfo sTD_ExamInfo = new STD_ExamInfo(); SqlSTD_ExamInfoProvider sqlSTD_ExamInfoProvider = new SqlSTD_ExamInfoProvider(); sTD_ExamInfo = sqlSTD_ExamInfoProvider.GetSTD_ExamInfoByExamTypeID(ExamTypeID); return sTD_ExamInfo; }
public static STD_ExamInfo GetSTD_BatchByBatchID(int BatchID) { STD_ExamInfo sTD_ExamInfo = new STD_ExamInfo(); SqlSTD_ExamInfoProvider sqlSTD_ExamInfoProvider = new SqlSTD_ExamInfoProvider(); sTD_ExamInfo = sqlSTD_ExamInfoProvider.GetSTD_ExamInfoByBatchID(BatchID); return sTD_ExamInfo; }
protected void btnUpdate_Click(object sender, EventArgs e) { STD_ExamInfo sTD_ExamInfo = new STD_ExamInfo (); sTD_ExamInfo.ExamInfoID= int.Parse(Request.QueryString["ID"].ToString()); sTD_ExamInfo.CampusID= int.Parse(ddlCampusID.SelectedValue); sTD_ExamInfo.BatchID= int.Parse(ddlBatchID.SelectedValue); sTD_ExamInfo.SemesterID= int.Parse(ddlSemesterID.SelectedValue); sTD_ExamInfo.SubjectTeacherID= ddlSubjectTeacherID.SelectedValue; sTD_ExamInfo.ExamTypeID= int.Parse(ddlExamTypeID.SelectedValue); sTD_ExamInfo.ExamInfoName= txtExamInfoName.Text; sTD_ExamInfo.ExtraField1= txtExtraField1.Text; sTD_ExamInfo.ExtraField2= txtExtraField2.Text; sTD_ExamInfo.ExtraField3= txtExtraField3.Text; sTD_ExamInfo.ExtraField4= txtExtraField4.Text; sTD_ExamInfo.ExtraField5= txtExtraField5.Text; sTD_ExamInfo.AddedBy= "530038e1-cf38-4ddb-84a4-99b6974b4f9d"; sTD_ExamInfo.AddedDate= DateTime.Now; sTD_ExamInfo.UpdatedBy= "530038e1-cf38-4ddb-84a4-99b6974b4f9d"; sTD_ExamInfo.UpdatedDate= DateTime.Now; sTD_ExamInfo.RowStatusID= int.Parse(ddlRowStatusID.SelectedValue); bool resutl =STD_ExamInfoManager.UpdateSTD_ExamInfo(sTD_ExamInfo); Response.Redirect("AdminDisplaySTD_ExamInfo.aspx"); }
public static STD_ExamInfo GetSTD_SubjectTeacherBySubjectTeacherID(string SubjectTeacherID) { STD_ExamInfo sTD_ExamInfo = new STD_ExamInfo(); SqlSTD_ExamInfoProvider sqlSTD_ExamInfoProvider = new SqlSTD_ExamInfoProvider(); sTD_ExamInfo = sqlSTD_ExamInfoProvider.GetSTD_ExamInfoBySubjectTeacherID(SubjectTeacherID); return sTD_ExamInfo; }
public static STD_ExamInfo GetSTD_SemesterBySemesterID(int SemesterID) { STD_ExamInfo sTD_ExamInfo = new STD_ExamInfo(); SqlSTD_ExamInfoProvider sqlSTD_ExamInfoProvider = new SqlSTD_ExamInfoProvider(); sTD_ExamInfo = sqlSTD_ExamInfoProvider.GetSTD_ExamInfoBySemesterID(SemesterID); return sTD_ExamInfo; }
public static bool UpdateSTD_ExamInfo(STD_ExamInfo sTD_ExamInfo) { SqlSTD_ExamInfoProvider sqlSTD_ExamInfoProvider = new SqlSTD_ExamInfoProvider(); return sqlSTD_ExamInfoProvider.UpdateSTD_ExamInfo(sTD_ExamInfo); }
public static int InsertSTD_ExamInfo(STD_ExamInfo sTD_ExamInfo) { SqlSTD_ExamInfoProvider sqlSTD_ExamInfoProvider = new SqlSTD_ExamInfoProvider(); return sqlSTD_ExamInfoProvider.InsertSTD_ExamInfo(sTD_ExamInfo); }
public bool UpdateSTD_ExamInfo(STD_ExamInfo sTD_ExamInfo) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateSTD_ExamInfo", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ExamInfoID", SqlDbType.Int).Value = sTD_ExamInfo.ExamInfoID; cmd.Parameters.Add("@CampusID", SqlDbType.Int).Value = sTD_ExamInfo.CampusID; cmd.Parameters.Add("@BatchID", SqlDbType.Int).Value = sTD_ExamInfo.BatchID; cmd.Parameters.Add("@SemesterID", SqlDbType.Int).Value = sTD_ExamInfo.SemesterID; cmd.Parameters.Add("@SubjectTeacherID", SqlDbType.NVarChar).Value = sTD_ExamInfo.SubjectTeacherID; cmd.Parameters.Add("@ExamTypeID", SqlDbType.Int).Value = sTD_ExamInfo.ExamTypeID; cmd.Parameters.Add("@ExamInfoName", SqlDbType.NVarChar).Value = sTD_ExamInfo.ExamInfoName; cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = sTD_ExamInfo.ExtraField1; cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = sTD_ExamInfo.ExtraField2; cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = sTD_ExamInfo.ExtraField3; cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = sTD_ExamInfo.ExtraField4; cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = sTD_ExamInfo.ExtraField5; cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = sTD_ExamInfo.UpdatedBy; cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = sTD_ExamInfo.UpdatedDate; cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = sTD_ExamInfo.RowStatusID; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public STD_ExamInfo GetSTD_ExamInfoFromReader(IDataReader reader) { try { STD_ExamInfo sTD_ExamInfo = new STD_ExamInfo ( DataAccessObject.IsNULL<int>(reader["ExamInfoID"]), DataAccessObject.IsNULL<int>(reader["CampusID"]), DataAccessObject.IsNULL<int>(reader["BatchID"]), DataAccessObject.IsNULL<int>(reader["SemesterID"]), DataAccessObject.IsNULL<string>(reader["SubjectTeacherID"].ToString()), DataAccessObject.IsNULL<int>(reader["ExamTypeID"]), DataAccessObject.IsNULL<string>(reader["ExamInfoName"]), 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_ExamInfo; } catch(Exception ex) { return null; } }
private void showSTD_ExamInfoData() { STD_ExamInfo sTD_ExamInfo = new STD_ExamInfo (); sTD_ExamInfo = STD_ExamInfoManager.GetSTD_ExamInfoByExamInfoID(Int32.Parse(Request.QueryString["ID"])); ddlCampusID.SelectedValue =sTD_ExamInfo.CampusID.ToString(); ddlBatchID.SelectedValue =sTD_ExamInfo.BatchID.ToString(); ddlSemesterID.SelectedValue =sTD_ExamInfo.SemesterID.ToString(); ddlSubjectTeacherID.SelectedValue =sTD_ExamInfo.SubjectTeacherID.ToString(); ddlExamTypeID.SelectedValue =sTD_ExamInfo.ExamTypeID.ToString(); txtExamInfoName.Text =sTD_ExamInfo.ExamInfoName.ToString(); txtExtraField1.Text =sTD_ExamInfo.ExtraField1.ToString(); txtExtraField2.Text =sTD_ExamInfo.ExtraField2.ToString(); txtExtraField3.Text =sTD_ExamInfo.ExtraField3.ToString(); txtExtraField4.Text =sTD_ExamInfo.ExtraField4.ToString(); txtExtraField5.Text =sTD_ExamInfo.ExtraField5.ToString(); ddlRowStatusID.SelectedValue =sTD_ExamInfo.RowStatusID.ToString(); }