private void EditFamilyBtn_Click(object sender, EventArgs e)
{
int rowNum = NotOnWardList.CurrentCell.RowIndex;
DataRow dr = WardList.dtNotOnWardList.Rows[rowNum];
Add_Family addFamilyForm = new Add_Family(dr);
addFamilyForm.MyParentForm = this;
if (addFamilyForm.ShowDialog() == DialogResult.OK)
{
//add edited info to table then save file
if (WardList.dtNotOnWardList.Rows.Count !=0)
{
WardList.dtNotOnWardList.Rows[rowNum]["lastName"]= addFamilyForm.lastName;
WardList.dtNotOnWardList.Rows[rowNum]["hoh1"] = addFamilyForm.hoh1;
WardList.dtNotOnWardList.Rows[rowNum]["hoh2"] = addFamilyForm.hoh2;
WardList.dtNotOnWardList.Rows[rowNum]["address"] = addFamilyForm.address;
WardList.dtNotOnWardList.Rows[rowNum]["status"] = addFamilyForm.status;
// Do I need to use an update command to make the table current ???
//save file
WardList.saveNotOnWardListToFile();
}
}
}
private void AddFamilyBtn_Click(object sender, EventArgs e)
{
Add_Family addFamilyForm = new Add_Family();
addFamilyForm.MyParentForm = this;
if (addFamilyForm.ShowDialog() == DialogResult.OK)
{
//add info to table then save file
//add new row to data table for this family
DataRow dr = WardList.dtNotOnWardList.NewRow(); //dr gets all columns of dt
//Last Name
dr["lastName"] = addFamilyForm.lastName;
//hoh1
dr["hoh1"] = addFamilyForm.hoh1;
//hoh2
dr["hoh2"] = addFamilyForm.hoh2;
//address
dr["address"] = addFamilyForm.address;
//status
dr["status"] = addFamilyForm.status;
//add row to table
WardList.dtNotOnWardList.Rows.Add(dr);
string tmpStr = WardList.dtNotOnWardList.Rows.Count.ToString();
lblNumFamsNotOnList.Text = "Number of Families: " + tmpStr;
//save file
WardList.saveNotOnWardListToFile();
}
}
public string[] matchPropertyToNames(string[] stringsToFind)
{
string[] returnStrings = new string[MAX_NUM_MATCHED_NAMES_RETURNED];
int i = 0;
string address;
//DataRow currentRow = dtOnWardList.NewRow();
//DataColumn dc = new DataColumn dtOnWardList.Columns["address"];
//DataColumn dc = dtOnWardList.Columns["address"];
//initialize return string
for (i = 0; i < MAX_NUM_MATCHED_NAMES_RETURNED; i++)
{
returnStrings[i] = "";
}
//format the search strings
for (i = 0; i < stringsToFind.Length; i++)
{
stringsToFind[i] = stringsToFind[i].Replace(" ", "").ToLower();
}
i = 0;
//search dtOnWardList
foreach (DataRow dr in dtOnWardList.Rows)
{
address = dr["address"].ToString().Replace(" ", "").ToLower();
if (address.Contains(stringsToFind[0])
&& address.Contains(stringsToFind[1]))
{
//found a match
if (i < MAX_NUM_MATCHED_NAMES_RETURNED)
{
returnStrings[i++] = dr["lastName"].ToString();
}
}
}
//search dtNotOnWardList
//get status values from the addFamilyForm
Add_Family addFamilyForm = new Add_Family();
foreach (DataRow dr in dtNotOnWardList.Rows)
{
address = dr["address"].ToString().Replace(" ","").ToLower();
if(address.Contains(stringsToFind[0])
&& address.Contains(stringsToFind[1]))
{
//found a match
if(i < MAX_NUM_MATCHED_NAMES_RETURNED)
{
if (dr["status"].ToString() == addFamilyForm.statusValues[0])
{
returnStrings[i++] = "*" + dr["lastName"].ToString();
}
else if(dr["status"].ToString() == addFamilyForm.statusValues[1])
{
returnStrings[i++] = "~" + dr["lastName"].ToString();
}
}
}
}
addFamilyForm.Close();
return returnStrings;
}