public Transport()
{
Driver = new Driver();
Delivery = new Delivery();
Loading = new Loading();
Truck = new Truck();
Container = new Container();
Railcar = new Railcar();
Ard = new Ard();
Arrival = new Arrival();
BillOfLading = new BillOfLading();
Carrier = new Carrier();
Weighbridge = new Weighbridge();
Seal = new Seal();
}
public List <ReleaseNote> SearchReleasesByRailcar(string number, DateTime startDate, DateTime endDate,
string railcar, string certificate, string reciver)
{
try
{
ReleaseNote note = null;
Railcar car = null;
var s = session.QueryOver <ReleaseNote>(() => note)
.JoinAlias(() => note.Railcars, () => car, JoinType.LeftOuterJoin)
.TransformUsing(Transformers.DistinctRootEntity);
if (!string.IsNullOrWhiteSpace(railcar))
{
s.WhereRestrictionOn(() => car.Number).IsInsensitiveLike(railcar, MatchMode.Start);
}
if (!string.IsNullOrWhiteSpace(number))
{
s.WhereRestrictionOn(x => x.Number).IsInsensitiveLike(number, MatchMode.Start);
}
if (!string.IsNullOrWhiteSpace(certificate))
{
s.WhereRestrictionOn(() => car.Certificate).IsInsensitiveLike(certificate, MatchMode.Start);
}
if (!string.IsNullOrWhiteSpace(reciver))
{
s.WhereRestrictionOn(() => car.Destination).IsInsensitiveLike(reciver, 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 <ReleaseNote>(s.List <ReleaseNote>().OrderBy(x => x.Number));
return(list);
}
catch (GenericADOException ex)
{
throw new RepositoryException("SearchReleasesByRailcar", ex);
}
}
public IList <Pipe> GetReleasedNotePipe(Guid Id)
{
try
{
IList <Pipe> pipeList = new List <Pipe>();
ReleaseNote note = null;
Railcar car = null;
Pipe pipe = null;
PipeTestResult result = null;
Inspector inspector = null;
Certificate cert = null;
var s = session.QueryOver <ReleaseNote>(() => note)
.Where(n => ((n.Id == Id)))
.JoinAlias(() => note.Railcars, () => car, JoinType.LeftOuterJoin)
.JoinAlias(() => car.Pipes, () => pipe, JoinType.LeftOuterJoin)
//.JoinAlias(() => pipe.PipeTestResult, () => result, JoinType.LeftOuterJoin)
//.JoinAlias(() => result.Inspectors, () => inspector, JoinType.LeftOuterJoin)
//.JoinAlias(() => inspector.Certificates, () => cert, JoinType.LeftOuterJoin)
.TransformUsing(Transformers.DistinctRootEntity);
var listReleaseNote = new List <ReleaseNote>(s.List <ReleaseNote>());
foreach (ReleaseNote n in listReleaseNote)
{
foreach (Prizm.Domain.Entity.Mill.Railcar r in n.Railcars)
{
foreach (Pipe p in r.Pipes)
{
pipeList.Add(p);
}
}
}
return(pipeList);
}
catch (GenericADOException ex)
{
throw new RepositoryException("Get pipes from Release note", ex);
}
}
