//Interface
public dlgYardDetail(string terminal, bool parentIsActive, ref YardDS yard)
{
//Constructor
try {
//Set command button and menu identities (used for onclick handler)
InitializeComponent();
this.btnOk.Text = CMD_OK;
this.btnCancel.Text = CMD_CANCEL;
//Set mediator service, data, and titlebar caption
this.lblTerminal.Text = terminal;
this.mParentIsActive = parentIsActive;
this.mYardDS = yard;
if (this.mYardDS.YardDetailTable.Count > 0)
{
this.mYardID = this.mYardDS.YardDetailTable[0].YardID;
this.Text = (this.mYardID > 0) ? "Yard (" + this.mYardID + ")" : "Yard (New)";
}
else
{
this.Text = "Yard (Data Unavailable)";
}
}
catch (Exception ex) { throw ex; }
}
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 bool UpdateYard(YardDS yard)
{
//Update an existing yard
bool result = false;
try {
result = Mediator.ExecuteNonQuery("", new object[] { yard });
}
catch (Exception ex) { throw ex; }
return(result);
}
public static int CreateYard(YardDS yard)
{
//Create a new yard
int result = 0;
try {
result = (int)Mediator.ExecuteNonQueryWithReturn("", new object[] { yard });
}
catch (Exception ex) { throw ex; }
return(result);
}
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);
}
