public int unesiAdministratora(Administrator a)
{
try
{
String query = "insert into Administrator " +
"values (@id,@Ime,@Prezime,@Username,@Password)";
DBConnectionString s = new DBConnectionString();
using (SqlConnection con = new SqlConnection(s.GetString()))
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = query;
SqlParameter id = new SqlParameter();
id.Value = Convert.ToString(a.ID);
id.ParameterName = "id";
SqlParameter Ime = new SqlParameter();
Ime.Value = a.Ime;
Ime.ParameterName = "Ime";
SqlParameter Prezime = new SqlParameter();
Prezime.Value = a.Prezime;
Prezime.ParameterName = "Prezime";
SqlParameter Username = new SqlParameter();
Username.Value = a.Username;
Username.ParameterName = "Username";
SqlParameter Password = new SqlParameter();
Password.Value = a.Password;
Password.ParameterName = "Password";
cmd.Parameters.Add(id);
cmd.Parameters.Add(Ime);
cmd.Parameters.Add(Prezime);
cmd.Parameters.Add(Username);
cmd.Parameters.Add(Password);
int k = cmd.ExecuteNonQuery();
cmd.Dispose();
return(k);
}
}
catch (Exception e)
{
Debug.WriteLine("Exception: " + e.Message);
return(0);
}
}
public int unesiJelo(Jelo a)
{
try
{
String query = "insert into Jelo " +
"values (@id,@nazivJela,@vrsta,@cijena,@idObjekta)";
DBConnectionString s = new DBConnectionString();
using (SqlConnection con = new SqlConnection(s.GetString()))
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = query;
SqlParameter id = new SqlParameter();
id.Value = Convert.ToString(a.idJela);
id.ParameterName = "id";
SqlParameter nazivJela = new SqlParameter();
nazivJela.Value = a.nazivJela;
nazivJela.ParameterName = "nazivJela";
SqlParameter vrsta = new SqlParameter();
vrsta.Value = a.vrsta;
vrsta.ParameterName = "vrsta";
SqlParameter cijena = new SqlParameter();
cijena.Value = a.cijena;
cijena.ParameterName = "cijena";
SqlParameter idObjekta = new SqlParameter();
idObjekta.Value = a.cijena;
idObjekta.ParameterName = "idObjekta";
cmd.Parameters.Add(id);
cmd.Parameters.Add(nazivJela);
cmd.Parameters.Add(vrsta);
cmd.Parameters.Add(cijena);
cmd.Parameters.Add(idObjekta);
int k = cmd.ExecuteNonQuery();
cmd.Dispose();
return(k);
}
}
catch (Exception e)
{
Debug.WriteLine("Exception: " + e.Message);
return(0);
}
}
public int unesiStavkuNarudzbe(StavkeNarudzbe a)
{
try
{
String query = "insert into StavkeNarudzbe " +
"values (@id,@idKupca,@idObjekta)";
DBConnectionString s = new DBConnectionString();
using (SqlConnection con = new SqlConnection(s.GetString()))
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = query;
SqlParameter id = new SqlParameter();
id.Value = Convert.ToString(a.idNarudzbe);
id.ParameterName = "id";
SqlParameter idKupca = new SqlParameter();
idKupca.Value = a.idNarudzbe;
idKupca.ParameterName = "idKupca";
SqlParameter idObjekta = new SqlParameter();
idObjekta.Value = a.idJela;
idObjekta.ParameterName = "idObjekta";
cmd.Parameters.Add(id);
cmd.Parameters.Add(idKupca);
cmd.Parameters.Add(idObjekta);
int k = cmd.ExecuteNonQuery();
cmd.Dispose();
return(k);
}
}
catch (Exception e)
{
Debug.WriteLine("Exception: " + e.Message);
return(0);
}
}
public int unesiKupca(Kupac a)
{
try
{
String query = "insert into Kupac " +
"values (@id,@Ime,@Prezime,@Adresa,@Telefon,@Username,@Password,@Mail,@Grad)";
DBConnectionString s = new DBConnectionString();
using (SqlConnection con = new SqlConnection(s.GetString()))
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = query;
SqlParameter id = new SqlParameter();
id.Value = Convert.ToString(a.id);
id.ParameterName = "id";
SqlParameter Ime = new SqlParameter();
Ime.Value = a.ime;
Ime.ParameterName = "Ime";
SqlParameter Prezime = new SqlParameter();
Prezime.Value = a.prezime;
Prezime.ParameterName = "Prezime";
SqlParameter Adresa = new SqlParameter();
Adresa.Value = a.adresa;
Adresa.ParameterName = "Adresa";
SqlParameter Telefon = new SqlParameter();
Telefon.Value = a.telefon;
Telefon.ParameterName = "Telefon";
SqlParameter Username = new SqlParameter();
Username.Value = a.username;
Username.ParameterName = "Username";
SqlParameter Password = new SqlParameter();
Password.Value = a.password;
Password.ParameterName = "Password";
SqlParameter Mail = new SqlParameter();
Mail.Value = a.email;
Mail.ParameterName = "Mail";
SqlParameter Grad = new SqlParameter();
Grad.Value = a.grad;
Grad.ParameterName = "Grad";
cmd.Parameters.Add(id);
cmd.Parameters.Add(Ime);
cmd.Parameters.Add(Prezime);
cmd.Parameters.Add(Adresa);
cmd.Parameters.Add(Telefon);
cmd.Parameters.Add(Username);
cmd.Parameters.Add(Password);
cmd.Parameters.Add(Mail);
cmd.Parameters.Add(Grad);
int k = cmd.ExecuteNonQuery();
cmd.Dispose();
return(k);
}
}
catch (Exception e)
{
Debug.WriteLine("Exception: " + e.Message);
return(0);
}
}
