public AdminProductController()
{
categoryManagement = new CategoryManagement();
storageManagement = new StorageManagement();
cargoManagement = new CargoManagement();
productManagement = new ProductManagement();
}
private void updateCategoryButton_Click(object sender, EventArgs e)
{
string id = txtIDCategory.Text;
string category = txtNameCategory.Text;
try
{
if (CategoryManagement.UpdateCategoryById(id, category))
{
FrmMain.Instance.ToolStripLabel.Text = "Se modificó la categoría de manera correcta.";
Clear();
categoryModels = CategoryManagement.SelectAllCategories();
WireUpCategoryGridView();
WireUpCategoryComboBox();
}
else
{
FrmMain.Instance.ToolStripLabel.Text = "Ha ocurrido un error al modificar la categoría, inténtelo nuevamente.";
}
}
catch (Exception)
{
throw;
}
}
public IHttpActionResult GetCategoryById(string id)
{
try
{
var mng = new CategoryManagement();
var category = new Category
{
IDCategory = id
};
category = mng.RetrieveById(category);
apiResp = new ApiResponse();
apiResp.Data = category;
return(Ok(apiResp));
}
catch (BussinessException bex)
{
var MessageManage = new ApplicationMessageManagement();
MessageManage.Create(bex.AppMessage);
return(InternalServerError(new Exception(bex.ExceptionId + "-"
+ bex.AppMessage.Message)));
}
catch (Exception ex)
{
ApplicationMessage msg = new ApplicationMessage
{
Message = ex.Message
};
var MessageManage = new ApplicationMessageManagement();
MessageManage.Create(msg);
return(InternalServerError(new Exception(ex.Message)));
}
}
public void GetAllCategoriesTest()
{
List <Category> listOfCategories = new List <Category>();
Category categoryOfBeach = new Category
{
Id = Guid.NewGuid(),
Name = "Playita y calor"
};
listOfCategories.Add(categoryOfBeach);
Category categoryOfCold = new Category
{
Id = Guid.NewGuid(),
Name = "Frio"
};
listOfCategories.Add(categoryOfCold);
var categoryMock = new Mock <ICategoryRepository>(MockBehavior.Strict);
categoryMock.Setup(m => m.GetAll()).Returns(new List <Category>(listOfCategories));
CategoryManagement categoryLogic = new CategoryManagement(categoryMock.Object);
List <Category> result = categoryLogic.GetAllCategories();
categoryMock.VerifyAll();
CollectionAssert.AreEqual(listOfCategories, result);
}
public void GetAllCategoriesAssociatedTestOk()
{
List <Guid> listOfIdentifier = new List <Guid>();
Guid guid1 = Guid.NewGuid();
Guid guid2 = Guid.NewGuid();
listOfIdentifier.Add(guid1);
listOfIdentifier.Add(guid2);
var categoryMock = new Mock <ICategoryRepository>(MockBehavior.Strict);
categoryMock.Setup(m => m.Get(guid1)).Returns(new Category()
{
Id = guid1
});
categoryMock.Setup(m => m.Get(guid2)).Returns(new Category()
{
Id = guid2
});
CategoryManagement categoryLogic = new CategoryManagement(categoryMock.Object);
List <Category> result = categoryLogic.GetAssociatedCategories(listOfIdentifier);
List <Guid> listOfIdentifiersGetted = new List <Guid>();
foreach (Category category in result)
{
listOfIdentifiersGetted.Add(category.Id);
}
categoryMock.VerifyAll();
CollectionAssert.AreEqual(listOfIdentifier, listOfIdentifiersGetted);
}
public ShopListPresentationModel(CategoryManagement productTypeManagement, ProductManagement productManagement)
{
this._productTypeManagement = productTypeManagement;
_productManagement = productManagement;
_cart = new AddToCart();
RowCount = 0;
}
public IActionResult ManageCategory()
{
CategoryManagement c = new CategoryManagement(db);
IEnumerable <Category> categories = c.retrieveCategories();
return(View(categories));
}
private void SaveCategoryButton_Click(object sender, EventArgs e)
{
try
{
if (!string.IsNullOrEmpty(CategoryNameTextBox.Text))
{
if (CategoryManagement.SelectCategoryByName(CategoryNameTextBox.Text) == null)
{
if (CategoryManagement.InsertCategory(CategoryNameTextBox.Text))
{
FrmMain.Instance.ToolStripLabel.Text = "Se agrego la Categoría correctamente.";
CategoryNameTextBox.Text = "";
ReloadCategoryDataGridView();
ReloadCategoryComboBox();
}
}
else
{
MetroMessageBox.Show(this, "Ya existe una categoría con ese nombre.", "Categoría repetida", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MetroMessageBox.Show(this, "El campo del nombre de la categoría no puede estar vacío.", "Campo vacío", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch (Exception ex)
{
}
}
public async Task ShouldRetrieveAllCategories()
{
List <CategoryDto> categoryList = new List <CategoryDto>()
{
new CategoryDto
{
CategoryId = 1,
CategoryName = "CHAIRS"
//CategoryDesc = ""
},
new CategoryDto
{
CategoryId = 2,
CategoryName = "COFFEE TABLES"
}
};
_categoryRepositoryMock.Setup(x => x.GetCategories()).ReturnsAsync(categoryList);
_unitOfWorkMock.Setup(m => m.CategoryRepository).Returns(_categoryRepositoryMock.Object);
var categoryManagement = new CategoryManagement(_unitOfWorkMock.Object);
List <CategoryDto> categories = await categoryManagement.GetCategories().ConfigureAwait(false);
Assert.NotNull(categories);
Assert.IsAssignableFrom <List <CategoryDto> >(categories);
Assert.Equal(2, categories.Count);
}
private void DeleteCategoryButton_Click(object sender, EventArgs e)
{
try
{
if (CategoryDataGridView.Rows.Count != 0)
{
if (MetroMessageBox.Show(this, $"¿Seguro que desea eliminar la categoría: { CategoryDataGridView.CurrentRow.Cells[1].Value.ToString() }?", "Eliminar categoría", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
if (CategoryManagement.DeleteCategoryById(int.Parse(CategoryDataGridView.CurrentRow.Cells[0].Value.ToString())))
{
FrmMain.Instance.ToolStripLabel.Text = "Se eliminó la Categoría correctamente.";
CategoryNameTextBox.Text = "";
ReloadCategoryDataGridView();
ReloadCategoryComboBox();
}
else
{
MetroMessageBox.Show(this, $"Ha ocurrido un error al eliminar la categoría: { CategoryDataGridView.CurrentRow.Cells[1].Value.ToString()}.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
else
{
MetroMessageBox.Show(this, "Debe seleccionar una categoría para poder eliminarla.", "Campo vacío", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch (Exception ex)
{
}
}
public IHttpActionResult GetAvailableCategories()
{
try
{
apiResp = new ApiResponse();
var mng = new CategoryManagement();
apiResp.Data = mng.RetrieveAvailable();
return(Ok(apiResp));
}
catch (BussinessException bex)
{
var MessageManage = new ApplicationMessageManagement();
MessageManage.Create(bex.AppMessage);
return(InternalServerError(new Exception(bex.ExceptionId + "-"
+ bex.AppMessage.Message)));
}
catch (Exception ex)
{
ApplicationMessage msg = new ApplicationMessage
{
Message = ex.Message
};
var MessageManage = new ApplicationMessageManagement();
MessageManage.Create(msg);
return(InternalServerError(new Exception(ex.Message)));
}
}
public async Task Should_Return__Exception_When_CategoriesNotAvailable()
{
var categoryManagement = new CategoryManagement(_unitOfWorkMock.Object);
_unitOfWorkMock.Setup(m => m.CategoryRepository).Returns(_categoryRepositoryMock.Object);
await Assert.ThrowsAsync <ArgumentNullException>(async() => await categoryManagement.GetCategories().ConfigureAwait(false));
}
public void GetClientExceptionObteinedAllCategoriesTest()
{
List <Category> listOfCategories = new List <Category>();
Category category = new Category
{
Id = Guid.NewGuid(),
Name = "Playita y calor"
};
listOfCategories.Add(category);
Category category2 = new Category
{
Id = Guid.NewGuid(),
Name = "Frio"
};
listOfCategories.Add(category2);
var categoryMock = new Mock <ICategoryRepository>(MockBehavior.Strict);
categoryMock.Setup(m => m.GetAll()).Throws(new ClientException());
CategoryManagement categoryLogic = new CategoryManagement(categoryMock.Object);
List <Category> result = categoryLogic.GetAllCategories();
}
public IHttpActionResult UpdateCategory(Category category)
{
try
{
var mng = new CategoryManagement();
mng.Update(category);
apiResp = new ApiResponse
{
Message = "Action was executed."
};
return(Ok(apiResp));
}
catch (BussinessException bex)
{
var MessageManage = new ApplicationMessageManagement();
MessageManage.Create(bex.AppMessage);
return(InternalServerError(new Exception(bex.ExceptionId + "-"
+ bex.AppMessage.Message)));
}
catch (Exception ex)
{
ApplicationMessage msg = new ApplicationMessage
{
Message = ex.Message
};
var MessageManage = new ApplicationMessageManagement();
MessageManage.Create(msg);
return(InternalServerError(new Exception(ex.Message)));
}
}
public void CreateInvalidLodgingWithoutRegionOnTouristSpotTest()
{
var lodgingRepositoryMock = new Mock <ILodgingRepository>(MockBehavior.Strict);
lodgingRepositoryMock.Setup(m => m.Add(It.IsAny <Lodging>()));
lodgingRepositoryMock.Setup(m => m.GetLodgingByNameAndTouristSpot(lodging.Name, touristSpot.Id)).Returns(value: null);
var touristSpotRepositoryMock = new Mock <ITouristSpotRepository>(MockBehavior.Strict);
touristSpotRepositoryMock.Setup(m => m.Get(It.IsAny <Guid>())).Throws(new ClientBusinessLogicException());
touristSpotRepositoryMock.Setup(m => m.GetTouristSpotByName(It.IsAny <string>())).Returns(value: null);
touristSpotRepositoryMock.Setup(m => m.Add(It.IsAny <TouristSpot>()));
var regionMock = new Mock <IRepository <Region> >(MockBehavior.Strict);
regionMock.Setup(m => m.Get(It.IsAny <Guid>())).Throws(new ClientBusinessLogicException());
RegionManagement regionLogic = new RegionManagement(regionMock.Object);
var categoryMock = new Mock <ICategoryRepository>(MockBehavior.Strict);
categoryMock.Setup(m => m.Get(It.IsAny <Guid>())).Returns(aCategory);
CategoryManagement categoryLogic = new CategoryManagement(categoryMock.Object);
TouristSpotManagement touristSpotLogic = new TouristSpotManagement(touristSpotRepositoryMock.Object, regionLogic, categoryLogic);
LodgingManagementForImportation lodgingLogic = new LodgingManagementForImportation(lodgingRepositoryMock.Object, touristSpotLogic);
Lodging resultOfCreateALodging = lodgingLogic.Create(lodging, touristSpot, listOfPicturesPath);
}
public ProjectController()
{
this.pm = new ProjectManagement();
this.cm = new CompentenceManagement();
this.categoryM = new CategoryManagement();
this.tk = new TaskManagement();
this.am = new AccountManagement();
}
public ActionResult Paging(int num)
{
var list = ProductManagement.GetProductsIncludeHidden();
var categories = CategoryManagement.GetAllCategory();
var products = ApplyPaging(list, num).Select(x => ConvertToProductDTO(x, categories));
return(Json(products, JsonRequestBehavior.AllowGet));
}
public JsonResult GetSubCategories(int CategoryId)
{
CategoryManagement c = new CategoryManagement(db);
List <SubCategoryDetail> sub = c.retrieveSubCategories(CategoryId);
return(Json(sub));
}
public ProductManagementSystem(ReadFile initial, CategoryManagement categoryManagement, ProductManagement productManagement)
{
InitializeComponent();
_categoryManagement = categoryManagement;
_productManagement = productManagement;
_productManagement._writeNewData += UpdateListBox;
_categoryManagement._addNewCategory += UpdateComboBoxSelection;
_productManagementSystemPresentationModel = new ProductManagementSystemPresentationModel(_categoryManagement, _productManagement);
this.InitialForm();
this.InitialListBox();
}
public ShopList(CategoryManagement productTypeManagement, ProductManagement productManagement)
{
InitializeComponent();
_categoryManagement = productTypeManagement;
_productManagement = productManagement;
_itemTabControlPages = new ItemTabControlPages(_itemTabControl, _categoryManagement);
_shopListPresentationModel = new ShopListPresentationModel(_categoryManagement, _productManagement);
_productManagement._writeNewData += UpdateProductData;
_categoryManagement._addNewCategory += AddNewTabPage;
this.InitialForm();
}
private void SearchCategoryTextBox_ButtonClick(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(SearchCategoryTextBox.Text))
{
CategoryDataGridView.DataSource = CategoryManagement.SelectCategoriesByName(SearchCategoryTextBox.Text);
}
else
{
ReloadCategoryDataGridView();
}
}
private void LoadData()
{
url = textBox1.Text;
Crawler cr = new Crawler();
cr.LoadData(url);
List <string> paths = cr.paths;
main.textBoxProductName.Text = cr.title;
main.pictureBoxBaseImage.Image = Bitmap.FromFile(paths[0]);
main.linkLabel1.Text = paths[0];//등록후 패쓰에서는 뺀다
main.textBoxPrice.Text = cr.price;
main.textBoxDiscount.Text = cr.discount;
main.textBoxDiscountAmount.Text = cr.discountPrice;
paths.RemoveAt(0);
main.dataGridView1.Rows.Clear();
foreach (string path in paths)
{
main.dataGridView1.Rows.Add(path);
}
//브랜드를 찾아보고 없으면 등록.
BrandManagement bm = new BrandManagement(mainForm.dbLoginInfo);
string brandName = cr.title.Substring(cr.title.IndexOf('[') + 1, cr.title.IndexOf(']') - cr.title.IndexOf('[') - 1);
int index = bm.FindBrandIndex(brandName);
if (index < 1)
{
//브랜드를 등록한다
bm.AddBrand(brandName);
//브랜드 리로드
main.comboBoxBrand.Items.Clear();
string[] brands = bm.LoadBrand();
foreach (string name in brands)
{
main.comboBoxBrand.Items.Add(name);
}
index = bm.FindBrandIndex(brandName);
}
var test = string.Format("{0:000}|{1}", index, brandName);
main.comboBoxBrand.SelectedItem = string.Format("{0:000}|{1}", index, brandName);
//카테고리는 선택만(없으면 생략)
CategoryManagement cm = new CategoryManagement(mainForm.dbLoginInfo);
index = cm.FindCategory(cr.category);
if (index > 0)
{
string text = string.Format("{0:000} | {1} | {2:000}", index, cr.category, cm.FindParentIndex(index));
main.buttonCategory.Text = text;
}
}
private List <SelectListItem> GetCategoryDropdownData()
{
CategoryManagement categoryManagement = new CategoryManagement();
var query = from cat in categoryManagement.GetAllCategory()
select new SelectListItem
{
Value = cat.Category_ID.ToString(),
Text = cat.Category_Name
};
return(query.ToList());
}
public ActionResult Index()
{
var serializer = new JavaScriptSerializer();
var products = ProductManagement.GetProductsIncludeHidden();
var categories = CategoryManagement.GetAllCategory();
var productDTO = ApplyPaging(products, 1).Select(x => ConvertToProductDTO(x, categories));
ViewBag.ProductDetail = serializer.Serialize(new EditProductDTO());
ViewBag.Products = serializer.Serialize(productDTO);
ViewBag.Categories = serializer.Serialize(categories.Select(x => new { x.Id, x.Name }));
ViewBag.TotalProductPage = (int)Math.Ceiling(((double)products.Count() / (double)pageSize));
return(View());
}
private void UcProduct_Load(object sender, EventArgs e)
{
categoryModels = CategoryManagement.SelectAllCategories();
subCategoryModels = SubCategoryManagement.SelectAllSubCategories();
dgvProduct.DataSource = ProductManagement.SelectAllProducts();
cmbBrand.DataSource = BrandManagement.SelectAllBrands();
cmbBrand.DisplayMember = "Name";
WireUpCategoryComboBox();
WireUpSubCategoryComboBox();
}
private void ReloadCategoryDataGridView()
{
categoryModels = CategoryManagement.SelectAllCategories();
CategoryDataGridView.MultiSelect = false;
CategoryDataGridView.DataSource = categoryModels;
CategoryDataGridView.Columns["Id_Category"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
CategoryDataGridView.Columns["Name"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
CategoryDataGridView.Columns["Id_Category"].HeaderText = "Id";
CategoryDataGridView.Columns["Name"].HeaderText = "Categoría";
CategoryDataGridView.Columns["Id_Category"].Visible = false;
}
public IActionResult AddItemStock()
{
CategoryManagement cat = new CategoryManagement(db);
IEnumerable <Category> categories = cat.retrieveCategories();
//IEnumerable<SubCategory> subcategories = cat.retrieveSubCategories();
ViewData["Categories"] = categories;
// ViewData["SubCategories"] = subcategories;
return(View());
}
//Carga datos de inicio
private void UcProduct_Load(object sender, EventArgs e)
{
ReloadProduct();
brandModels = BrandManagement.SelectAllBrands();
BrandComboBox.DataSource = brandModels;
BrandComboBox.DisplayMember = "Name";
categoryModels = CategoryManagement.SelectAllCategories();
CategoryComboBox.DataSource = categoryModels;
CategoryComboBox.DisplayMember = "Name";
gravadoRadioButton.Checked = true;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
/*----Dropdown list for category id and supplier id----*/
SupplierManagement _supplierManagement = new SupplierManagement();
CategoryManagement _categoryManagement = new CategoryManagement();
ddlSupplier.DataSource = _supplierManagement.ListSuppliers().Tables[0];
ddlSupplier.DataTextField = "SupplierID";
ddlSupplier.DataBind();
ddlCategory.DataSource = _categoryManagement.ListCategory().Tables[0];
ddlCategory.DataTextField = "CategoryID";
ddlCategory.DataBind();
}
}
public void GetInvalidCategoryByIdNotFoundTest()
{
Guid idForCategory = Guid.NewGuid();
Category category = new Category
{
Id = idForCategory,
Name = "Playita y calor"
};
var categoryMock = new Mock <ICategoryRepository>(MockBehavior.Strict);
categoryMock.Setup(x => x.Get(It.IsAny <Guid>())).Throws(new ClientException());
CategoryManagement categoryLogic = new CategoryManagement(categoryMock.Object);
categoryLogic.GetById(idForCategory);
}
