private void AdderNameForTeam_Load(object sender, EventArgs e)
{
ClassDataGridViewDo.DataGridAddVuleComBoxEx(comboBoxEx3, Jop.JopStatic);
ClassDataGridViewDo.DataGridAddVuleComBoxEx(comboBoxEx2, Team.Setwation);
intList = RibbonForm1.intList;
textBoxX1.AutoCompleteCustomSource = RibbonForm1.Combox;
textBoxX1.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
textBoxX1.AutoCompleteSource = AutoCompleteSource.CustomSource;
if (Team == null)
{
buttonX1.Text = "إضافة";
}
else
{
textBoxX1.Text = RibbonForm1.Combox[intList.IndexOf(Team.ID_informtion)];
comboBoxEx2.SelectedIndex = Team.Setewation;
comboBoxEx3.SelectedIndex = ClassDataGridViewDo.RetunIndexByIdSech(Team.Id_Jop_Ta, Jop.JopStatic);
if (ClassConvert.ConvDateTimeNull(Team.date_Start) != null)
{
dateTimeInput1.Value = ClassConvert.ConvDateTime(Team.date_Start);
}
if (ClassConvert.ConvDateTimeNull(Team.Date_End) != null)
{
dateTimeInput2.Value = ClassConvert.ConvDateTime(Team.Date_End);
}
buttonX1.Text = "تعديل";
}
}
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 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);
}
public static List <NameOfCouress> GetAll()
{
List <NameOfCouress> Lista = new List <NameOfCouress>();
System.Data.SqlClient.SqlCommand SqlComm = new System.Data.SqlClient.SqlCommand("SELECT [Id],[dataStart],[DataENd],[Suport],[Id_TypeofCouress_ta] ,[Decrption] ,[IntCoures] , WhereIS FROM [HR_SARC].[dbo].[NameOfCouress_ta] where [Delete] = 0");
Task <List <List <object> > > temp = Sqldatabasethrding.GetSql(SqlComm);
while (!temp.IsCompleted)
{
}
List <List <object> > Adw = temp.Result;
for (int i = 0; i < Adw.Count; i++)
{
if (Adw[i].Count != 0)
{
Lista.Add(new NameOfCouress(Convert.ToInt32(Adw[i][0]), ClassConvert.ConvDateTime(Adw[i][1]), ClassConvert.ConvDateTime(Adw[i][2]), ClassConvert.ConvBool(Adw[i][3]), Convert.ToInt32(Adw[i][4]), Convert.ToString(Adw[i][5]), Convert.ToInt32(Adw[i][6]), Convert.ToInt32(Adw[i][7])));
}
}
return(Lista);
}
private 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 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()); }
}