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;
}
