public void ClearTextBoxes() { TextBox1.Clear(); TextBox2.Clear(); TextBox3.Clear(); TextBox4.Clear(); TextBox5.Clear(); TextBox6.Clear(); TextBox7.Clear(); TextBox8.Clear(); TextBoxID.Clear(); }
private void ClearButton_Click(object sender, RoutedEventArgs e) { TextBoxID.Clear(); TextBoxName.Clear(); TextBoxCompany.Clear(); TextBoxCity.Clear(); TextBoxCountry.Clear(); ListBoxLog.Items.Insert(0, ""); ListBoxLog.Items.Insert(0, DateTime.Now); ListBoxLog.Items.Insert(0, "USER CLEARED TEXT"); }
//ClassPublicVar.TypeOperation _TypeOperation; // لفحص القيمة المدخلة هل هي موجوده مسبقا او لا\TextboxID دالة فحص public void SearchID(DataTable DtID) { foreach (DataRow row in DtID.Rows) { if (row[TableCostCenter.ID].ToString() == TextBoxID.Text) { MessageBox.Show("موجود مسبقا"); TextBoxID.Focus(); TextBoxID.Clear(); break; } } }
private void Button2_Click(object sender, RoutedEventArgs e) { if (!int.TryParse(TextBoxID.Text, out int id)) { MessageBox.Show("Unesite ceo broj"); TextBoxID.Clear(); TextBoxID.Focus(); return; } SqlDataAdapter da = new SqlDataAdapter("SELECT KupacId as Id, ImeKompanije as Firma, KontaktOsoba as Kontakt FROM Prodaja.Kupci", Konekcija.cnnTSQL2018); da.MissingSchemaAction = MissingSchemaAction.AddWithKey; //preuz info o primary key DataSet ds = new DataSet(); //netipizirani ds DataRow dr = null; try { da.Fill(ds, "Kupci"); DataTable tbl = ds.Tables[0]; dr = tbl.Rows.Find(id); } catch (Exception xcp) { MessageBox.Show(xcp.Message); return; } StringBuilder sb = new StringBuilder(); if (dr != null) { sb.AppendLine(dr[0].ToString()); sb.AppendLine(dr[1].ToString()); sb.AppendLine(dr[2].ToString()); } else { sb.AppendLine("Ne postoji kupac ciji je id: " + id); } TextBlock1.Text = sb.ToString(); }
//public void SearchGroupID(DataTable DTGroupID) //{ // foreach (DataRow row in DtID.Rows) // { // object sss = row[TableCostCenter.ID]; // if (sss = DBNull.Value) // { // MessageBox.Show("غير موجود"); // TextBoxID.Focus(); // break; // } // } //} private void ToolsStatus() { if (_TypeOperation == ClassPublicVar.TypeOperation.Show) { TextBoxID.ReadOnly = true; TextBoxGroupID.ReadOnly = true; TextBoxGroupName.ReadOnly = true; TextBoxNameLng1.ReadOnly = true; TextBoxNameLng2.ReadOnly = true; ButtonNew.Enabled = true; ButtonEdit.Enabled = true; ButtonSave.Enabled = false; ButtonDelete.Enabled = true; ButtonPrint.Enabled = true; ButtonSearch.Enabled = true; ButtonCancel.Enabled = false; ButtonExit.Enabled = true; TreeViewMain.Enabled = true; RadioBtnGroup.Enabled = false; RadioBtnNotGroup.Enabled = false; buttonGroupSearch.Enabled = false; ButtonLast.Enabled = true; ButtonNext.Enabled = true; ButtonPrevious.Enabled = true; ButtonFirst.Enabled = true; TextBoxID.Clear(); TextBoxGroupID.Clear(); TextBoxGroupName.Clear(); TextBoxNameLng1.Clear(); TextBoxNameLng2.Clear(); } else if (_TypeOperation == ClassPublicVar.TypeOperation.Add) { TextBoxID.ReadOnly = false; TextBoxGroupID.ReadOnly = false; TextBoxGroupName.ReadOnly = true; TextBoxNameLng1.ReadOnly = false; TextBoxNameLng2.ReadOnly = false; RadioBtnNotGroup.Checked = true; ButtonNew.Enabled = true; ButtonEdit.Enabled = false; ButtonSave.Enabled = true; ButtonDelete.Enabled = false; ButtonPrint.Enabled = false; ButtonSearch.Enabled = false; ButtonCancel.Enabled = true; ButtonExit.Enabled = false; RadioBtnGroup.Enabled = true; RadioBtnNotGroup.Enabled = true; buttonGroupSearch.Enabled = true; TreeViewMain.Enabled = false; ButtonLast.Enabled = false; ButtonNext.Enabled = false; ButtonPrevious.Enabled = false; ButtonFirst.Enabled = false; TextBoxID.Clear(); TextBoxGroupID.Clear(); TextBoxGroupName.Clear(); TextBoxNameLng1.Clear(); TextBoxNameLng2.Clear(); } else if (_TypeOperation == ClassPublicVar.TypeOperation.Edit) { TextBoxID.ReadOnly = true; TextBoxGroupID.ReadOnly = false; TextBoxGroupName.ReadOnly = true; TextBoxNameLng1.ReadOnly = false; TextBoxNameLng2.ReadOnly = false; ButtonNew.Enabled = false; ButtonEdit.Enabled = false; ButtonSave.Enabled = true; ButtonDelete.Enabled = false; ButtonPrint.Enabled = false; ButtonSearch.Enabled = false; ButtonCancel.Enabled = true; ButtonExit.Enabled = false; RadioBtnGroup.Enabled = true; RadioBtnNotGroup.Enabled = true; buttonGroupSearch.Enabled = true; TreeViewMain.Enabled = false; ButtonLast.Enabled = false; ButtonNext.Enabled = false; ButtonPrevious.Enabled = false; ButtonFirst.Enabled = false; //TextBoxID.Clear(); //TextBoxGroupID.Clear(); //TextBoxGroupName.Clear(); //TextBoxNameLng1.Clear(); //TextBoxNameLng2.Clear(); } }
private void ToolsStatus() { if (_TypeOperation == ClassPublicVar.TypeOperation.Show) { TextBoxMainID.ReadOnly = true; TextBoxMainName.ReadOnly = true; TextBoxID.ReadOnly = true; TextBoxGroupID.ReadOnly = true; TextBoxGroupName.ReadOnly = true; TextBoxNameLng1.ReadOnly = true; TextBoxNameLng2.ReadOnly = true; TextBoxPhone.ReadOnly = true; TextBoxeFax.ReadOnly = true; TextBoxAddress.ReadOnly = true; TextBoxRentStartDate.ReadOnly = true; TextBoxRentEndDate.ReadOnly = true; TextBoxCrNO.ReadOnly = true; TextBoxCrLssDate.ReadOnly = true; TextBoxCrExpDate.ReadOnly = true; TextBoxMunicp.ReadOnly = true; TextBoxMunicpLssDate.ReadOnly = true; TextBoxMunicpExpDate.ReadOnly = true; TxtBoxAdvocatteship.ReadOnly = true; TxtBoxAdvocatteshipLssDate.ReadOnly = true; TxtBoxAdvocatteshipExpDate.ReadOnly = true; ButtonNew.Enabled = true; ButtonEdit.Enabled = true; ButtonSave.Enabled = false; ButtonDelete.Enabled = true; ButtonPrint.Enabled = true; ButtonSearch.Enabled = true; ButtonCancel.Enabled = false; ButtonExit.Enabled = true; TreeViewMain.Enabled = true; RadioBtnGroup.Enabled = false; RadioBtnNotGroup.Enabled = false; buttonGroupSearch.Enabled = false; ButtonLast.Enabled = true; ButtonNext.Enabled = true; ButtonPrevious.Enabled = true; ButtonFirst.Enabled = true; TextBoxMainID.Clear(); TextBoxMainName.Clear(); TextBoxID.Clear(); TextBoxGroupID.Clear(); TextBoxGroupName.Clear(); TextBoxNameLng1.Clear(); TextBoxNameLng2.Clear(); TextBoxPhone.Clear(); TextBoxeFax.Clear(); TextBoxAddress.Clear(); TextBoxRentStartDate.Clear(); TextBoxRentEndDate.Clear(); TextBoxCrNO.Clear(); TextBoxCrLssDate.Clear(); TextBoxCrExpDate.Clear(); TextBoxMunicp.Clear(); TextBoxMunicpLssDate.Clear(); TextBoxMunicpExpDate.Clear(); TxtBoxAdvocatteship.Clear(); TxtBoxAdvocatteshipLssDate.Clear(); TxtBoxAdvocatteshipExpDate.Clear(); } else if (_TypeOperation == ClassPublicVar.TypeOperation.Add) { TextBoxMainID.ReadOnly = false; TextBoxMainName.ReadOnly = false; TextBoxID.ReadOnly = false; TextBoxGroupID.ReadOnly = false; TextBoxGroupName.ReadOnly = true; TextBoxNameLng1.ReadOnly = false; TextBoxNameLng2.ReadOnly = false; TextBoxPhone.ReadOnly = false; TextBoxeFax.ReadOnly = false; TextBoxAddress.ReadOnly = false; TextBoxRentStartDate.ReadOnly = false; TextBoxRentEndDate.ReadOnly = false; TextBoxCrNO.ReadOnly = false; TextBoxCrLssDate.ReadOnly = false; TextBoxCrExpDate.ReadOnly = false; TextBoxMunicp.ReadOnly = false; TextBoxMunicpLssDate.ReadOnly = false; TextBoxMunicpExpDate.ReadOnly = false; TxtBoxAdvocatteship.ReadOnly = false; TxtBoxAdvocatteshipLssDate.ReadOnly = false; TxtBoxAdvocatteshipExpDate.ReadOnly = false; RadioBtnNotGroup.Checked = true; ButtonNew.Enabled = true; ButtonEdit.Enabled = false; ButtonSave.Enabled = true; ButtonDelete.Enabled = false; ButtonPrint.Enabled = false; ButtonSearch.Enabled = false; ButtonCancel.Enabled = true; ButtonExit.Enabled = false; TreeViewMain.Enabled = false; RadioBtnGroup.Enabled = true; RadioBtnNotGroup.Enabled = true; buttonGroupSearch.Enabled = true; ButtonLast.Enabled = false; ButtonNext.Enabled = false; ButtonPrevious.Enabled = false; ButtonFirst.Enabled = false; TextBoxMainID.Clear(); TextBoxMainName.Clear(); TextBoxID.Clear(); TextBoxGroupID.Clear(); TextBoxGroupName.Clear(); TextBoxNameLng1.Clear(); TextBoxNameLng2.Clear(); TextBoxPhone.Clear(); TextBoxeFax.Clear(); TextBoxAddress.Clear(); TextBoxRentStartDate.Clear(); TextBoxRentEndDate.Clear(); TextBoxCrNO.Clear(); TextBoxCrLssDate.Clear(); TextBoxCrExpDate.Clear(); TextBoxMunicp.Clear(); TextBoxMunicpLssDate.Clear(); TextBoxMunicpExpDate.Clear(); TxtBoxAdvocatteship.Clear(); TxtBoxAdvocatteshipLssDate.Clear(); TxtBoxAdvocatteshipExpDate.Clear(); } else if (_TypeOperation == ClassPublicVar.TypeOperation.Edit) { TextBoxMainID.ReadOnly = false; TextBoxMainName.ReadOnly = false; TextBoxID.ReadOnly = true; TextBoxGroupID.ReadOnly = false; TextBoxGroupName.ReadOnly = true; TextBoxNameLng1.ReadOnly = false; TextBoxNameLng2.ReadOnly = false; TextBoxPhone.ReadOnly = false; TextBoxeFax.ReadOnly = false; TextBoxAddress.ReadOnly = false; TextBoxRentStartDate.ReadOnly = false; TextBoxRentEndDate.ReadOnly = false; TextBoxCrNO.ReadOnly = false; TextBoxCrLssDate.ReadOnly = false; TextBoxCrExpDate.ReadOnly = false; TextBoxMunicp.ReadOnly = false; TextBoxMunicpLssDate.ReadOnly = false; TextBoxMunicpExpDate.ReadOnly = false; TxtBoxAdvocatteship.ReadOnly = false; TxtBoxAdvocatteshipLssDate.ReadOnly = false; TxtBoxAdvocatteshipExpDate.ReadOnly = false; ButtonNew.Enabled = false; ButtonEdit.Enabled = false; ButtonSave.Enabled = true; ButtonDelete.Enabled = false; ButtonPrint.Enabled = false; ButtonSearch.Enabled = false; ButtonCancel.Enabled = true; ButtonExit.Enabled = false; TreeViewMain.Enabled = false; RadioBtnGroup.Enabled = true; RadioBtnNotGroup.Enabled = true; buttonGroupSearch.Enabled = true; ButtonLast.Enabled = false; ButtonNext.Enabled = false; ButtonPrevious.Enabled = false; ButtonFirst.Enabled = false; //TextBoxMainID.Clear(); //TextBoxMainName.Clear(); //TextBoxID.Clear(); //TextBoxGroupID.Clear(); //TextBoxGroupName.Clear(); //TextBoxNameLng1.Clear(); //TextBoxNameLng2.Clear(); //TextBoxPhone.Clear(); //TextBoxeFax.Clear(); //TextBoxAddress.Clear(); //TextBoxRentStartDate.Clear(); //TextBoxRentEndDate.Clear(); //TextBoxCrNO.Clear(); //TextBoxCrLssDate.Clear(); //TextBoxCrExpDate.Clear(); //TextBoxMunicp.Clear(); //TextBoxMunicpLssDate.Clear(); //TextBoxMunicpExpDate.Clear(); //TxtBoxAdvocatteship.Clear(); //TxtBoxAdvocatteshipLssDate.Clear(); //TxtBoxAdvocatteshipExpDate.Clear(); } }
private void ToolsStatus() { if (_TypeOperation == ClassPublicVar.TypeOperation.Show) { TextBoxID.ReadOnly = true; TextBoxGroupID.ReadOnly = true; TextBoxGroupName.ReadOnly = true; TextBoxNameLng1.ReadOnly = true; TextBoxNameLng2.ReadOnly = true; TextBoxAddress.ReadOnly = true; TextBoxCity.ReadOnly = true; TextBoxEmail.ReadOnly = true; TextBoxTelephone1.ReadOnly = true; TextBoxTelephone2.ReadOnly = true; TextBoxFax.ReadOnly = true; TextBoxMobile.ReadOnly = true; TextBoxCreditLimit.ReadOnly = true; TextBoxDebitTrans.ReadOnly = true; TextBoxCreditTrans.ReadOnly = true; TextBoxBalance.ReadOnly = true; ButtonNew.Enabled = true; ButtonEdit.Enabled = true; ButtonSave.Enabled = false; ButtonDelete.Enabled = true; ButtonPrint.Enabled = true; ButtonSearch.Enabled = true; ButtonCancel.Enabled = false; ButtonExit.Enabled = true; TreeViewMain.Enabled = true; RadioBtnGroup.Enabled = false; RadioBtnNotGroup.Enabled = false; buttonGroupSearch.Enabled = false; ButtonExit.Enabled = true; ButtonLast.Enabled = true; ButtonNext.Enabled = true; ButtonPrevious.Enabled = true; ButtonFirst.Enabled = true; TextBoxID.Clear(); TextBoxGroupID.Clear(); TextBoxGroupName.Clear(); TextBoxNameLng1.Clear(); TextBoxNameLng2.Clear(); TextBoxAddress.Clear(); TextBoxCity.Clear(); TextBoxEmail.Clear(); TextBoxTelephone1.Clear(); TextBoxTelephone2.Clear(); TextBoxFax.Clear(); TextBoxMobile.Clear(); TextBoxCreditLimit.Clear(); TextBoxDebitTrans.Clear(); TextBoxCreditTrans.Clear(); TextBoxBalance.Clear(); } else if (_TypeOperation == ClassPublicVar.TypeOperation.Add) { TextBoxID.ReadOnly = false; TextBoxGroupID.ReadOnly = false; TextBoxGroupName.ReadOnly = true; TextBoxNameLng1.ReadOnly = false; TextBoxNameLng2.ReadOnly = false; TextBoxAddress.ReadOnly = false; TextBoxCity.ReadOnly = false; TextBoxEmail.ReadOnly = false; TextBoxTelephone1.ReadOnly = false; TextBoxTelephone2.ReadOnly = false; TextBoxFax.ReadOnly = false; TextBoxMobile.ReadOnly = false; TextBoxCreditLimit.ReadOnly = false; TextBoxDebitTrans.ReadOnly = false; TextBoxCreditTrans.ReadOnly = false; TextBoxBalance.ReadOnly = false; ButtonNew.Enabled = true; ButtonEdit.Enabled = false; ButtonSave.Enabled = true; ButtonDelete.Enabled = false; ButtonPrint.Enabled = false; ButtonSearch.Enabled = false; ButtonCancel.Enabled = true; ButtonExit.Enabled = false; TreeViewMain.Enabled = false; RadioBtnGroup.Enabled = true; RadioBtnNotGroup.Enabled = true; buttonGroupSearch.Enabled = true; ButtonExit.Enabled = false; ButtonLast.Enabled = false; ButtonNext.Enabled = false; ButtonPrevious.Enabled = false; ButtonFirst.Enabled = false; TextBoxID.Clear(); TextBoxGroupID.Clear(); TextBoxGroupName.Clear(); TextBoxNameLng1.Clear(); TextBoxNameLng2.Clear(); TextBoxAddress.Clear(); TextBoxCity.Clear(); TextBoxEmail.Clear(); TextBoxTelephone1.Clear(); TextBoxTelephone2.Clear(); TextBoxFax.Clear(); TextBoxMobile.Clear(); TextBoxCreditLimit.Clear(); TextBoxDebitTrans.Clear(); TextBoxCreditTrans.Clear(); TextBoxBalance.Clear(); } else if (_TypeOperation == ClassPublicVar.TypeOperation.Edit) { TextBoxID.ReadOnly = true; TextBoxGroupID.ReadOnly = false; TextBoxGroupName.ReadOnly = true; TextBoxNameLng1.ReadOnly = false; TextBoxNameLng2.ReadOnly = false; TextBoxAddress.ReadOnly = false; TextBoxCity.ReadOnly = false; TextBoxEmail.ReadOnly = false; TextBoxTelephone1.ReadOnly = false; TextBoxTelephone2.ReadOnly = false; TextBoxFax.ReadOnly = false; TextBoxMobile.ReadOnly = false; TextBoxCreditLimit.ReadOnly = false; TextBoxDebitTrans.ReadOnly = false; TextBoxCreditTrans.ReadOnly = false; TextBoxBalance.ReadOnly = false; ButtonNew.Enabled = true; ButtonEdit.Enabled = false; ButtonSave.Enabled = true; ButtonDelete.Enabled = false; ButtonPrint.Enabled = false; ButtonSearch.Enabled = false; ButtonCancel.Enabled = true; ButtonExit.Enabled = false; TreeViewMain.Enabled = false; RadioBtnGroup.Enabled = true; RadioBtnNotGroup.Enabled = true; buttonGroupSearch.Enabled = true; ButtonLast.Enabled = false; ButtonNext.Enabled = false; ButtonPrevious.Enabled = false; ButtonFirst.Enabled = false; //TextBoxID.Clear(); //TextBoxGroupID.Clear(); //TextBoxGroupName.Clear(); //TextBoxNameLng1.Clear(); //TextBoxNameLng2.Clear(); //TextBoxAddress.Clear(); //TextBoxCity.Clear(); //TextBoxEmail.Clear(); //TextBoxTelephone1.Clear(); //TextBoxTelephone2.Clear(); //TextBoxFax.Clear(); //TextBoxMobile.Clear(); //TextBoxCreditLimit.Clear(); //TextBoxDebitTrans.Clear(); //TextBoxCreditTrans.Clear(); //TextBoxBalance.Clear(); } }