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;
}
}
