public static void IzmeniStatus(int id_zadatka, ZStatus status)
{
using (OracleCommand cmd = new OracleCommand("P_ZADATAK.Izmeni_Status", DBConnection.con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new OracleParameter("p_id", OracleDbType.Decimal, ParameterDirection.Input));
cmd.Parameters.Add(new OracleParameter("p_status", OracleDbType.Decimal, ParameterDirection.Input));
cmd.Parameters.Add(new OracleParameter("p_user", OracleDbType.Varchar2, ParameterDirection.Input));
cmd.Parameters["p_id"].Value = id_zadatka;
cmd.Parameters["p_status"].Value = status;
cmd.Parameters["p_user"].Value = Korisnik.KorisnickoIme;
cmd.ExecuteNonQuery();
}
}
public static List <Zadatak> VratiZadatkeFaze(int id_faze)
{
using (OracleCommand cmd = new OracleCommand("P_ZADATAK.Vrati_Zadatke_Faze", DBConnection.con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new OracleParameter("zadaci", OracleDbType.RefCursor, ParameterDirection.ReturnValue));
cmd.Parameters.Add(new OracleParameter("faza_id", OracleDbType.Varchar2, ParameterDirection.Input));
cmd.Parameters["faza_id"].Value = id_faze;
OracleDataReader dr = cmd.ExecuteReader();
List <Zadatak> zadaci = new List <Zadatak>();
while (dr.Read())
{
int id = (int)dr.GetDecimal(0);
string ime = dr.GetString(1);
string opis = dr.IsDBNull(2) ? null : dr.GetString(2);
ZStatus status = (ZStatus)dr.GetDecimal(3);
DateTime?pocetak = dr.IsDBNull(4) ? (DateTime?)null : dr.GetDateTime(4);
DateTime?kraj = dr.IsDBNull(5) ? (DateTime?)null : dr.GetDateTime(5);
ZTip tip = (ZTip)dr.GetDecimal(6);
Zadatak zad = new Zadatak()
{
Id = id,
Ime = ime,
Opis = opis,
Status = status,
PocetakIzrade = pocetak,
KrajIzrade = kraj,
Tip = tip
};
zadaci.Add(zad);
}
dr.Close();
return(zadaci);
}
}
public object Convert(object value, Type targetType, object parameter, CultureInfo culture)
{
ZStatus status = (ZStatus)value;
if (status == ZStatus.NotStarted)
{
return(new SolidColorBrush(Colors.Gray));
}
else if (status == ZStatus.InProgress)
{
return(new SolidColorBrush(Colors.Green));
}
else if (status == ZStatus.Finished)
{
return(new SolidColorBrush(Colors.SteelBlue));
}
else
{
return(new SolidColorBrush(Colors.Red));
}
}
