//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();
}
}
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;
}
}
}
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);
}
}
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();
}
}
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);
}
}
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);
}
}
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";
}
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;
}
}
