private void btn_Category_Reset_Click(object sender, RoutedEventArgs e)
{
textBox_Category_ID.Text = Category_BL.GetAutogeneratedCategoryID_BL().ToString();
textBox_SearchCategory.Clear();
textBox_Category_Name.Clear();
textBox_Category_Description.Clear();
}
//OnLoad Event
private void Window_Loaded(object sender, RoutedEventArgs e)
{
textBox_Employee_Id.Text = EmployeeValidation.GetAutogeneratedEmployeeID_BL().ToString();
textBox_Project_ID.Text = Project_BL.GetAutogeneratedProjectID_BL().ToString();
textBox_Category_ID.Text = Category_BL.GetAutogeneratedCategoryID_BL().ToString();
textBox_Skill_ID.Text = Skill_BL.GetAutogeneratedSkillID_BL().ToString();
//Load Civil Status Data from Database
DataTable dtCivil = EmployeeValidation.LoadCivilStatus_BL();
if (dtCivil.Rows.Count >= 0)
{
cmb_Employee_CivilStatus.ItemsSource = dtCivil.DefaultView;
cmb_Employee_CivilStatus.DisplayMemberPath = "Status_Description";
cmb_Employee_CivilStatus.SelectedValuePath = "Status_Id";
}
//Load Level Data from Database
DataTable dtLvl = EmployeeValidation.LoadLevel_BL();
if (dtLvl.Rows.Count >= 0)
{
cmb_Employee_LevelID.ItemsSource = dtLvl.DefaultView;
cmb_Employee_LevelID.DisplayMemberPath = "Level_Description";
cmb_Employee_LevelID.SelectedValuePath = "Level_Id";
}
//Load Projects Data from Database
DataTable dtProj = EmployeeValidation.LoadProject_BL();
if (dtProj.Rows.Count >= 0)
{
cmb_Employee_ProjectID.ItemsSource = dtProj.DefaultView;
cmb_Employee_ProjectID.DisplayMemberPath = "Project_Name";
cmb_Employee_ProjectID.SelectedValuePath = "Project_Id";
}
//Load Speciality Data from Database
DataTable dtSpec = EmployeeValidation.LoadSeciality_BL();
if (dtSpec.Rows.Count >= 0)
{
cmb_Employee_Speciality.ItemsSource = dtSpec.DefaultView;
cmb_Employee_Speciality.DisplayMemberPath = "Speciality_Name";
cmb_Employee_Speciality.SelectedValuePath = "Speciality_Id";
}
//Load Skills Data from Database
DataTable dtSkill = EmployeeValidation.LoadSkill_BL();
if (dtSkill.Rows.Count >= 0)
{
cmb_Employee_SkillID.ItemsSource = dtSkill.DefaultView;
cmb_Employee_SkillID.DisplayMemberPath = "Skill_Name";
cmb_Employee_SkillID.SelectedValuePath = "Skill_Id";
}
//Load Category Data from Database
DataTable dtCat = Skill_BL.LoadCatSkill_BL();
if (dtCat.Rows.Count >= 0)
{
cmb_Category_ID.ItemsSource = dtCat.DefaultView;
cmb_Category_ID.DisplayMemberPath = "Category_Name";
cmb_Category_ID.SelectedValuePath = "Category_Id";
}
}
