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