/// <summary>
/// Dodavanje novih dosežkov
/// </summary>
/// <param name="dosezek">Objekt s dosežkom kateroga hočemo dodati v bazo</param>
/// <returns></returns>
public static bool Dodaj(Dosezek dosezek)
{
SqlConnection con = new SqlConnection(Nastavitve.GetConnectionString());
SqlCommand cmd = new SqlCommand();
string into = "[StackDB].[dbo].[tblDosezki]";
string insert = "INSERT INTO " + into + " (Naziv, Nagrada) VALUES ('" +
dosezek.Naziv + "', '" + dosezek.Nagrada + "');";
cmd.CommandText = insert;
cmd.Connection = con;
try
{
con.Open();
cmd.ExecuteNonQuery();
return(true);
}
catch (TimeoutException tEx)
{
// Zapisivanje u log
return(false);
}
catch (Exception ex)
{
// log
return(false);
}
finally
{
con.Close();
}
}
/// <summary>
/// Brskanje dosezkov za pregled
/// </summary>
/// <param name="naziv">brskanje po nazivu dosezka</param>
/// <param name="nagradaMin">donja granica vrednosti nagrade</param>
/// <param name="nagradaMax">zgornja granica vrednosti nagrade</param>
/// <returns>seznam dosezkov</returns>
public static List <Dosezek> Brskaj(string naziv = "", int nagradaMin = -1, int nagradaMax = -1, int idUporabnika = -1, string uporabnisko = "")
{
SqlConnection con = new SqlConnection(Nastavitve.GetConnectionString());
SqlCommand cmd = new SqlCommand();
string where = "1 = 1 ";
where += (naziv.Trim() != "") ? ("AND (Naziv = '" + naziv + "') ") : ("");
where += (nagradaMin != -1) ? ("AND (Nagrada > " + nagradaMin + ") ") : ("");
where += (nagradaMax != -1) ? ("AND (Nagrada < " + nagradaMax + ") ") : ("");
where += (idUporabnika != -1) ? ("AND (UporabnikId = " + idUporabnika + ") ") : ("");
where += (uporabnisko != "") ? ("AND (Uporabnik = '" + uporabnisko + "') ") : ("");
string from = "[StackDB].[dbo].[tblDosezki]";
// 0 1 2
string select = "SELECT Id, Naziv, Nagrada FROM " + from + " WHERE " + where;
// če se brska za nekaterog uporabnika
if (idUporabnika != -1 || uporabnisko != "")
{
from = "[StackDB].[dbo].[viewDosezki]";
// 0 1 2
select = "SELECT DosezekId, Naziv, Nagrada FROM " + from + " WHERE " + where;
}
cmd.CommandText = select;
cmd.Connection = con;
List <Dosezek> lista = new List <Dosezek>();
try
{
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
int id = reader.GetInt32(0);
string nazivDosezka = reader.IsDBNull(1) ? "" : reader.GetString(1).Trim();
int nagrada = reader.IsDBNull(2) ? -1 : reader.GetInt32(2);
Dosezek enota = new Dosezek(id, nazivDosezka, nagrada);
lista.Add(enota);
}
reader.Close();
return(lista);
}
catch (TimeoutException tEx)
{
// Zapisivanje u log
return(null);
}
catch (Exception ex)
{
// log
return(null);
}
finally
{
con.Close();
}
}