using System; using System.Collections; using System.Configuration; using System.Data; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml; using System.Data.SqlClient; using System.Data.SqlTypes; using System.IO; public partial class EditMemberProfile : System.Web.UI.Page { SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["connect"].ConnectionString); DataSet ds = new DataSet(); DataTable dt = null; SqlDataAdapter da = null; SqlCommand cmd=null; FillDD objFillDD = new FillDD(); Dashboard objDash = new Dashboard(); string key; string path1, file1, query,id; string em, nm, mob, ddlddt, ddlmt, att, ch1, ch2, ddc1, ddc2, ddm1, ddm2; protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { Get_MemberData(); } } private void Get_MemberData() { string type1, stat, State1; try { if (con.State != ConnectionState.Open) { con.Open(); } cmd = new SqlCommand("Select * from RCBK_Member Where MemberId=" + Session["MemberId1"] + "", con); SqlDataReader dr; dr = cmd.ExecuteReader(); if (dr.Read()) { try { txtFName.Text = dr["M_FirstName"].ToString().Trim(); txtLName.Text = dr["M_LastName"].ToString().Trim(); type1 = dr["M_Type"].ToString().Trim(); txtMobile.Text = dr["M_MobileNo"].ToString().Trim(); txtPEmail.Text = dr["M_PrimaryEmailId"].ToString().Trim(); txtAEmail.Text = dr["M_AlternateEmailId"].ToString().Trim(); txtPassword.Text = dr["Password"].ToString().Trim(); string[] ADate = dr["AnniversaryDate"].ToString().Split('-'); ddAdate.SelectedItem.Text = ADate[0].ToString(); ddAMonth.SelectedItem.Text = ADate[1].ToString(); //txtDob.Text = Convert.ToDateTime(dr["M_Dob"]).ToString("dd/MM/yyyy"); Image1.ImageUrl = "Member_Photo/"+dr["MemberPhoto"].ToString(); string spimage = dr["SpousePhoto"].ToString(); if (spimage != "") { if (spimage == "blank.jpg") { image.Visible = false; Image2.Visible = false; } else { image.Visible = true; Image2.ImageUrl = "Spouse_Photo/" + dr["SpousePhoto"].ToString(); } } else if (spimage == "") { image.Visible = false; Image2.Visible = false; } string[] MDob = dr["M_Dob"].ToString().Split('-'); ddDate.SelectedItem.Text = MDob[0].ToString(); ddMonth.SelectedItem.Text = MDob[1].ToString(); stat = dr["Status"].ToString().Trim(); //State1 = dr["State"].ToString().Trim(); dplState.SelectedItem.Text = dr["State"].ToString().Trim(); txtAddress.Text = dr["Address"].ToString().Trim(); txtCity.Text = dr["City"].ToString().Trim(); txtPCode.Text = dr["Pincode"].ToString().Trim(); //txtSDob.Text = Convert.ToDateTime(dr["SpouseDob"]).ToString("dd/MM/yyyy"); string[] SDob = dr["SpouseDob"].ToString().Split('-'); ddSdate.SelectedItem.Text = SDob[0].ToString(); ddSMonth.SelectedItem.Text = SDob[1].ToString(); //ddSdate.SelectedItem.Text = dr["SpouseDob"].ToString().Trim(); //ddSMonth.SelectedItem.Text = dr["SpouseDob"].ToString().Trim(); txtSEmail.Text = dr["SpouseEmailId"].ToString().Trim(); txtSMobile.Text = dr["SpouseMobileNo"].ToString().Trim(); txtSName.Text = dr["SpouseName"].ToString().Trim(); //txtCdate1.Text = Convert.ToDateTime(dr["ChildDob1"]).ToString("dd/MM/yyyy"); //txtCDate2.Text = Convert.ToDateTime(dr["ChildDob2"]).ToString("dd/MM/yyyy"); string[] CDob1 = dr["ChildDob1"].ToString().Split('-'); ddCdate1.SelectedItem.Text = CDob1[0].ToString(); ddCMonth1.SelectedItem.Text = CDob1[1].ToString(); //ddCdate1.SelectedItem.Text = dr["ChildDob1"].ToString().Trim(); //ddCMonth1.SelectedItem.Text = dr["ChildDob1"].ToString().Trim(); string[] CDob2 = dr["ChildDob2"].ToString().Split('-'); ddCdate2.SelectedItem.Text = CDob2[0].ToString(); ddCMonth2.SelectedItem.Text = CDob2[1].ToString(); //ddCdate2.SelectedItem.Text = dr["ChildDob2"].ToString().Trim(); //ddCMonth2.SelectedItem.Text = dr["ChildDob2"].ToString().Trim(); txtCName1.Text = dr["ChildName1"].ToString().Trim(); txtCName2.Text = dr["ChildName2"].ToString().Trim(); //objFillDD.Get_DDSelectByText(ref dplState, State1); objFillDD.Get_DDSelectByText(ref DDType, type1); //tblUpdate.Visible = true; } catch (Exception ex) { lblErr.Text = "Alert! : " + ex.Message; } } else { lblErr.Text = "Alert: MemberId Invalid : No Data in Database"; //tblUpdate.Visible = false; } } catch (Exception ex) { lblErr.Text = "Alert! : " + ex.Message; } finally { con.Close(); } } private void Update_Member() { try { cmd = new SqlCommand("SpUpdateMember", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@MemberId", Session["MemberId1"])); cmd.Parameters.Add(new SqlParameter("@FName ", txtFName.Text)); cmd.Parameters.Add(new SqlParameter("@LName ", txtLName.Text)); cmd.Parameters.Add(new SqlParameter("@Type", DDType.SelectedItem.Text)); cmd.Parameters.Add(new SqlParameter("@Mobile ", txtMobile.Text)); cmd.Parameters.Add(new SqlParameter("@PEmail", txtPEmail.Text)); cmd.Parameters.Add(new SqlParameter("@AEmail", txtAEmail.Text)); cmd.Parameters.Add(new SqlParameter("@Pass", txtPassword.Text)); cmd.Parameters.Add(new SqlParameter("@Address", txtAddress.Text)); cmd.Parameters.Add(new SqlParameter("@State", dplState.SelectedItem.Text)); cmd.Parameters.Add(new SqlParameter("@City", txtCity.Text)); cmd.Parameters.Add(new SqlParameter("@PCode", txtPCode.Text)); cmd.Parameters.Add(new SqlParameter("@MDob", ddDate.SelectedItem.Text + "-" + ddMonth.SelectedItem.Text)); cmd.Parameters.Add(new SqlParameter("@ADate", ddAdate.SelectedItem.Text + "-" + ddAMonth.SelectedItem.Text)); cmd.Parameters.Add(new SqlParameter("@SName", nm)); cmd.Parameters.Add(new SqlParameter("@SMobile", mob)); cmd.Parameters.Add(new SqlParameter("@SEmail", em)); cmd.Parameters.Add(new SqlParameter("@SDob", ddlddt + "-" + ddlmt)); cmd.Parameters.Add(new SqlParameter("@ChildName1", ch1)); cmd.Parameters.Add(new SqlParameter("@ChildDob1", ddc1 + "-" + ddm1)); cmd.Parameters.Add(new SqlParameter("@ChildName2", ch2)); cmd.Parameters.Add(new SqlParameter("@ChildDob2", ddc2 + "-" + ddm2)); //cmd.Parameters.Add(new SqlParameter("@Status", ddc2 + "-" + ddm2)); con.Open(); cmd.ExecuteNonQuery(); if (AttachMember.PostedFile.FileName != "") { con.Close(); file(); } lblErr.Text = "Data Updated Successfully"; } catch (Exception exp) { lblErr.Text = "Update Alert : " + exp.Message; } finally { if (con.State == ConnectionState.Open) { con.Close(); } } } protected void btnUpdate_Click(object sender, EventArgs e) { if (txtSEmail.Text == "") { em = ""; } else if (txtSEmail.Text != "") { em = txtSEmail.Text; } if (txtSMobile.Text == "") { mob = ""; } else if (txtSMobile.Text != "") { mob = txtSMobile.Text; } if (txtSName.Text != "") { nm = txtSName.Text; } if (txtSName.Text == "") { nm = ""; } if (ddSdate.SelectedItem.Text == "Date") { ddlddt = ""; } else if (ddSdate.SelectedItem.Text != "Date") { ddlddt = ddSdate.SelectedItem.Text; } if (ddSMonth.SelectedItem.Text == "Month") { ddlmt = ""; } else if (ddSMonth.SelectedItem.Text != "Month") { ddlmt = ddSMonth.SelectedItem.Text; } if (AttachSpouse.PostedFile.FileName != "") { att = ""; } if (AttachSpouse.PostedFile.FileName == "") { file(); } if (txtCName1.Text == "") { ch1 = ""; } else if (txtCName1.Text != "") { ch1 = txtCName1.Text; } if (txtCName2.Text == "") { ch2 = ""; } else if (txtCName2.Text != "") { ch2 = txtCName2.Text; } if (ddCMonth1.SelectedItem.Text == "Month") { ddm1 = ""; } else if (ddCMonth1.SelectedItem.Text != "Month") { ddm1 = ddCMonth1.SelectedItem.Text; } if (ddCMonth2.SelectedItem.Text == "Month") { ddm2 = ""; } else if (ddCMonth2.SelectedItem.Text != "Month") { ddm2 = ddCMonth2.SelectedItem.Text; } if (ddCdate1.SelectedItem.Text == "Date") { ddc1 = ""; } else if (ddCdate1.SelectedItem.Text != "Date") { ddc1 = ddCdate1.SelectedItem.Text; } if (ddCdate2.SelectedItem.Text == "Date") { ddc2 = ""; } else if (ddCdate2.SelectedItem.Text!= "Date") { ddc2 = ddCdate2.SelectedItem.Text; } Update_Member(); } void file() { path1 = System.IO.Path.GetFileName(AttachMember.PostedFile.FileName); file1 = AttachMember.FileName; fetch_identity(); string fname = id + Path.GetExtension(file1); AttachMember.PostedFile.SaveAs(Server.MapPath("Member_Photo/") + fname); path1 = Server.MapPath("Member_Photo/") + fname; query = "update RCBK_Member set MemberPhoto='" + fname + "' where MemberId='" + id + "'"; try { con.Open(); cmd = new SqlCommand(query, con); cmd.ExecuteNonQuery(); } catch (Exception ex) { } finally { con.Close(); } } void fetch_identity() { query = "select ident_current('RCBK_Member')"; dt = new DataTable(); da = new SqlDataAdapter(query, con); da.Fill(dt); id = dt.Rows[0][0].ToString(); } }