public async void AddNewPatient(string PatientName) { int spaceOcc = PatientName.IndexOf(" "); var patient = new LocalPatient() { Name = spaceOcc > 0 ? PatientName.Substring(spaceOcc + 1, PatientName.Length - spaceOcc - 1) : PatientName, Surname = spaceOcc > 0 ? PatientName.Substring(0, spaceOcc) : "", AllName = PatientName, Brush = BackgroundColors.BackgroundFilled, }; if (!PatientsList.Any(item => item.Surname.Trim() == patient.Surname.Trim() && item.Name.Trim() == patient.Name.Trim())) { patient.Name = patient.Name.TrimEnd(); patient.Surname = patient.Surname.TrimEnd(); patient.AllName = patient.Surname + " " + patient.Name; SelectedPatient = patient; try { SelectedPatient.Id = await DatabaseHandler.Instance.AddPatient(SelectedPatient, LocalCache.Instance.CurrentUser.Id); PatientsList.Add(SelectedPatient); eventAggregator.GetEvent <PatientAddedEvent>().Publish(SelectedPatient); LocalCache.Instance.PatientsRepository.Patients.Add(SelectedPatient); } catch (Exception ex) { MessageBox.Show("Eroare la salvare pacient"); } } }
public void DataGrid_Loaded(string id, string fn, string ln) { SelectedFirstName = fn; PatientsList.Add(new PatientModel { IDPatient = id, FirstName = fn, LastName = ln }); }
public async Task <IActionResult> OnPostAsync() { if (!ModelState.IsValid) { return(Page()); } string photoFileName = null; string notesFileName = null; if (PatientView.Photo != null) { photoFileName = Guid.NewGuid().ToString() + "_" + Path.GetFileName(PatientView.Photo.FileName); var imagePath = Path.Combine(_environment.WebRootPath, "images", photoFileName); using (var fileStream = new FileStream(imagePath, FileMode.Create)) { await PatientView.Photo.CopyToAsync(fileStream); } } if (PatientView.Notes != null) { notesFileName = Guid.NewGuid().ToString() + "_" + Path.GetFileName(PatientView.Notes.FileName); var notesPath = Path.Combine(_environment.WebRootPath, "files", notesFileName); using (var fileStream = new FileStream(notesPath, FileMode.Create)) { await PatientView.Notes.CopyToAsync(fileStream); } } var speciesName = PatientView.Species.ToLowerInvariant(); var species = _speciesList.SearchBy(speciesName); if (species == null) { _speciesList.Add( new Models.DbModels.Species { Name = speciesName }); species = _speciesList.SearchBy(speciesName); } var patient = new Patient { Name = PatientView.Name, Species = species, Age = PatientView.Age, PhotoPath = photoFileName, NotesPath = notesFileName }; _patientsList.Add(patient); return(RedirectToPage("./Index")); }
public async void SavePatient(LocalPatient addedPatient) { if (!string.IsNullOrEmpty(SearchedItem)) { Search(SearchedItem); } AddPatientControlVisibility = Visibility.Collapsed; PatientsList.Add(addedPatient); //SelectedPatient = addedPatient; }
private void OnPatientAdded(object patient) { var patientSelected = (LocalPatient)patient; PatientsList.Add(patientSelected); CurrentPatients = PatientsList; SelectedPatient = patientSelected; eventAggregator.GetEvent <TotalsModifiedEvent>().Publish(new TotalsIfo { TotalHours = new TimeSpan(0), TotalInverventions = 0, TotalRevenue = 0, TotalProfit = 0, TotalPatients = 1 }); LocalCache.Instance.PatientsRepository.Patients.Add(patientSelected); LocalCache.Instance.PatientsRepository.SetBirthDays(); Parent.InterventionsGeneralDetailsViewModel.InitNames(); }
public void LoadPatientsList() { PatientsList.Clear(); DBHandler conn = new DBHandler(); conn.InitializeConnection(); List <Patient> patients = conn.GetAllPatients(); conn.CloseConnection(); for (int i = 0; i < patients.Count; i++) { PatientsList.Add(patients.ElementAt(i)); } /* var a = new Patient("Jan", "Kowalski", 18, "93827193821", 1); * var b = new Patient("Adam", "Adamski", 19, "93827193822", 1); * var c = new Patient("Tomasz", "Nowak", 20, "93827193823", 1); * PatientsList.Add(a); * PatientsList.Add(b); * PatientsList.Add(c);*/ }
public void Save() { if (SelectedPatient != null && SelectedPatient.NewlyAdded) { PatientsList.Add(SelectedPatient); SelectedPatient.NewlyAdded = false; } try { bool shouldDisplayMessage; double cost = MaterialCost.HasValue ? MaterialCost.Value : 0; var itemsNotSelected = GetNotAddedInformation(out shouldDisplayMessage); if (shouldDisplayMessage) { MessageBox.Show("Inainte de a salva adaugati :" + itemsNotSelected); return; } var duration = TimeSpan.FromMinutes(Convert.ToDouble(Durata)); EndTIme = StartingHour.Add(duration); double percentage = SelectedPercentage != null ? SelectedPercentage.Percentage / 100 : (SelectedWork != null && SelectedWork.Percent != 0 ? SelectedWork.Percent / 100 : 1); var intervention = new LocalIntervention() { Id = Id, Area = SelectedArea != null ? (SelectedArea.SettingTOarea()) : null, Location = SelectedLocation != null?SelectedLocation.SettingToLocation() : null, DateHourDetail = new LocalDateHourDetail() { Date = Date, StartHour = StartingHour, Mili = Convert.ToInt64(DateTime.Now.TimeOfDay.TotalMilliseconds), EndingHour = EndTIme, Duration = duration }, Lucrare = SelectedWork, PatientName = SelectedPatient.AllName, Material = SelectedMaterial, Observation = Observation, Revenue = Revenue.HasValue ? Revenue.Value : 0, PatientId = SelectedPatient.Id, Percent = Convert.ToDouble((Revenue - cost) * percentage), WasPayedByDental = WasPayedByDental, TechnicianId = SelectedTechnician != null ? SelectedTechnician.Id : (int?)null, MaterialCost = MaterialCost, Technician = SelectedTechnician }; ChangeTotalInfo(intervention, IsInEditMode); intervention.Id = DatabaseHandler.Instance.AddIntervention(intervention, LocalCache.Instance.CurrentUser.Id); if (IsInEditMode) { LocalIntervention = intervention; } else { LocalCache.Instance.AddIntervention(intervention); var patient = LocalCache.Instance.PatientsRepository.Patients.FirstOrDefault(item => item.Id == SelectedPatient.Id); if (patient != null) { patient.Interventions.Add(intervention); } } SetNewIntervenionDetails(intervention); IsPatientComboFocused = false; IsPatientComboFocused = true; InitData(); } catch (Exception ex) { MessageBox.Show("A intervenit o eroare la salvare."); Log.Error("Error inserting intervention --> Save"); } }
public void DataGrid_Loaded() { DBClass.openConnection(); //) CAST(DateOfBirth AS date), convert(Date, DateOfBirth, 23) DBClass.sql = "select distinct IDPatient, FirstName, LastName, convert(VARCHAR, DateOfBirth, 23) , " + "Street, ZIP, City, therapists.LastNameTherapist, patients.IDTherapist, Phone, Email " + "from patients, therapists, therapistSpecialization where therapists.LastNameTherapist = " + "(select LastNameTherapist from therapists where IDTherapist = patients.IDTherapist)"; DBClass.cmd.CommandType = CommandType.Text; DBClass.cmd.CommandText = DBClass.sql; DBClass.da = new SqlDataAdapter(DBClass.cmd); DBClass.dt = new DataTable(); DBClass.da.Fill(DBClass.dt); // wyciągamy dane int i = 0; int j = 0; //Console.WriteLine("Przy bazie" + data[3]); PatientsList.Clear(); using (SqlDataReader reader = DBClass.cmd.ExecuteReader()) { while (reader.Read()) { for (j = 0; j <= reader.FieldCount - 1; j++) // Looping throw colums { data[j] = reader.GetValue(j).ToString(); } if (data[7] == null) { data[7] = ""; } //Console.WriteLine("Przy bazie" + data[3]); PatientsList.Add(new PatientModel { IDPatient = (data[0]), FirstName = data[1], LastName = data[2], DateOfBirth = data[3], Street = data[4], ZIP = data[5], City = data[6], IDTherapist = data[7], NameTherapist = (data[8]), Phone = data[9], Email = data[10] }); //Console.WriteLine("IDTherapist - " + data[7] + data[8]); } } //cmd.CommandText = "update projekt set ocena_projekt = @ocenaProjekt " + // "where(select ID_Studenta from Student where STU_nazwisko = @nazwiskoS) = ID_studenta and " + // "(select ID_prowadzacego from Prowadzacy where nazwisko_pro = 'Wodecki') = Pro_ID_prowadzacego and " + // "(select ID_projektu from Projekty where temat = @temat) = ID_projektu;"; DBClass.closeConnection(); //int i = 0; //int j = 0; //var con = new SQLiteConnection("Data Source=Prolog;Version=3;New=False;Compress=True;"); try { //String con = "Server=localhost;Database=Prolog;User Id=prolog;password=prolog"; //String con = "Server=DELL-ADI\\SQLEXPRESS; uid=prolog; pwd=prolog; database=Prolog;"; ////String con = " server = 194.181.228.20; uid = edenland_prolog; pwd = adikos; database = edenland_prolog;"; //MySqlConnection Connection = new MySqlConnection(con); //string CommandText = "select * from patients"; //MySqlDataAdapter ApapterSQL = new MySqlDataAdapter(); //ApapterSQL.SelectCommand = new MySqlCommand(CommandText, Connection); //MySqlCommandBuilder builder = new MySqlCommandBuilder(ApapterSQL); //Connection.Open(); //DataTable dane = new DataTable(); //ApapterSQL.Fill(dane); ////ReservationFromWebList.ItemsSource = dane.DefaultView; //ApapterSQL.Update(dane); //con.Open(); //SQLiteCommand sqlCmd = con.CreateCommand(); //sqlCmd.CommandText = "SELECT * FROM patients "; //using (SQLiteDataReader rdr = sqlCmd.ExecuteReader()) //{ // while (rdr.Read()) // Reading Rows // { // for (j = 0; j <= rdr.FieldCount - 1; j++) // Looping throw colums // { // data[j] = rdr.GetValue(j).ToString(); // } // PatientsList.Add(new PatientModel { IDPatient = (data[0]), FirstName = data[1], LastName = data[2] }); // i++; // } //} //Connection.Close(); } catch (Exception exp) { MessageBox.Show(exp.Message); } }