private void manuInsert(object sender, EventArgs e)
        {
            if (statusBoxM.Text == "Manufacturer")
            {
                if (this.nameBoxM.Text.Length != 0 && mailBoxM.Text.Contains("@") == true && contactBoxM.Text.Length != 0)
                {
                    rand        = r.Next(00000, 99999);
                    idBoxM.Text = "man" + rand;

                    ManufacturerRep mr = new ManufacturerRep();

                    mr.Name = this.nameBoxM.Text;
                    //mr.Gender = this.sexBox.Text;
                    mr.Address  = this.addBoxM.Text;
                    mr.Email    = this.mailBoxM.Text;
                    mr.Status   = this.statusBoxM.Text;
                    mr.Contacts = this.contactBoxM.Text;
                    //mr.Password = this.passBox.Text;
                    mr.Id = this.idBoxM.Text;
                    //mr.Salary = this.salaryBox.Text;

                    ManufacturerRepositoryDB mrdb = new ManufacturerRepositoryDB();

                    if (mrdb.Insert(mr))
                    {
                        MessageBox.Show("Insert Completed!", "Succeed");
                        //button39.Visible = true;
                    }

                    else
                    {
                        MessageBox.Show("Insert Not Complete", "Error");
                    }
                }

                else
                {
                    MessageBox.Show("Invalid!", "Error");
                }
            }
        }
        private void insertBDClick(object sender, EventArgs e)
        {
            if (statusBox.Text == "Senior Employee")
            {
                if (passBox.Text == cpassBox.Text && nameBox.Text.Length != 0 && mailBox.Text.Contains("@") == true && contactBox.Text.Length != 0)
                {
                    rand       = r.Next(00000, 99999);
                    IdBox.Text = "se" + rand;

                    SeniorEmployeeRep ser = new SeniorEmployeeRep();

                    ser.SeniorEmployeename    = this.nameBox.Text;
                    ser.Gender                = this.sexBox.Text;
                    ser.SeniorEmployeeaddress = this.addBox.Text;
                    ser.Email            = this.mailBox.Text;
                    ser.Status           = this.statusBox.Text;
                    ser.Contacts         = this.contactBox.Text;
                    ser.Password         = this.passBox.Text;
                    ser.SeniorEmployeeid = this.IdBox.Text;
                    ser.Salary           = this.salaryBox.Text;

                    SeniorEmployeeRepositoryDB serdb = new SeniorEmployeeRepositoryDB();

                    if (serdb.Insert(ser))
                    {
                        MessageBox.Show("Insert Completed!", "Succeed");
                        //button7.Visible = true;
                    }

                    else
                    {
                        MessageBox.Show("Insert Not Complete", "Error");
                    }
                }

                else
                {
                    MessageBox.Show("Invalid!", "Error");
                }
            }


            else if (statusBox.Text == "Employee")
            {
                if (passBox.Text == cpassBox.Text && nameBox.Text.Length != 0 && mailBox.Text.Contains("@") == true && contactBox.Text.Length != 0)
                {
                    rand       = r.Next(00000, 99999);
                    IdBox.Text = "emp" + rand;

                    EmployeeRep er = new EmployeeRep();

                    er.Employeename = this.nameBox.Text;
                    er.Gender       = this.sexBox.Text;
                    er.Address      = this.addBox.Text;
                    er.Email        = this.mailBox.Text;
                    er.Status       = this.statusBox.Text;
                    er.Contacts     = this.contactBox.Text;
                    er.Password     = this.passBox.Text;
                    er.Employeeid   = this.IdBox.Text;
                    er.Salary       = this.salaryBox.Text;

                    EmployeeRepositoryDB erdb = new EmployeeRepositoryDB();

                    if (erdb.Insert(er))
                    {
                        MessageBox.Show("Insert Completed!", "Succeed");
                        //button7.Visible = true;
                    }

                    else
                    {
                        MessageBox.Show("Insert Not Complete", "Error");
                    }
                }

                else
                {
                    MessageBox.Show("Invalid!", "Error");
                }
            }

            else if (statusBox.Text == "Manufacturer")
            {
                if (passBox.Text == cpassBox.Text && nameBox.Text.Length != 0 && mailBox.Text.Contains("@") == true && contactBox.Text.Length != 0)
                {
                    rand       = r.Next(00000, 99999);
                    IdBox.Text = "man" + rand;

                    ManufacturerRep mr = new ManufacturerRep();

                    mr.Name = this.nameBox.Text;
                    //mr.Gender = this.sexBox.Text;
                    mr.Address  = this.addBox.Text;
                    mr.Email    = this.mailBox.Text;
                    mr.Status   = this.statusBox.Text;
                    mr.Contacts = this.contactBox.Text;
                    //mr.Password = this.passBox.Text;
                    mr.Id = this.IdBox.Text;
                    //mr.Salary = this.salaryBox.Text;

                    ManufacturerRepositoryDB mrdb = new ManufacturerRepositoryDB();

                    if (mrdb.Insert(mr))
                    {
                        MessageBox.Show("Insert Completed!", "Succeed");
                        //button7.Visible = true;
                    }

                    else
                    {
                        MessageBox.Show("Insert Not Complete", "Error");
                    }
                }

                else
                {
                    MessageBox.Show("Invalid!", "Error");
                }
            }
        }