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