public JsonResult Update([FromBody] MaterialProduct obj) { var msg = new JMessage { Title = "", Error = false }; try { var item = _context.MaterialProducts.FirstOrDefault(x => x.ProductCode == obj.ProductCode); item.ProductName = obj.ProductName; item.Note = obj.Note; item.Barcode = obj.Barcode; item.GroupCode = obj.GroupCode; item.TypeCode = obj.TypeCode; item.Status = obj.Status; item.UpdatedBy = ESEIM.AppContext.UserName; item.UpdatedTime = DateTime.Now; _context.MaterialProducts.Update(item); _context.SaveChanges(); msg.Title = String.Format(CommonUtil.ResourceValue("COM_MSG_UPDATE_SUCCESS"), CommonUtil.ResourceValue("MLP_MSG_SUPPLIES")); } catch { msg.Error = true; msg.Title = String.Format(CommonUtil.ResourceValue("COM_MSG_UPDATE_FAILED"), CommonUtil.ResourceValue("MLP_MSG_SUPPLIES")); } return(Json(msg)); }
public JsonResult Insert([FromBody] MaterialProduct obj) { var msg = new JMessage { Title = "", Error = false }; try { var model = _context.MaterialProducts.Where(x => x.ProductCode.Equals(obj.ProductCode)).FirstOrDefault(); if (model == null) { obj.CreatedBy = ESEIM.AppContext.UserName; obj.CreatedTime = DateTime.Now; _context.MaterialProducts.Add(obj); _context.SaveChanges(); msg.Title = String.Format(CommonUtil.ResourceValue("COM_MSG_ADD_SUCCESS"), CommonUtil.ResourceValue("MLP_MSG_SUPPLIES")); } else { msg.Error = true; msg.Title = String.Format(CommonUtil.ResourceValue("COM_MSG_EXITS"), CommonUtil.ResourceValue("MLP_CURD_LBL_SUPPLIES_CODE")); } } catch { msg.Error = true; msg.Title = String.Format(CommonUtil.ResourceValue("COM_MSG_ADD_FAILED"), CommonUtil.ResourceValue("MLP_MSG_SUPPLIES")); } return(Json(msg)); }
public int saveEditedProduct(int iProjectId) { Product editedProduct = _productsConnectDB.selectProduct(productId); // get current product from database editedProduct.code = sCode.sInput; editedProduct.name = sProductName.sInput; editedProduct.active = active; editedProduct.coverId = clCover.iSelectedValue; editedProduct.typeId = clType.iSelectedValue; editedProduct.projectId = iProjectId; editedProduct.profileId = clProfile.iSelectedValue; editedProduct.imagePath = imagePath; int iEditedProductId = _productsConnectDB.editInsertAndSubmit(editedProduct); // insert edited product to database _materialProductConnectDB.deleteWhereProductId(productId); if (iEditedProductId != -1) { MaterialProduct newMaterialProduct; // for every IO position foreach (var ioPosition in _obcIOPositions.ToList()) { // for every material in every IO position foreach (var material in ioPosition.obcAddedMaterials.ToList()) { newMaterialProduct = new MaterialProduct(); newMaterialProduct.productId = iEditedProductId; newMaterialProduct.materialIOPosition = ioPosition.iIOPositionSelectedValuePath + 1; newMaterialProduct.materialId = material.iSelectedvaluePath; _materialProductConnectDB.insert(newMaterialProduct); } } _materialProductConnectDB.submit(); } return(iEditedProductId); }
public int saveNewProduct(int iProjectId) { Product saveNewProduct = new Product(); saveNewProduct.code = sCode.sInput; saveNewProduct.name = sProductName.sInput; saveNewProduct.active = active; saveNewProduct.coverId = clCover.iSelectedValue; saveNewProduct.typeId = clType.iSelectedValue; saveNewProduct.projectId = iProjectId; saveNewProduct.profileId = clProfile.iSelectedValue; saveNewProduct.imagePath = imagePath; int iNewProductId = _productsConnectDB.insertAndSubmit(saveNewProduct); if (iNewProductId != -1) { MaterialProduct newMaterialProduct; // for every IO position foreach (var ioPosition in _obcIOPositions.ToList()) { // for every material in every IO position foreach (var material in ioPosition.obcAddedMaterials.ToList()) { newMaterialProduct = new MaterialProduct(); newMaterialProduct.productId = iNewProductId; newMaterialProduct.materialIOPosition = ioPosition.iIOPositionSelectedValuePath + 1; newMaterialProduct.materialId = material.iSelectedvaluePath; _materialProductConnectDB.insert(newMaterialProduct); } } _materialProductConnectDB.submit(); } return(iNewProductId); }