Пример #1
0
        private void btn_AdminSpeciality_Search_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                int       specId = Convert.ToInt32(textBox_AdminSpeciality_ID.Text);
                DataTable sEd    = Speciality_BL.SearchSpecialityById_BL(specId);

                DataRow dr = sEd.Rows[0];
                if (!dr.IsNull("Speciality_Id"))
                {
                    textBox_AdminSpeciality_ID.Text   = dr["Speciality_Id"].ToString();
                    textBox_AdminSpeciality_Name.Text = dr["Speciality_Name"].ToString();
                }
                else
                {
                    MessageBox.Show("No Records found with Speciality Id : " + specId);
                }
            }
            catch (HRMSException ex)
            {
                MessageBox.Show(ex.Message);
            }
            catch (SqlException ex)
            {
                MessageBox.Show(ex.Message);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
Пример #2
0
        private void btn_AdminSpeciality_Update_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                Speciality newSpec = new Speciality();

                newSpec.SpecialityId   = Convert.ToInt32(textBox_AdminSpeciality_ID.Text);
                newSpec.SpecialityName = textBox_AdminSpeciality_Name.Text;

                int rowsAffected = Speciality_BL.UpdateSpeciality_BL(newSpec);
                if (rowsAffected > 0)
                {
                    MessageBox.Show("Speciality Updated !!");
                }
                else
                {
                    MessageBox.Show("Error!!! Speciality Record not Updated");
                }
            }
            catch (HRMSException ex)
            {
                MessageBox.Show(ex.Message);
            }
            catch (SqlException ex)
            {
                MessageBox.Show(ex.Message);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
Пример #3
0
        private void btn_AdminSpeciality_Delete_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                int specId = Convert.ToInt32(textBox_AdminSpeciality_ID.Text);

                int rowsAffected = Speciality_BL.DeleteSpeciality_BL(specId);
                if (rowsAffected > 0)
                {
                    MessageBox.Show("Speciality Details Deleted !!");
                }
                else
                {
                    MessageBox.Show("Error!!! Speciality Record not found");
                }
            }
            catch (HRMSException ex)
            {
                MessageBox.Show(ex.Message);
            }
            catch (SqlException ex)
            {
                MessageBox.Show(ex.Message);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
Пример #4
0
 private void btn_AdminSpeciality_Display_Click(object sender, RoutedEventArgs e)
 {
     try
     {
         DataTable dtSpec = Speciality_BL.DisplaySpeciality_BL();
         dg_AdminSpeciality_Details.ItemsSource = dtSpec.DefaultView;
     }
     catch (HRMSException ex)
     {
         MessageBox.Show(ex.Message);
     }
     catch (SqlException ex)
     {
         MessageBox.Show(ex.Message);
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
 }
Пример #5
0
 //Window Loaded
 private void Window_Loaded(object sender, RoutedEventArgs e)
 {
     textBox_AdminSpeciality_ID.Text = Speciality_BL.GetAutogeneratedSpecialityID_BL().ToString();
 }
Пример #6
0
 private void btn_AdminSpeciality_Reset_Click(object sender, RoutedEventArgs e)
 {
     textBox_AdminSpeciality_ID.Text = Speciality_BL.GetAutogeneratedSpecialityID_BL().ToString();
     textBox_AdminSpeciality_Name.Clear();
 }