public List <Veterinar> GetAllVets()
{
List <Veterinar> all = new List <Veterinar>();
using (SqlConnection sqlConnection = new SqlConnection(Constants.connectionString))
{
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandText = "SELECT * FROM Vets";
sqlConnection.Open();
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
while (sqlDataReader.Read())
{
Veterinar v = new Veterinar();
v.Id = sqlDataReader.GetInt32(0);
v.FullName = sqlDataReader.GetString(1);
v.Speciality = sqlDataReader.GetString(2);
v.Expirience = sqlDataReader.GetInt32(3);
all.Add(v);
}
}
return(all);
}
private void btnDodajVeterinara_Click(object sender, EventArgs e)
{
if (txtVeterinarIme.Text == "" || txtVeterinarPrezime.Text == "" || txtVeterinarUsername.Text == "" || txtVeterinarPassword.Text == "")
{
MessageBox.Show("Unesite lepo podatke o veterinaru.");
return;
}
Veterinar v = new Veterinar();
v.ime = txtVeterinarIme.Text;
v.prezime = txtVeterinarPrezime.Text;
v.telefon = txtVeterinarTelefon.Text;
v.mail = txtVeterinarMail.Text;
v.username = txtVeterinarUsername.Text;
v.password = txtVeterinarPassword.Text;
v.adresa = txtVeterinarAdresa.Text;
v.titula = txtVeterinarTitula.Text;
v.pregledi = new List <Pregled>();
v.idVeterinar = Int32.Parse(nadjiMaxIdVeterinar()) + 1;
Dictionary <string, object> queryDict = new Dictionary <string, object>();
var query = new Neo4jClient.Cypher.CypherQuery("CREATE (n:Veterinar {idVeterinar:'" + v.idVeterinar + "', ime:'" + v.ime + "', prezime:'" + v.prezime
+ "', username: '******', password: '******', adresa: '" + v.adresa + "', titula: '" + v.titula +
"', telefon:'" + v.telefon + "', mail:'" + v.mail
+ "'}) return n",
queryDict, CypherResultMode.Set);
((IRawGraphClient)client).ExecuteGetCypherResults <Veterinar>(query).ToList();
MessageBox.Show("Uspesno ste dodali novog veterinara. Id: " + v.idVeterinar.ToString());
}
public List <Veterinar> GetAllVeterinars()
{
List <Veterinar> veterinars = new List <Veterinar>();
using (SqlConnection sqlConnection = new SqlConnection())
{
sqlConnection.ConnectionString = Constants.connString;
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandText = "SELECT * FROM Veterinari";
sqlConnection.Open();
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
while (sqlDataReader.Read())
{
Veterinar v = new Veterinar();
v.Id = sqlDataReader.GetInt32(0);
v.FullName = sqlDataReader.GetString(1);
v.Specialy = sqlDataReader.GetString(2);
v.Years = sqlDataReader.GetInt32(3);
veterinars.Add(v);
}
}
return(veterinars);
}
public bool InsertVet(Veterinar v)
{
if (this.vetRepository.InsertVet(v) > 0)
{
return(true);
}
return(false);
}
//public static Komunikacija Instanca
//{
// get
// {
// if (instanca == null)
// {
// instanca = new Komunikacija();
// }
// return instanca;
// }
//}
public object pronadjiVeterinara(Veterinar veterinar)
{
TransferKlasa transfer = new TransferKlasa();
transfer.operacija = Operacija.PronadjiVeterinara;
transfer.poruka = veterinar;
formater.Serialize(tok, transfer);
transfer = formater.Deserialize(tok) as TransferKlasa;
return(transfer.odgovor);
}
public List <Veterinar> vratiSveVeterinare(Veterinar vet)
{
TransferKlasa transfer = new TransferKlasa();
transfer.operacija = Operacija.VratiSveVeterinare;
transfer.poruka = vet;
formater.Serialize(tok, transfer);
transfer = formater.Deserialize(tok) as TransferKlasa;
return(transfer.odgovor as List <Veterinar>);
}
public int InsertVet(Veterinar v)
{
using (SqlConnection sqlConnection = new SqlConnection(Constants.connectionString))
{
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandText = String.Format("INSERT INTO Vets VALUES('{0}', '{1}', {2})", v.FullName, v.Speciality, v.Expirience);
sqlConnection.Open();
return(sqlCommand.ExecuteNonQuery());
}
}
public override object Izvrsi(OpstiDomenskiObjekat odo)
{
Veterinar v = Sesija.Broker.vratiKonekciju().vratiJedanZaUslovOpsti(odo) as Veterinar;
Osoba o = new Osoba();
o.Id = v.Id;
o = Sesija.Broker.vratiKonekciju().vratiJedanZaID(o) as Osoba;
v.Jmbg = o.Jmbg;
v.Ime = o.Ime;
v.Prezime = o.Prezime;
v.Email = o.Email;
v.Telefon = o.Telefon;
return(v);
}
private void button_Click(object sender, EventArgs e)
{
Veterinar v = new Veterinar();
v.FullName = textBoxName.Text;
v.Speciality = textBoxSpeciality.Text;
v.Expirience = Convert.ToInt32(textBoxExpirience.Text);
if (this.vetBusiness.InsertVet(v))
{
RefreshData();
textBoxName.Clear();
textBoxSpeciality.Clear();
textBoxExpirience.Clear();
}
else
{
MessageBox.Show("Greska pri upisu!");
}
}
public int InsertVeterinar(Veterinar v)
{
List <Veterinar> veterinars = new List <Veterinar>();
using (SqlConnection sqlConnection = new SqlConnection())
{
sqlConnection.ConnectionString = Constants.connString;
sqlConnection.Open();
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandText = string.Format(
"INSERT INTO Veterinari VALUES ('{0}','{1}',{2})"
, v.FullName, v.Specialy, v.Years
);
return(sqlCommand.ExecuteNonQuery());
}
}
private void buttonDodaj_Click(object sender, EventArgs e)
{
Veterinar v = new Veterinar();
v.FullName = textBoxIme.Text;
v.Specialy = textBoxSpecijalnost.Text;
v.Years = Convert.ToInt32(textBoxGod.Text);
bool result = this.veterinarBussiness.InsertVeterinar(v);
if (result)
{
FillList();
MessageBox.Show("Uspesan unos!");
textBoxIme.Text = " ";
textBoxSpecijalnost.Text = " ";
textBoxGod.Text = " ";
}
else
{
MessageBox.Show("Neuspesan unos!");
}
}
public static VrstaPostupka CreateVrstaPostupka(Veterinar veterinar, string naziv, string opis, double cijena, bool aktivno)
{
return(new VrstaPostupka(veterinar, naziv, opis, cijena, aktivno));
}
public static VrstaZivotinje CreateVrstaZivotinje(Veterinar veterinar, string vrsta, bool aktivno)
{
return(new VrstaZivotinje(veterinar, vrsta, aktivno));
}
public static LijekKodVeterinara CreateLijekKodVeterinara(Lijek lijek, Veterinar veterinar, double cijena, bool aktivno, string napomena)
{
return(new LijekKodVeterinara(lijek, veterinar, cijena, aktivno, napomena));
}
public FrmPocetna(Veterinar vet)
{
InitializeComponent();
// veterinar = vet;
lblVet.Text += vet.Ime + " " + vet.Prezime;
}
