protected void cmdreset_Click(object sender, EventArgs e)
{
RadComboBox cmbcat1 = (RadComboBox)RadPanelBar1.FindItemByValue("info").FindControl("cmbservicio");
RadComboBox cmbcat2 = (RadComboBox)RadPanelBar1.FindItemByValue("info").FindControl("cmbproducto");
RadComboBox cmbcat3 = (RadComboBox)RadPanelBar1.FindItemByValue("info").FindControl("cmbcentro");
RadButton rbt1 = (RadButton)RadPanelBar1.FindItemByValue("info").FindControl("rbtDefault");
RadButton rbt2 = (RadButton)RadPanelBar1.FindItemByValue("info").FindControl("rbtRevisado");
RadButton rbt3 = (RadButton)RadPanelBar1.FindItemByValue("info").FindControl("rbtTramite");
RadButton rbt4 = (RadButton)RadPanelBar1.FindItemByValue("info").FindControl("rbtCancel");
RadButton rbt5 = (RadButton)RadPanelBar1.FindItemByValue("info").FindControl("rbtaceptadopag");
RadButton rbt6 = (RadButton)RadPanelBar1.FindItemByValue("info").FindControl("rbtarechazadopag");
RadButton rbt9 = (RadButton)RadPanelBar1.FindItemByValue("info").FindControl("rbtnBarco");
RadDatePicker rdp1 = (RadDatePicker)RadPanelBar1.FindItemByValue("info").FindControl("rdpFechaIni");
RadDatePicker rdp2 = (RadDatePicker)RadPanelBar1.FindItemByValue("info").FindControl("rdpFechaFin");
RadButton rbt7 = (RadButton)RadPanelBar1.FindItemByValue("info").FindControl("rbtAnio");
RadButton rbt8 = (RadButton)RadPanelBar1.FindItemByValue("info").FindControl("rbtAniomes");
cmbcat1.ClearSelection();
cmbcat2.ClearSelection();
cmbcat3.ClearSelection();
rbt1.Checked = false;
rbt2.Checked = false;
rbt3.Checked = false;
rbt4.Checked = false;
rbt5.Checked = false;
rbt6.Checked = false;
rbt7.Checked = false;
rbt8.Checked = false;
rbt9.Checked = false;
rdp1.Clear();
rdp2.Clear();
}
protected void rcbArea_SelectedIndexChanged(object sender, EventArgs e)
{
RadComboBox rcbTempArea = (RadComboBox)sender;
String selected = rcbTempArea.SelectedValue;
RadComboBox rcbTempCoordinacion = (RadComboBox)rcbTempArea.NamingContainer.FindControl("rcbCoordinacion");
RadComboBox rcbTempPuesto = (RadComboBox)rcbTempArea.NamingContainer.FindControl("rcbPuesto");
rcbTempCoordinacion.ClearSelection();
this.odsCoordinacion.SelectParameters.Clear();
this.odsCoordinacion.SelectParameters.Add("area_id", System.Data.DbType.Guid, selected);
rcbTempCoordinacion.DataBind();
if (rcbTempArea.Items.Count != 0)
{
rcbTempPuesto.ClearSelection();
this.odsPuesto.SelectParameters.Clear();
this.odsPuesto.SelectParameters.Add("empresa_id", System.Data.DbType.Guid, Guid.Empty.ToString());
this.odsPuesto.SelectParameters.Add("gerencia_id", System.Data.DbType.Guid, Guid.Empty.ToString());
this.odsPuesto.SelectParameters.Add("area_id", System.Data.DbType.Guid, rcbTempArea.SelectedValue);
rcbTempPuesto.DataBind();
}
}
public static void Search(RadComboBox rcb_search, String SearchExpr, String UserID, bool CompaniesOnly = false, String CustomOnClientClick = "", bool FromLeads = false)
{
if (HttpContext.Current.User.Identity.IsAuthenticated)
{
rcb_search.Items.Clear();
// Get and clean search term
String search_term = SearchExpr;
search_term = search_term.Replace("+", String.Empty); // for phone number search
if (search_term == String.Empty)
{
// Add empty separator
RadComboBoxItem break_item = new RadComboBoxItem();
break_item.IsSeparator = true;
break_item.Controls.Add(new System.Web.UI.WebControls.Label()
{
Text = "Type to search for Companies and Contacts.."
});
rcb_search.Items.Add(break_item);
}
else
{
String radopen = "rwm_master_radopen";
if (FromLeads)
{
radopen = "rwm_radopen";
}
String qry = "SELECT cpy.CompanyID, cpy.Country, cpy.Industry, CONCAT(cpy.CompanyName,' (',COUNT(ctc.ContactID),')') as 'CompanyName' FROM (SELECT CompanyID, CompanyName, Country, Industry " +
"FROM db_company WHERE ((CONCAT(CompanyName,' ',IFNULL(Country,'')) LIKE @s AND CompanyName IS NOT NULL AND TRIM(CompanyName) != '' AND CompanyNameClean!='unknown') OR (CONCAT(TRIM(IFNULL(PhoneCode,'')),TRIM(REPLACE(Phone,' ',''))) LIKE @s)) " +
"AND Source NOT LIKE 'db_tmp%' LIMIT 10) as cpy LEFT JOIN db_contact ctc ON cpy.CompanyID = ctc.CompanyID GROUP BY cpy.CompanyID ORDER BY cpy.CompanyName, cpy.Country";
DataTable dt_companies = SQL.SelectDataTable(qry, "@s", search_term + "%"); //"%" + search_term + "%"
qry = "SELECT ContactID, TRIM(CONCAT(CASE WHEN FirstName IS NULL THEN '' ELSE CONCAT(TRIM(FirstName), ' ') END, CASE WHEN NickName IS NULL THEN '' ELSE CONCAT('\"',TRIM(NickName),'\" ') END, CASE WHEN LastName IS NULL THEN '' ELSE TRIM(LastName) END)) as 'contact', " +
"CompanyName, JobTitle, DontContactReason, DontContactUntil, DontContactDateSet, DontContactSetByUserID " +
"FROM db_contact ctc, db_company cpy WHERE ctc.CompanyID=cpy.CompanyID AND " +
"(TRIM(CONCAT(TRIM(FirstName),' ',TRIM(LastName))) LIKE @s OR CONCAT(TRIM(REPLACE(ctc.Phone,' ','')),TRIM(REPLACE(Mobile,' ',''))) LIKE @s OR CONCAT(TRIM(Email)) LIKE @s OR CONCAT(TRIM(PersonalEmail)) LIKE @s) " +
"AND Visible=1 ORDER BY FirstName, LastName LIMIT 6";
DataTable dt_contacts = SQL.SelectDataTable(qry, "@s", search_term + "%");
// Add Company separator
if (dt_companies.Rows.Count > 0)
{
RadComboBoxItem break_item = new RadComboBoxItem();
break_item.IsSeparator = true;
System.Web.UI.WebControls.Label lbl_cpy = new System.Web.UI.WebControls.Label();
lbl_cpy.Text = "Companies";
lbl_cpy.Font.Bold = true;
break_item.Controls.Add(lbl_cpy);
System.Web.UI.WebControls.Label lbl_cpy_info = new System.Web.UI.WebControls.Label();
lbl_cpy_info.Text = "Hover over a company name to see industry";
lbl_cpy_info.Font.Size = 8;
lbl_cpy_info.Attributes.Add("style", "position:absolute; right:0; margin-right:4px;");
break_item.Controls.Add(lbl_cpy_info);
rcb_search.Items.Add(break_item);
}
for (int i = 0; i < dt_companies.Rows.Count; i++)
{
String cpy_id = dt_companies.Rows[i]["CompanyID"].ToString();
String country = dt_companies.Rows[i]["Country"].ToString();
if (country == String.Empty)
{
country = "?";
}
country = " " + country;
HtmlGenericControl ul = new HtmlGenericControl("ul");
HtmlGenericControl li = new HtmlGenericControl("li");
ul.Controls.Add(li);
li.Attributes.Add("class", "CompanyBullet");
RadComboBoxItem cpy_item = new RadComboBoxItem();
cpy_item.ToolTip = dt_companies.Rows[i]["industry"].ToString();
cpy_item.Style.Add("cursor", "pointer");
LinkButton lb_cpy = new LinkButton();
lb_cpy.Text = Util.TruncateText(dt_companies.Rows[i]["CompanyName"].ToString(), 40);
System.Web.UI.WebControls.Label lbl_cpy_country = new System.Web.UI.WebControls.Label();
lbl_cpy_country.Text = country;
if (CustomOnClientClick == String.Empty)
{
cpy_item.Attributes.Add("onclick", "$find('" + rcb_search.ClientID + "').hideDropDown(); var rw=" + radopen + "('/dashboard/leads/viewcompanyandcontact.aspx?cpy_id="
+ HttpContext.Current.Server.UrlEncode(cpy_id) + "', 'rw_view_cpy_ctc'); rw.autoSize(); rw.center(); return false;");
}
else
{
String ThisCustomOnClientClick = CustomOnClientClick.Replace("[cpy_id]", cpy_id) + " return false;";
cpy_item.Attributes.Add("onclick", ThisCustomOnClientClick);
}
li.Controls.Add(lb_cpy);
li.Controls.Add(lbl_cpy_country);
cpy_item.Controls.Add(ul);
rcb_search.Items.Add(cpy_item);
}
// Add Contact separator
if (!CompaniesOnly)
{
if (dt_contacts.Rows.Count > 0)
{
RadComboBoxItem break_item = new RadComboBoxItem();
break_item.IsSeparator = true;
System.Web.UI.WebControls.Label lbl_ctc = new System.Web.UI.WebControls.Label();
lbl_ctc.Text = "Contacts";
lbl_ctc.Font.Bold = true;
break_item.Controls.Add(lbl_ctc);
System.Web.UI.WebControls.Label lbl_ctc_info = new System.Web.UI.WebControls.Label();
lbl_ctc_info.Text = "Hover over a name to see job title";
lbl_ctc_info.Font.Size = 8;
lbl_ctc_info.Attributes.Add("style", "position:absolute; right:0; margin-right:4px;");
break_item.Controls.Add(lbl_ctc_info);
rcb_search.Items.Add(break_item);
}
qry = "SELECT LeadID FROM dbl_lead WHERE Active=1 AND ContactID=@ctc_id AND (ProjectID IN (SELECT ProjectID FROM dbl_project WHERE UserID=@user_id) OR ProjectID IN (SELECT ProjectID FROM dbl_project_share WHERE UserID=@user_id)) ORDER BY DateUpdated DESC LIMIT 1";
for (int i = 0; i < dt_contacts.Rows.Count; i++)
{
String ctc_id = dt_contacts.Rows[i]["ContactID"].ToString();
HtmlGenericControl ul = new HtmlGenericControl("ul");
HtmlGenericControl li = new HtmlGenericControl("li");
ul.Controls.Add(li);
li.Attributes.Add("class", "CompanyBullet");
RadComboBoxItem ctc_item = new RadComboBoxItem();
ctc_item.Style.Add("cursor", "pointer");
LinkButton lb_ctc = new LinkButton();
lb_ctc.Text = Util.TruncateText(dt_contacts.Rows[i]["contact"].ToString(), 25) + " @ <b>" + Util.TruncateText(dt_contacts.Rows[i]["CompanyName"].ToString(), 30) + "</b>";
ctc_item.ToolTip = dt_contacts.Rows[i]["JobTitle"].ToString();
lb_ctc.Attributes.Add("onclick", "$find('" + rcb_search.ClientID + "').hideDropDown(); var rw = " + radopen + "('/dashboard/leads/viewcompanyandcontact.aspx?ctc_id="
+ HttpContext.Current.Server.UrlEncode(ctc_id) + "', 'rw_view_cpy_ctc'); rw.autoSize(); rw.center(); return false;");
CheckAndSetDoNotContact(dt_contacts.Rows[i], ctc_item, lb_ctc, null, null);
// Check to see if this contact is in this user's Leads list
DataTable dt_lead = SQL.SelectDataTable(qry,
new String[] { "@ctc_id", "@user_id" },
new Object[] { ctc_id, UserID });
ImageButton imbtn_view_overview = null;
ImageButton imbtn_view_project = null;
if (dt_lead.Rows.Count > 0)
{
String lead_id = dt_lead.Rows[0]["LeadID"].ToString();
imbtn_view_overview = new ImageButton();
imbtn_view_overview.ImageUrl = "~/images/leads/ico_details.png";
imbtn_view_overview.ToolTip = "View Lead overview";
imbtn_view_overview.Attributes.Add("style", "margin-right:4px;");
imbtn_view_overview.OnClientClick = "$find('" + rcb_search.ClientID + "').hideDropDown(); " + radopen + "('/dashboard/leads/leadoverview.aspx?lead_id=" + HttpContext.Current.Server.UrlEncode(lead_id) + "', 'rw_lead_overview'); return false;";
imbtn_view_project = new ImageButton();
imbtn_view_project.ID = "imbtn_view_" + ctc_id;
imbtn_view_project.ImageUrl = "~/images/leads/ico_go_to.png";
imbtn_view_project.ToolTip = "Go to Lead in my Project";
imbtn_view_project.CommandName = lead_id;
imbtn_view_project.OnClientClick = "$find('" + rcb_search.ClientID + "').hideDropDown(); SetViewLeadID(" + lead_id + "); return false;";
}
li.Controls.Add(lb_ctc);
if (dt_lead.Rows.Count > 0)
{
Panel p = new Panel();
p.CssClass = "ViewLeadOptions";
p.Controls.Add(imbtn_view_overview);
p.Controls.Add(imbtn_view_project);
li.Controls.Add(p);
}
ctc_item.Controls.Add(ul);
rcb_search.Items.Add(ctc_item);
}
}
}
rcb_search.ClearSelection();
rcb_search.DataBind();
}
}
private void BindStateCombo(RadComboBox sender, int contryId)
{
objBindCombo = new BindCombo();
sender.Items.Clear();
sender.ClearSelection();
sender.DataTextField = "STATE_NAME";
sender.DataValueField = "STATE_ID";
sender.DataSource = objBindCombo.GetStateKeyValue(contryId);
sender.DataBind();
sender.Items.Insert(0, new RadComboBoxItem("", "0"));
sender.SelectedValue = "0";
}
private void BindCountryCombo(RadComboBox sender)
{
objBindCombo = new BindCombo();
sender.Items.Clear();
sender.ClearSelection();
sender.DataTextField = "COUNTRY_NAME";
sender.DataValueField = "COUNTRY_ID";
sender.DataSource = objBindCombo.GetCountryKeyValue();
sender.DataBind();
sender.Items.Insert(0, new RadComboBoxItem("", "0"));
sender.SelectedValue = "0";
}
public static void SeleccionarItemCombo(ref RadComboBox combo, string valor, string texto)
{
combo.ClearSelection();
if ((combo.Items.FindItemByValue(valor) == null))
combo.Items.Insert(0, new RadComboBoxItem(texto, valor));
combo.Items.FindItemByValue(valor).Selected = true;
}
private void BindEmployeeCombo(RadComboBox sender)
{
objUserMasterDAL = new UserMasterDal();
sender.Items.Clear();
sender.ClearSelection();
sender.DataTextField = "EMP_NAME";
sender.DataValueField = "EMP_ID";
sender.DataSource = objUserMasterDAL.GetEmployeeKeyValue();
sender.DataBind();
sender.Items.Insert(0, new RadComboBoxItem("", "0"));
sender.SelectedValue = "0";
}
private void BindSecurityQuestionCombo(RadComboBox sender)
{
objUserMasterDAL = new UserMasterDal();
sender.Items.Clear();
sender.ClearSelection();
sender.DataTextField = "SECURITY_QUESTION_DESC";
sender.DataValueField = "SECURITY_QUESTION_ID";
sender.DataSource = objUserMasterDAL.GetSecurityQuestion();
sender.DataBind();
sender.Items.Insert(0, new RadComboBoxItem("--Select--", "0"));
sender.SelectedValue = "0";
}
private void bindCountryCombo(RadComboBox sender, DataSet source)
{
objBindCombo = new BindCombo();
sender.Items.Clear();
sender.ClearSelection();
sender.DataTextField = "COUNTRY_NAME";
sender.DataValueField = "COUNTRY_ID";
if (source != null)
sender.DataSource = source;
else
sender.DataSource = objBindCombo.GetAirLine();
sender.DataBind();
sender.Items.Insert(0, new RadComboBoxItem("", "0"));
sender.SelectedValue = "0";
}
//#region btnDeleteAirport_Click
//protected void btnDeleteAirport_Click(object sender, EventArgs e)
//{
// try
// {
// int serialNo = 0;
// ImageButton imgbtnDetailDelete = (ImageButton)sender;
// if (imgbtnDetailDelete != null)
// Int32.TryParse(imgbtnDetailDelete.CommandArgument, out serialNo);
// objAirlineMapDal = new AirlineMapDal();
// int result = objAirlineMapDal.DeleteAirportBySrNo(serialNo);
// if (result == 1)
// {
// Master.DisplayMessage(ConfigurationSettings.AppSettings[SuccessMessage.Delete].ToString());
// Master.MessageCssClass = "successMessage";
// BindAirportGrid();
// }
// else if (result == 547)
// {
// Master.DisplayMessage(ConfigurationSettings.AppSettings[FailureMessage.Delete].ToString());
// Master.MessageCssClass = "errorMessage";
// }
// else
// {
// Master.DisplayMessage(ConfigurationSettings.AppSettings[FailureMessage.Delete].ToString());
// Master.MessageCssClass = "errorMessage";
// }
// }
// catch (Exception ex)
// {
// bool rethrow = ExceptionPolicy.HandleException(ex, DALHelper.DAL_EXP_POLICYNAME);
// if (rethrow)
// { throw ex; }
// }
//}
//#endregion
#endregion
#region Method
private void BindRegionCombo(RadComboBox sender, DataSet source)
{
objBindCombo = new BindCombo();
sender.Items.Clear();
sender.ClearSelection();
sender.DataTextField = "REGION_LONG_NAME";
sender.DataValueField = "REGION_ID";
if (source != null)
sender.DataSource = source;
else
sender.DataSource = objBindCombo.GetCityKeyValue(0, 0);
sender.DataBind();
sender.Items.Insert(0, new RadComboBoxItem("", "0"));
sender.SelectedValue = "0";
}
public void CargaDrop(object nombreDrop, string value, string text, DataTable dt, string[] atributos = null)
{
if (nombreDrop is ComboBox)
{
ComboBox drop = (ComboBox)nombreDrop;
drop.DataSource = null;
drop.DataBind();
//drop.SelectedIndex = 0;
drop.Items.Clear();
if (dt.Rows.Count > 0)
{
drop.DataSource = dt;
drop.DataValueField = value;
drop.DataTextField = text;
drop.DataBind();
}
ListItem li = new ListItem("Seleccione...", "0");
li.Attributes.Add("Style", "font-weight:bold;");
drop.Items.Insert(0, li);
drop.SelectedIndex = 0;
}
else if (nombreDrop is RadComboBox)
{
RadComboBox drop = (RadComboBox)nombreDrop;
drop.DataSource = null;
drop.SelectedIndex = -1;
drop.ClearSelection();
drop.SelectedValue = null;
drop.DataBind();
drop.Items.Clear();
RadComboBoxItem li = new RadComboBoxItem("Seleccione...", "0");
drop.Items.Add(li);
for (int i = 0; i < dt.Rows.Count; i++)
{
RadComboBoxItem l2 = new RadComboBoxItem();
l2.Value = dt.Rows[i][value].ToString();
l2.Text = dt.Rows[i][text].ToString().ToUpper();
drop.Items.Add(l2);
if (atributos != null)
{
for (int j = 0; j < atributos.Length; j++)
{
l2.Attributes.Add(atributos[j], dt.Rows[i][atributos[j]].ToString());
}
}
}
drop.SelectedIndex = 0;
if (drop.Items.Count == 2)
{
drop.SelectedIndex = 1;
}
}
else
{
DropDownList drop = (DropDownList)nombreDrop;
drop.DataSource = null;
drop.SelectedIndex = -1;
drop.ClearSelection();
drop.SelectedValue = null;
drop.DataBind();
drop.Items.Clear();
ListItem li = new ListItem("Seleccione...", "0");
drop.Items.Add(li);
for (int i = 0; i < dt.Rows.Count; i++)
{
ListItem l2 = new ListItem();
l2.Value = dt.Rows[i][value].ToString();
l2.Text = dt.Rows[i][text].ToString().ToUpper();
drop.Items.Add(l2);
if (atributos != null)
{
for (int j = 0; j < atributos.Length; j++)
{
l2.Attributes.Add(atributos[j], dt.Rows[i][atributos[j]].ToString());
}
}
}
drop.SelectedIndex = 0;
if (drop.Items.Count == 2)
{
drop.SelectedIndex = 1;
}
}
}