public static Cart GetCartElements(User user)
{
SqlCommand vSQLcommand;
SqlDataReader vSQLreader;
Cart actualCart = new Cart();
actualCart.User = user;
try
{
using (SqlConnection objSQLconn = new SqlConnection(WebConfigurationManager.ConnectionStrings["movies"].ConnectionString))
{
objSQLconn.Open();
string query = "SELECT movies.Id as id_movie, movies.Price, Title, Description, Start, calelements.Id as id_calel";
query += " FROM cart";
query += " INNER JOIN calelements";
query += " ON cart.Id_CalElement = calelements.Id";
query += " INNER JOIN movies";
query += " ON calelements.id_Movie = movies.Id";
query += " WHERE cart.Id_User = @userId";
vSQLcommand = new SqlCommand(query, objSQLconn);
vSQLcommand.Parameters.AddWithValue("@userId", user.Id);
vSQLreader = vSQLcommand.ExecuteReader();
vSQLcommand.Dispose();
while (vSQLreader.Read())
{
Movie m = new Movie();
m.Id = (int)vSQLreader["id_movie"];
m.Title = (string)vSQLreader["Title"];
m.Description = (string)vSQLreader["Description"];
m.Price = (double)vSQLreader["Price"];
CalenderElement c = new CalenderElement();
c.Start = Convert.ToDateTime(vSQLreader["Start"].ToString());
c.Id = (int)vSQLreader["id_calel"];
c.Movie = m;
actualCart.Add(c);
}
vSQLreader.Close();
return(actualCart);
}
}
catch (Exception e)
{
throw new Exception("Fehler beim Ausführen der Datenbankselektion. Bitte InnerException beachten für Fehlerdetails.", e);
}
}
public ActionResult IndexPost()
{
try
{
User user = new User();
user.Id = 1;
user.Username = "******"; //TODO: User aus Session nehmen!!
CalenderElement calElement = CalenderElementManager.GetCalenderElementWithId(Int32.Parse(Request.Form["id"]));
CartManager.AddElementToCart(calElement, user);
ViewBag.Message = "Film " + calElement.Movie.Title + " mit Startzeit " + calElement.Start + " wurde zu Ihrem Einkaufswagen hinzugefügt.";
}
catch (Exception e)
{
ViewBag.Message = "Fehler: " + e.Message;
}
List <CalenderElement> elements = CalenderElementManager.GetAllCalenderElements();
return(View(elements));
}
public static List <CalenderElement> GetAllCalenderElements()
{
SqlCommand vSQLcommand;
SqlDataReader vSQLreader;
List <CalenderElement> returnList = new List <CalenderElement>();
try
{
using (SqlConnection objSQLconn = new SqlConnection(WebConfigurationManager.ConnectionStrings["movies"].ConnectionString))
{
objSQLconn.Open();
string query = "SELECT movies.Id as id_movie, movies.Price, Title, Description, Start, calelements.Id as id_calel";
query += " FROM calelements INNER JOIN movies";
query += " ON calelements.id_Movie = movies.Id;";
vSQLcommand = new SqlCommand(query, objSQLconn);
vSQLreader = vSQLcommand.ExecuteReader();
vSQLcommand.Dispose();
while (vSQLreader.Read())
{
Movie m = new Movie();
m.Id = (int)vSQLreader["id_movie"];
m.Title = (string)vSQLreader["Title"];
m.Description = (string)vSQLreader["Description"];
m.Price = (double)vSQLreader["Price"];
CalenderElement c = new CalenderElement();
c.Start = Convert.ToDateTime(vSQLreader["Start"].ToString());
c.Id = (int)vSQLreader["id_calel"];
c.Movie = m;
returnList.Add(c);
}
vSQLreader.Close();
return(returnList);
}
}
catch (Exception e)
{
throw new Exception("Fehler beim Ausführen der Datenbankselektion. Bitte InnerException beachten für Fehlerdetails.", e);
}
}
public static bool AddElementToCart(CalenderElement calEl, User user)
{
SqlCommand vSQLcommand;
try
{
using (SqlConnection objSQLconn = new SqlConnection(WebConfigurationManager.ConnectionStrings["movies"].ConnectionString))
{
int anz = 0;
objSQLconn.Open();
vSQLcommand = new SqlCommand("INSERT INTO cart (Id_CalElement, Id_User) VALUES (@idElement, @idUser); ", objSQLconn);
vSQLcommand.Parameters.AddWithValue("@idElement", calEl.Id);
vSQLcommand.Parameters.AddWithValue("@idUser", user.Id);
anz = vSQLcommand.ExecuteNonQuery();
vSQLcommand.Dispose();
return(anz > 0);
}
}
catch (Exception e)
{
throw new Exception("Fehler beim Hinzufügen des Elementes zum Einkaufswagen. Bitte InnerException beachten für Fehlerdetails.", e);
}
}
