public LstConfiguracionValorizacionForm()
{
InitializeComponent();
ViewModelList = new ObservableListSource <ConfiguracionValorizacionViewModel>();
configuracionValorizacionViewModelBindingSource.DataSource = ViewModelList;
}
public MercaderiaPromptForm()
{
InitializeComponent();
ViewModelList = new ObservableListSource <MercaderiaViewModel>();
mercaderiaViewModelBindingSource.DataSource = ViewModelList;
}
public static ObservableListSource <ProduccionNotaIng> Fetch(int idproduccion)
{
ObservableListSource <ProduccionNotaIng> _ProduccionNotaIngs = new ObservableListSource <ProduccionNotaIng>();
using (MySqlConnection connection = new MySqlConnection(
ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString))
{
connection.Open();
using (MySqlCommand command = connection.CreateCommand())
{
command.CommandText = SIAC_DATOS.Properties.Resources.q_pro_produccionnotaing_fetch;
command.Parameters.Add(new MySqlParameter("@n_idproduccion", idproduccion));
using (MySqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
ProduccionNotaIng periodoLaboral = new ProduccionNotaIng
{
c_idproduccionnotaing = reader.GetString("c_idproduccionnotaing"),
n_idproduccion = reader.GetInt32("n_idproduccion"),
n_idnoting = reader.GetInt32("n_idnoting"),
numnoting = reader.GetString("numnoting"),
cantidadmateriaprima = reader.GetDouble("cantidadmateriaprima"),
materiaprima = reader.GetString("materiaprima")
};
periodoLaboral.IsNew = false;
_ProduccionNotaIngs.Add(periodoLaboral);
}
}
}
}
return(_ProduccionNotaIngs);
}
public static ObservableListSource <ProductoReceta> FetchList(int n_idpro)
{
ObservableListSource <ProductoReceta> m_listentidad = new ObservableListSource <ProductoReceta>();
using (MySqlConnection connection
= new MySqlConnection(
ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString))
{
using (MySqlCommand command = new MySqlCommand())
{
command.Connection = connection;
command.CommandType = System.Data.CommandType.StoredProcedure;
command.CommandText = "pro_productosrecetas_listar";
command.Parameters.Add(new MySqlParameter("@n_idpro", n_idpro));
connection.Open();
using (MySqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
ProductoReceta m_entidad = SetObject(reader);
m_listentidad.Add(m_entidad);
}
}
}
}
return(m_listentidad);
}
public LstTipoAjusteInventarioForm()
{
InitializeComponent();
ViewModelList = new ObservableListSource <TipoAjusteInventarioViewModel>();
tipoAjusteInventarioViewModelBindingSource.DataSource = ViewModelList;
}
public MntTipoMovimientoForm(ObservableListSource <TipoMovimientoViewModel> viewModelList)
{
InitializeComponent();
IsNew = true;
ViewModelList = viewModelList;
tipoMovimientoViewModelBindingSource.DataSource = ViewModel;
}
public MntAplicacionCorrelativoForm(ObservableListSource <AplicacionCorrelativoViewModel> viewModelList)
{
InitializeComponent();
ViewModel = new AplicacionCorrelativoViewModel();
ViewModelList = viewModelList;
aplicacionCorrelativoViewModelBindingSource.DataSource = ViewModel;
}
public LstVentaForm()
{
InitializeComponent();
ViewModelList = new ObservableListSource <VentaViewModel>();
ventaViewModelBindingSource.DataSource = ViewModelList;
}
public LstOrdenProduccionForm()
{
InitializeComponent();
ViewModelList = new ObservableListSource <OrdenProduccionViewModel>();
ordenProduccionViewModelBindingSource.DataSource = ViewModelList;
}
public MntCostoOrdenProduccionForm(string parentId, ObservableListSource <CostoOrdenProduccionViewModel> viewModelList)
{
InitializeComponent();
ViewModel = new CostoOrdenProduccionViewModel(parentId);
ViewModelList = viewModelList;
costoOrdenProduccionViewModelBindingSource.DataSource = ViewModel;
}
public CompraPromptForm()
{
InitializeComponent();
ViewModelList = new ObservableListSource <CompraViewModel>();
compraViewModelBindingSource.DataSource = ViewModelList;
}
public MntDistribucionValorizacionForm(ObservableListSource <DistribucionValorizacionViewModel> viewModelList)
{
InitializeComponent();
ViewModel = new DistribucionValorizacionViewModel();
ViewModelList = viewModelList;
distribucionValorizacionViewModelBindingSource.DataSource = ViewModel;
}
public static ObservableListSource <InventarioInicialDet> FetchList(int n_idinvini)
{
ObservableListSource <InventarioInicialDet> m_listentidad = new ObservableListSource <InventarioInicialDet>();
using (MySqlConnection connection
= new MySqlConnection(
ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString))
{
using (MySqlCommand command = new MySqlCommand())
{
command.Connection = connection;
command.CommandType = System.Data.CommandType.StoredProcedure;
command.CommandText = "alm_inventarioinidet_listar";
command.Parameters.Add(new MySqlParameter("@n_idinvini", n_idinvini));
connection.Open();
using (MySqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
InventarioInicialDet m_entidad = SetObject(reader);
m_listentidad.Add(m_entidad);
}
}
}
}
return(m_listentidad);
}
public static ObservableListSource <OrdenCompraDetalle> FetchList(int n_idordcom)
{
ObservableListSource <OrdenCompraDetalle> m_listentidad = new ObservableListSource <OrdenCompraDetalle>();
using (MySqlConnection connection
= new MySqlConnection(
ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString))
{
using (MySqlCommand command = new MySqlCommand())
{
command.Connection = connection;
command.CommandType = System.Data.CommandType.StoredProcedure;
command.CommandText = "log_ordencompradet_listar";
command.Parameters.Add(new MySqlParameter("@n_idoc", n_idordcom));
connection.Open();
using (MySqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
OrdenCompraDetalle m_entidad = SetObject(reader);
m_listentidad.Add(m_entidad);
}
}
}
}
return(m_listentidad);
}
public LstAplicacionCorrelativoForm()
{
InitializeComponent();
ViewModelList = new ObservableListSource <AplicacionCorrelativoViewModel>();
aplicacionCorrelativoViewModelBindingSource.DataSource = ViewModelList;
}
public LstRecepcionForm()
{
InitializeComponent();
ViewModelList = new ObservableListSource <RecepcionViewModel>();
recepcionViewModelBindingSource.DataSource = ViewModelList;
}
public LstTipoMercaderiaForm()
{
InitializeComponent();
ViewModelList = new ObservableListSource <TipoMercaderiaViewModel>();
tipoMercaderiaViewModelBindingSource.DataSource = ViewModelList;
}
public static ObservableListSource <Categoria> Categorias()
{
ObservableListSource <Categoria> _Categorias = new ObservableListSource <Categoria>();
string selectQuery = "SELECT * FROM mae_categoria";
using (MySqlConnection connection
= new MySqlConnection(
ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString))
{
using (MySqlCommand command = new MySqlCommand(selectQuery, connection))
{
connection.Open();
using (MySqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Categoria categoria = new Categoria
{
n_idcategoria = reader.GetInt32("n_idcategoria"),
c_descripcion = reader.GetString("c_descripcion"),
c_codsun = reader.GetValue(2).ToString(),
c_abrev = reader.GetString("c_abrev"),
n_activo = reader.GetBoolean("n_activo")
};
categoria.IsNew = false;
_Categorias.Add(categoria);
}
}
}
}
return(_Categorias);
}
public LstTipoDespachoForm()
{
InitializeComponent();
ViewModelList = new ObservableListSource <TipoDespachoViewModel>();
tipoDespachoViewModelBindingSource.DataSource = ViewModelList;
}
public static ObservableListSource <FinPeriodo> FinPeriodos()
{
ObservableListSource <FinPeriodo> _FinPeriodos = new ObservableListSource <FinPeriodo>();
string selectQuery = "SELECT * FROM mae_finperiodo";
using (MySqlConnection connection
= new MySqlConnection(
ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString))
{
using (MySqlCommand command = new MySqlCommand(selectQuery, connection))
{
connection.Open();
using (MySqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
FinPeriodo finPeriodo = new FinPeriodo
{
n_idfinperiodo = reader.GetInt32("n_idfinperiodo"),
c_descripcion = reader.GetString("c_descripcion"),
c_codsun = reader.GetString("c_codsun")
};
finPeriodo.IsNew = false;
_FinPeriodos.Add(finPeriodo);
}
}
}
}
return(_FinPeriodos);
}
public LstMetodoValorizacionForm()
{
InitializeComponent();
ViewModelList = new ObservableListSource <MetodoValorizacionViewModel>();
metodoValorizacionViewModelBindingSource.DataSource = ViewModelList;
}
public MntTipoAjusteInventarioForm(ObservableListSource <TipoAjusteInventarioViewModel> viewModelList)
{
InitializeComponent();
ViewModel = new TipoAjusteInventarioViewModel();
ViewModelList = viewModelList;
tipoAjusteInventarioViewModelBindingSource.DataSource = ViewModel;
}
public static ObservableListSource <CostoProduccionDetCif> FetchList(int n_idcostoproddet)
{
ObservableListSource <CostoProduccionDetCif> m_listentidad = new ObservableListSource <CostoProduccionDetCif>();
using (MySqlConnection connection
= new MySqlConnection(
ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString))
{
using (MySqlCommand command = new MySqlCommand())
{
command.Connection = connection;
command.CommandType = System.Data.CommandType.StoredProcedure;
command.CommandText = "con_costoproddetcif_listar";
command.Parameters.Add(new MySqlParameter("@n_idcostoproddet", n_idcostoproddet));
connection.Open();
using (MySqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
CostoProduccionDetCif m_entidad = SetObject(reader);
m_entidad.IsNew = false;
m_listentidad.Add(m_entidad);
}
}
}
}
return(m_listentidad);
}
public MntFamiliaMercaderiaForm(ObservableListSource <FamiliaMercaderiaViewModel> viewModelList)
{
InitializeComponent();
ViewModel = new FamiliaMercaderiaViewModel();
ViewModelList = viewModelList;
familiaMercaderiaViewModelBindingSource.DataSource = ViewModel;
}
public MntCostoProduccionProcesoForm(ObservableListSource <CostoProduccionViewModel> viewModelList)
{
InitializeComponent();
ViewModel = new CostoProduccionViewModel();
ViewModelList = viewModelList;
costoProduccionViewModelBindingSource.DataSource = ViewModel;
}
public void The_BindingList_returned_from_ObservableListSource_GetList_is_cached()
{
var ols = new ObservableListSource <FakeEntity>();
var bindingList = ((IListSource)ols).GetList();
Assert.Same(bindingList, ((IListSource)ols).GetList());
}
public LstAlmacenForm()
{
InitializeComponent();
_AlmacenViewModels = new ObservableListSource <AlmacenViewModel>();
almacenViewModelBindingSource.DataSource = _AlmacenViewModels;
}
public void ObservableListSource_exposes_ObervableCollection_IEnumerable_constructor()
{
IEnumerable <FakeEntity> entities = new[] { new FakeEntity(), new FakeEntity() };
var ols = new ObservableListSource <FakeEntity>(entities);
Assert.Equal(2, ols.Count);
}
public MntAlmacenForm(ObservableListSource <AlmacenViewModel> viewModelList)
{
InitializeComponent();
ViewModel = new AlmacenViewModel();
ViewModelList = viewModelList;
almacenViewModelBindingSource.DataSource = ViewModel;
}
public LstCentroLogisticoForm()
{
InitializeComponent();
_CentroLogisticoViewModels = new ObservableListSource <CentroLogisticoViewModel>();
centroLogisticoViewModelBindingSource.DataSource = _CentroLogisticoViewModels;
}
