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