Ejemplo n.º 1
0
    //protected override void OnInit(EventArgs e)
    //{
    //    base.OnInit(e);
    //    //TextBox search = (TextBox)Accordion1.FindControl("txtSearch");
    //    GridSource.SelectParameters.Add(new CookieParameter("connection", "Company"));
    //    //DropDownList dropDown = (DropDownList)Accordion1.FindControl("ddCriteria");
    //    GridSource.SelectParameters.Add(new ControlParameter("txtSearch", TypeCode.String, txtSearch.UniqueID, "Text"));
    //    GridSource.SelectParameters.Add(new ControlParameter("dropDown", TypeCode.String, ddCriteria.UniqueID, "SelectedValue"));
    //}


    private void BindGrid(string textSearch, string dropDown)
    {
        string connection = Request.Cookies["Company"].Value;

        DataSet           ds = new DataSet();
        LeadBusinessLogic bl = new LeadBusinessLogic(sDataSource);

        object usernam = Session["LoggedUserName"];

        ds = bl.ListLeadMaster(connection, textSearch, dropDown);

        if (ds != null)
        {
            if (ds.Tables[0].Rows.Count > 0)
            {
                GrdViewLead.DataSource = ds.Tables[0].DefaultView;
                GrdViewLead.DataBind();
            }
        }
        else
        {
            GrdViewLead.DataSource = null;
            GrdViewLead.DataBind();
        }
    }
Ejemplo n.º 2
0
    protected void GrdViewLedger_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            LeadBusinessLogic bl1 = new LeadBusinessLogic(GetConnectionString());


            BusinessLogic bl         = new BusinessLogic(sDataSource);
            string        connection = Request.Cookies["Company"].Value;
            string        usernam    = Request.Cookies["LoggedUserName"].Value;

            if (bl.CheckUserHaveEdit(usernam, "LEDREF"))
            {
                ((ImageButton)e.Row.FindControl("btnEdit")).Visible         = false;
                ((ImageButton)e.Row.FindControl("btnEditDisabled")).Visible = true;
            }
            if (bl.CheckUserHaveDelete(usernam, "LEDREF"))
            {
                ((ImageButton)e.Row.FindControl("lnkB")).Visible         = false;
                ((ImageButton)e.Row.FindControl("lnkBDisabled")).Visible = true;
            }
            //string connection = Request.Cookies["Company"].Value;
            //string usernam = Request.Cookies["LoggedUserName"].Value;

            Label  referencename = e.Row.FindControl("typename") as Label;
            string refname       = referencename.Text;

            if (bl1.CheckIfleadreferenceused(connection, refname, int.Parse(((HiddenField)e.Row.FindControl("ldgID")).Value)))
            {
                ((ImageButton)e.Row.FindControl("lnkB")).Visible         = false;
                ((ImageButton)e.Row.FindControl("lnkBDisabled")).Visible = true;
            }
        }
    }
Ejemplo n.º 3
0
    protected void GrdViewLead_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        try
        {
            GridViewRow row    = GrdViewLead.Rows[e.RowIndex];
            string      leadID = row.Cells[0].Text;


            string userID = string.Empty;
            userID = Page.User.Identity.Name;
            LeadBusinessLogic bl = new LeadBusinessLogic(GetConnectionString());
            bl.DeleteLeadMaster(leadID, userID);
            ScriptManager.RegisterStartupScript(Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('Lead Management Details Deleted Successfully')", true);
            BindGrid("", "");
        }
        catch (Exception ex)
        {
            TroyLiteExceptionManager.HandleException(ex);
        }
    }
Ejemplo n.º 4
0
    private void ShowLeadContactInfo()
    {
        string connStr = GetConnectionString();

        if (Session["LeadID"] != null && Session["LeadID"].ToString() != "0")
        {
            LeadBusinessLogic bl = new LeadBusinessLogic(connStr);
            DataSet           ds = bl.ListLeadContact(Session["LeadID"].ToString());

            if (ds != null)
            {
                GrdViewLeadContact.DataSource = ds.Tables[0];
                GrdViewLeadContact.DataBind();
            }
        }
        else
        {
            GrdViewLeadContact.DataSource = null;
            GrdViewLeadContact.DataBind();
        }
    }
Ejemplo n.º 5
0
    protected void GrdViewLead_SelectedIndexChanged(object sender, EventArgs e)
    {
        try
        {
            GridViewRow       row    = GrdViewLead.SelectedRow;
            var               leadID = GrdViewLead.SelectedDataKey.Value.ToString();
            LeadBusinessLogic bl     = new LeadBusinessLogic(GetConnectionString());

            DataSet dsDetails = bl.GetLeadMasterDetails(leadID);

            if (dsDetails != null && dsDetails.Tables[0].Rows.Count > 0)
            {
                txtLeadNo.Text = dsDetails.Tables[0].Rows[0]["LeadID"].ToString();
                //txtCreationDate.Text = DateTime.Parse(dsDetails.Tables[0].Rows[0]["CreationDate"].ToString()).ToShortDateString();
                txtCreationDate.Text  = Convert.ToDateTime(dsDetails.Tables[0].Rows[0]["CreationDate"]).ToString("dd/MM/yyyy");
                txtProspCustName.Text = dsDetails.Tables[0].Rows[0]["ProspectCustName"].ToString();
                txtMobile.Text        = dsDetails.Tables[0].Rows[0]["Mobile"].ToString();
                txtAddress.Text       = dsDetails.Tables[0].Rows[0]["Address"].ToString();
                txtEmail.Text         = dsDetails.Tables[0].Rows[0]["Email"].ToString();
                txtLandline.Text      = dsDetails.Tables[0].Rows[0]["Landline"].ToString();

                if (cmbModeOfContact.Items.FindByValue(dsDetails.Tables[0].Rows[0]["ModeOfContact"].ToString().Trim()) != null)
                {
                    cmbModeOfContact.SelectedValue = Convert.ToString(dsDetails.Tables[0].Rows[0]["ModeOfContact"]);
                }
                if (cmbPersonalResp.Items.FindByValue(dsDetails.Tables[0].Rows[0]["PersonalResponsible"].ToString().Trim()) != null)
                {
                    cmbPersonalResp.SelectedValue = Convert.ToString(dsDetails.Tables[0].Rows[0]["PersonalResponsible"]);
                }
                if (cmbBussType.Items.FindByValue(dsDetails.Tables[0].Rows[0]["BusinessType"].ToString().Trim()) != null)
                {
                    cmbBussType.SelectedValue = Convert.ToString(dsDetails.Tables[0].Rows[0]["BusinessType"]);
                }
                if (cmbBranch.Items.FindByValue(dsDetails.Tables[0].Rows[0]["Branch"].ToString().Trim()) != null)
                {
                    cmbBranch.SelectedValue = Convert.ToString(dsDetails.Tables[0].Rows[0]["Branch"]);
                }
                if (cmbStatus.Items.FindByValue(dsDetails.Tables[0].Rows[0]["Status"].ToString().Trim()) != null)
                {
                    cmbStatus.SelectedValue = Convert.ToString(dsDetails.Tables[0].Rows[0]["Status"]);
                }
                if (cmbLastCompAction.Items.FindByValue(dsDetails.Tables[0].Rows[0]["LastCompletedAction"].ToString().Trim()) != null)
                {
                    cmbLastCompAction.SelectedValue = Convert.ToString(dsDetails.Tables[0].Rows[0]["LastCompletedAction"]);
                }
                if (cmbNextAction.Items.FindByValue(dsDetails.Tables[0].Rows[0]["NextAction"].ToString().Trim()) != null)
                {
                    cmbNextAction.SelectedValue = Convert.ToString(dsDetails.Tables[0].Rows[0]["NextAction"]);
                }
                if (cmbCategory.Items.FindByValue(dsDetails.Tables[0].Rows[0]["Category"].ToString().Trim()) != null)
                {
                    cmbCategory.SelectedValue = Convert.ToString(dsDetails.Tables[0].Rows[0]["Category"]);
                }


                if (cmblastaction.Items.FindByValue(dsDetails.Tables[0].Rows[0]["LastCompletedAction"].ToString().Trim()) != null)
                {
                    cmblastaction.SelectedValue = Convert.ToString(dsDetails.Tables[0].Rows[0]["LastCompletedAction"]);
                }
                if (cmbnxtaction.Items.FindByValue(dsDetails.Tables[0].Rows[0]["NextAction"].ToString().Trim()) != null)
                {
                    cmbnxtaction.SelectedValue = Convert.ToString(dsDetails.Tables[0].Rows[0]["NextAction"]);
                }
                if (cmbnewstatus.Items.FindByValue(dsDetails.Tables[0].Rows[0]["Status"].ToString().Trim()) != null)
                {
                    cmbnewstatus.SelectedValue = Convert.ToString(dsDetails.Tables[0].Rows[0]["Status"]);
                }


                txtInfo1.Text = dsDetails.Tables[0].Rows[0]["Information1"].ToString();
                txtInfo2.Text = dsDetails.Tables[0].Rows[0]["Information2"].ToString();
                if (ddlinfo3.Items.FindByValue(dsDetails.Tables[0].Rows[0]["Information3"].ToString().Trim()) != null)
                {
                    ddlinfo3.SelectedValue = Convert.ToString(dsDetails.Tables[0].Rows[0]["Information3"]);
                }

                if (ddlinfo4.Items.FindByValue(dsDetails.Tables[0].Rows[0]["Information4"].ToString().Trim()) != null)
                {
                    ddlinfo4.SelectedValue = Convert.ToString(dsDetails.Tables[0].Rows[0]["Information4"]);
                }
                if (ddlinfo5.Items.FindByValue(dsDetails.Tables[0].Rows[0]["Information5"].ToString().Trim()) != null)
                {
                    ddlinfo5.SelectedValue = Convert.ToString(dsDetails.Tables[0].Rows[0]["Information5"]);
                }


                //if (DropDownList1.Items.FindByValue(dsDetails.Tables[0].Rows[0]["callbackflag"].ToString().Trim()) != null)

                string tt = Convert.ToString(dsDetails.Tables[0].Rows[0]["callbackflag"]);
                if (tt == "NO")
                {
                    DropDownList1.SelectedItem.Text = "NO";
                    //DropDownList1.SelectedValue = Convert.ToString(dsDetails.Tables[0].Rows[0]["callbackflag"]);
                }
                else
                {
                    DropDownList1.SelectedItem.Text = "YES";
                }

                TextBox1.Text = Convert.ToString(dsDetails.Tables[0].Rows[0]["Callbackdate"]);

                dsDetails = bl.GetLeadContacts(leadID);

                if (dsDetails != null && dsDetails.Tables[0].Rows.Count > 0)
                {
                    GrdViewLeadContact.DataSource = dsDetails.Tables[0];
                    GrdViewLeadContact.DataBind();
                    Session["contactDs"] = dsDetails;
                }

                UpdateButton.Visible = true;
                AddButton.Visible    = false;
                ModalPopupExtender2.Show();
            }
        }
        catch (Exception ex)
        {
            TroyLiteExceptionManager.HandleException(ex);
        }
    }
Ejemplo n.º 6
0
    protected void btnExportToExcel_Click(object sender, EventArgs e)
    {
        try
        {
            HtmlForm form = new HtmlForm();
            Response.Clear();
            Response.Buffer = true;
            string filename = "LeadManagement_" + DateTime.Now.ToString() + ".xls";

            LeadBusinessLogic bl = new LeadBusinessLogic(GetConnectionString());

            int leadid = 0;

            DataSet ds = bl.ListLeadMasterContacts(GetConnectionString(), txtSearch.Text, ddCriteria.SelectedValue);

            if (ds != null)
            {
                if (ds.Tables[0].Rows.Count > 0)
                {
                    DataTable dt = new DataTable();
                    dt.Columns.Add(new DataColumn("LeadID"));
                    dt.Columns.Add(new DataColumn("CreationDate"));
                    dt.Columns.Add(new DataColumn("ProspectCustName"));
                    dt.Columns.Add(new DataColumn("Address"));
                    dt.Columns.Add(new DataColumn("Mobile"));
                    dt.Columns.Add(new DataColumn("Landline"));
                    dt.Columns.Add(new DataColumn("Email"));
                    dt.Columns.Add(new DataColumn("ModeOfContact"));
                    dt.Columns.Add(new DataColumn("PersonalResponsible"));
                    dt.Columns.Add(new DataColumn("BusinessType"));
                    dt.Columns.Add(new DataColumn("Branch"));
                    dt.Columns.Add(new DataColumn("Status"));
                    dt.Columns.Add(new DataColumn("LastCompletedAction"));
                    dt.Columns.Add(new DataColumn("NextAction"));
                    dt.Columns.Add(new DataColumn("Category"));
                    dt.Columns.Add(new DataColumn("ContactedDate"));
                    dt.Columns.Add(new DataColumn("ContactSummary"));

                    DataRow dr_export1 = dt.NewRow();
                    dt.Rows.Add(dr_export1);

                    foreach (DataRow dr in ds.Tables[0].Rows)
                    {
                        if (leadid == Convert.ToInt32(dr["LeadId"]))
                        {
                            DataRow dr_export111 = dt.NewRow();
                            dr_export111["LeadID"]              = "";
                            dr_export111["CreationDate"]        = "";
                            dr_export111["ProspectCustName"]    = "";
                            dr_export111["Address"]             = "";
                            dr_export111["Mobile"]              = "";
                            dr_export111["Landline"]            = "";
                            dr_export111["Email"]               = "";
                            dr_export111["ModeOfContact"]       = "";
                            dr_export111["PersonalResponsible"] = "";
                            dr_export111["BusinessType"]        = "";
                            dr_export111["Branch"]              = "";
                            dr_export111["Email"]               = "";
                            dr_export111["Status"]              = "";
                            dr_export111["LastCompletedAction"] = "";
                            dr_export111["NextAction"]          = "";
                            dr_export111["Category"]            = "";
                            dr_export111["ContactedDate"]       = dr["ContactedDate"];
                            dr_export111["ContactSummary"]      = dr["ContactSummary"];
                            dt.Rows.Add(dr_export111);
                        }
                        else
                        {
                            DataRow dr_export = dt.NewRow();
                            dr_export["LeadID"]              = dr["LeadID"];
                            dr_export["CreationDate"]        = dr["CreationDate"];
                            dr_export["ProspectCustName"]    = dr["ProspectCustName"];
                            dr_export["Address"]             = dr["Address"];
                            dr_export["Mobile"]              = dr["Mobile"];
                            dr_export["Landline"]            = dr["Landline"];
                            dr_export["Email"]               = dr["Email"];
                            dr_export["ModeOfContact"]       = dr["ModeOfContact"];
                            dr_export["PersonalResponsible"] = dr["PersonalResponsible"];
                            dr_export["BusinessType"]        = dr["BusinessType"];
                            dr_export["Branch"]              = dr["Branch"];
                            dr_export["Email"]               = dr["Email"];
                            dr_export["Status"]              = dr["Status"];
                            dr_export["LastCompletedAction"] = dr["LastCompletedAction"];
                            dr_export["NextAction"]          = dr["NextAction"];
                            dr_export["Category"]            = dr["Category"];
                            dr_export["ContactedDate"]       = dr["ContactedDate"];
                            dr_export["ContactSummary"]      = dr["ContactSummary"];
                            dt.Rows.Add(dr_export);
                        }
                        leadid = Convert.ToInt32(dr["LeadId"]);
                    }

                    ExportToExcel(filename, dt);
                }
            }
            else
            {
                ScriptManager.RegisterStartupScript(Page, typeof(Button), "MyScript", "alert('No Data Found');", true);
            }

            //if (dt.Rows.Count > 0)
            //{
            //    DataTable dt = ds.Tables[0];

            //    System.IO.StringWriter tw = new System.IO.StringWriter();
            //    System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);

            //    DataGrid dgGrid = new DataGrid();
            //    dgGrid.DataSource = dt;
            //    dgGrid.DataBind();

            //    //Get the HTML for the control.
            //    dgGrid.RenderControl(hw);

            //    //Write the HTML back to the browser.
            //    Response.ContentType = "application/vnd.ms-excel";
            //    Response.AppendHeader("Content-Disposition", "attachment; filename=" + filename + "");
            //    this.EnableViewState = false;
            //    Response.Write(tw.ToString());
            //    Response.End();
            //    UpdatePanelPage.Update();
            //}
        }
        catch (Exception ex)
        {
            TroyLiteExceptionManager.HandleException(ex);
        }
    }
Ejemplo n.º 7
0
    private void BindDropdownList()
    {
        LeadBusinessLogic bl = new LeadBusinessLogic(sDataSource);
        DataSet           ds = new DataSet();

        ds = bl.GetDropdownList(sDataSource, "CONTACT");
        cmbModeOfContact.DataSource = ds;
        cmbModeOfContact.DataBind();
        cmbModeOfContact.DataTextField  = "TextValue";
        cmbModeOfContact.DataValueField = "TextValue";

        ds = bl.GetDropdownList(sDataSource, "PERRES");
        cmbPersonalResp.DataSource = ds;
        cmbPersonalResp.DataBind();
        cmbPersonalResp.DataTextField  = "TextValue";
        cmbPersonalResp.DataValueField = "TextValue";

        ds = bl.GetDropdownList(sDataSource, "BUSTYPE");
        cmbBussType.DataSource = ds;
        cmbBussType.DataBind();
        cmbBussType.DataTextField  = "TextValue";
        cmbBussType.DataValueField = "TextValue";

        ds = bl.GetDropdownList(sDataSource, "BRNCH");
        cmbBranch.DataSource = ds;
        cmbBranch.DataBind();
        cmbBranch.DataTextField  = "TextValue";
        cmbBranch.DataValueField = "TextValue";

        ds = bl.GetDropdownList(sDataSource, "LSTCMP");
        cmbLastCompAction.DataSource = ds;
        cmbLastCompAction.DataBind();
        cmbLastCompAction.DataTextField  = "TextValue";
        cmbLastCompAction.DataValueField = "TextValue";

        ds = bl.GetDropdownList(sDataSource, "LSTCMP");
        cmblastaction.DataSource = ds;
        cmblastaction.DataBind();
        cmblastaction.DataTextField  = "TextValue";
        cmblastaction.DataValueField = "TextValue";

        ds = bl.GetDropdownList(sDataSource, "NXTAXN");
        cmbNextAction.DataSource = ds;
        cmbNextAction.DataBind();
        cmbNextAction.DataTextField  = "TextValue";
        cmbNextAction.DataValueField = "TextValue";

        ds = bl.GetDropdownList(sDataSource, "NXTAXN");
        cmbnxtaction.DataSource = ds;
        cmbnxtaction.DataBind();
        cmbnxtaction.DataTextField  = "TextValue";
        cmbnxtaction.DataValueField = "TextValue";

        ds = bl.GetDropdownList(sDataSource, "CATEGRY");
        cmbCategory.DataSource = ds;
        cmbCategory.DataBind();
        cmbCategory.DataTextField  = "TextValue";
        cmbCategory.DataValueField = "TextValue";

        ds = bl.GetDropdownList(sDataSource, "STATUS");
        cmbStatus.DataSource = ds;
        cmbStatus.DataBind();
        cmbStatus.DataTextField  = "TextValue";
        cmbStatus.DataValueField = "TextValue";

        ds = bl.GetDropdownList(sDataSource, "STATUS");
        cmbnewstatus.DataSource = ds;
        cmbnewstatus.DataBind();
        cmbnewstatus.DataTextField  = "TextValue";
        cmbnewstatus.DataValueField = "TextValue";

        ds = bl.GetDropdownList(sDataSource, "INFO3");
        ddlinfo3.DataSource = ds;
        ddlinfo3.DataBind();
        ddlinfo3.DataTextField  = "TextValue";
        ddlinfo3.DataValueField = "TextValue";

        ds = bl.GetDropdownList(sDataSource, "INFO4");
        ddlinfo4.DataSource = ds;
        ddlinfo4.DataBind();
        ddlinfo4.DataTextField  = "TextValue";
        ddlinfo4.DataValueField = "TextValue";

        ds = bl.GetDropdownList(sDataSource, "INFO5");
        ddlinfo5.DataSource = ds;
        ddlinfo5.DataBind();
        ddlinfo5.DataTextField  = "TextValue";
        ddlinfo5.DataValueField = "TextValue";
    }
Ejemplo n.º 8
0
    protected void AddButton_Click(object sender, EventArgs e)
    {
        DateTime creationDate;
        int      LeadID              = 0;
        string   prospectCustomer    = string.Empty;
        string   address             = string.Empty;
        string   mobile              = string.Empty;
        string   landline            = string.Empty;
        string   email               = string.Empty;
        string   modeOfContact       = string.Empty;
        string   personalResponsible = string.Empty;
        string   businessType        = string.Empty;
        string   branch              = string.Empty;
        string   status              = string.Empty;
        string   LastCompletedAction = string.Empty;
        //string creationDate = string.Empty;
        string  nextAction = string.Empty;
        string  category   = string.Empty;
        DataSet dsContact;

        string info1 = string.Empty;
        string info2 = string.Empty;
        string info3 = string.Empty;

        string info4 = string.Empty;
        string info5 = string.Empty;

        try
        {
            if (Session["contactDs"] == null || ((DataSet)Session["contactDs"]).Tables[0].Rows.Count < 1)
            {
                ScriptManager.RegisterStartupScript(Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('Please enter atleast one Lead Contact and try again.')", true);
                return;
            }

            if (Page.IsValid)
            {
                //if(txtLeadNo.Text != string.Empty)
                //LeadID = int.Parse(txtLeadNo.Text);

                creationDate = DateTime.Parse(txtCreationDate.Text);
                //creationDate = txtCreationDate.Text.Trim();
                prospectCustomer    = txtProspCustName.Text;
                address             = txtAddress.Text;
                mobile              = txtMobile.Text;
                landline            = txtLandline.Text;
                email               = txtEmail.Text;
                modeOfContact       = cmbModeOfContact.SelectedValue;
                personalResponsible = cmbPersonalResp.Text;
                businessType        = cmbBussType.SelectedValue;
                branch              = cmbBranch.SelectedValue;
                if (cmbnewstatus.SelectedValue == "0")
                {
                    status = cmbStatus.SelectedValue;
                }
                else
                {
                    status = cmbnewstatus.SelectedValue;
                }
                if (cmblastaction.SelectedValue == "0")
                {
                    LastCompletedAction = cmbLastCompAction.SelectedValue;
                }
                else
                {
                    LastCompletedAction = cmblastaction.SelectedValue;
                }
                if (cmbnxtaction.SelectedValue == "0")
                {
                    nextAction = cmbNextAction.SelectedValue;
                }
                else
                {
                    nextAction = cmbnxtaction.SelectedValue;
                }
                category = cmbCategory.SelectedValue;

                info1 = txtInfo1.Text;
                info2 = txtInfo2.Text;

                info3 = ddlinfo3.SelectedValue;
                info4 = ddlinfo4.SelectedValue;
                info5 = ddlinfo5.SelectedValue;

                string callbackflag = DropDownList1.SelectedItem.Text;
                string callbackdate = TextBox1.Text;

                dsContact = (DataSet)Session["contactDs"];

                string connStr = GetConnectionString();

                LeadBusinessLogic bl = new LeadBusinessLogic(connStr);

                //bl.AddUpdateLeadMaster(LeadID, creationDate, prospectCustomer, address, mobile, landline, email, modeOfContact, personalResponsible, businessType, branch, status, LastCompletedAction, nextAction, category, dsContact, info1, info2, info3, info4, info5);
                bl.AddUpdateLeadMaster(LeadID, creationDate, prospectCustomer, address, mobile, landline, email, modeOfContact, personalResponsible, businessType, branch, status, LastCompletedAction, nextAction, category, dsContact, info1, info2, info3, info4, info5, callbackflag, callbackdate);


                GrdViewLead.DataBind();

                ScriptManager.RegisterStartupScript(Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('Lead Details saved successfully.')", true);

                BindGrid("", "");
                UpdatePanelPage.Update();


                ModalPopupExtender2.Hide();


                //return;
            }
        }
        catch (Exception ex)
        {
            TroyLiteExceptionManager.HandleException(ex);
            return;
        }
    }