public tblstudenthealthrecord GetStudHealthRecord(int studentHealthRecordId) { tblstudenthealthrecord studentHealthRecord = (from p in svmContext.tblstudenthealthrecord where p.isDeleted == false && p.StudentHealthRecordId == studentHealthRecordId select p).FirstOrDefault(); return(studentHealthRecord); }
public void UpdateHealthBackground(int studentId, string childsDoctor, string doctorsContactNo, string doctorsBusinessNameAndAddress, bool immunization, int healthConcernId, string allergies, string conditionHindrance, string specialCare) { tblstudenthealthrecord tblStudentHealthRecord = new tblstudenthealthrecord(); tblStudentHealthRecord.ChildsDoctor = childsDoctor; tblStudentHealthRecord.DoctorsContactNo = doctorsBusinessNameAndAddress; tblStudentHealthRecord.DoctorsBusinessNameAndAddress = doctorsBusinessNameAndAddress; tblStudentHealthRecord.Immunization = immunization; tblStudentHealthRecord.HealthConcernId = healthConcernId; tblStudentHealthRecord.Allergies = allergies; tblStudentHealthRecord.ConditionHindrance = conditionHindrance; tblStudentHealthRecord.SpecialCare = specialCare; }
public void LoadStudent() { int result; //if (cmbStudentNo.SelectedValue != null) //{ if (int.TryParse(Global.selectedStudent.ToString(), out result)) { //disable buttons------------ txtFirstName.Enabled = false; txtMiddleName.Enabled = false; txtLastName.Enabled = false; dpDateOfBirth.Enabled = false; txtPlaceOfBirth.Enabled = false; cmbGender.Enabled = false; txtReligion.Enabled = false; txtCitizenship.Enabled = false; txtPostalCode.Enabled = false; rtbPermanentAddress.Enabled = false; btnUpload.Enabled = false; txtStudentNo.ReadOnly = true; dgEducationalBackground.Enabled = false; dgFamilyBackground.Enabled = false; txtChildsDoctor.Enabled = false; txtDoctorsContactNo.Enabled = false; txtAllergies.Enabled = false; rtbDoctorBizAddress.Enabled = false; cbComplete.Enabled = false; cbIncomplete.Enabled = false; cmbHealthConcern.Enabled = false; rtbSpecialProcedure.Enabled = false; btnSave.Hide(); btnEdit.Show(); isEdit = true; //---------------------------- student = _studentService.GetStudent(Global.selectedStudent); if (student != null) { txtStudentNo.Text = student.StudentId.ToString().PadLeft(4, '0') + " - " + student.AY.ToString(); txtFirstName.Text = student.FirstName; txtMiddleName.Text = student.MiddleName; txtLastName.Text = student.LastName; dpDateOfBirth.Text = student.DateOfBirth != dpDateOfBirth.MinDate ? student.DateOfBirth.ToString() : string.Empty; txtPlaceOfBirth.Text = student.PlaceOfBirth; cmbGender.SelectedValue = student.GenderId; txtReligion.Text = student.Religion; txtCitizenship.Text = student.Citizenship; txtPostalCode.Text = student.PostalCode; rtbPermanentAddress.Text = student.PermanentAddress; pbStudentImage.Image = !string.IsNullOrEmpty(student.path) ? Image.FromFile(student.path) : Image.FromFile(defaultImage); newPath = student.path; //render family background } studentEducationalBackground = _studentService.GetEducationalBackground(Global.selectedStudent); if (studentEducationalBackground != null) { dgEducationalBackground.ClearSelection(); dgEducationalBackground.Columns.Clear(); dgFamilyBackground.ClearSelection(); dgFamilyBackground.Columns.Clear(); var educBindingList = new BindingList <tblstudenteducationalbackground>(studentEducationalBackground); var educSource = new BindingSource(educBindingList, null); dgEducationalBackground.DataSource = educSource; DataGridViewComboBoxColumn lvlCol = new DataGridViewComboBoxColumn(); lvlCol.Items.Insert(0, string.Empty); lstEducLevel = _studentService.GetEducationLevel(); lstEducLevel.Insert(0, new tbldimeducationlevel { LevelId = 0, Level = string.Empty }); lvlCol.DataSource = lstEducLevel; lvlCol.ValueMember = "LevelId"; lvlCol.DisplayMember = "Level"; lvlCol.DataPropertyName = "EducLevelId"; lvlCol.Name = "Level"; dgEducationalBackground.Columns.Insert(0, lvlCol); dgEducationalBackground.Columns["EducLevelId"].HeaderText = "Level"; dgEducationalBackground.Columns["StudentId"].Visible = false; dgEducationalBackground.Columns["IsDeleted"].Visible = false; //dgEducationalBackground.Columns[7].Visible = false; // dgEducationalBackground.Columns["LevelId"].Visible = false; dgEducationalBackground.Columns["SchoolName"].HeaderText = "School Name and Address"; dgEducationalBackground.Columns["SchoolYear"].HeaderText = "School Year"; dgEducationalBackground.Columns["AwardsReceived"].HeaderText = "Awards Received"; studentFamily = _studentService.GetStudentFamily(Global.selectedStudent); if (studentFamily != null) { var famBindingList = new BindingList <tblstudentfamily>(studentFamily); var famcSource = new BindingSource(famBindingList, null); dgFamilyBackground.DataSource = famcSource; DataGridViewComboBoxColumn cmbRelation = new DataGridViewComboBoxColumn(); // DataGridViewColumn cmbLevel = new DataGridViewColumn(bc); //cmbRelation.Items.Insert(0, String.Empty); lstRelationship = _studentService.GetRelationship(); lstRelationship.Insert(0, new tblrelationship { RelationshipId = 0, RelationshipName = String.Empty }); cmbRelation.DataSource = lstRelationship; cmbRelation.ValueMember = "RelationshipId"; cmbRelation.DisplayMember = "RelationshipName"; cmbRelation.DataPropertyName = "RelationshipId"; dgFamilyBackground.Columns["RelationshipId"].Visible = false; dgFamilyBackground.Columns.Insert(1, cmbRelation); dgFamilyBackground.Columns["name"].HeaderText = "Name"; dgFamilyBackground.Columns["citizenship"].HeaderText = "Citizenship"; dgFamilyBackground.Columns["Religion"].HeaderText = "Religion"; dgFamilyBackground.Columns["Address"].HeaderText = "Home Address"; dgFamilyBackground.Columns["TelNo"].HeaderText = "Tel No"; dgFamilyBackground.Columns["MobileNo"].HeaderText = "Mobile No"; dgFamilyBackground.Columns["eMail"].HeaderText = "Email"; dgFamilyBackground.Columns["occupation"].HeaderText = "Occupation"; dgFamilyBackground.Columns["EmployerBizAddress"].HeaderText = "Employer Business Name and Address"; dgFamilyBackground.Columns["Address"].HeaderText = "Home Address"; dgFamilyBackground.Columns["YearGraduated"].HeaderText = "Year Graduated"; dgFamilyBackground.Columns["EducationalAttainment"].HeaderText = "Educational Attainment"; //dgFamilyBackground.Columns.Add(cmbLevel); dgFamilyBackground.Columns["IsDeleted"].Visible = false; dgFamilyBackground.Columns["StudentId"].Visible = false; } studentHealth = _studentService.GetStudentHealthRecord(Global.selectedStudent); if (studentHealth != null) { txtChildsDoctor.Text = studentHealth.ChildsDoctor; txtDoctorsContactNo.Text = studentHealth.DoctorsContactNo; txtAllergies.Text = studentHealth.Allergies; rtbDoctorBizAddress.Text = studentHealth.DoctorsBusinessNameAndAddress; cbComplete.Checked = studentHealth.Immunization == true ? true : false; cmbHealthConcern.SelectedValue = studentHealth.HealthConcernId; immunization = cbComplete.Checked == true ? true : false; rtbSpecialProcedure.Text = studentHealth.SpecialCare; } } } //} }