/// <summary> Loads User Check Box Labels from UserFields Table
/// </summary>
private void loadUserFieldLabels()
{
UserFields clsUserFields = new UserFields(CCFBGlobal.connectionString);
clsUserFields.open("Volunteers");
clsUserFields.setDataRow("UserFlag0");
if ("UserFlag0" == clsUserFields.FldName)
{
chkUserFlag0.Text = clsUserFields.EditLabel;
chkUserFlag0.Visible = (chkUserFlag0.Text != "");
}
clsUserFields.setDataRow("UserFlag1");
if ("UserFlag1" == clsUserFields.FldName)
{
chkUserFlag1.Text = clsUserFields.EditLabel;
chkUserFlag1.Visible = (chkUserFlag1.Text != "");
}
clsUserFields.setDataRow("Date1");
if ("Date1" == clsUserFields.FldName)
{
lblDate1.Text = clsUserFields.EditLabel;
tbDate1.Visible = (lblDate1.Text != "");
lblDate1.Visible = (lblDate1.Text != "");
}
clsUserFields.setDataRow("Date2");
if ("Date2" == clsUserFields.FldName)
{
lblDate2.Text = clsUserFields.EditLabel;
tbDate2.Visible = (lblDate2.Text != "");
lblDate2.Visible = (lblDate2.Text != "");
}
}
} // end of cboTable_Select_SelectedIndexChanged
/// <summary>
/// Checks the dataset for rows where AutoAlert = true but No text is entered
/// It then puts the edit lable in the AutoAlertText Field
/// </summary>
public void checkForEmptyAlertText()
{
for (int i = 0; i < clsUserFields.RowCount; i++)
{
clsUserFields.setDataRow(i);
if (clsUserFields.AutoAlert == true && clsUserFields.AutoAlertText == "")
{
clsUserFields.AutoAlertText = clsUserFields.EditLabel;
}
}
}
private void loadUserFieldLabels()
{
UserFields clsUserFields = new UserFields(CCFBGlobal.connectionString);
lstbxHHUserFields.Items.Clear();
string fldName = "";
clsUserFields.open("Household");
userFieldList.Clear();
for (int i = 0; i < clsUserFields.RowCount; i++)
{
fldName = "UserFlag" + i.ToString();
clsUserFields.setDataRow(fldName);
if (fldName == clsUserFields.FldName)
{
if (clsUserFields.EditLabel != "")
{
UserFieldItem fieldRow = new UserFieldItem(i, clsUserFields.EditLabel, fldName);
userFieldList.Add(fieldRow);
lstbxHHUserFields.Items.Add(fieldRow.EditLabel);
}
}
}
}