protected void GetClientInfo() { DataClients dC = new DataClients(); DataView dv = dC.GetMemberByMemberID(MemberID); DataTable oDataTable = dv.Table; txtFirstName.Text = oDataTable.Rows[0]["firstName"].ToString(); txtLastName.Text = oDataTable.Rows[0]["lastName"].ToString(); if ((oDataTable.Rows[0]["DOB"] != null) && (oDataTable.Rows[0]["DOB"].ToString().Trim() != "")) { DateTime dt = Convert.ToDateTime(oDataTable.Rows[0]["DOB"]); txtDOB.Text = dt.ToString("MM/dd/yyyy"); } ddSex.SelectedValue = oDataTable.Rows[0]["sex"].ToString(); txtNotes.Text = oDataTable.Rows[0]["Notes"].ToString(); txtAddress.Text = oDataTable.Rows[0]["address1"].ToString(); txtCity.Text = oDataTable.Rows[0]["city"].ToString(); txtPostalCode.Text = oDataTable.Rows[0]["postalCode"].ToString(); txtHomePhone.Text = oDataTable.Rows[0]["homePhone"].ToString(); txtCellPhone.Text = oDataTable.Rows[0]["cellPhone"].ToString(); txtPreContact.Text = oDataTable.Rows[0]["preferredMethodContact"].ToString(); ddMaritalStatus.SelectedValue = oDataTable.Rows[0]["MaritalStatusID"].ToString(); ddChurch.SelectedValue = oDataTable.Rows[0]["ChurchID"].ToString(); txtEmail.Text = oDataTable.Rows[0]["email"].ToString(); string strChurchName = oDataTable.Rows[0]["ChurchID"].ToString(); string strFileName = oDataTable.Rows[0]["PhotoFileName"].ToString(); string strFolder = "~/MemberPhoto/" + strChurchName + "/" + strFileName; Image1.ImageUrl = strFolder; if (!string.IsNullOrWhiteSpace(oDataTable.Rows[0]["FamilyBookNumber"].ToString())) { txtFamilyBookNumber.Text = oDataTable.Rows[0]["FamilyBookNumber"].ToString(); txtFamilyBookNumber.Enabled = false; } else { txtFamilyBookNumber.Text = string.Empty; txtFamilyBookNumber.Enabled = true; } if (!string.IsNullOrWhiteSpace(oDataTable.Rows[0]["FreeToMarry"].ToString())) { DateTime dt = Convert.ToDateTime(oDataTable.Rows[0]["FreeToMarry"]); txtFreeToMarry.Text = dt.ToString("MM/dd/yyyy"); } chkActive.Checked = Convert.ToBoolean(oDataTable.Rows[0]["Active"]); }
protected void GetSelectedMember() { //if (Utilities.IsNumeric(ddClient.SelectedItem.Value)) //{ // int memberID = Convert.ToInt32(ddClient.SelectedItem.Value); // Session["MemberID"] = ddClient.SelectedItem.Value; // DataClients dC = new DataClients(); // DataView dv = dC.GetMemberByMemberID(memberID); // DataTable oDataTable = dv.Table; // grdSelectedMember.DataSource = oDataTable; // grdSelectedMember.DataBind(); // divSelectedMember.Visible = true; // divClientinfo.Visible = false; //} if ((Session["MemberID"] != null) && (Utilities.IsNumeric(Session["MemberID"]))) { int memberID = Convert.ToInt32(Session["MemberID"]); DataClients dC = new DataClients(); DataView dv = dC.GetMemberByMemberID(memberID); DataTable oDataTable = dv.Table; DataRow dr = oDataTable.Rows[0]; lblmemberName.Text = dr["FirstName"].ToString() + " " + dr["LastName"].ToString(); grdSelectedMember.DataSource = oDataTable; grdSelectedMember.DataBind(); SetDivNotVisible(); divSelectedMember.Visible = true; divSelectedMemberAction.Visible = true; divClientinfo.Visible = false; divMembers.Visible = false; GetDependents(); GetDonations(); GetCertificates(); } else { _memberID = 0; Session["MemberID"] = null; divClientinfo.Visible = false; divSelectedMember.Visible = false; divMembers.Visible = true; } }