public static async System.Threading.Tasks.Task <List <CV_Info> > Serch(string Fullname, string Notes, int Id_Study, int Year_sutr, int ID_TemaNeed, bool Chek, int NumberPhone)
{
String Where = "";
Fullname = ClassDataGridViewDo.LograthemChangEverAleffToAll(Fullname, true);
System.Data.SqlClient.SqlCommand Sqlcom = new System.Data.SqlClient.SqlCommand("SELECT [id] ,[FullName] ,[Notes] ,[NmuberOfArchev] ,[Id_Study] ,[Year_sutr],[Numberphone] ,[Date],[ID_TemaNeed] ,[Bit] ,[ToOutTeam] , [ToOutDate] , [Notesout],[Delete] FROM [HR_SARC].[dbo].[CV_Info] where [Delete] =0 and [FullName] = @FullName " + Where);
if (Notes.Trim() != "")
{
Where += " and [Notes] like @Notes";
Sqlcom.Parameters.AddWithValue("@Notes", "%" + ClassDataGridViewDo.LograthemChangEverAleffToAll(Notes) + "%");
}
if (Id_Study != -1)
{
Where += " and [Id_Study] = @Id_Study";
Sqlcom.Parameters.AddWithValue("Id_Study", Id_Study);
}
if (Year_sutr != -1)
{
Where += " and [Year_sutr] = @Year_sutr";
Sqlcom.Parameters.AddWithValue("Year_sutr", Year_sutr);
}
if (ID_TemaNeed != -1)
{
Where += " and [ID_TemaNeed] = @ID_TemaNeed";
Sqlcom.Parameters.AddWithValue("ID_TemaNeed", ID_TemaNeed);
}
if (Chek)
{
Where += " and [Bit] = @Bit";
Sqlcom.Parameters.AddWithValue("Bit", !Chek);
}
if (NumberPhone != 0)
{
Where += " and [Numberphone] = @Numberphone";
Sqlcom.Parameters.AddWithValue("Numberphone", NumberPhone);
}
Sqlcom.CommandText = "SELECT [id] ,[FullName] ,[Notes] ,[NmuberOfArchev] ,[Id_Study] ,[Year_sutr],[Numberphone] ,[Date],[ID_TemaNeed] ,[Bit] ,[ToOutTeam] , [ToOutDate] , [Notesout],[Delete] FROM [HR_SARC].[dbo].[CV_Info] where [Delete] =0 and [FullName] like @FullName " + Where;
Sqlcom.Parameters.AddWithValue("@FullName", "%" + Fullname + "%");
List <CV_Info> Ve = new List <CV_Info>();
List <List <object> > Ob = await Sqldatabasethrding.GetSql(Sqlcom);
for (int i = 0; i < Ob.Count; i++)
{
if (Ob[i].Count != 0)
{
try
{
Ve.Add(new CV_Info(
Convert.ToInt32(Ob[i][0]),
Convert.ToString(Ob[i][1]),
Convert.ToString(Ob[i][2]),
Convert.ToInt32(Ob[i][3]),
Convert.ToInt32(Ob[i][4]),
Convert.ToInt32(Ob[i][5]),
Convert.ToInt32(Ob[i][6]),
ClassConvert.ConvDateTimeNull(Ob[i][7]),
Convert.ToInt32(Ob[i][8]),
Convert.ToBoolean(Ob[i][9]),
-1,
null,
null
));
}
catch (Exception e)
{
ErrorClass.SaveErrorFile(e);
}
}
}
return(Ve);
}
private void dataGridViewX1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex != -1)
{
DetalsDataVitelAssing DetalsDataVitelAssing1 = new DetalsDataVitelAssing(Alldatesee[ClassDataGridViewDo.RetunIndexByIdSech(Convert.ToInt32(dataGridViewX1.Rows[e.RowIndex].Cells[0].Value), Alldatesee)]);
DetalsDataVitelAssing1.ShowDialog();
}
}
private void buttonX1_Click(object sender, EventArgs e)
{
if (first_name.Checked)
{
ParamterrMakeSql1.AdderParmtaer(Vitl.vitl.first_name, "", ParamterrMakeSql.Condtion.like, ParamterrMakeSql.Between.And);
}
if (Last_name.Checked)
{
ParamterrMakeSql1.AdderParmtaer(Vitl.vitl.Last_name, "", ParamterrMakeSql.Condtion.like, ParamterrMakeSql.Between.And);
}
if (Father_name.Checked)
{
ParamterrMakeSql1.AdderParmtaer(Vitl.vitl.Father_name, "", ParamterrMakeSql.Condtion.like, ParamterrMakeSql.Between.And);
}
if (Mather_name.Checked)
{
ParamterrMakeSql1.AdderParmtaer(Vitl.vitl.Mather_name, "", ParamterrMakeSql.Condtion.like, ParamterrMakeSql.Between.And);
}
if (natiol_id.Checked)
{
ParamterrMakeSql1.AdderParmtaer(Vitl.vitl.natiol_id, 0, ParamterrMakeSql.Condtion.Eqial, ParamterrMakeSql.Between.And);
}
if (Id_course_no.Checked)
{
ParamterrMakeSql1.AdderParmtaer(Vitl.vitl.Id_course, 0, ParamterrMakeSql.Condtion.Eqial, ParamterrMakeSql.Between.And);
}
if (Id_course.Checked)
{
ParamterrMakeSql1.AdderParmtaer(Vitl.vitl.Id_course, 0, ParamterrMakeSql.Condtion.MoreThen, ParamterrMakeSql.Between.And);
}
if (image.Checked)
{
ParamterrMakeSql1.AdderParmtaer(Vitl.vitl.image, DBNull.Value, ParamterrMakeSql.Condtion.isnulldb, ParamterrMakeSql.Between.And);
}
if (Image_id_nationl1.Checked)
{
ParamterrMakeSql1.AdderParmtaer(Vitl.vitl.Image_id_nationl1, DBNull.Value, ParamterrMakeSql.Condtion.isnulldb, ParamterrMakeSql.Between.And);
}
if (data_barthday.Checked)
{
ParamterrMakeSql1.AdderParmtaer(Vitl.vitl.data_barthday, new DateTime(1800, 1, 1), ParamterrMakeSql.Condtion.lessThen, ParamterrMakeSql.Between.And);
}
if (data_regs.Checked)
{
ParamterrMakeSql1.AdderParmtaer(Vitl.vitl.data_regs, new DateTime(1800, 1, 1), ParamterrMakeSql.Condtion.lessThen, ParamterrMakeSql.Between.And);
}
if (Boold_id.Checked)
{
ParamterrMakeSql1.AdderParmtaer(Vitl.vitl.Boold_id, -1, ParamterrMakeSql.Condtion.Eqial, ParamterrMakeSql.Between.And);
}
if (natiol_id.Checked)
{
ParamterrMakeSql1.AdderParmtaer(Vitl.vitl.natiol_id, 0, ParamterrMakeSql.Condtion.Eqial, ParamterrMakeSql.Between.And);
}
if (Image_id_nationl2.Checked)
{
ParamterrMakeSql1.AdderParmtaer(Vitl.vitl.Image_id_nationl2, DBNull.Value, ParamterrMakeSql.Condtion.isnulldb, ParamterrMakeSql.Between.And);
}
if (Hanei_whare1.Checked)
{
ParamterrMakeSql1.AdderParmtaer(Vitl.vitl.Hanei_whare1, "", ParamterrMakeSql.Condtion.like, ParamterrMakeSql.Between.And);
}
if (Hanei_whare.Checked)
{
ParamterrMakeSql1.AdderParmtaer(Vitl.vitl.Hanei_whare, "", ParamterrMakeSql.Condtion.like, ParamterrMakeSql.Between.And);
}
if (study.Text.Trim() != "")
{
ParamterrMakeSql1.AdderParmtaer(Vitl.vitl.study, ClassDataGridViewDo.LograthemChangEverAleffToAll(study.Text, true), ParamterrMakeSql.Condtion.WhildCart, ParamterrMakeSql.Between.And);
}
if (yearstudy.SelectedIndex != -1)
{
ParamterrMakeSql1.AdderParmtaer(Vitl.vitl.yearstudy, yearstudy.SelectedIndex, ParamterrMakeSql.Condtion.Eqial, ParamterrMakeSql.Between.And);
}
if (Boold_id1.SelectedIndex != -1)
{
ParamterrMakeSql1.AdderParmtaer(Vitl.vitl.Boold_id, Boold_id1.SelectedIndex, ParamterrMakeSql.Condtion.Eqial, ParamterrMakeSql.Between.And);
}
if (birthdayFrom.Value != DateTime.MinValue)
{
ParamterrMakeSql1.AdderParmtaer(Vitl.vitl.data_barthday, birthdayFrom.Value, ParamterrMakeSql.Condtion.EqMoreThen, ParamterrMakeSql.Between.And);
}
if (birthdayTo.Value != DateTime.MinValue)
{
ParamterrMakeSql1.AdderParmtaer(Vitl.vitl.data_barthday, birthdayTo.Value, ParamterrMakeSql.Condtion.EqlessThen, ParamterrMakeSql.Between.And);
}
DialogResult = DialogResult.OK;
}
private async void RibbonForm2_Load(object sender, EventArgs e)
{
#region تحميل الفريم الأولي
#region تحميل معلومات الأساسية للجدول الفريق
ClassDataGridViewDo.DataGridAddVuleComBoxEx((DataGridViewComboBoxExColumn)dataGridViewX1.Columns["TeamTeam"], NameTeamType.NameTeamTypeStatic, NameTeam.NameTeamStatic);
ClassDataGridViewDo.DataGridAddVuleComBoxEx((DataGridViewComboBoxExColumn)dataGridViewX1.Columns["TeamJop"], Jop.JopStatic);
ClassDataGridViewDo.DataGridAddVuleComBoxEx((DataGridViewComboBoxExColumn)dataGridViewX2.Columns["id_NameOfCouress"], NameOfCouress.NameOfCouresslist);
ClassDataGridViewDo.DataGridAddVuleComBoxEx((DataGridViewComboBoxExColumn)dataGridViewX1.Columns["TeamStatus"], Team.Setwation);
#endregion
/// في كان ت
if (idvite != 0)
{
#region تحميل المعلومات في حال كان هناك مستخدم للتعديل
#region معلومات العامة
vitl1 = new Vitl(idvite);
first_name.Text = vitl1.first_name;
Last_name.Text = vitl1.Last_name;
Father_name.Text = vitl1.Father_name;
Mather_name.Text = vitl1.Mather_name;
natiol_id.Text = ClassConvert.ConvToIdNational(vitl1.natiol_id);
Gender.SelectedIndex = ClassConvert.ConvGenderBoolNull(vitl1.Gender);
where_birth.Text = vitl1.where_birth;
data_barthday.Value = vitl1.data_barthday;
Hanei_whare.Text = vitl1.Hanei_whare;
Hanei_whare1.Text = vitl1.Hanei_whare1;
adderas.Text = vitl1.adderas;
e_mail.Text = vitl1.e_mail;
Stutes_Jtma3.SelectedIndex = vitl1.Stutes_Jtma3;
Phone_Ground.Text = vitl1.Phone_Ground.ToString();
Phone_Mobile1.Text = vitl1.Phone_Mobile1.ToString();
Phone_Mobile2.Text = vitl1.Phone_Mobile2.ToString();
Facebook.Text = vitl1.Facebook;
Twiter.Text = vitl1.Twiter;
whatsApp.Text = vitl1.whatsApp.ToString();
viper.Text = vitl1.viper.ToString();
study.Text = vitl1.study;
yearstudy.SelectedIndex = vitl1.yearstudy;
Id_course.Text = vitl1.Id_course.ToString();
Id_course_Ware.Text = vitl1.Id_course_Ware;
data_regs.Value = vitl1.data_regs;
Image_id_nationl1.Image = vitl1.Image_id_nationl1;
Image_id_nationl2.Image = vitl1.Image_id_nationl2;
image.Image = vitl1.image;
image1.Image = vitl1.image;
Image_font.Image = vitl1.Image_font;
bitd_id.SelectedIndex = vitl1.Boold_id;
Nkname.Text = vitl1.Nkname;
nameEnglish.Text = vitl1.nameEnglish;
Z1.SelectedIndex = vitl1.Z1;
z2.Text = vitl1.z2.ToString();
z3.SelectedIndex = vitl1.z3;
this.dataGridView7.DataSource = vitl1.XmlHobbies;
#endregion
#region الفريق
/////إضافة الفريق إلى جدول الفرق
EditTame.CountOfNew = 0;
TeamList = await Team.GetByIdVil(idvite);
ClassDataGridViewDo.DataGridEnterGridToWorkTeam(dataGridViewX1, TeamList);
#endregion
#region الدورات
CoresEditAdder.CountOfNew = 0;
CouressList = Couress.GetByIdVil(idvite);
ClassDataGridViewDo.DataGridEnterGridToWorkCorser(dataGridViewX2, CouressList);
#endregion
#region المواد
WereDeliveryList = WereDelivery.GetByIdVil(idvite);
ClassDataGridViewDo.DataGridEnterGridToWorkWereDelivery(dataGridViewX3, WereDeliveryList);
#endregion
#region المواد
ValuationList = Valuation.GetByIdVil(idvite);
ClassDataGridViewDo.DataGridEnterGridToWorkValuation(dataGridViewX4, ValuationList);
#endregion
#endregion
}
else
{
this.Text = "تسجيل متطوع جديد";
}
#endregion
needSeaving = false;
}
private void AdderTypeCoures_Load(object sender, EventArgs e)
{
ClassDataGridViewDo.DataGridAddVuleComBoxEx(comboBoxEx1, NameTeam.NameTeamStatic);
}
private void CoureesExcl_Load(object sender, EventArgs e)
{
ClassDataGridViewDo.DataGridAddVuleComBoxEx(comboBoxEx1, TypeofCouress.TypeofCouressList);
}
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()); }
}
private void AdderAssing_Load(object sender, EventArgs e)
{
// ClassDataGridViewDo.DataGridAddVuleComBoxEx(comboBoxEx1, Valuationname.Valuationnamelist);
ClassDataGridViewDo.DataGridEnterGridAllValutionename(dataGridViewX1, Valuationname.Valuationnamelist);
}
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;
}
private void Form1_Load(object sender, EventArgs e)
{
ClassDataGridViewDo.DataGridAddVuleComBoxEx(comboBoxEx1, CvTeamNeed.CvTeamNeedList);
}
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 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
);
}
public static async void DataGridEnterGridForCV_InfoCV(DevComponents.DotNetBar.Controls.DataGridViewX Grid, List <CV_Info> TeamClassList)
{
Grid.BeginInvoke((Action)(() => { Grid.Rows.Clear();
///Id_TypeofCouress_ta.Items[RetunIndexByIdSech(TeamClassList[i].Id_TypeofCouress_ta, TypeofCouress.TypeofCouressList)]
for (int i = 0; i < TeamClassList.Count; i++)
{
// try
// {
Grid.Rows.Add(
TeamClassList[i].id,
TeamClassList[i].FullName,
TeamClassList[i].Notes,
TeamClassList[i].GetCodeArch(),
TeamClassList[i].Id_Study != -1 ? CV_Study.CV_StudyList[ClassDataGridViewDo.RetunIndexByIdSech(TeamClassList[i].Id_Study, CV_Study.CV_StudyList)].Sutdy : "",
ClassConvert.ConvNumberCombyereToString(TeamClassList[i].Year_sutr),
TeamClassList[i].Numberphone,
TeamClassList[i].Date != null ? TeamClassList[i].Date.Value.ToShortDateString() : "",
TeamClassList[i].ID_TemaNeed != -1 ? CvTeamNeed.CvTeamNeedList[ClassDataGridViewDo.RetunIndexByIdSech(TeamClassList[i].ID_TemaNeed, CvTeamNeed.CvTeamNeedList)].FullName : "",
TeamClassList[i].Bit);
}
}));
// }
// catch( Exception e )
// { ErrorClass.SaveErrorFile(e); }
}
private void SetQustionInDataBase_Load(object sender, EventArgs e)
{
ClassDataGridViewDo.DataGridEnterGridQustion(dataGridViewX1, Qustiones.Qustioneslist);
}
public string RetunNameString()
{
return(NameTeam.NameTeamStatic[ClassDataGridViewDo.RetunIndexByIdSech(this.id_NameTeam_Ta, NameTeam.NameTeamStatic)].nameOftame);
}
private async void dataGridViewX2_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex > -1)
{
AdderTeamName AdderTeamName = new AdderTeamName(NameTeam.NameTeamStatic[ClassDataGridViewDo.RetunIndexByIdSech(Convert.ToInt32(dataGridViewX2.Rows[e.RowIndex].Cells[0].Value), NameTeam.NameTeamStatic)]);
if (AdderTeamName.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
if (await Sqldatabasethrding.SqlSaveVitl(AdderTeamName.NameTeam.updata()))
{
NameTeam.NameTeamStatic = await NameTeam.GetAll();
ClassDataGridViewDo.DataGridEnterGridFornameTeamOption(dataGridViewX2, NameTeam.NameTeamStatic);
}
else
{
MegBox.Show("خطأ بالإتصال");
}
}
this.Opacity = 1;
}
}
