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