public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from LabelTrackOption a where ");
LabelTrackOption track = (LabelTrackOption)data;
if (track != null)
{
Parms = new List <Object[]>();
if (track.RowID != 0)
{
sql.Append(" a.RowID = :id1 and ");
Parms.Add(new Object[] { "id1", track.RowID });
}
if (!String.IsNullOrEmpty(track.TrackValue))
{
sql.Append(" a.TrackValue = :nom1 and ");
Parms.Add(new Object[] { "nom1", track.TrackValue });
}
if (track.TrackOption != null && track.TrackOption.RowID != 0)
{
sql.Append(" a.TrackOption.RowID = :nom8 and ");
Parms.Add(new Object[] { "nom8", track.TrackOption.RowID });
}
if (track.Label != null)
{
if (track.Label.Status != null && track.Label.Status.StatusID != 0)
{
sql.Append(" a.Label.Status.StatusID = :st0 and ");
Parms.Add(new Object[] { "st0", track.Label.Status.StatusID });
}
if (track.Label.Product != null && track.Label.Product.ProductID != 0)
{
sql.Append(" a.Label.Product.ProductID = :pr0 and ");
Parms.Add(new Object[] { "pr0", track.Label.Product.ProductID });
}
if (track.Label.LabelID != 0)
{
sql.Append(" a.Label.LabelID = :nom9 and ");
Parms.Add(new Object[] { "nom9", track.Label.LabelID });
}
}
}
sql = new StringBuilder(sql.ToString());
sql.Append(" 1=1 order by a.RowID ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return(query);
}
void View_UpdateTrackValue(object sender, DataEventArgs <object[]> e)
{
//Actualiza el Valor del Track Option para un label especifico.
try
{
LabelTrackOption lblTrak = service.GetLabelTrackOption(new LabelTrackOption
{
Label = new Label {
LabelID = long.Parse(e.Value[0].ToString())
}
}).First();
lblTrak.TrackValue = e.Value[1].ToString();
service.UpdateLabelTrackOption(lblTrak);
}
catch { }
}
public IList <LabelTrackOption> Select(LabelTrackOption data)
{
IList <LabelTrackOption> datos = new List <LabelTrackOption>();
try {
datos = GetHsql(data).List <LabelTrackOption>();
if (!Factory.IsTransactional)
{
Factory.Commit();
}
}
catch (Exception e)
{
NHibernateHelper.WriteEventLog(WriteLog.GetTechMessage(e));
}
return(datos);
}
public Label UpdateLabelTracking(Label label, TrackOption trackOpt, string trackValue, string user)
{
IList <LabelTrackOption> trackList = (label.TrackOptions == null || label.TrackOptions.Count == 0)
? new List <LabelTrackOption>() : label.TrackOptions;;
if (label.TrackOptions == null || label.TrackOptions.Where(f => f.TrackOption.RowID == trackOpt.RowID).Count() == 0)
{
LabelTrackOption curTrack = new LabelTrackOption
{
Label = label,
CreatedBy = user,
CreationDate = DateTime.Now,
TrackOption = trackOpt,
TrackValue = trackValue
};
trackList.Add(curTrack);
}
else //Si ya existe un registro con la informacion para ese trackoption
{
trackList.Where(f => f.TrackOption.RowID == trackOpt.RowID).First().Label = label;
trackList.Where(f => f.TrackOption.RowID == trackOpt.RowID).First().CreatedBy = user;
trackList.Where(f => f.TrackOption.RowID == trackOpt.RowID).First().CreationDate = DateTime.Now;
trackList.Where(f => f.TrackOption.RowID == trackOpt.RowID).First().TrackOption = trackOpt;
trackList.Where(f => f.TrackOption.RowID == trackOpt.RowID).First().TrackValue = trackValue;
}
//Adicionando las track options
label.TrackOptions = trackList.ToList();
//Update Label
label.ModDate = DateTime.Now;
label.ModifiedBy = user;
Factory.DaoLabel().Update(label);
return(label);
}
public LabelTrackOption SelectById(LabelTrackOption data)
{
return((LabelTrackOption)base.SelectById(data));
}
public Boolean Delete(LabelTrackOption data)
{
return(base.Delete(data));
}
public Boolean Update(LabelTrackOption data)
{
return(base.Update(data));
}
public LabelTrackOption Save(LabelTrackOption data)
{
return((LabelTrackOption)base.Save(data));
}
public void DeleteLabelTrackOption(LabelTrackOption data)
{
try
{
SetService(); SerClient.DeleteLabelTrackOption(data);
}
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
public LabelTrackOption SaveLabelTrackOption(LabelTrackOption data)
{
try
{
SetService(); return SerClient.SaveLabelTrackOption(data);
}
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
