protected void Page_Load(object sender, EventArgs e) { this.RequirePermission(Affinity.RolePermission.AdminSystem); this.RequirePermission(Affinity.RolePermission.AffinityManager); this.Master.SetLayout("Manage Companies", MasterPage.LayoutStyle.ContentOnly); Affinity.Companys cps = new Affinity.Companys(this.phreezer); Affinity.CompanyCriteria crit = new Affinity.CompanyCriteria(); crit.AppendToOrderBy("Name"); cps.Query(crit); cGrid.DataSource = cps; cGrid.DataBind(); }
public string[] GetCompanies(string prefixText, int count) { Phreezer phreezer = new Phreezer(ConfigurationManager.ConnectionStrings["DBConn"].ConnectionString); Affinity.Companys cs = new Affinity.Companys(phreezer); Affinity.CompanyCriteria cc = new Affinity.CompanyCriteria(); cc.NameBeginsWith = prefixText; cc.AppendToOrderBy("Name"); cc.MaxResults = count; cs.Query(cc); string[] returnval = new string[cs.Count]; int i = 0; foreach (Affinity.Company c in cs) { returnval[i++] = c.Name; } phreezer.Close(); return(returnval); }