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); }