User talk:Zokssss

public DataTable GetAllActors {   return ExecuteQuery("SELECT * FROM Glumac ORDER BY GlumacID;"); } private void LoadAllActors {   listView.Items.Clear; DataTable dataTable = database.GetAllActors; foreach(DataRow dataRow in dataTable.Rows) {       ListViewItem item = listView.Items.Add(dataRow["GlumacID"].ToString); item.SubItems.Add(dataRow["Ime"].ToString); item.SubItems.Add(dataRow["Prezime"].ToString); item.SubItems.Add(((DateTime)dataRow["DatumRodjenja"]).ToShortDateString); item.SubItems.Add(dataRow["MestoRodjenja"].ToString);

item.Tag = (int)dataRow["GlumacID"]; } }

CREATE TABLE Nagrada ( NagradaID INT NOT NULL PRIMARY KEY, Naziv Text NOT NULL, GodinaPocetka INT );

CREATE TABLE Nagradjen ( NagradjenID INT NOT NULL PRIMARY KEY, FilmID SHORT NOT NULL, NagradaID INT NOT NULL, GodinaDobijanja INT NOT NULL );

ALTER TABLE Nagradjen ADD CONSTRAINT FKNagrada FOREIGN KEY (FilmID) REFERENCES FILM(FilmID);

ALTER TABLE Nagradjen ADD CONSTRAINT FKNagrada FOREIGN KEY (NagradaID) REFERENCES Nagrada(NagradaID); 2

public DataTable GetActor(int id) {   return ExecuteQuery(string.Format("SELECT * FROM GLUMAC WHERE GlumacID = {0};", id));

private void LoadActor(int id) {   DataTable dataTable = database.GetActor(id); if(dataTable.Rows.Count > 0) {       DataRow dataRow = dataTable.Rows[0]; firstNameTextBox.Text = dataRow["Ime"].ToString; lastNameTextBox.Text = dataRow["Prezime"].ToString; birthDateTextBox.Text = ((DateTime)dataRow["DatumRodjenja"]).ToShortDateString; birthPlaceTextBox.Text = dataRow["MestoRodjenja"].ToString; }   else {       firstNameTextBox.Clear; lastNameTextBox.Clear; birthDateTextBox.Clear; birthPlaceTextBox.Clear; } }

private void idTextBox_Leave(object sender, EventArgs e) { int id = 0; if(int.TryParse(idTextBox.Text, out id)) {       LoadActor(id); } }

public int InsertActor(int id, string firstName, string lastName, DateTime birthDate, string birthPlace) {   return ExecuteNonQuery(string.Format("INSERT INTO Glumac (GlumacID, Ime, Prezime, DatumRodjenja, MestoRodjenja) VALUES({0}, '{1}', '{2}', #{3}#, '{4}');", id, firstName, lastName, birthDate.ToShortDateString, birthPlace)); }

public int DeleteActor(int id) {   return ExecuteNonQuery(string.Format("DELETE FROM Glumac WHERE GlumacID = {0};", id)); }

public int UpdateActor(int id, string firstName, string lastName, DateTime birthDate, string birthPlace) {   return ExecuteNonQuery(string.Format("UPDATE Glumac SET Ime = '{0}', Prezime = '{1}', DatumRodjenja = #{2}#, MestoRodjenja = '{3}' WHERE GlumacID = {4};", firstName, lastName, birthDate.ToShortDateString, birthPlace, id)); }

b13/14
public static DataTable ExecuteQuery(string query) {           DataTable dt = new DataTable; using (SqlConnection connection = new SqlConnection(Properties.Settings.Default.B17ConnectionString)) {               using (SqlCommand command = new SqlCommand(query, connection)) {                   connection.Open; using (SqlDataReader reader = command.ExecuteReader) {                       dt.Load(reader); }               }            }            return dt; }       public static int ExecuteNonQuery(string query) {           int rowsAffected = 0; using (SqlConnection connection =               new SqlConnection(Properties.Settings.Default.B17ConnectionString)) {               connection.Open; using (SqlCommand command = new SqlCommand(query, connection)) {                   rowsAffected = command.ExecuteNonQuery; }           }            return rowsAffected; }   } }

CREATE TABLE Izdavac ( IzdavacID INT NOT NULL PRIMARY KEY, Izdavac TEXT, Grad TEXT );

CREATE TABLE Izdanje ( KnjigaID SHORT NOT NULL, BrojIzdanja INT NOT NULL, IzdavacID INT, Cena SINGLE, CONSTRAINT PKIzdanje PRIMARY KEY (KnjigaID, BrojIzdanja), CONSTRAINT FKKnjiga FOREIGN KEY (KnjigaID) REFERENCES Knjiga(KnjigaID), CONSTRAINT FKIzdavac FOREIGN KEY (IzdavacID) REFERENCES Izdavac(IzdavacID) );

public DataTable GetBook(int id) {   return ExecuteQuery(string.Format("SELECT Naziv, BrojStrana, KategorijaID, Komentar FROM KNJIGA WHERE KnjigaID = {0};", id)); }

public int InsertBook(short id, string title, short pageCount, short categoryID, string comment) {   return ExecuteNonQuery(string.Format("INSERT INTO KNJIGA (KnjigaID, Naziv, BrojStrana, KategorijaID, Komentar) VALUES ({0}, '{1}', {2}, {3}, '{4}');", id, title, pageCount, categoryID, comment)); }

public int DeleteBook(short id) {   return ExecuteNonQuery(string.Format("DELETE FROM KNJIGA WHERE KnjigaID = {0};", id)); }

public DataTable GetAllCategories {   return ExecuteQuery("SELECT KategorijaID, Naziv FROM KATEGORIJA ORDER BY Naziv;");

private void BookForm_Load(object sender, EventArgs e) { categoryComboBox.DropDownStyle = ComboBoxStyle.DropDownList; categoryComboBox.DisplayMember = "Naziv"; categoryComboBox.ValueMember = "KategorijaID"; categoryComboBox.DataSource = database.GetAllCategories; }

private void radioButton_CheckedChanged(object sender, EventArgs e) { if(insertRadioButton.Checked) {       titleTextBox.Enabled = true; pageCountTextBox.Enabled = true; categoryComboBox.Enabled = true; commentTextBox.Enabled = true;

insertButton.Enabled = true; deleteButton.Enabled = false; }   else if(deleteRadioButton.Checked) {       titleTextBox.Enabled = false; pageCountTextBox.Enabled = false; categoryComboBox.Enabled = false; commentTextBox.Enabled = false;

insertButton.Enabled = false; deleteButton.Enabled = true; } }

private void idTextBox_TextChanged(object sender, EventArgs e) { int id = 0; if(int.TryParse(idTextBox.Text, out id)) {       DataTable dataTable = database.GetBook(id); if (dataTable.Rows.Count > 0) {           DataRow bookDataRow = dataTable.Rows[0]; titleTextBox.Text = bookDataRow["Naziv"].ToString; pageCountTextBox.Text = bookDataRow["BrojStrana"].ToString; categoryComboBox.SelectedValue = (short)bookDataRow["KategorijaID"]; commentTextBox.Text = bookDataRow["Komentar"].ToString; }       else {           titleTextBox.Clear; pageCountTextBox.Clear; categoryComboBox.SelectedIndex = 0; commentTextBox.Clear; }   }            }

b5/6
CREATE TABLE Takmicenje ( TakmicenjeID INT NOT NULL PRIMARY KEY, Naziv TEXT NOT NULL );

CREATE TABLE Utakmica {( UtakmicaID INT NOT NULL PRIMARY KEY, DomacinID INT NOT NULL, GostID INT NOT NULL, DatumOdigravanja DATETIME, VremeOdigravanja DATETIME, TakmicenjeID INT NOT NULL, CONSTRAINT FKDomacinID FOREIGN KEY (DomacinID) REFERENCES Klub(KlubID), CONSTRAINT FKGostID FOREIGN KEY (GostID) REFERENCES Klub(KlubID), CONSTRAINT FKTakmicenjeID FOREIGN KEY (TakmicenjeID) REFERENCES Takmicenje(TakmicenjeID) )};

CREATE TABLE Statistika { IgracID INT NOT NULL, UtakmicaID INT NOT NULL, BrojZutihKartona INT, BrojCrvenihKartona INT, BrojGolova INT, NapravioFaula INT, PrimioFaula INT, CONSTRAINT PKStatistika PRIMARY KEY (IgracID, UtakmicaID), CONSTRAINT FKIgracID FOREIGN KEY (IgracID) REFERENCES Igrac(IgracID), CONSTRAINT FKUtakmicaID FOREIGN KEY (UtakmicaID) REFERENCES Utakmica(UtakmicaID) )};

public DataTable GetAllTowns {   return ExecuteQuery("SELECT * FROM Grad ORDER BY GradID;"); private void LoadAllTowns {   DataTable dataTable = database.GetAllTowns; bindingSource.DataSource = dataTable; }

private void LoadTown {   DataRowView currentTown = (DataRowView)bindingSource.Current; idTextBox.Text = currentTown["GradID"].ToString; townTextBox.Text = currentTown["Grad"].ToString; areaCodeTextBox.Text = currentTown["PozivniBroj"].ToString; zipCodeTextBox.Text = currentTown["PostanskiBroj"].ToString; populationTextBox.Text = currentTown["BrojStanovnika"].ToString; }

private void TownsForm_Load(object sender, EventArgs e) { LoadAllTowns; bindingSource.MoveFirst; LoadTown; } private void newButton_Click(object sender, EventArgs e) { idTextBox.Clear; townTextBox.Clear; areaCodeTextBox.Clear; zipCodeTextBox.Clear; populationTextBox.Clear;

idTextBox.Focus; private void previousButton_Click(object sender, EventArgs e) { if(string.IsNullOrEmpty(idTextBox.Text)) {       bindingSource.MoveFirst; }   else {       if (bindingSource.Position == 0) bindingSource.MoveLast; else bindingSource.MovePrevious;

}   LoadTown; }

private void nextButton_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(idTextBox.Text)) {       bindingSource.MoveLast; }   else {       if (bindingSource.Position == bindingSource.Count - 1) bindingSource.MoveFirst; else bindingSource.MoveNext; }   LoadTown;

public int InsertTown(int id, string town, int areaCode, int zipCode, int population) {   return ExecuteNonQuery(string.Format("INSERT INTO Grad (GradID, Grad, PozivniBroj, PostanskiBroj, BrojStanovnika) VALUES ({0}, '{1}', {2}, {3}, {4});", id, town, areaCode, zipCode, population)); }

public int UpdateTown(int id, string town, int areaCode, int zipCode, int population) {   return ExecuteNonQuery(string.Format("UPDATE Grad SET Grad = '{0}', PozivniBroj = {1}, PostanskiBroj = {2}, BrojStanovnika = {3} WHERE GradID = {4};", town, areaCode, zipCode, population, id)); }

b3/4
public DataTable GetAllActors {   return ExecuteQuery("SELECT * FROM Glumac ORDER BY GlumacID;"); } private void LoadAllActors {   listView.Items.Clear; DataTable dataTable = database.GetAllActors; foreach(DataRow dataRow in dataTable.Rows) {       ListViewItem item = listView.Items.Add(dataRow["GlumacID"].ToString); item.SubItems.Add(dataRow["Ime"].ToString); item.SubItems.Add(dataRow["Prezime"].ToString); item.SubItems.Add(((DateTime)dataRow["DatumRodjenja"]).ToShortDateString); item.SubItems.Add(dataRow["MestoRodjenja"].ToString);

item.Tag = (int)dataRow["GlumacID"]; } }

( NagradaID INT NOT NULL PRIMARY KEY, Naziv Text NOT NULL, GodinaPocetka INT );

CREATE TABLE Nagradjen ( NagradjenID INT NOT NULL PRIMARY KEY, FilmID SHORT NOT NULL, NagradaID INT NOT NULL, GodinaDobijanja INT NOT NULL );

ALTER TABLE Nagradjen ADD CONSTRAINT FKNagrada FOREIGN KEY (FilmID) REFERENCES FILM(FilmID);

ALTER TABLE Nagradjen ADD CONSTRAINT FKNagrada FOREIGN KEY (NagradaID) REFERENCES Nagrada(NagradaID);

public DataTable GetActor(int id) {   return ExecuteQuery(string.Format("SELECT * FROM GLUMAC WHERE GlumacID = {0};", id));

private void LoadActor(int id) {   DataTable dataTable = database.GetActor(id); if(dataTable.Rows.Count > 0) {       DataRow dataRow = dataTable.Rows[0]; firstNameTextBox.Text = dataRow["Ime"].ToString; lastNameTextBox.Text = dataRow["Prezime"].ToString; birthDateTextBox.Text = ((DateTime)dataRow["DatumRodjenja"]).ToShortDateString; birthPlaceTextBox.Text = dataRow["MestoRodjenja"].ToString; }   else {       firstNameTextBox.Clear; lastNameTextBox.Clear; birthDateTextBox.Clear; birthPlaceTextBox.Clear; } }

private void idTextBox_Leave(object sender, EventArgs e) { int id = 0; if(int.TryParse(idTextBox.Text, out id)) {       LoadActor(id); } }

public int InsertActor(int id, string firstName, string lastName, DateTime birthDate, string birthPlace) {   return ExecuteNonQuery(string.Format("INSERT INTO Glumac (GlumacID, Ime, Prezime, DatumRodjenja, MestoRodjenja) VALUES({0}, '{1}', '{2}', #{3}#, '{4}');", id, firstName, lastName, birthDate.ToShortDateString, birthPlace)); }

public int DeleteActor(int id) {   return ExecuteNonQuery(string.Format("DELETE FROM Glumac WHERE GlumacID = {0};", id)); }

public int UpdateActor(int id, string firstName, string lastName, DateTime birthDate, string birthPlace) {   return ExecuteNonQuery(string.Format("UPDATE Glumac SET Ime = '{0}', Prezime = '{1}', DatumRodjenja = #{2}#, MestoRodjenja = '{3}' WHERE GlumacID = {4};", firstName, lastName, birthDate.ToShortDateString, birthPlace, id)); }