public IList<ZoneEntityRelation> Select(ZoneEntityRelation data)
{
IList<ZoneEntityRelation> datos = new List<ZoneEntityRelation>();
datos = GetHsql(data).List<ZoneEntityRelation>();
if (!Factory.IsTransactional)
Factory.Commit();
return datos;
}
public override Boolean Equals(object obj)
{
if ((obj == null) || (obj.GetType() != this.GetType()))
{
return(false);
}
ZoneEntityRelation castObj = (ZoneEntityRelation)obj;
return((castObj != null) &&
(this.RowID == castObj.RowID));
}
//Asigna un Bin a un producto
public void AssignBinToProduct(Product product, ZoneBinRelation zoneBin)
{
Zone zone;
Factory.IsTransactional = true;
try
{
//1. Crea Label zona const else nombre del producto si no existe
IList<Zone> zoneList = Factory.DaoZone().Select(new Zone { Location = zoneBin.Bin.Location, Name = product.ProductCode });
if (zoneList == null || zoneList.Count == 0)
{
Status status = Wtype.GetStatus(new Status { StatusID = EntityStatus.Active });
//Create Zone
zone = new Zone
{
Name = product.ProductCode,
CreationDate = DateTime.Now,
CreatedBy = zoneBin.CreatedBy,
Description = "Zone for Product " + product.ProductCode + ", " + product.Name,
Location = zoneBin.Bin.Location,
Status = status,
IsDefault = false
};
zone = Factory.DaoZone().Save(zone);
}
else
zone = zoneList.FirstOrDefault();
//2. Crear el Zone entity relation
ZoneEntityRelation zoneEntity = new ZoneEntityRelation
{
Entity = Factory.DaoClassEntity().SelectById(new ClassEntity { ClassEntityID = EntityID.Product }),
EntityRowID = product.ProductID,
Zone = zone
};
//Revisa si existe la relacion Zone Entity
IList<ZoneEntityRelation> zoneEntityList = Factory.DaoZoneEntityRelation().Select(zoneEntity);
if (zoneEntityList == null || zoneEntityList.Count == 0)
{
zoneEntity.CreationDate = DateTime.Today;
zoneEntity.CreatedBy = zoneBin.CreatedBy;
zoneEntity = Factory.DaoZoneEntityRelation().Save(zoneEntity);
}
//3. Crea el zone Bin Relation
//ZoneBinRelation zoneBinRel = new ZoneBinRelation
//{
// Bin = bin,
// Zone = zone,
// BinType = binDirection
//};
zoneBin.Zone = zone;
//Revisa que no exista la Relacion ZoneBin
IList<ZoneBinRelation> zoneBinList = Factory.DaoZoneBinRelation().Select(zoneBin);
if (zoneBinList != null && zoneBinList.Count > 0)
throw new Exception("Bin already was assigned to the product.");
zoneBin.CreationDate = DateTime.Today;
zoneBin = Factory.DaoZoneBinRelation().Save(zoneBin);
product = Factory.DaoProduct().SelectById(product);
Factory.Commit();
}
catch (Exception ex)
{
Factory.Rollback();
throw new Exception("Error creating Zone. " + ex.Message);
}
}
public void DeleteZoneEntityRelation(ZoneEntityRelation data) { Factory.DaoZoneEntityRelation().Delete(data); }
public void UpdateZoneEntityRelation(ZoneEntityRelation data) { Factory.DaoZoneEntityRelation().Update(data); }
public ZoneEntityRelation SaveZoneEntityRelation(ZoneEntityRelation data) { return Factory.DaoZoneEntityRelation().Save(data); }
public IList<ZoneEntityRelation> GetZoneEntityRelation(ZoneEntityRelation data) { return Factory.DaoZoneEntityRelation().Select(data); }
public ZoneEntityRelation SelectById(ZoneEntityRelation data)
{
return (ZoneEntityRelation)base.SelectById(data);
}
public Boolean Delete(ZoneEntityRelation data)
{
return base.Delete(data);
}
public Boolean Update(ZoneEntityRelation data)
{
return base.Update(data);
}
public ZoneEntityRelation Save(ZoneEntityRelation data)
{
return (ZoneEntityRelation)base.Save(data);
}