private void cmbBoxAboda_SelectionChangeCommitted(object sender, EventArgs e)
        {
            int     kod = Convert.ToInt32(cmbHazmzna.SelectedValue);
            DataRow dr  = mypirteHazmanots.Find(kod);

            this.mypirteHazmana = new pirteHazmana(dr);

            FillFields();

            grbPirteHazmana.Enabled = true;
            btnUpdate.Enabled       = true;
        }
        private void cmbPirty_SelectionChangeCommitted(object sender, EventArgs e)
        {
            int     kod = Convert.ToInt32(cmbPirty.SelectedValue);
            DataRow dr  = mypirteHazmanots.Find(kod);

            this.mypirteHazmana = new pirteHazmana(dr);//חיפשתי את השורה שבה הקוד פרטי הזמנה הוא כמו שבחרתי בקומבובוקס

            FillFields();

            grbPirteHazmana.Enabled = true;
            btnUpdate.Enabled       = true;
        }
        public bool BuildObjectByFields()
        {
            errorProvider1.Clear();
            bool ok = true;

            this.mypirteHazmana = new pirteHazmana();

            try
            {
                this.mypirteHazmana.KodPirteyHazmana = Convert.ToInt32(lblKodPirteHazmana.Text);
            }
            catch (Exception ex)
            {
                errorProvider1.SetError(lblKodPirteHazmana, ex.Message);
                ok = false;
            }
            try
            {
                this.mypirteHazmana.KodHazmana = Convert.ToInt32(lblHazmana.Text);
            }
            catch (Exception ex)
            {
                errorProvider1.SetError(lblHazmana, ex.Message);
                ok = false;
            }
            try
            {
                this.mypirteHazmana.KodAboda = Convert.ToInt32(cmbKodAboda.SelectedValue);
            }
            catch (Exception ex)
            {
                errorProvider1.SetError(cmbKodAboda, ex.Message);
                ok = false;
            }
            try
            {
                this.mypirteHazmana.DestinationDate = Convert.ToDateTime(txtDestinationDate.Text);
            }
            catch (Exception ex)
            {
                errorProvider1.SetError(txtDestinationDate, ex.Message);
                ok = false;
            }
            try
            {
                this.mypirteHazmana.Amount = Convert.ToInt32(txtAmount.Text);
            }
            catch (Exception ex)
            {
                errorProvider1.SetError(txtAmount, ex.Message);
                ok = false;
            }
            try
            {
                this.mypirteHazmana.KodSogKlaf = Convert.ToInt32(cmbSogKlaf.SelectedValue);
            }
            catch (Exception ex)
            {
                errorProvider1.SetError(cmbSogKlaf, ex.Message);
                ok = false;
            }
            try
            {
                this.mypirteHazmana.Price = Convert.ToInt32(txtPrice.Text);
            }
            catch (Exception ex)
            {
                errorProvider1.SetError(txtPrice, ex.Message);
                ok = false;
            }
            try
            {
                this.mypirteHazmana.Status = Convert.ToBoolean(checkBoxMade.Checked);
            }
            catch (Exception ex)
            {
                errorProvider1.SetError(checkBoxMade, ex.Message);
                ok = false;
            }
            return(ok);
        }
        private void btnAdd_Click(object sender, EventArgs e)
        {
            pirteHazmana p1 = new pirteHazmana();

            try
            {
                p1.KodPirteyHazmana = Convert.ToInt32(lblKodPirteHazmana.Text);
            }
            catch (Exception ex)
            {
                errorProvider1.SetError(lblKodPirteHazmana, ex.Message);
            }
            try
            {
                p1.KodHazmana = Convert.ToInt32(lblHazmana.Text);
            }
            catch (Exception ex)
            {
                errorProvider1.SetError(lblHazmana, ex.Message);
            }
            try
            {
                p1.KodAboda = Convert.ToInt32(cmbKodAboda.SelectedValue);
            }
            catch (Exception ex)
            {
                errorProvider1.SetError(cmbKodAboda, ex.Message);
            }
            try
            {
                p1.DestinationDate = Convert.ToDateTime(txtDestinationDate.Text);
            }
            catch (Exception ex)
            {
                errorProvider1.SetError(txtDestinationDate, ex.Message);
            }
            try
            {
                p1.Amount = Convert.ToInt32(txtAmount.Text);
            }
            catch (Exception ex)
            {
                errorProvider1.SetError(txtAmount, ex.Message);
            }
            try
            {
                p1.KodSogKlaf = Convert.ToInt32(cmbSogKlaf.SelectedValue);
            }
            catch (Exception ex)
            {
                errorProvider1.SetError(cmbSogKlaf, ex.Message);
            }
            try
            {
                p1.Price = Convert.ToInt32(txtPrice.Text);
            }
            catch (Exception ex)
            {
                errorProvider1.SetError(txtPrice, ex.Message);
            }
            try
            {
                p1.Status = Convert.ToBoolean(checkBoxMade.Checked);
            }
            catch (Exception ex)
            {
                errorProvider1.SetError(checkBoxMade, ex.Message);
            }
            bool ok = BuildObjectByFields();

            if (ok == true)
            {
                DataRow dr = this.mypirteHazmana.BuildRow();
                if (this.mypirteHazmanots.Add(dr))
                {
                    MessageBox.Show("פרטי ההזמנה התווספו בהצלחה");
                    clearFields();
                }
                else
                {
                    MessageBox.Show("הפרטים קיימים במאגר");
                }
            }
        }