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("إنتها"); }
/// <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()); } }
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; }