protected void MoveSelectedLeads(object sender, EventArgs e)
{
if (dd_buckets.Items.Count > 0)
{
String new_project_id = dd_buckets.SelectedItem.Value;
hf_lead_ids.Value = hf_lead_ids.Value.Replace(",", " ").Trim();
String[] ctc_ids = hf_lead_ids.Value.Split(' ');
String ProjectName = LeadsUtil.GetProjectFullNameFromID(new_project_id);
Util.SetRebindOnWindowClose(udp_move, true);
String UserID = Util.GetUserId();
if (hf_from_search.Value == "1")
{
String iqry = "INSERT INTO dbl_lead (ProjectID, ContactID, Source) VALUES (@ProjectID, @ContactID, 'RSA');";
foreach (String ctc_id in ctc_ids)
{
String lead_id = SQL.Insert(iqry,
new String[] { "@ProjectID", "@ContactID" },
new Object[] { new_project_id, ctc_id }).ToString();
// Log
LeadsUtil.AddLeadHistoryEntry(lead_id, "Lead added to the " + ProjectName + " Project.");
}
}
else
{
String uqry = "UPDATE dbl_lead SET ProjectID=@NewProjectID WHERE LeadID=@LeadID;";
String qry = "SELECT LeadID FROM dbl_lead WHERE LeadID=@LeadID AND (ProjectID IN (SELECT ProjectID FROM dbl_project WHERE UserID=@UserID) OR ProjectID IN (SELECT ProjectID FROM dbl_project_share WHERE UserID=@UserID))";
foreach (String lead_id in ctc_ids)
{
// Verify Lead exists and ownership
if (SQL.SelectDataTable(qry, new String[] { "@LeadID", "@UserID" }, new Object[] { lead_id, UserID }).Rows.Count > 0)
{
SQL.Update(uqry,
new String[] { "@NewProjectID", "@LeadID" },
new Object[] { new_project_id, lead_id });
// Log
LeadsUtil.AddLeadHistoryEntry(lead_id, "Lead moved to the " + ProjectName + " Project.");
}
}
}
Util.CloseRadWindowFromUpdatePanel(this, String.Empty, false);
}
else
{
Util.PageMessageAlertify(this, "You have no other Projects to move your Leads to.\\n\\nPlease close this window and add another Project first.", "Retry");
}
}
protected void RestoreProjectOrClientList(object sender, EventArgs e)
{
bool IsClientList = false;
String ProjectID = String.Empty;
if (dd_restore_choice.SelectedItem.Value == "P" && dd_project.Items.Count > 0 && dd_project.SelectedItem != null && !String.IsNullOrEmpty(dd_project.SelectedItem.Value))
ProjectID = dd_project.SelectedItem.Value;
else if(dd_restore_choice.SelectedItem.Value == "CL" && dd_client_list.Items.Count > 0 && dd_client_list.SelectedItem != null && !String.IsNullOrEmpty(dd_client_list.SelectedItem.Value))
{
ProjectID = dd_client_list.SelectedItem.Value;
IsClientList=true;
}
if (ProjectID != String.Empty)
{
String WithinExpr = String.Empty;
int Hours = 0;
if (Int32.TryParse(dd_leads_killed_within.SelectedItem.Value, out Hours))
WithinExpr = "AND DateUpdated BETWEEN DATE_ADD(NOW(), INTERVAL -" + Hours + " HOUR) AND NOW();";
else
{
switch (dd_leads_killed_within.SelectedItem.Value)
{
case "today": WithinExpr = "AND DATE(DateUpdated) = DATE(NOW());"; break;
case "week": WithinExpr = "AND YEAR(DateUpdated) = YEAR(NOW()) AND MONTH(DateUpdated) = MONTH(NOW()) AND WEEK(DateUpdated) = WEEK(NOW());"; break;
case "month": WithinExpr = "AND YEAR(DateUpdated) = YEAR(NOW()) AND MONTH(DateUpdated) = MONTH(NOW());"; break;
case "all": WithinExpr = String.Empty; break;
}
}
String uqry =
"UPDATE dbl_project SET Active=1, DateModified=CURRENT_TIMESTAMP WHERE ProjectID=@ProjectID OR ProjectID IN (SELECT ProjectID FROM (SELECT ProjectID FROM dbl_project WHERE ParentProjectID=@ProjectID) as t); " +
"UPDATE dbl_lead SET Active=1, DateUpdated=CURRENT_TIMESTAMP WHERE (ProjectID=@ProjectID OR ProjectID IN " +
"(SELECT ProjectID FROM (SELECT ProjectID FROM dbl_project WHERE ParentProjectID=@ProjectID) as t)) " + WithinExpr;
SQL.Update(uqry, "@ProjectID", ProjectID);
String Type = "Project";
String Action = " reactivated. Leads killed within " + dd_leads_killed_within.SelectedItem.Text.ToLower() + " restored.";
if(IsClientList)
Type = "Client List";
LeadsUtil.AddProjectHistoryEntry(ProjectID, null, LeadsUtil.GetProjectFullNameFromID(ProjectID), Type + Action);
Util.SetRebindOnWindowClose(this, true);
Util.PageMessageAlertify(this, Type + " restored!<br/><br/>Close this window to refresh your Project list.", "Restored!");
}
else
Util.PageMessageAlertify(this, "Nothing to restore!", "Select something first!");
}
protected void DeleteThisBucket(object sender, EventArgs e)
{
// If we're chosing to move any existing leads to another bucket..
String action = "Client List " + LeadsUtil.GetProjectFullNameFromID(hf_project_id.Value) + " deactivated.";
if (dd_del_buckets.SelectedItem.Value != "-1") // move leads
{
String new_bucket_id = dd_del_buckets.SelectedItem.Value;
String uqry = "UPDATE dbl_lead SET ProjectID=@NewBucketID WHERE ProjectID=@OldBucketID;";
SQL.Update(uqry,
new String[] { "@NewBucketID", "@OldBucketID" },
new Object[] { new_bucket_id, hf_project_id.Value });
action += " All remaining active Leads moved to the " + LeadsUtil.GetProjectFullNameFromID(new_bucket_id) + " Project.";
}
else // else de-active old leads
{
String uqry = "UPDATE dbl_lead SET Active=0, DateUpdated=CURRENT_TIMESTAMP WHERE Active=1 AND ProjectID=@BucketID;";
SQL.Update(uqry, "@BucketID", hf_project_id.Value);
action += " All remaining active Leads were marked inactive (removed).";
}
// Set bucket inactive
String dqry = "UPDATE dbl_project SET Active=0, DateModified=CURRENT_TIMESTAMP WHERE ProjectID=@BucketID;";
SQL.Delete(dqry, "@BucketID", hf_project_id.Value);
// Assign a new project to view
String prefs_uqry = "UPDATE dbl_preferences SET LastViewedProjectID=(SELECT ProjectID FROM dbl_project WHERE ParentProjectID=@ProjID AND Name='Cold Leads' LIMIT 1) WHERE UserID=@UserID";
SQL.Update(prefs_uqry, new String[] { "@ProjID", "@UserID" }, new Object[] { hf_parent_project_id.Value, Util.GetUserId() });
// Log
LeadsUtil.AddProjectHistoryEntry(hf_project_id.Value, null, tb_bucket_name.Text.Trim(), action.Trim());
Util.SetRebindOnWindowClose(this, true);
Util.CloseRadWindowFromUpdatePanel(this, String.Empty, false);
}
protected void MoveAllLeads(object sender, EventArgs e)
{
if (dd_move_buckets.Items.Count > 0)
{
// Move any existing Leads to another Project..
String new_project_id = dd_move_buckets.SelectedItem.Value;
String uqry = "UPDATE dbl_lead SET ProjectID=@NewProjectID WHERE ProjectID=@OldProjectID OR ProjectID IN (SELECT ProjectID FROM dbl_project WHERE ParentProjectID=@OldProjectID)";
SQL.Update(uqry,
new String[] { "@NewProjectID", "@OldProjectID" },
new Object[] { new_project_id, hf_project_id.Value });
// Log
LeadsUtil.AddProjectHistoryEntry(hf_project_id.Value, null, tb_bucket_name.Text.Trim(), "Leads moved to the " + LeadsUtil.GetProjectFullNameFromID(new_project_id) + " Client List.");
Util.SetRebindOnWindowClose(this, true);
Util.CloseRadWindowFromUpdatePanel(this, String.Empty, false);
}
}
protected void BindProject(object sender, EventArgs e)
{
String ProjectID = String.Empty;
if (sender != null) // from grid
{
LinkButton lb_project = (LinkButton)sender;
ProjectID = lb_project.CommandArgument;
}
else // from page index changing
{
ProjectID = hf_bound_project_id.Value;
}
String ActiveExpr = "dbl_lead.Active=1";
if (cb_show_deactivated_projects.Checked)
{
ActiveExpr = "dbl_lead.Active=0";
}
String qry = "SELECT " +
"dbl_project.ProjectID, dbl_lead.LeadID, db_company.CompanyID, db_contact.ContactID, t3.ProjectName, " +
"dbl_lead.DateAdded, CompanyName, Country, FirstName, LastName, JobTitle, db_contact.Phone, Email, PersonalEmail " +
"FROM dbl_project " +
"LEFT JOIN db_userpreferences ON dbl_Project.UserID = db_userpreferences.userid " +
"LEFT JOIN dbl_lead ON dbl_project.ProjectID = dbl_lead.ProjectID " +
"LEFT JOIN db_contact ON dbl_lead.ContactID = db_contact.ContactID " +
"LEFT JOIN db_company ON db_contact.CompanyID = db_company.CompanyID " +
"LEFT JOIN (SELECT t1.ProjectID, CASE WHEN t2.Name IS NULL THEN t1.Name ELSE CONCAT(t2.Name,' - ', t1.Name) END as 'ProjectName' " +
"FROM (SELECT ProjectID, ParentProjectID, Name FROM dbl_project) as t1 " +
"LEFT JOIN (SELECT ProjectID, Name FROM dbl_project) as t2 ON t1.ParentProjectID = t2.ProjectID) as t3 ON dbl_Project.ProjectID = t3.ProjectID " +
"WHERE (dbl_project.ProjectID=@ProjectID OR ParentProjectID=@ProjectID)" +
"AND " + ActiveExpr;
DataTable dt_leads = SQL.SelectDataTable(qry, "@ProjectID", ProjectID);
rg_leads.DataSource = dt_leads;
rg_leads.DataBind();
lbl_leads_title.Text = "Showing " + dt_leads.Rows.Count + " active Leads for " + Server.HtmlEncode(dd_user.SelectedItem.Text.Replace(" (Disabled)", String.Empty)) + "'s " + Server.HtmlEncode(LeadsUtil.GetProjectFullNameFromID(ProjectID)) + " Project.";
div_leads.Visible = true;
hf_bound_project_id.Value = ProjectID;
}