예제 #1
0
        public static int operator +(Trainers t1, int x)
        {
            Trainers t2 = new Trainers();

            t2.Salary = t1.Salary + x;
            return(t2.Salary);
        }
예제 #2
0
        private void button3_Click(object sender, EventArgs e)
        {
            con.Open();
            Trainers c1   = new Trainers();
            string   name = txtname.Text;

            c1.delete(name);
            con.Close();
        }
        public displaytraine()
        {
            InitializeComponent();

            con.Open();

            #region paramter

            Trainers c1 = new Trainers();

            #endregion

            dgv_display_cust.DataSource = c1.display();
            con.Close();
        }
        private void button1_Click(object sender, EventArgs e)
        {
            con.Open();

            #region paramter

            Trainers c1   = new Trainers();
            string   name = combname.Text;

            #endregion

            dgv_search_cust.DataSource = c1.search(name);

            con.Close();
        }
예제 #5
0
        public virtual void add(Trainers c1)
        {
            #region Paramters

            SqlCommand cmd;

            #endregion
            try
            {
                con.Open();
                cmd = new SqlCommand("insert into Traineer (Traineer_Name,Sallary,halls_id,manager_id,Froms,Tos) values ('" + c1.Name + "','" + c1.Salary + "','" + c1.halls_id + "', '" + c1.manager_id + "','" + c1.froms + "','" + c1.tos + "') ", con);
                cmd.ExecuteNonQuery();
                MessageBox.Show("Your Registeration was sucsessful");
                con.Close();
            }
            catch (Exception)
            {
                MessageBox.Show("Please check Name or Salary");
            }
        }
예제 #6
0
        public virtual void edit(Trainers c1, string n)
        {
            try
            {
                #region Paramters

                SqlCommand cmd;

                #endregion

                con.Open();

                cmd = new SqlCommand("update Traineer set Traineer_Name='" + c1.Name + "', Sallary='" + c1.Salary + "', halls_id='" + c1.halls_id + "', manager_id='" + c1.manager_id + "', Froms='" + c1.froms + "', Tos='" + c1.tos + "' where Traineer_Name='" + n + "'", con);
                cmd.ExecuteNonQuery();
                MessageBox.Show("Your Update was sucsessful");
                con.Close();
            }
            catch (Exception)
            {
                MessageBox.Show("Please check Name or Salary");
            }
        }
        private void button2_Click(object sender, EventArgs e)
        {
            #region all statements of add Equipments

            #region paramter

            int      b  = int.Parse(txtbouns.Text);
            Trainers t  = new Trainers();
            Trainers c2 = new Trainers();

            #endregion

            if (txtnames.Text != string.Empty && txtsalary.Text != string.Empty && combhall.Text != string.Empty && combmanage.Text != string.Empty && txtfroms.Text != string.Empty && txttos.Text != string.Empty)
            {
                #region paramter

                string name = combname.Text;
                int    salary = Int32.Parse(txtsalary.Text) + Int32.Parse(txtbouns.Text);
                string dtf = txtfroms.Text;
                string dtt = txttos.Text;
                int    x = 0, y = 0;

                #endregion

                if ((dtf == "12 pm" && dtt == "8 pm") || (dtf == "8 pm" && dtt == "4 am"))
                {
                    con.Open();
                    if (combmanage.Text.Equals("Mohamed Salah Salem"))
                    {
                        x = 1;
                    }

                    else if (combmanage.Text.Equals("Marawan Mahmoud"))
                    {
                        x = 2;
                    }

                    else if (combmanage.Text.Equals("Yossief Sayed"))
                    {
                        x = 3;
                    }

                    else if (combmanage.Text.Equals("Youmna"))
                    {
                        x = 4;
                    }

                    else
                    {
                        x = 5;
                    }

                    if (combhall.Text.Equals("Chest"))
                    {
                        y = 1;
                    }

                    else if (combhall.Text.Equals("Back"))
                    {
                        y = 2;
                    }

                    else if (combhall.Text.Equals("Shoulder"))
                    {
                        y = 3;
                    }

                    else if (combhall.Text.Equals("Biceps"))
                    {
                        y = 4;
                    }

                    else if (combhall.Text.Equals("Triceps"))
                    {
                        y = 5;
                    }

                    else if (combhall.Text.Equals("Leg"))
                    {
                        y = 6;
                    }

                    else
                    {
                        y = 7;
                    }

                    #region paramter

                    Trainers c1 = new Trainers();
                    c1.Name       = txtnames.Text;
                    c1.Salary     = salary;
                    c1.halls_id   = y;
                    c1.manager_id = x;
                    c1.froms      = dtf;
                    c1.tos        = dtt;

                    #endregion

                    c1.edit(c1, name);
                    con.Close();
                }
                else
                {
                    MessageBox.Show("Please check trainers shift");
                }
            }
            else
            {
                MessageBox.Show("Please make sure that you have entered all the information");
            }

            c2.Salary = int.Parse(txtsalary.Text);
            t.Salary  = c2 + b;
            MessageBox.Show("Bouns =" + t.Salary);


            #endregion
        }