Exemplo n.º 1
0
        private void frmListas_Load(object sender, EventArgs e)
        {
            var Lojas       = Database.LojasGet();
            var sourceLojas = new BindingSource {
                DataSource = Lojas
            };

            DataGridViewComboBoxColumn columnLoja = (DataGridViewComboBoxColumn)this.DataGridViewListas.Columns["LojaID"];

            columnLoja.ValueMember   = "ID";
            columnLoja.DisplayMember = "Loja";
            columnLoja.DataSource    = sourceLojas;

            _listas       = Database.ListasGet();
            _sourceListas = new BindingSource {
                DataSource = _listas
            };
            bindingSourceListas.DataSource = _sourceListas;
        }
Exemplo n.º 2
0
 public static SortableBindingList <clsLoja> LojasGet()
 {
     try {
         var lojas = new SortableBindingList <clsLoja>();
         using (var conn = GetConnectionShopping()) {
             var cmd = new SqlCommand("sp_Lojas", conn)
             {
                 CommandType = System.Data.CommandType.StoredProcedure
             };
             var r = cmd.ExecuteReader();
             while (r.Read())
             {
                 lojas.Add(new clsLoja(r));
             }
             r.Close();
             return(lojas);
         }
     }
     catch (Exception ex) {
         ShowError("Database.LojasGet()", ex);
         return(null);
     }
 }
Exemplo n.º 3
0
 public static SortableBindingList <clsMapa> MapasGet(int ListaID)
 {
     try {
         var mapas = new SortableBindingList <clsMapa>();
         using (var conn = GetConnectionShopping()) {
             var cmd = new SqlCommand("sp_Mapas", conn)
             {
                 CommandType = CommandType.StoredProcedure
             };
             cmd.Parameters.Add(new SqlParameter("@lojaID", ListaID));
             var r = cmd.ExecuteReader();
             while (r.Read())
             {
                 mapas.Add(new clsMapa(r));
             }
             r.Close();
             return(mapas);
         }
     }
     catch (Exception ex) {
         ShowError("Database.MapasGet()", ex);
         return(null);
     }
 }
Exemplo n.º 4
0
 public static SortableBindingList <clsItem> ItensGet(int ListaID)
 {
     try {
         var Itens = new SortableBindingList <clsItem>();
         using (var conn = GetConnectionShopping()) {
             var cmd = new SqlCommand("sp_Itens", conn)
             {
                 CommandType = System.Data.CommandType.StoredProcedure
             };
             cmd.Parameters.Add(new SqlParameter("@listaID", ListaID));
             var r = cmd.ExecuteReader();
             while (r.Read())
             {
                 Itens.Add(new clsItem(r));
             }
             r.Close();
             return(Itens);
         }
     }
     catch (Exception ex) {
         ShowError("Database.ItensGet()", ex);
         return(null);
     }
 }
Exemplo n.º 5
0
 public static SortableBindingList <clsProduto> ProdutosGet(bool getAllRecords)
 {
     try {
         var produtos = new SortableBindingList <clsProduto>();
         using (var conn = GetConnectionShopping()) {
             var cmd = new SqlCommand("sp_Produtos", conn)
             {
                 CommandType = CommandType.StoredProcedure
             };
             cmd.Parameters.Add(new SqlParameter("@Modo", getAllRecords));
             var r = cmd.ExecuteReader();
             while (r.Read())
             {
                 produtos.Add(new clsProduto(r));
             }
             r.Close();
             return(produtos);
         }
     }
     catch (Exception ex) {
         ShowError("Database.ProdutosGet()", ex);
         return(null);
     }
 }
Exemplo n.º 6
0
        private void DataGridViewMapas_DragDrop(object sender, DragEventArgs e)
        {
            int rowIndexOfItemUnderMouseToDrop = GetRowIndexOfItemUnderMouseToDrop(e);

            // If the drag operation was a move then remove and insert the row.
            //          if (e.Effect == DragDropEffects.Move) {
            if (_ddSource == DragDropSource.Mapas)
            {
                DataGridViewRow rowToMove = e.Data.GetData(
                    typeof(DataGridViewRow)) as DataGridViewRow;
                if (rowToMove.Index == rowIndexOfItemUnderMouseToDrop)
                {
                    return;
                }
                _mapas[rowToMove.Index].Updated = true;
                if (rowToMove.Index > rowIndexOfItemUnderMouseToDrop)
                {
                    // Moving UP
                    _mapas[rowToMove.Index].Corredor = _mapas[rowIndexOfItemUnderMouseToDrop].Corredor;
                    for (int r = rowIndexOfItemUnderMouseToDrop; r < rowToMove.Index; r++)
                    {
                        _mapas[r].Corredor = _mapas[r].Corredor + 1;
                        _mapas[r].Updated  = true;
                    }
                }
                else
                {
                    // Moving DOWN
                    _mapas[rowToMove.Index].Corredor = _mapas[rowIndexOfItemUnderMouseToDrop].Corredor - 1;
                    for (int r = rowToMove.Index + 1; r < rowIndexOfItemUnderMouseToDrop; r++)
                    {
                        _mapas[r].Corredor = _mapas[r].Corredor - 1;
                        _mapas[r].Updated  = true;
                    }
                }
                var SortedList = _mapas.OriginalList.OrderBy(o => o.Corredor);
                _mapas = new SortableBindingList <clsMapa>();
                foreach (clsMapa mapa in SortedList)
                {
                    _mapas.Add(mapa);
                }
                _sourceMapas.DataSource              = _mapas;
                bindingSourceMapas.DataSource        = _sourceMapas;
                LojaBindingNavigatorSaveItem.Enabled = _mapas.Any(m => m.Updated);
            }
            else
            {
                if (e.Data.GetDataPresent(typeof(ListView.SelectedListViewItemCollection)))
                {
                    foreach (ListViewItem current in (ListView.SelectedListViewItemCollection)e.Data.GetData(typeof(ListView.SelectedListViewItemCollection)))
                    {
                        if (_ddSource == DragDropSource.ProdutosNoCorredor)
                        {
                            if (bindingSourceMapas.Position == rowIndexOfItemUnderMouseToDrop)
                            {
                                return;
                            }
                            _mapas[bindingSourceMapas.Position].ProdutoRemove(current);
                        }
                        _mapas[rowIndexOfItemUnderMouseToDrop].ProdutoAdd(current);
                        current.Remove();
                    }
                    DataGridViewMapas.Refresh();
                    LojaBindingNavigatorSaveItem.Enabled = true;
                }
            }
        }