private void Button_Click_4(object sender, RoutedEventArgs e) // Delete selected student { var selectedIndex = List.SelectedIndex; if (students.studentlist[selectedIndex].isHead == "+") { var rez = students.studentlist[selectedIndex].group; rez.head = null; rez.headName = "-"; } students.studentlist.Remove(students.studentlist[selectedIndex]); NameBox.Clear(); SurnameBox.Clear(); Middlename.Clear(); YearBox.Clear(); FileNameTextBox.Clear(); GroupCombo.SelectedIndex = -1; OldGroupCombo.SelectedIndex = -1; List.Items.Refresh(); mark.marks.Clear(); Table.ItemsSource = mark.marks; Table.Items.Refresh(); AddButton.IsEnabled = true; HeadCheck.IsChecked = false; ChangeButton.IsEnabled = false; DeleteButton.IsEnabled = false; }
private void update_Click(object sender, EventArgs e) { if (Firstname.Text != "" && Lastname.Text != "" && Middlename.Text != "" && bday.Text != "" && Address.Text != "" && Phonenum.Text != "" && Jobposition.Text != "" && Emailadd.Text != "") { sqlcon.Close(); string query = "Update quickpctbl Set Fname ='" + Firstname.Text.Trim() + "', Mname ='" + Middlename.Text.Trim() + "', Lname ='" + Lastname.Text.Trim() + "', Birthday ='" + bday.Text.Trim() + "', Address ='" + Address.Text.Trim() + "', PhoneNumber ='" + Phonenum.Text.Trim() + "', JobPosition ='" + Jobposition.Text.Trim() + "', EmailAddress ='" + Emailadd.Text.Trim() + "' where IdNumber = '" + idnum.Text.Trim() + "'"; SqlDataAdapter sda = new SqlDataAdapter(query, sqlcon); DataTable dtbl = new DataTable(); sda.Fill(dtbl); MessageBox.Show("Successfuly Update!"); } else { MessageBox.Show("Please Input!"); } idnum.Clear(); Firstname.Clear(); Middlename.Clear(); Lastname.Clear(); bday.Text = String.Empty; Address.Clear(); Phonenum.Clear(); Jobposition.Text = String.Empty; Emailadd.Clear(); }
public override void Save() { string SQL = qryEmployeeSave; try { if (!Owner.isCreated) { Owner = Program.UserContext; } SQL = SQL.Replace(":empid", Key.ToString()); SQL = SQL.Replace(":persontitle", "'" + Title.ToString() + "'"); SQL = SQL.Replace(":personname", "'" + Name.ToString() + "'"); SQL = SQL.Replace(":personmiddle", "'" + Middlename.ToString() + "'"); SQL = SQL.Replace(":personlastname", "'" + Surname.ToString() + "'"); SQL = SQL.Replace(":_phone", Phone.ToString() == "" ? "null" : "'" + Phone.ToString() + "'"); SQL = SQL.Replace(":city", "'" + City.ToString() + "'"); SQL = SQL.Replace(":country", "'" + Country.ToString() + "'"); SQL = SQL.Replace(":region", "'" + Region.ToString() + "'"); SQL = SQL.Replace(":district", "'" + District.ToString() + "'"); SQL = SQL.Replace(":_address", "'" + Address.ToString() + "'"); SQL = SQL.Replace(":postalcode", "'" + PostalCode.ToString() + "'"); SQL = SQL.Replace(":dateborn", "'" + Birthday.ToString() + "'"); SQL = SQL.Replace(":_email", "'" + Email.ToString() + "'"); SQL = SQL.Replace(":rcomment", "'" + RComment.ToString() + "'"); SQL = SQL.Replace(":ownerid", isCreated ? Owner.Key : Program.UserContext.Key); SQL = SQL.Replace(":locked", Locked ? "1" : "0"); SQL = SQL.Replace(":username", "'" + UserName.ToString() + "'"); SQL = SQL.Replace(":userpassword", "'" + Encryption.Encode(UserPassword.ToString(), Program.PasswordKey) + "'"); Client.ExecuteSQLCommit(SQL); Owner.Load(); MainForm.toolStripStatusOwner.Text = Owner.Title; isChanged = false; isCreated = true; Program.EmployeesAreChanged = true; Program.RefreshEmployee(this); } catch (Exception e) { MessageBox.Show(e.Message + "\n"); } }
private void Button_Click_6(object sender, RoutedEventArgs e) { NameBox.Clear(); SurnameBox.Clear(); Middlename.Clear(); YearBox.Clear(); GroupCombo.SelectedIndex = -1; OldGroupCombo.SelectedIndex = -1; FileNameTextBox.Clear(); mark.marks.Clear(); Table.ItemsSource = mark.marks; Table.Items.Refresh(); AddButton.IsEnabled = true; HeadCheck.IsChecked = false; ChangeButton.IsEnabled = false; DeleteButton.IsEnabled = false; }
protected override IQueryable <Player> FilterImpl(IQueryable <Player> resources) { var result = resources; if (!string.IsNullOrEmpty(Firstname)) { result = resources.Where(p => p.Firstname.ToLower().Contains(Firstname.ToLower())); } if (!string.IsNullOrEmpty(Middlename)) { result = resources.Where(p => p.OtherNames.ToLower().Contains(Middlename.ToLower())); } if (!string.IsNullOrEmpty(Lastname)) { result = resources.Where(p => p.LastName.ToLower().Contains(Lastname.ToLower())); } return(result); }
private void newaccount_Click(object sender, EventArgs e) { if (Firstname.Text != "" && Lastname.Text != "" && Middlename.Text != "" && bday.Text != "" && Address.Text != "" && Phonenum.Text != "" && Jobposition.Text != "" && Emailadd.Text != "") { string query = "Insert into quickpctbl VALUES('" + idnum.Text.Trim() + "','" + Firstname.Text.Trim() + "','" + Middlename.Text.Trim() + "','" + Lastname.Text.Trim() + "','" + bday.Text.Trim() + "','" + Address.Text.Trim() + "','" + Phonenum.Text.Trim() + "','" + Jobposition.Text.Trim() + "','" + Emailadd.Text.Trim() + "')"; SqlDataAdapter sda = new SqlDataAdapter(query, sqlcon); DataTable dtbl = new DataTable(); sda.Fill(dtbl); MessageBox.Show("Successfuly Added!"); idnum.Clear(); Firstname.Clear(); Middlename.Clear(); Lastname.Clear(); bday.Text = String.Empty; Address.Clear(); Phonenum.Clear(); Jobposition.Text = String.Empty; Emailadd.Clear(); } else { MessageBox.Show("Please Input!"); } }
/// <summary> /// Method overriding ToString() /// </summary> /// <returns>String</returns> public override string ToString() { return("Страховой полис:\n\t\t" + base.ToString() + "\tОтчество: " + Middlename.ToString() + "\tПол: " + Sex + "\tДата рождения: " + DateOfBirth.ToShortDateString() + "\tСтраховой номер: " + InsuranceNumber); }
private void MenuItem_Click_1(object sender, RoutedEventArgs e) { GroupEnum new_groups = new GroupEnum(); StudentEnum new_students = new StudentEnum(); OpenFileDialog dialog = new OpenFileDialog(); dialog.DefaultExt = ".zip"; dialog.Filter = "zip|*.zip"; string selectedArchive = ""; bool? result = dialog.ShowDialog(); if (result == true) { selectedArchive = dialog.FileName; } else { return; } try { if (!Directory.Exists(Directory.GetCurrentDirectory() + @"\Buffer") && selectedArchive != "") { ZipFile.ExtractToDirectory(selectedArchive, Directory.GetCurrentDirectory()); } else { return; } } catch (Exception) { MessageBox.Show("Please, select another folder ", "Error", MessageBoxButton.OK, MessageBoxImage.Error); return; } FileStream connector = new FileStream(Directory.GetCurrentDirectory() + @"\Buffer\Temp.txt", FileMode.Open);; StreamReader reader = new StreamReader(connector); int groupsNumber = Convert.ToInt32(reader.ReadLine()); reader.ReadLine(); for (int i = 0; i < groupsNumber; i++) { reader.ReadLine(); Group new_group = new Group(); new_group.Number = Convert.ToInt32(reader.ReadLine()); new_group.Actual = reader.ReadLine(); new_group.headName = reader.ReadLine(); int teachersNumber = Convert.ToInt32(reader.ReadLine()); Group subject = new Group(); if (teachersNumber != 0) { reader.ReadLine(); for (int j = 0; j < teachersNumber; j++) { Group.struct_teachers new_teacher = new Group.struct_teachers(); new_teacher.Name = reader.ReadLine(); new_teacher.Subject = reader.ReadLine(); subject.teachers.Add(new_teacher); } reader.ReadLine(); new_group.teachers = new List <Group.struct_teachers>(subject.teachers); } else { reader.ReadLine(); } reader.ReadLine(); new_groups.groupList.Add(new_group); } reader.ReadLine(); int studentsNumber = Convert.ToInt32(reader.ReadLine()); reader.ReadLine(); for (int i = 0; i < studentsNumber; i++) { reader.ReadLine(); Student new_student = new Student(); new_student.Name = reader.ReadLine(); new_student.Surname = reader.ReadLine(); new_student.Middlename = reader.ReadLine(); new_student.Year = Convert.ToInt32(reader.ReadLine()); new_student.isHead = reader.ReadLine(); new_student.groupHeading = reader.ReadLine(); new_student.group_number = reader.ReadLine(); new_student.old_group_number = reader.ReadLine(); new_student.photoPath = reader.ReadLine(); if (new_student.photoPath != "") { BitmapImage StudentPhoto = new BitmapImage(); StudentPhoto.BeginInit(); StudentPhoto.UriSource = new Uri(new_student.photoPath, UriKind.Absolute); StudentPhoto.CacheOption = BitmapCacheOption.OnLoad; StudentPhoto.EndInit(); new_student.studentPhoto = StudentPhoto; } int marksNumber = Convert.ToInt32(reader.ReadLine()); Student mark = new Student(); if (marksNumber != 0) { reader.ReadLine(); for (int j = 0; j < marksNumber; j++) { Student.struct_marks new_mark = new Student.struct_marks(); new_mark.Mark = Convert.ToInt32(reader.ReadLine()); new_mark.Subject = reader.ReadLine(); mark.marks.Add(new_mark); } reader.ReadLine(); new_student.marks = new List <Student.struct_marks>(mark.marks); } else { reader.ReadLine(); } reader.ReadLine(); new_students.studentlist.Add(new_student); } for (int i = 0; i < new_groups.groupList.Count(); i++) { for (int j = 0; j < new_students.studentlist.Count(); j++) { if (new_students.studentlist[j].group_number == Convert.ToString(new_groups.groupList[i].Number)) { new_students.studentlist[j].group = new_groups.groupList[i]; if (new_students.studentlist[j].groupHeading == Convert.ToString(new_groups.groupList[i].Number)) { new_groups.groupList[i].head = new_students.studentlist[j]; } } if (new_students.studentlist[j].old_group_number == Convert.ToString(new_groups.groupList[i].Number)) { new_students.studentlist[j].oldGroup = new_groups.groupList[i]; } } } reader.Close(); connector.Close(); groups.groupList = new_groups.groupList; students.studentlist = new_students.studentlist; List.ItemsSource = students.studentlist; List.Items.Refresh(); mark.marks.Clear(); Table.ItemsSource = mark.marks; Table.Items.Refresh(); NameBox.Clear(); SurnameBox.Clear(); Middlename.Clear(); YearBox.Clear(); GroupCombo.SelectedIndex = -1; OldGroupCombo.SelectedIndex = -1; HeadCheck.IsChecked = false; FileNameTextBox.Text = ""; if (Directory.Exists(Directory.GetCurrentDirectory() + @"\Buffer")) { Directory.Delete(Directory.GetCurrentDirectory() + @"\Buffer", true); } MessageBox.Show("File loaded", "", MessageBoxButton.OK, MessageBoxImage.Information); }
private void Button_Click_3(object sender, RoutedEventArgs e) // Change information { if (String.IsNullOrWhiteSpace(NameBox.Text) || String.IsNullOrWhiteSpace(SurnameBox.Text) || String.IsNullOrWhiteSpace(Middlename.Text) || String.IsNullOrWhiteSpace(YearBox.Text)) { MessageBox.Show("Please, fill all fields", "Error", MessageBoxButton.OK, MessageBoxImage.Error); return; } if (NameBox.Text.Length > 16 || SurnameBox.Text.Length > 16 || Middlename.Text.Length > 16) { MessageBox.Show("Name, Surname and Middlename must not contain more than 16 letters ", "Error", MessageBoxButton.OK, MessageBoxImage.Error); return; } if (Convert.ToInt32(YearBox.Text) > 2017 || Convert.ToInt32(YearBox.Text) < 1950) { MessageBox.Show("In the year selection field number should be between 1950 to 2017", "Error", MessageBoxButton.OK, MessageBoxImage.Error); YearBox.Clear(); return; } if (GroupCombo.SelectedItem != null && GroupCombo.SelectedItem == OldGroupCombo.SelectedItem) { MessageBox.Show("Old group and current group must be different", "Error", MessageBoxButton.OK, MessageBoxImage.Error); GroupCombo.SelectedItem = null; OldGroupCombo.SelectedItem = null; return; } var selectedIndex = List.SelectedIndex; students.studentlist[selectedIndex].Name = NameBox.Text; students.studentlist[selectedIndex].Surname = SurnameBox.Text; students.studentlist[selectedIndex].Middlename = Middlename.Text; students.studentlist[selectedIndex].Year = Convert.ToInt32(YearBox.Text); if (GroupCombo.SelectedItem == null) { students.studentlist[selectedIndex].group_number = "-"; students.studentlist[selectedIndex].groupHeading = "-"; students.studentlist[selectedIndex].isHead = "-"; students.studentlist[selectedIndex].group = null; } else { students.studentlist[selectedIndex].group_number = GroupCombo.Text; var rez = (Group)GroupCombo.SelectedItem; if (HeadCheck.IsChecked == true) { if (students.studentlist[selectedIndex].groupHeading != Convert.ToString(rez.Number)) { if (rez != students.studentlist[selectedIndex].group) { if (students.studentlist[selectedIndex].isHead == "+") { var rez1 = students.studentlist[selectedIndex].group; rez1.headName = "-"; rez1.head = null; } } if (rez.head == null) { students.studentlist[selectedIndex].isHead = "+"; students.studentlist[selectedIndex].group_number = Convert.ToString(rez.Number); students.studentlist[selectedIndex].groupHeading = students.studentlist[selectedIndex].group_number; students.studentlist[selectedIndex].group = rez; rez.headName = students.studentlist[selectedIndex].Surname + " " + students.studentlist[selectedIndex].Name; rez.head = students.studentlist[selectedIndex]; } else { students.studentlist[selectedIndex].group_number = Convert.ToString(rez.Number); students.studentlist[selectedIndex].isHead = "-"; students.studentlist[selectedIndex].groupHeading = "-"; students.studentlist[selectedIndex].group = rez; MessageBox.Show("This group already has a head. This student was not appointed head", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning); } } else { rez.headName = students.studentlist[selectedIndex].Surname + " " + students.studentlist[selectedIndex].Name; } } else { if (rez.head == students.studentlist[selectedIndex]) { rez.head = null; rez.headName = "-"; } students.studentlist[selectedIndex].isHead = "-"; students.studentlist[selectedIndex].groupHeading = "-"; } students.studentlist[selectedIndex].group = (Group)GroupCombo.SelectedItem; } if (students.studentlist[selectedIndex].isHead == "+") { students.studentlist[selectedIndex].groupHeading = students.studentlist[selectedIndex].group_number; } else { students.studentlist[selectedIndex].groupHeading = "-"; } if (OldGroupCombo.SelectedItem == null) { students.studentlist[selectedIndex].old_group_number = "-"; } else { students.studentlist[selectedIndex].old_group_number = OldGroupCombo.Text; } students.studentlist[selectedIndex].oldGroup = (Group)OldGroupCombo.SelectedItem; if (students.studentlist[selectedIndex].studentPhoto != null) { if ("file:///" + FileNameTextBox.Text != Convert.ToString(students.studentlist[selectedIndex].studentPhoto.UriSource)) { if (FileNameTextBox.Text != "") { BitmapImage StudentPhoto = new BitmapImage(); StudentPhoto.BeginInit(); StudentPhoto.UriSource = new Uri(FileNameTextBox.Text, UriKind.Absolute); StudentPhoto.CacheOption = BitmapCacheOption.OnLoad; StudentPhoto.EndInit(); students.studentlist[selectedIndex].studentPhoto = StudentPhoto; students.studentlist[selectedIndex].photoPath = Convert.ToString(students.studentlist[selectedIndex].studentPhoto.UriSource); } } } students.studentlist[selectedIndex].marks = new List <Student.struct_marks>(mark.marks); List.Items.Refresh(); NameBox.Clear(); SurnameBox.Clear(); Middlename.Clear(); YearBox.Clear(); FileNameTextBox.Clear(); GroupCombo.SelectedIndex = -1; OldGroupCombo.SelectedIndex = -1; mark.marks.Clear(); Table.ItemsSource = mark.marks; Table.Items.Refresh(); AddButton.IsEnabled = true; HeadCheck.IsChecked = false; ChangeButton.IsEnabled = false; DeleteButton.IsEnabled = false; }
private void AddPatientRecord() { if (!VerifyRequiredFields()) { return; } DateTime dateOfBirth = (DateTime)DOB; SQLiteConnection connection = OpenConnection("Patients"); string cmdString = ""; if (string.IsNullOrWhiteSpace(Middlename)) { cmdString = @"SELECT COUNT(*) FROM PatientData WHERE Firstname = @firstname" + " AND Lastname = @lastname AND DOB = @dob AND Gender = @gender AND ST_Number = @streetNumber AND Postcode = @postcode"; } else { cmdString = @"SELECT COUNT(*) FROM PatientData WHERE Firstname = @firstname AND Middlename = @middlename " + " AND Lastname = @lastname AND DOB = @dob AND Gender = @gender AND ST_Number = @streetNumber AND Postcode = @postcode"; } SQLiteCommand cmd = new SQLiteCommand(cmdString, connection); cmd.Prepare(); cmd.Parameters.Add("@firstname", DbType.String).Value = Firstname.ToLower(new System.Globalization.CultureInfo("en-UK", false)); if (!string.IsNullOrWhiteSpace(Middlename)) { cmd.Parameters.Add("@middlename", DbType.String).Value = Middlename.ToLower(new System.Globalization.CultureInfo("en-UK", false)); } cmd.Parameters.Add("@lastname", DbType.String).Value = Lastname.ToLower(new System.Globalization.CultureInfo("en-UK", false)); cmd.Parameters.Add("@dob", DbType.String).Value = dateOfBirth.ToString("dd/MM/yyyy"); cmd.Parameters.Add("@gender", DbType.String).Value = Gender; cmd.Parameters.Add("@streetNumber", DbType.String).Value = AddressNo; cmd.Parameters.Add("@postcode", DbType.String).Value = Postcode.Replace(" ", "").ToUpper(); // Checks if record already exists, if it does a prompt is shown to the user, // user decides if duplicate record is required. int recordsFound = Convert.ToInt32(cmd.ExecuteScalar()); if (recordsFound > 0) { string createDuplicate = Confirmation("Are you sure?", "Patient Record with identical information already exists. Are you sure you want to create another record with this data?"); if (createDuplicate != "Yes") { return; } } // Record added to patient database. if (string.IsNullOrWhiteSpace(Middlename)) { cmdString = @"INSERT INTO PatientData (Firstname, Lastname, DOB, Gender, ST_Number, Postcode) VALUES (@firstname, @lastname, @dob, @gender, @streetNumber, @postcode)"; } else { cmdString = @"INSERT INTO PatientData (Firstname, Middlename, Lastname, DOB, Gender, ST_Number, Postcode) VALUES (@firstname, @middlename, @lastname, @dob, @gender, @streetNumber, @postcode)"; } cmd = new SQLiteCommand(cmdString, connection); cmd.Prepare(); cmd.Parameters.Add("@firstname", DbType.String).Value = Firstname.ToLower(new System.Globalization.CultureInfo("en-UK", false)); if (!string.IsNullOrEmpty(Middlename)) { cmd.Parameters.Add("@middlename", DbType.String).Value = Middlename.ToLower(new System.Globalization.CultureInfo("en-UK", false)); } cmd.Parameters.Add("@lastname", DbType.String).Value = Lastname.ToLower(new System.Globalization.CultureInfo("en-UK", false)); cmd.Parameters.Add("@dob", DbType.String).Value = dateOfBirth.ToString("dd/MM/yyyy"); cmd.Parameters.Add("@gender", DbType.String).Value = Gender; cmd.Parameters.Add("@streetNumber", DbType.String).Value = AddressNo; cmd.Parameters.Add("@postcode", DbType.String).Value = Postcode.Replace(" ", "").ToUpper(); cmd.ExecuteNonQuery(); Success("Success", "Record created. You can now proceed to create an appointment."); connection.Close(); }
/// <summary>Parse accepts an XmlNode and parses values</summary> public void Parse(XmlNode xNode) { XmlNode xResultNode = null; string strTmp = null; try { xResultNode = xNode.SelectSingleNode(TAG_USER_ID); strTmp = xResultNode.InnerText; UserID = (long)Convert.ToInt32(strTmp); } catch { } try { xResultNode = xNode.SelectSingleNode(TAG_USER_ROLE_ID); UserRoleID = (long)Convert.ToInt32(xResultNode.InnerText); } catch { UserRoleID = 0; } try { xResultNode = xNode.SelectSingleNode(TAG_BEGIN_DATE_CREATED); BeginDateCreated = DateTime.Parse(xResultNode.InnerText); } catch { } try { xResultNode = xNode.SelectSingleNode(TAG_END_DATE_CREATED); EndDateCreated = DateTime.Parse(xResultNode.InnerText); } catch { } try { xResultNode = xNode.SelectSingleNode(TAG_BEGIN_DATE_MODIFIED); BeginDateModified = DateTime.Parse(xResultNode.InnerText); } catch { } try { xResultNode = xNode.SelectSingleNode(TAG_END_DATE_MODIFIED); EndDateModified = DateTime.Parse(xResultNode.InnerText); } catch { } try { xResultNode = xNode.SelectSingleNode(TAG_FIRSTNAME); Firstname = xResultNode.InnerText; if (Firstname.Trim().Length == 0) { Firstname = null; } } catch { Firstname = null; } try { xResultNode = xNode.SelectSingleNode(TAG_MIDDLENAME); Middlename = xResultNode.InnerText; if (Middlename.Trim().Length == 0) { Middlename = null; } } catch { Middlename = null; } try { xResultNode = xNode.SelectSingleNode(TAG_LASTNAME); Lastname = xResultNode.InnerText; if (Lastname.Trim().Length == 0) { Lastname = null; } } catch { Lastname = null; } try { xResultNode = xNode.SelectSingleNode(TAG_USERNAME); Username = xResultNode.InnerText; if (Username.Trim().Length == 0) { Username = null; } } catch { Username = null; } try { xResultNode = xNode.SelectSingleNode(TAG_PASSWD); Passwd = xResultNode.InnerText; if (Passwd.Trim().Length == 0) { Passwd = null; } } catch { Passwd = null; } try { xResultNode = xNode.SelectSingleNode(TAG_PICTURE_URL); PictureUrl = xResultNode.InnerText; if (PictureUrl.Trim().Length == 0) { PictureUrl = null; } } catch { PictureUrl = null; } // Cannot reliably convert a byte[] to a string. try { xResultNode = xNode.SelectSingleNode(TAG_IS_DISABLED); IsDisabled = Convert.ToBoolean(xResultNode.InnerText); } catch { IsDisabled = false; } try { xResultNode = xNode.SelectSingleNode(TAG_BEGIN_LAST_LOGIN_DATE); BeginLastLoginDate = DateTime.Parse(xResultNode.InnerText); } catch { } try { xResultNode = xNode.SelectSingleNode(TAG_END_LAST_LOGIN_DATE); EndLastLoginDate = DateTime.Parse(xResultNode.InnerText); } catch { } }