//čitanje korištenjem zajedničke klase PristupPodacima
protected void UcitajAnkete2()
{
string cmdstr = "select * from studenti " + SqlWhere();
gvStudenti.DataSource = PristupPodacima.VratiDataTable(cmdstr, paramTrazi);
gvStudenti.DataBind();
}
//Tipka za filtriranje Spola pomoću odabira sa radio-buttona
protected void Button3_Click(object sender, EventArgs e)
{
if (RadioButton1.Checked)
{
string cmdstr = "";
try
{
tbTrazi.Text = "";
lbBrojZapisa.Text = "";
cmdstr = "select * from user.studenti where spol='m'";
gvStudenti.DataSource = PristupPodacima.VratiDataTable(cmdstr, paramTrazi);
gvStudenti.DataBind();
}
catch
{
tbTrazi.Text = "Nema studenata!";
}
}
if (RadioButton2.Checked)
{
string cmdstr = "";
try
{
tbTrazi.Text = "";
lbBrojZapisa.Text = "";
cmdstr = "select * from user.studenti where spol='z'";
gvStudenti.DataSource = PristupPodacima.VratiDataTable(cmdstr, paramTrazi);
gvStudenti.DataBind();
}
catch
{
tbTrazi.Text = "Nema studentica!";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
Obrada();
gvImenik.DataSource = Imenik;
gvImenik.DataBind();
if (!IsPostBack)
{
//prihvat parametara ako se radi o editiranju postojece forme
string editId = Request.QueryString["editId"];
if (editId != null)
{
//dohvat i popunjavanje ankete
object[] parametri = { editId };
string cmdstr = "select ime_i_prezime, email, oib, spol, adresa, hobiji, boje from studenti ";
cmdstr += "where id = " + editId;
DataTable dt = PristupPodacima.VratiDataTable(cmdstr, parametri);
//popunjavanje forme
tbId.Text = editId;
tbImeIPrezime.Text = dt.Rows[0]["ime_i_prezime"].ToString();
tbEmail.Text = dt.Rows[0]["email"].ToString();
tbOIB.Text = dt.Rows[0]["oib"].ToString();
rbSpol.SelectedValue = dt.Rows[0]["spol"].ToString();
tbAdresa.Text = dt.Rows[0]["adresa"].ToString();
//dodati još petlje za hobije i boje
}
}
}
//tipka za filtriranje Godine
protected void Button4_Click(object sender, EventArgs e)
{
if (RadioButton3.Checked)
{
string cmdstr = "";
try
{
tbTrazi.Text = "";
lbBrojZapisa.Text = "";
cmdstr = "select * from user.studenti where godina='1'";
gvStudenti.DataSource = PristupPodacima.VratiDataTable(cmdstr, paramTrazi);
gvStudenti.DataBind();
}
catch
{
tbTrazi.Text = "Nema 1. godine!";
}
}
if (RadioButton4.Checked)
{
string cmdstr = "";
try
{
tbTrazi.Text = "";
lbBrojZapisa.Text = "";
cmdstr = "select * from user.studenti where godina='2'";
gvStudenti.DataSource = PristupPodacima.VratiDataTable(cmdstr, paramTrazi);
gvStudenti.DataBind();
}
catch
{
tbTrazi.Text = "Nema 2. godine!";
}
}
if (RadioButton5.Checked)
{
string cmdstr = "";
try
{
tbTrazi.Text = "";
lbBrojZapisa.Text = "";
cmdstr = "select * from user.studenti where godina='3'";
gvStudenti.DataSource = PristupPodacima.VratiDataTable(cmdstr, paramTrazi);
gvStudenti.DataBind();
}
catch
{
tbTrazi.Text = "Nema 3. godine!";
}
}
}
//tipka za kombinaciju uvjeta filtriranja omogućava
//filtriranje prema unesenoj riječi i prema godini studija
protected void Button7_Click(object sender, EventArgs e)
{
using (MySqlConnection sqlConn = new MySqlConnection(
ConfigurationManager.ConnectionStrings["defaultConnectionString"].ConnectionString))
{
string cmdstr = "";
try
{
lbBrojZapisa.Text = "";
cmdstr = "select * from user.studenti where studenti.godina='" + tbTrazi.Text + "';";
gvStudenti.DataSource = PristupPodacima.VratiDataTable(cmdstr, paramTrazi);
gvStudenti.DataBind();
}
catch
{
tbTrazi.Text = "Nema rezultata!";
}
}
}
