private void AddPatient(String name, String surname, String patronymic, String date, String nation, String religion, String mType)
{
Patient p = new Patient();
p.Name = name;
p.Surname = surname;
p.Patronymic = patronymic;
p.Birthday = Convert.ToDateTime(date);
p.Nation = nation;
p.Religion = religion;
p.MedCard = new MedCard();
//p.MedAccount = new MedAccount();
p.MilitaryCard = new MilitaryCard();
p.PsyCard = new PsyCard();
p.StudyCard = new StudyCard();
p.WorkCard = new WorkCard();
p.Relatives = new EntitySet<Relative>();
p.BehaviorCard = new BehaviorCard();
p.FamilyCard = new FamilyCard();
p.MilitaryCard.ServType = mType;
p.MilitaryCard.Academy = false;
p.MilitaryCard.ContrDesire = false;
p.FamilyCard.Divorced = false;
p.FamilyCard.Widower = false;
p.BehaviorCard.Alcohol = false;
p.BehaviorCard.Drugs = false;
myContext.Patients.InsertOnSubmit(p);
myContext.SubmitChanges();
}
public void AddPatient(Patient newPatient)
{
//Data.DataPatient data = new Data.DataPatient();
DataRow row = this.NewRow();
row[0] = newPatient.ID;
foreach (List<Data.Item> list in Data.DataPatient.Columns)
foreach(Data.Item item in list)
if (this.Columns.Contains(item.Name))
row[this.Columns[item.Name]] = Data.DataPatient.GetData(newPatient, item.Name);
this.Rows.Add(row);
}
public FormPatientCommon(ref Patient patient)
{
InitializeComponent();
_patient = patient;
txtName.Text = patient.Name;
txtSurname.Text = patient.Surname;
txtPatronymic.Text = patient.Patronymic;
txtReligion.Text = patient.Religion;
txtNation.Text = patient.Nation;
txtBirthday.Text = Data.DataPatient.GetDate(patient.Birthday);
if (patient.MilitaryCard.ServType == "Призыв")
comboServ.SelectedIndex = 0;
else
comboServ.SelectedIndex = 1;
txtRank.Text = patient.MilitaryCard.MilRank;
txtRecPlace.Text = patient.MilitaryCard.RecruitPlace;
comboCotract.SelectedIndex = 1;
if (patient.MilitaryCard.ContrDesire != null)
if ((bool)patient.MilitaryCard.ContrDesire)
comboCotract.SelectedIndex = 0;
foreach (Ship ship in FormMain.myContext.Ships)
{
comboShip.Items.Add(ship.Name);
}
comboShip.SelectedIndex = FormMain.myContext.Ships.ToList().IndexOf(patient.MilitaryCard.Ship);
txtUnit.Text = patient.MilitaryCard.Unit.ToString();
txtRecDate.Text = Data.DataPatient.GetDate(patient.MilitaryCard.RecData);
comboAcademy.SelectedIndex = 1;
if (patient.MilitaryCard.Academy != null)
if ((bool)patient.MilitaryCard.Academy)
comboAcademy.SelectedIndex = 0;
comboMarried.SelectedIndex = 1;
if (patient.MilitaryCard.Academy != null)
if ((bool)patient.MilitaryCard.Academy)
comboAcademy.SelectedIndex = 0;
comboDivorced.SelectedIndex = 1;
if (patient.MilitaryCard.Academy != null)
if ((bool)patient.MilitaryCard.Academy)
comboAcademy.SelectedIndex = 0;
comboWidower.SelectedIndex = 1;
if (patient.MilitaryCard.Academy != null)
if ((bool)patient.MilitaryCard.Academy)
comboAcademy.SelectedIndex = 0;
comboOrphan.SelectedIndex = 1;
if (patient.MilitaryCard.Academy != null)
if ((bool)patient.MilitaryCard.Academy)
comboAcademy.SelectedIndex = 0;
comboFather.SelectedIndex = 1;
if (patient.MilitaryCard.Academy != null)
if ((bool)patient.MilitaryCard.Academy)
comboAcademy.SelectedIndex = 0;
comboMother.SelectedIndex = 1;
if (patient.MilitaryCard.Academy != null)
if ((bool)patient.MilitaryCard.Academy)
comboAcademy.SelectedIndex = 0;
comboSisters.SelectedIndex = 1;
if (patient.MilitaryCard.Academy != null)
if ((bool)patient.MilitaryCard.Academy)
comboAcademy.SelectedIndex = 0;
comboBrothers.SelectedIndex = 1;
if (patient.MilitaryCard.Academy != null)
if ((bool)patient.MilitaryCard.Academy)
comboAcademy.SelectedIndex = 0;
comboBrain.SelectedIndex = 1;
if (patient.MedCard.BrainInjury != null)
if ((bool)patient.MedCard.BrainInjury)
comboBrain.SelectedIndex = 0;
txtHealth.Text = patient.MedCard.HealthInfo;
comboAlcohol.SelectedIndex = 1;
if (patient.BehaviorCard.Alcohol != null)
if ((bool)patient.BehaviorCard.Alcohol)
comboAlcohol.SelectedIndex = 0;
txtAlcohol.Text = patient.BehaviorCard.AlcoholInfo;
comboDrugs.SelectedIndex = 1;
if (patient.BehaviorCard.Drugs != null)
if ((bool)patient.BehaviorCard.Drugs)
comboDrugs.SelectedIndex = 0;
txtDrugs.Text = patient.BehaviorCard.DrugsInfo;
txtStudyType.Text = patient.StudyCard.StudyType;
txtStudyTime.Text = (String)patient.StudyCard.StudyTime;
txtSpeciality.Text = patient.WorkCard.Speciality;
txtWorkTime.Text = (String)patient.WorkCard.WorkTime;
if (patient.PsyCard.DateSurvey != null)
txtSurveyDate.Text = patient.PsyCard.DateSurvey.Value.ToString();
cmbAttention.SelectedIndex = cmbAttention.Items.IndexOf(patient.PsyCard.Attention == null ? "" : patient.PsyCard.Attention);
cmbCommAb.SelectedIndex = cmbCommAb.Items.IndexOf(patient.PsyCard.CommSkill == null ? "" : patient.PsyCard.CommSkill);
cmbConflictTend.SelectedIndex = cmbConflictTend.Items.IndexOf(patient.PsyCard.ConflictTend == null ? "" : patient.PsyCard.ConflictTend);
cmbConflictOrient.SelectedIndex = cmbConflictOrient.Items.IndexOf(patient.PsyCard.ConflictOrient == null ? "" : patient.PsyCard.ConflictOrient);
cmbGCA.SelectedIndex = cmbGCA.Items.IndexOf(patient.PsyCard.GCA == null ? "" : patient.PsyCard.GCA);
cmbGroup.SelectedIndex = cmbGroup.Items.IndexOf(patient.PsyCard.ProfFitness == null ? "" : patient.PsyCard.ProfFitness);
cmbMemory.SelectedIndex = cmbMemory.Items.IndexOf(patient.PsyCard.Memory == null ? "" : patient.PsyCard.Memory);
cmbMoral.SelectedIndex = cmbMoral.Items.IndexOf(patient.PsyCard.MoralNormativity == null ? "" : patient.PsyCard.MoralNormativity);
cmbNMB.SelectedIndex = cmbNMB.Items.IndexOf(patient.PsyCard.NMB == null ? "" : patient.PsyCard.NMB);
cmbNPS.SelectedIndex = cmbNPS.Items.IndexOf(patient.PsyCard.NPS == null ? "" : patient.PsyCard.NPS);
cmbRisk.SelectedIndex = cmbRisk.Items.IndexOf(patient.PsyCard.SuicideRisk == null ? "" : patient.PsyCard.SuicideRisk);
foreach (PersonalityType type in FormMain.myContext.PersonalityTypes)
{
comboPerson.Items.Add(type.Name);
}
comboPerson.SelectedIndex = FormMain.myContext.PersonalityTypes.ToList().IndexOf(patient.PsyCard.PersonalityType);
if (patient.MedCard.Illnesses.Count > 0)
{
dataIllnesses.Rows.Add(patient.MedCard.Illnesses.Count);
for (int i = 0; i < patient.MedCard.Illnesses.Count; i++)
dataIllnesses.Rows[i].Cells[0].Value = patient.MedCard.Illnesses[i].Disease;
}
if (patient.BehaviorCard.PoliceEvents.Count > 0)
{
dataEvents.Rows.Add(patient.BehaviorCard.PoliceEvents.Count);
for (int i = 0; i < patient.BehaviorCard.PoliceEvents.Count; i++)
{
dataEvents.Rows[i].Cells[0].Value = patient.BehaviorCard.PoliceEvents[i].Reason;
dataEvents.Rows[i].Cells[1].Value = patient.BehaviorCard.PoliceEvents[i].DateEvent;
}
}
if (patient.Relatives.Count > 0)
{
dataRelatives.Rows.Add(patient.Relatives.Count);
for (int i = 0; i < patient.Relatives.Count; i++)
{
dataRelatives.Rows[i].Cells[0].Value = patient.Relatives[i].Kinsman;
dataRelatives.Rows[i].Cells[1].Value = patient.Relatives[i].Relations;
}
}
_canAdd = true;
}
private void buttonAdd_Click(object sender, EventArgs e)
{
for (int i = 0; i < dataGridViewNew.RowCount - 1; i++)
{
if (!RowIsEmpty(dataGridViewNew.Rows[i]))
{
switch (_tableType)
{
case SampleType.Patients:
Patient newPatient = new Patient();
//Data.DataPatient dataPatient = new Data.DataPatient();
newPatient.MedCard = new MedCard();
//newPatient.MedAccount = new MedAccount();
newPatient.MilitaryCard = new MilitaryCard();
newPatient.PsyCard = new PsyCard();
newPatient.StudyCard = new StudyCard();
newPatient.WorkCard = new WorkCard();
newPatient.BehaviorCard = new BehaviorCard();
newPatient.FamilyCard = new FamilyCard();
foreach (DataGridView gridTable in tables)
{
if (!RowIsEmpty(gridTable.Rows[i]))
{
_table = (DataTable)gridTable.DataSource;
for (int j = 0; j < _table.Columns.Count; j++)
Data.DataPatient.SetData(_table.Rows[i][_table.Columns[j].ColumnName], _table.Columns[j].ColumnName, ref newPatient);
}
}
int shipID = 0;
if (int.TryParse(dataGridViewMil[2, i].Value.ToString(), out shipID))
{
var ships = from ship in FormMain.myContext.Ships
where ship.BoardNum == shipID
select ship;
newPatient.MilitaryCard.Ship = ships.Single();
}
newPatient.MedCard.Illnesses.AddRange(_illnesses[i]);
newPatient.BehaviorCard.PoliceEvents.AddRange(_events[i]);
newPatient.Relatives.AddRange(_relatives[i]);
FormMain.myContext.Patients.InsertOnSubmit(newPatient);
break;
case SampleType.Ships:
Ship newShip = new Ship();
_table = (DataTable)dataGridViewNew.DataSource;
for (int j = 0; j < _table.Columns.Count; j++)
Data.DataShip.SetData(_table.Rows[i][_table.Columns[j].ColumnName], _table.Columns[j].ColumnName, ref newShip);
if (dataGridViewNew[2, i].Value.ToString() != "" && dataGridViewNew[3, i].Value.ToString() != "")
{
var officers = from officer in FormMain.myContext.Officers
where officer.Surname == dataGridViewNew[2, i].Value.ToString() && officer.Name == dataGridViewNew[3, i].Value.ToString()
select officer;
newShip.Officer = officers.Single();
}
FormMain.myContext.Ships.InsertOnSubmit(newShip);
break;
case SampleType.Officers:
Officer newOfficer = new Officer();
_table = (DataTable)dataGridViewNew.DataSource;
for (int j = 0; j < _table.Columns.Count; j++)
Data.DataOfficer.SetData(_table.Rows[i][_table.Columns[j].ColumnName], _table.Columns[j].ColumnName, ref newOfficer);
FormMain.myContext.Officers.InsertOnSubmit(newOfficer);
break;
}
}
}
FormMain.myContext.SubmitChanges();
}
private void detach_Patients(Patient entity)
{
this.SendPropertyChanging();
entity.FamilyCard = null;
}
private void attach_Patients(Patient entity)
{
this.SendPropertyChanging();
entity.WorkCard = this;
}
partial void DeletePatient(Patient instance);
partial void UpdatePatient(Patient instance);
partial void InsertPatient(Patient instance);
private void DeletePatient(Patient patient)
{
myContext.PoliceEvents.DeleteAllOnSubmit(patient.BehaviorCard.PoliceEvents);
myContext.Illnesses.DeleteAllOnSubmit(patient.MedCard.Illnesses);
myContext.Relatives.DeleteAllOnSubmit(patient.Relatives);
myContext.Patients.DeleteOnSubmit(patient);
myContext.MedCards.DeleteOnSubmit(patient.MedCard);
myContext.MilitaryCards.DeleteOnSubmit(patient.MilitaryCard);
myContext.FamilyCards.DeleteOnSubmit(patient.FamilyCard);
myContext.StudyCards.DeleteOnSubmit(patient.StudyCard);
myContext.WorkCards.DeleteOnSubmit(patient.WorkCard);
myContext.PsyCards.DeleteOnSubmit(patient.PsyCard);
myContext.BehaviorCards.DeleteOnSubmit(patient.BehaviorCard);
myContext.SubmitChanges();
}