Online Restaurant Website Part 19 Stock Complete

on March 09, 2023

Online Restaurant Website Part 19 Stock Complete

Hi, Dear's here we learn how to implement PizzaRestaurantDrink Website in Visual Studio using C# ASP.NET MVC. Ilyasoft software company provide full project step by step training on our YouTube Channel ilyasoft software company so now subscribe, share and like for more project base tutorials

In this video we are going to implement Stock Designing + Implementation for more details click here: watch vedio

Note : first download all item ingredient's photo's click here

First we are going to create StockCategoryMV for data model to show data in view. code add below:

> StockCategoryMV Model Code :

using Dblayer;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

namespace PizzaRestaurantDrink.Models

{

public class StockCategoryMV

{

PizzaRestaurentandDrinksDbEntities db = new PizzaRestaurentandDrinksDbEntities();

public StockCategoryMV(int? categoryid)

{

GetItems(categoryid);

}

public string StockCategory { get; set; }

public List<StockItemMV> Lists { get; set; }

public void GetItems(int? categoryid)

{

Lists = new List<StockItemMV>();

foreach (var item in db.StockItemTables.Where(c => c.StockItemCategoryID == categoryid).ToList())

{

var visiblestatus = db.VisibleStatusTables.Find(item.VisibleStatusID).VisibleStatus;

var createdby = db.UserTables.Find(item.CreatedBy_UserID).UserName;

Lists.Add(new StockItemMV()

{

StockItemID = item.StockItemID,

StockItemCategory = item.StockItemCategoryTable.StockItemCategory,

ItemPhotoPath = item.ItemPhotoPath,

StockItemTitle = item.StockItemTitle,

ItemSize = item.ItemSize,

UnitPrice = item.UnitPrice,

RegisterDate = item.RegisterDate,

VisibleStatus = visiblestatus,

CreatedBy = createdby,

OrderType = item.OrderTypeTable.OrderType,

});

}

> CRU_StockItemMV Model Code : // To Create and get to list of select item.

using Dblayer;

using System;

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations;

using System.ComponentModel.DataAnnotations.Schema;

using System.Linq;

using System.Web;

namespace PizzaRestaurantDrink.Models

{

public class CRU_StockItemMV

{

PizzaRestaurentandDrinksDbEntities db = new PizzaRestaurentandDrinksDbEntities();

public CRU_StockItemMV()

{

GetCategory();

}

public CRU_StockItemMV(int? id)

{

GetCategory();

var edit = db.StockItemTables.Find(id);

if (edit != null)

{

StockItemID = edit.StockItemID;

StockItemCategoryID = edit.StockItemCategoryID;

ItemPhotoPath = edit.ItemPhotoPath;

StockItemTitle = edit.StockItemTitle;

ItemSize = edit.ItemSize;

UnitPrice = edit.UnitPrice;

VisibleStatusID = edit.VisibleStatusID;

OrderTypeID = edit.OrderTypeID;

}

else

{

StockItemID = 0;

StockItemCategoryID = 0;

ItemPhotoPath = string.Empty;

StockItemTitle = string.Empty;

ItemSize = string.Empty;

UnitPrice = 0;

RegisterDate = DateTime.Now;

VisibleStatusID = 0;

OrderTypeID = 0;

}

public int StockItemID { get; set; }

[Required(ErrorMessage ="Required*")]

public int StockItemCategoryID { get; set; }

public string ItemPhotoPath { get; set; }