public void WriteToFile(String _firstName, String _lastName, String _patronymic, bool _gender, bool _isMother, DateTime _dateOfBirth, DateTime _dateOfEntry, DateTime _dateOfRetirement, String _placeOfLiving1, String _bedProfile, String _department, int _status) { currentId++; DBRecord record = new DBRecord(); record.id = currentId; record.lastName = _lastName; record.firstName = _firstName; record.patronymic = _patronymic; record.gender = _gender; record.isLyingWithParent = _isMother; record.dateOfEntry = _dateOfEntry; record.dateOfBirth = _dateOfBirth; record.dateOfRetirement = _dateOfRetirement; record.placeOfLiving = _placeOfLiving1; record.bedProfile = _bedProfile; record.department = _department; record.status = _status; records.Add(record); String stringToWrite = currentId.ToString() + separator + _lastName + separator + _firstName + separator + _patronymic + separator + _gender + separator + _isMother + separator + _dateOfBirth + separator + _dateOfEntry + separator + _dateOfRetirement + separator + _placeOfLiving1 + separator + _bedProfile + separator + _department + separator + _status; if (!File.Exists(path)) { // Create a file to write to. using (StreamWriter sw = File.AppendText(path + "Database.txt")) { sw.WriteLine(stringToWrite); } } }
private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex == -1 || e.ColumnIndex == -1) { return; } int id = Convert.ToInt32(dataGridView1[0, e.RowIndex].Value); DBRecord record = databaseHandler.FindRecordById(id); if (record == null) { return; } AddRecord addRecord = new AddRecord(false, @"S:\Projects\PatientRegistry\PatientRegistry\", record); var result = addRecord.ShowDialog(); if (result == DialogResult.OK) { databaseHandler.ModifyRegistry(id, addRecord.firstName, addRecord.lastName, addRecord.patronymic, addRecord.gender, addRecord.isMother, addRecord.dateOfBirth, addRecord.dateOfEntry, addRecord.dateOfRetirement, addRecord.placeOfLiving, addRecord.bedProfile, addRecord.department, addRecord.status); databaseHandler.FillDataGridView(); } }
public void ReadAllFromFile() { records.Clear(); String[] lines = System.IO.File.ReadAllLines(path + "Database.txt"); foreach (String s in lines) { String[] str = s.Split(separator); DBRecord record = new DBRecord(); record.id = Convert.ToInt32(str[0]); record.lastName = str[1]; record.firstName = str[2]; record.patronymic = str[3]; record.gender = Convert.ToBoolean(str[4]); record.isLyingWithParent = Convert.ToBoolean(str[5]); record.dateOfBirth = Convert.ToDateTime(str[6]); record.dateOfEntry = Convert.ToDateTime(str[7]); record.dateOfRetirement = Convert.ToDateTime(str[8]); record.placeOfLiving = str[9]; record.bedProfile = str[10]; record.department = str[11]; record.status = Convert.ToInt32(str[12]); TimeSpan time; if (record.dateOfRetirement == DateTime.MinValue) { // time = DateTime.Today - record.dateOfEntry; record.daysWithin = -1; } else { time = record.dateOfRetirement - record.dateOfEntry; record.daysWithin = time.Days - 1; } records.Add(record); } currentId = lines.Length; }
public void ModifyRegistry(int id, String _firstName, String _lastName, String _patronymic, bool _gender, bool _isMother, DateTime _dateOfBirth, DateTime _dateOfEntry, DateTime _dateOfRetirement, String _placeOfLiving1, String _bedProfile, String _department, int _status) { DBRecord record = new DBRecord(); record.id = id; record.lastName = _lastName; record.firstName = _firstName; record.patronymic = _patronymic; record.gender = _gender; record.isLyingWithParent = _isMother; record.dateOfEntry = _dateOfEntry; record.dateOfBirth = _dateOfBirth; record.dateOfRetirement = _dateOfRetirement; record.placeOfLiving = _placeOfLiving1; record.bedProfile = _bedProfile; record.department = _department; record.status = _status; for (int i = 0; i < records.Count; i++) { if (records[i].id == id) { records[i] = record; } } if (!File.Exists(path)) { using (StreamWriter sw = new StreamWriter(path + "Database.txt", false)) { foreach (DBRecord r in records) { String stringToWrite = r.id.ToString() + separator + r.lastName + separator + r.firstName + separator + r.patronymic + separator + r.gender + separator + r.isLyingWithParent + separator + r.dateOfBirth + separator + r.dateOfEntry + separator + r.dateOfRetirement + separator + r.placeOfLiving + separator + r.bedProfile + separator + r.department + separator + r.status; sw.WriteLine(stringToWrite); } } } }
//String _firstName, String _lastName, String _patronymic, bool _gender, bool _isMother, DateTime _dateOfEntry, DateTime _dateOfBirth, String _placeOfLiving1, String _placeOfLiving2, String _bedProfile, String _department public AddRecord(bool _mode, String _path, DBRecord record) { InitializeComponent(); path = _path; mode = _mode; hidingLabel1.Visible = true; statusComboBox.Visible = true; dateOfRetirement = record.dateOfRetirement; statusComboBox.SelectedIndex = record.status; if (record.status == 0) { hidingLabel2.Visible = false; dateTimePicker3.Visible = false; } else { hidingLabel2.Visible = true; dateTimePicker3.Visible = true; dateTimePicker3.Value = record.dateOfRetirement; } comboBox3.AutoCompleteMode = AutoCompleteMode.SuggestAppend; comboBox3.AutoCompleteSource = AutoCompleteSource.CustomSource; comboBox3.DropDownStyle = ComboBoxStyle.DropDown; String[] lines = System.IO.File.ReadAllLines(path + "Cities.txt", System.Text.Encoding.Default); AutoCompleteStringCollection data = new AutoCompleteStringCollection(); foreach (String str in lines) { data.Add(str); comboBox3.Items.Add(str); } lines = System.IO.File.ReadAllLines(path + "Settlements.txt", System.Text.Encoding.Default); foreach (String str in lines) { data.Add(str); comboBox3.Items.Add(str); } comboBox3.AutoCompleteCustomSource = data; textBox1.Text = record.lastName; textBox2.Text = record.firstName; textBox3.Text = record.patronymic; if (record.gender == true) { comboBox1.SelectedIndex = 0; } else { comboBox1.SelectedIndex = 1; } if (record.isLyingWithParent == true) { comboBox2.SelectedIndex = 1; } else { comboBox2.SelectedIndex = 0; } dateTimePicker1.Value = record.dateOfBirth; dateTimePicker2.Value = record.dateOfEntry; comboBox3.SelectedIndex = comboBox3.FindStringExact(record.placeOfLiving); comboBox4.SelectedIndex = comboBox4.FindStringExact(record.bedProfile); comboBox5.SelectedIndex = comboBox5.FindStringExact(record.department); }