public IActionResult AddMenu(Menu_Language menu_language)
{
using (var db = CMSContextFactory.Create(Settings.MySqlConnectionString))
{
db.Add(menu_language);
db.SaveChanges();
}
return(Redirect("/backend/menus"));
}
public IActionResult GetEditItem(int menu_id)
{
using (var db = CMSContextFactory.Create(Settings.MySqlConnectionString))
{
Menu_Language ml = db.Menu_Language.SingleOrDefault(_menu_lang => _menu_lang.Id == menu_id);
ViewBag.menu = db.Menu_Language.Where(_menu => _menu.Id == menu_id)
.Include(_item => _item.Menu)
.SingleOrDefault();
ViewBag.cats = db.Category_Language.Where(cat_lang => cat_lang.LanguageId == ml.LanguageId).ToList();
return(View("~/Components/Main/Menu/Views/Backend/edit.cshtml"));
}
}
public IActionResult CreateMenu(int CategoryId, string Description)
{
using (var db = CMSContextFactory.Create(Settings.MySqlConnectionString))
{
Menu menu = new Menu();
menu.CategoryId = CategoryId;
db.Add(menu);
Menu_Language menu_language = new Menu_Language();
menu_language.Description = Description;
menu_language.LanguageId = 1;//default laguage
menu_language.Menu = menu;
db.Add(menu_language);
db.SaveChanges();
return(Redirect("/backend/menus"));
}
}
public IActionResult EditItem(int MenuId, int Menu_LanguageId, int LanguageId, int CategoryId, string Description)
{
Menu m = new Menu()
{
Id = MenuId, CategoryId = CategoryId
};
Menu_Language il = new Menu_Language()
{
Id = Menu_LanguageId, LanguageId = LanguageId, Description = Description, MenuId = MenuId
};
using (var db = CMSContextFactory.Create(Settings.MySqlConnectionString))
{
db.Entry(m).State = EntityState.Modified;
db.Entry(il).State = EntityState.Modified;
db.SaveChanges();
return(Redirect("/backend/menus"));
}
}
public void Bootstrap(string sqlString)
{
createRoles(sqlString);
createSuperUser(sqlString);
//find or create pattern
using (var db = CMSContextFactory.Create(sqlString))
{
//add language if not exist
var lang = db.Language.SingleOrDefault(laganguage => laganguage.Name == "English");
if (lang == null)
{
lang = new Language();
lang.Name = "English";
lang.Id = 1;
lang.orientation = "ltr";
db.Add(lang);
}
lang = db.Language.SingleOrDefault(laganguage => laganguage.Name == "Arabic");
if (lang == null)
{
lang = new Language();
lang.Name = "Arabic";
lang.Id = 2;
lang.orientation = "rtl";
db.Add(lang);
}
//init category
var mainCategory = db.Categories.SingleOrDefault(cat => cat.Id == 1);
if (mainCategory == null)
{
mainCategory = new Category()
{
Id = 1,
Role = db.Roles.SingleOrDefault(role => role.Name.Equals("Public"))
};
db.Add(mainCategory);
Category_Language category_language = new Category_Language()
{
Id = 1,
Description = "Main Category",
LanguageId = 1,
CategoryId = 1
};
db.Add(category_language);
category_language = new Category_Language()
{
Id = 2,
Description = "الرئيسية",
LanguageId = 2,
CategoryId = 1
};
db.Add(category_language);
}
//init menu
var mainMenu = db.Menus.SingleOrDefault(menu => menu.Id == 1);
if (mainMenu == null)
{
mainMenu = new Menu()
{
Id = 1,
CategoryId = 1, // main category
//Description = "Main Menu - Displayed at header"
};
db.Add(mainMenu);
Menu_Language mainMenu_Language = new Menu_Language()
{
Id = 1,
LanguageId = 1,
MenuId = 1,
Description = "Main Menu - Displayed at header"
};
db.Add(mainMenu_Language);
mainMenu_Language = new Menu_Language()
{
Id = 2,
LanguageId = 2,
MenuId = 1,
Description = "اللائحة الرئيسية"
};
db.Add(mainMenu_Language);
}
db.SaveChanges();
}
}
