private void btnAlterar_Click(object sender, EventArgs e)
{
try
{
Database.Entities.tb_product product = new Database.Entities.tb_product();
product.id_product = Convert.ToInt32(nudID.Value);
product.nm_product = txtNome.Text.Trim();
product.ds_typeProduct = cboTipo.Text.Trim();
product.vl_amount = Convert.ToInt32(nudQuantidade.Value);
product.vl_value = nudValor.Value;
product.ds_note = rtxtDescrição.Text.Trim();
Business.ProductBusiness busproduct = new Business.ProductBusiness();
busproduct.Alterar(product);
MessageBox.Show("Produto alterado com sucesso", "Alterado", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
catch (ArgumentException ex)
{
MessageBox.Show(ex.Message, "Atenção", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
catch (Exception)
{
MessageBox.Show("Ocorreu um erro!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public JsonResult UpdateProductCategory(ViewModel.ProductCategotyModel productCategory)
{
Business.ProductBusiness business = new Business.ProductBusiness();
var returnResult = business.UpdateProductCategory(productCategory);
return(Json(returnResult));
}
public ActionResult Product(int id)
{
//string CurrentAction = (string)this.RouteData.Values["id"];
var business = new Business.ProductBusiness();
var product = business.GetProduct(id);
var path = Server.MapPath($"~/AkoSatrapImages/{product.ImageFolderName}/");
product.Images = new List <string>();
if (System.IO.Directory.Exists(path))
{
var files = System.IO.Directory.GetFiles(path);
foreach (var file in files)
{
var fileName = System.IO.Path.GetFileName(file);
product.Images.Add($"../../AkoSatrapImages/{product.ImageFolderName}/{fileName}");
}
}
var lostFile = 8 - product.Images.Count;
for (int i = 0; i < lostFile; i++)
{
product.Images.Add("../../AkoSatrapImages/amghezi.jpg");
}
return(View(product));
}
private void btnConsultar_Click(object sender, EventArgs e)
{
Business.ProductBusiness busproduct = new Business.ProductBusiness();
List <Database.Entities.tb_product> productlista = busproduct.ConsultarTodos();
dgvConsultarProduto.DataSource = productlista;
}
// GET: Product
public ActionResult Index()
{
var business = new Business.ProductBusiness();
var allProduct = business.GetAllProduct(false);
allProduct.ForEach(r =>
{
var path = Server.MapPath($"~/AkoSatrapImages/{r.ImageFolderName}/");
r.Images = new List <string>();
if (System.IO.Directory.Exists(path))
{
var files = System.IO.Directory.GetFiles(path);
if (files.Count() > 0)
{
r.Images.Add($"../../AkoSatrapImages/{r.ImageFolderName}/{System.IO.Path.GetFileName(files[0])}");
}
else
{
r.Images.Add($"../../AkoSatrapImages/{r.ImageFolderName}/amghezi.jpg");
}
}
else
{
r.Images.Add($"../../AkoSatrapImages/amghezi.jpg");
}
});
return(View(allProduct));
}
public JsonResult UpdateProduct(ViewModel.ProductModel product)
{
Business.ProductBusiness business = new Business.ProductBusiness();
var returnResult = business.UpdateProduct(product);
return(Json(returnResult));
}
public JsonResult AddProduct(ViewModel.ProductModel product)
{
var business = new Business.ProductBusiness();
var returnResult = business.AddProduct(product);
return(Json(returnResult));
}
public JsonResult UpdateProductDetail(ViewModel.ProductFeatureModel productFeature)
{
Business.ProductBusiness business = new Business.ProductBusiness();
var returnResult = business.UpdateProductFeature(productFeature);
return(Json(returnResult));
}
private void nudID_ValueChanged(object sender, EventArgs e)
{
int id = Convert.ToInt32(nudID.Value);
Business.ProductBusiness busproduct = new Business.ProductBusiness();
Database.Entities.tb_product product = busproduct.ConsultarPorID(id);
if (product == null)
{
txtNome.Text = string.Empty;
cboTipo.Text = null;
txtLocalDoEstoque.Text = string.Empty;
nudQuantidade.Value = 0;
nudValor.Value = Convert.ToDecimal("0,00");
rtxtDescrição.Text = string.Empty;
}
else
{
txtNome.Text = product.nm_product;
cboTipo.Text = product.ds_typeProduct;
txtLocalDoEstoque.Text = product.ds_placeStock;
nudQuantidade.Value = product.vl_amount;
nudValor.Value = product.vl_value;
rtxtDescrição.Text = product.ds_note;
}
}
private void btnDeletar_Click(object sender, EventArgs e)
{
int id = Convert.ToInt32(nudID.Value);
Business.ProductBusiness busproduct = new Business.ProductBusiness();
busproduct.Remover(id);
MessageBox.Show("Produto deletado com sucesso", "Deletado", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
public JsonResult GetProductList()
{
GridResult <ViewModel.ProductModel> gridResult = new GridResult <ViewModel.ProductModel>();
var allProduct = new Business.ProductBusiness().GetAllProduct();
gridResult.Data = allProduct.OrderByDescending(r => r.Id).ToList();
gridResult.Total = allProduct.Count;
return(Json(gridResult, JsonRequestBehavior.AllowGet));
}
private void Consulta()
{
Database.Entities.tb_product product = new Database.Entities.tb_product();
product.nm_product = txtNome.Text.Trim();
product.ds_typeProduct = cboTipo.Text.Trim();
Business.ProductBusiness busproduct = new Business.ProductBusiness();
List <Database.Entities.tb_product> productlista = busproduct.Consultar(product);
dgvConsultarProduto.DataSource = productlista;
}
public JsonResult GetProductDetail(int productId)
{
//var productId = Convert.ToInt32(Request.QueryString["productId"]);
GridResult <ViewModel.ProductFeatureModel> gridResult = new GridResult <ViewModel.ProductFeatureModel>();
var allDetail = new Business.ProductBusiness().GetAllProductDetail(productId);
gridResult.Data = allDetail.OrderByDescending(r => r.Id).ToList();
gridResult.Total = allDetail.Count;
return(Json(gridResult, JsonRequestBehavior.AllowGet));
}
public JsonResult GetProductCategoryList()
{
int pageNumber = Convert.ToInt32(Request.QueryString["page"]);
int pageSize = Convert.ToInt32(Request.QueryString["pageSize"]);
GridResult <ViewModel.ProductCategotyModel> gridResult = new GridResult <ViewModel.ProductCategotyModel>();
var allCategory = new Business.ProductBusiness().GetAllProductCategory();
gridResult.Data = allCategory.OrderByDescending(r => r.Id).Skip((pageNumber - 1) * pageSize).Take(pageSize).ToList();
gridResult.Total = allCategory.Count;
return(Json(gridResult, JsonRequestBehavior.AllowGet));
}
private void button_enregistrer_Click(object sender, EventArgs e)
{
if (textBox_codeBarre.Text == "")
{
MessageBox.Show("Veuillez remplir le champ code à barres");
}
else
{
datePeremption = dateTimePicker_peremption.Value;
codeBarre = textBox_codeBarre.Text;
objProductBusiness = new ProductBusiness();
objProductBusiness.AjouterProduit(codeBarre, datePeremption);
}
}
public JsonResult AddImage(FileAttachment fileAttachment, int id)
{
var returnResult = new ViewModel.ReturnResult <bool>();
if (fileAttachment.Attachment.ContentLength > 2097152)
{
returnResult.SetError("حجم فایل نمیتواند بیشتر از 2 مگابایت باشد");
return(Json(returnResult));
}
Business.ProductBusiness business = new Business.ProductBusiness();
var product = business.GetProductById(id);
var path = Server.MapPath($"~/AkoSatrapImages/{product.ImageFolderName}/");
if (!System.IO.Directory.Exists(path))
{
System.IO.Directory.CreateDirectory(path);
}
fileAttachment.Attachment.SaveAs($"{path}/{Guid.NewGuid()}.{fileAttachment.Attachment.FileName.Split('.')[1].ToString()}");
return(Json(returnResult));
}
public JsonResult GetProductCategoryListForDropDown()
{
var allCategory = new Business.ProductBusiness().GetAllProductCategory();
return(Json(allCategory, JsonRequestBehavior.AllowGet));
}
