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) ? "Мужская" : "Женская";
}
