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