static public Corpus CreateCorpus(int floors, string name) { Corpus corpus = new Corpus(); corpus.Cabinet = new List <Cabinet>(); corpus.Floors = floors; corpus.Name = name; return(corpus); }
private void comboBoxCorpus_SelectedIndexChanged(object sender, EventArgs e) { comboBoxCabinet.Items.Clear(); string corpusName = comboBoxCorpus.Text; Corpus corpus = (from c in db.CorpusSet where c.Name == corpusName select c).ToList()[0]; foreach (Cabinet c in corpus.Cabinet) { comboBoxCabinet.Items.Add(c.Num); } }
private void ReloadForm(bool RefreshDataGrid = false, bool selectByCab = false) { if (RefreshDataGrid) { if (!selectByCab) { var cabinetsInfo = (from cabinet in db.CabinetSet select new { Корпус = cabinet.Corpus.Name, Этаж = cabinet.Floor, Номер = cabinet.Num, id = cabinet.Id }).ToList(); dataGridView1.Columns.Clear(); dataGridView1.Columns.Add("Корпус", "Корпус"); dataGridView1.Columns.Add("Этаж", "Этаж"); dataGridView1.Columns.Add("Номер", "Номер"); dataGridView1.Columns.Add("Id", "Id"); dataGridView1.Columns["Id"].Visible = false; foreach (var s in cabinetsInfo) { dataGridView1.Rows.Add(s.Корпус, s.Этаж, s.Номер, s.id); } dataGridView1.RowHeadersVisible = false; dataGridView1.Refresh(); } else { Corpus corpus = (from c in db.CorpusSet where c.Name == comboBoxJobs.Text select c).ToList()[0]; var cabinetsInfo = (from cabinet in corpus.Cabinet select new { Корпус = cabinet.Corpus.Name, Этаж = cabinet.Floor, Номер = cabinet.Num, id = cabinet.Id }).ToList(); dataGridView1.Columns.Clear(); dataGridView1.Columns.Add("Корпус", "Корпус"); dataGridView1.Columns.Add("Этаж", "Этаж"); dataGridView1.Columns.Add("Номер", "Номер"); dataGridView1.Columns.Add("Id", "Id"); dataGridView1.Columns["Id"].Visible = false; foreach (var s in cabinetsInfo) { dataGridView1.Rows.Add(s.Корпус, s.Этаж, s.Номер, s.id); } dataGridView1.RowHeadersVisible = false; dataGridView1.Refresh(); } dataGridView1.Refresh(); } else { comboBoxJobs.Items.Clear(); var corpuses = (from c in db.CorpusSet select c).ToList(); foreach (var c in corpuses) { comboBoxJobs.Items.Add(c.Name); } } }
static public Cabinet CreateCabinet(string corpusName, int floor, int num) { Cabinet cabinet = new Cabinet(); Corpus corpus = (from c in dbContext.CorpusSet where c.Name == corpusName select c).ToList()[0]; cabinet.Corpus = corpus; cabinet.Floor = floor; cabinet.Num = num; cabinet.TimeForVisit = new List <TimeForVisit>(); return(cabinet); }
private void EditVisit_Load(object sender, EventArgs e) { var doctorsList = (from d in db.PersonSet where d is Doctor select d).ToArray(); if (doctorsList.Count() == 0) { MessageBox.Show("Добавьте врачей"); this.Close(); } foreach (Person d in doctorsList) { comboBoxDoctor.Items.Add(d.FullName + "_" + d.BirthDate.Date.ToString()); } var corpusList = (from c in db.CorpusSet select c).ToArray(); if (corpusList.Count() == 0) { MessageBox.Show("Добавьте корпусы"); this.Close(); } foreach (Corpus c in corpusList) { comboBoxCorpus.Items.Add(c.Name); } comboBoxCorpus.SelectedIndex = 0; string corpusName = comboBoxCorpus.Text; Corpus corpus = (from c in db.CorpusSet where c.Name == corpusName select c).ToList()[0]; if (corpus.Cabinet.Count() == 0) { MessageBox.Show("Добавьте кабинеты в корпус"); this.Close(); } comboBoxCabinet.Items.Clear(); foreach (Cabinet c in corpus.Cabinet) { comboBoxCabinet.Items.Add(c.Num); } }
static public TimeForVisit EditVisit(TimeForVisit visit, string docInfo, string patInfo, string corpusName, string cabinetNum, string date, string time) { visit = dbContext.TimeForVisitSet.Find(visit.Id); string[] docFIODB = docInfo.Split('_'); string docFIO = docFIODB[0]; DateTime docDB = DateTime.Parse(docFIODB[1]); Doctor doctor = (Doctor)(from pers in dbContext.PersonSet where pers is Doctor && pers.FullName == docFIO && pers.BirthDate == docDB select pers).ToList()[0]; Patient patient = null; if (patInfo != "Нет пациента" && patInfo != "") { string[] patFIODB = patInfo.Split('_'); string patFIO = patFIODB[0]; DateTime patDB = DateTime.Parse(patFIODB[1]); patient = (Patient)(from pers in dbContext.PersonSet where pers is Patient && pers.FullName == patFIO && pers.BirthDate == patDB select pers).ToList()[0]; } Corpus corpus = (from c in dbContext.CorpusSet where c.Name == corpusName select c).ToArray()[0]; int num = int.Parse(cabinetNum); Cabinet cabinet = (from c in corpus.Cabinet where c.Num == num select c).ToArray()[0]; DateTime dateValue = DateTime.Parse(date); DateTime timeValue = DateTime.Parse(time); DateTime visitTime = dateValue.Add(timeValue.TimeOfDay); visit.Cabinet = cabinet; visit.Doctor = doctor; visit.Patient = patient; visit.VisitTime = visitTime; dbContext.Entry(visit).State = System.Data.Entity.EntityState.Modified; dbContext.SaveChanges(); return(visit); }
private void comboBoxCorpus_SelectedIndexChanged_1(object sender, EventArgs e) { comboBoxFloor.Items.Clear(); string corpusName = comboBoxCorpus.Text; if (corpusName != "") { Corpus corpus = (from c in db.CorpusSet where c.Name == corpusName select c).ToList()[0]; for (int i = 0; i < corpus.Floors; i++) { comboBoxFloor.Items.Add(i + 1); } } }
private void comboBoxCorpus_SelectedIndexChanged(object sender, EventArgs e) { comboBoxFloor.Items.Clear(); string corpusName = comboBoxCorpus.Text; Corpus corpus = (from c in db.CorpusSet where c.Name == corpusName select c).ToList().First(); if (corpus != null) { for (int i = 0; i < corpus.Floors; i++) { comboBoxFloor.Items.Add(i + 1); } comboBoxFloor.Enabled = true; } }
static public void RemoveCabinet(string cabinetName) { string corpusName = cabinetName.Split(':')[0]; int cabinetNum = int.Parse(cabinetName.Split(':')[1]); Corpus corpus = (from c in dbContext.CorpusSet where c.Name == corpusName select c).ToArray()[0]; Cabinet cabinet = (from c in corpus.Cabinet where c.Num == cabinetNum select c).ToArray()[0]; TimeForVisit[] tfvs = cabinet.TimeForVisit.ToArray(); foreach (TimeForVisit tfv in tfvs) { dbContext.TimeForVisitSet.Remove(tfv); } cabinet.TimeForVisit.Clear(); dbContext.CabinetSet.Remove(cabinet); dbContext.SaveChanges(); }
static public Cabinet EditCabinet(Cabinet cabinet, string corpusName, int floor, int num) { cabinet = dbContext.CabinetSet.Find(cabinet.Id); Corpus corpus = (from c in dbContext.CorpusSet where c.Name == corpusName select c).ToList()[0]; cabinet.Corpus = corpus; cabinet.Floor = floor; cabinet.Num = num; dbContext.Entry(cabinet).State = System.Data.Entity.EntityState.Modified; dbContext.SaveChanges(); return(cabinet); }
static public string AddCorpus(Corpus corpus) { //Проверка наличия совпадений по этажу, комнате, корпусу var searchResult = (from c in dbContext.CorpusSet where c.Name == corpus.Name select c).ToList(); if (searchResult.Count != 0) { return("Такой корпус уже существует"); } else { ; } //Добавление в БД dbContext.CorpusSet.Add(corpus); dbContext.SaveChanges(); return(null); }
private void buttonAddJob_Click(object sender, EventArgs e) { string corpusName = textBoxCorpus.Text; if (corpusName != "") { int floors = (int)numericUpDown1.Value; Corpus newCorpus = ControlFunctions.CreateCorpus(floors, corpusName); string result = ControlFunctions.AddCorpus(newCorpus); if (result != null) { MessageBox.Show(result, "Ошибка"); } else { ReloadForm(); } } else { MessageBox.Show("Введите название корпуса"); } }
protected override void Seed(ModelMedContainer db) { Job jobNull = ControlFunctions.CreateJob("Нет должности"); db.JobSet.Add(jobNull); Job jobA = ControlFunctions.CreateJob("Главврач"); db.JobSet.Add(jobA); Job jobB = ControlFunctions.CreateJob("Терапевт"); db.JobSet.Add(jobB); db.SaveChanges(); Doctor docA = ControlFunctions.CreateDoctor("Александров Александр Иванович", DateTime.Parse("11.11.1990"), "Паспорт РФ", "0000000001", "Главврач", "Home,1", "Enough", "Мужской", "12345", "2"); db.PersonSet.Add(docA); Doctor docB = ControlFunctions.CreateDoctor("Иванов Иван Иванович", DateTime.Parse("11.11.1980"), "Паспорт РФ", "0000000002", "Терапевт", "Home,2", "Enough", "Мужской", "12346", "2"); db.PersonSet.Add(docB); db.SaveChanges(); Doctor docC = ControlFunctions.CreateDoctor("Иванов Иван Иванович", DateTime.Parse("11.11.1955"), "Паспорт РФ", "0000000003", "Терапевт", "Home,2", "Enough", "Мужской", "123473", "2"); ControlFunctions.AddPerson(docC); Patient patA = ControlFunctions.CreatePatient("Иванов Иван Иванович", DateTime.Parse("11.12.1980"), "Паспорт РФ", "0000000004", "Home,3", "+1", "Мужской", "12347", "2"); Corpus corpA = ControlFunctions.CreateCorpus(3, "Корпус 1"); db.CorpusSet.Add(corpA); db.SaveChanges(); Cabinet cabA = ControlFunctions.CreateCabinet("Корпус 1", 1, 1); db.CabinetSet.Add(cabA); db.SaveChanges(); TimeForVisit timeA = ControlFunctions.CreateTimeForVisit("Иванов Иван Иванович_11.11.1980", "Корпус 1", "1", "11.11.2000", "00:00:00"); TimeForVisit timeB = ControlFunctions.CreateTimeForVisit("Иванов Иван Иванович_11.11.1980", "Корпус 1", "1", "11.11.2000", "12:13:17"); db.TimeForVisitSet.Add(timeB); db.TimeForVisitSet.Add(timeA); patA.TimeForVisit.Add(timeA); timeA.Patient = patA; Illness illA = ControlFunctions.CreateIllness("Что-то можно, что-то нельзя.", "Болезнь А"); Illness illAA = ControlFunctions.CreateIllness("Что-то можно, что-то нельзя.", "Болезнь А"); Illness illB = ControlFunctions.CreateIllness("Что-то можно, что-то нельзя.", "Болезнь Б"); db.IllnessSet.Add(illA); illA.MedCard.Add(patA.MedCard); patA.MedCard.Illness.Add(illA); db.IllnessSet.Add(illB); illB.MedCard.Add(patA.MedCard); patA.MedCard.Illness.Add(illB); db.PersonSet.Add(patA); Record recA = ControlFunctions.CreateRecord(DateTime.Now, docB, "111", patA.MedCard); Record recB = ControlFunctions.CreateRecord(DateTime.Parse("11.11.2000"), docB, "222", patA.MedCard); Record recC = ControlFunctions.CreateRecord(DateTime.Parse("11.11.2010"), docA, "333", patA.MedCard); db.RecordSet.Add(recA); db.RecordSet.Add(recB); db.RecordSet.Add(recC); db.JobSet.Add(ControlFunctions.CreateJob("testJob")); db.SaveChanges(); }