//Function to save work experience details of student private void workExpDetailsButton_Click(object sender, EventArgs e) { try { IWorkExperienceDetails _workExpDetails = new studentWorkExpDetails(); WorkExperienceDetails _studentWorkExpDetails = new WorkExperienceDetails(); if (!NoneRadioButton.Checked) { _studentWorkExpDetails.StudentId = _studentID; _studentWorkExpDetails.RecentCompanyYear = (string.IsNullOrEmpty(yearsTextbox.Text) == false) ? yearsTextbox.Text : "NA"; _studentWorkExpDetails.RecentCompanyName = (string.IsNullOrEmpty(companyTextbox.Text) == false) ? companyTextbox.Text : "NA"; _studentWorkExpDetails.TotalYrsExp = (string.IsNullOrEmpty(totalYearsExperienceTextbox.Text) == false) ? Convert.ToInt32(totalYearsExperienceTextbox.Text) : 0; _studentWorkExpDetails.PreviousGA = (string.IsNullOrEmpty(previousGATextbox.Text) == false) ? previousGATextbox.Text : "NA"; _studentWorkExpDetails.PreGAFaculty = (string.IsNullOrEmpty(prevGAFacultyTextbox.Text) == false) ? prevGAFacultyTextbox.Text : "NA"; _studentWorkExpDetails.FacultyRef = (string.IsNullOrEmpty(facultyReferenceTextbox.Text) == false) ? facultyReferenceTextbox.Text : "NA"; } else { _studentWorkExpDetails.StudentId = _studentID; _studentWorkExpDetails.RecentCompanyYear = "No Expereience"; _studentWorkExpDetails.RecentCompanyName = "No Expereience"; _studentWorkExpDetails.TotalYrsExp = 0; _studentWorkExpDetails.PreviousGA = "No Expereience"; _studentWorkExpDetails.PreGAFaculty = "No Expereience"; _studentWorkExpDetails.FacultyRef = "No Expereience"; } string _resultWorkExp = _workExpDetails.insertWorkExperience(_studentWorkExpDetails); MessageBox.Show(_resultWorkExp); } catch (Exception Ex) { MessageBox.Show(Ex.Message); } }
//get request to display work experience details private void getWorkExpButton_Click(object sender, EventArgs e) { try { IWorkExperienceDetails _workExpDetails = new studentWorkExpDetails(); _studentID = 700; WorkExperienceDetails _resultWorkExpDetails = _workExpDetails.GetStudentWrkExpDetailsBy(_studentID); companyTextbox.Text = _resultWorkExpDetails.RecentCompanyName; yearsTextbox.Text = _resultWorkExpDetails.RecentCompanyYear; totalYearsExperienceTextbox.Text = Convert.ToString(_resultWorkExpDetails.TotalYrsExp); previousGATextbox.Text = _resultWorkExpDetails.PreviousGA; prevGAFacultyTextbox.Text = _resultWorkExpDetails.PreGAFaculty; facultyReferenceTextbox.Text = _resultWorkExpDetails.FacultyRef; } catch (Exception Ex) { MessageBox.Show(Ex.Message); } }
//Function to update Work Experience Details private void updateWorkExpButton_Click(object sender, EventArgs e) { try { IWorkExperienceDetails _workExpDetails = new studentWorkExpDetails(); WorkExperienceDetails _studentWorkExpDetails = new WorkExperienceDetails(); if (!NoneRadioButton.Checked) { _studentWorkExpDetails.StudentId = 700;//_studentID; _studentWorkExpDetails.RecentCompanyYear = yearsTextbox.Text; _studentWorkExpDetails.RecentCompanyName = companyTextbox.Text; _studentWorkExpDetails.TotalYrsExp = Convert.ToInt32(totalYearsExperienceTextbox.Text); _studentWorkExpDetails.PreviousGA = previousGATextbox.Text; _studentWorkExpDetails.PreGAFaculty = prevGAFacultyTextbox.Text; _studentWorkExpDetails.FacultyRef = facultyReferenceTextbox.Text; } else { _studentWorkExpDetails.StudentId = _studentID; _studentWorkExpDetails.RecentCompanyYear = "No Expereience"; _studentWorkExpDetails.RecentCompanyName = "No Expereience"; _studentWorkExpDetails.TotalYrsExp = 0; _studentWorkExpDetails.PreviousGA = "No Expereience"; _studentWorkExpDetails.PreGAFaculty = "No Expereience"; _studentWorkExpDetails.FacultyRef = "No Expereience"; } string _resultWorkExp = _workExpDetails.UpDateStudentWrkExpDetails(_studentWorkExpDetails); MessageBox.Show(_resultWorkExp); } catch (Exception Ex) { MessageBox.Show(Ex.Message); } }