public LeadsController() { leadList = new LeadList(); string[] inputValues = { "Rusty Shackleford House Bunker 05/15/2018", "Jim Harbaugh House Siding 07/19/2018", "Dante Hicks Trailer Plumbing 05/27/2018", "Phillip Fry Condo Plumbing 10/21/2018", "Homer Simpson House Foundation 06/01/2018" }; foreach (string line in inputValues) { leadList.AddLead(line); } }
static void Main(string[] args) { LeadList leads = new LeadList(); try { foreach (string line in File.ReadLines(args[0])) { leads.AddLead(line); } Console.WriteLine(""); Console.WriteLine("Sorted by Property Type Then Project:"); foreach (Lead l in leads.SortByPropertyTypeThenProject()) { Console.WriteLine(l.StringToPrint()); } Console.WriteLine(""); Console.WriteLine("Sorted by Start Date:"); foreach (Lead l in leads.SortByStartDate()) { Console.WriteLine(l.StringToPrint()); } Console.WriteLine(""); Console.WriteLine("Sorted by Last Name Descending:"); foreach (Lead l in leads.SortByLastNameDescending()) { Console.WriteLine(l.StringToPrint()); } Console.ReadLine(); } catch { Console.WriteLine("Please Specify the file in the command line"); } }
public void LeadListTestInitialize() { leads = new LeadList(); }
private void ContSearchLe_Click(object sender, EventArgs e) { LeadList.Fields.Clear(); LeadList.DataSource = null; StringBuilder sql = new StringBuilder(); sql.Append("SELECT ID,ISNULL(NAME,'')+' '+ISNULL(SURNAME,'') AS CONTACTNAME, PHONE, MOBILEPHONE, ADDRESS, CITY, PROVINCE, ZIPCODE, STATE, COMPANYNAME "); sql.Append("FROM CRM_LEADS "); sql.AppendFormat("WHERE (LIMBO=0 AND ({1})) AND (SURNAME LIKE '%{0}%' OR ", ContQuery.Text, (GroupsSecure("CRM_Leads").Length > 0) ? GroupsSecure("CRM_LEADS") : "BASE_COMPANIES.GROUPS LIKE '%|" + UC.UserGroupId + "|%'"); sql.AppendFormat("NAME LIKE '%{0}%' OR ", ContQuery.Text); sql.AppendFormat("PHONE LIKE '%{0}%' OR ", ContQuery.Text); sql.AppendFormat("MOBILEPHONE LIKE '%{0}%' OR ", ContQuery.Text); sql.AppendFormat("COMPANYNAME LIKE '%{0}%') ", ContQuery.Text); DataTable dt = DatabaseConnection.CreateDataset(sql.ToString()).Tables[0]; if (dt.Rows.Count > 0) { LeadList.DataSource = dt; ObjectListField ListField1 = new ObjectListField(); ListField1.DataField = "ContactName"; ListField1.Visible = false; ListField1.Title = SimpleG.rm.GetString("Reftxt9"); LeadList.Fields.Add(ListField1); ListField1 = new ObjectListField(); ListField1.DataField = "CompanyName"; ListField1.Title = SimpleG.rm.GetString("Reftxt10"); LeadList.Fields.Add(ListField1); ListField1 = new ObjectListField(); ListField1.DataField = "Phone"; ListField1.Name = "CALL"; ListField1.Title = SimpleG.rm.GetString("Reftxt11"); LeadList.Fields.Add(ListField1); ListField1 = new ObjectListField(); ListField1.DataField = "MobilePhone"; ListField1.Name = "CALL"; ListField1.Title = SimpleG.rm.GetString("Reftxt12"); LeadList.Fields.Add(ListField1); ListField1 = new ObjectListField(); ListField1.DataField = "Address"; ListField1.Title = SimpleG.rm.GetString("Reftxt28"); LeadList.Fields.Add(ListField1); ListField1 = new ObjectListField(); ListField1.DataField = "City"; ListField1.Title = SimpleG.rm.GetString("Reftxt29"); LeadList.Fields.Add(ListField1); ListField1 = new ObjectListField(); ListField1.DataField = "Province"; ListField1.Title = SimpleG.rm.GetString("Reftxt30"); LeadList.Fields.Add(ListField1); ListField1 = new ObjectListField(); ListField1.DataField = "ZIPCode"; ListField1.Title = SimpleG.rm.GetString("Reftxt31"); LeadList.Fields.Add(ListField1); ListField1 = new ObjectListField(); ListField1.DataField = "State"; ListField1.Title = SimpleG.rm.GetString("Reftxt53"); LeadList.Fields.Add(ListField1); LeadList.AutoGenerateFields = false; LeadList.ItemsPerPage = 5; LeadList.DataBind(); LeadList.Visible = true; Clearpanels(); LeadPanel.Visible = true; Bback.Visible = true; SearchInfo.Visible = false; } else { SearchInfo.Text = SimpleG.rm.GetString("WAPtxt7"); SearchInfo.Visible = true; } }