public void CreateShoppingCart(shoppingcartDAO shoppingcartToCreate) { try { using (SqlConnection _connection = new SqlConnection(connectionstring)) { using (SqlCommand _command = new SqlCommand("Sp_CreateShoppingCart", _connection)) { _command.CommandType = CommandType.StoredProcedure; _command.Parameters.AddWithValue("@Albums_ID", shoppingcartToCreate.Albums_ID); _command.Parameters.AddWithValue("@Clothing_ID", shoppingcartToCreate.Clothing_ID); _command.Parameters.AddWithValue("@Instruments_ID", shoppingcartToCreate.Instruments_ID); _command.Parameters.AddWithValue("@User_ID", shoppingcartToCreate.User_ID); _connection.Open(); _command.ExecuteNonQuery(); _connection.Close(); _connection.Dispose(); } } } catch (Exception _Error) { Error_Logger Log = new Error_Logger(); Log.Errorlogger(_Error); } }
public void SendClothingID(shoppingcartDAO clothingidToSend) { int SendClothingID = new int(); try { using (SqlConnection _connection = new SqlConnection(connectionstring)) { using (SqlCommand _command = new SqlCommand("Sp_SendClothingID", _connection)) { _command.CommandType = CommandType.StoredProcedure; _command.Parameters.AddWithValue("@Clothing_ID", clothingidToSend.Clothing_ID); _command.Parameters.AddWithValue("@User_ID", clothingidToSend.User_ID); _connection.Open(); _command.ExecuteNonQuery(); _connection.Close(); } } } catch (Exception _Error) { Error_Logger Log = new Error_Logger(); Log.Errorlogger(_Error); } }
public bool DeleteShoppingCart(shoppingcartDAO cartToDelete) { bool yes = false; try { using (SqlConnection _connection = new SqlConnection(connectionstring)) { using (SqlCommand _command = new SqlCommand("Sp_DeleteShoppingCart", _connection)) { _command.CommandType = CommandType.StoredProcedure; _command.Parameters.AddWithValue("@ShoppingCart_ID", cartToDelete.ShoppingCart_ID); _connection.Open(); _command.ExecuteNonQuery(); yes = true; _connection.Close(); } } } catch (Exception _Error) { Error_Logger Log = new Error_Logger(); Log.Errorlogger(_Error); } if (yes == true) { } return(yes); }
public List <shoppingcartDAO> GetAllShoppingCarts() { List <shoppingcartDAO> _cartList = new List <shoppingcartDAO>(); try { using (SqlConnection _connection = new SqlConnection(connectionstring)) { using (SqlCommand _command = new SqlCommand("Sp_ViewAllShoppingCarts", _connection)) { _command.CommandType = CommandType.StoredProcedure; _connection.Open(); using (SqlDataReader _reader = _command.ExecuteReader()) { while (_reader.Read()) { shoppingcartDAO _cartToList = new shoppingcartDAO(); _cartToList.ShoppingCart_ID = _reader.GetInt32(0); _cartToList.Albums_ID = _reader.GetInt32(1); _cartToList.Clothing_ID = _reader.GetInt32(2); _cartToList.Instruments_ID = _reader.GetInt32(3); _cartToList.User_ID = _reader.GetInt32(4); _cartList.Add(_cartToList); } } } } } catch (Exception _Error) { Error_Logger Log = new Error_Logger(); Log.Errorlogger(_Error); } return(_cartList); }
public List <shoppingcartDAO> GetPrices() { List <shoppingcartDAO> _ListPrices = new List <shoppingcartDAO>(); try { using (SqlConnection _connection = new SqlConnection(connectionstring)) { using (SqlCommand _command = new SqlCommand("Sp_PricePull", _connection)) { _command.CommandType = CommandType.StoredProcedure; _connection.Open(); using (SqlDataReader _reader = _command.ExecuteReader()) { while (_reader.Read()) { shoppingcartDAO _PriceToList = new shoppingcartDAO(); _PriceToList.AlbumPrice = _reader.GetDecimal(0); _PriceToList.ClothingPrice = _reader.GetDecimal(1); _PriceToList.InstrumentsPrice = _reader.GetDecimal(2); _ListPrices.Add(_PriceToList); } } } } } catch (Exception _Error) { Error_Logger Log = new Error_Logger(); Log.Errorlogger(_Error); } return(_ListPrices); }
public void GetAlbumID(shoppingcartDAO albumidToGet) { int GetAlbumID = new int(); try { using (SqlConnection _connection = new SqlConnection(connectionstring)) { using (SqlCommand _command = new SqlCommand("Sp_GetAlbumsID", _connection)) { _command.CommandType = CommandType.StoredProcedure; _command.Parameters.AddWithValue("@Albums_ID", albumidToGet.Albums_ID); _command.Parameters.AddWithValue("@User_ID", albumidToGet.User_ID); _connection.Open(); _command.ExecuteNonQuery(); _connection.Close(); } } } catch (Exception _Error) { Error_Logger Log = new Error_Logger(); Log.Errorlogger(_Error); } }
public ActionResult SendAlbumsID(int _SendID) { shoppingcartDAO cartToSend = new shoppingcartDAO(); cartToSend.Albums_ID = _SendID; cartToSend.User_ID = (int)Session["User_ID"]; _AlbumDataAccess.SendAlbumsID(cartToSend); return(RedirectToAction("AlbumView")); }
public ActionResult GetAlbumID(int _GetID) { shoppingcartDAO cartToGet = new shoppingcartDAO(); cartToGet.Albums_ID = _GetID; cartToGet.User_ID = (int)Session["User_ID"]; _AlbumDataAccess.GetAlbumID(cartToGet); return(RedirectToAction("AlbumView")); }
public ActionResult UpdateShoppingCart(ShoppingCart _CartInfo) { if ((int)Session["Role_ID"] == 3 || (int)Session["Role_ID"] == 2) { shoppingcartDAO _recievedCart = _mapper.SingleShoppingCart(_CartInfo); _shoppingcartDataAccess.UpdateShoppingCart(_recievedCart); } return(RedirectToAction("ShoppingCartView")); }
public ActionResult CreateShoppingCart(ShoppingCart newShoppingCart) { if ((int)Session["Role_ID"] == 3 || (int)Session["Role_ID"] == 2) { shoppingcartDAO CartToCreate = _mapper.SingleShoppingCart(newShoppingCart); _shoppingcartDataAccess.CreateShoppingCart(CartToCreate); } return(RedirectToAction("ShoppingCartView")); }
public ActionResult SendInstrumentID(int _SendID) { shoppingcartDAO cartToSend = new shoppingcartDAO(); cartToSend.Instruments_ID = _SendID; cartToSend.User_ID = (int)Session["User_ID"]; _InstrumentDataAccess.SendInstrumentID(cartToSend); return(RedirectToAction("InstrumentsView")); }
public ActionResult GetInstrumentID(int _GetID) { shoppingcartDAO cartToGet = new shoppingcartDAO(); cartToGet.Instruments_ID = _GetID; cartToGet.User_ID = (int)Session["User_ID"]; _InstrumentDataAccess.GetInstrumentsID(cartToGet); return(RedirectToAction("InstrumentsView")); }
public ActionResult SendClothingID(int _SendID) { shoppingcartDAO cartToSend = new shoppingcartDAO(); cartToSend.Clothing_ID = _SendID; cartToSend.User_ID = (int)Session["User_ID"]; _ClothingDataAccess.SendClothingID(cartToSend); return(RedirectToAction("ClothingView")); }
public ActionResult GetClothingID(int _GetID) { shoppingcartDAO cartToGet = new shoppingcartDAO(); cartToGet.Clothing_ID = _GetID; cartToGet.User_ID = (int)Session["User_ID"]; _ClothingDataAccess.GetClothingID(cartToGet); return(RedirectToAction("ClothingView")); }
public ActionResult DeleteShoppingCart(int Delete_ShoppingCart) { if ((int)Session["Role_ID"] == 3) { shoppingcartDAO _DeleteShoppingCart = new shoppingcartDAO(); _DeleteShoppingCart.ShoppingCart_ID = Delete_ShoppingCart; _shoppingcartDataAccess.DeleteShoppingCart(_DeleteShoppingCart); } return(RedirectToAction("AllShopingCartsView")); }
public ShoppingCart SelectCart(shoppingcartDAO _SelectCartToMap) { ShoppingCart CartToReturn = new ShoppingCart(); { ShoppingCart _cartToView = new ShoppingCart(); _cartToView.ShoppingCart_ID = _SelectCartToMap.ShoppingCart_ID; _cartToView.Albums_ID = _SelectCartToMap.Albums_ID; _cartToView.Clothing_ID = _SelectCartToMap.Clothing_ID; _cartToView.Instruments_ID = _SelectCartToMap.Instruments_ID; _cartToView.User_ID = _SelectCartToMap.User_ID; CartToReturn = _cartToView; } return(CartToReturn); }
public shoppingcartDAO SingleShoppingCart(ShoppingCart _SingleCartToMap) { shoppingcartDAO cartToReturn = new shoppingcartDAO(); { shoppingcartDAO _cartToView = new shoppingcartDAO(); _cartToView.ShoppingCart_ID = _SingleCartToMap.ShoppingCart_ID; _cartToView.Albums_ID = _SingleCartToMap.Albums_ID; _cartToView.Clothing_ID = _SingleCartToMap.Clothing_ID; _cartToView.Instruments_ID = _SingleCartToMap.Instruments_ID; _cartToView.User_ID = _SingleCartToMap.User_ID; cartToReturn = _cartToView; } return(cartToReturn); }
public void CreateShoppingCartOnRegister2(shoppingcartDAO shoppingCartFromRegister2) { try { using (SqlConnection _connection = new SqlConnection(connectionstring)) { using (SqlCommand _command = new SqlCommand("Sp_CreateCartOnRegisterPart2", _connection)) { _command.CommandType = CommandType.StoredProcedure; _command.Parameters.AddWithValue("@User_ID", shoppingCartFromRegister2.User_ID); _connection.Open(); _command.ExecuteNonQuery(); _connection.Close(); _connection.Dispose(); } } } catch (Exception _Error) { Error_Logger Log = new Error_Logger(); Log.Errorlogger(_Error); } }