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