public static bool InsertJoke(IJokes joke) { List <parameters> parms = new List <parameters>(); parms.Add(new parameters("@title", joke.Title, SqlDbType.VarChar, ParameterDirection.Input)); parms.Add(new parameters("@teaser", joke.Teaser, SqlDbType.VarChar, ParameterDirection.Input)); parms.Add(new parameters("@jokeText", joke.JokeText, SqlDbType.VarChar, ParameterDirection.Input)); parms.Add(new parameters("@categoryId", joke.CategoryId, SqlDbType.Int, ParameterDirection.Input)); parms.Add(new parameters("@featured", joke.IsFeatured, SqlDbType.Bit, ParameterDirection.Input)); DAL.GetData("addJoke", parms); return(true); }
public static bool UpdateJoke(IJokes joke) { List <parameters> parms = new List <parameters>(); parms.Add(new parameters("@jokeID", joke.JokeId, SqlDbType.Int, ParameterDirection.Input)); parms.Add(new parameters("@title", joke.Title, SqlDbType.VarChar, ParameterDirection.Input)); parms.Add(new parameters("@teaser", joke.Teaser, SqlDbType.VarChar, ParameterDirection.Input)); parms.Add(new parameters("@joke_text", joke.JokeText, SqlDbType.VarChar, ParameterDirection.Input)); parms.Add(new parameters("@category_id", joke.CategoryId, SqlDbType.Int, ParameterDirection.Input)); parms.Add(new parameters("@featured", joke.IsFeatured, SqlDbType.Bit, ParameterDirection.Input)); parms.Add(new parameters("@timestamp", joke.TimeStamp, SqlDbType.Timestamp, ParameterDirection.InputOutput)); DAL.GetData("UpdateJoke", parms); joke.TimeStamp = parms[6].value; return(true); }
//Update Joke public static Boolean UpdateJoke(IJokes jokes) { List <Parms> parms = new List <Parms>(); parms.Add(new Parms("@id", jokes.id, ParameterDirection.Input, SqlDbType.Int)); parms.Add(new Parms("@title", jokes.title, ParameterDirection.Input, SqlDbType.NVarChar, 50)); parms.Add(new Parms("@teaser", jokes.teaser, ParameterDirection.Input, SqlDbType.NVarChar, 150)); parms.Add(new Parms("@joke_text", jokes.joke_text, ParameterDirection.Input, SqlDbType.NText)); parms.Add(new Parms("@created_at", jokes.created_at, ParameterDirection.Input, SqlDbType.Date)); parms.Add(new Parms("@user_id", jokes.user_id, ParameterDirection.Input, SqlDbType.Int)); parms.Add(new Parms("@category_id", jokes.category_id, ParameterDirection.Input, SqlDbType.Int)); parms.Add(new Parms("@featured", jokes.featured, ParameterDirection.Input, SqlDbType.Bit)); DAL.DataAccessLayer.SendData("updateJoke", parms); return(true); }
public JokesController(IJokes r) { repo = r; }
public JokeController(IJokes repository, IMapper mapper) { //inject dep _repository = repository; _mapper = mapper; }