private DataTable getExtraCards()
{
DataTable retVal = new DataTable();
try
{
MembershipTableAdapters.MembersTableAdapter daMember = new PFGA_Membership.MembershipTableAdapters.MembersTableAdapter();
Membership.MembersDataTable dtMember = new Membership.MembersDataTable();
DataColumn dcID = new DataColumn("ID", System.Type.GetType("System.Int32"));
DataColumn dcName = new DataColumn("Name", System.Type.GetType("System.String"));
DataColumn dcDeleted = new DataColumn("Deleted", System.Type.GetType("System.Boolean"));
DataColumn dcPromote = new DataColumn("Promote", System.Type.GetType("System.Boolean"));
DataRow dr;
retVal.Columns.Add(dcID);
retVal.Columns.Add(dcName);
retVal.Columns.Add(dcDeleted);
retVal.Columns.Add(dcPromote);
DataView dvMember;
daMember.Fill(dtMember);
dvMember = new DataView(dtMember);
dvMember.RowFilter = String.Format("MasterRecord = {0}", ID);
foreach (DataRowView row in dvMember)
{
dr = retVal.NewRow();
dr[dcID] = int.Parse(row["ID"].ToString());
dr[dcName] = String.Format("{0}, {1}", row["Last Name"].ToString(), row["First Name"].ToString());
dr[dcDeleted] = false;
dr[dcPromote] = false;
retVal.Rows.Add(dr);
}
}
catch (Exception ex)
{
ErrorLogger.Log("Error getting Extra Cards", ex, true);
}
return(retVal);
}
private void UpdateWalk(DataGridViewCellEventArgs e)
{
try
{
int ID = Int32.Parse(dgMemberList.Rows[e.RowIndex].Cells[dgMemberList.Columns["colID"].Index].Value.ToString());
MembershipTableAdapters.MembersTableAdapter da = new PFGA_Membership.MembershipTableAdapters.MembersTableAdapter();
Membership.MembersDataTable dt = new Membership.MembersDataTable();
da.Fill(dt);
dt.Rows.Find(ID)["Walk"] = "Done";
da.Update(dt);
dgMemberList.Rows[e.RowIndex].Cells[dgMemberList.Columns["colWalk"].Index].Value = "Done";
}
catch (Exception ex)
{
ErrorLogger.Log("Error in UpdateWalk", ex, true);
}
reFormatGrid(e.RowIndex);
}
