// GET: Category/Details/5
public ActionResult Details(int id)
{
CategoryDal pd = new CategoryDal();
var category = pd.CategoryDetail(id);
return(View(category));
}
// GET: Category/Delete/5
public ActionResult Delete(int id)
{
CategoryDal ct = new CategoryDal();
var category = ct.CategoryDetail(id);
return(View(category));
}
private void cbCategories_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
var bookList = new BookDal().GetAll();
var categoryList = new CategoryDal().GetAll();
dgvBooks.DataSource =
bookList
.Join(categoryList,
b => b.CategoryId,
c => c.CategoryId,
(b, c) => new
{
Id = b.Id,
Title = b.Title,
Description = b.Description,
Year = b.Year,
CategoryId = c.CategoryId,
CategoryName = c.CategoryName
})
.Where(b => b.CategoryId == Convert.ToInt32(cbCategories.SelectedValue.ToString()))
.ToList();
}
catch
{
}
}
public IActionResult Index()
{
string str = "";
Random r = new Random();
BlogDal blogdal = new BlogDal();
CategoryDal cadal = new CategoryDal();
List <Model.Category> list_ca = cadal.GetList("");
for (int i = 0; i < 102; i++)
{
string title = $"新闻标题{i}";
string body = title + "的内容";
Model.Category ca = list_ca[r.Next(0, list_ca.Count)];
string cabh = ca.Num,
caname = ca.CaName;
blogdal.Insert(new Model.Blog
{
Title = title,
Body = body,
VisitNum = r.Next(100, 999),
CaNum = cabh,
CaName = caname,
});
}
str = "添加102条测试新闻成功！";
return(Content(str));
}
// GET: Category
public ActionResult Index()
{
CategoryDal pd = new CategoryDal();
var categories = pd.CategoryList();
return(View(categories));
}
public int EditCategory(int id, string name)
{
ValidateName(name);
var categoryDal = new CategoryDal();
return(categoryDal.EditCategory(id, name));
}
public static CategoryDto GetCategory(int id)
{
Category category = CategoryDal.GetCategory(id);
CategoryDto dtoCategory = new CategoryDto(category);
//converting Dal Object to Dto
return(dtoCategory);
}
public ActionResult AddCategory(CategoryDal obj)
{
CategoryDal objcat = new CategoryDal();
objcat.AddCategory(obj.Categoryname);
return(Json(obj, JsonRequestBehavior.AllowGet));
}
public int CreateCategory(string name)
{
ValidateName(name);
var categoryDal = new CategoryDal();
return(categoryDal.CreateCategory(name));
}
public static List <CategoryDto> GetProductsCategories()
{
//categories from dataBase
List <Category> categories = CategoryDal.GetProductsCategories();
List <CategoryDto> dtoCategories = new List <CategoryDto>();
for (int i = 0; i < categories.Count; i++)
{
dtoCategories.Add(new CategoryDto(categories[i]));
}
return(dtoCategories);
}
public static List <CategoryDto> GetCatgsToppingsForCatgProduct(int catgProductId)
{
//categories from dataBase
List <Category> categories = CategoryDal.GetCatgsToppingsForCatgProduct(catgProductId);
List <CategoryDto> dtoCategories = new List <CategoryDto>();
for (int i = 0; i < categories.Count; i++)
{
dtoCategories.Add(new CategoryDto(categories[i]));
}
return(dtoCategories);
}
public ActionResult GetCategoriesByJson()
{
//get json of all the categories from DB
if (Session["CurrentUser"] == null)
{
return(RedirectToAction("RedirectByUser", "Home"));
}
CategoryDal ctgyDal = new CategoryDal();
List <Category> categories = ctgyDal.Categories.ToList <Category>();
Thread.Sleep(1000);
return(Json(categories, JsonRequestBehavior.AllowGet));
}
public ActionResult Delete(category cat)
{
try
{
CategoryDal ct = new CategoryDal();
ct.DeleteProduct(cat.CategoryID);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Edit(category cat)
{
try
{
CategoryDal ct = new CategoryDal();
ct.UpdateProduct(cat);
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
return(View());
}
}
public ActionResult Create(category cat)
{
try
{
CategoryDal ct = new CategoryDal();
ct.AddCategory(cat);
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
return(View());
}
}
public Category GetCategory(int id)
{
var categoryDal = new CategoryDal();
var dt = categoryDal.GetCategory(id);
var category = new Category();
if (dt.Rows.Count <= 0)
{
return(null);
}
var dr = dt.Rows[0];
category.Id = int.Parse(dr["Id"].ToString());
category.Name = dr["Name"].ToString();
return(category);
}
public ActionResult ShowCategoryList()
{
CategoryDal objcat = new CategoryDal();
DataTable dt = objcat.ShowCategory();
List <CategoryDal> objmenulist = new List <CategoryDal>();
foreach (DataRow row in dt.Rows)
{
CategoryDal objmenu = new CategoryDal();
objmenu.Categoryname = row["cat_name"].ToString();
objmenulist.Add(objmenu);
}
return(Json(objmenulist, JsonRequestBehavior.AllowGet));
}
public List <Category> SearchCategories(string name)
{
var categoryDal = new CategoryDal();
var dt = categoryDal.SearchCategories(name);
var categoriesList = new List <Category>();
foreach (DataRow dr in dt.Rows)
{
var category = new Category()
{
Id = int.Parse(dr["Id"].ToString()),
Name = dr["Name"].ToString(),
};
categoriesList.Add(category);
}
return(categoriesList);
}
public ActionResult SaveNewCategory()
{
//save the new category
if (!Authorize())
{
return(RedirectToAction("RedirectByUser", "Home"));
}
CategoryDal ctgyDal = new CategoryDal();
Category newCategory = new Category
{
Type = Request.Form["Type"].ToString()
};
ModelState.Clear();
TryValidateModel(newCategory);
if (ModelState.IsValid)
{
try
{
ctgyDal.Categories.Add(newCategory);
ctgyDal.SaveChanges();
}
catch (DbUpdateException)
{
//TODO: show error message in client side
ViewBag.addNewCategoryError = "התרחשה שגיאה בהוספת הקטגוריה";
}
}
else
{
ViewBag.addNewCategoryError = "הזן קטגוריה תקינה!";
}
List <Category> categories = ctgyDal.Categories.ToList <Category>();
Thread.Sleep(1000);
return(Json(categories, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 根据分类ID获取分类信息
/// </summary>
/// <param name="categoryID"></param>
/// <returns></returns>
public Category Get(string categoryID)
{
if (string.IsNullOrEmpty(categoryID))
{
return null;
}
using (CategoryDal dal = new CategoryDal())
{
return dal.Get(categoryID);
}
}
/// <summary>
/// 根据分类名字获取分类信息
/// </summary>
/// <param name="categoryName"></param>
/// <returns></returns>
public Category GetName(string categoryName)
{
if (string.IsNullOrEmpty(categoryName))
{
return null;
}
Category entity = this.GetAllCache().Where(x => x.Name == categoryName).SingleOrDefault();
if (entity == null)
{
using (CategoryDal dal = new CategoryDal())
{
entity = dal.GetByName(categoryName);
}
}
return entity;
}
public CategoryLogic()
{
this.dal = new CategoryDal();
}
private CategoryManager()
{
categoryDal = CategoryDal.GetInstance();
}
public BlogController(BlogDal bdal, CategoryDal cadal)
{
this.dal = bdal;
this.cadal = cadal;
}
public CategoryBll()
{
this._CategoryDal = new CategoryDal();
}
public void ChooseActionForCategories()
{
CategoryDal categoryDal = new CategoryDal();
Console.Clear();
Console.WriteLine("TABLE: CATEGORIES\n\n");
Console.WriteLine("What action you want to choose?\n" +
"1. View all categories\n" +
"2. Get category by Id\n" +
"3. Get category by name of column\n" +
"4. Add category\n" +
"5. Edit info about category\n" +
"6. Delete category by Id\n" +
"7. Delete category by name of column\n" +
"8. Back to start menu");
Console.Write("\nYour selection: ");
string ch = Console.ReadLine();
switch (ch)
{
case "1":
{
try
{
Console.Clear();
Console.WriteLine("TABLE: CATEGORIES\n\n");
categoryDal.PrintListOfCategories(categoryDal.GetAll());
Console.ReadKey();
break;
}
finally
{
Menu menu = new Menu();
menu.ChooseActionForCategories();
}
}
case "2":
{
try
{
Console.Clear();
Console.WriteLine("TABLE: CATEGORIES\n\nId: ");
int id = Convert.ToInt32(Console.ReadLine());
categoryDal.PrintCategory(categoryDal.GetById(id));
Console.ReadKey();
break;
}
finally
{
Menu menu = new Menu();
menu.ChooseActionForCategories();
}
}
case "3":
{
try
{
Console.Clear();
Console.WriteLine("TABLE: CATEGORIES\n\n");
Console.WriteLine("Name of column: ");
string fieldName = Console.ReadLine();
Console.WriteLine("\nValue: ");
string text = Console.ReadLine();
categoryDal.PrintListOfCategories(categoryDal.GetByFieldName(fieldName, text));
Console.ReadKey();
break;
}
finally
{
Menu menu = new Menu();
menu.ChooseActionForCategories();
}
}
case "4":
{
try
{
Console.Clear();
Console.WriteLine("TABLE: CATEGORIES\n\n");
Console.WriteLine("NAME: ");
string name = Console.ReadLine();
Console.WriteLine("DESCRIPTION: ");
string desc = Console.ReadLine();
Category category = new Category(name, desc);
categoryDal.Insert(category);
Console.WriteLine("Category succesfully inserted :)");
Console.ReadKey();
break;
}
finally
{
Menu menu = new Menu();
menu.ChooseActionForCategories();
}
}
case "5":
{
try
{
Console.Clear();
Console.WriteLine("TABLE: CATEGORIES\n\n");
Console.WriteLine("Name of column (set): ");
string fieldName = Console.ReadLine();
Console.WriteLine("Value (set): ");
string text = Console.ReadLine();
Console.WriteLine("Name of column (condition): ");
string fieldCondition = Console.ReadLine();
Console.WriteLine("Value (condition): ");
string textCondition = Console.ReadLine();
categoryDal.UpdateByFieldName(fieldName, text, fieldCondition, textCondition);
Console.WriteLine("Category succesfully updated :)");
Console.ReadKey();
break;
}
finally
{
Menu menu = new Menu();
menu.ChooseActionForCategories();
}
}
case "6":
{
try
{
Console.Clear();
Console.WriteLine("TABLE: CATEGORIES\n\nId: ");
int id = Convert.ToInt32(Console.ReadLine());
categoryDal.DeleteById(id);
Console.WriteLine("Category succesfully deleted :)");
Console.ReadKey();
break;
}
finally
{
Menu menu = new Menu();
menu.ChooseActionForCategories();
}
}
case "7":
{
try
{
Console.Clear();
Console.WriteLine("TABLE: CATEGORIES\n\n ");
Console.WriteLine("Name of column (condition): ");
string fieldCondition = Console.ReadLine();
Console.WriteLine("Value (condition): ");
string textCondition = Console.ReadLine();
categoryDal.DeleteByFieldName(fieldCondition, textCondition);
Console.WriteLine("Category succesfully deleted :)");
Console.ReadKey();
break;
}
finally
{
Menu menu = new Menu();
menu.ChooseActionForCategories();
}
}
case "8":
{
Menu menu = new Menu();
menu.ChooseTable();
break;
}
default:
Console.WriteLine("Invalid selection. Please select 1, 2, 3, 4, 5, 6, 7 or 8.");
break;
}
}
/// <summary>
/// 获取顶级分类信息/即:导航菜单
/// </summary>
/// <returns></returns>
public IList<Category> GetMenu()
{
IList<Category> list = this.GetAllCache().Where(e => (e.ParentID == "0" && e.Status > 0)).OrderBy(e => e.Status).ToList();
if (list == null || list.Count < 1)
{
using (CategoryDal dal = new CategoryDal())
{
list = dal.GetMenu();
}
}
else
{
log.Debug("Get navigation from cache !");
}
return list;
}
public IList<Category> GetAllCache()
{
IList<Category> cache = Common.BuildCache<IList<Category>>.Default.Get(this.CategoryAllCacheKey);
if (cache == null)
{
using (CategoryDal dal = new CategoryDal())
{
cache = dal.GetAll();
if (cache != null)
{
lock (this.lockCategory)
{
Common.BuildCache<IList<Category>>.Default.Cache(this.CategoryAllCacheKey, cache);
}
}
}
}
return cache;
}
public IList<Category> GetByParentID(string parentID)
{
if (string.IsNullOrEmpty(parentID))
{
return null;
}
IList<Category> list = GetAllCache().Where(x => x.ParentID == parentID).Where(e => e.Status > -1).ToList();
if (list == null || list.Count < 1)
{
using (CategoryDal dal = new CategoryDal())
{
list = dal.GetByParentID(parentID);
}
}
return list;
}
/// <summary>
/// 获取相似的分类信息
/// </summary>
/// <param name="likeCategoryID"></param>
/// <returns></returns>
public IList<Category> GetLike(string likeCategoryID)
{
using (CategoryDal dal = new CategoryDal())
{
return dal.GetLike(likeCategoryID);
}
}
public int DeleteCategory(int dni)
{
var categoryDal = new CategoryDal();
return(categoryDal.DeleteCategory(dni));
}
public CategoryController(CategoryDal cadal)
{
this.dal = cadal;
}
public Category Add(Category item)
{
CategoryDal categoryDal = new CategoryDal();
return(categoryDal.Add(item));
}
/// <summary>
/// 添加或修改分类信息
/// <br/>
/// 清除分类缓存
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public ReturnValue AddOrEdit(Category entity)
{
ReturnValue retValue = new ReturnValue();
if (string.IsNullOrEmpty(entity.Name))
{
retValue.IsExists = false;
retValue.Message = "分类名称";
return retValue;
}
if (string.IsNullOrEmpty(entity.Title))
{
retValue.IsExists = false;
retValue.Message = "分类显示名称";
return retValue;
}
using (CategoryDal dal = new CategoryDal())
{
Category old = dal.Get(entity.CategoryID);
if (old == null)//添加
{
old = dal.GetByName(entity.Name);
if (old != null)
{
retValue.IsExists = false;
retValue.Message = "分类已存在";
return retValue;
}
if (dal.Add(entity))
{
retValue.IsExists = true;
retValue.Message = "分类添加成功";
}
else
{
retValue.IsExists = false;
retValue.Message = "分类添加失败";
}
}
else
{
if (entity.Name != old.Name)
{
old = dal.GetByName(entity.Name);
if (old != null)
{
retValue.IsExists = false;
retValue.Message = "分类已存在";
return retValue;
}
}
if (dal.Modify(entity))
{
retValue.IsExists = true;
retValue.Message = "分类修改成功";
}
else
{
retValue.IsExists = false;
retValue.Message = "分类修改失败";
}
}
}
if (retValue.IsExists)
{
ClearCache();
}
return retValue;
}
/// <summary>
/// 是否重新下载项目信息
/// </summary>
/// <param name="updatejson">是否重新下载配置分类</param>
public void LoadConfig(bool isload)
{
lock (_lockconfig)
{
string jasonpath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "json", "json.txt");
try
{
bool isupdatelocal = false;
DateTime updatetime = DateTime.Now;
if (isload)
{
SystemConfigDal scdal = new SystemConfigDal();
SystemConfig sc = scdal.GetRedisServer(AppDomainContext.Context.ConfigParams.ConfigManagerConnectString);
if (sc != null)
{
AppDomainContext.Context.ConfigParams.RedisServer = sc.ConfigValue;
}
//更新项目信息
ProjectDal prodal = new ProjectDal();
AppDomainContext.Context.ProjectModel = prodal.GetByName(AppDomainContext.Context.ConfigParams.ConfigManagerConnectString, AppDomainContext.Context.ConfigParams.ProjectName);
//更新分类信息
CategoryDal catedal = new CategoryDal();
AppDomainContext.Context.CategoryModels = catedal.GetListByIds(AppDomainContext.Context.ConfigParams.ConfigManagerConnectString, AppDomainContext.Context.ProjectModel.CategoryIds);
long[] cids = AppDomainContext.Context.CategoryModels.Select(p => p.Id).ToArray();
//更新配置信息
ConfigDal configdal = new ConfigDal();
List <Config> configs = configdal.GetListByCategoryIds(AppDomainContext.Context.ConfigParams.ConfigManagerConnectString, cids, updatetime);
List <ConfigModel> configmodels = ToConfigModel(configs);
ConfigInfoOfKeyDic dic = new ConfigInfoOfKeyDic();
foreach (var item in configmodels)
{
dic.SetConfig(item);
}
AppDomainContext.Context.ConfigInfoOfKeyDic = dic;
if (configs.Count > 0)
{
configdal.SetUpdatetime(AppDomainContext.Context.ConfigParams.ConfigManagerConnectString, cids, updatetime);
isupdatelocal = true;
}
}
else
{
ConfigDal configdal = new ConfigDal();
long[] cids = AppDomainContext.Context.CategoryModels.Select(p => p.Id).ToArray();
List <Config> configs = configdal.GetListByCategoryIds(AppDomainContext.Context.ConfigParams.ConfigManagerConnectString, cids, updatetime);
List <ConfigModel> configmodels = ToConfigModel(configs);
foreach (var item in configmodels)
{
AppDomainContext.Context.ConfigInfoOfKeyDic.SetConfig(item);
}
if (configs.Count > 0) //本次有配置更新
{
configdal.SetUpdatetime(AppDomainContext.Context.ConfigParams.ConfigManagerConnectString, cids, updatetime);
isupdatelocal = true;
}
}
if (isupdatelocal)
{
string json1 = JsonConvert.SerializeObject(AppDomainContext.Context);
IOHelper.Write(jasonpath, json1); //写入磁盘
LogHelper.WriteInfo("写入磁盘成功");
}
}
catch (Exception)
{
string json2 = IOHelper.Read(jasonpath);
JsonConvert.DeserializeObject <ConfigContext>(json2); //从磁盘获得上次正确的配置
LogHelper.WriteInfo("从磁盘读取配置");
}
}
}
public CategoryController()
{
category_dal = new CategoryDal();
}
public CategoryService(CategoryDal categoryDal, IMapper mapper)
{
_categoryDal = categoryDal;
_mapper = mapper;
}
public ReturnValue Delete(string ids)
{
ReturnValue retValue = new ReturnValue();
string[] categoryIdArr = ids.Split(new Char[] { ',' });
using (CategoryDal dal = new CategoryDal())
{
foreach (string item in categoryIdArr)
{
if (dal.Delete(item))
{
retValue.PutValue("ok", retValue.GetInt("ok"));
}
else
{
retValue.PutValue("error", retValue.GetInt("error"));
}
}
}
if (retValue.GetInt("error") != 0)
{
retValue.IsExists = false;
retValue.Message = string.Format("删除分类失败，成功{0},失败{1}!", retValue.GetInt("ok"), retValue.GetInt("error"));
}
else
{
retValue.IsExists = true;
retValue.Message = "删除分类成功!";
ClearCache();//清除缓存
}
return retValue;
}
