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 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()); }
}