public override bool Create() { //Save this object bool bRet = false; try { DispatchDS ds = new DispatchDS(); ds.Merge(base.mMediator.FillDataset(base.mDataFile, "", null)); if (this._id <= 0) { //For new entries only; some entries are moved between schedules int ID = 0; for (int i = 0; i < ds.ClientInboundTable.Rows.Count; i++) { if (ds.ClientInboundTable[i].ID > ID) { ID = ds.ClientInboundTable[i].ID; } } this._id = ID + 1; } DispatchDS.ClientInboundTableRow row = ds.ClientInboundTable.NewClientInboundTableRow(); row.ID = this._id; row.Created = this._created; row.CreatedBy = this._createdby; row.VendorName = this._vendorname; row.ConsigneeName = this._consigneename; if (this._etatime != DateTime.MinValue) { row.ETATime = this._etatime; } row.DriverName = this._drivername; row.TrailerNumber = this._trailernumber; row.Amount = this._amount; row.AmountType = this._amounttype; row.FreightType = this._freighttype; row.Comments = this._comments; row.In = this._in; ds.ClientInboundTable.AddClientInboundTableRow(row); ds.ClientInboundTable.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 bool Delete() { //Delete this object bool bRet = false; try { DispatchDS ds = new DispatchDS(); ds.Merge(base.mMediator.FillDataset(base.mDataFile, "", null)); DispatchDS.ClientInboundTableRow row = (DispatchDS.ClientInboundTableRow)ds.ClientInboundTable.Select("ID = " + this._id)[0]; row.Delete(); ds.ClientInboundTable.AcceptChanges(); bRet = base.mMediator.ExecuteNonQuery(base.mDataFile, new object[] { ds }); bRet = true; base.OnEntryChanged(this, new EventArgs()); } catch (Exception ex) { throw ex; } return(bRet); }