private void btnSearchMember_Click(object sender, EventArgs e)
        {
            try
            {
                subscriber = subscriberBLL.Get(int.Parse(txtMemberID.Text));

                txtFirstName.Text       = subscriber.Name;
                txtLastName.Text        = subscriber.LastName;
                txtFullAddress.Text     = subscriber.Address;
                dtPickerBirthdate.Value = subscriber.Birthday;

                if (subscriber.Gender == 'M')
                {
                    radioMale.Checked = true;
                }
                else if (subscriber.Gender == 'F')
                {
                    radioFemale.Checked = true;
                }

                txtPersonalNumber.Text = subscriber.PersonalNo;
                txtEmail.Text          = subscriber.Email;
                txtPhoneNumber.Text    = subscriber.PhoneNo;

                bill = billBLL.Get(int.Parse(txtMemberID.Text));

                txtFromDate.Text = subscriber.InsDate.ToShortDateString();
                txtTillDate.Text = subscriber.ExpirationDate.ToShortDateString();
            }

            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        private void btnSearchMember_Click(object sender, EventArgs e)
        {
            try
            {
                int id = int.Parse(txtMemberID.Text);
                subscriber = subscriberBLL.Get(id);

                txtFirstName.Text      = subscriber.Name;
                txtLastName.Text       = subscriber.LastName;
                txtFullAddress.Text    = subscriber.Address;
                txtBirthdate.Text      = subscriber.Birthday.ToShortDateString();
                txtGender.Text         = subscriber.Gender.ToString();
                txtPersonalNumber.Text = subscriber.PersonalNo;
                txtEmail.Text          = subscriber.Email;
                txtPhoneNumber.Text    = subscriber.PhoneNo;

                if (subscriber.UpdNo == 0)
                {
                    txtFromDate.Text = subscriber.InsDate.ToShortDateString();
                }
                else
                {
                    txtFromDate.Text = subscriber.UpdDate.ToShortDateString();
                }

                txtTillDate.Text = subscriber.ExpirationDate.ToShortDateString();

                if (subscriber.ExpirationDate.Month == subscriber.InsDate.AddMonths(1).Month)
                {
                    txtSubscriptionPlan.Text = "Monthly";
                }
                else if (subscriber.ExpirationDate.Year == subscriber.InsDate.AddYears(1).Year)
                {
                    txtSubscriptionPlan.Text = "Yearly";
                }
            }

            catch (Exception ex)
            {
                //MessageBox.Show("errorrrrrrrrr !", "fail!", MessageBoxButtons.OK, MessageBoxIcon.Information);
                MessageBox.Show(ex.Message);
            }
        }
        private void btnSearch_Click(object sender, EventArgs e)
        {
            try
            {
                //Subscriber
                subscriber = subscriberBLL.Get(int.Parse(txtSubscriberID.Text));

                txtName.Text           = subscriber.Name;
                txtAddress.Text        = subscriber.Address;
                txtEmail.Text          = subscriber.Email;
                txtPhoneNumber.Text    = subscriber.PersonalNo;
                txtPersonalNumber.Text = subscriber.PersonalNo;


                //Material
                material                = materialBLL.Get(int.Parse(txtMaterialID.Text));
                txtMaterialName.Text    = material.Title;
                txtMaterialType.Text    = material.MaterialId.ToString();
                txtOverallQuantity.Text = material.Quantity.ToString();
                txtStockQuantity.Text   = material.AvailableCoppies.ToString();

                if (material.AvailableCoppies > 0)
                {
                    txtAvailability.Text = "Available";
                }

                else
                {
                    txtAvailability.Text = "Unavailable";
                }
            }

            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        private void BtnSearch_Click_1(object sender, EventArgs e)
        {
            int  n;
            bool isNumeric = int.TryParse(txtSubscriberID.Text, out n);

            int  m;
            bool isMaterialId = int.TryParse(txtMaterialID.Text, out m);

            if (isNumeric && isMaterialId)
            {
                sbll = new SubscriberBLL();
                rbll = new ReservationBLL();
                mbll = new MaterialBLL();


                mbo = mbll.Get(m);
                sbo = sbll.Get(n);



                if (sbo != null && mbo.MaterialId > 0)
                {
                    re = rbll.GetReservationBySubscriberIdAndMaterialId(sbo.SubscriberId, mbo.MaterialId);

                    txtName.Text           = $"{sbo.Name} {sbo.LastName}";
                    txtAddress.Text        = sbo.Address;
                    txtEmail.Text          = sbo.Email;
                    txtPhoneNumber.Text    = sbo.PhoneNo;
                    txtPersonalNumber.Text = sbo.PersonalNo;

                    txtMaterialName.Text = mbo.Title;
                    txtMaterialType.Text = mbo._MaterialType._MaterialType;
                    txtAuthor.Text       = mbo._Author.AuthorName;
                    txtLocated.Text      = mbo._Shelf.Location;

                    if (re == null)
                    {
                        txtReserved.Text = "No";
                    }
                    else
                    {
                        txtReserved.Text = "Yes";
                    }



                    if (mbo.AvailableCoppies > 0)
                    {
                        txtAvailability.Text = "Yes";
                    }
                    else
                    {
                        txtAvailability.Text = "No";
                    }
                }
                else
                {
                    if (sbo == null && mbo.MaterialId < 1)
                    {
                        MessageBox.Show($"Material and Subscriber are not found", $"ERROR", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    }
                    else if (sbo == null)
                    {
                        MessageBox.Show($"Subscriber is not found", $"ERROR", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    }
                    else if (mbo.MaterialId < 1)
                    {
                        MessageBox.Show($"Material is not found", $"ERROR", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    }
                }
            }
            else if (txtMaterialID.Text == string.Empty && txtSubscriberID.Text == string.Empty)
            {
                MessageBox.Show($"Material and Subscriber are empty", $"ERROR", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
            else if (txtMaterialID.Text == string.Empty)
            {
                MessageBox.Show($"Material ID field is empty", $"ERROR", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
            else if (txtSubscriberID.Text == string.Empty)
            {
                MessageBox.Show($"Subscriber ID field is empty", $"ERROR", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
            else
            {
                MessageBox.Show($"Material or Subscriber is not valid", $"ERROR", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
        }