public Upit getUpitID(int _id)
{
connection();
Upit upit = new UPit();
con.ConnectionString = str;
using (MySqlCommand cmd = new MySqlCommand())
{
cmd.Connection = con;
cmd.CommandText = "SELECT id_upit,id_stanar,datum,naslov,opis,dogovoreno FROM upit WHERE id=+@id";
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@id", _id);
con.Open();
using (MySqlDataReader sdr = cmd.ExecuteReader())
{
if (sdr.HasRows)
{
while (sdr.Read())
{
upit = new Upit()
{
id_upit = Convert.ToInt32(sdr["id_upit"]),
id_stanar = Convert.ToInt32(sdr["id_stanar"]),
datum = sdr["datum"].datetime(),
naslov = sdr["naslov"].ToString(),
opis = sdr["opis"].ToString(),
dogovoreno = sdr["dogovoreno"].ToString()
};
}
}
}
con.Close();
}
return(upit);
}
public string updateUpit(Upit data)
{
try
{
connection();
using (MySqlCommand cmd = new MySqlCommand())
{
cmd.Connection = con;
cmd.CommandText = "UPDATE upit SET id_upit = @id_upit, id_stanar = @id_stanar,datum = @datum,naslov = @naslov,opis = @opis,dogovreno = @dogovoreno WHERE id = @id";
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@id_upit", data.id_upit);
cmd.Parameters.AddWithValue("@id_stanar", data.id_stanar);
cmd.Parameters.AddWithValue("@datum", data.datum);
cmd.Parameters.AddWithValue("@naslov", data.naslov);
cmd.Parameters.AddWithValue("@opis", data.opis);
cmd.Parameters.AddWithValue("@dogovoreno", data.dogovoreno);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
return("OK");
}
}
catch (Exception err)
{
con.Close();
return("Error");
}
}
public string addUpit(Upit data)
{
try
{
connection();
using (MySqlCommand cmd = new MySqlCommand())
{
cmd.Connection = con;
cmd.CommandText = "INSERT INTO upit(id_upit,id_stanar,datum,naslov,opis,dogovoreno) " + " VALUES(@id_upit,@id_stanar,@datum,@naslov,@opis,@dogovoreno)";
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@id_upit", data.id_upit);
cmd.Parameters.AddWithValue("@id_stanar", data.id_stanar);
cmd.Parameters.AddWithValue("@datum", data.datum);
cmd.Parameters.AddWithValue("@naslov", data.naslov);
cmd.Parameters.AddWithValue("@opis", data.opis);
cmd.Parameters.AddWithValue("@dogovoreno", data.dogovoreno);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
return("OK");
}
}
catch (Exception err)
{
con.Close();
return("Error");
}
}
public List <upit> GetUpit_2(string searchData)
{
connection();
List <Upit> upit = new List <Upit>();
con.ConnectionString = str;
using (MySqlCommand cmd = new MySqlCommand())
{
cmd.Connection = con;
cmd.CommandText = "SELECT id_upit,id_stanar,datum,naslov,opis,dogovoreno FROM upit WHERE " +
" naslov like '%" + searchData + "%' " +
" ORDER BY id_upit ASC";
con.Open();
using (MySqlDataReader sdr = cmd.ExecuteReader())
{
if (sdr.HasRows)
{
while (sdr.Read())
{
Upit emp = new Upit()
{
id_upit = Convert.ToInt32(sdr["id_upit"]),
id_stanar = Convert.ToInt32(sdr["id_stanar"]),
datum = sdr["datum"].datetime(),
naslov = sdr["naslov"].ToString(),
opis = sdr["opis"].ToString(),
dogovoreno = sdr["dogovoreno"].ToString()
};
if (emp.naslov.Length > 0)
{
upit.Add(emp);
}
}
}
}
con.Close();
}
return(upit);
}