public CartModelClass GetBookCart(CartModelClass cart)
{
try
{
SqlCommand sqlCommand = new SqlCommand("GetBookCart", sqlConnection);
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@cartId", cart.CardId);
sqlConnection.Open();
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
while (sqlDataReader.Read())
{
cart.Quantity = Convert.ToInt32(sqlDataReader["Quantity"]);
cart.BookId = Convert.ToInt32(sqlDataReader["BookId"]);
}
return(cart);
}
catch (Exception e)
{
throw new Exception("Value is not able to read" + e);
}
finally
{
sqlConnection.Close();
}
}
public CartModelClass DeleteCart(CartModelClass whis)
{
try
{
SqlCommand sqlCommand = new SqlCommand("sp_DeleteCart", sqlConnection);
sqlCommand.Parameters.AddWithValue("@cartId", whis.CardId);
sqlConnection.Open();
sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
return(whis);
}
catch (Exception e)
{
throw new Exception("WishList not Details Added" + e);
}
finally
{
sqlConnection.Close();
}
}
public CartModelClass UpdateCart(CartModelClass whis)
{
return(cart.UpdateCart(whis));
}
public CartModelClass AddCart(CartModelClass whis)
{
return(cart.AddCart(whis));
}
public CartModelClass DeleteCart(CartModelClass whis)
{
return(cart.DeleteCart(whis));
}
public CartModelClass GetBookCart(CartModelClass carthad)
{
return(cart.GetBookCart(carthad));
}
