public void loadSync(object element)
{
if (element != null)
{
MAX_MIN poco = (MAX_MIN)element;
using (var entity = new TAE2Entities())
{
var query = (from cust in entity.MAX_MIN
where poco.UNID_MAX_MIN == cust.UNID_MAX_MIN
select cust).ToList();
//Actualización
if (query.Count > 0)
{
var aux = query.First();
if (aux.LAST_MODIFIED_DATE < poco.LAST_MODIFIED_DATE)
{
udpateElementSync((object)poco);
}
}
//Inserción
else
{
insertElementSync((object)poco);
}
var modifiedCotizacion = entity.MAX_MIN.First(p => p.UNID_MAX_MIN == poco.UNID_MAX_MIN);
modifiedCotizacion.IS_MODIFIED = false;
entity.SaveChanges();
}
}
}
public void getElementArticulosTest()
{
MaxMinDataMapper target = new MaxMinDataMapper(); // TODO: Inicializar en un valor adecuado
MAX_MIN element = new MAX_MIN()
{
UNID_ALMACEN = 20121128133427677
}; // TODO: Inicializar en un valor adecuado
object expected = null; // TODO: Inicializar en un valor adecuado
object actual;
actual = target.getElementArticulos(element);
Assert.AreEqual(expected, actual);
Assert.Inconclusive("Compruebe la exactitud de este método de prueba.");
}
public DeleteMaxMin(MAX_MIN maxMin)
{
this.UNID_MAX_MIN = maxMin.UNID_MAX_MIN;
this.MAX = maxMin.MAX;
this.MIN = maxMin.MIN;
this._almacen = maxMin.ALMACEN;
this._articulo = maxMin.ARTICULO;
this._categoria = maxMin.ARTICULO.CATEGORIA;
this._equipo = maxMin.ARTICULO.EQUIPO;
this._marca = maxMin.ARTICULO.MARCA;
this._modelo = maxMin.ARTICULO.MODELO;
this.IS_ACTIVE = maxMin.IS_ACTIVE;
this.IsChecked = false;
}
public object getElement(object element)
{
object res = null;
using (var entitie = new TAE2Entities())
{
MAX_MIN maxMin = (MAX_MIN)element;
var query = (from cust in entitie.MAX_MIN
where cust.UNID_MAX_MIN == maxMin.UNID_MAX_MIN
select cust).ToList();
if (query.Count > 0)
{
res = query;
}
return(res);
}
}
public void insertElementSync(object element)
{
if (element != null)
{
using (var entity = new TAE2Entities())
{
MAX_MIN maxMin = (MAX_MIN)element;
//Sync
var modifiedSync = entity.SYNCs.First(p => p.UNID_SYNC == 20120101000000000);
modifiedSync.ACTUAL_DATE = UNID.getNewUNID();
entity.SaveChanges();
//
entity.MAX_MIN.AddObject(maxMin);
entity.SaveChanges();
}
}
}
public object getElementArticulos(object element)
{
object res = null;
using (var entitie = new TAE2Entities())
{
MAX_MIN maxMin = (MAX_MIN)element;
res = (from cust in entitie.MAX_MIN
.Include("ARTICULO")
.Include("ARTICULO.CATEGORIA")
.Include("ARTICULO.EQUIPO")
.Include("ARTICULO.MODELO")
.Include("ARTICULO.MARCA")
.Include("ALMACEN")
where cust.UNID_ALMACEN == maxMin.UNID_ALMACEN && cust.IS_ACTIVE == true
select cust).ToList();
return(res);
}
}
public void deleteElement(object element)
{
if (element != null)
{
using (var entity = new TAE2Entities())
{
MAX_MIN maxMin = (MAX_MIN)element;
var modifiedMaxMin = entity.MAX_MIN.First(p => p.UNID_MAX_MIN == maxMin.UNID_MAX_MIN);
modifiedMaxMin.IS_ACTIVE = false;
//Sync
modifiedMaxMin.IS_MODIFIED = true;
modifiedMaxMin.LAST_MODIFIED_DATE = UNID.getNewUNID();
var modifiedSync = entity.SYNCs.First(p => p.UNID_SYNC == 20120101000000000);
modifiedSync.ACTUAL_DATE = UNID.getNewUNID();
entity.SaveChanges();
//
entity.SaveChanges();
}
}
}
public void udpateElement(object element, USUARIO u)
{
if (element != null)
{
using (var entity = new TAE2Entities())
{
MAX_MIN maxMin = (MAX_MIN)element;
var modifiedMaxMin = entity.MAX_MIN.First(p => p.UNID_MAX_MIN == maxMin.UNID_MAX_MIN);
modifiedMaxMin.MAX = maxMin.MAX;
modifiedMaxMin.MIN = maxMin.MIN;
//Sync
modifiedMaxMin.IS_MODIFIED = true;
modifiedMaxMin.LAST_MODIFIED_DATE = UNID.getNewUNID();
var modifiedSync = entity.SYNCs.First(p => p.UNID_SYNC == 20120101000000000);
modifiedSync.ACTUAL_DATE = UNID.getNewUNID();
entity.SaveChanges();
//
UNID.Master(maxMin, u, -1, "Modificación");
}
}
}
public void insertElement(object element, USUARIO u)
{
if (element != null)
{
using (var entity = new TAE2Entities())
{
MAX_MIN maxmin = (MAX_MIN)element;
maxmin.UNID_MAX_MIN = UNID.getNewUNID();
//Sync
maxmin.IS_MODIFIED = true;
maxmin.LAST_MODIFIED_DATE = UNID.getNewUNID();
var modifiedSync = entity.SYNCs.First(p => p.UNID_SYNC == 20120101000000000);
modifiedSync.ACTUAL_DATE = UNID.getNewUNID();
entity.SaveChanges();
//
entity.MAX_MIN.AddObject(maxmin);
entity.SaveChanges();
UNID.Master(maxmin, u, -1, "Inserción");
}
}
}
