/// <summary> /// This method is used to get all categories /// </summary> /// <returns></returns> List <UI.Entities.CategoryModel> ICategoryBL.GetAllCategories() { ICategoriesDAL CatDAL = new CategoriesDAL(); List <UI.Entities.CategoryModel> result = CatDAL.GetCategoryList(); return(result); }
public void Update(BaseDTO dtoName) { Type currentType = dtoName.GetType(); if (currentType.Name.Equals("ProductDTO")) { ProductsDAL updateProduct = new ProductsDAL(); updateProduct.UpdateProduct((dtoName as ProductDTO).ProductOldName, (dtoName as ProductDTO).ProductNewName, (dtoName as ProductDTO).CategoryName, (dtoName as ProductDTO).VendorName, (dtoName as ProductDTO).ProductPrice, (dtoName as ProductDTO).Quantity, (dtoName as ProductDTO).StoreName, (dtoName as ProductDTO).TownName); resultMessage = updateProduct.GetCRUDResult(); } if (currentType.Name.Equals("VendorDTO")) { VendorsDAL updateVendor = new VendorsDAL(); updateVendor.UpdateVendor((dtoName as VendorDTO).VendorOldName, (dtoName as VendorDTO).VendorName); resultMessage = updateVendor.GetCRUDResult(); } if (currentType.Name.Equals("CategoryDTO")) { CategoriesDAL updateCategory = new CategoriesDAL(); updateCategory.UpdateCategory((dtoName as CategoryDTO).CategoryOldName, (dtoName as CategoryDTO).CategoryName); resultMessage = updateCategory.GetCRUDResult(); } else { //MessageBox.Show("Pone stigna do tuk v update seckciqta"); } }
public List <CategoryModel> GetCategory(string CategoryCode) { ICategoriesDAL CatDAL = new CategoriesDAL(); List <UI.Entities.CategoryModel> result = CatDAL.GetCategory(CategoryCode); return(result); }
public List <ContentModel> GetPSCategoryList() { ICategoriesDAL CatDAL = new CategoriesDAL(); List <UI.Entities.ContentModel> result = CatDAL.GetPSCategoryList(); return(result); }
public List <CategoryDTO> GetCategories() { CategoriesDAL getCategories = new CategoriesDAL(); List <CategoryDTO> allCategories = getCategories.GetAllCategories(); return(allCategories); }
public void Delete(BaseDTO dtoName) { Type currentType = dtoName.GetType(); if (currentType.Name.Equals("ProductDTO")) { ProductsDAL deleteProduct = new ProductsDAL(); deleteProduct.DeleteProduct((dtoName as ProductDTO).ProductNewName); resultMessage = deleteProduct.GetCRUDResult(); } if (currentType.Name.Equals("VendorDTO")) { VendorsDAL deleteVendor = new VendorsDAL(); deleteVendor.DeleteVendor((dtoName as VendorDTO).VendorName); resultMessage = deleteVendor.GetCRUDResult(); } if (currentType.Name.Equals("CategoryDTO")) { CategoriesDAL deleteCategory = new CategoriesDAL(); deleteCategory.DeleteCategory((dtoName as CategoryDTO).CategoryName); resultMessage = deleteCategory.GetCRUDResult(); } else { //MessageBox.Show("Pone stigna do tuk v update seckciqta"); } }
public ActionResult Create() { //data author var lstAuthor = new List <SelectListItem>(); using (AuthorsDAL svAuthors = new AuthorsDAL()) { foreach (var author in svAuthors.GetData()) { lstAuthor.Add(new SelectListItem { Value = author.AuthorID.ToString(), Text = author.FirstName + " " + author.LastName }); } ViewBag.Authors = lstAuthor; } // var lstCat = new List <SelectListItem>(); using (CategoriesDAL svCat = new CategoriesDAL()) { foreach (var cat in svCat.GetData()) { lstCat.Add(new SelectListItem { Value = cat.CategoryID.ToString(), Text = cat.CategoryName }); } ViewBag.Categories = lstCat; } return(View()); }
// GET: Categories/Delete/5 public ActionResult Delete(int id) { CategoriesDAL categoriesDAL = new CategoriesDAL(); var model = categoriesDAL.GetById(id); return(View(model)); }
public ActionResult Add() { ViewBag.listCategories = new SelectList(CategoriesDAL.GetData(), "ID", "Name"); ItemsViewModel models = new ItemsViewModel(); return(PartialView("Add", models)); }
// GET: Categories public ActionResult Index() { CategoriesDAL catDal = new CategoriesDAL(); var models = catDal.GetAll(); return(View(models)); }
public ActionResult Search(string txtSearch) { using (CategoriesDAL cat = new CategoriesDAL()) { var result = cat.Search(txtSearch).ToList(); return(View("Index", result)); } }
// GET: Categories/Delete/5 public ActionResult Delete(int id) { //memanggil methode delete pada DAL CategoriesDAL categoriesDAL = new CategoriesDAL(); var model = categoriesDAL.GetById(id); return(View(model)); }
public ActionResult Search(string selectKriteria, string txtSearch) { using (CategoriesDAL svCat = new CategoriesDAL()) { var results = svCat.SearchByKriteria(txtSearch).ToList(); return(View("Index", results)); } }
public ActionResult EditCategories(int id) { using (CategoriesDAL service = new CategoriesDAL()) { var category = service.GetDataByID(id); return(View(category)); } }
//menampilkan list items yang akan kita tampilkan public ActionResult GetItems(int categoryID, int outletId) { CategoriesViewModel model = CategoriesDAL.GetDataById(categoryID); model.ID = categoryID; ViewBag.ListItems = CategoriesDAL.GetItemsData(outletId); return(PartialView("ListItems", model)); }
public ActionResult Search(string txtSearch) { using (CategoriesDAL svBooks = new CategoriesDAL()) { var results = svBooks.Search(txtSearch).ToList(); return(View("ViewAllCategories", results)); } }
// GET: Categories public ActionResult Index() { List <CategoriesViewModel> model = CategoriesDAL.GetData(); // karena kita mau menampilkan list category berdasarkan outlet iD maka kita membuat ViewBag untuk outlet ID // jadi prosesnya : kita menginstansiasi select list baru dari method GetData pada OUtletDAL yang nanti kita ambil nilai ID dan Name nya ViewBag.ListOutlet = new SelectList(OutletDAL.GetData(), "ID", "OutletName"); return(View(model)); }
public ReturnResult Delete(int id) { CommonAPI commonApi = new CommonAPI(); commonApi.getHeaderValues(Request.Headers, out connectionString, out userAccount, out roleId, out companyCode, out DBProviderName); CategoriesDAL categroyDAL = new CategoriesDAL(connectionString, userAccount, roleId, DBProviderName, companyCode); ReturnResult returnResult = categroyDAL.DeleteCategory(id); return(returnResult); }
public ReturnResult Post([FromBody] Category objCategory) { CommonAPI commonApi = new CommonAPI(); commonApi.getHeaderValues(Request.Headers, out connectionString, out userAccount, out roleId, out companyCode, out DBProviderName); CategoriesDAL categroyDAL = new CategoriesDAL(connectionString, userAccount, roleId, DBProviderName, companyCode); ReturnResult returnResult = categroyDAL.SaveCategory(objCategory); return(returnResult); }
public Category Get(int id) { CommonAPI commonApi = new CommonAPI(); commonApi.getHeaderValues(Request.Headers, out connectionString, out userAccount, out roleId, out companyCode, out DBProviderName); CategoriesDAL categroyDAL = new CategoriesDAL(connectionString, userAccount, roleId, DBProviderName, companyCode); var category = categroyDAL.GetCategoryById(id); return(category); }
public IEnumerable <Category> Get() { CommonAPI commonApi = new CommonAPI(); commonApi.getHeaderValues(Request.Headers, out connectionString, out userAccount, out roleId, out companyCode, out DBProviderName); CategoriesDAL categroyDAL = new CategoriesDAL(connectionString, userAccount, roleId, DBProviderName, companyCode); var categories = categroyDAL.GetCategories(); return(categories); }
private void loadCategoriesFromDb() { CategoriesDAL cdal = new CategoriesDAL(); DataTable categoriesDt = new DataTable(); categoriesDt = cdal.Select(); cmbCategory.DataSource = categoriesDt; cmbCategory.DisplayMember = "title"; cmbCategory.ValueMember = "title"; }
public ActionResult Edit(int id) { CategoriesDAL c = new CategoriesDAL(); CategoryDTO dto = new CategoryDTO(); dto = c.GetCategoryByID(id); CategoryModel model = new CategoryModel(); model.id_categ = dto.id_categ; model.categ_name = dto.categ_name; return View(model); }
public ActionResult Delete(int Id) { //list Category ViewBag.listCategories = new SelectList(CategoriesDAL.GetData(), "ID", "Name"); //list Inventory ViewBag.listInventory = new SelectList(ItemsIventoryDAL.GetData(), "ID", "VariantName"); ListItemViewModel model = ItemsDAL.GetDataById(Id); return(PartialView("Delete", model)); }
// GET: Items public ActionResult Index() { //list Category ViewBag.listCategories = new SelectList(CategoriesDAL.GetData(), "ID", "Name"); //list Inventory ViewBag.listInventory = new SelectList(ItemsIventoryDAL.GetData(), "ID", "VariantName"); List <ListItemViewModel> models = ItemDAL.GetData(); return(View(models)); }
public void Insert(BaseDTO dtoName) { Type currentType = dtoName.GetType(); if (currentType.Name.Equals("ProductDTO")) { ProductsDAL newProduct = new ProductsDAL(); if (newProduct.IsProductNameExistInDb((dtoName as ProductDTO).ProductNewName)) { resultMessage = BaseDAL.Messages(MessageFor.ItemExistInDatabase, "Product"); } else { newProduct.InsertNewProduct((dtoName as ProductDTO).ProductNewName, (dtoName as ProductDTO).CategoryName, (dtoName as ProductDTO).VendorName, (dtoName as ProductDTO).ProductPrice, (dtoName as ProductDTO).Quantity, (dtoName as ProductDTO).StoreName, (dtoName as ProductDTO).TownName); resultMessage = newProduct.GetCRUDResult(); } } if (currentType.Name.Equals("VendorDTO")) { VendorsDAL newVendor = new VendorsDAL(); if (newVendor.IsVendorNameExistInDb((dtoName as VendorDTO).VendorName)) { resultMessage = BaseDAL.Messages(MessageFor.ItemExistInDatabase, "Vendor"); } else { newVendor.InsertNewVendor((dtoName as VendorDTO).VendorName); resultMessage = newVendor.GetCRUDResult(); } } if (currentType.Name.Equals("CategoryDTO")) { CategoriesDAL newCategory = new CategoriesDAL(); if (newCategory.IsCategoryNameExistInDb((dtoName as CategoryDTO).CategoryName)) { resultMessage = BaseDAL.Messages(MessageFor.ItemExistInDatabase, "Category"); } else { newCategory.InsertNewCategory((dtoName as CategoryDTO).CategoryName); resultMessage = newCategory.GetCRUDResult(); } } else { //MessageBox.Show("Pone stigna do tuk"); } }
// GET: Categories public ActionResult Index() { using (CategoriesDAL service = new CategoriesDAL()) { var categories = service.GetData().ToList(); if (TempData["Message"] != null) { ViewBag.msg = TempData["Message"].ToString(); } return(View(categories)); } }
public ActionResult CreateNews(string chkType, string chkAutoUpload, News newDetail) { try { if (string.IsNullOrEmpty(newDetail.Title)) { return(Json(new { msg = "Bạn phải nhập tiêu đề" })); } if (string.IsNullOrEmpty(newDetail.Summary)) { return(Json(new { msg = "Bạn phải nhập tóm tắt" })); } if (newDetail.CategoryID <= 0) { return(Json(new { msg = "Bạn phải chọn chuyên mục" })); } if (newDetail.Id == 0) { CategoriesDAL categoryCtrl = new CategoriesDAL(); var category = categoryCtrl.GetItemByID("Id", newDetail.CategoryID); NewsDAL objCtrl = new NewsDAL(); newDetail.Type = !string.IsNullOrEmpty(chkType) ? (byte)1 : (byte)0; newDetail.Active = 1; newDetail.UnitId = SysBaseInfor.GetCurrentUnitId().ToInt32(); newDetail.CreatedAt = DateTime.Now; newDetail.CreatedBy = SysBaseInfor.GetCurrentUserId(); newDetail.Status = isChief ? (byte)1 : (byte)0; objCtrl.CreateItem(newDetail); if (newDetail.Id > 0 && !string.IsNullOrEmpty(chkAutoUpload)) { var tmpContent = UploadAllImageInNewsToServer(newDetail.FullContent, newDetail.Id); if (!string.IsNullOrEmpty(tmpContent)) { newDetail.FullContent = tmpContent; } objCtrl.UpdateItem(newDetail); } return(Json(new { msg = "Success", idNews = newDetail.Id, typeAction = "Create" })); } else { return(Json(new { msg = "Thao tác không thực hiện được" })); } } catch (Exception ex) { return(Json(new { msg = ex.Message })); } }
public ActionResult Create(Category category) { try { // TODO: Add insert logic here CategoriesDAL cat = new CategoriesDAL(); cat.Create(category); return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Delete(Category category) { try { CategoriesDAL categoriesDAL = new CategoriesDAL(); categoriesDAL.Delete(category); return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Create(Category category) { try { CategoriesDAL catDal = new CategoriesDAL(); catDal.Create(category); return(RedirectToAction("Index")); } catch (Exception ex) { ViewBag.Error = ex.Message; return(View()); } }
public ActionResult Index(int page = 1, int pageSize = 6) { CategoriesDAL c = new CategoriesDAL(); List<CategoryDTO> categoryList = c.GetCategories(); List<CategoryModel> modelList = new List<CategoryModel>(); int i = 0; foreach (CategoryDTO x in categoryList) { CategoryModel m = new CategoryModel(); m.id_categ = categoryList[i].id_categ; m.categ_name = categoryList[i].categ_name; modelList.Add(m); i++; } PagedList<CategoryModel> model = new PagedList<CategoryModel>(modelList, page, pageSize); return View(model); }
public ActionResult Add(CategoryModel model) { CategoriesDAL category = new CategoriesDAL(); CategoryDTO dto = new CategoryDTO(); dto.categ_name = model.categ_name; try { if (ModelState.IsValid) { category.insertCategory(dto); return RedirectToAction("Index"); } } catch (DataException) { //Log the error (add a variable name after DataException) ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists see your system administrator."); } return View(model); }
//----------------Delete------------------- public ActionResult Delete(int id) { CategoriesDAL c = new CategoriesDAL(); CategoryDTO dto = new CategoryDTO(); dto = c.GetCategoryByID(id); try { c.deleteCategory(dto); return RedirectToAction("Index"); } catch (DataException) { //Log the error (add a variable name after DataException) ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists see your system administrator."); } return View(); }