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();
}
}
}
internal static void DataGridEnterAsncyGrAllname(DataGridViewX dataGridViewX1, List <vitelAssingInformation> alldatesee)
{
foreach (vitelAssingInformation item in alldatesee)
{
dataGridViewX1.Rows.Add(item.GetidInformation(), Vitl.VitlIdAndName(item.GetidInformation()).Name, item.GetResut());
}
}
private async void buttonX2_Click(object sender, EventArgs e)
{
using (FolderBrowserDialog ShowWhereSaveYouPhoto = new FolderBrowserDialog())
{
if (ShowWhereSaveYouPhoto.ShowDialog() == DialogResult.OK)
{
string fe = ShowWhereSaveYouPhoto.SelectedPath;
await Task.Run(() =>
{
for (int i = 0; i < Vitl1.Count; i++)
{
Vitl Vitlnew = new Vitl(Vitl1[i].id);
if (Vitlnew.image != null)
{
dataGridViewX1.Rows[i].Cells[8].Value = "موجود";
Vitlnew.image.Save(fe + "\\" + Vitlnew.first_name + " " + Vitlnew.Last_name + ".jpg");
}
else
{
dataGridViewX1.Rows[i].Cells[8].Value = "غير موجود";
}
Vitlnew.Dispose();
}
});
}
}
}
/// <summary>
/// من أجل إضافة الأسماء إلى Comboxex
/// </summary>
/// <param name="ComboBox1">إضافة</param>
public static async Task <bool> GetNameForRibbonForm1Combox(List <int> intList)
{
await openConction();
System.Data.SqlClient.SqlCommand SqlCommand1 = new SqlCommand();
SqlCommand1 = Vitl.GetAllName();
SqlCommand1.Connection = Sqldatabasethrding.SqlConnection1;
IAsyncResult result = SqlCommand1.BeginExecuteReader();
SqlDataReader SqlDataReader1 = SqlCommand1.EndExecuteReader(result);
try
{
while (await SqlDataReader1.ReadAsync())
{
RibbonForm1.Combox.Add(SqlDataReader1.GetValue(0).ToString());
intList.Add(SqlDataReader1.GetInt32(1));
}
}
catch (Exception e)
{
System.Windows.Forms.MessageBox.Show(e.ToString());
}
finally { SqlDataReader1.Close(); }
return(true);
}
public DetalsDataVitelAssing(vitelAssingInformation vitelAssingInformation1)
{
InitializeComponent();
ClassDataGridViewDo.DataGridEnterAsncyGrAllname(dataGridViewX1, vitelAssingInformation1);
labelX2.Text = "%" + Convert.ToInt32(vitelAssingInformation1.GetResut()).ToString();
labelX4.Text = Vitl.VitlIdAndName(vitelAssingInformation1.GetidInformation()).Name;
}
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 :;
}
}
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());
}
}
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 buttonX3_Click(object sender, EventArgs e)
{
for (int i = 0; i < dataGridViewX1.Rows.Count; i++)
{
if (Convert.ToInt32(dataGridViewX1.Rows[i].Cells["id"].Value) > 0)
{
await Vitl.EditByidNationId(Convert.ToInt32(dataGridViewX1.Rows[i].Cells["id"].Value),
Convert.ToInt64(dataGridViewX1.Rows[i].Cells["الرقم الوطني"].Value));
}
}
MegBox.Show("تم التعديل");
}
public async void NameSrc()
{
viltl.Clear();
dataGridViewX1.Rows.Clear();
viltl = await Vitl.GetAll(comboBox1.Text);
foreach (IdAndName Name in viltl)
{
dataGridViewX1.Rows.Add(Name.id, Name.Name);
}
}
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));
}
}
}
}
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);
}
/// <summary>
/// البحث في قاعدة البيانات عن طريق الأسم
/// </summary>
///
public static async void WaitSqlsersh(string Stringa, Int64 Idnationl, string Idviter, DateTime DateTimerFrom, DateTime DateTimerTo, DevComponents.DotNetBar.Controls.ProgressBarX ProgressBarX1, DevComponents.DotNetBar.Controls.DataGridViewX DataGridViewX1)
{
await openConction();
SqlCommand sqlcom1 = null;
sqlcom1 = Vitl.Serch1(Stringa, DateTimerFrom, DateTimerTo);
sqlcom1.Connection = SqlConnection1;
IAsyncResult result = sqlcom1.BeginExecuteReader();
SqlDataReader reader = sqlcom1.EndExecuteReader(result);
DataGridViewX1.Rows.Clear();
try
{
while (await reader.ReadAsync())
{
List <object> Tempobject = new List <object>();
for (int i = 0; i < reader.FieldCount; i++)
{
Tempobject.Add(reader.GetValue(i));
}
ClassDataGridViewDo.DataGridViewShow1Show(DataGridViewX1, Tempobject);
}
}
catch
{
MessageBox.Show("Error");
}
finally
{
reader.Close();
}
}
public static void DataGridEnterGridSerc(DataGridViewX dataGridViewX1, Vitl vitl, List <Team> list)
{
string Team1 = "";
foreach (Team item in list)
{
Team1 += " + " + item.RetunNameString();
}
if (Team1.Length != 0)
{
Team1 = Team1.Remove(0, 2);
}
dataGridViewX1.Rows.Add(vitl.id, vitl.first_name + " " + vitl.Last_name, Team1);
}
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 async void buttonX2_Click(object sender, EventArgs e)
{
IdAndName1.Clear();
dataGridViewX1.Rows.Clear();
IdAndName1 = await Vitl.GetAll("");
for (int i = 0; i < IdAndName1.Count; i++)
{
for (int j = i + 1; j < IdAndName1.Count; j++)
{
if (IdAndName1[i].Name.Contains(IdAndName1[j].Name))
{
dataGridViewX1.Rows.Add(IdAndName1[j].id, IdAndName1[j].Name);
dataGridViewX1.Rows.Add(IdAndName1[i].id, IdAndName1[i].Name);
}
}
}
}
private async void buttonX1_Click(object sender, EventArgs e)
{
IdAndName1.Clear();
dataGridViewX1.Rows.Clear();
IdAndName1 = await Vitl.GetAll("");
var employeesByState = from ex in IdAndName1
group ex by ex.Name;
foreach (var employeeGroup in employeesByState)
{
foreach (var employee in employeeGroup)
{
if (employeeGroup.Count() > 1)
{
dataGridViewX1.Rows.Add(employee.id, employee.Name);
}
}
}
}
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);
}
}
public static async void SqlSaveAdderAndBack(Vitl Vitl)
{
SqlCommand Sqlcommand1 = Vitl.adder();
await openConction();
try
{
// IAsyncResult result = Sqlcommand1.BeginExecuteNonQuery();
Sqlcommand1.Connection = Sqldatabasethrding.SqlConnection1;
Vitl.ChanId((int)Sqlcommand1.ExecuteScalar());
}
catch (Exception e)
{
ErrorClass.SaveErrorFile(e);
MessageBox.Show(e.ToString());
}
finally
{
}
}
private void buttonX2_Click(object sender, EventArgs e)
{
CoresEditAdder CoresEditAdder = new CoresEditAdder();
CoresEditAdder.ToAddInCores = true;
if (Type != 0)
{
CoresEditAdder.idVite = NameOfCouress.id;
if (CoresEditAdder.ShowDialog() == System.Windows.Forms.DialogResult.Yes)
{
CouressList.Add(CoresEditAdder.CouressEdit);
IntAdderCoress.Add(CouressList.Count - 1);
VitlByIdList.Clear();
foreach (Couress Couressv in CouressList)
{
VitlByIdList.Add(Vitl.VitlIdAndName(Couressv.Id_Information));
}
ClassDataGridViewDo.DataGridEnterGridToWorkNameOfCouress_ta(dataGridViewX1, CoresEditAdder.CouressEdit, VitlByIdList[CouressList.IndexOf(CoresEditAdder.CouressEdit)]);
}
}
}
private void dataGridViewX1_UserDeletingRow(object sender, DataGridViewRowCancelEventArgs e)
{
Vitl.DeleByid(Convert.ToInt32(e.Row.Cells[0].Value));
}
/// <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;
}
public static void DataGridEnterGridForGetdateByID(DevComponents.DotNetBar.Controls.DataGridViewX Grid, Vitl vitl, List <Team> Teamlest, List <Couress> coureslist)
{
string listtamestring = "";
string listtcoures = "";
foreach (Team item in Teamlest)
{
listtamestring += " + " + NameTeam.NameTeamStatic[ClassDataGridViewDo.RetunIndexByIdSech(item.id_NameTeam_Ta, NameTeam.NameTeamStatic)].nameOftame;
}
foreach (Couress item in coureslist)
{
listtcoures += " + " + NameOfCouress.NameOfCouresslist[ClassDataGridViewDo.RetunIndexByIdSech(item.id_NameOfCouress, NameOfCouress.NameOfCouresslist)].Decrption;
}
if (coureslist.Count != 0)
{
listtcoures = listtcoures.Remove(0, 2);
}
if (Teamlest.Count != 0)
{
listtamestring = listtamestring.Remove(0, 2);
}
Grid.Rows.Add(
vitl.id.ToString()
, ClassConvert.ConvNonullTostring(vitl.first_name) + " " + ClassConvert.ConvNonullTostring(vitl.Last_name)
, ClassConvert.ConvNonullTostring(vitl.first_name)
, ClassConvert.ConvNonullTostring(vitl.Last_name)
, ClassConvert.ConvNonullTostring(vitl.Father_name)
, ClassConvert.ConvNonullTostring(vitl.Mather_name)
, ClassConvert.ConvNonullTostring(ClassConvert.ConvToIdNational(vitl.natiol_id))
, vitl.Gender == false ? "ذكر" : vitl.Gender == true ? "إنثى" : ""
, ClassConvert.ConvNonullTostring(vitl.where_birth)
, vitl.data_barthday.ToShortDateString()
, ClassConvert.ConvNonullTostring(vitl.Hanei_whare)
, ClassConvert.ConvNonullTostring(vitl.Hanei_whare1)
, ClassConvert.ConvNonullTostring(vitl.adderas)
, ClassConvert.ConvNonullTostring(vitl.e_mail)
, ClassConvert.Stutes_Jtma3Tostring(vitl.Stutes_Jtma3, vitl.Gender)
, vitl.Phone_Ground.ToString()
, vitl.Phone_Mobile1.ToString()
, vitl.Phone_Mobile2.ToString()
, ClassConvert.ConvNonullTostring(vitl.Facebook)
, ClassConvert.ConvNonullTostring(vitl.Twiter)
, vitl.whatsApp.ToString()
, vitl.viper.ToString()
, ClassConvert.ConvNonullTostring(vitl.study)
, ClassConvert.yearstudyToString(vitl.yearstudy)
, vitl.Id_course.ToString()
, ClassConvert.ConvNonullTostring(vitl.Id_course_Ware)
, vitl.data_regs.ToShortDateString()
, ClassConvert.ConvStringBoloed(vitl.Boold_id)
, ClassConvert.ConvNonullTostring(vitl.Nkname)
, ClassConvert.ConvNonullTostring(vitl.nameEnglish)
, ClassConvert.ConvSizeToString(vitl.Z1)
, vitl.z2.ToString()
, ClassConvert.ConvSizeToString(vitl.z3)
, listtamestring
, listtcoures
);
}
private async void RibbonForm1_Load(object sender, EventArgs e)
{
#region setup1
Vitl.SetUpNameDataBase();
#endregion
// Sqldatabasethrding.SqlConnection1.ConnectionString = Sqldatabasethrding.sqlconction;
// Sqldatabasethrding.SqlConnection1.Open();
#region SetUpCLassis
CvTeamNeed.CvTeamNeedList = await CvTeamNeed.GetAll();
CV_Study.CV_StudyList = await CV_Study.GetAll();
NameTeamType.NameTeamTypeStatic = NameTeamType.GetAll();
NameTeam.NameTeamStatic = await NameTeam.GetAll();
Jop.JopStatic = Jop.GetAll();
TypeofCouress.TypeofCouressList = TypeofCouress.GetAll();
NameOfCouress.NameOfCouresslist = NameOfCouress.GetAll();
WereType.WereTypeList = WereType.GetAll();
Valuationname.Valuationnamelist = Valuationname.GetAll();
Scileis.ScileislList = await Scileis.GetAll();
Qustiones.Qustioneslist = Qustiones.GetAll();
//من أجل عم بحث على أنهم غير فعالين
Team.ListNotAllAtive.Add(4);
Team.ListNotAllAtive.Add(5);
//من أجل عم بحث على أنهم غير فعالين
////
Team.Setwation.Add("رديف");
Team.Setwation.Add("أساسي");
Team.Setwation.Add("دوار");
Team.Setwation.Add("موظف");
Team.Setwation.Add("مسافر");
Team.Setwation.Add("منقطع");
Team.Setwation.Add("تطوعي غير مؤجور");
///
Valuationname.ValuationnameTypeInt.Add("دائمين");
Valuationname.ValuationnameTypeInt.Add("تجربين");
Valuationname.ValuationnameTypeInt.Add("شامل لكل المتطوعين");
Valuationname.ValuationnameTypeInt.Add("مخصص");
//
Vitl.Bransh.Add("حلب");
Vitl.Bransh.Add("حلب-سفيرة");
//
#endregion
#region interFace
ClassDataGridViewDo.DataGridAddVuleComBoxEx((DataGridViewComboBoxExColumn)dataGridViewX3.Columns["Id_TypeofCouress_ta"], TypeofCouress.TypeofCouressList);
ClassDataGridViewDo.DataGridAddVuleComBoxEx((DataGridViewComboBoxExColumn)dataGridViewX9.Columns["NameTeamType_Id"], NameTeamType.NameTeamTypeStatic);
ClassDataGridViewDo.DataGridEnterGridToWorkNameOfCouress_ta(dataGridViewX3, NameOfCouress.NameOfCouresslist);
//dataGridViewX9
ClassDataGridViewDo.DataGridEnterGridToWorkNameTeam_Ta(dataGridViewX9, NameTeam.NameTeamStatic);
await Sqldatabasethrding.GetNameForRibbonForm1Combox(intList);
#endregion
comboBoxEx1.AutoCompleteCustomSource = Combox;
}
public IDPrinter(Vitl vitle)
{
this.vitle = vitle;
InitializeComponent();
pictureBox1.ImageLocation = @"C:\Users\sarc-12\Desktop\ID-Card.jpg";
}
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));
// });
}
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()); }
}
