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);
}
}
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);
}
}
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);
}
}
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);
}
}
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;
}
}
}