Esempio n. 1
0
        //BOTÓN BUSCAR POR ID
        private void BtnBuscarID_Click(object sender, System.Windows.RoutedEventArgs e)
        {
            int id;

            if (int.TryParse(TxtID.Text, out id) == true)
            {
                personasBusquedas.Clear();
                DtgClientes.ItemsSource = null;

                /*Recorre el Array de personas y si encuentra el ID que escribimos
                 * agrega la persona*/
                foreach (Persona i in Contenedor.ArrayPersonas)
                {
                    if (i.IdPersona.ToString() == TxtID.Text)
                    {
                        personasBusquedas.Add(i);
                    }
                }
                MessageBox.Show(personasBusquedas.Count.ToString() + " clientes encontrados");

                //Muestra el Array
                DtgClientes.ItemsSource = null;
                DtgClientes.ItemsSource = personasBusquedas;

                TxtID.Clear();

                TxtBuscar.IsEnabled = true;
                BtnBuscar.IsEnabled = true;
            }

            else
            {
                MessageBox.Show("Verificar ID");
            }
        }
Esempio n. 2
0
 private void CboTipoId_KeyPress(object sender, KeyPressEventArgs e)
 {
     if (e.KeyChar == 13)
     {
         TxtID.Focus();
     }
 }
Esempio n. 3
0
 /// <summary>Resets all TextBoxes to the default data.</summary>
 private void Reset()
 {
     TxtID.Text        = School.CurrentStudent.Id;
     TxtFirstName.Text = School.CurrentStudent.FirstName;
     TxtLastName.Text  = School.CurrentStudent.LastName;
     TxtID.Focus();
 }
 /// <summary>Clears all TextBoxes.</summary>
 private void Clear()
 {
     TxtID.Clear();
     TxtFirstName.Clear();
     TxtLastName.Clear();
     TxtID.Focus();
 }
Esempio n. 5
0
 private void BtnReset_Click(object sender, EventArgs e)
 {
     TxtID.Clear();
     TxtName.Clear();
     ChkClose.Checked = false;
     ChkOpen.Checked  = false;
 }
Esempio n. 6
0
        private void BtnCancel_Click(object sender, EventArgs e)
        {
            TxtID.Text  = string.Empty;
            TxtPwd.Text = string.Empty;

            TxtID.Focus();
        }
Esempio n. 7
0
        private void BtnSearchProduct_Click(object sender, EventArgs e)
        {
            if (invoice.Client != null)
            {
                if (TxtID.Text != "")
                {
                    SearchProductAnswer answer  = productService.Search(TxtID.Text);
                    Product             product = answer.Product;

                    if (answer.Product != null)
                    {
                        TxtID.Text                = product.ID;
                        TxtName.Text              = product.Name;
                        TxtUnitMeasure.Text       = product.UnitMeasure;
                        TxtWarehouseQuantity.Text = product.Quantity.ToString();
                        TxtUnitValue.Text         = product.UnitValue.ToString();
                        TxtIVA.Text               = product.IVA.ToString();

                        TxtQuantity.Text = "0";
                        TxtDiscount.Text = "0";
                    }

                    MessageBox.Show(answer.Message);
                }
                else
                {
                    MessageBox.Show("Debe ingrasar un codigo de producto para realizar la busqueda!");
                    TxtID.Focus();
                }
            }
            else
            {
                MessageBox.Show("Primero debe agragarun cliente a la factura!");
            }
        }
Esempio n. 8
0
        private void InitControls()
        {
            TxtID.Text   = TxtAuthor.Text = string.Empty;
            TxtISBN.Text = TxtNames.Text = TxtPrice.Text = string.Empty;
            CboDivision.SelectedIndex = 0; //선택

            TxtID.Focus();
            TxtID.ReadOnly = true;

            DtpReleaseDate.CustomFormat = "yyyy-MM-dd";
            DtpReleaseDate.Format       = DateTimePickerFormat.Custom;
            DtpReleaseDate.Value        = DateTime.Now;


            myMode = BaseMode.NONE;

            ////콤보 박스 데이터 바인딩
            //Dictionary<string, string> dic = new Dictionary<string, string>();
            //dic.Add("선택", "00");
            //dic.Add("서울특별시", "11");//key value
            //dic.Add("부산광역시", "21");
            //dic.Add("대구광역시", "22");
            //dic.Add("인천광역시", "23");
            //dic.Add("광주광역시", "24");
            //dic.Add("대전광역시", "25");

            //CboDivision.DataSource = new BindingSource(dic,null); //폼의 데이터 소스 캡슐화
            //CboDivision.DisplayMember = "key";
            //CboDivision.ValueMember = "Value";
        }
Esempio n. 9
0
 public NewClassView()
 {
     InitializeComponent();
     TxtID.Focus();
     CmbCourse.ItemsSource  = School.AllCourses;
     CmbTeacher.ItemsSource = School.AllTeachers;
 }
Esempio n. 10
0
        public LoadFromID(DataSet data)
        {
            InitializeComponent();

            _data = data;
            TxtID.Focus();
        }
 private void BtGuardar_Click(object sender, EventArgs e)
 {
     try
     {
         MemoryStream ms = new System.IO.MemoryStream();
         PBImage.Image.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
         DataBaseControl DbControl  = new DataBaseControl(DataBaseControl.cPath, "ProjectDataBase.mdf");
         string[]        parameters = { "@id", "@nombre", "@image" };
         string[]        values     = { TxtID.Text, TxtNombre.Text };
         if (DbControl.Insertar("Insert into Maestros values (@id,@nombre,@image)", parameters, values, ms))
         {
             MessageBox.Show(string.Format("{0} agregado", TxtNombre.Text));
             TxtID.Clear();
             TxtNombre.Clear();
             PBImage.Image = Image.FromFile("intec.png");
             Verificar();
         }
         else
         {
             MessageBox.Show(string.Format("{0} no agregado", TxtNombre.Text));
         }
     }
     catch (Exception)
     {
         MessageBox.Show("Por favor, revisar los valores agregados");
     }
 }
Esempio n. 12
0
 public FrmPrincipal()
 {
     InitializeComponent();
     TxtID.Focus();
     label6.Text = "0.0";
     GrillaConsultar.DataSource = PersonaService.Consutar();
 }
Esempio n. 13
0
 private void LimpiarCajas()
 {
     TxtID.Text        = "";
     TxtNombre.Text    = "";
     TxtUsuarioID.Text = "";
     TxtDNI.Text       = "";
     TxtTelefono.Text  = "";
     TxtID.Focus();
 }
Esempio n. 14
0
        private void BtnSave_Click(object sender, EventArgs e)
        {
            Product product = MapOutProduct();

            MessageBox.Show(productService.Save(product));
            FillTable();
            EmptyTextBoxes();
            TxtID.Focus();
        }
Esempio n. 15
0
 public FindForm()
 {
     InitializeComponent();
     CboQ.IsAccessible = false;
     TxtID.Focus();
     label4.Visible = CboQ.Visible = CheckButton.Visible = true;
     Txt.Text       = "ID";
     PWA.Text       = "비번 답";
     Find.Text      = "찾기";
 }
        } // end method BtnAddClear_Click()

        /// <summary>
        /// To clear the add course fields
        /// </summary>
        private void AddClear()
        {
            //Clear all Add fields
            CBxInstitution.ResetText();
            TxtID.Clear();
            TxtDescription.Clear();
            CBxGrade.SelectedIndex   = -1;
            CBxGrade.Text            = string.Empty;
            CBxCredits.SelectedIndex = -1;
            CBxCredits.Text          = string.Empty;
        } // end method AddClear()
Esempio n. 17
0
 private void ChangePW()
 {
     TxtID.Focus();
     TxtID.PasswordChar = txtA.PasswordChar = '♥';
     CK             = 1;
     TxtID.Text     = txtA.Text = "";
     Txt.Text       = "새 비번";
     PWA.Text       = "새 비번 확인";
     label4.Visible = CboQ.Visible = CheckButton.Visible = false;
     Find.Text      = "비번 바꾸기";
 }
Esempio n. 18
0
 private void TxtContact_KeyUp(object sender, KeyEventArgs e)
 {
     switch (e.KeyCode)
     {
     case Keys.Enter:
     {
         TxtID.SelectAll();
         TxtID.Focus();
         break;
     }
     }
 }
Esempio n. 19
0
        }     // end method TxtID_Leave()

        /// <summary>
        /// To reset all controls on the add_emp form to their defaults
        /// </summary>
        private void ResetFields()
        {
            //Clear all txtboxes and reset radioBtns to HOURLY
            TxtID.Clear();
            TxtFirstName.Clear();
            TxtLastName.Clear();
            TxtHourlyRate.Clear();
            TxtMonthlySalary.Clear();
            TxtCommissionRate.Clear();
            TxtContractWage.Clear();
            RBtnHourly.Checked = true;
        } // end method ResetFields()
Esempio n. 20
0
 void temizle()
 {
     TxtID.Text       = "";
     TxtSinav1.Text   = "";
     TxtSinav2.Text   = "";
     TxtSinav3.Text   = "";
     TxtProje.Text    = "";
     comboBox1.Text   = "";
     TxtOrtalama.Text = "";
     TxtDurum.Text    = "";
     TxtID.Focus();
 }
Esempio n. 21
0
        public void ClearTextBoxes()
        {
            TxtID.Clear();
            TxtName.Clear();
            TxtUnitMeasure.Clear();
            TxtQuantity.Clear();
            TxtUnitValue.Clear();
            TxtIVA.Clear();
            TxtWarehouseQuantity.Clear();
            TxtDiscount.Clear();

            TxtID.Focus();
        }
Esempio n. 22
0
 private void BtnTemizle_Click(object sender, EventArgs e)
 {
     TxtYil.Clear();
     TxtAy.Clear();
     TxtTarih.Clear();
     TxtFirma.Clear();
     TxtSube.Clear();
     TxtTutar1.Clear();
     TxtTutar2.Clear();
     TxtTtutar3.Clear();
     TxtID.Clear();
     TxtYil.Focus();
 }
Esempio n. 23
0
        private void BtnCancel_Click(object sender, EventArgs e)
        {
            TxtID.Text              = string.Empty;
            TxtNickName.Text        = string.Empty;
            TxtPwd.Text             = string.Empty;
            TxtPwdConfirm.Text      = string.Empty;
            TxtMailAddress.Text     = string.Empty;
            TxtVerticationCode.Text = string.Empty;
            CmbPwdQuestion.Text     = string.Empty;
            TxtPwdAnswer.Text       = string.Empty;

            TxtID.Focus();
        }
Esempio n. 24
0
        private void FrmSinavNotlar_Load(object sender, EventArgs e)
        {
            TxtID.Focus();

            baglanti.Open();
            SqlCommand     komut = new SqlCommand("Select*From TBLDERSLER", baglanti);
            SqlDataAdapter da    = new SqlDataAdapter(komut);
            DataTable      dt    = new DataTable();

            da.Fill(dt);
            comboBox1.DisplayMember = "DERSAD";
            comboBox1.ValueMember   = "DERSID";
            comboBox1.DataSource    = dt;
            baglanti.Close();
        }
Esempio n. 25
0
 /// <summary>Clears all TextBoxes.</summary>
 private void Clear()
 {
     TxtID.Clear();
     CmbCourse.SelectedIndex  = -1;
     CmbTeacher.SelectedIndex = -1;
     TxtDaily.Clear();
     TxtHomework.Clear();
     TxtProject.Clear();
     TxtQuiz.Clear();
     TxtReport.Clear();
     TxtTest.Clear();
     TxtStartTime.Text = "9:00 AM";
     TxtEndTime.Text   = "9:50 AM";
     TxtID.Focus();
     TxtError.Visibility = Visibility.Collapsed;
 }
Esempio n. 26
0
        private void BtnEditar_Click(object sender, EventArgs e)
        {
            if (DGV.SelectedRows.Count > 0)
            {
                Editar            = true;
                TxtID.Text        = DGV.CurrentRow.Cells[0].Value.ToString();
                TxtNombre.Text    = DGV.CurrentRow.Cells[1].Value.ToString();
                TxtUsuarioID.Text = DGV.CurrentRow.Cells[2].Value.ToString();
                TxtDNI.Text       = DGV.CurrentRow.Cells[3].Value.ToString();
                TxtTelefono.Text  = DGV.CurrentRow.Cells[4].Value.ToString();

                TxtID.Focus();
            }
            else
            {
                MensajeError("Seleccione una fila primero.");
            }
        }
Esempio n. 27
0
        //验证是否为空
        private bool ValidateInput()
        {
            bool isOk = true;

            if (TxtID.Text == "")
            {
                TxtID.BackColor = Color.Red;
                TxtID.Focus();
                isOk = false;
            }
            if (Txtname.Text == "")
            {
                Txtname.BackColor = Color.Red;
                Txtname.Focus();
                isOk = false;
            }
            if (Txtpwd.Text == "")
            {
                Txtpwd.BackColor = Color.Red;
                Txtpwd.Focus();
                isOk = false;
            }
            if (txtAddress.Text == "")
            {
                txtAddress.BackColor = Color.Red;
                txtAddress.Focus();
                isOk = false;
            }
            if (TxtpaperID.Text == "")
            {
                TxtpaperID.BackColor = Color.Red;
                TxtpaperID.Focus();
                isOk = false;
            }
            if (TxtcontactTel.Text == "")
            {
                TxtcontactTel.BackColor = Color.Red;
                TxtcontactTel.Focus();
                isOk = false;
            }

            return(isOk);  //返回结果
        }
Esempio n. 28
0
 /// <summary>
 /// actually clears each textbox in the form
 /// </summary>
 private void ClearNewEmpForm()
 {
     EpForm.Clear();
     TxtID.Clear();
     TxtFirstName.Clear();
     TxtLastName.Clear();
     TxtAddress.Clear();
     TxtCity.Clear();
     CBxState.SelectedIndex = -1;
     CBxEmpType.SelectedIndex = -1;
     TxtZip.Clear();
     TxtHireDate.Clear();
     CBxMarriageStatus.SelectedIndex = -1;
     TxtDept.Clear();
     TxtJobTitle.Clear();
     LblAfterSubmitMsg.Text = "";
     TxtPayAmount.Visible = false;
     LblPayAmount.Visible = false;
     LblSecondInput.Visible = false;
     TxtSecondInput.Visible = false;
 }
Esempio n. 29
0
        private void BtnAdd_Click(object sender, EventArgs e)
        {
            if (!string.IsNullOrEmpty(TxtTitle.Text) && !string.IsNullOrEmpty(TxtID.Text) && comboBoxCredits.Text != null && comboBoxDepartments.Text != null && comboBoxInstructors.Text != null)
            {
                using (var db = new SchoolEntities())
                {
                    // converting id text to number
                    Int32.TryParse(TxtID.Text, out Int32 ID);

                    // converting department name to department id
                    var deptID = from o in db.Department
                                 where o.Name.Equals(comboBoxDepartments.SelectedItem.ToString())
                                 select o.DepartmentID;

                    Int32.TryParse(deptID.First().ToString(), out Int32 finalDeptID);


                    // converting credits from combobox selection to number
                    Int32.TryParse(comboBoxCredits.SelectedItem.ToString(), out Int32 credits);

                    var course = new Course {
                        CourseID = ID, Title = TxtTitle.Text, Credits = credits, DepartmentID = finalDeptID
                    };
                    db.Course.Add(course);

                    // course instructor part
                    // missing from model (?)
                    //var courseInstructor = db.


                    db.SaveChanges();
                    dataGridView1.DataSource = db.Course.ToList();
                }
                TxtID.ResetText();
                TxtTitle.ResetText();
                comboBoxCredits.SelectedItem     = null;
                comboBoxDepartments.SelectedItem = null;
                comboBoxInstructors.SelectedItem = null;
            }
        }
Esempio n. 30
0
        private void CHECK_ID()
        {
            string strQuery = "SELECT id FROM member " + //반드시 뒤에 SpaceBar를 넣어줘야됨(안넣으면 userTBLWHERE로 붙어져서 Syntax Error나옴)
                              " WHERE id = @id ";        //@userID로 사용안하고 직접적 ID(TxtUserID)를 바로 넣으면 SQL Injection으로 해킹위험이 나옴

            try
            {
                using (MySqlConnection conn = new MySqlConnection(strConnString))
                {
                    conn.Open();
                    //MetroMessageBox.Show(this, $"DB접속성공!!");
                    MySqlCommand cmd = new MySqlCommand();
                    cmd.Connection  = conn;
                    cmd.CommandText = strQuery;
                    MySqlParameter paramUserId = new MySqlParameter("@id", MySqlDbType.VarChar, 45);
                    cmd.Parameters.Add(paramUserId);
                    paramUserId.Value = TxtID.Text.Trim();
                    MySqlDataReader reader = cmd.ExecuteReader();
                    reader.Read();

                    if (reader.HasRows)
                    {
                        MessageBox.Show("등록아이디가 있습니다.");
                        CboQ.Focus();
                        CboQ.IsAccessible = true;
                    }
                    else
                    {
                        MessageBox.Show("없는 아이디 입니다.");
                        TxtID.Text = null;
                        TxtID.Focus();
                    }
                }
            }
            catch (Exception e)
            {
                MessageBox.Show(e.Message);
            }
        }