private void DeletePacient() { if (SelectedPacient == null) { MessageBox.Show("Selecteaza un pacient.", "Atentie", MessageBoxButton.OK, MessageBoxImage.Information); } else { var canDelete = true; AppService.Instance.CerereService.GetAll().ToList().ForEach(x => { if (x.IdPacient == SelectedPacient.Id) { canDelete = false; } }); if (!canDelete) { MessageBox.Show("Pacientul nu poate fi sters. \n Exista cereri pe numele pacientului.", "Atentie", MessageBoxButton.OK, MessageBoxImage.Information); } else { AppService.Instance.PacientService.Delete(SelectedPacient.Id); Pacienti.Remove(SelectedPacient); } } }
public static bool UpdatePacient(Pacienti pacienti) { bool uEditua = false; SqlConnection conn = Connection.GetSqlConnection(); try { SqlCommand cmd = new SqlCommand("ups_Pacient_Update", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@PacientiID", pacienti.PacientiID); cmd.Parameters.AddWithValue("@Emri", pacienti.Emri); cmd.Parameters.AddWithValue("@Mbiemri", pacienti.Mbiemri); cmd.Parameters.AddWithValue("@NrLeternjoftimit", pacienti.NrLeternjoftimit); cmd.Parameters.AddWithValue("@Gjinia", pacienti.Gjinia); cmd.Parameters.AddWithValue("@DataLindjes", pacienti.DataLindjes); cmd.Parameters.AddWithValue("@VendiLindjes", pacienti.VendiLindjes); cmd.Parameters.AddWithValue("@Telefoni", pacienti.Telefoni); cmd.Parameters.AddWithValue("@EmailAddresa", pacienti.Email); cmd.Parameters.AddWithValue("@Addresa", pacienti.Addresa); cmd.ExecuteNonQuery(); uEditua = true; } catch (SqlException ex) { throw; } finally { conn.Close(); } return(uEditua); }
private void gridPacientet_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex != -1) { Pacienti pacienti = new Pacienti(); pacienti.PacientiID = Convert.ToInt32(gridPacientet.Rows[e.RowIndex].Cells[0].Value); pacienti.Emri = Convert.ToString(gridPacientet.Rows[e.RowIndex].Cells[2].Value); pacienti.Mbiemri = Convert.ToString(gridPacientet.Rows[e.RowIndex].Cells[3].Value); pacienti.NrLeternjoftimit = Convert.ToString(gridPacientet.Rows[e.RowIndex].Cells[1].Value); pacienti.Gjinia = Convert.ToString(gridPacientet.Rows[e.RowIndex].Cells[4].Value); pacienti.DataLindjes = Convert.ToDateTime(gridPacientet.Rows[e.RowIndex].Cells[5].Value); pacienti.VendiLindjes = Convert.ToString(gridPacientet.Rows[e.RowIndex].Cells[6].Value); pacienti.Telefoni = Convert.ToString(gridPacientet.Rows[e.RowIndex].Cells[7].Value); pacienti.Email = Convert.ToString(gridPacientet.Rows[e.RowIndex].Cells[8].Value); pacienti.Addresa = Convert.ToString(gridPacientet.Rows[e.RowIndex].Cells[9].Value); FrmEditPacient frmedito = new FrmEditPacient(); frmedito.VendosTeDhenat(pacienti); frmedito.ShowDialog(); btn_SearchPatient_Click(sender, e); } }
public async Task <IActionResult> PutPacienti([FromRoute] int id, [FromBody] Pacienti pacienti) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != pacienti.id) { return(BadRequest()); } _context.Entry(pacienti).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!PacientiExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
private void FrmContent_Load(object sender, EventArgs e) { FrmEditPacient editoPacient = new FrmEditPacient(); Pacienti pacient = new Pacienti(); pacient.PacientiID = 1; //editoPacient.VendosTeDhenat(pacient); }
private void AddPacient() { var win = new PacientDetails(new PacientViewModel()); win.Show(); win.ViewModel.PacientAdded += (sender, args) => { Pacienti.Add(args); win.Close(); }; }
public async Task <IActionResult> PostPacienti([FromBody] Pacienti pacienti) { string userId = User.Claims.First(c => c.Type == "UserID").Value; if (!ModelState.IsValid) { return(BadRequest(ModelState)); } pacienti.UserID = userId; pacienti.DataInregistrare = DateTime.Today; _context.Pacienti.Add(pacienti); await _context.SaveChangesAsync(); return(CreatedAtAction("GetPacienti", new { id = pacienti.id }, pacienti)); }
static void Main(string[] args) { int x; Meniu meniu = new Meniu(); List <Pacient> listaPacienti = new List <Pacient>(); listaPacienti.Add(new Pacient("2950622350067", "Popescu", "Ion", new Modele.Generic.Adresa("Timis", "Timisoara", "Salciei", 3), "preinfarct", new Modele.Generic.Data(6, 12, 2017))); listaPacienti.Add(new Pacient("2953475350067", "Ionescu", "Andreea", new Modele.Generic.Adresa("Timis", "Timisoara", "Plopi", 9), "ulcer", new Modele.Generic.Data(6, 8, 2017))); listaPacienti.Add(new Pacient("2950622763467", "Anghel", "Maria", new Modele.Generic.Adresa("Timis", "Timisoara", "Madrid", 10), "gripa", new Modele.Generic.Data(6, 7, 2017))); Pacienti lista = new Pacienti(listaPacienti); List <Ambulanta> listaAmbulante = new List <Ambulanta>(); listaAmbulante.Add(new Ambulanta("VW", 2005, new Modele.Generic.NumarMasina("TM02WOW"))); listaAmbulante.Add(new Ambulanta("Mercedes", 2000, new Modele.Generic.NumarMasina("TM02FXR"))); listaAmbulante.Add(new Ambulanta("BMW", 2010, new Modele.Generic.NumarMasina("TM05PLS"))); Ambulante listaAmb = new Ambulante(listaAmbulante); List <Angajat> listaAngajati = new List <Angajat>(); listaAngajati.Add(new Angajat("29567342688", "Pop", "Ionel", new Modele.Generic.Adresa("Timis", "Timisoara", "Plop", 3), "manager", "Ionescu Maria")); listaAngajati.Add(new Angajat("29556742688", "Popovici", "Arthur", new Modele.Generic.Adresa("Timis", "Timisoara", "Sever Bocu", 20), "doctor", "Pop Ionel")); listaAngajati.Add(new Angajat("29567342688", "Meda", "Ana", new Modele.Generic.Adresa("Timis", "Timisoara", "Linitei", 3), "asistent", "Popovici Arthur")); Angajati listaAng = new Angajati(listaAngajati); List <Medicament> listaMedicamente = new List <Medicament>(); listaMedicamente.Add(new Medicament(new Modele.Medicament.Furnizor("SC MED", new Modele.Generic.Adresa("Timis", "Timisoara", "Lazar", 2)), "Algocalmin", 200)); listaMedicamente.Add(new Medicament(new Modele.Medicament.Furnizor("SC OSM", new Modele.Generic.Adresa("Timis", "Timisoara", "Maur", 23)), "Diazepam", 240)); Medicamente listaMed = new Medicamente(listaMedicamente); List <Investigatie> investigatii = new List <Investigatie>(); investigatii.Add(new Investigatie("2950622350067", new Analize(200, 100, 50))); investigatii.Add(new Investigatie("2953475350067", new Analize(300, 50, 20))); do { meniu.afisareMeniu(); x = int.Parse(Console.ReadLine()); meniu.selectareOptiune(x, lista, listaAmb, listaAng, listaMed, investigatii); } while (x != 0); Console.ReadLine(); }
/// <summary> /// //////////////////////Shfaq Listen e pacientave /////////////////////////////// /// </summary> /// <returns></returns> public static List <Pacienti> ShfaqListenPacienteve() { List <Pacienti> listPacient = new List <Pacienti>(); SqlConnection conn = Connection.GetSqlConnection(); SqlCommand cmd = new SqlCommand("usp_SelectAll_Pacienti", conn); cmd.CommandType = CommandType.StoredProcedure; try { using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { Pacienti p = new Pacienti(); p.Emri = Convert.ToString(reader["Emri"]); p.Mbiemri = Convert.ToString(reader["Mbiemri"]); p.NrLeternjoftimit = Convert.ToString(reader["NrLeternjofitmit"]); p.Gjinia = Convert.ToString(reader["Gjinia"]); p.DataLindjes = Convert.ToDateTime(reader["DataLindjes"]); p.VendiLindjes = Convert.ToString(reader["VendiLindjes"]); p.Telefoni = Convert.ToString(reader["Telefoni"]); p.Email = Convert.ToString(reader["EmailAddresa"]); p.Addresa = Convert.ToString(reader["Addresa"]); listPacient.Add(p); } } } catch (Exception ex) { throw new Exception("AccPacienti.ShfaqListenPacienteve() :" + ex.Message); } finally {//perderisa nuk eshte e mbyllur ti mbylle dhe alokoi resurset nga memorja if (conn.State != ConnectionState.Closed) { conn.Close(); conn.Dispose(); } } return(listPacient); }
//per vendosjen e te dhenave ne textboxa public void VendosTeDhenat(Pacienti pacienti) { txtPacienti.Text = pacienti.PacientiID.ToString(); txtEName.Text = pacienti.Emri; txtESurname.Text = pacienti.Mbiemri; txtNrLeternjofitmit.Text = pacienti.NrLeternjoftimit; if (pacienti.Gjinia == "Male") { rbMashkull.Checked = true; } else { rbFemer.Checked = true; } dtpDataOfBirth.Value = pacienti.DataLindjes; txtVendiLindjes.Text = pacienti.VendiLindjes; txtTel.Text = pacienti.Telefoni; txtEmail.Text = pacienti.Email; txtAddresa.Text = pacienti.Addresa; }
//Kerko pacient Shfaq listen e pacienteve ////////////////////////////////////////////////// public static List <Pacienti> ShfaqListenPacienteve(string prmKerko) { List <Pacienti> pacient = new List <Pacienti>(); SqlConnection connect = Connection.GetSqlConnection(); try { // emri procedures n SQL SqlCommand comand = new SqlCommand("usp_Kerko_Pacient", connect); comand.CommandType = CommandType.StoredProcedure; comand.Parameters.AddWithValue("@prmKerko", prmKerko); SqlDataReader reader = comand.ExecuteReader(); while (reader.Read()) { Pacienti p = new Pacienti(); p.PacientiID = Int32.Parse(reader["PacientiID"].ToString()); p.NrLeternjoftimit = reader["NrLeternjofitmit"].ToString(); p.Emri = reader["Emri"].ToString(); p.Mbiemri = reader["Mbiemri"].ToString(); p.Gjinia = reader["Gjinia"].ToString(); p.DataLindjes = DateTime.Parse(reader["DataLindjes"].ToString()); p.VendiLindjes = reader["VendiLindjes"].ToString(); p.Telefoni = reader["Telefoni"].ToString(); p.Addresa = reader["Addresa"].ToString(); p.Email = reader["EmailAddresa"].ToString(); pacient.Add(p); } } catch (Exception) { throw; } finally { connect.Close(); } return(pacient); }
private void UpdatePacient() { if (SelectedPacient == null) { MessageBox.Show("Selecteaza un pacient.", "Atentie", MessageBoxButton.OK, MessageBoxImage.Information); } else { var win = new PacientDetails(SelectedPacient); win.Show(); win.ViewModel.PacientUpdated += (sender, args) => { Pacienti.ToList().ForEach(x => { if (x.Id == args.Id) { var nume = args.Nume; var prenume = args.Prenume; var idGrupa = args.IdGrupaDeSange; var idInst = args.IdInstitutieAsociata; var grupa = args.GrupaDeSange; var inst = args.InstitutieAsociata; var data = args.DataNastere; x.Nume = nume; x.Prenume = prenume; x.IdGrupaDeSange = idGrupa; x.IdInstitutieAsociata = idInst; x.GrupaDeSange = grupa; x.InstitutieAsociata = inst; x.DataNastere = data; } }); win.Close(); }; } }
private void btnEditPacient_Click(object sender, EventArgs e) { BLPacienti pacienti = new BLPacienti(); //Objekti i klases pacienti Pacienti pacient = new Pacienti(); pacient.PacientiID = Int32.Parse(txtPacienti.Text); pacient.Emri = txtEName.Text; pacient.Mbiemri = txtESurname.Text; pacient.NrLeternjoftimit = txtNrLeternjofitmit.Text; if (rbMashkull.Checked) { pacient.Gjinia = "Mashkull"; } else { pacient.Gjinia = "Femer"; } pacient.DataLindjes = Convert.ToDateTime(dtpDataOfBirth.Text); pacient.VendiLindjes = txtVendiLindjes.Text; pacient.Telefoni = txtTel.Text; pacient.Email = txtEmail.Text; pacient.Addresa = txtAddresa.Text; if (BLPacienti.UpdatePacient(pacient)) { MessageBox.Show("U editua me sukses"); } else { MessageBox.Show("Error"); } //Thirret metoda per te edituar }
//Metoda void per te insertuar pacient public static void Insert(Pacienti pacient) { SqlConnection conn = Connection.GetSqlConnection(); SqlCommand cmd = new SqlCommand("usp_Pacient_Insert", conn); cmd.CommandType = CommandType.StoredProcedure; try { cmd.Parameters.AddWithValue("@prmEmri", pacient.Emri); cmd.Parameters.AddWithValue("@prmMbiemri", pacient.Mbiemri); cmd.Parameters.AddWithValue("@prmNrLeternjoftimit", pacient.NrLeternjoftimit); cmd.Parameters.AddWithValue("@prmGjinia", pacient.Gjinia); cmd.Parameters.AddWithValue("@prmDataLindjes", pacient.DataLindjes); cmd.Parameters.AddWithValue("@prmVendiLindjes", pacient.VendiLindjes); cmd.Parameters.AddWithValue("@prmTelefoni", pacient.Telefoni); cmd.Parameters.AddWithValue("@prmEmailAddresa", pacient.Email); cmd.Parameters.AddWithValue("@prmAddresa", pacient.Addresa); cmd.ExecuteNonQuery(); } catch (Exception ex) { throw new Exception("AccPacienti.Insert() :" + ex.Message); } finally { //perderisa qikjo nuk e ka gjendjen e mbyllur ti mbylle dhe liroi resurset if (conn.State != ConnectionState.Closed) { conn.Close(); conn.Dispose(); } } }
//eventi i butonit Shto pacient private void btnShtoPacient_Click(object sender, EventArgs e) { if (txtName.Text == "") { MessageBox.Show("Ju lutem shkruani emrin e pacientit"); } else if (txtSurname.Text == "") { MessageBox.Show("Ju lutem shkruani mbiemrin e pacientit"); } else if (txtNrLeternjofitmit.Text == "") { MessageBox.Show("Ju lutem shkruani numrin e leternjoftimit e pacientit"); } else if (dtpDataOfBirth.Text == "") { MessageBox.Show("Ju lutem shkruani datëlindjen e pacientit"); } else if (txtVendiLindjes.Text == "") { MessageBox.Show("Ju lutem shkruani vendin e lindjes e pacientit"); } else if (txtAddresa.Text == "") { MessageBox.Show("Ju lutem shkruani addresen e pacientit"); } else if (txtTel.Text == "") { MessageBox.Show("Ju lutem shkruani numrin e telefonit e pacientit"); } try { //Objekti i klases pacienti Pacienti pacient = new Pacienti(); pacient.Emri = txtName.Text; pacient.Mbiemri = txtSurname.Text; pacient.NrLeternjoftimit = txtNrLeternjofitmit.Text; pacient.Gjinia = cmbSex.Text; pacient.DataLindjes = Convert.ToDateTime(dtpDataOfBirth.Text); pacient.VendiLindjes = txtVendiLindjes.Text; pacient.Telefoni = txtTel.Text; pacient.Email = txtEmail.Text; pacient.Addresa = txtAddresa.Text; BLPacienti.Insert(pacient); MessageBox.Show("Pacienti u shtua me sukses "); } catch (FormatException ex) { throw new FormatException("Error" + ex.Message); } //if (AccPacienti.Insert(pacient.ToString())) //{ // MessageBox.Show("Pacienti u regjistrua me sukses"); //} //else //{ // MessageBox.Show("Error"); //} //FrmContent frmcountent = new FrmContent(); //frmcountent.Show(); }
public void selectareOptiune(int x, Pacienti pacienti, Ambulante ambulante, Angajati angajati, Medicamente medicamente, List <Investigatie> investigatii) { switch (x) { case 0: break; case 1: Console.Write(ambulante.ToString()); Console.Write("\n\n"); break; case 2: Console.Write(angajati.ToString()); Console.Write("\n\n"); break; case 3: Console.Write("Dati CNP:\n"); string cnp = Console.ReadLine(); foreach (var inv in investigatii) { if (inv.Cnp.Equals(cnp)) { Console.Write(inv.ToString()); } } break; case 4: Console.Write(medicamente.ToString()); Console.Write("\n\n"); break; case 5: Console.Write(pacienti.ToString()); Console.Write("\n\n"); break; case 6: List <string> content = new List <string>(); GeneratorRapoartePdf pdf = new GeneratorRapoartePdf(); Console.Write("Dati CNP:\n"); string cnp2 = Console.ReadLine(); foreach (Pacient pac in pacienti._pacienti) { if (pac.Cnp == cnp2) { content.Add(pac.ToString()); } } foreach (var inv in investigatii) { if (inv.Cnp.Equals(cnp2)) { content.Add(inv.ToString()); } } pdf.GenerareRaportTabelar(cnp2 + ".pdf", content); break; } }