Exemple #1
0
        private void buttonX1_Click(object sender, EventArgs e)
        {
            if (CouressEdit == null && ToAddInCores == false)
            {
                CouressEdit = new Couress(CountOfNew, EditTame.SerchByComBBox(comboBoxEx2, NameOfCouress.NameOfCouresslist), this.idVite, ClassConvert.Convint(NumberOfdayregest.Text), Convert.ToSingle(Result.Text));
                CountOfNew--;
                this.DialogResult = System.Windows.Forms.DialogResult.Yes;
            }

            else if (CouressEdit == null && ToAddInCores && comboBoxEx1.AutoCompleteCustomSource.IndexOf(comboBoxEx1.Text) != -1)
            {
                CouressEdit = new Couress(CountOfNew, this.idVite, intList[comboBoxEx1.AutoCompleteCustomSource.IndexOf(comboBoxEx1.Text)], ClassConvert.Convint(NumberOfdayregest.Text), Convert.ToSingle(Result.Text));
                CountOfNew--;
                this.DialogResult = System.Windows.Forms.DialogResult.Yes;
            }
            else if (ToAddInCores == false)
            {
                CouressEdit.Eidt(EditTame.SerchByComBBox(comboBoxEx2, NameOfCouress.NameOfCouresslist), this.idVite, ClassConvert.Convint(NumberOfdayregest.Text), Convert.ToSingle(Result.Text));
                this.DialogResult = System.Windows.Forms.DialogResult.OK;
            }
            else if (ToAddInCores && comboBoxEx1.AutoCompleteCustomSource.IndexOf(comboBoxEx1.Text) != -1)
            {
                CouressEdit.Eidt(intList[comboBoxEx1.SelectedIndex], this.idVite, ClassConvert.Convint(NumberOfdayregest.Text), Convert.ToSingle(Result.Text));
                this.DialogResult = System.Windows.Forms.DialogResult.OK;
            }

            this.Close();
        }
        private void buttonX1_Click(object sender, EventArgs e)
        {
            Sqldatabasethrding.SqlAddOrUpdateOrDelet(ClassConvert.ConvertListInterfaseToDataBase(CouressList), IntAdderCoress, IntEditCoress, IntDeletCoress);
            CouressList = Couress.GetByNameOfCores(NameOfCouress.id);
            VitlByIdList.Clear();
            foreach (Couress Couressv in CouressList)
            {
                VitlByIdList.Add(Vitl.VitlIdAndName(Couressv.Id_Information));
            }

            ClassDataGridViewDo.DataGridEnterGridToWorkNameOfCouress_ta(dataGridViewX1, CouressList, VitlByIdList);
        }
        private async void IDCartOut_Load(object sender, EventArgs e)
        {
            foreach (int item in id_information)
            {
                Vitl dw2 = new Vitl();

                await dw2.MakeAsn(item);

                Vitl1.Add(dw2);
                Team1.Add((await(Team.GetByIdVil(item, true)))[0]);
                ifHaveCores72.Add(await Couress.GetIsItHaveCouresByIdInformation(item, 3, true));

                dataGridViewX1.Rows.Add(Vitl1[Vitl1.Count - 1].id, "ALP-" + ClassConvert.ConvIdNumberAdderZero4Digit(Vitl1[Vitl1.Count - 1].Id_course), Vitl1[Vitl1.Count - 1].first_name + " " + Vitl1[Vitl1.Count - 1].Last_name, ClassConvert.ConvStringBoloed(Vitl1[Vitl1.Count - 1].Boold_id), Jop.JopStatic[ClassDataGridViewDo.RetunIndexByIdSech(Team1[Team1.Count - 1].Id_Jop_Ta, Jop.JopStatic)].NvacherWord, Jop.JopStatic[ClassDataGridViewDo.RetunIndexByIdSech(Team1[Team1.Count - 1].Id_Jop_Ta, Jop.JopStatic)].NvacherWordEng,
                                        Vitl1[Vitl1.Count - 1].data_barthday.Year.ToString(), Vitl1[Vitl1.Count - 1].nameEnglish);
            }
            MegBox.Show("إنتها");
        }
        private void Corser_Load(object sender, EventArgs e)
        {
            EditTame.AdderComvbox(comboBoxEx1, TypeofCouress.TypeofCouressList);
            if (NameOfCouress == null)
            {
            }
            else
            {
                Type                      = NameOfCouress.Id_TypeofCouress_ta;
                textBoxX1.Text            = NameOfCouress.Decrption;
                comboBoxEx1.SelectedIndex = ClassDataGridViewDo.RetunIndexByIdSech(NameOfCouress.Id_TypeofCouress_ta, TypeofCouress.TypeofCouressList);
                comboBoxEx1.Enabled       = false;
                CouressList               = Couress.GetByNameOfCores(NameOfCouress.id);

                foreach (Couress Couressv in CouressList)
                {
                    VitlByIdList.Add(Vitl.VitlIdAndName(Couressv.Id_Information));
                }

                ClassDataGridViewDo.DataGridEnterGridToWorkNameOfCouress_ta(dataGridViewX1, CouressList, VitlByIdList);
            }
        }
Exemple #5
0
 private async void GetDateByID_Load(object sender, EventArgs e)
 {
     if (id != null)
     {
         for (int i = 0; i < id.Count; i++)
         {
             Vite.Add(new Vitl());
             await Vite[Vite.Count - 1].MakeAsn(id[i]);
             ClassDataGridViewDo.DataGridEnterGridForGetdateByID(dataGridViewX1, Vite[Vite.Count - 1], await Team.GetByIdVil(Vite[Vite.Count - 1].id, true), Couress.GetByIdVil(Vite[Vite.Count - 1].id, true));
         }
     }
 }
Exemple #6
0
        private async void buttonX1_Click(object sender, EventArgs e)
        {
            SerchNameBynameRetu SerchNameBynameRetu1 = new SerchNameBynameRetu();

            if (SerchNameBynameRetu1.ShowDialog() == System.Windows.Forms.DialogResult.OK)
            {
                Vite.Add(new Vitl(SerchNameBynameRetu1.Id));
            }

            ClassDataGridViewDo.DataGridEnterGridForGetdateByID(dataGridViewX1, Vite[Vite.Count - 1], await Team.GetByIdVil(Vite[Vite.Count - 1].id, true), Couress.GetByIdVil(Vite[Vite.Count - 1].id, true));
        }
        /// <summary>
        /// من أجل البحث المتقم
        /// </summary>
        /// <param name="Stringa">الأسم</param>
        /// <param name="SerchAdvaCoursClass">كلاس البحث المتقدم</param>
        /// <param name="idJop">مصفوفة المناصب</param>
        /// <param name="IdTeam">مصفوفة الفرق</param>
        /// <param name="ActivVitel">هل المتطوع فعال</param>
        /// <param name="InformationSelect"></param>
        /// <param name="SqlCmaand"></param>
        /// <param name="DataGridViewX1"></param>
        /// <param name="DateFrom"></param>
        /// <param name="DateEnd"></param>
        /// <returns></returns>
        public static async Task WaitSqlsersh(string Stringa, SerchAdvaCoursClass SerchAdvaCoursClass, List <int> idJop, List <int> IdTeam, bool ActivVitel, string InformationSelect, SqlCommand SqlCmaand, DevComponents.DotNetBar.Controls.DataGridViewX DataGridViewX1, DateTime DateFrom, DateTime DateEnd)
        {
            await openConction();

            SqlCommand sqlcom1 = null;

            sqlcom1 = Vitl.SerchRetIdInformation(Stringa, InformationSelect, SqlCmaand, DateFrom, DateEnd);

            sqlcom1.Connection = SqlConnection1;
            IAsyncResult result = sqlcom1.BeginExecuteReader();

            SqlDataReader reader = sqlcom1.EndExecuteReader(result);

            DataGridViewX1.Rows.Clear();

            List <IDinformationAdvSrchFullCoures> IDinformationAdvSrchListProsses = new List <IDinformationAdvSrchFullCoures>();

            try
            {
                int NumberDub = reader.FieldCount;


                while (await reader.ReadAsync())
                {
                    IDinformationAdvSrchListProsses.Add(new IDinformationAdvSrchFullCoures(reader.GetInt32(0)));
                }
            }


            catch (Exception e)
            {
                MessageBox.Show(e.ToString());
            }

            finally
            {
                reader.Close();
            }
            ///هاد من شان البحث هل المتطوع لديه هذا المنصب
            for (int i = 0; i < idJop.Count; i++)
            {
                for (int j = 0; j < IDinformationAdvSrchListProsses.Count; j++)
                {
                    if (await Team.RetHaveVitelJop(IDinformationAdvSrchListProsses[j].idinformation, idJop[i]))
                    {
                        IDinformationAdvSrchListProsses[j].AddJop(idJop[i]);
                    }
                }
            }
            // هاد من أجل البحث هل المتطوع لديه الدوره
            for (int i = 0; i < SerchAdvaCoursClass.idTypeofcorsSerch.Count; i++)
            {
                for (int j = 0; j < IDinformationAdvSrchListProsses.Count; j++)
                {
                    if (await Couress.GetIsItHaveCouresByIdInformation(IDinformationAdvSrchListProsses[j].idinformation, SerchAdvaCoursClass.idTypeofcorsSerch[i], true, !SerchAdvaCoursClass.idTypeofcorsSerchbool[i]))
                    {
                        IDinformationAdvSrchListProsses[j].AddCoures(SerchAdvaCoursClass.idTypeofcorsSerch[i]);
                    }
                }
            }
            //هل هذا المتطوع في الفريق
            for (int i = 0; i < IdTeam.Count; i++)
            {
                for (int j = 0; j < IDinformationAdvSrchListProsses.Count; j++)
                {
                    if (await Team.RetHaveVitelTeam(IDinformationAdvSrchListProsses[j].idinformation, IdTeam[i]))
                    {
                        IDinformationAdvSrchListProsses[j].AddTeam(IdTeam[i]);
                    }
                }
            }
            ///من أجل المتطوعين الفعالين
            if (ActivVitel)
            {
                for (int j = 0; j < IDinformationAdvSrchListProsses.Count; j++)
                {
                    if (await Team.RetHaveVitelACtiv(IDinformationAdvSrchListProsses[j].idinformation))
                    {
                        IDinformationAdvSrchListProsses[j].SetAtciv();
                    }
                }
            }

            List <IDinformationAdvSrchFullCoures> IDView = await IDinformationAdvSrchFullCoures.GetHaveAll(SerchAdvaCoursClass.idTypeofcorsSerch, idJop, IdTeam, ActivVitel, IDinformationAdvSrchListProsses);

            List <List <object> > obj = new List <List <object> > ();

            obj = await Sqldatabasethrding.GetSql(Vitl.Serhid(IDView));



            foreach (List <object> item in obj)
            {
                int i = 0;
                DataGridViewX1.Rows.Add(item[i].ToString(), item[++i].ToString(), item[++i].ToString(), item[++i].ToString(), item[++i].ToString(), item[++i].ToString(), item[++i].ToString(), item[++i].ToString());
            }
        }
        private async void RibbonForm2_Load(object sender, EventArgs e)
        {
            #region تحميل الفريم الأولي

            #region تحميل معلومات الأساسية للجدول الفريق
            ClassDataGridViewDo.DataGridAddVuleComBoxEx((DataGridViewComboBoxExColumn)dataGridViewX1.Columns["TeamTeam"], NameTeamType.NameTeamTypeStatic, NameTeam.NameTeamStatic);
            ClassDataGridViewDo.DataGridAddVuleComBoxEx((DataGridViewComboBoxExColumn)dataGridViewX1.Columns["TeamJop"], Jop.JopStatic);
            ClassDataGridViewDo.DataGridAddVuleComBoxEx((DataGridViewComboBoxExColumn)dataGridViewX2.Columns["id_NameOfCouress"], NameOfCouress.NameOfCouresslist);
            ClassDataGridViewDo.DataGridAddVuleComBoxEx((DataGridViewComboBoxExColumn)dataGridViewX1.Columns["TeamStatus"], Team.Setwation);

            #endregion


            /// في كان ت
            if (idvite != 0)
            {
                #region تحميل المعلومات في حال كان هناك مستخدم للتعديل
                #region معلومات العامة
                vitl1                         = new Vitl(idvite);
                first_name.Text               = vitl1.first_name;
                Last_name.Text                = vitl1.Last_name;
                Father_name.Text              = vitl1.Father_name;
                Mather_name.Text              = vitl1.Mather_name;
                natiol_id.Text                = ClassConvert.ConvToIdNational(vitl1.natiol_id);
                Gender.SelectedIndex          = ClassConvert.ConvGenderBoolNull(vitl1.Gender);
                where_birth.Text              = vitl1.where_birth;
                data_barthday.Value           = vitl1.data_barthday;
                Hanei_whare.Text              = vitl1.Hanei_whare;
                Hanei_whare1.Text             = vitl1.Hanei_whare1;
                adderas.Text                  = vitl1.adderas;
                e_mail.Text                   = vitl1.e_mail;
                Stutes_Jtma3.SelectedIndex    = vitl1.Stutes_Jtma3;
                Phone_Ground.Text             = vitl1.Phone_Ground.ToString();
                Phone_Mobile1.Text            = vitl1.Phone_Mobile1.ToString();
                Phone_Mobile2.Text            = vitl1.Phone_Mobile2.ToString();
                Facebook.Text                 = vitl1.Facebook;
                Twiter.Text                   = vitl1.Twiter;
                whatsApp.Text                 = vitl1.whatsApp.ToString();
                viper.Text                    = vitl1.viper.ToString();
                study.Text                    = vitl1.study;
                yearstudy.SelectedIndex       = vitl1.yearstudy;
                Id_course.Text                = vitl1.Id_course.ToString();
                Id_course_Ware.Text           = vitl1.Id_course_Ware;
                data_regs.Value               = vitl1.data_regs;
                Image_id_nationl1.Image       = vitl1.Image_id_nationl1;
                Image_id_nationl2.Image       = vitl1.Image_id_nationl2;
                image.Image                   = vitl1.image;
                image1.Image                  = vitl1.image;
                Image_font.Image              = vitl1.Image_font;
                bitd_id.SelectedIndex         = vitl1.Boold_id;
                Nkname.Text                   = vitl1.Nkname;
                nameEnglish.Text              = vitl1.nameEnglish;
                Z1.SelectedIndex              = vitl1.Z1;
                z2.Text                       = vitl1.z2.ToString();
                z3.SelectedIndex              = vitl1.z3;
                this.dataGridView7.DataSource = vitl1.XmlHobbies;
                #endregion
                #region الفريق

                /////إضافة الفريق إلى جدول الفرق
                EditTame.CountOfNew = 0;
                TeamList            = await Team.GetByIdVil(idvite);

                ClassDataGridViewDo.DataGridEnterGridToWorkTeam(dataGridViewX1, TeamList);
                #endregion
                #region الدورات
                CoresEditAdder.CountOfNew = 0;
                CouressList = Couress.GetByIdVil(idvite);
                ClassDataGridViewDo.DataGridEnterGridToWorkCorser(dataGridViewX2, CouressList);
                #endregion
                #region المواد

                WereDeliveryList = WereDelivery.GetByIdVil(idvite);
                ClassDataGridViewDo.DataGridEnterGridToWorkWereDelivery(dataGridViewX3, WereDeliveryList);

                #endregion

                #region المواد

                ValuationList = Valuation.GetByIdVil(idvite);
                ClassDataGridViewDo.DataGridEnterGridToWorkValuation(dataGridViewX4, ValuationList);

                #endregion
                #endregion
            }
            else
            {
                this.Text = "تسجيل متطوع جديد";
            }

            #endregion
            needSeaving = false;
        }
        private async System.Threading.Tasks.Task SaveNewOrUpdate()
        {
            try
            {
                if (idvite == 0)
                {
                    #region تسجيل متطوع جديد

                    #region المتغيرات للكلاس المعلومات الأساسية
                    int                        id                = 0;
                    string                     first_name        = this.first_name.Text;
                    string                     Last_name         = this.Last_name.Text;
                    string                     Father_name       = this.Father_name.Text;
                    string                     Mather_name       = this.Mather_name.Text;
                    Int64                      natiol_id         = ClassConvert.Convint64(this.natiol_id.Text);
                    bool                       Gender            = ClassConvert.ConvBool(this.Gender.SelectedIndex);
                    string                     where_birth       = this.where_birth.Text;
                    DateTime                   data_barthday     = ClassConvert.ConvDateTime(this.data_barthday.Value);
                    string                     Hanei_whare       = this.Hanei_whare.Text;
                    string                     Hanei_whare1      = this.Hanei_whare1.Text;
                    string                     adderas           = this.adderas.Text;
                    string                     e_mail            = this.e_mail.Text;
                    int                        Stutes_Jtma3      = this.Stutes_Jtma3.SelectedIndex;
                    int                        Phone_Ground      = ClassConvert.Convint(this.Phone_Ground.Text);
                    int                        Phone_Mobile1     = ClassConvert.Convint(this.Phone_Mobile1.Text);
                    int                        Phone_Mobile2     = ClassConvert.Convint(this.Phone_Mobile2.Text);
                    string                     Facebook          = this.Facebook.Text;
                    int                        whatsApp          = ClassConvert.Convint(this.whatsApp.Text);
                    int                        viper             = ClassConvert.Convint(this.viper.Text);
                    string                     Twiter            = (this.Twiter.Text);
                    string                     study             = this.study.Text;
                    int                        yearstudy         = this.yearstudy.SelectedIndex;
                    int                        Id_course         = ClassConvert.Convint(this.Id_course.Text);
                    string                     Id_course_Ware    = this.Id_course_Ware.Text;
                    DateTime                   data_regs         = ClassConvert.ConvDateTime(this.data_regs.Value);
                    System.Drawing.Image       Image_id_nationl1 = ClassConvert.ConvImage(this.Image_id_nationl1.Image);
                    System.Drawing.Image       Image_id_nationl2 = ClassConvert.ConvImage(this.Image_id_nationl2.Image);
                    System.Drawing.Image       image             = ClassConvert.ConvImage(this.image.Image);
                    System.Drawing.Image       Image_font        = ClassConvert.ConvImage(this.Image_font.Image);
                    int                        bitd_id           = this.bitd_id.SelectedIndex;
                    string                     Nkname            = this.Nkname.Text;
                    string                     nameEnglish       = this.nameEnglish.Text;
                    int                        Z1                = this.Z1.SelectedIndex;
                    int                        z2                = ClassConvert.Convint(this.z2.Text);
                    int                        z3                = this.z3.SelectedIndex;
                    System.Xml.XmlDataDocument XmlHobbies        = null;



                    vitl1 = new Vitl(id, first_name, Last_name, Father_name, Mather_name, natiol_id, Gender, where_birth, data_barthday, Hanei_whare, Hanei_whare1, adderas, e_mail, Stutes_Jtma3, Phone_Ground, Phone_Mobile1, Phone_Mobile2, Facebook, Twiter, whatsApp, viper, study, yearstudy, Id_course, Id_course_Ware, data_regs, Image_id_nationl1, Image_id_nationl2, image, Image_font, bitd_id, Nkname, nameEnglish, Z1, z2, z3, XmlHobbies);

                    Sqldatabasethrding.SqlSaveAdderAndBack(vitl1);


                    idvite = vitl1.id;//تاكد من عمل الصحيح للبرنامج

                    #endregion

                    #region إضافة وتعديل الفرق
                    EditTame.CountOfNew = 0;
                    foreach (Team IdInfoAdder in TeamList)
                    {
                        IdInfoAdder.EdidInfoId(idvite);
                    }
                    await Sqldatabasethrding.SqlAddOrUpdateOrDelet(ClassConvert.ConvertListInterfaseToDataBase(TeamList), IntAdderTeam, IntEditTeam, IntDeletTeam);

                    #endregion

                    #region إضافة وتعديل الدورات
                    CoresEditAdder.CountOfNew = 0;
                    foreach (Couress IdInfoAdder in CouressList)
                    {
                        IdInfoAdder.EdidInfoId(idvite);
                    }
                    await Sqldatabasethrding.SqlAddOrUpdateOrDelet(ClassConvert.ConvertListInterfaseToDataBase(CouressList), IntAdderCoress, IntEditCoress, IntDeletCoress);

                    #endregion

                    #endregion
                }
                else
                {
                    #region تعديلات العلومات العامة

                    #region المتغيرات

                    string                     first_name        = this.first_name.Text;
                    string                     Last_name         = this.Last_name.Text;
                    string                     Father_name       = this.Father_name.Text;
                    string                     Mather_name       = this.Mather_name.Text;
                    Int64                      natiol_id         = ClassConvert.Convint64(this.natiol_id.Text);
                    bool                       Gender            = ClassConvert.ConvBool(this.Gender.SelectedIndex);
                    string                     where_birth       = this.where_birth.Text;
                    DateTime                   data_barthday     = ClassConvert.ConvDateTime(this.data_barthday.Value);
                    string                     Hanei_whare       = this.Hanei_whare.Text;
                    string                     Hanei_whare1      = this.Hanei_whare1.Text;
                    string                     adderas           = this.adderas.Text;
                    string                     e_mail            = this.e_mail.Text;
                    int                        Stutes_Jtma3      = this.Stutes_Jtma3.SelectedIndex;
                    int                        Phone_Ground      = ClassConvert.Convint(this.Phone_Ground.Text);
                    int                        Phone_Mobile1     = ClassConvert.Convint(this.Phone_Mobile1.Text);
                    int                        Phone_Mobile2     = ClassConvert.Convint(this.Phone_Mobile2.Text);
                    string                     Facebook          = this.Facebook.Text;
                    int                        whatsApp          = ClassConvert.Convint(this.whatsApp.Text);
                    int                        viper             = ClassConvert.Convint(this.viper.Text);
                    string                     Twiter            = (this.Twiter.Text);
                    string                     study             = this.study.Text;
                    int                        yearstudy         = this.yearstudy.SelectedIndex;
                    int                        Id_course         = ClassConvert.Convint(this.Id_course.Text);
                    string                     Id_course_Ware    = this.Id_course_Ware.Text;
                    DateTime                   data_regs         = ClassConvert.ConvDateTime(this.data_regs.Value);
                    System.Drawing.Image       Image_id_nationl1 = ClassConvert.ConvImage(this.Image_id_nationl1.Image);
                    System.Drawing.Image       Image_id_nationl2 = ClassConvert.ConvImage(this.Image_id_nationl2.Image);
                    System.Drawing.Image       image             = ClassConvert.ConvImage(this.image.Image);
                    System.Drawing.Image       Image_font        = ClassConvert.ConvImage(this.Image_font.Image);
                    int                        bitd_id           = this.bitd_id.SelectedIndex;
                    string                     Nkname            = this.Nkname.Text;
                    string                     nameEnglish       = this.nameEnglish.Text;
                    int                        Z1         = this.Z1.SelectedIndex;
                    int                        z2         = ClassConvert.Convint(this.z2.Text);
                    int                        z3         = this.z3.SelectedIndex;
                    System.Xml.XmlDataDocument XmlHobbies = null;

                    #endregion

                    vitl1.UpdateOUtid(first_name, Last_name, Father_name, Mather_name, natiol_id, Gender, where_birth, data_barthday, Hanei_whare, Hanei_whare1, adderas, e_mail, Stutes_Jtma3, Phone_Ground, Phone_Mobile1, Phone_Mobile2, Facebook, Twiter, whatsApp, viper, study, yearstudy, Id_course, Id_course_Ware, data_regs, Image_id_nationl1, Image_id_nationl2, image, Image_font, bitd_id, Nkname, nameEnglish, Z1, z2, z3, XmlHobbies);

                    await Sqldatabasethrding.SqlupdataVitl(vitl1.updata());

                    #endregion


                    #region إضافة وتعديل الفرق
                    await Sqldatabasethrding.SqlAddOrUpdateOrDelet(ClassConvert.ConvertListInterfaseToDataBase(TeamList), IntAdderTeam, IntEditTeam, IntDeletTeam);

                    #endregion


                    #region إضافة وتعديل الدورات
                    await Sqldatabasethrding.SqlAddOrUpdateOrDelet(ClassConvert.ConvertListInterfaseToDataBase(CouressList), IntAdderCoress, IntEditCoress, IntDeletCoress);

                    #endregion


                    #region إضافة وتعديل وحذف الأستلامات
                    await Sqldatabasethrding.SqlAddOrUpdateOrDelet(ClassConvert.ConvertListInterfaseToDataBase(WereDeliveryList), IntAdderWere, IntEditWere, IntDeletWere);

                    #endregion
                }

                /////Loed Team Grid
                EditTame.CountOfNew = 0;
                TeamList            = await Team.GetByIdVil(idvite);

                ClassDataGridViewDo.DataGridEnterGridToWorkTeam(dataGridViewX1, TeamList);
                ////Loed Coures Grid
                CoresEditAdder.CountOfNew = 0;
                CouressList = Couress.GetByIdVil(idvite);
                ClassDataGridViewDo.DataGridEnterGridToWorkCorser(dataGridViewX2, CouressList);
                #region التقيم


                ValuationList = Valuation.GetByIdVil(idvite);
                ClassDataGridViewDo.DataGridEnterGridToWorkValuation(dataGridViewX4, ValuationList);

                #endregion



                MegBox.Show("تم التعديل", this);
            }
            catch (Exception xv)
            { MessageBox.Show(xv.ToString()); }
        }
        public async void ForRunThrading()
        {
            try
            {
                dataGridViewX1.Enabled = false;

                ClassDataGridViewDo.ClumChekArray(NameCol, dataGridViewX1);
                progressBarX1.Maximum = dataGridViewX1.Rows.Count;
                int       IndexCombox = comboBoxEx1.SelectedIndex;
                Stopwatch stopwatch   = new Stopwatch();

                stopwatch.Start();
                for (int i = 0; i < dataGridViewX1.Rows.Count; i++)
                {
                    stopwatch.Restart();
                    // إيقاف العمل في خلفية التزامن
                    if (!Workin)
                    {
                        break;
                    }
                    //العداد
                    progressBarX1.Value = i;
                    // إنتظار بين الأمر والثاني
                    await System.Threading.Tasks.Task.Delay(100);



                    int   id             = ClassConvert.Convint(dataGridViewX1.Rows[i].Cells["id"].Value);
                    int   NumberOfCoures = ClassConvert.Convint(dataGridViewX1.Rows[i].Cells["رقم الدورة"].Value);
                    int?  NuberOfDayes   = ClassConvert.ConvintNull(dataGridViewX1.Rows[i].Cells["عدد الأيام"].Value);
                    float?float1         = ClassConvert.ConvFloatNull(dataGridViewX1.Rows[i].Cells["النتيجة"].Value);
                    //أختبار هل الدورة مسجل عند الشخص + أنه تأكد من وجود ID
                    if (!await Couress.GetIsItHaveCouresByIdInformation(id, IndexCombox))
                    {
                        if (id > 0 && NumberOfCoures > 0 && NuberOfDayes != null && float1 != null)
                        {
                            int IdTheNameOfcoures = NameOfCouress.SerchByListStaticRetId(TypeofCouress.TypeofCouressList[IndexCombox].id, NumberOfCoures);
                            if (IdTheNameOfcoures == -1)
                            {
                                DevComponents.DotNetBar.MessageBoxEx.Show("رقم الدورة غير مضاف:" + NumberOfCoures);
                                break;
                            }


                            Couress CouresNew = new Couress(0, IdTheNameOfcoures, id, (int)NuberOfDayes, (float)float1);
                            await Sqldatabasethrding.SqlSaveVitl(CouresNew.adder());

                            dataGridViewX1.Rows[i].DefaultCellStyle.BackColor = Color.Green;
                        }
                        else
                        {
                            dataGridViewX1.Rows[i].DefaultCellStyle.BackColor = Color.Red;
                        }
                    }
                    else
                    {
                        dataGridViewX1.Rows[i].DefaultCellStyle.BackColor = Color.Yellow;
                    }

                    labelX2.Text = ((stopwatch.ElapsedMilliseconds * (dataGridViewX1.Rows.Count - i)) / 1000).ToString();
                }
            }
            catch (NoColumnsException ex)
            {
                ErrorClass.SaveErrorFile(ex);
                MessageBox.Show(string.Format(" لا يوجد عامود {0} ", ex.Message));
            }
            catch (Exception ex)
            {
                ErrorClass.SaveErrorFile(ex);
            }

            buttonX3.Enabled       = true;
            Workin                 = false;
            dataGridViewX1.Enabled = true;
        }
        public static void DataGridEnterGridToWorkNameOfCouress_ta(DevComponents.DotNetBar.Controls.DataGridViewX Grid, Couress TeamClassList, IdAndName nameInfrma)
        {
            DevComponents.DotNetBar.Controls.DataGridViewComboBoxExColumn id_NameOfCouress = (DevComponents.DotNetBar.Controls.DataGridViewComboBoxExColumn)Grid.Columns["id_NameOfCouress"];

            Grid.Rows.Add(TeamClassList.id, nameInfrma.Name, TeamClassList.NumberOfdayregest, TeamClassList.Result);
        }