Skip to content

BeesabathiniV/bluetapecrew

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

BlueTapeCrew

N|Solid

BlueTapeCrew is a client website from my freelancing days

I was far less experienced when I initially pushed this to production and have been improving the source gradually over time.

12-21-2019 - ASP.NET 4.5 to .NET Core 3.1 Migration Complete

Features

  • Front end based on KeenThemes Metronic Store Template
  • Paypal integration
  • Mobile Repsonsive
  • Client Accessable Admin
  • Built in Image Handling
  • SSL
  • GMail SMTP

Tech

BlueTapeCrew uses a typical .NET stack:

  • Anemic Domain Model W/Service Layer
  • Dependency Injection
  • I did not use an existing schema or site design.
  • ASP.NET Core MVC
  • SQL Server
  • Razor
  • AngularJS
  • JQuery
  • HTML5
  • CSS

Development

*I am open to contributions, and you are welcome to use the site code with one caveat; the Admin contains elements from a purchased templates, you must purchase a license from KeenThemes (Metronic Admin Template)

Roadmap

  • Impliment Admin & Client Side SPA w/modern Javascript Framework
  • Social Logins: (as of 12/21 broken from .NET Core config)
  • Write Unit tests
  • Configure Scope of DI Container
  • Add support for multi-tenancy
  • Strip template elements from Admin
  • Complete Admin functionality so site is fully configurable from UI
  • Complete de-branding of the source
  • Replace stored procedures and views with ORM queries

Installation

Environment

IDE: Visual Studio 2019 .NET Core Version: 3.1

Connetion String

  • DefaultConnection

Databae Migrations

Add Code-First Migration from Package Manager Console (You will have to do this once for each connection string. Follow the prompts in package manager console)

$ Add-Migration "[DESCRIPTION]"

Update Database

$ Update-Database

SQL Server Stored Procedures and Views

You will need to create these stored procedures and Views on your SQL Database:

CartView View

create view [dbo].[CartView] AS
SELECT Cart.Id AS Id,CartId, [Count] As Quantity,Styles.ProductId,ProductName,LinkName,Price, StyleId,Colors.ColorText,Products.[Description],
CONCAT('Color: ',ColorText,'; Size: ',SizeText) As StyleText,
([Count] * Price) AS SubTotal,CartImages.ImageData as ImageData
FROM Cart INNER JOIN Styles ON Cart.StyleId = Styles.Id
	INNER JOIN Products ON Styles.ProductId = Products.Id
	INNER JOIN Sizes On Styles.SizeId = Sizes.Id
	INNER JOIN Colors On Styles.ColorId = Colors.Id
	Left JOIN CartImages On CartImages.ProductId = Products.Id

StyleView View

create view [dbo].[StyleView] as
select Styles.Id as Id,ProductId,SizeId,SizeOrder,SizeText,ColorId,ColorText,Price,SizeText + ' / ' + ColorText AS StyleText
from Styles inner join Sizes ON SizeId = Sizes.id
			inner join Colors on ColorId = Colors.Id

About

.NET Core Web Store (Freelance Project)

Resources

Stars

Watchers

Forks

Packages

No packages published

Languages

  • CSS 42.3%
  • C# 32.0%
  • HTML 14.6%
  • JavaScript 11.1%