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); }
public static List <Termini> ShfaqListenTermineve(string prmKerko) { List <Termini> termini = new List <Termini>(); SqlConnection connect = Connection.GetSqlConnection(); try {//emri procedures ne SQL SqlCommand comand = new SqlCommand("" + connect); comand.CommandType = CommandType.StoredProcedure; comand.Parameters.AddWithValue("@prmKerko", prmKerko); SqlDataReader reader = comand.ExecuteReader(); while (reader.Read()) { Termini t = new Termini(); t.TerminiID = Int32.Parse(reader["TerminiID"].ToString()); t.PacientiID = Int32.Parse(reader["PacientiID"].ToString()); t.Koha = DateTime.Parse(reader["Koha"].ToString()); t.ArsyejaTerminit = reader["ArsyejaTerminit"].ToString(); termini.Add(t); } } catch (Exception) { throw; } finally { connect.Close(); } return(termini); }
/// <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); }
//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); }
public static List <Vizita> ShfaqListenVizitave(string prmKerko) { List <Vizita> vizita = new List <Vizita>(); SqlConnection connect = Connection.GetSqlConnection(); try { // emri procedures n SQL SqlCommand comand = new SqlCommand("" + connect); comand.CommandType = CommandType.StoredProcedure; comand.Parameters.AddWithValue("@prmKerko", prmKerko); SqlDataReader reader = comand.ExecuteReader(); while (reader.Read()) { Vizita v = new Vizita(); v.VizitaID = Int32.Parse(reader["VizitaID"].ToString()); v.PacientiID = Int32.Parse(reader["PacientiID"].ToString()); v.DoktoriID = Int32.Parse(reader["DoktoriID"].ToString()); v.TerminiID = Int32.Parse(reader["TerminiID"].ToString()); v.FaturaID = Int32.Parse(reader["FaturaID"].ToString()); v.Koha = DateTime.Parse(reader["KohaVizites"].ToString()); v.Rekomandimi = reader["Rekomandimi"].ToString(); v.Terapia = reader["Terapia"].ToString(); v.Diagnoza = reader["Diagnoza"].ToString(); vizita.Add(v); } } catch (Exception) { throw; } finally { connect.Close(); } return(vizita); }
//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(); } } }