private void saveExtraCard()
{
DataRow[] search;
int retVal = 0;
try
{
search = _ExtraCards.Select("Deleted = True");
if (search.Length > 0)
{
ErrorLogger.Log(string.Format("{0} Cards to Delete", search.Length.ToString()), null, false);
MembershipTableAdapters.MembersTableAdapter daExtra = new PFGA_Membership.MembershipTableAdapters.MembersTableAdapter();
foreach (DataRow row in search)
{
retVal = daExtra.DeleteQuery(int.Parse(row["ID"].ToString()));
ErrorLogger.Log(string.Format("{0} Extra Cards deleted", retVal), null, false);
}
}
}
catch (Exception ex)
{
ErrorLogger.Log("Error saving extra card", ex, true);
}
}
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);
}
private static void OnRowUpdated(object sender, SqlRowUpdatedEventArgs e)
{
try
{
// Conditionally execute this code block on inserts only.
if (e.StatementType == StatementType.Insert)
{
MembershipTableAdapters.MembersTableAdapter mbr = new PFGA_Membership.MembershipTableAdapters.MembersTableAdapter();
SqlConnection conn = mbr.Connection;
conn.Open();
SqlCommand cmdNewID = new SqlCommand("SELECT Max(ID) + 1 FROM Members", conn);
// Retrieve the Autonumber and store it in the CategoryID column.
e.Row["ID"] = (int)cmdNewID.ExecuteScalar();
e.Status = UpdateStatus.SkipCurrentRow;
conn.Close();
}
}
catch (Exception ex)
{
ErrorLogger.Log("Error retrieving the newly added ID number", ex, true);
}
}
