A5 Produzeni Boravak

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Configuration;
namespace A5
{
public partial class Aktivnost : Form
{
DataSet ds = new DataSet();
string ConnectionString =
System.Configuration.ConfigurationManager.ConnectionStrings["conString"].ConnectionSt
ring;
public Aktivnost()
{
InitializeComponent();
}
private void btnIzadji_Click(object sender, EventArgs e)
{
this.Close();
}
private void pictureBox1_Click(object sender, EventArgs e)
{
Statistika sta = new Statistika();
sta.Show();
}
private void Form1_Load(object sender, EventArgs e)
{
PopunicbDan();
Ucitaj();
}
private bool ProveriPolja()
{
if (cbDanUNedelji.Text == string.Empty || txtNaziv.Text==string.Empty)
{
return false;
}
else
{
return true;
}
}
private void ocistiPolja()
{
txtSifra.Clear();
txtNaziv.Clear();
cbDanUNedelji.SelectedIndex = -1;
mtbVremePocetka.Clear();
mtbVremeZavrsetka.Clear();
}
private void PopunicbDan()
{
SqlConnection con = new SqlConnection(ConnectionString);
string sql = "select distinct(Aktivnost.Dan) as dan from Aktivnost";
SqlDataAdapter adapter = new SqlDataAdapter(sql, con);
adapter.Fill(ds, "dan");
DataTable dt = new DataTable();
adapter.Fill(dt);
cbDanUNedelji.DataSource = dt;
cbDanUNedelji.DisplayMember = "dan";
cbDanUNedelji.ValueMember = "dan";
cbDanUNedelji.SelectedIndex = -1;
}
private void Ucitaj()
{
listView1.Clear();
SqlConnection con = new SqlConnection(ConnectionString);
//string sql = "select * from stadion";
string sql = "select Aktivnost.AktivnostID as Sifra,Aktivnost.nazivaktivnosti as " +
"naziv,Aktivnost.dan,Aktivnost.pocetak, Aktivnost.zavrsetak " +
"from aktivnost";
// MessageBox.Show(sql);
/ ds = new DataSet();
/ SqlDataAdapter adapter = new SqlDataAdapter(sql,
con);
adapter.Fill(ds, "Aktivnosti");
string output = "{0,-20}\t{1,-20}\t{2,-20}\t{3,-20}\t{4,-20}";
foreach (DataRow row in ds.Tables["Aktivnosti"].Rows)
{
this.listView1.Items.Add(string.Format(output, row[0], row[1], row[2], row[3],
row[4]));
}
}
private void listView1_DoubleClick(object sender, EventArgs e)
{
int index;
if (listView1.SelectedItems.Count > 0)
{
index = listView1.Items.IndexOf(listView1.SelectedItems[0]);
MessageBox.Show(index.ToString());
txtSifra.Text = ds.Tables["Aktivnosti"].Rows[index][0].ToString();
txtNaziv.Text = ds.Tables["Aktivnosti"].Rows[index][1].ToString();
cbDanUNedelji.Text = ds.Tables["Aktivnosti"].Rows[index][2].ToString();
mtbVremePocetka.Text = ds.Tables["Aktivnosti"].Rows[index][3].ToString();
mtbVremeZavrsetka.Text = ds.Tables["Aktivnosti"].Rows[index][4].ToString();
}
}
private void btnUnesi_Click(object sender, EventArgs e)
{
if (ProveriPolja())
{
string sqlStmt;
SqlConnection cn = null;
SqlCommand cmd = null;
try
{
sqlStmt = "insert into aktivnost (NazivAktivnosti,dan,pocetak,zavrsetak)
values (@NazivAktivnosti,@dan,@pocetak,@zavrsetak)";
cn = new SqlConnection(ConnectionString);
cmd = new SqlCommand(sqlStmt, cn);
cmd.Parameters.Add(new SqlParameter("@NazivAktivnosti", SqlDbType.NVarChar,
50));
cmd.Parameters.Add(new SqlParameter("@dan", SqlDbType.NVarChar, 50));
cmd.Parameters.Add(new SqlParameter("@pocetak", SqlDbType.Time, 50));
cmd.Parameters.Add(new SqlParameter("@zavrsetak", SqlDbType.Time, 50));
cmd.Parameters["@NazivAktivnosti"].Value = txtNaziv.Text;
cmd.Parameters["@dan"].Value = cbDanUNedelji.SelectedValue;
cmd.Parameters["@pocetak"].Value = mtbVremePocetka.Text;
cmd.Parameters["@zavrsetak"].Value = mtbVremeZavrsetka.Text;
cn.Open();
cmd.ExecuteNonQuery();
ocistiPolja();
MessageBox.Show("uspelo je", "izmena u bazi", MessageBoxButtons.OK,
MessageBoxIcon.Information);
Ucitaj();
}
catch (Exception ex)
{
MessageBox.Show("greska" + ex, "izmena u bazi", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
finally
{
cn.Close();
}
}
else
{ MessageBox.Show("polja su prazna", "izmena u bazi", MessageBoxButtons.OK,
MessageBoxIcon.Information); }
}
}
}
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace A5
{
public partial class Statistika : Form
{
DataSet ds;
string ConnectionString =
System.Configuration.ConfigurationManager.ConnectionStrings["conString"].ConnectionSt
ring;
public Statistika()
{
InitializeComponent();
}
private void Izadji2_Click(object sender, EventArgs e)
{
this.Close();
}
private void btnPrikazi_Click(object sender, EventArgs e)
{
string sqlStmt;
SqlConnection cn = null;
SqlCommand cmd = null;
try
{
sqlStmt = "select Aktivnost.Dan as dan,count(*) as broj fr
Aktivnost,Registar_Aktivnosti " + om
"where Registar_Aktivnosti.AktivnostID = Aktivnost.AktivnostID" +
" group by Aktivnost.Dan";
cn = new SqlConnection(ConnectionString);
cmd = new SqlCommand(sqlStmt, cn);
cn.Open();
DataTable dt = new DataTable();
SqlDataReader dr = cmd.ExecuteReader();
dt.Load(dr);
dataGridView1.DataSource = dt;
chart1.DataSource = dt;
chart1.Series[0].Name = "Deca";
chart1.Series["Deca"].XValueMember = "dan";
chart1.Series["Deca"].YValueMembers = "broj";
chart1.ChartAreas["ChartArea1"].AxisX.MajorGrid.Enabled = true;
chart1.ChartAreas["ChartArea1"].AxisY.MajorGrid.Enabled = true;
chart1.Series["Deca"].IsValueShownAsLabel = false;
chart1.Legends[0].Enabled = false;
chart1.Series["Deca"].Color = System.Drawing.Color.Blue;
chart1.Legends[0].Enabled = false;
chart1.DataBind();
MessageBox.Show("uspelo je", "izmena u bazi", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show("greska" + ex, "izmena u bazi", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
finally
{
cn.Close();
}
}
}
}

A5 Produzeni Boravak

Uploaded by

Copyright:

Available Formats

A5 Produzeni Boravak

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

A5 Produzeni Boravak

Uploaded by

Copyright:

Available Formats

using System;

You might also like