public ShowRecordForm(int id) { this.id = id; InitializeComponent(); Model.AmbulatorRecord record = PostgresConnector.GetRecord(id); Model.AmbulatorCard card = PostgresConnector.GetAmbulatorCard(record.ToCard); Breeder.Text = card.Breeder; Adress.Text = card.Address; Phone.Text = card.Phone; KindOfAnimal.Text = card.KindOfAnimal; Breed.Text = card.Breed; PetName.Text = card.PetName; DateTime birth = card.DateOfBirth; Birth.Text = birth.ToLongDateString(); TimeSpan AgeSpan = DateTime.Now - birth; Age.Text = String.Format("{0} лет {1} месяцев {2} дней", AgeSpan.Days / 365, (AgeSpan.Days % 365) / 30, (AgeSpan.Days % 365) % 30); IsMale.Text = (card.IsMale) ? "Мужская" : "Женская"; Visit.Text = record.DateVisit.ToString(); PayBox.Text = record.Payment.ToString(); Anamnesis.Text = record.anamnesis; Clinic.Text = record.assignments; Epicrisis.Text = record.epicrisis; Debt.Text = record.Debt.ToString(); }
private void AddRecBtn_Click(object sender, EventArgs e) { var form = new NewRecordForm((int)dataGridView1.SelectedRows[0].Cells[0].Value); form.ShowDialog(); PostgresConnector.FirstInitialize(ref dataSet); }
private void toolStripButton1_Click_1(object sender, EventArgs e) { var form = new NewCardForm(); form.ShowDialog(); if (form.DialogResult == DialogResult.OK) { dataSet = new DataSet(); PostgresConnector.FirstInitialize(ref dataSet); } }
private void EnterRecord_Click(object sender, EventArgs e) { Model.AmbulatorRecord value = new Model.AmbulatorRecord(); value.ToCard = id; value.DateVisit = DateTime.Now; value.Payment = Int32.Parse(PayBox.Text); value.assignments = Clinic.Text; value.anamnesis = Anamnesis.Text; value.epicrisis = Epicrisis.Text; value.Debt = (int)Debt.Value; PostgresConnector.InsertRecord(id, value); DialogResult = DialogResult.OK; Close(); }
public MainWindow() { PostgresConnector.FirstInitialize(ref dataSet); InitializeComponent(); dataGridView1.DataSource = dataSet.Tables["Амбулаторные карты"].DefaultView; foreach (DataGridViewColumn column in dataGridView1.Columns) { column.SortMode = DataGridViewColumnSortMode.NotSortable; } dataGridView2.DataSource = dataSet.Tables["Амбулаторные записи"].DefaultView; foreach (DataGridViewColumn column in dataGridView2.Columns) { column.SortMode = DataGridViewColumnSortMode.NotSortable; } }
private void ApplyFilter_Click(object sender, EventArgs e) { string query = "Select id, breeder, address, phone, kindofanimal, breed, petname, dateofbirth, gender, dateoffirst From clientbase"; Dictionary <string, object> addToQuery = new Dictionary <string, object>(); if (this.NumFilter.Value != 0) { addToQuery.Add("id", NumFilter.Value); } if (this.PhoneFilter.Text != "") { addToQuery.Add("phone", PhoneFilter.Text); } if (FIOFilter.Text != "") { addToQuery.Add("breeder", FIOFilter.Text); } if (PetFilter.Text != "") { addToQuery.Add("petname", PetFilter.Text); } if (addToQuery.Count != 0) { query += " where "; } int i = 1; foreach (KeyValuePair <string, object> row in addToQuery) { if (row.Key == "id") { query += string.Format("{0} = {1}", row.Key, row.Value); } else { query += string.Format("{0} LIKE '%{1}%'", row.Key, row.Value.ToString()); } if (i != addToQuery.Count) { i++; query += " OR "; } } query += ";"; dataGridView1.DataSource = PostgresConnector.SelectCard(query); }
private void DeleteRecBtn_Click(object sender, EventArgs e) { int record = (int)dataGridView2.SelectedRows[0].Cells[0].Value; var result = MessageBox.Show(String.Format("Вы действительно хотите удалить запись №{0}?", record), "Внимание", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { var form = new Password(); form.ShowDialog(); if (form.DialogResult == DialogResult.OK) { PostgresConnector.DeleteRecord(record); } } PostgresConnector.FirstInitialize(ref dataSet); dataGridView2.Refresh(); }
public NewRecordForm(int id) { this.id = id; InitializeComponent(); Model.AmbulatorCard card = PostgresConnector.GetAmbulatorCard(id); Breeder.Text = card.Breeder; Adress.Text = card.Address; Phone.Text = card.Phone; KindOfAnimal.Text = card.KindOfAnimal; Breed.Text = card.Breed; PetName.Text = card.PetName; DateTime birth = card.DateOfBirth; Birth.Text = birth.ToLongDateString(); TimeSpan AgeSpan = DateTime.Now - birth; Age.Text = String.Format("{0} лет {1} месяцев {2} дней", AgeSpan.Days / 365, (AgeSpan.Days % 365) / 30, (AgeSpan.Days % 365) % 30); IsMale.Text = (card.IsMale) ? "Мужская" : "Женская"; }
private void Add_Click(object sender, EventArgs e) { value.Breeder = BreedName.Text; value.Address = String.Format("{0}, улица {1}, дом {2}, квартира {3}", this.City.Text, this.Street.Text, this.Home.Text, this.Room.Text); value.Phone = Telephone.Text; value.Breed = BreedName.Text; value.KindOfAnimal = TypeAnimal.Text; if (DontHaveBD.Checked) { value.DateOfBirth = Model.AmbulatorCard.getBirthFromString(years.Value, months.Value, days.Value); } else { value.DateOfBirth = dateTimePicker2.Value; } value.PetName = NamePet.Text; PostgresConnector.InsertCard(value); this.DialogResult = DialogResult.OK; Close(); }
public ShowCardForm(int id) { this.id = id; InitializeComponent(); Model.AmbulatorCard model = PostgresConnector.GetAmbulatorCard(id); DataTable records = PostgresConnector.GetRecordsForCard(id); BaseGrid.DataSource = records; BreederLabel.Text = model.Breeder; AddressLabel.Text = model.Address; NumLabel.Text = model.Phone; KindOfAnimal.Text = model.KindOfAnimal; Breed.Text = model.Breed; PetName.Text = model.PetName; DateTime birth = model.DateOfBirth; Birth.Text = birth.ToLongDateString(); TimeSpan AgeSpan = DateTime.Now - birth; Age.Text = String.Format("{0} лет {1} месяцев {2} дней", AgeSpan.Days / 365, (AgeSpan.Days % 365) / 30, (AgeSpan.Days % 365) % 30); IsMale.Text = (model.IsMale) ? "Мужская" : "Женская"; }