public override ScheduleEntry Item(int ID)
{
//Return an existing entry object from the entry schedule
Arrival entry = null;
try {
//Merge from collection (dataset)
if (ID > 0)
{
DataRow[] rows = this.mSchedule.LineHaulTable.Select("ID=" + ID);
if (rows.Length == 0)
{
throw new ApplicationException("Entry " + ID + " does not exist in this schedule!\n");
}
DispatchDS.LineHaulTableRow row = (DispatchDS.LineHaulTableRow)rows[0];
entry = new Arrival(row, this.mMediator);
entry.DataFile = base.mDataFile;
entry.EntryChanged += new EventHandler(OnEntryChanged);
}
else
{
entry = (Arrival)Item();
}
}
catch (Exception ex) { throw ex; }
return(entry);
}
public Arrival(DispatchDS.LineHaulTableRow row, Mediator mediator) : base(mediator)
{
//Constructor
try {
if (row != null)
{
this._id = row.ID;
this._created = row.Created;
this._createdby = row.CreatedBy;
if (!row.IsTrailerNumberNull())
{
this._trailernumber = row.TrailerNumber;
}
if (!row.IsTerminalNull())
{
this._terminal = row.Terminal;
}
if (!row.IsScheduledArrivalNull())
{
this._scheduledarrival = row.ScheduledArrival;
}
if (!row.IsActualArrivalNull())
{
this._actualarrival = row.ActualArrival;
}
if (!row.IsCommentsNull())
{
this._comments = row.Comments;
}
}
}
catch (Exception ex) { throw ex; }
}
public override void RemoveList(DispatchDS list)
{
//Remove a list of entries from this schedule
try {
for (int i = 0; i < list.LineHaulTable.Rows.Count; i++)
{
DispatchDS.LineHaulTableRow row = list.LineHaulTable[i];
Arrival entry = (Arrival)Item(row.ID);
entry.Delete();
}
}
catch (Exception ex) { throw ex; }
}
public override bool Delete()
{
//Delete this object
bool bRet = false;
try {
DispatchDS ds = new DispatchDS();
ds.Merge(base.mMediator.FillDataset(base.mDataFile, "", null));
DispatchDS.LineHaulTableRow row = (DispatchDS.LineHaulTableRow)ds.LineHaulTable.Select("ID = " + this._id)[0];
row.Delete();
ds.LineHaulTable.AcceptChanges();
bRet = base.mMediator.ExecuteNonQuery(base.mDataFile, new object[] { ds });
bRet = true;
base.OnEntryChanged(this, new EventArgs());
}
catch (Exception ex) { throw ex; }
return(bRet);
}
public override DataSet ToDataSet()
{
//Return a dataset containing values for this object
DispatchDS ds = null;
try {
ds = new DispatchDS();
DispatchDS.LineHaulTableRow row = ds.LineHaulTable.NewLineHaulTableRow();
row.ID = this._id;
row.Created = this._created;
row.CreatedBy = this._createdby;
row.TrailerNumber = this._trailernumber;
row.Terminal = this._terminal;
row.ScheduledArrival = this._scheduledarrival;
row.ActualArrival = this._actualarrival;
row.Comments = this._comments;
ds.LineHaulTable.AddLineHaulTableRow(row);
}
catch (Exception) { }
return(ds);
}
public override bool Update()
{
//Update this object
bool bRet = false;
try {
DispatchDS ds = new DispatchDS();
ds.Merge(base.mMediator.FillDataset(base.mDataFile, "", null));
DispatchDS.LineHaulTableRow row = (DispatchDS.LineHaulTableRow)ds.LineHaulTable.Select("ID = " + this._id)[0];
row.TrailerNumber = this._trailernumber;
row.Terminal = this._terminal;
row.ScheduledArrival = this._scheduledarrival;
row.ActualArrival = this._actualarrival;
row.Comments = this._comments;
ds.LineHaulTable.AcceptChanges();
bRet = base.mMediator.ExecuteNonQuery(base.mDataFile, new object[] { ds });
bRet = true;
base.OnEntryChanged(this, new EventArgs());
}
catch (Exception ex) { throw ex; }
return(bRet);
}
public override void AddList(DispatchDS list)
{
//
try {
for (int i = 0; i < list.LineHaulTable.Rows.Count; i++)
{
DispatchDS.LineHaulTableRow row = list.LineHaulTable[i];
Arrival entry = (Arrival)Item();
entry.ID = row.ID;
entry.Created = row.Created;
entry.CreatedBy = row.CreatedBy;
if (!row.IsTrailerNumberNull())
{
entry.TrailerNumber = row.TrailerNumber;
}
if (!row.IsTerminalNull())
{
entry.Terminal = row.Terminal;
}
if (!row.IsScheduledArrivalNull())
{
entry.ScheduledArrival = row.ScheduledArrival;
}
if (!row.IsActualArrivalNull())
{
entry.ActualArrival = row.ActualArrival;
}
if (!row.IsCommentsNull())
{
entry.Comments = row.Comments;
}
Add(entry);
}
}
catch (Exception ex) { throw ex; }
}
