public ActionResult Create() { CategoryDataAccess cda = new CategoryDataAccess(); ViewData["cats"] = cda.GetAllCategories(); return(View()); }
public void CategoryDataAccess_CrudCategory() { var categoryDataAccess = new CategoryDataAccess(new DbHelper(new SQLitePlatformWinRT(), new TestDatabasePath())); const string firstName = "category"; const string secondName = "new category"; var category = new Category { Name = firstName }; categoryDataAccess.Save(category); categoryDataAccess.LoadList(); var list = categoryDataAccess.LoadList(); Assert.AreEqual(1, list.Count); Assert.AreEqual(firstName, list.First().Name); category.Name = secondName; categoryDataAccess.Save(category); list = categoryDataAccess.LoadList(); Assert.AreEqual(1, list.Count); Assert.AreEqual(secondName, list.First().Name); categoryDataAccess.Delete(category); list = categoryDataAccess.LoadList(); Assert.IsFalse(list.Any()); }
public ActionResult CreateEdit(CategoryViewModel model) { try { if (ModelState.IsValid) { if (CategoryDataAccess.Update(model)) { return(Json(new { success = true, message = "berhasil" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { success = false, mesage = CategoryDataAccess.Message }, JsonRequestBehavior.AllowGet)); } } else { return(Json(new { succes = false, message = "Please full fill required fields!" }, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet)); } }
public void CategoryDataAccess_CrudCategory() { var categoryDataAccess = new CategoryDataAccess(); const string firstName = "category"; const string secondName = "new category"; var category = new Category { Name = firstName }; categoryDataAccess.Save(category); categoryDataAccess.LoadList(); var list = categoryDataAccess.LoadList(); Assert.AreEqual(1, list.Count); Assert.AreEqual(firstName, list.First().Name); category.Name = secondName; categoryDataAccess.Save(category); list = categoryDataAccess.LoadList(); Assert.AreEqual(1, list.Count); Assert.AreEqual(secondName, list.First().Name); categoryDataAccess.Delete(category); list = categoryDataAccess.LoadList(); Assert.IsFalse(list.Any()); }
public CategoryService() { if (CategoryService.categoryDataAccess == null) { CategoryService.categoryDataAccess = new CategoryDataAccess(); } }
public void CategoryDataAccess_CrudCategory() { var categoryDataAccess = new CategoryDataAccess(new SqliteConnectionCreator(new WindowsSqliteConnectionFactory())); const string firstName = "category"; const string secondName = "new category"; var category = new Category { Name = firstName }; categoryDataAccess.SaveItem(category); categoryDataAccess.LoadList(); var list = categoryDataAccess.LoadList(); Assert.Equal(1, list.Count); Assert.Equal(firstName, list.First().Name); category.Name = secondName; categoryDataAccess.SaveItem(category); list = categoryDataAccess.LoadList(); Assert.Equal(1, list.Count); Assert.Equal(secondName, list.First().Name); categoryDataAccess.DeleteItem(category); list = categoryDataAccess.LoadList(); Assert.False(list.Any()); }
private void btnDelete_Click(object sender, EventArgs e) { if (cateroryGridView.SelectedRows.Count > 0) { DataGridViewRow dataRow = cateroryGridView.SelectedRows[0]; int.TryParse(dataRow.Cells["id"].Value.ToString(), out int id); if (id < 0) { MessageBox.Show("Invalid category id"); return; } else { int success = CategoryDataAccess.DeleteCategory(id); if (success > 0) { MessageBox.Show("successfully deleted"); frmCategory_Load(sender, e); } } } else { MessageBox.Show("Please select a category to delete"); return; } }
public RegisteredVehicleController() { _vehicle = new RegisteredVehicleDataAccess(); _service = new RegisteredVehicleService(); _manufacturer = new ManufacturerDataAccess(); _category = new CategoryDataAccess(); }
public List <Food> GetAllFoodsByCategory(string categoryName) { CategoryDataAccess categoryDataAccess = new CategoryDataAccess(); int categoryId = categoryDataAccess.GetCategoryId(categoryName); this.foodDataAccess = new FoodDataAccess(); return(this.foodDataAccess.GetFoodsByCategoryId(categoryId)); }
public ActionResult Create() { ViewBag.CategoryList = new SelectList(CategoryDataAccess.GetAll(), "CategoryCode", "CategoryName"); ViewBag.ItemList = new SelectList(ItemDataAccess.GetByCategory(""), "ItemCode", "ItemName"); return(View()); }
public ActionResult Category(int cateId) { var productcategory = new CategoryDataAccess().ViewDetail(cateId); ViewBag.Category = productcategory; var model = new ProductDataAccess().ListByCategoryId(cateId); return(View(model)); }
public async Task <IActionResult> Put(int id, [FromBody] UpdateCategoryMaster category) { try { if (!ModelState.IsValid) { return(Ok(new OperationResponse { HasSucceeded = false, IsDomainValidationErrors = true, StatusCode = ((int)ResponseStatus.BadRequest).ToString(), Message = string.Join("; ", ModelState.Values .SelectMany(x => x.Errors) .Select(x => x.ErrorMessage)) })); } CategoryDataAccess _categoryAccess = new CategoryDataAccess(_iconfiguration); DatabaseResponse response = await _categoryAccess.UpdateCategory(category, id); if (response.ResponseCode == (int)DbReturnValue.UpdateSuccess) { return(Ok(new OperationResponse { HasSucceeded = true, IsDomainValidationErrors = false, Message = EnumExtensions.GetDescription(DbReturnValue.UpdateSuccess), ReturnedObject = response.Results })); } else { Log.Error(EnumExtensions.GetDescription(DbReturnValue.UpdationFailed)); return(Ok(new OperationResponse { HasSucceeded = false, IsDomainValidationErrors = false, Message = EnumExtensions.GetDescription(DbReturnValue.NotExists), ReturnedObject = response.Results })); } } catch (Exception ex) { Log.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); return(Ok(new OperationResponse { HasSucceeded = false, Message = StatusMessages.ServerError, StatusCode = ((int)ResponseStatus.ServerError).ToString(), IsDomainValidationErrors = false })); } }
private void ViewEditData() { category = CategoryDataAccess.GetCategoryById(categoryId); if (category != null) { txtCategory.Text = category.CategoryName; chkActive.Checked = category.IsActive; } }
public ManagerCollection() { _dataAccess = new CategoryDataAccess(); _account = new AccountDataAccess(); _cats = new List <Category>(); _invs = new List <Invoice>(); _buss = new List <Business>(); SetCategories(); }
public ActionResult Edit(int id) { VarianViewModel model = VarianDataAccess.GetById(id); ViewBag.CategoryList = new SelectList(CategoryDataAccess.GetAll(), "CategoryCode", "CategoryName"); ViewBag.ItemList = new SelectList(ItemDataAccess.GetByCategory(model.CategoryCode), "ItemCode", "ItemName"); return(View(model)); }
public void frmCategory_Load(object sender, EventArgs e) { DataTable dt = CategoryDataAccess.GetCategories(); if (dt != null) { this.cateroryGridView.DataSource = dt; FormatGrid(ref this.cateroryGridView); } }
public ActionResult Edit(Category cat) { CategoryDataAccess cda = new CategoryDataAccess(); int i = cda.UpdateCategory(cat); if (i > 0) { return(RedirectToAction("Index")); } return(View()); }
public ActionResult ConfirmDelete(int id) { CategoryDataAccess cda = new CategoryDataAccess(); int i = cda.DeleteCategory(id); if (i > 0) { return(RedirectToAction("Index")); } return(View()); }
public ActionResult Create(Category cat) { CategoryDataAccess cda = new CategoryDataAccess(); int i = cda.InsertCategory(cat); if (i > 0) { return(RedirectToAction("Index")); } return(View()); }
public ActionResult DeleteConfirm(int id) { if (CategoryDataAccess.Delete(id)) { return(Json(new { success = true, message = "Sukses" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { success = false, message = CategoryDataAccess.Message }, JsonRequestBehavior.AllowGet)); } }
private void frmProductAdd_Load(object sender, EventArgs e) { keyValues = CategoryDataAccess.GetCategoriesForProduct(); if (keyValues != null) { foreach (var item in keyValues) { cmbCategory.Items.Add(item.Value); categoryIds.Add(item.Key); } } }
public void TestInitCategory() { //making sure the table is empty TestBuisness.clearAllTable(); cat1 = new Category(); cat2 = new Category(); cat3 = new Category(); cat1.catName = "food"; cat2.catName = "sport"; cat3.catName = "Entertaiment"; cat_da = new CategoryDataAccess(); }
public CreateBook() { InitializeComponent(); pubYearCmb.ItemsSource = Enumerable.Range(1950, DateTime.UtcNow.Year - 1948).ToList(); pubYearCmb.SelectedIndex = 12; // Load categories to the combo box CategoryDataAccess categoryDataAccess = new CategoryDataAccess(); List <Category> categories = categoryDataAccess.AllCategories(); categoriesCmb.ItemsSource = categories; categoriesCmb.SelectedValuePath = "CategoryId"; categoriesCmb.DisplayMemberPath = "CategoryName"; categoriesCmb.SelectedValue = 2; }
private void ViewCategories() { keyValues = CategoryDataAccess.GetCategoriesForProduct(); if (keyValues != null) { cmbCategory.Items.Add("All"); foreach (var item in keyValues) { cmbCategory.Items.Add(item.Value); categoryIds.Add(item.Key); } } cmbCategory.SelectedIndex = 0; }
public async Task <IActionResult> Get() { try { var parameters = HttpUtility.ParseQueryString(Request.QueryString.Value); var paramIsActive = parameters["IsActive"]; CategoryDataAccess _categoryAccess = new CategoryDataAccess(_iconfiguration); DatabaseResponse response = await _categoryAccess.GetCategories(paramIsActive); if (response.ResponseCode == (int)DbReturnValue.RecordExists) { return(Ok(new OperationResponse { HasSucceeded = true, IsDomainValidationErrors = false, Message = EnumExtensions.GetDescription(DbReturnValue.RecordExists), ReturnedObject = response.Results })); } else { Log.Error(EnumExtensions.GetDescription(DbReturnValue.NoRecords)); return(Ok(new OperationResponse { HasSucceeded = false, IsDomainValidationErrors = false, Message = EnumExtensions.GetDescription(DbReturnValue.NoRecords) })); } } catch (Exception ex) { Log.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); return(Ok(new OperationResponse { HasSucceeded = false, Message = StatusMessages.ServerError, StatusCode = ((int)ResponseStatus.ServerError).ToString(), IsDomainValidationErrors = false })); } }
public int AddNewFood(string foodName, double foodprice, string categoryName) { CategoryDataAccess categoryDataAccess = new CategoryDataAccess(); int categoryId = categoryDataAccess.GetCategoryId(categoryName); Food food = new Food() { FoodName = foodName, FoodPrice = foodprice, CategoryId = categoryId }; this.foodDataAccess = new FoodDataAccess(); return(this.foodDataAccess.AddFood(food)); }
public void DeleteFromDatabase_CategoryToDelete_CorrectlyDelete() { var category = new Category { Name = "categoryToDelete" }; var dataAccess = new CategoryDataAccess(_connectionCreator); dataAccess.SaveItem(category); Assert.IsTrue(dataAccess.LoadList(x => x.Id == category.Id).Any()); dataAccess.DeleteItem(category); Assert.IsFalse(dataAccess.LoadList(x => x.Id == category.Id).Any()); }
public int UpdateExistingFood(int foodId, string foodName, double foodprice, string categoryName) { CategoryDataAccess categoryDataAccess = new CategoryDataAccess(); int categoryId = categoryDataAccess.GetCategoryId(categoryName); Food food = new Food() { FoodId = foodId, FoodName = foodName, FoodPrice = foodprice, CategoryId = categoryId }; this.foodDataAccess = new FoodDataAccess(); return(this.foodDataAccess.UpdateFood(food)); }
public int AddNewOrder(string customerName, int customerNumber, string orderdCategory, string orderdFood, int price, string DeliveryType, string categoryName) { CategoryDataAccess categoryDataAccess = new CategoryDataAccess(); int categoryId = categoryDataAccess.GetCategoryId(categoryName); Order order = new Order() { CustomerName = customerName, CustomerNumber = customerNumber, OrderdCategory = orderdCategory, OrderdFood = orderdFood, }; this.orderDataAccess = new OrderDataAccess(); return(this.orderDataAccess.AddOrder(order)); }
private void frmProductAdd_Load(object sender, EventArgs e) { keyValues = CategoryDataAccess.GetCategoriesForProduct(); if (keyValues != null && cmbCategory.Items.Count < 1) { foreach (var item in keyValues) { cmbCategory.Items.Add(item.Value); categoryIds.Add(item.Key); } } if (productId > 0) { btnAdd.Text = "Update"; } }
public void SaveToDatabase_ExistingCategory_CorrectId() { var category = new Category(); var dataAccess = new CategoryDataAccess(_connectionCreator); dataAccess.SaveItem(category); Assert.IsNull(category.Name); var id = category.Id; var name = "TestCategory"; category.Name = name; Assert.AreEqual(id, category.Id); Assert.AreEqual(name, category.Name); }
public static void AddNewPreferencesDueToNewCustomer(CustomerEntity customer) { // Add all the categories as preferences. CustomerDataAccess customerDataAccess = new CustomerDataAccess(); CategoryDataAccess categoryDataAccess = new CategoryDataAccess(); foreach (CategoryEntity category in categoryDataAccess.LoadAll(false)) { PreferenceEntity preference = new PreferenceEntity(); preference.Active = true; preference.Level = 0; preference.Category = category; preference.IdCustomer = customer.Id; preference.IsNew = true; customer.Preferences.Add(preference); } customerDataAccess.Save(customer); }
public frmProductAdd(Form frmProduct, int userId, int productId) { this.frmProduct = frmProduct; this.userId = userId; this.productId = productId; InitializeComponent(); keyValues = CategoryDataAccess.GetCategoriesForProduct(); if (keyValues != null && cmbCategory.Items.Count < 1) { foreach (var item in keyValues) { cmbCategory.Items.Add(item.Value); categoryIds.Add(item.Key); } } ViewProductInfo(); }
public void SaveToDatabase_MultipleCategories_AllSaved() { var category1 = new Category { Name = "Einkaufen" }; var category2 = new Category { Name = "Beer" }; var dataAccess = new CategoryDataAccess(_connectionCreator); dataAccess.SaveItem(category1); dataAccess.SaveItem(category2); var resultList = dataAccess.LoadList(); Assert.IsTrue(resultList.Any(x => x.Id == category1.Id && x.Name == category1.Name)); Assert.IsTrue(resultList.Any(x => x.Id == category2.Id && x.Name == category2.Name)); }
public void SaveToDatabase_CreateAndUpdateCategory_CorrectlyUpdated() { var firstName = "old name"; var secondName = "new name"; var category = new Category { Name = firstName }; var dataAccess = new CategoryDataAccess(_connectionCreator); dataAccess.SaveItem(category); Assert.AreEqual(firstName, dataAccess.LoadList().FirstOrDefault(x => x.Id == category.Id).Name); category.Name = secondName; dataAccess.SaveItem(category); var categories = dataAccess.LoadList(); Assert.IsFalse(categories.Any(x => x.Name == firstName)); Assert.AreEqual(secondName, categories.First(x => x.Id == category.Id).Name); }