public VerhaalViewModel ToViewModel(Verhaal H)
{
VerhaalViewModel V;
int usID = H.AuteurID;
string Titel = H.Titel;
string Desc = H.Beschrijving;
genre Genre = (genre)((int)H.VerhaalGenre);
int ID = H.ID;
V = new VerhaalViewModel(ID, Titel, Desc, Genre, usID);
return(V);
}
public List <Verhaal> GetListVerhalen(int id)
{
List <Verhaal> F = new List <Verhaal>();
Verhaal V = new Verhaal();
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
string query = "SELECT * from Verhaal WHERE AuteurID = @ID";
using (SqlCommand cmd = new SqlCommand(query, conn))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@ID", id);
cmd.ExecuteNonQuery();
SqlDataAdapter adapt = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapt.Fill(ds);
int count = ds.Tables[0].Rows.Count;
//conn.Close();
if (count > 0)
{
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
// get everything from the things and make a new obj
int ID = (int)reader["ID"];
string Titel = (string)reader["Titel"];
string Desc = (string)reader["Beschrijving"];
string genre = ((string)reader["Genre"]);
int AutID = (int)reader["AuteurID"];
// Enum.TryParse(genre, out VerhaalGenres genres);
VerhaalGenres MyGenres = (VerhaalGenres)Enum.Parse(typeof(VerhaalGenres), genre, true);
V = new Verhaal(ID, Titel, Desc, MyGenres, AutID);
F.Add(V);
}
}
}
}
return(F);
}
}
public ActionResult AddVerhaal(VerhaalViewModel V)
{
try
{
int usID = Convert.ToInt32(Session["usID"]);
Verhaal J = new Verhaal(V.ID, V.Titel, V.Beschrijving, (VerhaalGenres)((int)V.Genre), usID);
Repo.AddVerhaal(J);
List <VerhaalViewModel> F = Repo.ToListViewModel(Repo.GetListVerhalen(usID));
return(View("VerhaalPage", F));
}
catch
{
return(View("Nope"));
}
}
public void DeleteVerhaal(Verhaal H)
{
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
string query = "DELETE FROM Verhaal WHERE ID = @id AND AuteurID = @AuteurID";
using (SqlCommand cmd = new SqlCommand(query, conn))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@id", H.ID);
cmd.Parameters.AddWithValue("@AuteurID", H.AuteurID);
cmd.ExecuteNonQuery();
}
conn.Close();
}
}
public void AddVerhaal(Verhaal V)
{
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
string query = "INSERT INTO Verhaal(Titel, Beschrijving, Genre, AuteurID) VALUES (@Titel, @Beschrijving, @Genre, @AuteurID)";
using (SqlCommand cmd = new SqlCommand(query, conn))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@Titel", V.Titel);
cmd.Parameters.AddWithValue("@Beschrijving", V.Beschrijving);
cmd.Parameters.AddWithValue("@Genre", V.VerhaalGenre);
cmd.Parameters.AddWithValue("@AuteurID", V.AuteurID);
cmd.ExecuteNonQuery();
}
conn.Close();
}
}
public void DeleteVerhaal(Verhaal V)
{
this.context.DeleteVerhaal(V);
}
public VerhaalViewModel ToViewModel(Verhaal V)
{
return(context.ToViewModel(V));
}
public void AddVerhaal(Verhaal V)
{
this.context.AddVerhaal(V);
}
