/// <summary>
 /// ثبت اطلاعات
 /// </summary>
 private void Register()
 {
     int ID = Convert.ToInt32(MakeID());
     try
     {
         Tankhah T = new Tankhah()
         {
             TankhahID = ID,
             TankhahName = Txt_FName.Text.Trim(),
             CreditCurrent = 0
         };
         db.Tankhahs.Add(T);
         foreach (var item in listBox_Tels.Items)
         {
             PhoneBook PB = new PhoneBook();
             PB.PNumber = item.ToString();
             PB.TankhahID = ID;
             db.PhoneBooks.Add(PB);
         }
         db.SaveChanges();
         utility.Show_Message("اطلاعات این تنخواه با موفقیت ثبت شد", "ثبت");
         GetData();
         ShowData();
         Clear();
     }
     catch (DbUpdateException ex)
     {
         MessageBox.Show(SqlServerErrorManagment.ShowError(ex, "تنخواه"), "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message, "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
 }
 private void RegisterTel(int _NewID)
 {
     try
     {
         if (listBox_Tels.Items.Count != 0)
         {
             String s;
             foreach (Object selecteditem in listBox_Tels.Items)
             {
                 s = selecteditem as String;
                 PhoneBook t = new PhoneBook()
                 {
                     ContractorID = _NewID,
                     PNumber = s,
                 };
                 db.PhoneBooks.Add(t);
             }
             db.SaveChanges();
         }
     }
     catch (DbUpdateException ex)
     {
         MessageBox.Show(SqlServerErrorManagment.ShowError(ex, "پیمانکار"), "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message, "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
 }
 private void Edit()
 {
     try
     {
         int ID = Convert.ToInt32(GridTankhah.Rows[Row].Cells[0].Value);
         Tankhah T = ListTankhah.Single(p => p.TankhahID == ID);
         T.TankhahName = Txt_FName.Text.Trim();
         foreach (var item in T.PhoneBooks.ToList())
         {
             T.PhoneBooks.Remove(item);
         }
         String s;
         foreach (Object selecteditem in listBox_Tels.Items)
         {
             s = selecteditem as String;
             PhoneBook t = new PhoneBook()
             {
                 TankhahID = T.TankhahID,
                 PNumber = s,
             };
             db.PhoneBooks.Add(t);
         }
         db.SaveChanges();
         List<PhoneBook> ListT = db.PhoneBooks.ToList<PhoneBook>();
         foreach (var item in ListT)
         {
             if (item.TankhahID == null && item.ContractorID == null)
                 db.PhoneBooks.Remove(item);
         }
         db.SaveChanges();
         Btn_Register.Enabled = true;
         Btn_Edit.Enabled = false;
         utility.Show_Message("اطلاعات این تنخواه با موفقیت ویرایش شد", "ویرایش");
         GetData();
         ShowData();
         Clear();
     }
     catch (DbUpdateException ex)
     {
         MessageBox.Show(SqlServerErrorManagment.ShowError(ex, "تنخواه"), "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message, "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
 }
 private void Edit()
 {
     try
     {
         Contractor C = ListContractor.Single(p => p.ContractorID == Convert.ToInt32(GridContractor.Rows[Row].Cells["ContractorID"].Value));
         C.CName = Txt_FName.Text.Trim();
         foreach (Skill item in C.Skills.ToList())
         {
             C.Skills.Remove(item);
         }
         foreach (string item in listBox_Skill.Items)
         {
             Skill S = (from V in db.Skills where V.SkillName == item select V).FirstOrDefault();
             C.Skills.Add(S);
         }
         foreach (var item in C.PhoneBooks.ToList())
         {
             C.PhoneBooks.Remove(item);
         }
         String s;
         foreach (Object selecteditem in listBox_Tels.Items)
         {
             s = selecteditem as String;
             PhoneBook t = new PhoneBook()
             {
                 ContractorID = C.ContractorID,
                 PNumber = s,
             };
             db.PhoneBooks.Add(t);
         }
         db.SaveChanges();
         List<PhoneBook> ListT = db.PhoneBooks.ToList<PhoneBook>();
         foreach (var item in ListT)
         {
             if (item.TankhahID == null && item.ContractorID == null)
                 db.PhoneBooks.Remove(item);
         }
         db.SaveChanges();
         utility.Show_Message("اطلاعات این پیمانکار با موفقیت ویرایش شد", "ویرایش");
         GetData();
         ShowDatainGrid();
         Clear();
         Btn_Edit.Enabled = false;
     }
     catch (DbUpdateException ex)
     {
         MessageBox.Show(SqlServerErrorManagment.ShowError(ex, "حرفه"), "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message, "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
 }