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