コード例 #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();
        }
コード例 #2
0
        private async void buttonX2_Click(object sender, EventArgs e)
        {
            if (!dataGridViewX1.Columns.Contains("تاريخ1"))
            {
                dataGridViewX1.Columns.Add("تاريخ1", "تاريخ");
            }

            if (!dataGridViewX1.Columns.Contains("تاريخ2"))
            {
                dataGridViewX1.Columns.Add("تاريخ2", "تاريخ");
            }

            if (!dataGridViewX1.Columns.Contains("الاسم1"))
            {
                dataGridViewX1.Columns.Add("الاسم1", "تاريخ");
            }

            for (int i = 0; i < dataGridViewX1.Rows.Count; i++)
            {
                if (ClassConvert.Convint(dataGridViewX1.Rows[i].Cells["id"].Value) > 0)
                {
                    IdAndName vit = await Vitl.GetbyidIdAndName(ClassConvert.Convint(dataGridViewX1.Rows[i].Cells["id"].Value));

                    dataGridViewX1.Rows[i].Cells["الاسم1"].Value = vit.Name;
                    dataGridViewX1.Rows[i].Cells["تاريخ1"].Value = vit.Regesterdeg.ToShortDateString();

                    dataGridViewX1.Rows[i].Cells["تاريخ2"].Value = vit.Regesterdeg.ToLongDateString();
                }
            }
        }
コード例 #3
0
        private void buttonX2_Click(object sender, EventArgs e)
        {
            if (!dataGridViewX1.Columns.Contains("id"))
            {
                dataGridViewX1.Columns.Add("Id", "id");
            }

            for (int i = 0; i < dataGridViewX1.Rows.Count; i++)
            {
                if (ClassConvert.Convint(dataGridViewX1.Rows[i].Cells["id"].Value) <= 0)
                {
                    string name = Convert.ToString(dataGridViewX1.Rows[i].Cells["الاسم"].Value);

                    SerchNameBynameRetu SerchNameBynameRetu = new SerchNameBynameRetu();

                    SerchNameBynameRetu.sech = name;
                    SerchNameBynameRetu.DoWorkOff();

                    if (SerchNameBynameRetu.Id > 0)
                    {
                        dataGridViewX1.Rows[i].Cells["id"].Value = SerchNameBynameRetu.Id;
                    }
                    else
                    {
                        SerchNameBynameRetu.Text = name;
                        if (SerchNameBynameRetu.ShowDialog() == System.Windows.Forms.DialogResult.OK)
                        {
                            dataGridViewX1.Rows[i].Cells["id"].Value = SerchNameBynameRetu.Id;
                        }
                    }
                }
            }
        }
コード例 #4
0
        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());
            }
        }
コード例 #5
0
ファイル: Form1.cs プロジェクト: Sandy4321/Human-Resources-1
        private void buttonX3_Click_1(object sender, EventArgs e)
        {
            if (!dataGridViewX1.Columns.Contains("موجودأم لا"))
            {
                dataGridViewX1.Columns.Add("موجودأم لا", "موجودأم لا");
            }

            for (int i = 0; i < dataGridViewX1.Rows.Count - 1; i++)
            {
                progressBarX1.BeginInvoke(new Prosser(NewProsserVaul), i);

                if (ClassConvert.Convint64(dataGridViewX1.Rows[i].Cells[listStringNkname2[4]].Value) > 0)
                {
                    if (Vitl.GetIf(ClassConvert.Convint64(dataGridViewX1.Rows[i].Cells[listStringNkname2[4]].Value)))
                    {
                        dataGridViewX1.Rows[i].Cells["موجودأم لا"].Value = "غير موجود رقم وطني";
                        goto end;
                    }
                    else
                    {
                        dataGridViewX1.Rows[i].Cells["موجودأم لا"].Value = "موجود رقم وطني";
                        goto end;
                    }
                }

                if (Convert.ToString(dataGridViewX1.Rows[i].Cells[listStringNkname2[11]].Value) != "")
                {
                    if (Vitl.GetIfEmail(Convert.ToString(dataGridViewX1.Rows[i].Cells[listStringNkname2[11]].Value)))
                    {
                        dataGridViewX1.Rows[i].Cells["موجودأم لا"].Value = "غير موجود Email";
                        goto end;
                    }
                    else
                    {
                        dataGridViewX1.Rows[i].Cells["موجودأم لا"].Value = " موجود Email";
                        goto end;
                    }
                }

                if (ClassConvert.Convint(dataGridViewX1.Rows[i].Cells[listStringNkname2[14]].Value) != 0)
                {
                    if (Vitl.GetIfmobilephon(ClassConvert.Convint(dataGridViewX1.Rows[i].Cells[listStringNkname2[11]].Value)))
                    {
                        dataGridViewX1.Rows[i].Cells["موجودأم لا"].Value = " غير موجود رقم هاتف";
                        goto end;
                    }
                    else
                    {
                        dataGridViewX1.Rows[i].Cells["موجودأم لا"].Value = "موجود رقم هاتف";
                        goto end;
                    }
                }

                dataGridViewX1.Rows[i].Cells["موجودأم لا"].Value = "لا يوجد وسيلة تحقق أبدا";
                end :;
            }
        }
コード例 #6
0
 private void dataGridViewX1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
 {
     if (e.RowIndex >= 0)
     {
         RibbonForm2 Detalis1 = new RibbonForm2();
         this.Opacity    = 0.5;
         Detalis1.idvite = ClassConvert.Convint(dataGridViewX1.Rows[e.RowIndex].Cells[0].Value);
         Detalis1.ShowDialog();
         this.Opacity = 1;
     }
 }
コード例 #7
0
ファイル: Corser.cs プロジェクト: Sandy4321/Human-Resources-1
        private void dataGridViewX1_UserDeletingRow(object sender, DataGridViewRowCancelEventArgs e)
        {
            if (Convert.ToInt32(e.Row.Cells["Idcours"].Value) <= 0)
            {
                e.Cancel = true;
            }

            else
            {
                IntDeletCoress.Add(ClassDataGridViewDo.RetunIndexByIdSech(ClassConvert.Convint(e.Row.Cells["Idcours"].Value), CouressList));
            }
        }
コード例 #8
0
        private async void buttonX3_Click(object sender, EventArgs e)
        {
            try
            {
                dataGridViewX1.Enabled = false;

                ClassDataGridViewDo.ClumChekArray(NameCol, dataGridViewX1);


                int IdTheNameOfcoures = NameTeam.NameTeamStatic[comboBoxEx1.SelectedIndex].id;


                for (int i = 0; i < dataGridViewX1.Rows.Count; i++)
                {
                    int      id           = ClassConvert.Convint(dataGridViewX1.Rows[i].Cells["id"].Value);
                    DateTime?NuberOfDayes = ClassConvert.ConvDateTimeNull(dataGridViewX1.Rows[i].Cells["تاريخ تكليفه بالعمل"].Value);

                    //أختبار هل الدورة مسجل عند الشخص + أنه تأكد من وجود ID


                    if (id > 0)
                    {
                        Team CouresNew = new Team(0, NuberOfDayes, null, id, IdTheNameOfcoures, 1, 1);

                        if (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.Red;
                    }
                }
            }
            catch (NoColumnsException ex)
            {
                ErrorClass.SaveErrorFile(ex);
                MessageBox.Show(string.Format(" لا يوجد عامود {0} ", ex.Message));
            }
            catch (Exception ex)
            {
                ErrorClass.SaveErrorFile(ex);
            }

            buttonX3.Enabled = true;

            dataGridViewX1.Enabled = true;
        }
コード例 #9
0
 private void buttonX3_Click(object sender, EventArgs e)
 {
     for (int i = 0; i < dataGridViewX1.Rows.Count; i++)
     {
         if (ClassConvert.Convint(dataGridViewX1.Rows[i].Cells["id"].Value) > 0)
         {
             if (ClassConvert.ConvString(dataGridViewX1.Rows[i].Cells["التاريخ"].Value) != "")
             {
                 Vitl.EditbyIdRegInSARC(ClassConvert.Convint(dataGridViewX1.Rows[i].Cells["id"].Value), ClassConvert.ConvDateTime(dataGridViewX1.Rows[i].Cells["التاريخ"].Value));
             }
         }
     }
 }
コード例 #10
0
ファイル: Form1.cs プロジェクト: Sandy4321/Human-Resources-1
        private void SaveMyVitlNew(int i)
        {
            int j = 0;

            int      id             = 0;
            string   first_name     = dataGridViewX1.Rows[i].Cells[listStringNkname1[j]].Value.ToString();
            string   Last_name      = dataGridViewX1.Rows[i].Cells[listStringNkname1[++j]].Value.ToString();
            string   Father_name    = dataGridViewX1.Rows[i].Cells[listStringNkname1[++j]].Value.ToString();
            string   Mather_name    = dataGridViewX1.Rows[i].Cells[listStringNkname1[++j]].Value.ToString();
            Int64    natiol_id      = ClassConvert.Convint64(dataGridViewX1.Rows[i].Cells[listStringNkname1[++j]].Value);
            bool?    Gender         = ClassConvert.ConvBoolMelaFemalNUll(dataGridViewX1.Rows[i].Cells[listStringNkname1[++j]].Value);
            string   where_birth    = dataGridViewX1.Rows[i].Cells[listStringNkname1[++j]].Value.ToString();
            DateTime data_barthday  = ClassConvert.ConvDateTime(dataGridViewX1.Rows[i].Cells[listStringNkname1[++j]].Value);
            string   Hanei_whare    = dataGridViewX1.Rows[i].Cells[listStringNkname1[++j]].Value.ToString();
            string   Hanei_whare1   = dataGridViewX1.Rows[i].Cells[listStringNkname1[++j]].Value.ToString();
            string   adderas        = dataGridViewX1.Rows[i].Cells[listStringNkname1[++j]].Value.ToString();
            string   e_mail         = dataGridViewX1.Rows[i].Cells[listStringNkname1[++j]].Value.ToString();
            int      Stutes_Jtma3   = ClassConvert.ConvToStatesF(dataGridViewX1.Rows[i].Cells[listStringNkname1[++j]].Value);
            int      Phone_Ground   = ClassConvert.Convint(dataGridViewX1.Rows[i].Cells[listStringNkname1[++j]].Value);
            int      Phone_Mobile1  = ClassConvert.Convint(dataGridViewX1.Rows[i].Cells[listStringNkname1[++j]].Value);
            int      Phone_Mobile2  = ClassConvert.Convint(dataGridViewX1.Rows[i].Cells[listStringNkname1[++j]].Value);
            string   Facebook       = dataGridViewX1.Rows[i].Cells[listStringNkname1[++j]].Value.ToString();
            int      whatsApp       = ClassConvert.Convint(dataGridViewX1.Rows[i].Cells[listStringNkname1[++j]].Value);
            int      viper          = ClassConvert.Convint(dataGridViewX1.Rows[i].Cells[listStringNkname1[++j]].Value);
            string   Twiter         = dataGridViewX1.Rows[i].Cells[listStringNkname1[++j]].Value.ToString();
            string   study          = dataGridViewX1.Rows[i].Cells[listStringNkname1[++j]].Value.ToString();
            int      yearstudy      = ClassConvert.ConvToStady(dataGridViewX1.Rows[i].Cells[listStringNkname1[++j]].Value);;
            int      Id_course      = ClassConvert.Convint(dataGridViewX1.Rows[i].Cells[listStringNkname1[++j]].Value);
            string   Id_course_Ware = dataGridViewX1.Rows[i].Cells[listStringNkname1[++j]].Value.ToString();
            DateTime data_regs      = ClassConvert.ConvDateTime(dataGridViewX1.Rows[i].Cells[listStringNkname1[++j]].Value);

            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;

            int    bitd_id     = ClassConvert.ConvintBoloed(dataGridViewX1.Rows[i].Cells[listStringNkname1[++j]].Value);
            string Nkname      = dataGridViewX1.Rows[i].Cells[listStringNkname1[++j]].Value.ToString();
            string nameEnglish = dataGridViewX1.Rows[i].Cells[listStringNkname1[++j]].Value.ToString();
            int    Z1          = ClassConvert.ConvSizeToint(dataGridViewX1.Rows[i].Cells[listStringNkname1[++j]].Value);
            int    z2          = ClassConvert.Convint(dataGridViewX1.Rows[i].Cells[listStringNkname1[++j]].Value);
            int    z3          = ClassConvert.ConvSizeToint(dataGridViewX1.Rows[i].Cells[listStringNkname1[++j]].Value);

            System.Xml.XmlDataDocument XmlHobbies = null;



            Vitl 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);
        }
コード例 #11
0
ファイル: Corser.cs プロジェクト: Sandy4321/Human-Resources-1
        private void dataGridViewX1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.RowIndex >= 0)
            {
                CoresEditAdder Detalis1 = new CoresEditAdder();
                Detalis1.idVite      = NameOfCouress.id;
                this.Opacity         = 0.5;
                Detalis1.CouressEdit = CouressList[ClassDataGridViewDo.RetunIndexByIdSech(ClassConvert.Convint(dataGridViewX1.Rows[e.RowIndex].Cells[0].Value), CouressList)];
                if (Detalis1.ShowDialog() == System.Windows.Forms.DialogResult.OK)
                {
                    CouressList[ClassDataGridViewDo.RetunIndexByIdSech(ClassConvert.Convint(dataGridViewX1.Rows[e.RowIndex].Cells[0].Value), CouressList)] = Detalis1.CouressEdit;

                    if (ClassConvert.Convint(dataGridViewX1.Rows[e.RowIndex].Cells[0].Value) > 0)
                    {
                        IntEditCoress.Add(ClassDataGridViewDo.RetunIndexByIdSech(ClassConvert.Convint(dataGridViewX1.Rows[e.RowIndex].Cells[0].Value), CouressList));
                    }
                }

                ClassDataGridViewDo.DataGridEnterGridToWorkNameOfCouress_ta(dataGridViewX1, CouressList, VitlByIdList);
                this.Opacity = 1;
            }
        }
コード例 #12
0
        private async void dataGridViewX1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.RowIndex >= 0)
            {
                AdderNameForTeam EditTame = new AdderNameForTeam();


                this.Opacity      = 0.5;
                EditTame.NameTeam = NameTeam;
                EditTame.Team     = TeamList[ClassDataGridViewDo.RetunIndexByIdSech(ClassConvert.Convint(dataGridViewX1.Rows[e.RowIndex].Cells[0].Value), TeamList)];
                if (EditTame.ShowDialog() == System.Windows.Forms.DialogResult.OK)
                {
                    await Sqldatabasethrding.SqlSaveVitl(EditTame.Team.updata());


                    UpdateTheNewAdderOrEdit();
                }


                this.Opacity = 1;
            }
        }
コード例 #13
0
        private void dataGridViewX3_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.RowIndex >= 0)
            {
                ShowAllIteam ShowAllIteam1 = new ShowAllIteam(WereDeliveryList[ClassDataGridViewDo.RetunIndexByIdSech(ClassConvert.Convint(dataGridViewX3.Rows[e.RowIndex].Cells[0].Value), WereDeliveryList)]);
                ShowAllIteam1.idVite = idvite;
                this.Opacity         = 0.5;
                if (ShowAllIteam1.ShowDialog() == System.Windows.Forms.DialogResult.Yes)
                {
                    WereDeliveryList[ClassDataGridViewDo.RetunIndexByIdSech(ClassConvert.Convint(dataGridViewX3.Rows[e.RowIndex].Cells[0].Value), WereDeliveryList)] = ShowAllIteam1.Waredelivare;

                    if (ClassConvert.Convint(dataGridViewX3.Rows[e.RowIndex].Cells[0].Value) > 0)
                    {
                        IntEditWere.Add(ClassDataGridViewDo.RetunIndexByIdSech(ClassConvert.Convint(dataGridViewX3.Rows[e.RowIndex].Cells[0].Value), WereDeliveryList));
                    }
                    needSeaving = true;
                }

                ClassDataGridViewDo.DataGridEnterGridToWorkWereDelivery(dataGridViewX3, WereDeliveryList);
                this.Opacity = 1;
            }
        }
コード例 #14
0
        private void dataGridViewX1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.RowIndex >= 0)
            {
                EditTame Detalis1 = new EditTame();
                Detalis1.idVite   = idvite;
                this.Opacity      = 0.5;
                Detalis1.TeamEdit = TeamList[ClassDataGridViewDo.RetunIndexByIdSech(ClassConvert.Convint(dataGridViewX1.Rows[e.RowIndex].Cells[0].Value), TeamList)];
                if (Detalis1.ShowDialog() == System.Windows.Forms.DialogResult.OK)
                {
                    TeamList[ClassDataGridViewDo.RetunIndexByIdSech(ClassConvert.Convint(dataGridViewX1.Rows[e.RowIndex].Cells[0].Value), TeamList)] = Detalis1.TeamEdit;

                    if (ClassConvert.Convint(dataGridViewX1.Rows[e.RowIndex].Cells[0].Value) > 0)
                    {
                        IntEditTeam.Add(ClassDataGridViewDo.RetunIndexByIdSech(ClassConvert.Convint(dataGridViewX1.Rows[e.RowIndex].Cells[0].Value), TeamList));
                    }
                    needSeaving = true;
                }

                ClassDataGridViewDo.DataGridEnterGridToWorkTeam(dataGridViewX1, TeamList);
                this.Opacity = 1;
            }
        }
コード例 #15
0
        public CV_Info(int id)
        {
            //
            System.Data.SqlClient.SqlCommand SqlCommand = new System.Data.SqlClient.SqlCommand("SELECT  [id]  ,[FullName] ,[Notes]  ,[NmuberOfArchev]  ,[Id_Study] ,[Year_sutr],[Numberphone]  ,[Date],[ID_TemaNeed] ,[Bit]   ,[ToOutTeam]  ,[ToOutDate]  ,[Notesout] FROM [HR_SARC].[dbo].[CV_Info] where [Delete] =0 and  id = @id");
            SqlCommand.Parameters.AddWithValue("id", id);
            List <List <object> > Adw = (Sqldatabasethrding.GetSql(SqlCommand)).Result;

            if (Adw[0].Count != 0)
            {
                this.id             = Convert.ToInt32(Adw[0][0]);
                this.FullName       = Convert.ToString(Adw[0][1]);
                this.Notes          = Convert.ToString(Adw[0][2]);
                this.NmuberOfArchev = Convert.ToInt32(Adw[0][3]);
                this.Id_Study       = Convert.ToInt32(Adw[0][4]);
                this.Year_sutr      = Convert.ToInt32(Adw[0][5]);
                this.Numberphone    = Convert.ToInt32(Adw[0][6]);
                this.Date           = ClassConvert.ConvDateTimeNull(Adw[0][7]);
                this.ID_TemaNeed    = Convert.ToInt32(Adw[0][8]);
                this.Bit            = Convert.ToBoolean(Adw[0][9]);
                this.ToOutTeam      = ClassConvert.Convint(Adw[0][10]);
                this.ToOutDate      = ClassConvert.ConvDateTimeNull(Adw[0][11]);
                this.Notesout       = Convert.ToString(Adw[0][12]);
            }
        }
コード例 #16
0
ファイル: Form1.cs プロジェクト: Sandy4321/Human-Resources-1
        private void buttonX2_Click(object sender, EventArgs e)
        {
            progressBarX1.Maximum  = dataGridViewX1.Rows.Count - 1;
            buttonX2.Enabled       = false;
            dataGridViewX1.Enabled = false;

            foreach (DataColumn Column in   Dat.Tables[0].Columns)
            {
                if (listStringNkname2.IndexOf(Column.ColumnName) != -1)
                {
                    listStringNkname1.Add(listStringNkname2[listStringNkname2.IndexOf(Column.ColumnName)]);
                }
            }
            MessageBoxEx.Show("الرجاء الإنتظار ....");

            //        Task.Run(() => {
            if (!checkBox2.Checked)
            {
                for (int i = 0; i < dataGridViewX1.Rows.Count - 1; i++)
                {
                    progressBarX1.BeginInvoke(new Prosser(NewProsserVaul), i);

                    if (ClassConvert.Convint64(dataGridViewX1.Rows[i].Cells[listStringNkname2[4]].Value) > 0)
                    {
                        if (Vitl.GetIf(ClassConvert.Convint64(dataGridViewX1.Rows[i].Cells[listStringNkname2[4]].Value)))
                        {
                            SaveMyVitlNew(i);
                            goto end;
                        }
                        else
                        {
                            goto end;
                        }
                    }

                    if (Convert.ToString(dataGridViewX1.Rows[i].Cells[listStringNkname2[11]].Value) != "")
                    {
                        if (Vitl.GetIfEmail(Convert.ToString(dataGridViewX1.Rows[i].Cells[listStringNkname2[11]].Value)))
                        {
                            SaveMyVitlNew(i);
                            goto end;
                        }
                        else
                        {
                            goto end;
                        }
                    }

                    if (ClassConvert.Convint(dataGridViewX1.Rows[i].Cells[listStringNkname2[14]].Value) != 0)
                    {
                        if (Vitl.GetIfmobilephon(ClassConvert.Convint(dataGridViewX1.Rows[i].Cells[listStringNkname2[11]].Value)))
                        {
                            SaveMyVitlNew(i);
                            goto end;
                        }
                        else
                        {
                            goto end;
                        }
                    }

                    SaveMyVitlNew(i);
                    end :;
                }
            }
            else
            {
                for (int i = 0; i < dataGridViewX1.Rows.Count - 1; i++)
                {
                    SaveMyVitlNew(i);
                }
            }
            //  dataGridViewX1.Enabled = true;
            buttonX2.BeginInvoke(new buttn(Endbuttonx2));
            //        });
        }
コード例 #17
0
        private void dataGridViewX3_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.RowIndex >= 0)
            {
                Corser Corser = new Corser();
                this.Opacity = 0.5;

                Corser.NameOfCouress = NameOfCouress.NameOfCouresslist[ClassDataGridViewDo.RetunIndexByIdSech(ClassConvert.Convint(dataGridViewX3.Rows[e.RowIndex].Cells[0].Value), NameOfCouress.NameOfCouresslist)];
                Corser.ShowDialog();
                this.Opacity = 1;
            }
        }
コード例 #18
0
        private void dataGridViewX9_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.RowIndex >= 0)
            {
                TeamShowAll TeamShowAll = new TeamShowAll();
                this.Opacity = 0.5;

                TeamShowAll.NameTeam = NameTeam.NameTeamStatic[ClassDataGridViewDo.RetunIndexByIdSech(ClassConvert.Convint(dataGridViewX9.Rows[e.RowIndex].Cells[0].Value), NameTeam.NameTeamStatic)];
                TeamShowAll.ShowDialog();
                this.Opacity = 1;
            }
        }
コード例 #19
0
        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;
        }
コード例 #20
0
        public static List <TypeofCouress> GetAll()
        {
            List <TypeofCouress> Lista = new List <TypeofCouress>();

            System.Data.SqlClient.SqlCommand SqlComm = new System.Data.SqlClient.SqlCommand("SELECT [Id],[NameOfCouress],[NameTeam_Ta] FROM [dbo].[TypeofCouress_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 TypeofCouress(Convert.ToInt32(Adw[i][0]), ClassConvert.ConvString(Adw[i][1]), ClassConvert.Convint(Adw[i][2])));
                }
            }

            return(Lista);
        }
コード例 #21
0
        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()); }
        }