private void UpdateChild(Guid childId) { Child child = null; try { child = _membershipManager.GetChild(childId); } catch { } if (child.Members.Any()) { foreach (Member m in child.Members) { UpdateChild(m, child); } } }
void btnSearch_Click(object sender, EventArgs e) { MembershipManager mm = new MembershipManager(); Child child = mm.GetChild(Guid.Parse(ddlChildren.SelectedValue)); _parentInterests = child.Members.FirstOrDefault().Interests.Select(i => Sitecore.Context.Database.GetItem(i.Key)) .Where(i => i != null) .Select(i => i.ID.ToGuid()) .ToList(); string childGrade = string.Empty; var grade = child.Grades.FirstOrDefault(); if (grade != null) { GradeLevelItem gli = Sitecore.Context.Database.GetItem(grade.Key); if (gli != null) { // store value for data bound match _childGuidId = grade.Key; childGrade = gli.Name.Rendered; } } litChild.Text = String.Format("{0} ({1})", child.Nickname, childGrade); var issues = child.Issues.Select(i => Sitecore.Context.Database.GetItem(i.Key)) .Where(i => i != null) .Select(i => new ChildIssueItem(i)); if (issues.Any()) { // store lookup values for data bound match _childIssues = issues.Select(i => i.ID.ToGuid()).ToList(); rptIssues.DataSource = issues; rptIssues.DataBind(); } DateTime specifiedDate = DateTime.Parse(txtDate.Text).Date; var articles = SearchHelper.GetArticles(child.Members.FirstOrDefault(), child, specifiedDate) .Where(i => i.GetItem() != null); if (articles.Any()) { rptArticles.DataSource = articles; rptArticles.DataBind(); } }
protected void btnE1_Click(object sender, EventArgs e) { MembershipManager mm = new MembershipManager(); Member mem = new Member(); BaseReply reply = ExactTargetService.InvokeE1ATurnAroundBullying(new InvokeE1ATurnAroundBullyingRequest { Child = mm.GetChild(new Guid("1DC558DE-8E46-4973-980A-08F582EAE6D5")), ToEmail = tbxSubscriberEmail1.Text, Member = mem, PreferredLanguage = new Guid(ddlLanguages.SelectedValue) }); lblMessage.Text = reply.Message; }
public static void RefreshAndSavePersonalizedContent(Guid childId) { DateTime now = DateTime.Now; Child child = null; MembershipManager mm = new MembershipManager(); try { child = mm.GetChild(childId); } catch { } if (child.Members.Any()) { foreach (Member m in child.Members) { RefreshAndSavePersonalizedContent(m, child); } } }
public static void Main(string[] args) { Console.Title = "YMCA Child Watch Manager"; bool end = false; YMCADataGenerator gen = new YMCADataGenerator(); SqlConnection connection = new SqlConnection(connection_string); MembershipManager membership = new MembershipManager(connection); SignInManager signIn = new SignInManager(connection); while (!end) { Console.Write("YMCA> "); string[] options = Console.ReadLine().Split(' '); try { switch (options[0].ToUpper()) { // Options on members case "MEMBER": switch (options[1]) { case "/s": Member newMember = new Member() { MemberId = options[2], FirstName = options[3], LastName = options[4], Barcode = options[5], Pin = options[6], PhoneNumber = options[7], IsActive = options.Length <= 8 ? true : (options[8] == "0" ? false : true) }; bool res = membership.SaveMember(newMember); Console.WriteLine(String.Format("Member save {0}", res ? "successful" : "failed")); break; case "/g": Member found = null; switch (options.Length) { case 3: found = membership.GetMember(options[2]); break; case 4: found = membership.GetMember(options[2], options[3]); break; } if (found != null) { Console.WriteLine("Member Information:"); Console.WriteLine(found.ToString()); } else { Console.WriteLine("Unable to find member information"); } break; } break; // Options on children case "CHILD": switch (options[1]) { case "/a": // Attach child to member bool attached = membership.AttachChild(options[2], int.Parse(options[3])); Console.WriteLine("Child Attached: " + (attached ? "Completed" : "Failed")); break; case "/d": // Detach child from member bool detached = membership.DetachChild(options[2], int.Parse(options[3])); Console.WriteLine("Child Detached: " + (detached ? "Completed" : "Failed")); break; case "/u": // Update child bool updated = membership.UpdateChild(new Child() { Id = int.Parse(options[2]), FirstName = options[3], LastName = options[4], BirthDate = DateTime.Parse(options[5]) }); Console.WriteLine("Child Updated: " + (updated ? "Completed" : "Failed")); break; case "/i": // Insert Child int id = membership.InsertChild(new Child() { FirstName = options[2], LastName = options[3], BirthDate = DateTime.Parse(options[4]), }, options[5]); if (id >= 1) { Console.WriteLine("Child added with id = " + id.ToString()); } else { Console.WriteLine("Child Insert: Failed"); } break; case "/g": // Get Child Child c = membership.GetChild(int.Parse(options[2])); if (c == null) { Console.WriteLine("Child not found"); } else { Console.WriteLine("Child Information:\n" + c.ToString()); } break; } break; case "CREATEMEMBERS": Console.WriteLine("Member Count: "); int x = int.Parse(Console.ReadLine()); Console.WriteLine("Child Count: "); int y = int.Parse(Console.ReadLine()); Random r = new Random(); int registered = 0; while (x != 0) { try { Child[] child = new Child[0]; Member m = gen.RandomMember(); x--; if (y > 0) { int count = Math.Min(r.Next(6), y); child = new Child[count]; for (int i = 0; i < count; i++) { child[i] = gen.RandomChild(m.LastName); } y = y - count; } Family family = new Family() { Guardian = m, Children = child }; if (membership.RegisterFamily(family)) { registered++; } } catch { } } Console.WriteLine("Registered " + registered + " members and their children"); break; case "CREATESIGNIN": Random random = new Random(); DateTime start = new DateTime(2018, 4, 6, 9, 0, 0); DateTime stop = new DateTime(2018, 4, 6, 21, 0, 0); TimeSpan interval = stop - start; int timefromstart = random.Next((int)interval.TotalMinutes); DateTime signinTime = start.AddMinutes(timefromstart); interval = stop - signinTime; DateTime signoutTime = signinTime.AddMinutes(random.Next((int)interval.TotalMinutes)); Console.WriteLine(signinTime); Console.WriteLine(signoutTime); Family fam = gen.RandomFamily(); Console.WriteLine(fam.Guardian); break; case "CLEAR": Console.Clear(); break; case "EXIT": end = true; break; } } catch (Exception ex) { Console.WriteLine("Error Occurred"); Console.WriteLine(ex.Message); Console.WriteLine("\n" + ex.StackTrace); } } }
public static void Main(string[] args) { Console.Title = "YMCA Child Watch Manager"; DateTime now = DateTime.Now; DateTime start = new DateTime(now.Year, now.Month, now.Day, 9, 0, 0); DateTime stop = new DateTime(now.Year, now.Month, now.Day, 22, 0, 0); bool end = false; YMCADataGenerator gen = new YMCADataGenerator(); SqlConnection connection = new SqlConnection(connection_string); MembershipManager membership = new MembershipManager(connection); SignInManager signIn = new SignInManager(connection); ReportManager reports = new ReportManager(connection); OrganizationManager organization = new OrganizationManager(connection); while (!end) { Console.Write("YMCA> "); string[] options = Console.ReadLine().Split(' '); try { switch (options[0].ToUpper()) { case "LOG": switch (options[1]) { case "/m": try { throw new Exception("Test Exception"); } catch (Exception ex) { log.Write(ex, "YMCAHelpUtility"); } break; } break; // Options on members case "MEMBER": switch (options[1]) { case "/s": Member newMember = new Member() { MemberId = options[2], FirstName = options[3], LastName = options[4], Barcode = options[5], Pin = options[6], PhoneNumber = options[7], IsActive = options.Length <= 8 ? true : (options[8] == "0" ? false : true) }; bool res = membership.SaveMember(newMember); Console.WriteLine(String.Format("Member save {0}", res ? "successful" : "failed")); break; case "/g": Member found = null; switch (options.Length) { case 3: found = membership.GetMember(options[2]); break; case 4: found = membership.GetMember(options[2], options[3]); break; } if (found != null) { Console.WriteLine("Member Information:"); Console.WriteLine(found.ToString()); } else { Console.WriteLine("Unable to find member information"); } break; } break; // Options on children case "CHILD": switch (options[1]) { case "/a": // Attach child to member bool attached = membership.AttachChild(options[2], int.Parse(options[3])); Console.WriteLine("Child Attached: " + (attached ? "Completed" : "Failed")); break; case "/d": // Detach child from member bool detached = membership.DetachChild(options[2], int.Parse(options[3])); Console.WriteLine("Child Detached: " + (detached ? "Completed" : "Failed")); break; case "/u": // Update child bool updated = membership.UpdateChild(new Child() { Id = int.Parse(options[2]), FirstName = options[3], LastName = options[4], BirthDate = DateTime.Parse(options[5]) }); Console.WriteLine("Child Updated: " + (updated ? "Completed" : "Failed")); break; case "/i": // Insert Child int id = membership.InsertChild(new Child() { FirstName = options[2], LastName = options[3], BirthDate = DateTime.Parse(options[4]), }, options[5]); if (id >= 1) { Console.WriteLine("Child added with id = " + id.ToString()); } else { Console.WriteLine("Child Insert: Failed"); } break; case "/g": // Get Child Child c = membership.GetChild(int.Parse(options[2])); if (c == null) { Console.WriteLine("Child not found"); } else { Console.WriteLine("Child Information:\n" + c.ToString()); } break; } break; case "CREATEMEMBERS": Console.WriteLine("Member Count: "); int x = int.Parse(Console.ReadLine()); Console.WriteLine("Child Count: "); int y = int.Parse(Console.ReadLine()); Random r = new Random(); int registered = 0; while (x != 0) { try { List <Child> child = new List <Child>(); Member m = gen.RandomMember(); x--; if (y > 0) { int childs = Math.Min(r.Next(6), y); for (int i = 0; i < childs; i++) { child.Add(gen.RandomChild(m.LastName)); } y = y - childs; } Family family = new Family() { Guardian = m, Children = child }; if (membership.RegisterFamily(family)) { registered++; } } catch (Exception ex) { Console.WriteLine(ex.Message); } } Console.WriteLine("Registered " + registered + " members and their children"); break; case "REPORT": switch (options[1]) { case "/m": var member_report = reports.GetMemberReport(true); Console.WriteLine(member_report.Rows.Count); break; case "/i": var interval_report = reports.GetIntervalReport(60, start, stop, 1); if (interval_report.Rows.Count > 0) { Console.WriteLine("REPORT DATA\n================================================="); } foreach (DataRow i in interval_report.Rows) { DateTime time = (DateTime)i["time"]; Console.WriteLine((time.ToShortTimeString() + " " + time.AddMinutes((int)i["interval"]).ToShortTimeString() + " " + ((int)i["count"]).ToString())); } if (interval_report.Rows.Count > 0) { Console.WriteLine("============================================================\nEND DATA"); } break; } break; case "CREATESIGNIN": Console.WriteLine("Enter number of families"); int families = int.Parse(Console.ReadLine()); int written = 0; Signin[] signins = new Signin[families]; for (int z = 0; z < families; z++) { try { Random random = new Random(); Family fam = gen.RandomFamily(reports); Location[] list = organization.GetLocations(); int count = 0; try { count = random.Next(1, fam.Children.Count - 1); } catch { count = 1; }; List <Assignment> assignments = new List <Assignment>(); for (int i = 0; i < count; i++) { Child c = fam.Children[random.Next(fam.Children.Count)]; Assignment assignment = new Assignment() { Child = c.Id, Location = list[random.Next(list.Length)].Id }; assignments.Add(assignment); } Signin current = signIn.SignIn(fam.Guardian.MemberId, assignments.ToArray()); signins[written] = current; if (current.Band > 0 && !signIn.SignOut(current.Band)) { throw new Exception("Failed sign out or sign in for member " + fam.Guardian.MemberId); } written++; Console.WriteLine(written + ")" + fam.Guardian.MemberId); } catch (Exception ex) { File.AppendAllText("ErrorReport.txt", ex.ToString()); } } Console.WriteLine("Families written: " + written); using (SqlConnection connect = new SqlConnection(connection_string)) { connect.Open(); Random rnd = new Random(); int failed = 0; for (int i = 0; i < signins.Length; i++) { try { if (signins[i] != null) { DateTime signinTime = gen.RandomTimeBetween(start, stop); DateTime signoutTime = gen.RandomTimeBetween(signinTime, stop); using (SqlCommand command = new SqlCommand("p_signin_modify", connect)) { command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@out", signoutTime); command.Parameters.AddWithValue("@in", signinTime); command.Parameters.AddWithValue("@id", signins[i].Id); command.ExecuteNonQuery(); } } } catch (Exception ex) { failed++; Console.WriteLine("Exception: " + ex.Message); } } Console.WriteLine("Failed Update Count: " + failed); connect.Close(); } break; case "CLEAR": Console.Clear(); break; case "EXIT": end = true; break; } } catch (Exception ex) { Console.WriteLine("Error Occurred"); Console.WriteLine(ex.Message); Console.WriteLine("\n" + ex.StackTrace); } } }