public static bool UpdateKlijent(Klijent k)
{
SqlParameter[] parameters = new SqlParameter[5];
parameters[0] = new SqlParameter("@IDKlijent", SqlDbType.Int)
{
Direction = ParameterDirection.Input,
Value = k.IDKlijent
};
parameters[1] = new SqlParameter("@Naziv", SqlDbType.NVarChar, 30)
{
Direction = ParameterDirection.Input,
Value = k.Naziv
};
parameters[2] = new SqlParameter("@Telefon", SqlDbType.NVarChar, 15)
{
Direction = ParameterDirection.Input,
Value = k.Telefon
};
parameters[3] = new SqlParameter("@Email", SqlDbType.NVarChar, 25)
{
Direction = ParameterDirection.Input,
Value = k.Email
};
parameters[4] = new SqlParameter("@output", SqlDbType.Int)
{
Direction = ParameterDirection.Output
};
SqlHelper.ExecuteDataset(cs, CommandType.StoredProcedure, "AzurirajKlijenta", parameters);
int output = (int)parameters[4].Value;
return(output == 1);
}
public static void AddNewKlijent(Klijent k)
{
SqlParameter[] parameters = new SqlParameter[3];
parameters[0] = new SqlParameter("@Naziv", SqlDbType.NVarChar, 30)
{
Direction = ParameterDirection.Input,
Value = k.Naziv
};
parameters[1] = new SqlParameter("@Telefon", SqlDbType.NVarChar, 15)
{
Direction = ParameterDirection.Input,
Value = k.Telefon
};
parameters[2] = new SqlParameter("@Email", SqlDbType.NVarChar, 25)
{
Direction = ParameterDirection.Input,
Value = k.Email
};
SqlHelper.ExecuteDataset(cs, CommandType.StoredProcedure, "DodajNovogKlijenta", parameters);
}
public Projekt(int idProjekt, string naziv, DateTime datumOtvaranja, Djelatnik voditelj, Klijent klijent, string opisProjekta)
: this(naziv, datumOtvaranja, voditelj, klijent, opisProjekta)
=> IDProjekt = idProjekt;