protected void btnSubmit_Click(object sender, EventArgs e) { DataTable dt = GetGridviewData(); if (dt != null && dt.Rows.Count > 0) { StudentInformation _AlumniInfo = new StudentInformation(); _AlumniInfo.nAlumniID = 0; _AlumniInfo.sAlumniName = txtAlumniName.Text.Trim(); _AlumniInfo.sAdmissionYear = txtAdmissionYear.Text.Trim(); _AlumniInfo.sPassingYear = txtPassingYear.Text.Trim(); _AlumniInfo.nBranchID = Convert.ToInt64(BranchName.Value); _AlumniInfo.sContactNo = txtContactNo.Text.Trim(); _AlumniInfo.sAlternateContactNo = txtAltContactNo.Text.Trim(); _AlumniInfo.sPersonalEmailID = txtPersonalEmail.Text.Trim(); _AlumniInfo.sOfficeEmailID = txtOfficeEmail.Text.Trim(); _AlumniInfo.sCorrespondanceAddress = txtCorresAddr.Text.Trim(); _AlumniInfo.sPermanentAddress = txtPermanentAddr.Text.Trim(); _AlumniInfo.sOccupation = txtOccupation.Text.Trim(); _AlumniInfo.sDesigation = txtDesignation.Text.Trim(); _AlumniInfo.sCompanyName = txtCompanyName.Text.Trim(); _AlumniInfo.sCompanyAddress = txtCompanyAddr.Text.Trim(); _AlumniInfo.sWhatsUpDetails = txtWhatsup.Text.Trim(); _AlumniInfo.sFacebookDetails = txtFacebook.Text.Trim(); _AlumniInfo.sLinkedinDetails = txtLinkedin.Text.Trim(); _AlumniInfo.InsertUpdateAlumniStudentInfo(dt); } }
protected void btnSubmit_Click(object sender, EventArgs e) { DataTable _dt = null; StudentInformation _studInfo=new StudentInformation(); _dt = _studInfo.GetStudentDetailsByUserName(txtUserName.Text.Trim()); if (_dt!=null&&_dt.Rows.Count>0) { string sPassword = Encryption.DecryptToBase64String(Convert.ToString(_dt.Rows[0]["sPassword"])); if (sPassword==txtPassword.Text) { Session["UserName"] = Convert.ToString(_dt.Rows[0]["sUserName"]); Session["StudentName"] = Convert.ToString(_dt.Rows[0]["Student Name"]); Session["StudentEmail"] = Convert.ToString(_dt.Rows[0]["sStudEmailID"]); Session["StudentID"] = Convert.ToString(_dt.Rows[0]["nStudentID"]); Response.Redirect("RegistrationForm.aspx"); } else { dvLoginError.Style.Add("display", "Block"); lbLoginError.InnerHtml = "Please enter correct password"; } } }
private DataTable GetAllatestNews(int nNewsType) { DataTable _dt = null; DataAccess _DataAccess = new DataAccess(); StudentInformation _Student = new StudentInformation(); try { _dt = _Student.GetLatestNEWS(nNewsType, true); } catch (Exception) { if (_DataAccess != null) { _DataAccess.RollBack(); _DataAccess.CloseConnection(false); } } finally { } return _dt; }
private DataTable GetDepartmentFaculty() { DataTable _dt = null; DataAccess _DataAccess = new DataAccess(); StudentInformation _studentInfo = new StudentInformation(); try { _dt = _studentInfo.GetDepartmentFacultyList(2); } catch (Exception) { if (_DataAccess != null) { _DataAccess.RollBack(); _DataAccess.CloseConnection(false); } } finally { } return _dt; }
private DataTable GetBranchIntake() { DataTable _dt = null; DataAccess _DataAccess = new DataAccess(); StudentInformation _Student = new StudentInformation(); try { _dt = _Student.GetBranchIntakeDetails(13); } catch (Exception) { if (_DataAccess != null) { _DataAccess.RollBack(); _DataAccess.CloseConnection(false); } } finally { } return _dt; }
private DataTable GetPaperPresentedByStaff() { DataTable _dt = null; DataAccess _DataAccess = new DataAccess(); StudentInformation _Student = new StudentInformation(); try { _dt = _Student.GetPaperPresentedByStaff(6); } catch (Exception) { if (_DataAccess != null) { _DataAccess.RollBack(); _DataAccess.CloseConnection(false); } } finally { } return _dt; }
protected void btnSubmit_Click(object sender, EventArgs e) { StudentInformation _studInfo = new StudentInformation(); DataAccess _DataAccess = new DataAccess(); _studInfo.nStudentID = 0; _studInfo.sStudFirstName = txtFirstName.Text; _studInfo.sStudMiddleName = txtMiddleName.Text; _studInfo.sStudLastName = txtLastName.Text; if (!bIsModify) { _studInfo.sStudUserName = txtUserName.Text; _studInfo.sStudPassword = Encryption.EncryptToBase64String(txtConfirmPassword.Text); } _studInfo.sStudEmailID = txtEmailID.Text; _studInfo.sStudRegistrationID = txtRegistrationID.Text; _studInfo.sStudCurrentYear = CurrentYear.Value; _studInfo.dtStudDOB = Convert.ToDateTime(txtDOB.Text); _studInfo.nBranchID = Convert.ToInt64(BranchName.Value); _studInfo.bIsStudentActive = true; _studInfo.nEduDtlsID = 0; _studInfo.sSSCMarks = txtSscMarks.Text; _studInfo.sHSCMarks = txtHscMarks.Text; _studInfo.sDiplomaMarks = txtDiplomaMarks.Text; _studInfo.sFirstYearMarks = txtFirstYearMarks.Text; _studInfo.sSecondYearMarks = txtSecondYearMarks.Text; _studInfo.sThirdYearMarks = txtThirdYearMarks.Text; _studInfo.sBEMarks = txtBEMarks.Text; try { _studInfo.InsertUpdateStudentInfo(); } catch (Exception) { } finally { } }
public static string GetStudentDetails(string id) { DataTable _dt = null; string sStudentDetails = string.Empty; DataAccess _DataAccess = new DataAccess(); StudentInformation _Student = new StudentInformation(); try { _dt = _Student.GetStudentDetailInfo(Convert.ToInt64(id)); if (_dt!=null&&_dt.Rows.Count>0) { foreach (DataRow dr in _dt.Rows) { foreach (DataColumn dc in _dt.Columns) { if (sStudentDetails=="") { sStudentDetails = dr[dc].ToString(); } else { sStudentDetails = sStudentDetails + "^" + dr[dc].ToString(); } } } } } catch (Exception) { if (_DataAccess != null) { _DataAccess.RollBack(); _DataAccess.CloseConnection(false); } } finally { } return sStudentDetails; }
private DataTable GetSeminarOrganized() { DataTable _dt = null; DataAccess _DataAccess = new DataAccess(); StudentInformation _Student = new StudentInformation(); try { _dt = _Student.GetSeminarOrganized(2); } catch (Exception) { if (_DataAccess != null) { _DataAccess.RollBack(); _DataAccess.CloseConnection(false); } } finally { } return _dt; }
private DataTable GetAllAlumni(string sSearchString, int nSearchCriteria) { DataTable _dt = null; DataAccess _DataAccess = new DataAccess(); StudentInformation _Student = new StudentInformation(); try { _dt = _Student.GetAlumniInfo(sSearchString,nSearchCriteria); } catch (Exception) { if (_DataAccess != null) { _DataAccess.RollBack(); _DataAccess.CloseConnection(false); } } finally { } return _dt; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { PopulateYearDatalist(0); PopulateBranchDatalist(); Int64 nStudentID = Convert.ToInt64(Session["StudentID"]); if (nStudentID != 0) { dvLoginDetails.Style.Add("Display","none"); bIsModify = true; StudentInformation _studInfo = new StudentInformation(); DataTable _dtStudentInfo = _studInfo.GetEditStudentDetailInfo(nStudentID); if (_dtStudentInfo != null && _dtStudentInfo.Rows.Count > 0) { foreach (DataRow dr in _dtStudentInfo.Rows) { txtRegistrationID.Text = Convert.ToString(dr["sStudRegistrationID"]); txtEmailID.Text = Convert.ToString(dr["sStudEmailID"]); txtFirstName.Text = Convert.ToString(dr["sStudFirstName"]); txtMiddleName.Text = Convert.ToString(dr["sStudMiddleName"]); txtLastName.Text = Convert.ToString(dr["sStudLastName"]); txtDOB.Text = Convert.ToDateTime(dr["dtStudDOB"]).ToString("yyyy-MM-dd"); CurrentYear.SelectedIndex = Convert.ToInt16(dr["sCurrentYear"]); BranchName.SelectedIndex = Convert.ToInt16(dr["nBranchID"]); txtUserName.Text = Convert.ToString(dr["sUserName"]); //txtpassword.Text = Convert.ToString(dr[""]); txtSscMarks.Text = Convert.ToString(dr["sSSCMarks"]); txtHscMarks.Text = Convert.ToString(dr["sHSCMarks"]); txtDiplomaMarks.Text = Convert.ToString(dr["sDiplomaMarks"]); txtFirstYearMarks.Text = Convert.ToString(dr["sFirstYearMarks"]); txtSecondYearMarks.Text = Convert.ToString(dr["sSecondYearMarks"]); txtThirdYearMarks.Text = Convert.ToString(dr["sThirdYearMarks"]); txtBEMarks.Text = Convert.ToString(dr["sBEMarks"]); } } } } }