Пример #1
0
        private void btnEnter_Click(object sender, EventArgs e)
        {
            string   frsName  = txtFrsName.Text;
            string   lstName  = txtLastName.Text;
            string   phone    = txtPhone.Text;
            string   stati    = cmbStadium.Text;
            string   room     = cmbChangeRoom.Text;
            DateTime StartDat = dtgStart.Value;
            DateTime EndDat   = dtgEnd.Value;
            User     newUser;

            if (frsName == null)
            {
                MessageBox.Show("xanalari doldurun");
            }
            else
            {
                if (!DB.Users.Any(us => us.Phone == phone))
                {
                    newUser = DB.Users.Add(new User
                    {
                        FirstName = frsName,
                        LastName  = lstName,
                        Phone     = phone,
                    });

                    DB.SaveChanges();
                }
                else
                {
                    newUser = DB.Users.FirstOrDefault(us => us.Phone == phone);
                }

                int StatID = DB.Stations.FirstOrDefault(st => st.StationNumber == stati).ID;
                int roomId = DB.ChangeRooms.FirstOrDefault(ch => ch.RoomNumber == room).ID;
                int workID = worky.ID;

                RezervationStation newReserv;
                if (!DB.RezervationStations.Any(rs => rs.StartResDate == StartDat))
                {
                    newReserv = DB.RezervationStations.Add(new RezervationStation
                    {
                        UserID       = newUser.ID,
                        StationID    = StatID,
                        WorkerID     = workID,
                        RoomID       = roomId,
                        StartResDate = StartDat,
                        EndResDate   = EndDat
                    });
                }
                else
                {
                    newReserv = DB.RezervationStations.FirstOrDefault(rst => rst.StartResDate == StartDat);
                }
                MessageBox.Show("Add new Reservation success", "sucess", MessageBoxButtons.OK, MessageBoxIcon.Information);
                DB.SaveChanges();
            }
        }
Пример #2
0
        private void btnEnter_Click(object sender, EventArgs e)
        {
            string lgn    = txtLogin.Text;
            string phn    = txtPhone.Text;
            string pass   = txtPassword.Text;
            string ckpass = txtckPassword.Text;

            Worker newWorker;

            if (pass == ckpass)
            {
                newWorker = DB.Workers.Add(new Worker
                {
                    FullName = lgn,
                    Phone    = phn,
                    Password = pass.HashMe(),
                });
                MessageBox.Show("Added New Worker");
            }
            ;
            DB.SaveChanges();
        }