public bool SaveProduct(Products product)
{
try
{
ProductsDAO dao = new ProductsDAO();
bool error = false;
if (product != null)
{
if (product.Name.Equals(""))
{
error = true;
}
if (!error)
{
if (dao.CountProductName(product) == 0)
{
dao.InsertProduct(product);
return(true);
}
}
}
return(false);
}
catch (Exception e)
{
throw new Exception("Erro ao inserir o produto no banco de dados! " + e.Message);
}
}
public bool DeleteProduct(Products product)
{
ProductsDAO dao = new ProductsDAO();
bool error = false;
if (product != null)
{
if (dao.CountProductOrder(product) > 0)
{
error = true;
}
if (dao.CountProductSales(product) > 0)
{
error = true;
}
if (!error)
{
dao.DeleteProduct(product);
}
else
{
dao.ChangeProductActivated(product, false);
}
return(true);
}
return(false);
}
public bool UpdateProduct(Products product)
{
ProductsDAO dao = new ProductsDAO();
Products p;
bool error = false;
if (product != null)
{
p = dao.SelectProduct(product);
if (p != null)
{
if (!product.Name.Equals(""))
{
if (!product.Name.Equals(p.Name))
{
if (dao.CountProductName(product) != 0)
{
error = true;
}
}
}
if (!error)
{
dao.UpdateProduct(product);
return(true);
}
}
}
return(false);
}
public void dataEvent(object sender, FormClosedEventArgs e)
{
List <ProductsPOJO> productsList = ProductsDAO.Select();
dtgProducts.DataSource = null;
dtgProducts.DataSource = productsList;
}
public IActionResult Search(string searchTerm)
{
ProductsDAO products = new ProductsDAO();
List <ProductModel> productList = products.SearchProducts(searchTerm);
return(View("index", productList));
}
public ActionResult <int> ProcessInsert(ProductModel product)
{
ProductsDAO products = new ProductsDAO();
int newId = products.Insert(product);
return(newId);
}
public JsonResult InsertRegister(Customer item, Account ac)
{
ProductsDAO dao = new ProductsDAO();
if (item == null || ac == null)
{
return(Json(new { Success = false }, JsonRequestBehavior.AllowGet));
}
var old = dao.Model.Customers.FirstOrDefault(f => f.ID == item.ID);
var oldAc = dao.Model.Accounts.FirstOrDefault(f => f.id == ac.id);
if (old != null && oldAc != null)
{
return(Json(new { Success = false }, JsonRequestBehavior.AllowGet));
}
else
{
var oldAcName = dao.Model.Accounts.FirstOrDefault(f => f.UserName == ac.UserName);
if (oldAcName != null)
{
return(Json(new { Success = false }, JsonRequestBehavior.AllowGet));
}
else
{
dao.Model.Customers.Add(item);
dao.Model.SaveChanges();
ac.RoleID = 1;
ac.CustomerID = dao.Model.Customers.OrderByDescending(y => y.ID).Select(y => y.ID).FirstOrDefault();
ac.Pwd = MD5Hash(ac.Pwd);
dao.Model.Accounts.Add(ac);
dao.Model.SaveChanges();
return(Json(new { Success = true }, JsonRequestBehavior.AllowGet));
}
}
}
/// <summary>
/// Displays product information by supplier id to the user.
/// </summary>
/// <param name="productInfo"></param>
static void DisplayProducts(List <ProductsDO> items)
{
string currentMethod = "DisplayProducts";
try
{
//Prints all rows.
if (items.Count > 0)
{
for (int i = 0; i < items.Count; i++)
{
Console.WriteLine(new string('-', 80));
Console.WriteLine($"ProductID: { items[i].ProductId}---| Product Name: {items[i].ProductName}\n | Quanity Per Unit: " +
$"{ items[i].QuantityPerUnit} | Price per unit: ${items[i].UnitPrice.ToString("#.##")} | Units in stock: { items[i].UnitsInStock}\n | Units on order: " +
$"{items[i].UnitsOnOrder} | Reorder Level: {items[i].ReorderLevel}");
}
}
Console.WriteLine("\n\t\t\tPress any key to continue.");
Console.ReadKey();
}
catch (Exception ex)
{
string currentClass = "Program";
ProductsDAO productsDAO = new ProductsDAO();
//Prints error to console, logs, and restarts the menu.
productsDAO.ProductsErrorHandler(ex, currentClass, currentMethod, ex.StackTrace);
throw ex;
}
}
public void data()
{
List <ProductsPOJO> productsList = ProductsDAO.Select();
dtgProducts.DataSource = null;
dtgProducts.DataSource = productsList;
}
public ActionResult <IEnumerable <ProductModel> > SearchResults(string searchTerm)
{
ProductsDAO products = new ProductsDAO();
List <ProductModel> productList = products.SearchProducts(searchTerm);
return(productList);
}
public ActionResult <ProductModelDTO> ShowOneProduct(int id)
{
ProductsDAO products = new ProductsDAO();
ProductModelDTO pdto = new ProductModelDTO(products.GetProductById(id));
return(pdto);
}
public ActionResult <ProductModel> ProcessEdit(ProductModel product)
{
ProductsDAO products = new ProductsDAO();
products.Update(product);
return(products.GetProductById(product.Id));
}
public string ImageDetail(int id)
{
//List<String> lst = new List<string>();
ProductsDAO dao = new ProductsDAO();
//var lstImg = dao.GetAllImgProduct();
//foreach (var item in lstImg)
//{
// if (item.ProductID == id)
// lst.Add(item.ImgLink);
// else
// s
var lstImg = dao.ListImg(id);
string tempStr = "";
for (int i = 0; i < lstImg.Count; i++)
{
var s = "\"item_" + i + "\":{\"orig\":\"../../Images/ThePicture" + lstImg[i].ImgLink + "\",\"main\":\"../../Images/ThePicture//" + lstImg[i].ImgLink + "\",\"thumb\":\"../../Images/ThePicture/" + lstImg[i].ImgLink + "\",\"label\":\"\"}";
tempStr += s.ToString();
if (i != (lstImg.Count - 1))
{
tempStr += ",";
}
}
return(tempStr.Replace("\"", ""));;
}
public ActionResult GetCategoryList()
{
ProductsDAO dao = new ProductsDAO();
var lstCt = dao.GetAllCategory();
return(PartialView(lstCt));
}
public static List <InventoryItem> getNext10Products(int from)
{
ProductsDAO datalayer = new ProductsDAO();
List <InventoryItem> items = datalayer.getNextTenItems(from);
return(items);
}
public static InventoryItem getSingleItem(int viewItem)
{
ProductsDAO datalayer = new ProductsDAO();
InventoryItem item = datalayer.getSingleItem(viewItem);
return(item);
}
public bool DeleteSaleItem(SaleItems item)
{
try
{
SalesDAO salesDAO = new SalesDAO();
SaleItemsDAO itemsDAO = new SaleItemsDAO();
ProductsDAO productsDAO = new ProductsDAO();
UserDAO userDAO = new UserDAO();
if (item != null)
{
if (userDAO.CheckLogin(item.Sale.User) == null)
{
return(false);
}
if (!salesDAO.CheckUserPermission(item.Sale))
{
return(false);
}
itemsDAO.DeleteSaleItem(item);
return(true);
}
return(false);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (!DataIsValid())
{
return;
}
Prod = new ProductsPOJO(
EditMode ? Prod.ProductID : -1,
txtProductName.Text,
(int)cmbSupplier.SelectedValue,
(int)cmbCategory.SelectedValue,
txtQuantityPerUnit.Text,
(double)nmUnitPrice.Value,
(int)nmUnitsInStock.Value,
(int)nmUnitsOnOrder.Value,
(int)nmReorderLevel.Value,
chkDescontinued.Checked ? 1 : 0
);
bool success = EditMode ? ProductsDAO.Update(Prod) : ProductsDAO.Insert(Prod);
if (!success)
{
MessageBox.Show(null, "Ocurrió un error.", "Error",
MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
MessageBox.Show(null, "Cambios guardados correctamente.", "Info",
MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
public void UpdateProduct(int id, string name, int brandId, string shortDescription, string longDescription, string price, int colorId)
{
try
{
name = name.TrimEnd().TrimStart();
shortDescription = shortDescription.TrimEnd().TrimStart();
}
catch (Exception)
{
throw new Exception("No es posible actualizar el Producto");
}
ProductsDAO dao = new ProductsDAO();
Product updatedProduct = dao.GetProduct(id);
if (updatedProduct != null)
{
updatedProduct.name = name;
updatedProduct.brandId = brandId;
updatedProduct.shortDescription = shortDescription;
updatedProduct.longDescription = longDescription;
updatedProduct.price = price;
updatedProduct.colorId = colorId;
int result = dao.UpdateProduct(updatedProduct);
if (result < 1)
{
throw new Exception("No es posible actualizar el Producto");
}
}
}
private void EliminarBtn_Click(object sender, EventArgs e)
{
bool result = false;
try {
DialogResult res = MessageBox.Show("¿Desea eliminar el proveedor?",
"My Store Desktop", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (res == DialogResult.Yes)
{
int fila = dgvDatos.CurrentRow.Index;
producto = productos.ElementAt(fila);
ProductsDAO pDAO = new ProductsDAO();
result = pDAO.Delete(producto.ProductID);
if (result)
{
GetProductos();
}
else
{
MessageBox.Show("Error al eliminar el producto",
"My Store Desktop", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
} catch (Exception ex) {
MessageBox.Show("Error al eliminar el producto: " + ex.Message, "My Store Desktop",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public JsonResult Insert(Product item)
{
ProductsDAO dao = new ProductsDAO();
if (item == null)
{
return(Json(new { Success = false }, JsonRequestBehavior.AllowGet));
}
var old = dao.Model.Products.FirstOrDefault(f => f.ID == item.ID);
if (old != null)
{
return(Json(new { Success = false }, JsonRequestBehavior.AllowGet));
}
else
{
var oldName = dao.Model.Products.FirstOrDefault(f => f.ProductName == item.ProductName);
if (oldName != null)
{
return(Json(new { Success = false }, JsonRequestBehavior.AllowGet));
}
dao.Model.Products.Add(item);
dao.Model.SaveChanges();
return(Json(new { Success = true }, JsonRequestBehavior.AllowGet));
}
}
public static bool insertNewItem(InventoryItem updateItem)
{
ProductsDAO datalayer = new ProductsDAO();
bool success = datalayer.insertNewItem(updateItem);
return(success);
}
public static List <InventoryItem> getAllItems()
{
ProductsDAO datalayer = new ProductsDAO();
List <InventoryItem> completeInventory = datalayer.getAllInventory();
return(completeInventory);
}
public static bool updateInventoryItem(InventoryItem item)
{
ProductsDAO datalayer = new ProductsDAO();
bool success = datalayer.updateInventoryItem(item);
return(success);
}
public IActionResult Index()
{
//HardCodedSampleDataRepo hardCodedSampleDataRepo = new HardCodedSampleDataRepo();
ProductsDAO products = new ProductsDAO();
return(View(products.GetAllProducts()));
}
public Product GetProduct(int id)
{
Product product = new Product();
ProductsDAO dao = new ProductsDAO();
product = dao.GetProduct(id);
return(product);
}
public List <Product> GetAllProducts()
{
List <Product> products = new List <Product>();
ProductsDAO dao = new ProductsDAO();
products = dao.GetAllProducts();
return(products);
}
//
// GET: /Products/
public ActionResult Category(int id)
{
ProductsDAO dao = new ProductsDAO();
var lstProductCate = dao.ListProductCate(id);
this.ViewBag.lstProductCate = lstProductCate;
return(View());
}
public static List <Product> Register(this Product p)
{
using (var contextProd = new ProductsDAO())
{
contextProd.Add(p);
return(contextProd.Products());
}
}
public ActionResult <int> DeleteOne(int Id)
{
ProductsDAO products = new ProductsDAO();
ProductModel product = products.GetProductById(Id);
int success = products.Delete(product);
return(success);
}
