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); } }