private void PopulateFamily(string strFamilyID)
{
DataAccess da = new DataAccess();
DataTable dtFamilyInfo = new DataTable();
dtFamilyInfo = da.GetFamilyBasicInfo(Convert.ToInt32(strFamilyID));
foreach (DataRow dr in dtFamilyInfo.Rows)
{
txtLastNames.Text = DataHelper.GetString(dr["FamilyLastNames"]);
txtFamilyPhone.Text = DataHelper.GetString(dr["Phone"]);
txtStreet.Text = DataHelper.GetString(dr["Street_Address"]);
txtTown.Text = DataHelper.GetString(dr["Town"]);
txtState.Text = DataHelper.GetString(dr["State"]);
txtZip.Text = DataHelper.GetString(dr["ZipCode"]);
txtCountry.Text = DataHelper.GetString(dr["Country"]);
string strActive = DataHelper.GetString(dr["isActive"]);
if (String.IsNullOrEmpty(strActive) || Convert.ToBoolean(strActive) == true)
{
rdoActive.Checked = true;
}
else
{
rdoInActive.Checked = true;
}
}
}
public static bool UpdateChurchMember(string strPersonid, string lastName, string firstName, string middleInitial, string gender, string DOB, string homePhone, string cellPhone, string businessPhone, string Email, string Fellowship,
string bChristain, string bCharterMember, string bShowinDirectory, string bActive)
{
bool isUpdateSucceeded = false;
DataAccess da = new DataAccess();
// now update the Target Volume
isUpdateSucceeded = da.UpdateChurchMember(Convert.ToInt32(strPersonid), lastName, firstName, middleInitial, gender, DOB, homePhone, cellPhone, businessPhone, Email, Fellowship,
bChristain.Trim().ToLower() == "true" ? 1 : 0, bCharterMember.Trim().ToLower() == "true" ? 1 : 0, bShowinDirectory.Trim().ToLower() == "true" ? 1 : 0, bActive.Trim().ToLower() == "true" ? 1 : 0);
return isUpdateSucceeded;
}
protected void btnUpdateFamily_Click(object sender, EventArgs e)
{
szFamilyID = Request.QueryString["FamilyID"].ToString();
int intFamilyID = Convert.ToInt32(szFamilyID);
DataAccess da = new DataAccess();
// now update the family entry
bool isUpdateFamilySucceeded = false;
int isActive = 1;
if (rdoInActive.Checked)
{
isActive = 0;
}
isUpdateFamilySucceeded = da.UpdateFaimlyInfo(intFamilyID, txtLastNames.Text.ToString(), txtStreet.Text.ToString(), txtTown.Text.ToString(),
txtState.Text.ToString(), txtZip.Text.ToString(), txtCountry.Text.ToString(), txtFamilyPhone.Text.ToString(), isActive);
}
private void populateMemberInfo()
{
string strFamilyID = Request.QueryString["FamilyID"].ToString();
string strHomePhone = Request.QueryString["homePhone"].ToString();
string strMemberTable = Request.QueryString["MemberTable"].ToString();
da = new DataAccess();
string strFellowship = da.GetFellowshipName(Convert.ToInt32( strFamilyID));
// now get member details
if (strMemberTable == "A")
{
txtHomePhone.Text = strHomePhone;
txtFellowship.Text = strFellowship;
}
else
{
tdBusinessPhone.Visible = false;
tdCellPhone.Visible = false;
tdHomePhone.Visible = false;
tdFellowship.Visible = false;
tdPhone.Visible = true;
}
rdoActive.Checked = true;
rdoChristainNo.Checked = true;
rdoCharterMemberNo.Checked = true;
rdoShowinDirectoryYes.Checked = true;
}
private void PopulateGrid()
{
DataTable dtListMember = new DataTable();
da = new DataAccess();
try
{
if (Request.QueryString["MemberStatus"] != null)
{
string strMemberStatus = String.Empty;
strMemberStatus = Request.QueryString["MemberStatus"].ToString().ToLower().Trim();
dtListMember = da.GetMemberList(strMemberStatus);
}
}
catch (Exception ex)
{
}
reportRepeater.DataSource = dtListMember;
reportRepeater.DataBind();
// select distinct Convert(VARCHAR(50), RunID) from dbo.reportmapping
}
private void PopulateGrid()
{
DataTable dtListFamily = new DataTable();
da = new DataAccess();
try
{
if (Request.QueryString["FamilyID"] != null)
{
string strFamilyID = String.Empty;
strFamilyID = Request.QueryString["FamilyID"].ToString().ToLower().Trim();
dtListFamily = da.GetFamilyMemberList(Convert.ToInt32(strFamilyID));
}
}
catch (Exception ex)
{
}
reportRepeater.DataSource = dtListFamily;
reportRepeater.DataBind();
// select distinct Convert(VARCHAR(50), RunID) from dbo.reportmapping
}
private void populateMemberInfo()
{
string strFamilyID = Request.QueryString["FamilyID"].ToString();
strPersonID = Request.QueryString["PersonID"].ToString();
string strMemberTable = Request.QueryString["MemberTable"].ToString();
da = new DataAccess();
// now get member details
DataTable dtMemberDetails = da.GetMemberDetails(Convert.ToInt32(strFamilyID), Convert.ToInt32(strPersonID), strMemberTable);
foreach (DataRow dr in dtMemberDetails.Rows)
{
txtLastName.Text = DataHelper.GetString(dr["Last_Name"]);
txtFirstName.Text = DataHelper.GetString(dr["First_Name"]);
txtMiddleInitial.Text = DataHelper.GetString(dr["MiddlelInitial"]);
txtGender.Text = DataHelper.GetString(dr["Sex"]);
txtDOB.Text = DataHelper.GetDateTime(dr["DOB"]).ToString();
if (strMemberTable == "A")
{
txtHomePhone.Text = DataHelper.GetString(dr["Home_Phone"]);
txtCellPhone.Text = DataHelper.GetString(dr["Cell_Phone"]);
txtBusinessPhone.Text = DataHelper.GetString(dr["Business_Phone"]);
txtFellowship.Text = DataHelper.GetString(dr["Fellowship"]);
}
else
{
txtPhone.Text = DataHelper.GetString(dr["Phone"]);
tdBusinessPhone.Visible = false;
tdCellPhone.Visible = false;
tdHomePhone.Visible = false;
tdFellowship.Visible = false;
tdPhone.Visible = true;
}
TxtEmail.Text = DataHelper.GetString(dr["Email"]);
string strActive = DataHelper.GetString(dr["isActive"]);
if (String.IsNullOrEmpty(strActive) || Convert.ToBoolean(strActive) == true)
{
rdoActive.Checked = true;
}
else
{
rdoInActive.Checked = true;
}
string strChristian = DataHelper.GetString(dr["isChristian"]);
if (String.IsNullOrEmpty(strChristian) || Convert.ToBoolean(strChristian) == true)
{
rdoChristainYes.Checked = true;
}
else
{
rdoChristainNo.Checked = true;
}
string strChartMember = DataHelper.GetString(dr["isChartMember"]);
if (String.IsNullOrEmpty(strChartMember) || Convert.ToBoolean(strChartMember) == true)
{
rdoCharterMemberYes.Checked = true;
}
else
{
rdoCharterMemberNo.Checked = true;
}
string strShowInDirectory = DataHelper.GetString(dr["isShowInDirectory"]);
if (String.IsNullOrEmpty(strShowInDirectory) || Convert.ToBoolean(strShowInDirectory) == true)
{
rdoShowinDirectoryYes.Checked = true;
}
else
{
rdoShowinDirectoryNo.Checked = true;
}
break;
}
}
