public void Load_Grid()
{
try
{
//string[] param = new string[4];
//param[0] = "Empcode";
//param[1] = Request.Cookies["empcode"].Value.ToString();
//param[2] = "Plan_Date";
//param[3] = txtDate.Text;
CommanDataLoad.Load_Gridview(GridView1, "Usp_Load_Sw_Request_Report", "0", "Software_Request_Report", "");
}
catch (Exception ex)
{
lblmsg.Text = "Some Error" + ex.Message.ToString();
}
}
public static string[] Getemp(string prefix)
{
List <string> data = new List <string>();
string empcode = HttpContext.Current.Request.Cookies["empcode"].Value.ToString();
DataSet ds = CommanDataLoad.ExecuteDataSet("select emp_code,name from dbo.get_child_emp('" + empcode + "') where name like '%" + prefix + "%' order by name", "2", "Lead Assign Telecaller New", "");
int i = 0;
while (i < ds.Tables[0].Rows.Count)
{
data.Add(string.Format("{0}-{1}", ds.Tables[0].Rows[i][1], ds.Tables[0].Rows[i][0]));
i = i + 1;
}
return(data.ToArray());
}
public void Load_Grid()
{
try
{
string[] param = new string[4];
param[0] = "Empcode";
param[1] = Request.Cookies["empcode"].Value.ToString();
param[2] = "Plan_Date";
param[3] = txtDate.Text;
CommanDataLoad.Load_Gridview(GridView1, "USP_Load_EMP_Team_Daily_Planing", "1", "Daily_Planing", param);
}
catch (Exception ex)
{
//lblmsg.Text = "Some Error" + ex.Message.ToString();
}
}
public static string[] GetCities(string prefix)
{
List <string> data = new List <string>();
DataSet ds = CommanDataLoad.ExecuteDataSet("select City_name, City_Id from City_master where is_active=1 and City_Name like '%" + prefix + "%'", "2", "Manage Lead", "");
int i = 0;
while (i < ds.Tables[0].Rows.Count)
{
data.Add(string.Format("{0}-{1}", ds.Tables[0].Rows[i]["City_Name"], ds.Tables[0].Rows[i]["City_ID"]));
i = i + 1;
}
return(data.ToArray());
}
//private DropDownList ddldept;
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
CommanDataLoad.Load_CommanDropDown(ddlcompany, "", "select Company_id,company_name from company_Master", "0", "Company_id", "company_name", "Company_Master", "");
//CommanDataLoad.Load_CommanDropDown(ddlreportingauth, "", "select Empid,emp_name from employee_Master order by emp_name asc", "0", "empid", "emp_name", "Employee_Master", "");
CommanDataLoad.Load_CommanDropDown(ddldesignation, "", "select designation_id,designation from designation_Master order by designation asc", "0", "designation_id", "designation", "designation_Master", "");
CommanDataLoad.Load_CommanDropDown(ddldept, "", "select department_id,department_name from department_Master order by department_name asc", "0", "department_id", "department_name", "department_Master", "");
CommanDataLoad.Load_CommanDropDown(ddlreportingauth, "", "select emp_code,emp_name from employee_Master order by emp_name asc", "0", "emp_code", "emp_name", "Employee_Master", "");
//dgemployeelist.DataSource = BindGrid();
//dgemployeelist.DataBind();
txtctc.Text = "0";
txtvariable.Text = "0";
}
}
public static string[] Getstatus(string prefix)
{
List <string> data = new List <string>();
DataSet ds = CommanDataLoad.ExecuteDataSet("select lead_status_id, lead_status from lead_status_master where lead_status like '%" + prefix + "%' order by lead_status", "2", "Manage Lead", "");
int i = 0;
while (i < ds.Tables[0].Rows.Count)
{
data.Add(string.Format("{0}-{1}", ds.Tables[0].Rows[i][1], ds.Tables[0].Rows[i][0]));
i = i + 1;
}
return(data.ToArray());
}
protected void btnsubmit_Click(object sender, EventArgs e)
{
if (Session["checkExits"] == null || Session["checkExits"].ToString() == "")
{
if (txtMessage.Text != "" && TextArea1.Text != "")
{
string[] param = new string[12];
param[0] = "messageTitle";
param[1] = txtMessage.Text;
param[2] = "messageBody";
param[3] = TextArea1.Text;
param[4] = "is_Active";
if (Active.Checked == true)
{
param[5] = "1";
}
else
{
param[5] = "0";
}
param[6] = "IP_address";
param[7] = ClsConnection.StrIP;
param[8] = "UserId";
param[9] = ClsConnection.Userid;
param[10] = "MessageId";
param[11] = lblid.Text;
int rowaffected = CommanDataLoad.ExecuteNonQuery("usp_insert_message_Master", "1", "Message_Master", param);
if (rowaffected > 0)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Record Saved Successfully')", true);
ClearControls();
BindGrid();
}
}
}
else
{
//ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Please Enter Values In Data field ')", true);
//ClearControls();
update_data();
}
// ClearControls();
Session["checkExits"] = "";
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
CommanDataLoad.Load_CommanDropDown(ddledept, "", "select department_id,department_name from department_Master order by department_name asc", "0", "department_id", "department_name", "department_Master", "");
CommanDataLoad.Load_CommanDropDown(ddledesignation, "", "select designation_id,designation from designation_Master order by designation asc", "0", "designation_id", "designation", "designation_Master", "");
CommanDataLoad.Load_CommanDropDown(ddlcom, "", "select Company_id,company_name from company_Master", "0", "Company_id", "company_name", "Company_Master", "");
CommanDataLoad.Load_CommanDropDown(ddlereporting, "", "select emp_code,emp_name from employee_Master order by emp_name asc", "0", "emp_code", "emp_name", "Employee_Master", "");
Load_Employee_EditData();
string[] Param = new string[2];
Param[0] = "emp";
Param[1] = Convert.ToInt16(Request.QueryString["EmpId"]).ToString();
CommanDataLoad.Load_Gridview(GridView1, "sp_get_login_history", "1", "Edit employee", Param);
}
}
protected void Load_Grid()
{
try
{
string[] param = new string[6];
param[0] = "Vertical_Id";
param[1] = Request.QueryString["Vertical_Id"];
param[2] = "Lead_Status_id";
param[3] = Request.QueryString["Lead_Status_id"];
param[4] = "Emp_Code";
param[5] = Request.Cookies["empcode"].Value.ToString();
CommanDataLoad.Load_Gridview(GridView1, "USP_Load_LeadDetail", "1", "Vertical Lead Details", param);
}
catch (Exception ex)
{
}
}
private void Load_SourceType(string SourceNm)
{
string[] param = new string[2];
param[0] = "source_name";
param[1] = SourceNm;
DataSet ds = CommanDataLoad.ExecuteDataSet("USP_Load_SourceType", "1", "", param);
if (ds != null)
{
ddlsouce.SelectedValue = ds.Tables[0].Rows[0]["source_id"].ToString();
}
else
{
ddlsouce.SelectedIndex = -1;
}
}
private void Load_City(string CityNm)
{
string[] param = new string[2];
param[0] = "City_Name";
param[1] = CityNm;
DataSet ds = CommanDataLoad.ExecuteDataSet("USP_Load_StateByCityNm", "1", "", param);
if (ds != null)
{
ddlCity.SelectedValue = ds.Tables[0].Rows[0]["City_Id"].ToString();
}
else
{
ddlCity.SelectedIndex = -1;
}
}
protected void Update_Data()
{
try
{
string[] param = new string[24];
param[0] = "Map_Id";
param[1] = lblMapId.Text;
param[2] = "Bank_Id";
param[3] = ddlbName.SelectedValue;
param[4] = "City_Id";
param[5] = ddlcName.SelectedValue;
param[6] = "Product_Id";
param[7] = ddlpName.SelectedValue;
param[8] = "Contact_Person";
param[9] = txtcPerson.Text;
param[10] = "Designation";
param[11] = txtDesign.Text;
param[12] = "Mobile_No";
param[13] = txtmNo.Text;
param[14] = "Landline_No";
param[15] = txtlandNo.Text;
param[16] = "Fax_No";
param[17] = txtfNo.Text;
param[18] = "Email_Id";
param[19] = txteId.Text;
param[20] = "Userid";
param[21] = ClsConnection.Userid;
param[22] = "Ip_Addr";
param[23] = ClsConnection.StrIP;
int rowaffected = CommanDataLoad.ExecuteNonQuery("USP_Update_Bank_Product_Mapping", "1", "Edit Bank Product Mapping", param);
if (rowaffected > 0)
{
Response.Write("<script>alert('Record Updated Successfully.');</script>");
}
Popup(false);
Load_Grid();
ClearControls();
}
catch (Exception ex)
{
//lblmsg.Text = "Some Error" + ex.Message.ToString();
}
}
protected int DirectWebsiteLead(string CName, string MobileNo, string Email, string CityId, string Profession, string Product_Id, string MonthlyIncome)
{
int result = 0;
try
{
string[] param = new string[14];
param[0] = "CName";
param[1] = CName;
param[2] = "MobileNo";
param[3] = MobileNo;
param[4] = "City_Id";
param[5] = CityId;
param[6] = "Email";
param[7] = Email;
param[8] = "Profession";
param[9] = Profession;
param[10] = "MonthlyIncome";
param[11] = MonthlyIncome;
param[12] = "Product_Id";
param[13] = Product_Id;
int rowaffected = CommanDataLoad.ExecuteNonQuery("USP_Insert_LeadRawData_Website", "1", "Customer Web Request", param);
if (rowaffected > 0)
{
//Response.Write("<script>alert('Record Insert Successfully.');</script>");
result = 1;
Response.Write(result);
}
else
{
result = 0;
Response.Write(result);
}
return(result);
}
catch (Exception ex)
{
result = 0;
//lblmsg.Text = "Some Error" + ex.Message.ToString();
}
return(result);
}
protected void Load_Grid()
{
try
{
string[] param = new string[6];
param[0] = "Empcode";
param[1] = Request.Cookies["empcode"].Value.ToString();
param[2] = "Month";
param[3] = ddlMonth.SelectedValue;
param[4] = "Year";
param[5] = ddlYear.SelectedValue;
CommanDataLoad.Load_Gridview(GridView1, "USP_Load_Team", "1", "Team_Target_Form", param);
}
catch (Exception ex)
{
//lblmsg.Text = "Some Error" + ex.Message.ToString();
}
}
public void Fill_Grid()
{
try
{
string[] param1 = new string[2];
param1[0] = "Id";
param1[1] = Convert.ToString(Request.QueryString["Id"]);
CommanDataLoad.Load_Gridview(grdDetails, "Usp_LoadPayout_Details", "1", "playout_detail", param1);
}
catch
{
throw;
}
finally
{
}
}
protected void Load_Grid()
{
try
{
string[] param1 = new string[10];
param1[0] = "FromDt";
param1[1] = Convert.ToString(Request.QueryString["fdate"]);
param1[2] = "ToDt";
param1[3] = Convert.ToString(Request.QueryString["tdate"]);
param1[4] = "Emp_Code";
param1[5] = Convert.ToString(Request.QueryString["Emp_Code"]);
param1[6] = "Type";
param1[7] = Convert.ToString(Request.QueryString["type"]);
param1[8] = "lead_staus_id";
if (Convert.ToString(Request.QueryString["lead_status_id"].ToString()) != "undefined")
{
param1[9] = Convert.ToString(Request.QueryString["lead_status_id"]);
}
else
{
param1[9] = "0";
}
if (Convert.ToString(Request.QueryString["type"]).Contains("ST"))
{
CommanDataLoad.Load_Gridview(grdDetails, "USP_Load_Lead_Detail_statusWise", "1", "View Assign Lead Detail", param1);
}
else
{
CommanDataLoad.Load_Gridview(grdDetails, "USP_Load_Assign_Lead_Detail", "1", "View Assign Lead Detail", param1);
}
}
catch
{
throw;
}
finally
{
}
}
private void Load_Emp_Details()
{
string[] param = new string[2];
param[0] = "Emp_Code";
param[1] = Request.Cookies["empcode"].Value.ToString();
//param[1] = "RB40000255";
DataSet ds = new DataSet();
ds = CommanDataLoad.ExecuteDataSet("Usp_Load_User_Detail_Sp", "1", "LogRequest", param);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
lblusername.Text = ds.Tables[0].Rows[0]["Emp_Name"].ToString();
lbluseremail.Text = ds.Tables[0].Rows[0]["Email_Id"].ToString();
lblreportingemail.Text = ds.Tables[0].Rows[0]["Reporting_Email_Id"].ToString();
}
}
}
private string Load_City(string CityNm)
{
string cityid = "-1";
string[] param = new string[2];
param[0] = "City_Name";
param[1] = CityNm;
DataSet ds = CommanDataLoad.ExecuteDataSet("USP_Load_CityIDbyCityNm", "1", "", param);
if (ds != null)
{
cityid = ds.Tables[0].Rows[0]["City_Id"].ToString();
}
else
{
cityid = "-1";
}
return(cityid);
}
protected void btnsubmit_Click(object sender, EventArgs e)
{
string strDump = "";
int i = 0;
int j = 0;
strDump = "delete from group_rights where groupid=" + ddlgroup.SelectedValue + ";";
while (i < TreeView1.Nodes.Count)
{
if (TreeView1.Nodes[i].Checked == true)
{
strDump = strDump + "Insert into Group_Rights (Menu_ID,Groupid,UserId,ip,sysdate)";
strDump = strDump + "values(" + TreeView1.Nodes[i].Value + "," + ddlgroup.SelectedValue + "," + CommanDataLoad.UserId + ",'" + Request.UserHostAddress + "',getdate());";
}
j = 0;
while (j < TreeView1.Nodes[i].ChildNodes.Count)
{
if (TreeView1.Nodes[i].ChildNodes[j].Checked == true)
{
strDump = strDump + "Insert into Group_Rights (Menu_ID,Groupid,UserId,ip,sysdate)";
strDump = strDump + "values(" + TreeView1.Nodes[i].ChildNodes[j].Value + "," + ddlgroup.SelectedValue + "," + CommanDataLoad.UserId + ",'" + Request.UserHostAddress + "',getdate());";
}
j = j + 1;
}
i = i + 1;
}
int rowaffected = CommanDataLoad.ExecuteNonQuery(strDump, "2", "Group Rights Item", "");
if (rowaffected > 0)
{
Response.Write("<script>alert('Record Inserted Successfully.');</script>");
}
else
{
Response.Write("<script>alert('Technical error Please contact CS Development Team');</script>");
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
string[] param = new string[22];
param[0] = "Bank_Id";
param[1] = ddlBank.SelectedValue;
param[2] = "City_Id";
param[3] = ddlCity.SelectedValue;
param[4] = "Product_Id";
param[5] = ddlProduct.SelectedValue;
param[6] = "Contact_Person";
param[7] = txtContactPerson.Text;
param[8] = "Designation";
param[9] = txtDesignation.Text;
param[10] = "Mobile_No";
param[11] = txtMobileNo.Text;
param[12] = "Landline_No";
param[13] = txtLandlineNo.Text;
param[14] = "Fax_No";
param[15] = txtFaxNo.Text;
param[16] = "Email_Id";
param[17] = txtEmailId.Text;
param[18] = "UserId";
param[19] = ClsConnection.Userid;
param[20] = "Ip_Addr";
param[21] = ClsConnection.StrIP;
int rowaffected = CommanDataLoad.ExecuteNonQuery("USP_Insert_Bank_Product_Mapping", "1", "Bank Product Mapping", param);
if (rowaffected > 0)
{
Response.Write("<script>alert('Record Saved Successfully.');</script>");
}
Load_Grid();
ClearControls();
}
catch (Exception ex)
{
//lblmsg.Text = "Some Error" + ex.Message.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
// Response.Cookies["empcode"].Value = "RB40000401";
if (!Page.IsPostBack)
{
CommanDataLoad.Load_CommanDropDown(ddlStatus, "Select All", "select * from lead_Status_Master order by lead_status asc", "0", "lead_Status_id", "Lead_Status", "Lead_status_Master", "");
Load_lead_Status();
Load_Assign_To();
Load_City();
Load_Bank();
BindGrid();
BindTime();
//Util.JQueryUtils.RegisterTextBoxForDatePicker(Page, txtfollowup);
////RBERP.JQueryUtils.RegisterTextBoxForDatePicker(Page, txtfollowup);
////RBERP.JQueryUtils.RegisterTextBoxForDatePicker(Page, txtvfollowupdate);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
lblvlid.Text = Request.QueryString["leadid"].ToString();
Load_Bank();
Load_Assign_To();
Load_lead_Status();
Bind_Valid_PopUpGrid();
BindTime();
txtvfollowupdate.Text = DateTime.Now.Date.ToShortDateString();
string[] Param = new string[2];
Param[0] = "empcode";
Param[1] = Request.Cookies["empcode"].Value.ToString();
CommanDataLoad.Load_CommanDropDown(ddlproduct, "", "Get_Product", "1", "product_id", "product_name", "Manage Lead Data", "");
CommanDataLoad.Load_CommanDropDown(ddlbroker, "", "sp_load_broker", "1", "broker_id", "broker_name", "Lead Capture", Param);
Load_Data();
}
}
public void Load_Lead_Details(string Empcode, string PlanDate, string StartTime, string EndTime)
{
try
{
string[] param = new string[8];
param[0] = "Empcode";
param[1] = Empcode;
param[2] = "Plan_Date";
param[3] = PlanDate;
param[4] = "StartTime";
param[5] = StartTime;
param[6] = "EndTime";
param[7] = EndTime;
CommanDataLoad.Load_Gridview(GridView2, "USP_Load_Emp_Lead_Detail", "1", "Daily_Planing", param);
}
catch (Exception ex)
{
//lblmsg.Text = "Some Error" + ex.Message.ToString();
}
}
protected void ClearControls()
{
Name.Text = "";
txtMobile.Text = "";
ddlproduct.SelectedValue = "0";
ddlstatus.SelectedItem.Text = "New";
ddlsouce.SelectedItem.Text = "PolicyBoss";
ddlstatus.SelectedValue = "43";
ddlsouce.SelectedValue = "15";
ddlVertical.SelectedIndex = -1;
lblUserId.Text = "";
Name.Focus();
CommanDataLoad.Load_CommanDropDown(ddlstatus, "", "select * from lead_Status_Master order by lead_status asc", "0", "lead_Status_id", "Lead_Status", "Lead_status_Master", "");
}
protected void btnsubmit_Click(object sender, EventArgs e)
{
if (txtname.Text != "" && txtemail.Text != "" && txtmobile.Text != "" && txtremark.Text != "")
{
string[] param = new string[8];
param[0] = "name";
param[1] = txtname.Text;
param[2] = "email";
param[3] = txtemail.Text;
param[4] = "mobile";
param[5] = txtmobile.Text;
param[6] = "Remark";
param[7] = txtremark.Text;
int rowaffected = CommanDataLoad.ExecuteNonQuery("usp_insert_lead_Master", "1", "Lead_Capture_Master", param);
if (rowaffected > 0)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Record Saved Successfully')", true);
ClearControls();
}
}
}
protected void Update_Data()
{
try
{
string[] param = new string[12];
param[0] = "Bank_Id";
param[1] = lblBankId.Text;
param[2] = "Bank_Name";
param[3] = txtBankName.Text;
param[4] = "Bank_Address";
param[5] = txtBankAddress.Text;
param[6] = "Is_Active";
if (chkIsAct.Checked == true)
{
param[7] = "1";
}
else
{
param[7] = "0";
}
param[8] = "Userid";
param[9] = ClsConnection.Userid;
param[10] = "Ip_Addr";
param[11] = ClsConnection.StrIP;
int rowaffected = CommanDataLoad.ExecuteNonQuery("USP_Update_Bank_Master", "1", "Bank Master", param);
if (rowaffected > 0)
{
Response.Write("<script>alert('Record Updated Successfully.');</script>");
}
Popup(false);
BindGrid();
ClearControls();
}
catch (Exception ex)
{
//lblmsg.Text = "Some Error" + ex.Message.ToString();
}
}
protected void Update_Data()
{
try
{
string[] param = new string[12];
param[0] = "Sub_Division_Id";
param[1] = lblSubDivisionId.Text;
param[2] = "Division_Id";
param[3] = ddlDiv.SelectedValue;
param[4] = "Sub_Division_Name";
param[5] = txtSubDiv.Text;
param[6] = "Is_Active";
if (chkIsAct.Checked == true)
{
param[7] = "Y";
}
else
{
param[7] = "N";
}
param[8] = "Userid";
param[9] = ClsConnection.Userid;
param[10] = "Ip_Addr";
param[11] = ClsConnection.StrIP;
int rowaffected = CommanDataLoad.ExecuteNonQuery("USP_Update_Sub_Division", "1", "Sub Division Master", param);
if (rowaffected > 0)
{
Response.Write("<script>alert('Record Updated Successfully.');</script>");
}
Popup(false);
Load_Grid();
ClearControls();
}
catch (Exception ex)
{
//lblmsg.Text = "Some Error" + ex.Message.ToString();
}
}
protected void Load_Bank_Mapping_Detail(string Map_Id)
{
try
{
string[] param = new string[2];
param[0] = "Map_Id";
param[1] = Map_Id;
DataSet ds = new DataSet();
ds = CommanDataLoad.ExecuteDataSet("USP_Bank_Product_Mapping_Detail", "1", "Edit Bank Product Mapping", param);
if (ds != null)
{
lblMapId.Text = ds.Tables[0].Rows[0]["Map_Id"].ToString();
Load_Bank();
ddlbName.SelectedValue = ds.Tables[0].Rows[0]["Bank_Id"].ToString();
Load_City();
ddlcName.SelectedValue = ds.Tables[0].Rows[0]["City_Id"].ToString();
Load_Product();
ddlpName.SelectedValue = ds.Tables[0].Rows[0]["Product_Id"].ToString();
txtcPerson.Text = ds.Tables[0].Rows[0]["Contact_Person"].ToString();
txtDesign.Text = ds.Tables[0].Rows[0]["Designation"].ToString();
txtmNo.Text = ds.Tables[0].Rows[0]["Mobile_No"].ToString();
txtlandNo.Text = ds.Tables[0].Rows[0]["Landline_No"].ToString();
txtfNo.Text = ds.Tables[0].Rows[0]["Fax_No"].ToString();
txteId.Text = ds.Tables[0].Rows[0]["Email_Id"].ToString();
Popup(true);
}
else
{
Popup(false);
}
}
catch (Exception ex)
{
//lblmsg.Text = "Some Error" + ex.Message.ToString();
}
}
protected void btnsubmit_Click(object sender, EventArgs e)
{
try
{
if (txtstatename.Text == "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Please enter State Name')", true);
return;
}
DateTime localdate = DateTime.Now;
string[] param = new string[8];
param[0] = "State_name";
param[1] = txtstatename.Text;
param[2] = "Is_Active";
param[3] = "1";
param[4] = "Created_on";
param[5] = string.Format("{0:s}", localdate);
param[6] = "cuserid";
param[7] = ClsConnection.Userid;
int rowaffected = CommanDataLoad.ExecuteNonQuery("SpInsState_Master", "1", "State_Master", param);
if (rowaffected > 0)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Record Saved Successfully')", true);
BindGrid();
}
ClearControls();
}
catch (Exception ex)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Some Error' + ex.Message.ToString();)", true);
}
}
private void BindGrid()
{
string[] param1 = new string[8];
param1[0] = "empcode";
// param1[1] = "RB40000401";
if (Request.QueryString.Count > 0)
{
param1[1] = Request.QueryString["emp_code"].ToString();
}
else
{
param1[1] = Request.Cookies["empcode"].Value.ToString();
}
param1[2] = "cityid";
param1[3] = ddlCity.SelectedValue;
param1[4] = "Lead_Status_id";
param1[5] = ddlStatus.SelectedValue;
param1[6] = "Emp_Code";
param1[7] = ddlEmployee.SelectedValue;
CommanDataLoad.Load_Gridview(dgManageLeads, "SpDispManageLeadData", "1", "Manage_Leads_self", param1);
}
