private void LoadDefaultData(CodeFrm.TableNames TableName)
 {
     switch (TableName)
     {
         case CodeFrm.TableNames.CD_KastBnood:
             repositoryItemGridLookUpEditMoaahel_ID.DataSource = SqlDB.LoadDataTable(@"SELECT qualId, qualName, qualName_e FROM CDQualification");
             repositoryItemGridLookUpEditMoaahel_ID.DisplayMember = "qualName";
             repositoryItemGridLookUpEditMoaahel_ID.ValueMember = "qualId";
             break;
         case CodeFrm.TableNames.CD_Specialization:
             repositoryItemGridLookUpEditSPECIFICATION_ID.DataSource = SqlDB.LoadDataTable(@"SELECT SpecializationId, SpecializationName, SpecializationName_e FROM CD_Specialization");
             repositoryItemGridLookUpEditSPECIFICATION_ID.DisplayMember = "SpecializationName";
             repositoryItemGridLookUpEditSPECIFICATION_ID.ValueMember = "SpecializationId";
             break;
         case CodeFrm.TableNames.CD_KastSaf:
             repositoryItemGridLookUpEditQualifiedPlaceId.DataSource = SqlDB.LoadDataTable(@"SELECT QualifiedPlaceId, QualifiedPlaceName, QualifiedPlaceName_e FROM CD_QualifiedPlace");
             repositoryItemGridLookUpEditQualifiedPlaceId.DisplayMember = "QualifiedPlaceName";
             repositoryItemGridLookUpEditQualifiedPlaceId.ValueMember = "QualifiedPlaceId";
             break;
         case CodeFrm.TableNames.CDTakdeer:
             repositoryItemGridLookUpEditTakdeerId.DataSource = SqlDB.LoadDataTable(@"SELECT TakdeerId, TakdeerName, TakdeerName_e FROM CDTakdeer");
             repositoryItemGridLookUpEditTakdeerId.DisplayMember = "TakdeerName";
             repositoryItemGridLookUpEditTakdeerId.ValueMember = "TakdeerId";
             break;
         case CodeFrm.TableNames.All:
             //CDQualification
             repositoryItemGridLookUpEditMoaahel_ID.DataSource = SqlDB.LoadDataTable(@"SELECT qualId, qualName, qualName_e FROM CDQualification");
             repositoryItemGridLookUpEditMoaahel_ID.DisplayMember = "qualName";
             repositoryItemGridLookUpEditMoaahel_ID.ValueMember = "qualId";
             //CD_Specialization
             repositoryItemGridLookUpEditSPECIFICATION_ID.DataSource = SqlDB.LoadDataTable(@"SELECT SpecializationId, SpecializationName, SpecializationName_e FROM CD_Specialization");
             repositoryItemGridLookUpEditSPECIFICATION_ID.DisplayMember = "SpecializationName";
             repositoryItemGridLookUpEditSPECIFICATION_ID.ValueMember = "SpecializationId";
             //TBL_Emp
             repositoryItemGridLookUpEditEmp_ID.DataSource = SqlDB.LoadDataTable(@"SELECT EmpID, EMP_FIRST_NAME + ' ' + EMP_FATHER_NAME + ' ' + EMP_FAM_NAME + ' ' + EMP_FOURTH_NAME AS Emp_Name FROM TBL_Emp");
             repositoryItemGridLookUpEditEmp_ID.DisplayMember = "Emp_Name";
             repositoryItemGridLookUpEditEmp_ID.ValueMember = "EmpID";
             //CD_QualifiedPlace
             repositoryItemGridLookUpEditQualifiedPlaceId.DataSource = SqlDB.LoadDataTable(@"SELECT QualifiedPlaceId, QualifiedPlaceName, QualifiedPlaceName_e FROM CD_QualifiedPlace");
             repositoryItemGridLookUpEditQualifiedPlaceId.DisplayMember = "QualifiedPlaceName";
             repositoryItemGridLookUpEditQualifiedPlaceId.ValueMember = "QualifiedPlaceId";
             //CDTakdeer
             repositoryItemGridLookUpEditTakdeerId.DataSource = SqlDB.LoadDataTable(@"SELECT TakdeerId, TakdeerName, TakdeerName_e FROM CDTakdeer");
             repositoryItemGridLookUpEditTakdeerId.DisplayMember = "TakdeerName";
             repositoryItemGridLookUpEditTakdeerId.ValueMember = "TakdeerId";
             break;
         default:
             break;
     }
 }
 private void LoadDefaultData(CodeFrm.TableNames TableName)
 {
     switch (TableName)
     {
         case CodeFrm.TableNames.CD_Courses:
             repositoryItemGridLookUpEditCourseId.DataSource = SqlDB.LoadDataTable(@"SELECT CourseId, CourseName, CourseName_e FROM CD_Courses");
             repositoryItemGridLookUpEditCourseId.DisplayMember = "CourseName";
             repositoryItemGridLookUpEditCourseId.ValueMember = "CourseId";
             break;
         case CodeFrm.TableNames.CDPlaceTraining:
             repositoryItemGridLookUpEditPlaceTrainingId.DataSource = SqlDB.LoadDataTable(@"SELECT PlaceTrainingId, PlaceTrainingName, PlaceTrainingName_e FROM CDPlaceTraining");
             repositoryItemGridLookUpEditPlaceTrainingId.DisplayMember = "PlaceTrainingName";
             repositoryItemGridLookUpEditPlaceTrainingId.ValueMember = "PlaceTrainingId";
             break;
         case CodeFrm.TableNames.CDTakdeer:
             repositoryItemGridLookUpEditTakdeerId.DataSource = SqlDB.LoadDataTable(@"SELECT TakdeerId, TakdeerName, TakdeerName_e FROM CDTakdeer");
             repositoryItemGridLookUpEditTakdeerId.DisplayMember = "TakdeerName";
             repositoryItemGridLookUpEditTakdeerId.ValueMember = "TakdeerId";
             break;
         case CodeFrm.TableNames.All:
             //CD_Courses
             repositoryItemGridLookUpEditCourseId.DataSource = SqlDB.LoadDataTable(@"SELECT CourseId, CourseName, CourseName_e FROM CD_Courses");
             repositoryItemGridLookUpEditCourseId.DisplayMember = "CourseName";
             repositoryItemGridLookUpEditCourseId.ValueMember = "CourseId";
             //CDPlaceTraining
             repositoryItemGridLookUpEditPlaceTrainingId.DataSource = SqlDB.LoadDataTable(@"SELECT PlaceTrainingId, PlaceTrainingName, PlaceTrainingName_e FROM CDPlaceTraining");
             repositoryItemGridLookUpEditPlaceTrainingId.DisplayMember = "PlaceTrainingName";
             repositoryItemGridLookUpEditPlaceTrainingId.ValueMember = "PlaceTrainingId";
             //CDTakdeer
             repositoryItemGridLookUpEditTakdeerId.DataSource = SqlDB.LoadDataTable(@"SELECT TakdeerId, TakdeerName, TakdeerName_e FROM CDTakdeer");
             repositoryItemGridLookUpEditTakdeerId.DisplayMember = "TakdeerName";
             repositoryItemGridLookUpEditTakdeerId.ValueMember = "TakdeerId";
             //TBL_Emp
             repositoryItemGridLookUpEditEmpID.DataSource = SqlDB.LoadDataTable(@"SELECT EmpID, EMP_FIRST_NAME + ' ' + EMP_FATHER_NAME + ' ' + EMP_FAM_NAME + ' ' + EMP_FOURTH_NAME AS Emp_Name FROM TBL_Emp");
             repositoryItemGridLookUpEditEmpID.DisplayMember = "Emp_Name";
             repositoryItemGridLookUpEditEmpID.ValueMember = "EmpID";
             break;
         default:
             break;
     }
 }
Beispiel #3
0
        public void LoadCD_AsaseACC()
        {
            foreach (DockPanel pnl in dockManagerMain.Panels)
                pnl.Enabled = false;

            repositoryItemLookUpEditasase_code.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT asase_code, asase_year, SPOS,
            (Select SCHOOL From TBLSCHOOL Where SPOS = CD_AsaseACC.SPOS) AS SCHOOL, school_allcode FROM CD_AsaseACC ORDER BY asase_code DESC");
            DataTable dt = (DataTable)repositoryItemLookUpEditasase_code.DataSource;
            if (dt.Rows.Count == 0)
            {
                CodeFrm FrmCode = new CodeFrm(CodeFrm.TableNames.CD_AsaseACC) { Icon = FXFW.SqlDB.MakeIcon(imageCollection32.Images["CD_AsaseACC.png"], 32, false) };
                FrmCode.ShowDialog();
                Application.Exit();
            }
            else
            {
                barEditItemasase_code.EditValue = dt.Rows[0]["asase_code"];
                DevExpress.XtraEditors.Controls.ButtonPredefines btn = new DevExpress.XtraEditors.Controls.ButtonPredefines();
                btn = DevExpress.XtraEditors.Controls.ButtonPredefines.OK;
                repositoryItemLookUpEditasase_code_ButtonClick(repositoryItemLookUpEditasase_code, new DevExpress.XtraEditors.Controls.ButtonPressedEventArgs(new DevExpress.XtraEditors.Controls.EditorButton(btn)));
            }
        }
 private void LoadDefaultData(CodeFrm.TableNames TableName)
 {
     switch (TableName)
     {
         case CodeFrm.TableNames.CD_AgazaType:
             repositoryItemGridLookUpEditagaza_type_code.DataSource = SqlDB.LoadDataTable(@"SELECT AgazaTypeId, AgazaTypeName, AgazaTypeName_e FROM CD_AgazaType");
             repositoryItemGridLookUpEditagaza_type_code.DisplayMember = "AgazaTypeName";
             repositoryItemGridLookUpEditagaza_type_code.ValueMember = "AgazaTypeId";
             break;
         case CodeFrm.TableNames.All:
             //CD_Specialization
             repositoryItemGridLookUpEditagaza_type_code.DataSource = SqlDB.LoadDataTable(@"SELECT AgazaTypeId, AgazaTypeName, AgazaTypeName_e FROM CD_AgazaType");
             repositoryItemGridLookUpEditagaza_type_code.DisplayMember = "AgazaTypeName";
             repositoryItemGridLookUpEditagaza_type_code.ValueMember = "AgazaTypeId";
             //TBL_Emp
             repositoryItemGridLookUpEditEmpID.DataSource = SqlDB.LoadDataTable(@"SELECT EmpID, ISNULL(EMP_FIRST_NAME, '') + ' ' + ISNULL(EMP_FATHER_NAME, '') + ' ' + ISNULL(EMP_FAM_NAME, '') + ' ' + ISNULL(EMP_FOURTH_NAME, '') AS Emp_Name FROM TBL_Emp");
             repositoryItemGridLookUpEditEmpID.DisplayMember = "Emp_Name";
             repositoryItemGridLookUpEditEmpID.ValueMember = "EmpID";
             break;
         default:
             break;
     }
 }
 private void LoadDefaultData(CodeFrm.TableNames TableName)
 {
     switch (TableName)
     {
         case CodeFrm.TableNames.CD_EznType:
             repositoryItemGridLookUpEditEznTypeId.DataSource = SqlDB.LoadDataTable(@"SELECT EznTypeId, EznType, EznType_e FROM CD_EznType");
             repositoryItemGridLookUpEditEznTypeId.DisplayMember = "EznType";
             repositoryItemGridLookUpEditEznTypeId.ValueMember = "EznTypeId";
             break;
         case CodeFrm.TableNames.All:
             //TBL_Emp
             repositoryItemGridLookUpEditEmpID.DataSource = SqlDB.LoadDataTable(@"SELECT EmpID, EMP_FIRST_NAME + ' ' + EMP_FATHER_NAME + ' ' + EMP_FAM_NAME + ' ' + EMP_FOURTH_NAME AS Emp_Name FROM TBL_Emp");
             repositoryItemGridLookUpEditEmpID.DisplayMember = "Emp_Name";
             repositoryItemGridLookUpEditEmpID.ValueMember = "EmpID";
             //CD_EznType
             repositoryItemGridLookUpEditEznTypeId.DataSource = SqlDB.LoadDataTable(@"SELECT EznTypeId, EznType, EznType_e FROM CD_EznType");
             repositoryItemGridLookUpEditEznTypeId.DisplayMember = "EznType";
             repositoryItemGridLookUpEditEznTypeId.ValueMember = "EznTypeId";
             break;
         default:
             break;
     }
 }
Beispiel #6
0
 private void navBarItemAccCD_KastBnood_LinkClicked(object sender, NavBarLinkEventArgs e)
 {
     CodeFrm FrmCode = new CodeFrm(CodeFrm.TableNames.CD_KastBnood) { MdiParent = this, Icon = FXFW.SqlDB.MakeIcon(imageCollection32.Images["CD_KastBnood.png"], 32, false) };
     FrmCode.Show();
 }
 private void repositoryItemGridLookUpEditTakdeerId_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
 {
     if (e.Button.Kind != DevExpress.XtraEditors.Controls.ButtonPredefines.Plus)
         return;
     CodeFrm FrmCode = new CodeFrm(CodeFrm.TableNames.CDTakdeer);
     FrmCode.ShowDialog();
     LoadDefaultData(CodeFrm.TableNames.CDTakdeer);
 }