Esempio n. 1
0
        private void PrescriptionsButtonDelete_Click(object sender, EventArgs e)
        {
            DeletePrescriptions deletePrescriptions = new DeletePrescriptions();
            DialogResult        status = deletePrescriptions.ShowDialog();

            if (status == DialogResult.OK)
            {
                query = Commands.DeletePrescriptions(Models.Prescriptions.id1, Models.Prescriptions.id2, Models.Prescriptions.patientName);
                MessageBox.Show(query);
                int count;

                if (connectionType == ConnectionTypes.Connected)
                {
                    ConnectedData.SetCommand(query);
                    count = ConnectedData.UpdateData();
                }
                else
                {
                    count = DisconnectedData.DeleteData(query);
                }

                MessageBox.Show("Удалено: " + count.ToString());
                PrescriptionsPrint(SortTypes.IdAsc);
            }
        }
Esempio n. 2
0
        private void StorehouseFButtonEdit_Click(object sender, EventArgs e)
        {
            UpdateStorehouseFields updateStorehouseFields = new UpdateStorehouseFields(connectionType);
            DialogResult           status = updateStorehouseFields.ShowDialog();

            if (status == DialogResult.OK)
            {
                query = Commands.UpdateStorehouseF(Models.StorehouseField.id1, Models.StorehouseField.Quantity,
                                                   Models.StorehouseField.Critical_quantity, Models.StorehouseField.StorehouseRequestsId,
                                                   Models.StorehouseField.ManufactureDate, Models.StorehouseField.ShelfLife);
                MessageBox.Show(query);
                int count;
                if (connectionType == ConnectionTypes.Connected)
                {
                    ConnectedData.SetCommand(query);
                    count = ConnectedData.UpdateData();
                }
                else
                {
                    count = DisconnectedData.UpdateData(query);
                }
                MessageBox.Show("Обновлено: " + count.ToString());
                StorehouseFPrint(SortTypes.IdAsc);
            }
        }
Esempio n. 3
0
        private void MedicationButtonEdit_Click(object sender, EventArgs e)
        {
            UpdateMedications updateMedications = new UpdateMedications(connectionType);
            DialogResult      status            = updateMedications.ShowDialog();

            if (status == DialogResult.OK)
            {
                query = Commands.UpdateMedications(Models.Medications.id1, Models.Medications.Name, Models.Medications.Price, Models.Medications.Quantity,
                                                   Models.Medications.Volume, Models.Medications.MedicationType, Models.Medications.UsesType, Models.Medications.ManufactureType,
                                                   Models.Medications.MixableList, Models.Medications.PreparationTime, Models.Medications.FiltrationTime);
                MessageBox.Show(query);
                int count;

                if (connectionType == ConnectionTypes.Connected)
                {
                    ConnectedData.SetCommand(query);
                    count = ConnectedData.UpdateData();
                }
                else
                {
                    count = DisconnectedData.UpdateData(query);
                }

                MessageBox.Show("Обновлено: " + count.ToString());
                MedicationsPrint(SortTypes.IdAsc);
            }
        }
Esempio n. 4
0
        private void StorehouseFButtonDelete_Click(object sender, EventArgs e)
        {
            DeleteStorehouseFields deleteStorehouseFields = new DeleteStorehouseFields();
            DialogResult           status = deleteStorehouseFields.ShowDialog();

            if (status == DialogResult.OK)
            {
                query = Commands.DeleteStorehouseF(Models.StorehouseField.id1, Models.StorehouseField.id2, Models.StorehouseField.MedicationsName);
                MessageBox.Show(query);
                int count;
                if (connectionType == ConnectionTypes.Connected)
                {
                    ConnectedData.SetCommand(query);
                    count = ConnectedData.UpdateData();
                }
                else
                {
                    count = DisconnectedData.DeleteData(query);
                }

                MessageBox.Show("Удалено: " + count.ToString());
                StorehouseFPrint(SortTypes.IdAsc);
            }
        }
Esempio n. 5
0
        private void PrescriptionsButtonEdit_Click(object sender, EventArgs e)
        {
            UpdatePrescriptions updatePrescriptions = new UpdatePrescriptions(connectionType);
            DialogResult        status = updatePrescriptions.ShowDialog();

            if (status == DialogResult.OK)
            {
                query = Commands.UpdatePrescriptions(Models.Prescriptions.id1, Models.Prescriptions.doctorName,
                                                     Models.Prescriptions.doctorSignature, Models.Prescriptions.doctorStamp,
                                                     Models.Prescriptions.patientId);
                int count;
                MessageBox.Show(query);

                if (connectionType == ConnectionTypes.Connected)
                {
                    ConnectedData.SetCommand(query);
                    count = ConnectedData.UpdateData();
                    MessageBox.Show("Обновлено основ: " + count.ToString());
                    PrescriptionsPrint(SortTypes.IdAsc);

                    query = Commands.DeleteDiagnosesPrescriptions(Models.Prescriptions.id1);
                    MessageBox.Show(query);
                    ConnectedData.SetCommand(query);
                    count = ConnectedData.UpdateData();
                    MessageBox.Show("Удалено диагнозов: " + count.ToString());
                    PrescriptionsPrint(SortTypes.IdAsc);

                    query = Commands.DeletePrescriptionsMedications(Models.Prescriptions.id1);
                    MessageBox.Show(query);
                    ConnectedData.SetCommand(query);
                    count = ConnectedData.UpdateData();
                    MessageBox.Show("Удалено лекарств: " + count.ToString());
                    PrescriptionsPrint(SortTypes.IdAsc);

                    query = Commands.InsertDiagnosesPrescriptions(Models.Prescriptions.diagnosesId, Models.Prescriptions.id1);
                    MessageBox.Show("3\n" + query);
                    ConnectedData.SetCommand(query);
                    count = ConnectedData.UpdateData();
                    MessageBox.Show("Добавлено диагнозов: " + count.ToString());

                    query = Commands.InsertPrescriptionsMedications(Models.Prescriptions.medicationsId, Models.Prescriptions.id1);
                    MessageBox.Show("4\n" + query);
                    ConnectedData.SetCommand(query);
                    count = ConnectedData.UpdateData();
                    MessageBox.Show("Добавлено лекарств: " + count.ToString());
                }

                else
                {
                    count = DisconnectedData.UpdateData(query);
                    MessageBox.Show("Обновлено основ: " + count.ToString());
                    PrescriptionsPrint(SortTypes.IdAsc);

                    query = Commands.DeleteDiagnosesPrescriptions(Models.Prescriptions.id1);
                    MessageBox.Show(query);

                    count = DisconnectedData.DeleteData(query);
                    MessageBox.Show("Удалено диагнозов: " + count.ToString());
                    PrescriptionsPrint(SortTypes.IdAsc);

                    query = Commands.DeletePrescriptionsMedications(Models.Prescriptions.id1);
                    MessageBox.Show(query);

                    count = DisconnectedData.DeleteData(query);
                    MessageBox.Show("Удалено лекарств: " + count.ToString());
                    PrescriptionsPrint(SortTypes.IdAsc);

                    query = Commands.InsertDiagnosesPrescriptions(Models.Prescriptions.diagnosesId, Models.Prescriptions.id1);
                    MessageBox.Show("3\n" + query);

                    count = DisconnectedData.InsertData(query);
                    MessageBox.Show("Добавлено диагнозов: " + count.ToString());

                    query = Commands.InsertPrescriptionsMedications(Models.Prescriptions.medicationsId, Models.Prescriptions.id1);
                    MessageBox.Show("4\n" + query);
                    count = DisconnectedData.InsertData(query);
                    MessageBox.Show("Добавлено лекарств: " + count.ToString());
                }


                PrescriptionsPrint(SortTypes.IdAsc);
            }
        }
Esempio n. 6
0
        private void PrescriptionsButtonAdd_Click(object sender, EventArgs e)
        {
            AddPrescriptions addPrescriptions = new AddPrescriptions(connectionType);
            DialogResult     status           = addPrescriptions.ShowDialog();

            if (status == DialogResult.OK)
            {
                query = Commands.InsertPrescriptions(Models.Prescriptions.doctorName,
                                                     Models.Prescriptions.doctorSignature, Models.Prescriptions.doctorStamp,
                                                     Models.Prescriptions.patientId);

                int count;

                if (connectionType == ConnectionTypes.Connected)
                {
                    MessageBox.Show("1\n" + query);
                    ConnectedData.SetCommand(query);
                    count = ConnectedData.UpdateData();
                    MessageBox.Show("Добавлено: " + count.ToString());

                    string[] data = new string[1];
                    query = Commands.SelectLastId("dbo.prescriptions");
                    MessageBox.Show("2\n" + query);
                    ConnectedData.SetCommand(query);
                    data = ConnectedData.GetRowFromTable();
                    int id = Convert.ToInt32(data[0]);

                    query = Commands.InsertDiagnosesPrescriptions(Models.Prescriptions.diagnosesId, id);
                    MessageBox.Show("3\n" + query);
                    ConnectedData.SetCommand(query);
                    count = ConnectedData.UpdateData();
                    MessageBox.Show("Добавлено: " + count.ToString());

                    query = Commands.InsertPrescriptionsMedications(Models.Prescriptions.medicationsId, id);
                    MessageBox.Show("4\n" + query);
                    ConnectedData.SetCommand(query);
                    count = ConnectedData.UpdateData();
                    MessageBox.Show("Добавлено: " + count.ToString());
                }

                else
                {
                    count = DisconnectedData.InsertData(query);
                    MessageBox.Show("Добавлено: " + count.ToString());

                    query = Commands.SelectLastId("dbo.prescriptions");
                    MessageBox.Show("2\n" + query);

                    dataSet = DisconnectedData.GetTableData(query);
                    DataTable dataTable = dataSet.Tables[0];
                    DataRow   dataRow   = dataTable.Rows[0];
                    int       id        = Convert.ToInt32(dataRow[0]);

                    query = Commands.InsertDiagnosesPrescriptions(Models.Prescriptions.diagnosesId, id);
                    MessageBox.Show("3\n" + query);
                    count = DisconnectedData.InsertData(query);
                    MessageBox.Show("Добавлено: " + count.ToString());

                    query = Commands.InsertPrescriptionsMedications(Models.Prescriptions.medicationsId, id);
                    MessageBox.Show("4\n" + query);
                    count = DisconnectedData.InsertData(query);
                    MessageBox.Show("Добавлено: " + count.ToString());
                }

                PrescriptionsPrint(SortTypes.IdAsc);
            }
        }