public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from ZonePickerRelation a where ");
ZonePickerRelation zoneRel = (ZonePickerRelation)data;
if (zoneRel != null)
{
Parms = new List <Object[]>();
if (zoneRel.Zone != null && zoneRel.Zone.ZoneID != 0)
{
sql.Append(" a.Zone.ZoneID = :id and ");
Parms.Add(new Object[] { "id", zoneRel.Zone.ZoneID });
}
if (zoneRel.Picker != null && zoneRel.Picker.UserID != 0)
{
sql.Append(" a.Picker.UserID = :id1 and ");
Parms.Add(new Object[] { "id1", zoneRel.Picker.UserID });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append(" 1=1 order by a.Rank asc ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return(query);
}
private void AddOnePicker(UserByRol user)
{
if (user == null)
{
return;
}
try
{
ZonePickerRelation zoneUser = new ZonePickerRelation
{
Zone = View.Model.Record,
Picker = user.User,
Rank = 0, //bin.Rank,
CreatedBy = App.curUser.UserName,
CreationDate = DateTime.Today
};
zoneUser = service.SaveZonePickerRelation(zoneUser);
View.Model.PickerListReg.Insert(0, zoneUser);
View.Model.PickerList.Remove(user);
}
catch (Exception ex)
{
throw ex;
}
}
public IList <ZonePickerRelation> Select(ZonePickerRelation data)
{
IList <ZonePickerRelation> datos = new List <ZonePickerRelation>();
datos = GetHsql(data).List <ZonePickerRelation>();
if (!Factory.IsTransactional)
{
Factory.Commit();
}
return(datos);
}
private void RemoveOnePicker(ZonePickerRelation ZoneUser)
{
if (ZoneUser == null)
{
return;
}
try
{
service.DeleteZonePickerRelation(ZoneUser);
View.Model.PickerListReg.Remove(ZoneUser);
View.Model.PickerList.Add(service.GetUserByRol(new UserByRol {
User = ZoneUser.Picker, Rol = new Rol {
RolID = BasicRol.Picker
}, Location = App.curLocation
}).First());
}
catch (Exception ex)
{
throw ex;
}
}
public void DeleteZonePickerRelation(ZonePickerRelation data)
{
try {
SetService(); SerClient.DeleteZonePickerRelation(data); }
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
public ZonePickerRelation SaveZonePickerRelation(ZonePickerRelation data)
{
try {
SetService(); return SerClient.SaveZonePickerRelation(data); }
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
public ZonePickerRelation SelectById(ZonePickerRelation data)
{
return((ZonePickerRelation)base.SelectById(data));
}
public Boolean Delete(ZonePickerRelation data)
{
return(base.Delete(data));
}
public Boolean Update(ZonePickerRelation data)
{
return(base.Update(data));
}
public ZonePickerRelation Save(ZonePickerRelation data)
{
return((ZonePickerRelation)base.Save(data));
}
private void RemoveOnePicker(ZonePickerRelation ZoneUser)
{
if (ZoneUser == null)
return;
try
{
service.DeleteZonePickerRelation(ZoneUser);
View.Model.PickerListReg.Remove(ZoneUser);
View.Model.PickerList.Add(service.GetUserByRol(new UserByRol { User = ZoneUser.Picker, Rol= new Rol { RolID = BasicRol.Picker}, Location= App.curLocation }).First());
}
catch (Exception ex)
{
throw ex;
}
}
private void AddOnePicker(UserByRol user)
{
if (user == null)
return;
try
{
ZonePickerRelation zoneUser = new ZonePickerRelation
{
Zone = View.Model.Record,
Picker = user.User,
Rank = 0, //bin.Rank,
CreatedBy = App.curUser.UserName,
CreationDate = DateTime.Today
};
zoneUser = service.SaveZonePickerRelation(zoneUser);
View.Model.PickerListReg.Insert(0, zoneUser);
View.Model.PickerList.Remove(user);
}
catch (Exception ex)
{
throw ex;
}
}
