private void buttonItem2_Click(object sender, EventArgs e)
        {
            for (int n = 0; dataGridViewX1.Rows.Count - 1 > 0; n++)
            {
                #region Adder
                int      id             = 0;
                string   first_name     = ClassConvert.ConvString(dataGridViewX1.Rows[n].Cells[1].Value);
                string   Last_name      = ClassConvert.ConvString(dataGridViewX1.Rows[n].Cells[2].Value);
                string   Father_name    = ClassConvert.ConvString(dataGridViewX1.Rows[n].Cells[3].Value);
                string   Mather_name    = ClassConvert.ConvString(dataGridViewX1.Rows[n].Cells[4].Value);
                Int64    natiol_id      = ClassConvert.Convint64(dataGridViewX1.Rows[n].Cells[8].Value);
                bool     Gender         = ClassConvert.ConvBool(dataGridViewX1.Rows[n].Cells[5].Value);
                string   where_birth    = ClassConvert.ConvString(dataGridViewX1.Rows[n].Cells[6].Value);
                DateTime data_barthday  = ClassConvert.ConvDateTime(dataGridViewX1.Rows[n].Cells[7].Value);
                string   e_mail         = ClassConvert.ConvString(dataGridViewX1.Rows[n].Cells[18].Value);
                int      Phone_Ground   = ClassConvert.Convint(dataGridViewX1.Rows[n].Cells[20].Value);
                int      Phone_Mobile1  = ClassConvert.Convint(dataGridViewX1.Rows[n].Cells[19].Value);
                string   study          = ClassConvert.ConvString(dataGridViewX1.Rows[n].Cells[9].Value);
                int      yearstudy      = ClassConvert.Convint(dataGridViewX1.Rows[n].Cells[10].Value);
                int      Id_course      = ClassConvert.Convint(dataGridViewX1.Rows[n].Cells[0].Value);
                string   Id_course_Ware = ClassConvert.ConvString(dataGridViewX1.Rows[n].Cells[21].Value);
                DateTime data_regs      = ClassConvert.ConvDateTime(dataGridViewX1.Rows[n].Cells[17].Value);
                int      bitd_id        = ClassConvert.Convint(dataGridViewX1.Rows[n].Cells[11].Value);
                string   nameEnglish    = ClassConvert.ConvString(dataGridViewX1.Rows[n].Cells[12].Value);
                int      Z1             = ClassConvert.Convint(dataGridViewX1.Rows[n].Cells[13].Value);
                int      z2             = ClassConvert.Convint(dataGridViewX1.Rows[n].Cells[14].Value);
                int      z3             = ClassConvert.Convint(dataGridViewX1.Rows[n].Cells[15].Value);
                string   Hanei_whare    = "";
                string   Hanei_whare1   = "";
                string   adderas        = "";

                int    Stutes_Jtma3  = ClassConvert.Convint(dataGridViewX1.Rows[n].Cells[16].Value);
                int    Phone_Mobile2 = 0;
                string Facebook      = "";
                int    whatsApp      = 0;
                int    viper         = 0;
                string Twiter        = "";

                System.Drawing.Image Image_id_nationl1 = null;
                System.Drawing.Image Image_id_nationl2 = null;
                System.Drawing.Image image             = null;
                System.Drawing.Image Image_font        = null;

                string Nkname = "";


                System.Xml.XmlDataDocument XmlHobbies = null;;

                /*
                 * string[] liststring = System.IO.Directory.GetFiles(".\\", "Hobbis1.xml", System.IO.SearchOption.AllDirectories);
                 * XmlHobbies.Load(liststring[0]);*/
                #endregion
                Vitl vitltemp = 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.SqlSaveVitl(vitltemp.adder());
            }
        }
        public static List <NameOfCouress> GetAll()
        {
            List <NameOfCouress> Lista = new List <NameOfCouress>();

            System.Data.SqlClient.SqlCommand SqlComm = new System.Data.SqlClient.SqlCommand("SELECT [Id],[dataStart],[DataENd],[Suport],[Id_TypeofCouress_ta]   ,[Decrption] ,[IntCoures] , WhereIS FROM [HR_SARC].[dbo].[NameOfCouress_ta] where [Delete] = 0");
            Task <List <List <object> > >    temp    = Sqldatabasethrding.GetSql(SqlComm);

            while (!temp.IsCompleted)
            {
            }

            List <List <object> > Adw = temp.Result;

            for (int i = 0; i < Adw.Count; i++)
            {
                if (Adw[i].Count != 0)
                {
                    Lista.Add(new NameOfCouress(Convert.ToInt32(Adw[i][0]), ClassConvert.ConvDateTime(Adw[i][1]), ClassConvert.ConvDateTime(Adw[i][2]), ClassConvert.ConvBool(Adw[i][3]), Convert.ToInt32(Adw[i][4]), Convert.ToString(Adw[i][5]), Convert.ToInt32(Adw[i][6]), Convert.ToInt32(Adw[i][7])));
                }
            }

            return(Lista);
        }
        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()); }
        }