public AdminChildCheckIn() { InitializeComponent(); this.db = new ConnectionsDB(); txt_SearchBox.Focus(); SetupEvents(); }
private void btn_AddChild_Click(object sender, RoutedEventArgs e) { EnableForm(); int maxID = this.db.GetMaxChildID(); ConnectionsDB conDB = new ConnectionsDB(); maxID = maxID + 1; string mID = string.Format("{0:000000}", maxID); Image i; //string test = "C:/Users/Public/Documents"; i = buildImage("C:/Users/Public/Documents" + "/Childcare Application/Pictures/default.jpg", 60); lst_ChildBox.Items.Add(new Child(mID, "First", "Last", i, "2005/01/01", "None", "None", "C:/Users/Public/Documents" + "/Childcare Application/Pictures/default.jpg")); //TAG: pictures access int connID = this.db.GetMaxConnectionID(); connID = connID + 1; string connectionID = string.Format("{0:000000}", connID); string famID = GetFamilyID(ID); this.db.AddNewChild(mID, "First", "Last", "2005-01-01", "None", "None", "C:/Users/Public/Documents" + "/Childcare Application/Pictures/default.jpg"); //TAG: pictures access conDB.UpdateAllowedConnections(connectionID, ID, mID, famID); lst_ChildBox.Items.Clear(); setChildBox(); lst_ChildBox.SelectedItem = lst_ChildBox.Items[lst_ChildBox.Items.Count - 1]; txt_FirstName.Focus(); }
public TransactionCharge(String guardianID, String allowanceID) { this.settings = new GuardianToolsSettings(); this.guardianID = guardianID; this.allowanceID = allowanceID; this.db = new ConnectionsDB(); }
private void btn_Enter_Click(object sender, RoutedEventArgs e) { ConnectionsDB conDB = new ConnectionsDB(); GuardianInfoDB gdb = new GuardianInfoDB(); string fID = "", pID = ""; bool formNotComplete = CheckIfNull(); if (!formNotComplete)//form is completed { bool sameID = CheckIfSame(txt_GuardianID.Text, txt_GuardianID2.Text); bool regexID = RegExpressions.RegexID(txt_GuardianID.Text); if (sameID && regexID)//both IDand PIN are the same vlues { pID = txt_GuardianID.Text; MakeFamilyID(pID); if (linked == 0) //link child { int connID = this.db.GetMaxConnectionID(); connID = connID + 1; string connectionID = string.Format("{0:000000}", connID); fID = MakeFamilyID(pID); bool guardianExists = false; guardianExists = gdb.GuardianNotDeletedAndExists(pID); if (guardianExists) { conDB.UpdateAllowedConnections(connectionID, pID, childID, fID); } else { WPFMessageBox.Show("Guardian with ID: " + pID + " does not exist."); } } else if (linked == 1) //delink child { bool connExists = conDB.ConnectionExists(pID, childID); bool guardianExists = gdb.GuardianNotDeletedAndExists(pID); if (connExists && guardianExists) { conDB.DeleteAllowedConnection(childID, pID); } else { WPFMessageBox.Show("No connection to the Guardian with ID: " + pID + " exists or no Guardian with that ID exists."); } } this.Close(); } } }
private void ReadyTransaction(object sender, RoutedEventArgs e) { TransactionDB transDB = new TransactionDB(); ConnectionsDB conDB = new ConnectionsDB(); ChildInfoDatabase childDB = new ChildInfoDatabase(); GuardianInfoDB parentDB = new GuardianInfoDB(); if (parentDB.GuardianNameExists(txt_GuardianName.Text) && childDB.ChildNameExists(txt_ChildName.Text)) { SetAllowanceID(); this.transaction = new TransactionCharge(conDB.GetGuardianID(allowanceID), allowanceID); CalculateTransaction(sender, e); } }
public ChildLogin(string ID) { InitializeComponent(); this.WindowState = WindowState.Maximized; this.guardianID = ID; this.db = new ConnectionsDB(); SetUpCheckInBox(); SetUpParentDisplay(); EventsSetup(); this.updateTime = new DateTime(); updateTime = DateTime.Now; lbl_Time.DataContext = updateTime; this.lst_CheckInBox.GotFocus += listBoxFocus; this.lst_CheckOutBox.GotFocus += listBoxFocus; this.MouseDown += WindowMouseDown; }
private void LoadGrid() { ConnectionsDB conDB = new ConnectionsDB(); DataTable table = new DataTable(); string[] guardianName = new string[2]; //[first, last] table.Columns.Add("First Name", typeof(string)); table.Columns.Add("Last Name", typeof(string)); table.Columns.Add("Allowance ID", typeof(string)); for (int i = 0; i < this.allowanceIDs.Count; i++) { guardianName = conDB.GetGuardianName(allowanceIDs[i]); table.Rows.Add(guardianName[0], guardianName[1], allowanceIDs[i]); } this.dta_GuardianList.ItemsSource = table.DefaultView; }
private void btn_Delete_Click(object sender, RoutedEventArgs e) { if (lst_ChildBox.SelectedItem != null) { MessageBoxResult messageBoxResult = WPFMessageBox.Show("Are you sure you wish to delete this person?", "Deletion Conformation", MessageBoxButton.YesNo); if (messageBoxResult == MessageBoxResult.Yes) { ConnectionsDB conDB = new ConnectionsDB(); string cID = ((Child)(lst_ChildBox.SelectedItem)).ID; string pID = txt_IDNumber.Text; this.db.DeleteChildInfo(cID); conDB.DeleteAllowedConnection(cID, pID); lst_ChildBox.Items.Clear(); setChildBox(); ClearFields(); } } }
private void LoadData() { ChildInfoDatabase childDB = new ChildInfoDatabase(); TransactionDB transDB = new TransactionDB(); GuardianInfoDB parentDB = new GuardianInfoDB(); ConnectionsDB conDB = new ConnectionsDB(); this.txt_ChildName.Text = childDB.GetChildName(this.transactionID); this.txt_GuardianName.Text = transDB.GetParentNameFromTrans(this.transactionID); this.originalFee = transDB.GetTransactionTotal(this.transactionID); this.txt_TransactionTotal.Text = String.Format("{0:0.00}", transDB.GetTransactionTotal(this.transactionID)); this.originalEventName = transDB.GetTransEventName(this.transactionID); string eventName = this.originalEventName; LoadEventCMB(eventName); this.txt_CheckIn.Text = transDB.GetTwelveHourTime(this.transactionID, "CheckedIn"); this.txt_CheckOut.Text = transDB.GetTwelveHourTime(this.transactionID, "CheckedOut"); this.txt_Date.Text = transDB.GetTransactionDate(this.transactionID); this.transaction = new TransactionCharge(transDB.GetGuardianIDFromTrans(this.transactionID), conDB.GetAllowanceID(this.transactionID)); }
private void SetAllowanceID() { if (this.allowanceID == null || this.txt_GuardianName.Text.CompareTo(guardianName) != 0 || this.txt_ChildName.Text.CompareTo(childName) != 0) { this.guardianName = this.txt_GuardianName.Text; this.childName = this.txt_ChildName.Text; ConnectionsDB conDB = new ConnectionsDB(); List <string> allowanceIDs = conDB.GetAllowanceIDsOnNames(txt_GuardianName.Text, txt_ChildName.Text); if (allowanceIDs.Count > 1) { SelectGuardian selectGuardian = new SelectGuardian(allowanceIDs, this); selectGuardian.ShowDialog(); } else { this.allowanceID = allowanceIDs[0]; } } }
private void lst_Guardians_IndexChange(object sender, System.EventArgs e) { if (dta_GuardianList.SelectedItem != null) { GuardianInfoDB parentDB = new GuardianInfoDB(); ConnectionsDB conDB = new ConnectionsDB(); String allowanceID = ""; DataRowView selectedFile = (DataRowView)dta_GuardianList.SelectedItem; allowanceID = Convert.ToString(selectedFile.Row.ItemArray[2]); this.guardianID = conDB.GetGuardianID(allowanceID); string imageLink = parentDB.GetGuardianImagePath(this.guardianID); if (imageLink != null) { ImageBrush ib = new ImageBrush(); ib.ImageSource = new BitmapImage(new Uri(imageLink, UriKind.Relative)); cnv_GuardianPic.Background = ib; cnv_GuardianPic.Visibility = System.Windows.Visibility.Visible; } } }