protected void Page_Load(object sender, EventArgs e)
{
txtDOB.Attributes.Add("readonly", "readonly");
txtAnnvDate.Attributes.Add("readonly", "readonly");
if (!IsPostBack)
{
txtInvestorName.Focus();
// Code for Source 1
SqlDataAdapter S1DA = new SqlDataAdapter(" " +
" select Code, Name from fp_ComboDetail where ComboCode=17 and ParentCode is NULL order by Name " +
" ", Con);
DataSet S1DS = new DataSet();
Con.Open();
S1DA.Fill(S1DS);
Con.Close();
DDSource1.DataSource = S1DS.Tables[0];
DDSource1.DataTextField = "Name";
DDSource1.DataValueField = "Code";
DDSource1.DataBind();
DDSource1.Items.Insert(0, new ListItem("Select Source1", "0"));
// Code for Source 2
//SqlDataAdapter S2DA = new SqlDataAdapter(" " +
//" select Code, PlannerName from fp_Planner p where PlannerRole in (Select Code from fp_ComboDetail where Name<>'Admin') " +
//" ", Con);
//DataSet S2DS = new DataSet();
//Con.Open();
//S2DA.Fill(S2DS);
//Con.Close();
//DDSource2.DataSource = S2DS.Tables[0];
//DDSource2.DataTextField = "PlannerName";
//DDSource2.DataValueField = "Code";
//DDSource2.DataBind();
DDSource2.Items.Insert(0, new ListItem("Select Source2", "0"));
}
}
protected void Page_Load(object sender, EventArgs e)
{
ViewState["xClientCode"] = Request.QueryString["clientcode"];
EditSuccess.Style.Add("Display", "none");
if (!IsPostBack)
{
// Code for Source 1
SqlDataAdapter S1DA = new SqlDataAdapter(" " +
" select Code, Name from fp_ComboDetail where ComboCode=17 and ParentCode is NULL order by Name " +
" ", Con);
DataSet S1DS = new DataSet();
Con.Open();
S1DA.Fill(S1DS);
Con.Close();
DDSource1.DataSource = S1DS.Tables[0];
DDSource1.DataTextField = "Name";
DDSource1.DataValueField = "Code";
DDSource1.DataBind();
DDSource1.Items.Insert(0, new ListItem("Select Source1", "0"));
//// Code for Source 2
//SqlDataAdapter S2DA = new SqlDataAdapter(" " +
//" select Code, PlannerName from fp_Planner p where PlannerRole in (Select Code from fp_ComboDetail where Name<>'Admin') " +
//" ", Con);
//DataSet S2DS = new DataSet();
//Con.Open();
//S2DA.Fill(S2DS);
//Con.Close();
//DDSource2.DataSource = S2DS;
//DDSource2.DataTextField = "PlannerName";
//DDSource2.DataValueField = "Code";
//DDSource2.DataBind();
DDSource2.Items.Insert(0, new ListItem("Select Source2", "0"));
// select for Investor Name
SqlDataAdapter InvGDA = new SqlDataAdapter(" " +
" Select Name, Gender, Age=(year(getdate())-year(DOB)), Email1, Mobile1, Mobile2, Email2, City, Source1, Source2, " +
" OpType1, OpType2, SiteAC, TxnAC, Remarks from fp_Prospects where Code='" + ViewState["xClientCode"] + "' " +
" ", Con);
DataSet InvGDS = new DataSet();
Con.Open();
InvGDA.Fill(InvGDS);
Con.Close();
if (InvGDS.Tables[0].Rows.Count > 0)
{
txtClientName.Text = InvGDS.Tables[0].Rows[0]["Name"].ToString();
DDGender.SelectedValue = InvGDS.Tables[0].Rows[0]["Gender"].ToString();
txtAge.Text = InvGDS.Tables[0].Rows[0]["Age"].ToString();
txtEmailID2.Text = InvGDS.Tables[0].Rows[0]["Email2"].ToString();
txtMobile1.Text = InvGDS.Tables[0].Rows[0]["Mobile1"].ToString();
txtMobile2.Text = InvGDS.Tables[0].Rows[0]["Mobile2"].ToString();
txtCity.Text = InvGDS.Tables[0].Rows[0]["City"].ToString();
DDOpType1.SelectedValue = InvGDS.Tables[0].Rows[0]["OpType1"].ToString();
DDOpType2.SelectedValue = InvGDS.Tables[0].Rows[0]["OpType2"].ToString();
DDSiteAC.SelectedValue = InvGDS.Tables[0].Rows[0]["SiteAC"].ToString();;
DDSource1.SelectedValue = InvGDS.Tables[0].Rows[0]["Source1"].ToString();
DDSource2.SelectedValue = InvGDS.Tables[0].Rows[0]["Source2"].ToString();
DDTxnAC.Text = InvGDS.Tables[0].Rows[0]["TxnAC"].ToString();
txtRemarks.Text = InvGDS.Tables[0].Rows[0]["Remarks"].ToString();
}
}
}