public static DamageCodeDS GetDamageCode(short codeID)
{
//Get a new or existing damage code
DamageCodeDS code = new DamageCodeDS();
try {
if (codeID == 0)
{
//New
DamageCodeDS.DamageCodeTableRow row = code.DamageCodeTable.NewDamageCodeTableRow();
//row.CodeID = codeID;
row.Description = "";
row.LastUpdated = DateTime.Now;
row.UserID = System.Environment.UserName;
row.RowVersion = "";
code.DamageCodeTable.AddDamageCodeTableRow(row);
}
else
{
//Existing
DataSet ds = Mediator.FillDataset("", "DamageCodeTable", new object[] { codeID });
if (ds != null)
{
code.Merge(ds.Tables["DamageCodeTable"].Select("Code=" + codeID));
}
}
}
catch (Exception ex) { throw ex; }
return(code);
}
public static DamageCodeDS ViewDamageCodes()
{
//Get a list of damage codes
DamageCodeDS codes = new DamageCodeDS();
try {
DataSet ds = Mediator.FillDataset("uspEnterpriseDamageGetList", "DamageCodeTable", null);
if (ds != null)
{
codes.Merge(ds.Tables["DamageCodeTable"].Select("", "Code", DataViewRowState.CurrentRows));
}
}
catch (Exception ex) { throw ex; }
return(codes);
}
