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();
}
public static Model.AmbulatorRecord GetRecord(int id)
{
connector.Open();
Model.AmbulatorRecord value = new Model.AmbulatorRecord(id);
QueryString = string.Format("SELECT * FROM recordincard WHERE idbase={0}", id);
NpgsqlCommand Command = new NpgsqlCommand(QueryString, connector);
NpgsqlDataReader myDataReader = Command.ExecuteReader();
while (myDataReader.Read())
{
value.DateVisit = (DateTime)(myDataReader["dateofvisit"]);
value.anamnesis = myDataReader["anamnesis"].ToString().Trim();
value.assignments = myDataReader["assignment"].ToString().Trim();
value.epicrisis = myDataReader["epicrisis"].ToString().Trim();
value.Payment = (int)myDataReader["payment"];
value.ToCard = (int)myDataReader["tocard"];
if (myDataReader["debt"].ToString() == "")
{
value.Debt = 0;
}
else
{
value.Debt = (int)myDataReader["debt"];
}
}
myDataReader.Close();
connector.Close();
return(value);
}
public PrintForm(int id)
{
this.id = id;
InitializeComponent();
Model.AmbulatorRecord record = PostgresConnector.GetRecord(id);
Model.AmbulatorCard card = PostgresConnector.GetAmbulatorCard(record.ToCard);
DateOfVisit.Text = record.DateVisit.ToString();
Assignment.Text = record.assignments;
Clinic.Text = record.anamnesis;
Diagnosis.Text = record.epicrisis;
Breeder.Text = card.Breeder;
TypeAnimal.Text = card.KindOfAnimal;
Breed.Text = card.Breed;
PetName.Text = card.PetName;
DateTime birth = card.DateOfBirth;
if (birth == new DateTime(1812, 1, 1))
{
DateOfBirth.Text = "Неизвестно";
}
else
{
DateOfBirth.Text = birth.ToLongDateString();
}
IsMale.Text = (card.IsMale) ? "Мужская" : "Женская";
}
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 static int InsertRecord(int card, Model.AmbulatorRecord value)
{
connector.Open();
QueryString = "INSERT INTO recordincard (tocard, dateofvisit, anamnesis, assignment, epicrisis, payment, debt) " +
"VALUES(@ToCard, @DateOfVisit, @Anamnesis, @Clinic, @Epicrisis, @Pay, @Debt);";
NpgsqlCommand Command = new NpgsqlCommand(QueryString, connector);
Command.Parameters.Add("@ToCard", NpgsqlTypes.NpgsqlDbType.Integer).Value = card;
Command.Parameters.Add("@Pay", NpgsqlTypes.NpgsqlDbType.Integer).Value = value.Payment;
Command.Parameters.Add("@DateOfVisit", NpgsqlTypes.NpgsqlDbType.Timestamp).Value = value.DateVisit;
Command.Parameters.Add("@Anamnesis", NpgsqlTypes.NpgsqlDbType.Text).Value = value.anamnesis;
Command.Parameters.Add("@Clinic", NpgsqlTypes.NpgsqlDbType.Text).Value = value.assignments;
Command.Parameters.Add("@Epicrisis", NpgsqlTypes.NpgsqlDbType.Text).Value = value.epicrisis;
Command.Parameters.Add("@Debt", NpgsqlTypes.NpgsqlDbType.Integer).Value = value.Debt;
Command.ExecuteNonQuery();
connector.Close();
return(1);
}
public static int UpdateRecord(Model.AmbulatorRecord value, int record)
{
Model.AmbulatorRecord oldValue = GetRecord(record);
if (oldValue == value)
{
return(2);
}
connector.Open();
QueryString = string.Format("UPDATE recordincard SET dateofvisit=@DateOfVisit, payment=@Pay, anamnesis=@Anamnesis, assignment=@Clinic, epicrisis=@Epicrisis, debt=@Debt WHERE idbase={0}", record);
NpgsqlCommand Command = new NpgsqlCommand(QueryString, connector);
Command.Parameters.Add("@Pay", NpgsqlTypes.NpgsqlDbType.Integer).Value = value.Payment;
Command.Parameters.Add("@DateOfVisit", NpgsqlTypes.NpgsqlDbType.Timestamp).Value = value.DateVisit;
Command.Parameters.Add("@Anamnesis", NpgsqlTypes.NpgsqlDbType.Text).Value = value.anamnesis;
Command.Parameters.Add("@Clinic", NpgsqlTypes.NpgsqlDbType.Text).Value = value.assignments;
Command.Parameters.Add("@Epicrisis", NpgsqlTypes.NpgsqlDbType.Text).Value = value.epicrisis;
Command.Parameters.Add("@Debt", NpgsqlDbType.Integer).Value = value.Debt;
Command.ExecuteNonQuery();
connector.Close();
return(1);
}
