public static YardDS GetYard(int terminalID, int yardID) { //Get a new or existing yard YardDS yard = new YardDS(); try { if (yardID == 0) { //New YardDS.YardDetailTableRow row = yard.YardDetailTable.NewYardDetailTableRow(); row.YardID = 0; row.Description = ""; row.TerminalID = terminalID; row.IsActive = true; row.LastUpdated = DateTime.Now; row.UserID = System.Environment.UserName; row.RowVersion = ""; yard.YardDetailTable.AddYardDetailTableRow(row); } else { //Existing DataSet ds = Mediator.FillDataset("", "YardDetailTable", new object[] { terminalID, yardID }); if (ds != null) { yard.Merge(ds); } } } catch (Exception ex) { throw ex; } return(yard); }
public static YardDS ViewYards(int terminalID) { //Get a list of yards YardDS yards = new YardDS(); try { DataSet ds = Mediator.FillDataset("", "YardListTable", new object[] { terminalID }); if (ds != null) { yards.Merge(ds.Tables["YardListTable"].Select("", "Name", DataViewRowState.CurrentRows)); } } catch (Exception ex) { throw ex; } return(yards); }