Exemple #1
0
 public FormPrincipalVenda(string usuario)
 {
     this.usuario = usuario;
     cn.Connect();
     InitializeComponent();
     lblDataHora.Text = DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss");
     timerHora.Start();
 }
Exemple #2
0
        private void btnOK_Click(object sender, EventArgs e)
        {
            Conn cn = new Conn();

            cn.Connect();

            if (modo == 0)
            {
                if (cn.ExecuteInsertTB_CATEGORIA(txtDesc.Text))
                {
                    MessageBox.Show("Catergoria cadastrada");
                    cn.ExecuteInsertTB_LOG_CAIXA(FormLogin.idusuario, 5, FormLogin.caixa);
                }
                else
                {
                    MessageBox.Show("Falha ao cadastrar");
                }

                FuncForm.LimparTextBox(this);
            }
            else
            {
                int id = Convert.ToInt32(R["IDCATEGORIA"]);
                if (cn.ExecuteUpdateTB_CATEGORIA(id, txtDesc.Text))
                {
                    MessageBox.Show("Catergoria atualizada");
                    cn.ExecuteInsertTB_LOG_CAIXA(FormLogin.idusuario, 6, FormLogin.caixa);
                    this.Close();
                }
                else
                {
                    MessageBox.Show("Falha ao atualizar");
                }
            }
        }
    public override bool Connect(int retry, int timeout)
    {
        bool succeed = false;

        while (!succeed && retry-- > 0)
        {
            try
            {
                Conn.Connect(ServerEndPoint);
            }
            catch (SocketException) { }

            succeed = Handshake(timeout / 2);
            if (!succeed)
            {
                Thread.Sleep(timeout / 2);
            }
        }

        Established         = succeed;
        Conn.ReceiveTimeout = 5000;
        Conn.SendTimeout    = 5000;

        return(succeed);
    }
Exemple #4
0
        public FormConsulta(DataTable Mostrar, Form alterar, bool v = true)
        {
            T = Mostrar;

            InitializeComponent();
            altera = alterar;

            cn.Connect();
            visivel            = v;
            btnAlterar.Visible = btnExcluir.Visible = visivel;
        }
Exemple #5
0
        private void FormNovaEntradaEstoque_Load(object sender, EventArgs e)
        {
            cn.Connect();
            ProdQuantPreco = new DataTable();

            DataColumn dt1 = new DataColumn("IDPRODUTO", typeof(long));
            DataColumn dt2 = new DataColumn("QUANTIDADE", typeof(int));
            DataColumn dt3 = new DataColumn("PRECO", typeof(decimal));

            ProdQuantPreco.Columns.Add(dt1);
            ProdQuantPreco.Columns.Add(dt2);
            ProdQuantPreco.Columns.Add(dt3);
            dgvProd.DataSource = ProdQuantPreco;
        }
Exemple #6
0
        private void FormNovoFornecedor_Load(object sender, EventArgs e)
        {
            cn = new Conn();
            cn.Connect();

            if (modo == 1)
            {
                txtDesc.Text = R["DESCRICAO"].ToString();
                txtTel.Text = R["TELEFONE"].ToString();
                txtEmail.Text = R["EMAIL"].ToString();
                txtCEP.Text = R["CEP"].ToString();
                txtComp.Text = R["COMPLEMENTO"].ToString();
                txtCPFCNPJ.Text = R["CPF_CNPJ"].ToString();
            }
        }
Exemple #7
0
        private void btnOK_Click(object sender, EventArgs e)
        {
            Conn cn = new Conn();

            cn.Connect();

            if (m == 0)
            {
                if (cn.ExecuteInsertTB_CARGO(txtDesc.Text, numericSalario.Value))
                {
                    MessageBox.Show("Cargo cadastrado");
                    cn.ExecuteInsertTB_LOG_CAIXA(FormLogin.idusuario, 5, FormLogin.caixa);
                }
                else
                {
                    MessageBox.Show("Falha ao cadastrar");
                }
            }
        }
Exemple #8
0
        private void FormNovoFuncionario_Load(object sender, EventArgs e)
        {
            try
            {
                cn.Connect();

                cargo = cn.Query("SELECT * FROM TB_CARGO");
                cmbCargo.DataSource    = cargo;
                cmbCargo.DisplayMember = "DESCRICAO";
                cmbCargo.ValueMember   = "IDCARGO";

                if (modo == 1)
                {
                    txtNome.Text     = R["NOME"].ToString();
                    txtDataNasc.Text = R["DT_NASC"].ToString();
                    txtCPF.Text      = R["CPF"].ToString();
                    txtTel.Text      = R["TELEFONE"].ToString();
                    txtRG.Text       = R["RG"].ToString();

                    rdioSexoM.Checked = (R["SEXO"].ToString() == "M");

                    txtEmail.Text  = R["EMAIL"].ToString();
                    txtCEP.Text    = R["CEP"].ToString();
                    txtNumRes.Text = R["NUM_RESID"].ToString();
                    txtCompl.Text  = R["COMPLEMENTO"].ToString();

                    for (int i = 0; i < cmbCargo.Items.Count; i++)
                    {
                        cmbCargo.SelectedIndex = i;
                        if (cmbCargo.SelectedValue.ToString() == R["IDCARGO"].ToString())
                        {
                            break;
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
Exemple #9
0
        private void FormNovoProduto_Load(object sender, EventArgs e)
        {
            cn.Connect();
            categoria  = cn.Query("SELECT * FROM TB_CATEGORIA");
            fornecedor = cn.Query("SELECT * FROM TB_FORNECEDOR");

            cmbCategoria.DataSource    = categoria;
            cmbCategoria.DisplayMember = "DESCRICAO";
            cmbCategoria.ValueMember   = "IDCATEGORIA";

            cmbFornecedor.DataSource    = fornecedor;
            cmbFornecedor.DisplayMember = "DESCRICAO";
            cmbFornecedor.ValueMember   = "IDFORNECEDOR";

            if (modo == 1)
            {
                txtDesc.Text       = R["NOMEPRODUTO"].ToString();
                numericVenda.Value = Convert.ToDecimal(R["VALORVENDA"]);
                txtUnidade.Text    = R["UNIDADE"].ToString();


                for (int i = 0; i < cmbCategoria.Items.Count; i++)
                {
                    cmbCategoria.SelectedIndex = i;
                    if (cmbCategoria.SelectedValue.ToString() == R["IDCATEGORIA"].ToString())
                    {
                        break;
                    }
                }

                for (int i = 0; i < cmbFornecedor.Items.Count; i++)
                {
                    cmbFornecedor.SelectedIndex = i;
                    if (cmbFornecedor.SelectedValue.ToString() == R["IDFORNECEDOR"].ToString())
                    {
                        break;
                    }
                }
            }
        }
Exemple #10
0
 public FormConfirmar(int formId)
 {
     InitializeComponent();
     Id = formId;
     cn.Connect();
 }
Exemple #11
0
 public FormPrincipal()
 {
     cn = new Conn();
     cn.Connect();
     InitializeComponent();
 }
Exemple #12
0
 public FormRelatorio()
 {
     InitializeComponent();
     cn.Connect();
 }
Exemple #13
0
 public UserControlRelatorio()
 {
     InitializeComponent();
     cn.Connect();
 }
Exemple #14
0
 public FormDefinirLogin()
 {
     InitializeComponent();
     cn.Connect();
 }
Exemple #15
0
        public void Main(string argument, UpdateType updateSource)
        {
            // The main entry point of the script, invoked every time
            // one of the programmable block's Run actions are invoked,
            // or the script updates itself. The updateSource argument
            // describes where the update came from. Be aware that the
            // updateSource is a  bitfield  and might contain more than
            // one update type.
            //
            // The method itself is required, but the arguments above
            // can be removed if not needed.

            if (argument.Length > 0)
            {
                Log.Add("Argument: " + argument);
                //CurState = argument;
            }
            else
            {
                Log.Add("No Argument.");
            }

            switch (updateSource)
            {
            case UpdateType.None:
                break;

            case UpdateType.Terminal:    //Script call trough terminal window
            //break;
            case UpdateType.Trigger:     //Script call
                switch (argument.ToLower())
                {
                case "up":
                    LiftIntent = "up";
                    CurState   = "PrepDep";
                    break;

                case "down":
                case "dn":
                    LiftIntent = "down";
                    CurState   = "PrepDep";
                    break;
                }

                break;

            case UpdateType.Mod:
                break;

            case UpdateType.Script:
                break;

            case UpdateType.Update1:
                IterativeMultiplier = 100;
                goto Update;

            case UpdateType.Update10:
                IterativeMultiplier = 10;
                goto Update;

            case UpdateType.Update100:
                IterativeMultiplier = 1;
Update:         //"goto" landing

                switch (Iteration)
                {
                case 0:         //rescan blocks
                    //RescanBlocks();
                    //Iteration = RescanBlocksSuccess ? Iteration : 3;
                    break;

                case 1:
                //ConfigBlocks();
                //break;
                default:
                    Log.Add("NOP.");
                    break;
                }

                break;

            case UpdateType.Once:
                break;

            case UpdateType.IGC:
                break;
            }

            Log.Add("Current state: " + CurState);
            Log.Add("Current intent: " + LiftIntent
                    );

//            float Dist = Math.Min(50f, Math.Max(1.5f, float.Parse(SettingsDictionary["Upward Approach Distance [1.5m~50m]"])));// 1.5~50
//            Log.Add("Sensor distance: " + Dist);

            //Main state machine
            CurStateTemp = CurState;
            switch (CurState)
            {
            case "Unknown":
                Runtime.UpdateFrequency = UpdateFrequency.Update100;
                RescanBlocks();
                CurState   = "PrepDep";
                LiftIntent = "up";

                //check sensors, go to nearest floor
                //Approach
                if (SetSensors(TASens, TADist) && SetSensors(BASens, BADist))
                {
                    if (BASens.First().IsActive)
                    {
                        CurState   = "Approach";
                        LiftIntent = "down";
                    }

                    if (TASens.First().IsActive)
                    {
                        CurState   = "Approach";
                        LiftIntent = "up";
                    }
                }

                //check sensors, go to nearest floor
                //Parking
                if (SetSensors(TPSens, 50) && SetSensors(BPSens, 50))
                {
                    if (BPSens.First().IsActive)
                    {
                        CurState   = "Parking";
                        LiftIntent = "down";
                    }

                    if (TPSens.First().IsActive)
                    {
                        CurState   = "Parking";
                        LiftIntent = "up";
                    }
                }

//                    foreach (var gear in LG) {
//                        if (gear.LockMode != LandingGearMode.Unlocked) {
//                            CurState = "Unknown";
//                        }
//                    }

                foreach (var Con in TConn)
                {
                    if (Con.Status != MyShipConnectorStatus.Unconnected)
                    {
                        CurState   = "Parking";
                        LiftIntent = "up";
                        break;
                    }
                }

                foreach (var Con in BConn)
                {
                    if (Con.Status != MyShipConnectorStatus.Unconnected)
                    {
                        CurState   = "Parking";
                        LiftIntent = "down";
                        break;
                    }
                }

                break;

            case "Idle":
                Runtime.UpdateFrequency = UpdateFrequency.Update100;
                RescanBlocks();

                EnableBlockList(Batt);     //recharge if connected
                if (TConn.First().Status == MyShipConnectorStatus.Connected || BConn.First().Status == MyShipConnectorStatus.Connected)
                {
                    foreach (var batt in Batt)
                    {
                        batt.ChargeMode = ChargeMode.Recharge;
                    }
                }


                if (LastState != CurState)       //State running first time.
                {
                    EnableBlockList(BDoor);
                    EnableBlockList(TDoor);
                    EnableBlockList(PSens);
                    SetPassengerSensors(PSens);
                    EnableBlockList(Thr, false);
                }

                foreach (var gear in LG)
                {
                    gear.Lock();
                }
                foreach (var Conn in TConn)
                {
                    Conn.Connect();
                }
                foreach (var Conn in BConn)
                {
                    Conn.Connect();
                }

                if (SetPassengerSensors(PSens))       //Make sure blocks exist before using first()
                {
                    if (PSens.First().IsActive)       //People inside? Open doors.
                    {
                        if (LiftIntent == "up")
                        {
                            foreach (var door in TDoor)
                            {
                                if (door.Status != DoorStatus.Open)
                                {
                                    door.OpenDoor();
                                }
                            }
                        }
                        else if (LiftIntent == "down")
                        {
                            foreach (var door in BDoor)
                            {
                                if (door.Status != DoorStatus.Open)
                                {
                                    door.OpenDoor();
                                }
                            }
                        }
                    }
                    else
                    {
                        foreach (var door in TDoor)
                        {
                            if (door.Status != DoorStatus.Closed)
                            {
                                door.CloseDoor();
                            }
                        }
                        foreach (var door in BDoor)
                        {
                            if (door.Status != DoorStatus.Closed)
                            {
                                door.CloseDoor();
                            }
                        }
                    }
                }

                //Final destination - no natural migrating from this case.
                break;

            case "PrepDep":     //Prepare for Departure
                Runtime.UpdateFrequency = UpdateFrequency.Update10;
                if (LastState != CurState)
                {
                    EnableBlockList(Batt);
                    EnableBlockList(Thr);
                    EnableBlockList(TDoor);
                    EnableBlockList(BDoor);
                    EnableBlockList(CCPB);
                    CCPB.First()?.TryRun("cc_on");     // Turn on CC
                    CCPB.First()?.TryRun("axis_v");    //Set to vertical


                    EnableBlockList(LiftIntent == "up" ? TPSens : BPSens);     //Parking
                    EnableBlockList(LiftIntent == "up" ? TASens : BASens);     //Approach
                }

                CCPB.First()?.TryRun("setspeed " + (LiftIntent == "up" ? "0" : "10")); //Hold in place in preparation for departure

                bool doorsClosed = true;                                               //Assumption that neated later via AND gate.
                foreach (var batt in Batt)
                {
                    batt.ChargeMode = ChargeMode.Auto;
                }


                if (PSens.First().IsActive)                                        //People in the vicinity, open correct doors
                {
                    if (TConn.First().Status != MyShipConnectorStatus.Unconnected) //Is on top
                    {
                        foreach (var door in TDoor)
                        {
                            door.OpenDoor();
                        }
                    }
                    else if (BConn.First().Status != MyShipConnectorStatus.Unconnected)         //Is on botom
                    {
                        foreach (var door in BDoor)
                        {
                            door.OpenDoor();
                        }
                    }
                    else
                    {
                        //CurState = "Unknown";
                    }

                    doorsClosed = false;     //Hold departure
                }
                else
                {
                    foreach (var door in TDoor)
                    {
                        door.CloseDoor();
                        doorsClosed &= (door.Status == DoorStatus.Closed);
                    }

                    foreach (var door in BDoor)
                    {
                        door.CloseDoor();
                        doorsClosed &= (door.Status == DoorStatus.Closed);
                    }
                }

                if (doorsClosed)
                {
                    CurState = "Cruise";
                    foreach (var connector in TConn)
                    {
                        connector.Disconnect();
                    }
                    foreach (var connector in BConn)
                    {
                        connector.Disconnect();
                    }
                    foreach (var lg in LG)
                    {
                        lg.AutoLock = false;
                        lg.Unlock();
                        lg.Enabled = false;
                    }
                }

                break;

            case "Cruise":     //Cruise downwards
                if (LastState != CurState)
                {
                    Runtime.UpdateFrequency = UpdateFrequency.Update10;

                    EnableBlockList(Thr);
                    EnableBlockList(Batt);
                    EnableBlockList(CCPB);
                    EnableBlockList(TDoor, false);
                    EnableBlockList(BDoor, false);
                    foreach (var batteryBlock in Batt)
                    {
                        batteryBlock.ChargeMode = ChargeMode.Auto;
                    }

                    EnableBlockList(LG);
                    foreach (var gear in LG)
                    {
                        gear.AutoLock = false;
                        gear.Unlock();
                        gear.Enabled = false;
                    }

                    foreach (var conn in TConn)
                    {
                        conn.Disconnect();
                    }
                    foreach (var conn in BConn)
                    {
                        conn.Disconnect();
                    }

                    SetSensors(TASens, TADist);
                    SetSensors(BASens, BADist);
                    SetSensors(TPSens, TPDist);
                    SetSensors(BPSens, BPDist);
                    SetPassengerSensors(PSens);

                    CCPB.First()?.TryRun("cc_on");     // Turn on CC
                    CCPB.First()?.TryRun("axis_v");    //Set to vertical
                    CCPB.First()?.TryRun("setspeed " + (LiftIntent == "up" ? TCVel : -BCVel));
                }

                if (PSens.First().IsActive)       //stop if humans detected
                {
                    CCPB.First()?.TryRun("setspeed 0");
                }
                else
                {
                    CCPB.First()?.TryRun("setspeed " + (LiftIntent == "up" ? TCVel : -BCVel));
                }

                if (LiftIntent == "up" && TASens.First().IsActive)
                {
                    CurState = "Approach";
                }
                if (LiftIntent == "down" && BASens.First().IsActive)
                {
                    CurState = "Approach";
                }

                break;

            case "Approach":     //Approach bottom floor
                Runtime.UpdateFrequency = UpdateFrequency.Update10;

                if (LastState != CurState)
                {
                    SetSensors(TPSens, TPDist);
                    SetSensors(BPSens, BPDist);
                    SetSensors(TASens, TADist);
                    SetSensors(BASens, BADist);
                    EnableBlockList(Thr);
                    EnableBlockList(CCPB);
                    EnableBlockList(TConn);
                    EnableBlockList(BConn);
                    EnableBlockList(LG);

                    EnableBlockList(TDoor);
                    EnableBlockList(BDoor);
                    foreach (var door in TDoor)
                    {
                        door.CloseDoor();
                    }
                    foreach (var door in BDoor)
                    {
                        door.CloseDoor();
                    }
                }
                else
                {
                    if (LiftIntent == "up" && TPSens.First().IsActive ||
                        LiftIntent == "down" && BPSens.First().IsActive)
                    {
                        //Is active AND in right direction?
                        CurState = "Parking";
                    }
                }

                CCPB.First()?.TryRun("setspeed " + (LiftIntent == "up" ? TAVel : -BAVel));
                break;

            case "Parking":     //Parking at bottom floor
                if (LastState != CurState)
                {
                    EnableBlockList(Thr);
                    EnableBlockList(CCPB);
                    EnableBlockList(TConn);
                    EnableBlockList(BConn);
                    EnableBlockList(LG);
                    EnableBlockList(TDoor);
                    EnableBlockList(BDoor);
                    foreach (var door in TDoor)
                    {
                        door.CloseDoor();
                    }
                    foreach (var door in BDoor)
                    {
                        door.CloseDoor();
                    }
                }


                Runtime.UpdateFrequency = UpdateFrequency.Update10;
                CCPB.First()?.TryRun("setspeed " + (LiftIntent == "up" ? PVel : -PVel));     //Set parking speed to a crawl, to prevent collision damage

                bool LG_Ready   = false;
                bool Con_Ready  = false;
                bool Con_Locked = false;

                foreach (var gear in LG)
                {
                    gear.AutoLock = true;
                    if (gear.LockMode != LandingGearMode.Unlocked)
                    {
                        LG_Ready = true;
                        break;
                    }
                }

                if (LG_Ready)
                {
                    foreach (var Con in BConn)
                    {
                        if (Con.Status != MyShipConnectorStatus.Unconnected)
                        {
                            Con_Ready = true;
                            if (Con.Status == MyShipConnectorStatus.Connected)
                            {
                                Con_Locked = true;
                            }
                            break;
                        }
                    }

                    foreach (var Con in TConn)
                    {
                        if (Con.Status != MyShipConnectorStatus.Unconnected)
                        {
                            Con_Ready = true;
                            if (Con.Status == MyShipConnectorStatus.Connected)
                            {
                                Con_Locked = true;
                            }
                            break;
                        }
                    }
                }
                else         //keep conectors disconnected until LG is locked
                {
                    foreach (var Con in TConn)
                    {
                        Con.Disconnect();
                    }
                    foreach (var Con in BConn)
                    {
                        Con.Disconnect();
                    }
                }

                if (LG_Ready && Con_Ready)
                {
                    foreach (var gear in LG)
                    {
                        gear.Lock();
                    }
                    foreach (var Con in TConn)
                    {
                        Con.Connect();
                    }
                    foreach (var Con in BConn)
                    {
                        Con.Connect();
                    }

                    if (Con_Locked)
                    {
                        CCPB.First()?.TryRun("cc_off");
                        //EnableBlockList(Thr, false);
                        foreach (var batteryBlock in Batt)
                        {
                            batteryBlock.ChargeMode = ChargeMode.Recharge;
                        }
                        CurState = "Idle";
                    }
                }

                break;

            default:
                Log.Add("Unknown state: " + CurState, Log.Error);
                break;
            }

            LastState = CurStateTemp;

            //Output
            Iteration = ++Iteration % (4 * IterativeMultiplier); //Adjust by amount of idle tasks
            Log.Add("Update source: " + updateSource);
            Log.Add("Current Iteration: " + (Iteration + 1) + "/" + 4 * IterativeMultiplier);
            Log.Print(LCD);
        }
Exemple #16
0
 public FormLogin()
 {
     cn.Connect();
     InitializeComponent();
 }
Exemple #17
0
 public FormPagamento()
 {
     InitializeComponent();
     cn.Connect();
 }
Exemple #18
0
        static async void LoadAsync()
        {
            MusicProcessor.Buffers = new BufferPool(1920 * 2, (int)Math.Pow(2, 16));

            using (var Context = GetDb)
            {
                foreach (var KVP in Context.Config)
                {
                    Config[KVP.Name] = KVP.Value;
                }

                SongData.YT = new YouTubeService(new BaseClientService.Initializer
                {
                    ApiKey = Config["Google"]
                });

                for (byte i = 0; i < Feeds.Length; i++)
                {
                    Feeds[i] = new FeedContext(i);
                }

                foreach (var Cred in Context.DiscordCredentials)
                {
                    Clients.TryAdd(Cred.Token, new Client.Discord(Cred.App, Cred.Token)
                    {
                        Owner = Cred.Owner
                    });
                }

                foreach (var Cred in Context.TelegramCredentials)
                {
                    Clients.TryAdd(Cred.Token, new Client.Telegram(Cred.Token)
                    {
                        Owner = Cred.Owner.ToString()
                    });
                }
            }

            Commands.Parser.LoadCommands();

            foreach (var Conn in Clients.Values)
            {
                await Conn.Connect();

                var Info = await Conn.Info();

                Log($"Connected to {Info.Type} as {Info.Name}\n - Join {Info.Join}");
            }

            UpdateCache();
            ConsoleEvents.SetHandler(delegate
            {
                ShutdownRequested = true;
                Waiter.Wait();
            });

            AppDomain.CurrentDomain.UnhandledException += (s, e) =>
            {
                var StartInfo = Process.GetCurrentProcess().StartInfo;
                StartInfo.FileName = Process.GetCurrentProcess().MainModule.FileName;
                Process.Start(StartInfo);

                System.IO.File.AppendAllText("UnhandledExceptions.txt", e.ExceptionObject.ToString());

                ShutdownRequested = true;
                Thread.Sleep(int.MaxValue);
            };

            ShutdownCode = new Random().Next(0, 999999).ToString().PadLeft(6, '0');
            Log($"Fully functional - Shutdown code is {ShutdownCode}");
        }