//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);
}
}
