public IActionResult Index(int id)
{
ViewData["HeaderBackgroundImg"] = C.Photos.ToList()[58].PhotoPath;
SpecificNewsItemModel S = new SpecificNewsItemModel();
News_Item N = C.News_Items.Where(x => x.NewsID == id).FirstOrDefault();
if (N != null)
{
List <string> Content = (from T in C.Text
join TN in C.Text_News on T.TextID equals TN.TextID
join Nn in C.News_Items on TN.NewsID equals Nn.NewsID
where Nn.NewsID == id
select T.Content).ToList();
S.Content = Content;
S.Item = N;
string PhotoPath = (from Nq in C.News_Items
join NP in C.Photo_News on Nq.NewsID equals NP.NewsID
join P in C.Photos on NP.PhotoID equals P.PhotoID
where Nq.NewsID == id
select P.PhotoPath).FirstOrDefault() + "";
S.PhotoPath = PhotoPath;
}
else
{
S.Content = new List <string>();
S.Item = new News_Item();
S.PhotoPath = "";
}
return(View(S));
}
public async Task <IActionResult> Edit(int id, [Bind("NewsID,Event_Date,Last_Modified_Date,Title,CategoryID")] News_Item news_Item)
{
if (id != news_Item.NewsID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(news_Item);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!News_ItemExists(news_Item.NewsID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["CategoryID"] = new SelectList(_context.News_Categories, "CategoryID", "CategoryID", news_Item.CategoryID);
return(View(news_Item));
}
public void AddDBOTestNewsItem()
{
WebsiteContext C = GetInMemoryDB();
SearchController SC = new SearchController(C);
News_Item P = new News_Item
{
Title = "Cheese"
};
SC.AddDBO(P, new NewsSearch(C));
Assert.Equal("Cheese", SC.DBO.ElementAt(0).GetSearchAbleString());
}
public async Task <IActionResult> Create([Bind("NewsID,Event_Date,Last_Modified_Date,Title,CategoryID")] News_Item news_Item)
{
if (ModelState.IsValid)
{
_context.Add(news_Item);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["CategoryID"] = new SelectList(_context.News_Categories, "CategoryID", "CategoryID", news_Item.CategoryID);
return(View(news_Item));
}
public override void SetObject(object Uknown)
{
if (N == null)
{
N = (News_Item)Uknown;
base.Count();
}
else
{
new ArgumentException("Object already set");
}
}
public override bool Check(object Uknown)
{
if (Uknown.GetType() == typeof(News_Item))
{
News_Item NeedsCheck = (News_Item)Uknown;
if (NeedsCheck.Title == N.Title && NeedsCheck.NewsID == N.NewsID)
{
base.Count();
return(true);
}
}
return(false);
}
public News_Item CustomVsStandardArt()
{
News_Item CustomVsStandardArt = _context.News_Items.Where(p => p.News_Category.Category == "Custom vs standard").FirstOrDefault();
return(CustomVsStandardArt);
}
public static void Seed(WebsiteContext C)
{
Branch_Category Chicken = new Branch_Category
{
Name = "Chicken"
};
Branch_Category Pork = new Branch_Category
{
Name = "Pork"
};
Branch_Category Fruit = new Branch_Category
{
Name = "Fruit"
};
Type_Category ChickenSoup = new Type_Category
{
Name = "ChickenSoup",
BranchCategory = Chicken,
};
Type_Category ChickenEgg = new Type_Category
{
Name = "ChickenEgg",
BranchCategory = Chicken,
};
Chicken.TypeCategory = new List <Type_Category>();
Chicken.TypeCategory.Add(ChickenSoup);
Chicken.TypeCategory.Add(ChickenEgg);
ChickenSoup.BranchCategory = Chicken;
ChickenEgg.BranchCategory = Chicken;
Normal_Category SaltChicken = new Normal_Category
{
Name = "SaltChicken"
};
Normal_Category SweetChicken = new Normal_Category
{
Name = "SweetChicken"
};
Normal_Category NoChicken = new Normal_Category
{
Name = "NoChicken"
};
Normal_Category GingerChicken = new Normal_Category
{
Name = "GingerChicken"
};
ChickenSoup.NormalCategory = new List <Normal_Category>();
ChickenEgg.NormalCategory = new List <Normal_Category>();
ChickenSoup.NormalCategory.Add(SaltChicken);
ChickenSoup.NormalCategory.Add(SweetChicken);
ChickenSoup.NormalCategory.Add(NoChicken);
ChickenEgg.NormalCategory.Add(GingerChicken);
SaltChicken.TypeCategory = ChickenSoup;
SweetChicken.TypeCategory = ChickenSoup;
NoChicken.TypeCategory = ChickenSoup;
GingerChicken.TypeCategory = ChickenEgg;
Recipe ChickenWings = new Recipe
{
Name = "ChickenWings"
};
Recipe ChickenNoodles = new Recipe
{
Name = "ChickenNoodles"
};
Recipe Spinach = new Recipe
{
Name = "Spinach"
};
TypeCategory_Recipe SpinachSoup = new TypeCategory_Recipe
{
Type_Category = ChickenSoup,
Recipe = Spinach,
Percent = 10,
Weight = 0.5
};
TypeCategory_Recipe ChickenRecipe = new TypeCategory_Recipe
{
Type_Category = ChickenEgg,
Recipe = ChickenWings,
Percent = 15,
Weight = 2.6
};
TypeCategory_Recipe ChickenRecipe2 = new TypeCategory_Recipe
{
Type_Category = ChickenEgg,
Recipe = ChickenNoodles,
Percent = 80,
Weight = 2.56
};
Product ChickenSticks = new Product
{
Name = "ChickenSticks",
Description = "small",
Contents = "very small",
};
Product Ketchup = new Product
{
Name = "Ketchup",
Description = "big",
Contents = "very big",
};
Product Curry = new Product
{
Name = "Curry",
Description = "Scary",
Contents = "thing",
};
Product Bread = new Product
{
Name = "Bread",
Description = "Useless",
Contents = "thing",
};
NormalCategory_Product ZeroChickenGiven = new NormalCategory_Product
{
Product = ChickenSticks,
Normal_Category = NoChicken
};
NormalCategory_Product BreadChicken = new NormalCategory_Product
{
Product = Bread,
Normal_Category = SaltChicken
};
NormalCategory_Product SaltyChicken = new NormalCategory_Product
{
Product = Ketchup,
Normal_Category = SaltChicken
};
Product_Details PD0 = new Product_Details
{
Product = Curry,
ProductDetails = "Tastes bad"
};
Product_Details PD1 = new Product_Details
{
Product = Bread,
ProductDetails = "White"
};
Curry.Details = new List <Product_Details>();
Bread.Details = new List <Product_Details>();
Curry.Details.Add(PD0);
Bread.Details.Add(PD1);
PD0.Product = Curry;
PD1.Product = Bread;
Text CurryText = new Text
{
Content = "Bla Bla Pizza",
WebsitePageID = 1
};
Text KetchupText = new Text
{
Content = "Hi Hi Hi",
WebsitePageID = 1
};
Text Important = new Text
{
Content = "No Live",
WebsitePageID = null
};
Text Important2 = new Text
{
Content = "Oh No",
WebsitePageID = 2
};
Product_Text PT0 = new Product_Text
{
Product = Bread,
Text = Important
};
Product_Text PT1 = new Product_Text
{
Product = Bread,
Text = Important2
};
Product_Text PT2 = new Product_Text
{
Product = ChickenSticks,
Text = CurryText
};
Recipe_Text RT0 = new Recipe_Text
{
Recipe = Spinach,
Text = KetchupText
};
Recipe_Text RT1 = new Recipe_Text
{
Recipe = ChickenNoodles,
Text = KetchupText
};
Recipe_Text RT2 = new Recipe_Text
{
Recipe = ChickenNoodles,
Text = Important2
};
News_Item MadPizza = new News_Item
{
Event_Date = new DateTime().AddYears(2020).AddMonths(11).AddDays(2),
Title = "MadPizza",
Last_Modified_Date = new DateTime().AddYears(1996).AddMonths(1).AddDays(5)
};
News_Item HappyPizza = new News_Item
{
Event_Date = new DateTime().AddYears(2020).AddMonths(11).AddDays(3),
Title = "HappyPizza",
Last_Modified_Date = new DateTime().AddYears(1996).AddMonths(1).AddDays(5)
};
Text_News TN0 = new Text_News
{
News = MadPizza,
Text = CurryText
};
Text_News TN1 = new Text_News
{
News = MadPizza,
Text = KetchupText
};
Text_News TN2 = new Text_News
{
News = HappyPizza,
Text = CurryText
};
Language NL = new Language
{
LangTag = "nl"
};
Language EN = new Language
{
LangTag = "en"
};
Language DE = new Language
{
LangTag = "de"
};
CurryText.Language = NL;
Important.Language = NL;
Important2.Language = EN;
KetchupText.Language = DE;
NL.Texts = new List <Text>();
EN.Texts = new List <Text>();
DE.Texts = new List <Text>();
NL.Texts.Add(CurryText);
NL.Texts.Add(Important);
EN.Texts.Add(Important2);
DE.Texts.Add(KetchupText);
News_Category Mad = new News_Category
{
Category = "Mad"
};
News_Category Happy = new News_Category
{
Category = "Happy"
};
MadPizza.News_Category = Mad;
HappyPizza.News_Category = Happy;
Mad.Items = new List <News_Item>();
Happy.Items = new List <News_Item>();
Mad.Items.Add(MadPizza);
Happy.Items.Add(HappyPizza);
Photo AA = new Photo
{
PhotoPath = "/Img/uknownA.img"
};
Photo BB = new Photo
{
PhotoPath = "/Img/uknownB.img"
};
Photo CC = new Photo
{
PhotoPath = "/Img/uknownC.png"
};
Product_Photo AAA = new Product_Photo
{
Product = Ketchup,
Photo = AA
};
Product_Photo BBB = new Product_Photo
{
Product = Curry,
Photo = BB
};
Product_Photo CCC = new Product_Photo
{
Product = ChickenSticks,
Photo = CC
};
Recipe_Photo RP0 = new Recipe_Photo
{
Recipe = ChickenWings,
Photo = AA
};
Recipe_Photo RP1 = new Recipe_Photo
{
Recipe = ChickenWings,
Photo = BB
};
Recipe_Photo RP2 = new Recipe_Photo
{
Recipe = ChickenNoodles,
Photo = CC
};
Recipe_Photo RP3 = new Recipe_Photo
{
Recipe = ChickenNoodles,
Photo = AA
};
Photo_News PN0 = new Photo_News
{
Photo = AA,
News = MadPizza
};
Photo_News PN1 = new Photo_News
{
Photo = BB,
News = HappyPizza
};
Employee_Profile Henk = new Employee_Profile
{
Name = "Henk",
Job = "Sleeping",
Profile_PhotoPath = "/images/Henk.png",
CountryOrProvince = "Zuid-Holland",
Region = "Netherlands"
};
Employee_Profile Johan = new Employee_Profile
{
Name = "Johan",
Job = "Sales",
Profile_PhotoPath = "/images/Johan.png",
CountryOrProvince = "South-Africa",
Region = "Africa"
};
Employee_Profile Marit = new Employee_Profile
{
Name = "Marit",
Job = "ICT",
Profile_PhotoPath = "/images/Marit.png"
};
Employee_Profile_Email EHenk = new Employee_Profile_Email
{
Email = "*****@*****.**"
};
Employee_Profile_Email EJohan = new Employee_Profile_Email
{
Email = "*****@*****.**"
};
Employee_Profile_Email EMarit = new Employee_Profile_Email
{
Email = "*****@*****.**"
};
Employee_Profile_Email EMarit2 = new Employee_Profile_Email
{
Email = "*****@*****.**",
};
EMarit.Employee = Marit;
EMarit2.Employee = Marit;
EHenk.Employee = Henk;
EJohan.Employee = Johan;
Marit.Emails = new List <Employee_Profile_Email>();
Henk.Emails = new List <Employee_Profile_Email>();
Johan.Emails = new List <Employee_Profile_Email>();
Marit.Emails.Add(EMarit);
Marit.Emails.Add(EMarit2);
Henk.Emails.Add(EHenk);
Johan.Emails.Add(EJohan);
Employee_Profile_Phone_Number N0 = new Employee_Profile_Phone_Number
{
Number = "3160000000000"
};
Employee_Profile_Phone_Number N1 = new Employee_Profile_Phone_Number
{
Number = "3160000000001"
};
N0.Employee = Henk;
N1.Employee = Henk;
Henk.Phone_Numbers = new List <Employee_Profile_Phone_Number>();
Henk.Phone_Numbers.Add(N0);
Henk.Phone_Numbers.Add(N1);
Subscriber Sleep = new Subscriber
{
Email = "*****@*****.**"
};
Subscriber Pizza = new Subscriber
{
Email = "*****@*****.**"
};
C.Branch_Categories.Add(Chicken);
C.Branch_Categories.Add(Pork);
C.Branch_Categories.Add(Fruit);
C.Type_Categories.Add(ChickenSoup);
C.Type_Categories.Add(ChickenEgg);
C.Normal_Categories.Add(SaltChicken);
C.Normal_Categories.Add(SweetChicken);
C.Normal_Categories.Add(NoChicken);
C.Normal_Categories.Add(GingerChicken);
C.Recipes.Add(ChickenWings);
C.Recipes.Add(ChickenNoodles);
C.Recipes.Add(Spinach);
C.TypeCategory_Recipes.Add(SpinachSoup);
C.TypeCategory_Recipes.Add(ChickenRecipe);
C.TypeCategory_Recipes.Add(ChickenRecipe2);
C.Products.Add(ChickenSticks);
C.Products.Add(Ketchup);
C.Products.Add(Curry);
C.Products.Add(Bread);
C.NormalCategory_Products.Add(ZeroChickenGiven);
C.NormalCategory_Products.Add(BreadChicken);
C.NormalCategory_Products.Add(SaltyChicken);
C.Product_Details.Add(PD0);
C.Product_Details.Add(PD1);
C.Text.Add(CurryText);
C.Text.Add(KetchupText);
C.Text.Add(Important);
C.Text.Add(Important2);
C.Product_Texts.Add(PT0);
C.Product_Texts.Add(PT1);
C.Product_Texts.Add(PT2);
C.Recipe_Texts.Add(RT0);
C.Recipe_Texts.Add(RT1);
C.Recipe_Texts.Add(RT2);
C.News_Items.Add(MadPizza);
C.News_Items.Add(HappyPizza);
C.Text_News.Add(TN0);
C.Text_News.Add(TN1);
C.Text_News.Add(TN2);
C.Languages.Add(NL);
C.Languages.Add(EN);
C.Languages.Add(DE);
C.News_Categories.Add(Mad);
C.News_Categories.Add(Happy);
C.Photos.Add(AA);
C.Photos.Add(BB);
C.Photos.Add(CC);
C.Product_Photos.Add(AAA);
C.Product_Photos.Add(BBB);
C.Product_Photos.Add(CCC);
C.Recipe_Photos.Add(RP0);
C.Recipe_Photos.Add(RP1);
C.Recipe_Photos.Add(RP2);
C.Recipe_Photos.Add(RP3);
C.Photo_News.Add(PN0);
C.Photo_News.Add(PN1);
C.Employee_Profiles.Add(Henk);
C.Employee_Profiles.Add(Johan);
C.Employee_Profiles.Add(Marit);
C.Employee_Profile_Emails.Add(EHenk);
C.Employee_Profile_Emails.Add(EJohan);
C.Employee_Profile_Emails.Add(EMarit);
C.Employee_Profile_Emails.Add(EMarit2);
C.Employee_Profile_Phone_Numbers.Add(N0);
C.Employee_Profile_Phone_Numbers.Add(N1);
C.Subscribers.Add(Sleep);
C.Subscribers.Add(Pizza);
C.SaveChanges();
}