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