public List <SimpleNote> SearchReleases(string number, DateTime startDate, DateTime endDate)
{
try
{
SimpleNote note = null;
SimpleRailcar car = null;
var s = session.QueryOver <SimpleNote>(() => note)
.JoinAlias(() => note.Railcars, () => car, JoinType.LeftOuterJoin)
.TransformUsing(Transformers.DistinctRootEntity);
if (!string.IsNullOrWhiteSpace(number))
{
s.WhereRestrictionOn(x => x.Number).IsInsensitiveLike(number, MatchMode.Start);
}
if (startDate != DateTime.MinValue && endDate != DateTime.MinValue)
{
s.WhereRestrictionOn(x => x.Date).IsBetween(startDate).And(endDate.AddHours(23).AddMinutes(59).AddSeconds(59));
}
var list = new List <SimpleNote>(s.List <SimpleNote>().OrderBy(x => x.Number));
return(list);
}
catch (GenericADOException ex)
{
throw new RepositoryException("SearchReleases", ex);
}
}
private void railcarNumber_ProcessNewValue(object sender, DevExpress.XtraEditors.Controls.ProcessNewValueEventArgs e)
{
SimpleRailcar r = new SimpleRailcar
{
Number = railcarNumber.Text,
Certificate = "",
Destination = ""
};
viewModel.Railcars.Add(r);
railcarNumber.EditValue = viewModel.Railcar = r;
e.Handled = true;
}
