public ProductVO Create(ProductVO product)
{
Product productEntity = _converter.Parse(product);
productEntity = _repository.Create(_converter.Parse(product));
return(_converter.Parse(productEntity));
}
/// <summary>
/// Edit product details
/// </summary>
/// <param name="id">The product Id</param>
/// <returns>The product details view</returns>
public ActionResult ProductEdit(int id)
{
MODEL.Product product = null;
try
{
ProductService productService = new ProductService();
//Get product details
ProductVO productVO = productService.GetProductById(id);
if (productVO == null)
{
ModelState.AddModelError("", String.Format(Constants.ITEM_NOT_FOUND, Constants.PRODUCT));
}
else
{
product = new MODEL.Product(productVO);
}
}
catch (Exception e)
{
ModelState.AddModelError("", e.Message);
}
return(PartialView("ProductDetails", product));
}
public void Create([FromBody] ProductVO Product)
{
if (ModelState.IsValid)
{
da.AddProduct(Mapper.Map <Models.Product>(Product));
}
}
public void Edit([FromBody] ProductVO vo)
{
if (ModelState.IsValid)
{
da.UpdateProduct(Mapper.Map <Models.Product>(vo));
}
}
public IActionResult Update([FromBody] ProductVO product)
{
try
{
var productDO = new ProductDO
{
Id = product.Id,
ProductNumber = product.ProductNumber,
ProductName = product.ProductName,
ProductType = product.ProductType,
Price = Convert.ToDouble(product.Price)
};
_productService.Update(productDO);
return(Json(new
{
code = "success",
}));
}
catch (Exception ex)
{
return(Json(new
{
code = "fail",
message = ex.Message
}));
}
}
/// <summary>
/// Save the Product
/// </summary>
/// <param name="model">model Object</param>
/// <returns></returns>
public ActionResult ProductSave(MODEL.Product model)
{
try
{
if (ModelState.IsValid)
{
//Get user id
int? userId = Session.GetUserId();
ProductService productService = new ProductService();
//ProductVO productVO = new ProductVO(model, userId);
ProductVO productVO = model.Transpose(userId);
productService.SaveProduct(productVO);
return(new HttpStatusCodeResult(200));
}
else
{
throw new ApplicationException(String.Format(Constants.CANNOT_SAVE, Constants.PRODUCT));
}
}
catch (ApplicationException e)
{
return(new HttpStatusCodeAndErrorResult(500, e.Message));
}
}
public IActionResult Create([FromBody] ProductVO product)
{
var productDO = new ProductDO
{
ProductNumber = product.ProductNumber,
ProductName = product.ProductName,
Price = Convert.ToDouble(product.Price),
Price = product.Price
};
try
{
var insertedProduct = _productService.Insert(productDO);
return(Json(new
{
code = "success",
data = insertedProduct
}));
}
catch (Exception ex)
{
return(Json(new
{
code = "fail",
message = ex.Message
}));
}
}
public ProductVO Update(ProductVO product)
{
var productEntity = _repository.FindById(product.Id ?? 0);
SaveImageProduct imageProducts = new SaveImageProduct(_converter.Parse(product, productEntity));
imageProducts.Save();
return(_converter.Parse(_repository.Update(_converter.Parse(product, productEntity))));
}
public ProductVO Update(ProductVO item)
{
var productEntntiry = _converter.Parse(item);
productEntntiry = _repository.Update(_converter.Parse(item));
return(_converter.Parse(productEntntiry));
}
public IActionResult NovoProduto([FromBody] ProductVO product)
{
if (product == null)
{
return(BadRequest());
}
return(new OkObjectResult(_productBusiness.Create(product)));
}
public async Task <IActionResult> Put([FromBody] ProductVO product, Guid id)
{
if (product == null)
{
return(BadRequest());
}
product.Id = id;
return(new ObjectResult(_productBusiness.Update(product)));
}
public ProductVO Create(ProductVO product)
{
var productEntity = _converter.Parse(product);
productEntity = _repository.Create(productEntity);
SaveFile(productEntity.Image, productEntity.Id);
return(_converter.Parse(productEntity));
}
/// <summary>
/// Transpose Model object to Value Object
/// </summary>
/// <param name="userId">user Id</param>
/// <returns>Value object</returns>
public ProductVO Transpose(int?userId)
{
ProductVO productVO = new ProductVO();
productVO.ProductId = this.ID;
productVO.ProductName = this.ProductName;
productVO.CreatedByUserId = userId;
productVO.LastUpdatedByUserId = userId;
return(productVO);
}
/// <summary>
/// Get Product details by Id
/// </summary>
/// <param name="productId">Product Id</param>
/// <returns>Product Details</returns>
public ProductVO GetProductById(int productId)
{
Product product = mdbDataContext.Products.SingleOrDefault(c => c.ID == productId);
ProductVO productVO = null;
if (product != null)
{
productVO = new ProductVO(product);
}
return(productVO);
}
public ProductVO Create(ProductVO product)
{
var productEntity = _converter.Parse(product);
productEntity = _repository.Create(productEntity);
SaveImageProduct imageProducts = new SaveImageProduct(productEntity);
imageProducts.Save();
return(_converter.Parse(productEntity));
}
public void update(ProductVO product)
{
if (product != null)
{
this.Repository.Update <ProductVO>(product);
}
else
{
throw new ArgumentException("The product passed in was null!");
}
}
private void InsertProduct()
{
//이미지를 Byte 배열로 변환
Cursor currentCursor = this.Cursor;
this.Cursor = Cursors.WaitCursor;
string localFile = pictureBox1.Tag.ToString().Replace("\\", "/");
byte[] ImageData;
FileStream fs = new FileStream(localFile, FileMode.Open, FileAccess.Read);
BinaryReader br = new BinaryReader(fs);
ImageData = br.ReadBytes((int)fs.Length);
br.Close();
fs.Close();
ProductVO Pitem = new ProductVO
{
Product_Name = txtProductName.Text,
Product_Price = Convert.ToInt32(txtProductMoney.Text.Replace(",", "").Replace("원", "")),
Product_Category = cboProductCategory.SelectedValue.ToString(),
Product_Origin = Convert.ToInt32(lblOrigin.Text.Replace(",", "").Replace("원", "")),
Product_Image = ImageData
};
List <BOMVO> citemList = new List <BOMVO>();
foreach (Control control in splitContainer2.Panel1.Controls)
{
if (control is SemiProductCompControl)
{
SemiProductCompControl spc = (SemiProductCompControl)control;
BOMVO citem = new BOMVO
{
Combination_Product_ID = spc.TxtName.Tag.ToString(),
Combination_RequiredQty = Convert.ToInt32(spc.Qty.Value)
};
count += spc.Controls.Count;
citemList.Add(citem);
}
}
try
{
BOMService service = new BOMService();
service.InsertProduct(Pitem, citemList, count);
}
catch (Exception err)
{
Log.WriteError(err.Message, err);
}
}
/// <summary>
/// Get the Product by Name
/// </summary>
/// <param name="productName">The Product Name</param>
/// <returns>Value Object product</returns>
public ProductVO GetProductByName(string productName)
{
Product product = mdbDataContext.Products.Where(pro => pro.ProductName.Equals(productName) && pro.IsDeleted == false).SingleOrDefault();
ProductVO productVO = null;
if (product != null)
{
productVO = new ProductVO(product);
}
return(productVO);
}
public ProductInfoForm(string employee, bool IsUpdate = true, ProductVO vo = null)
{
InitializeComponent();
this.IsUpdate = IsUpdate;
this.vo = vo;
this.employee = employee;
if (IsUpdate == true)
{
Update_ProductID = vo.Product_ID;
}
}
public void UpdateProduct(ProductVO Pitem, List <BOMVO> citemList, int count)
{
conn.Open();
SqlTransaction trans = conn.BeginTransaction();
List <BOMVO> list = null;
try
{
string productSql = "CMG_UpdateProduct";
SqlCommand cmd = new SqlCommand(productSql, conn);
cmd.Transaction = trans;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Product_Name", Pitem.Product_Name);
cmd.Parameters.AddWithValue("@Product_Price", Pitem.Product_Price);
cmd.Parameters.AddWithValue("@Product_Image", Pitem.Product_Image);
cmd.Parameters.AddWithValue("@Product_Category", Pitem.Product_Category);
cmd.Parameters.AddWithValue("@Product_Origin", Pitem.Product_Origin);
cmd.Parameters.AddWithValue("@Product_ID", Pitem.Product_ID);
SqlDataReader reader = cmd.ExecuteReader();
list = Helper.DataReaderMapToList <BOMVO>(reader);
string combiSql = "Update Combination Set Combination_Product_ID = @Combination_Product_ID, Combination_RequiredQty = @Combination_RequiredQty Where Combination_ID = @Combination_ID ";
SqlCommand dcmd = new SqlCommand(combiSql, conn);
for (int i = 0; i < count; i++)
{
dcmd.Transaction = trans;
dcmd.Parameters.AddWithValue("@Combination_Product_ID", citemList[i].Combination_Product_ID);
dcmd.Parameters.AddWithValue("@Combination_RequiredQty", citemList[i].Combination_RequiredQty);
dcmd.Parameters.AddWithValue("@Combination_ID", list[i].Combination_ID);
reader.Close();
dcmd.ExecuteNonQuery();
dcmd.Parameters.Clear();
}
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
finally
{
conn.Close();
}
}
public void InsertProduct(ProductVO Pitem, List <BOMVO> citemList, int count)
{
conn.Open();
SqlTransaction trans = conn.BeginTransaction();
string productID = string.Empty;
try
{
string productSql = "CMG_InsertProduct";
SqlCommand cmd = new SqlCommand(productSql, conn);
cmd.Transaction = trans;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Product_Name", Pitem.Product_Name);
cmd.Parameters.AddWithValue("@Product_Price", Pitem.Product_Price);
cmd.Parameters.AddWithValue("@Product_Category", Pitem.Product_Category);
cmd.Parameters.AddWithValue("@Product_Image", Pitem.Product_Image);
cmd.Parameters.AddWithValue("@Product_Origin", Pitem.Product_Origin);
object obj = cmd.ExecuteScalar();
productID = obj.ToString();
string combiSql = "insert into Combination(Product_ID, Combination_Product_ID, Combination_RequiredQty) values (@Product_ID, @Combination_Product_ID, @Combination_RequiredQty) ";
SqlCommand dcmd = new SqlCommand(combiSql, conn);
for (int i = 0; i < count; i++)
{
dcmd.Transaction = trans;
dcmd.Parameters.AddWithValue("@Product_ID", productID);
dcmd.Parameters.AddWithValue("@Combination_Product_ID", citemList[i].Combination_Product_ID);
dcmd.Parameters.AddWithValue("@Combination_RequiredQty", citemList[i].Combination_RequiredQty);
dcmd.ExecuteNonQuery();
dcmd.Parameters.Clear();
}
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
finally
{
conn.Close();
}
}
public ProductPop(EditMode edit, ProductVO vo = null)
{
InitializeComponent();
if (edit == EditMode.Insert)
{
this.Text = "품목 등록";
this.edit = EditMode.Insert;
}
else if (edit == EditMode.Update)
{
this.Text = "품목 수정";
this.edit = EditMode.Update;
this.vo = vo;
}
}
public void save(ProductVO product)
{
if (product != null)
{
if (product.ID == null)
{
product.ID = Guid.NewGuid();
}
this.Repository.Add <ProductVO>(product);
}
else
{
throw new ArgumentException("The product passed in was null!");
}
}
private void LoadDGV()
{
dgvProductList.RowHeadersVisible = false;
//품목 가져오기
ProductService product_service = new ProductService();
List <ProductVO> list = product_service.GetAllProducts();
ProductVO vo = new ProductVO();
dgvProductList.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvProductList.Columns.Add("Number", "No.");
dgvProductList.Columns[0].Width = 53;
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "품목유형", "product_type", true, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "품목", "product_codename", true, 130);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "품명", "product_name", true, 220);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "단위", "product_unit", true, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "단위수량", "product_unit_count", true, 100, DataGridViewContentAlignment.MiddleRight);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "발주방식", "product_ordertype", true, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "최소발주수량", "product_lorder_count", true, 130, DataGridViewContentAlignment.MiddleRight);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "안전재고수량", "product_safety_count", true, 130, DataGridViewContentAlignment.MiddleRight);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "사용여부", "product_yn", true, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "담당자", "product_admin", true, 100);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "입고창고", "product_in_sector", true, 130, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "출고창고", "product_out", true, 130, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "납품업체", "product_supply_com", true, 130, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "발주업체", "product_demand_com", true, 130, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "측정방식", "product_meastype", true, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "LeadTime", "product_leadtime", true, 100, DataGridViewContentAlignment.MiddleRight);
#region visible_false
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "최솟값", "product_lsl", false, 130);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "최댓값", "product_usl", false, 130);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "아이템코드", "product_itemcode", false, 130);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "품번", "product_id", false, 130);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "품명코드", "product_code", false, 130);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "수정일", "product_udate", false, 130);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "비고", "product_comment", false, 130);
#endregion
//dgvProductList.Columns[0].SortMode = DataGridViewColumnSortMode.Automatic;
GridViewUtil.SetDataGridView(dgvProductList);
dgvProductList.AutoGenerateColumns = false;
dgvProductList.DataSource = list;
}
public async Task <IActionResult> Post([FromBody] ProductVO product)
{
if (product == null)
{
return(BadRequest());
}
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (_productBusiness.Exists(product.Name).Equals(true))
{
return(Ok(new { Description = "Este item já esxite" }));
}
return(new ObjectResult(_productBusiness.Create(product)));
}
/// <summary>
/// Save the Product
/// </summary>
/// <param name="product">Value Object of Product</param>
public void SaveProduct(ProductVO product)
{
if (!string.IsNullOrEmpty(product.ProductName))
{
ProductVO productExist = productDAL.GetProductByName(product.ProductName);
//Check whether product already exist or not
if (productExist != null && product.ProductId != productExist.ProductId)
{
throw new ApplicationException(Constants.PRODUCT_ALREADY_EXIST);
}
else
{
productDAL.SaveProduct(product);
}
}
}
public IActionResult Put([FromBody] ProductVO product)
{
if (product == null)
{
return(BadRequest());
}
var updated = _productBusiness.Update(product);
if (updated != null)
{
return(new OkObjectResult(updated));
}
else
{
return(NotFound());
}
}
public void DeleteProduct(ProductVO Pitem)
{
conn.Open();
SqlTransaction trans = conn.BeginTransaction();
List <BOMVO> list = null;
try
{
string productSql = "CMG_DeleteProduct";
SqlCommand cmd = new SqlCommand(productSql, conn);
cmd.Transaction = trans;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Product_ID", Pitem.Product_ID);
SqlDataReader reader = cmd.ExecuteReader();
list = Helper.DataReaderMapToList <BOMVO>(reader);
string combiSql = "Update Combination Set Combination_DeletedYN = 1 Where Combination_ID = @Combination_ID ";
SqlCommand dcmd = new SqlCommand(combiSql, conn);
for (int i = 0; i < list.Count; i++)
{
dcmd.Transaction = trans;
dcmd.Parameters.AddWithValue("@Combination_ID", list[i].Combination_ID);
reader.Close();
dcmd.ExecuteNonQuery();
dcmd.Parameters.Clear();
}
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
finally
{
conn.Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
//vo = new ProductVO();
ProductVO product_vo = new ProductVO();
foreach (DataGridViewRow row in this.dgvProductList.SelectedRows)
{
product_vo = row.DataBoundItem as ProductVO;
}
ProductPop frm = new ProductPop(ProductPop.EditMode.Update, product_vo);
if (frm.ShowDialog() == DialogResult.OK)
{
List <ProductVO> new_product_list = product_service.GetAllProducts(); //등록후 다시 조회
dgvProductList.DataSource = new_product_list;
SetBottomStatusLabel("품목 정보가 수정되었습니다.");
}
}
private void dgvBOM_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex < dgvBOM.Rows.Count && e.RowIndex > -1)
{
item = new ProductVO
{
Product_ID = dgvBOM.Rows[e.RowIndex].Cells[0].Value.ToString(),
Product_Category = dgvBOM.Rows[e.RowIndex].Cells[1].Value.ToString(),
Product_Name = dgvBOM.Rows[e.RowIndex].Cells[3].Value.ToString(),
Product_Price = Convert.ToInt32(dgvBOM.Rows[e.RowIndex].Cells[4].Value),
Warehouse_ID = Convert.ToInt32(dgvBOM.Rows[e.RowIndex].Cells[5].Value),
Product_Safety = Convert.ToInt32(dgvBOM.Rows[e.RowIndex].Cells[8].Value),
Product_Origin = Convert.ToInt32(dgvBOM.Rows[e.RowIndex].Cells[12].Value)
};
dgvBOMDetail1.DataSource = null;
dgvBOMDetail2.DataSource = null;
//원자재 품목일 때 전개를 누르면 역전개만 보인다.
if (e.ColumnIndex == 13 && dgvBOM.CurrentRow.Cells[1].Value.ToString().Contains("CM"))
{
List <BOMVO> productList = (from item in bomReverseList where item.Combination_Product_ID.Equals(dgvBOM.Rows[e.RowIndex].Cells[0].Value.ToString()) select item).ToList();
dgvBOMDetail2.DataSource = productList;
}
//반제품 품목일 때 전개를 누르면 정전개, 역전개 모두 보인다.
else if (e.ColumnIndex == 13 && dgvBOM.CurrentRow.Cells[1].Value.ToString().Contains("CS"))
{
List <BOMVO> semiProductList = (from item in bomList where item.Product_ID.Equals(dgvBOM.Rows[e.RowIndex].Cells[0].Value.ToString()) select item).ToList();
dgvBOMDetail1.DataSource = semiProductList;
List <BOMVO> productList = (from item in bomReverseList where item.Combination_Product_ID.Equals(dgvBOM.Rows[e.RowIndex].Cells[0].Value.ToString()) select item).ToList();
dgvBOMDetail2.DataSource = productList;
}
//완제품 품목일 때 전개를 누르면 정전개만 보인다.
else if (e.ColumnIndex == 13 && dgvBOM.CurrentRow.Cells[1].Value.ToString().Contains("CP"))
{
List <BOMVO> semiProductList = (from item in bomList where item.Product_ID.Equals(dgvBOM.Rows[e.RowIndex].Cells[0].Value.ToString()) select item).ToList();
dgvBOMDetail1.DataSource = semiProductList;
}
}
}
