public static IEnumerable <Party> GetOrderedParties() { DataTable dt = DBHelper.GetDataTable("GetOrderedParties", null, true); if (dt != null && dt.Rows.Count > 0) { var parties = DBHelper.ConvertToList <Party>(dt); if (parties != null) { foreach (var party in parties) { party.Addresses = PartyAddressLogic.GetPartyAddress(party.ID); } } return(parties); } else { return(null); } }
public static IEnumerable <Party> GetPartyByID(int ID) { Dictionary <string, object> param = new Dictionary <string, object>(); param.Add("@ID", ID); DataTable dt = DBHelper.GetDataTable("GetPartyByID", param, true); if (dt != null && dt.Rows.Count > 0) { var parties = DBHelper.ConvertToList <Party>(dt); if (parties != null) { foreach (var party in parties) { party.Addresses = PartyAddressLogic.GetPartyAddress(party.ID); } } return(parties); } else { return(null); } }