//this function is used to determine if the student id exists private Boolean IsExistStudentIdStudentInformation(CommonExchange.SysAccess userInfo, String studentId, String studentSysId) { Boolean isExist = false; using (RemoteClient.RemCntStudentManager remClient = new RemoteClient.RemCntStudentManager()) { isExist = remClient.IsExistsStudentIdStudentInformation(userInfo, studentId, studentSysId); } return(isExist); } //-------------------------------
}//--------------------- //this function will get student information by person system id public CommonExchange.Student SelectBySysIDPersonStudentInformation(CommonExchange.SysAccess userInfo, String personSysId, String startUp) { CommonExchange.Student studentInfo = new CommonExchange.Student(); using (RemoteClient.RemCntStudentManager remClient = new RemoteClient.RemCntStudentManager()) { studentInfo = remClient.SelectBySysIDPersonStudentInformation(userInfo, personSysId); } studentInfo.PersonInfo.FilePath = this.GetPersonImagePath(userInfo, studentInfo.PersonInfo.PersonSysId, studentInfo.PersonInfo.PersonImagesFolder(startUp)); return(studentInfo); }//------------------
}//------------------------------ //this function gets the selected student public DataTable GetSearchedStudentInformation(CommonExchange.SysAccess userInfo, String queryString, String dateStart, String dateEnd, String yearLevelId, String courseId) { DataTable newTable = new DataTable("StudentSearchByStudentNameIdCardNumberTable"); newTable.Columns.Add("student_id", System.Type.GetType("System.String")); newTable.Columns.Add("card_number", System.Type.GetType("System.String")); newTable.Columns.Add("student_name", System.Type.GetType("System.String")); newTable.Columns.Add("course_title", System.Type.GetType("System.String")); newTable.Columns.Add("year_level_description", System.Type.GetType("System.String")); newTable.Columns.Add("department_name", System.Type.GetType("System.String")); using (RemoteClient.RemCntStudentManager remClient = new RemoteClient.RemCntStudentManager()) { _studentTable = remClient.SelectStudentInformation(userInfo, queryString, dateStart, dateEnd, courseId, yearLevelId); } foreach (DataRow studentRow in _studentTable.Rows) { DataRow newRow = newTable.NewRow(); newRow["student_id"] = RemoteServerLib.ProcStatic.DataRowConvert(studentRow, "student_id", ""); newRow["card_number"] = RemoteServerLib.ProcStatic.DataRowConvert(studentRow, "card_number", ""); newRow["student_name"] = RemoteClient.ProcStatic.GetCompleteNameMiddleInitial(studentRow, "last_name", "first_name", "middle_name"); newRow["course_title"] = RemoteServerLib.ProcStatic.DataRowConvert(studentRow, "course_title", "") + " - " + RemoteServerLib.ProcStatic.DataRowConvert(studentRow, "course_acronym", ""); newRow["year_level_description"] = RemoteServerLib.ProcStatic.DataRowConvert(studentRow, "year_level_description", ""); newRow["department_name"] = RemoteServerLib.ProcStatic.DataRowConvert(studentRow, "department_name", "") + " - " + RemoteServerLib.ProcStatic.DataRowConvert(studentRow, "department_acronym", ""); newTable.Rows.Add(newRow); } newTable.AcceptChanges(); return(newTable); }//-----------------------------
} //------------------------ //this procedure exports the student data to the sql server private void ExportStudentDataToSqlServer() { try { this.Cursor = Cursors.WaitCursor; Int32 deniedCount = 0; Int32 successCount = 0; Int32 rowCount = 0; pgbImport.Step = 1; pgbImport.Maximum = this.dgvList.Rows.Count; foreach (DataRow studRow in _studentTable.Rows) { this.SetDataGridViewBehavior(rowCount); String studentId = RemoteServerLib.ProcStatic.DataRowConvert(studRow, "ACCESSION", ""); String cardNumber = RemoteServerLib.ProcStatic.DataRowConvert(studRow, "KEYWORDS", ""); String studentName = RemoteServerLib.ProcStatic.DataRowConvert(studRow, "TITLE0", ""); if (!this.IsExistStudentIdStudentInformation(_userInfo, studentId, "") && !this.IsExistCardNumberStudentInformation(_userInfo, cardNumber, "") && !String.Equals("(blank)", studentName) && !String.IsNullOrEmpty(RemoteClient.ProcStatic.TrimStartEndString(cardNumber)) && !String.IsNullOrEmpty(RemoteClient.ProcStatic.TrimStartEndString(studentId))) { String remarks = RemoteServerLib.ProcStatic.DataRowConvert(studRow, "REMARKS", ""); CommonExchange.Student studentInfo = new CommonExchange.Student(); studentInfo.ObjectState = DataRowState.Added; studentInfo.PersonInfo.ObjectState = DataRowState.Added; StudentName studName = this.GetStudentNameDetails(studentName); RemarksDetails remarkInfo = this.GetRemarksDetails(remarks); studentInfo.StudentId = RemoteClient.ProcStatic.TrimStartEndString(studentId); studentInfo.PersonInfo.LastName = studName.LastName; studentInfo.PersonInfo.FirstName = studName.FirstName; studentInfo.CardNumber = cardNumber; studentInfo.Scholarship = studName.Scholoarship; studentInfo.CourseInfo.CourseId = this.GetCourseId(remarkInfo.CourseName); studentInfo.PersonInfo.OtherPersonInformation = remarkInfo.OtherInformation; studentInfo.PersonInfo.BirthDate = String.Empty; if (!String.IsNullOrEmpty(_imagePath) && this.chkImage.Checked) { StudentImage imageInfo = this.GetStudentImageDetails(studentId); if (!String.IsNullOrEmpty(imageInfo.ImagePath)) { studentInfo.PersonInfo.FilePath = imageInfo.ImagePath; studentInfo.PersonInfo.FileData = RemoteClient.ProcStatic.GetFileArrayBytes(imageInfo.ImagePath); studentInfo.PersonInfo.FileExtension = imageInfo.ImageExtension; studentInfo.PersonInfo.FileName = Path.GetFileName(imageInfo.ImagePath); this.txtDirectory.Text = imageInfo.ImagePath; } } using (RemoteClient.RemCntStudentManager remClient = new RemoteClient.RemCntStudentManager()) { remClient.InsertStudentInformation(_userInfo, ref studentInfo); } using (RemoteClient.RemCntIdMakerManager remClient = new RemoteClient.RemCntIdMakerManager()) { remClient.UpdateForIdMakerStudentInformation(_userInfo, studentInfo); } successCount++; } else { deniedCount++; } pgbImport.PerformStep(); rowCount++; Application.DoEvents(); this.Refresh(); } MessageBox.Show("Student data has been successfully exported to the SQL Server" + "\n\nSuccess: " + successCount.ToString() + " Record(s)" + "\nDenied: " + deniedCount.ToString() + " Record(s)", "Success", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); pgbImport.Value = 0; } catch (Exception ex) { MessageBox.Show("Error in exporting: " + ex.Message, "Error"); } finally { this.Cursor = Cursors.Arrow; } } //--------------------------------------