private void Form_Closed(object sender, FormClosedEventArgs e) { if (transferList == null) { return; } var demandMaster = dbContext.ItemDemandMaster.Find(_itemDemandMasterId); foreach (var item in transferList) { var existStockDetail = StockHelper.GetBarcodeStocks(item.BarcodeId); var stockDetail = new StockDetail(); stockDetail.STOCKDETAIL_BARCODE_ID = item.BarcodeId; stockDetail.STOCKDETAIL_MASTER_ID = _stockMasterId; stockDetail.STOCKDETAIL_STORE_ID = existStockDetail.STOCKDETAIL_STORE_ID; stockDetail.STOCKDETAIL_ITEM_ID = existStockDetail.STOCKDETAIL_ITEM_ID; stockDetail.STOCKDETAIL_RACK_ID = existStockDetail.STOCKDETAIL_RACK_ID; stockDetail.STOCKDETAIL_QUANTITY = Convert.ToDouble(item.Quantity) * -1; dbContext.StockDetail.Add(stockDetail); dbContext.SaveChanges(); var stockDetailSecond = new StockDetail(); stockDetailSecond.STOCKDETAIL_BARCODE_ID = item.BarcodeId; stockDetailSecond.STOCKDETAIL_MASTER_ID = _stockMasterId; stockDetailSecond.STOCKDETAIL_STORE_ID = demandMaster.Project.Company.COMPANY_STORE_ID.Value; stockDetailSecond.STOCKDETAIL_ITEM_ID = existStockDetail.STOCKDETAIL_ITEM_ID; stockDetailSecond.STOCKDETAIL_RACK_ID = existStockDetail.STOCKDETAIL_RACK_ID; stockDetailSecond.STOCKDETAIL_QUANTITY = Convert.ToDouble(item.Quantity); stockDetailSecond.STOCKDETAIL_REF_ID = stockDetail.ID; dbContext.StockDetail.Add(stockDetailSecond); dbContext.SaveChanges(); } LoadData(); transferList.Clear(); }
private void btnSave_Click(object sender, EventArgs e) { int targetStore = (int)lueTargetStore.EditValue; int sourceStore = (int)lueSourceStore.EditValue; string stockDetail = (string)lueStockDetail.EditValue; double quantity = Convert.ToDouble(txtQuantity.EditValue == "" ? 0 : txtQuantity.EditValue); if (_stockDetailId == 0) { var selectedStock = StockHelper.GetBarcodeStocks(stockDetail); StockDetail entryDetail = new StockDetail() { STOCKDETAIL_ITEM_ID = selectedStock.STOCKDETAIL_ITEM_ID, STOCKDETAIL_RACK_ID = selectedStock.STOCKDETAIL_RACK_ID, STOCKDETAIL_BARCODE_ID = selectedStock.STOCKDETAIL_BARCODE_ID, STOCKDETAIL_STORE_ID = sourceStore, STOCKDETAIL_QUANTITY = quantity, STOCKDETAIL_MASTER_ID = _stockMasterIdEntry, }; dbContext.StockDetail.Add(entryDetail); dbContext.SaveChanges(); dbContext.StockDetail.Add(new StockDetail { STOCKDETAIL_ITEM_ID = selectedStock.STOCKDETAIL_ITEM_ID, STOCKDETAIL_RACK_ID = selectedStock.STOCKDETAIL_RACK_ID, STOCKDETAIL_BARCODE_ID = selectedStock.STOCKDETAIL_BARCODE_ID, STOCKDETAIL_STORE_ID = targetStore, STOCKDETAIL_QUANTITY = quantity * -1, STOCKDETAIL_MASTER_ID = _stockMasterId, STOCKDETAIL_REF_ID = entryDetail.ID, STOCKDETAIL_REF_LINK = "StockDetail" }); } else { StockDetail existStockDetail = dbContext.StockDetail.Find(_stockDetailId); existStockDetail.STOCKDETAIL_ITEM_ID = existStockDetail.STOCKDETAIL_ITEM_ID; existStockDetail.STOCKDETAIL_RACK_ID = existStockDetail.STOCKDETAIL_RACK_ID; existStockDetail.STOCKDETAIL_BARCODE_ID = existStockDetail.STOCKDETAIL_BARCODE_ID; existStockDetail.STOCKDETAIL_STORE_ID = targetStore; existStockDetail.STOCKDETAIL_QUANTITY = quantity; existStockDetail.STOCKDETAIL_MASTER_ID = _stockMasterId; StockDetail existStockDetail2 = dbContext.StockDetail.SingleOrDefault(x => x.ID == existStockDetail.STOCKDETAIL_REF_ID); existStockDetail2.STOCKDETAIL_QUANTITY = quantity * -1; existStockDetail2.STOCKDETAIL_ITEM_ID = existStockDetail.STOCKDETAIL_ITEM_ID; existStockDetail2.STOCKDETAIL_RACK_ID = existStockDetail.STOCKDETAIL_RACK_ID; existStockDetail2.STOCKDETAIL_BARCODE_ID = existStockDetail.STOCKDETAIL_BARCODE_ID; existStockDetail2.STOCKDETAIL_STORE_ID = targetStore; existStockDetail2.STOCKDETAIL_MASTER_ID = _stockMasterId; _stockDetailId = 0; } dbContext.SaveChanges(); lueStockDetail.EditValue = ""; txtQuantity.Text = ""; LoadData(); }
private void btnSave_Click(object sender, EventArgs e) { if (validationResult() == true) { var project = dbContext.Project.Find(_projectId); var enterStockDetail = dbContext.StockDetail.Where(x => x.STOCKDETAIL_BARCODE_ID == lueActiveStockDetail.EditValue.ToString() && x.STOCKDETAIL_STORE_ID == project.Company.COMPANY_STORE_ID.Value && x.STOCKDETAIL_QUANTITY > 0).OrderBy(x => x.ID).FirstOrDefault(); if (txtCableStart.Text != "") { double cableStart = Convert.ToDouble(txtCableStart.Text); double cableEnd = Convert.ToDouble(txtCableEnd.Text); if (enterStockDetail.STOCKDETAIL_PRIVATEVALUE1.Value > cableStart) { XtraMessageBox.Show("Kablo ucu başı teslim edilen değerden küçük olamaz.", "HATA"); return; } if (enterStockDetail.STOCKDETAIL_PRIVATEVALUE2.Value < cableEnd) { XtraMessageBox.Show("Kablo ucu sonu teslim edilen değerden büyük olamaz.", "HATA"); return; } txtQuantity.Text = (cableEnd - cableStart).ToString(); } var existStockDetail = StockHelper.GetBarcodeStocks(lueActiveStockDetail.EditValue.ToString()); var stockDetail = new StockDetail(); stockDetail.STOCKDETAIL_BARCODE_ID = existStockDetail.STOCKDETAIL_BARCODE_ID; stockDetail.STOCKDETAIL_MASTER_ID = _stockMasterId; stockDetail.STOCKDETAIL_STORE_ID = project.Company.COMPANY_STORE_ID.Value; stockDetail.STOCKDETAIL_ITEM_ID = existStockDetail.STOCKDETAIL_ITEM_ID; stockDetail.STOCKDETAIL_RACK_ID = existStockDetail.STOCKDETAIL_RACK_ID; stockDetail.STOCKDETAIL_QUANTITY = Convert.ToDouble(txtQuantity.Text) * -1; stockDetail.STOCKDETAIL_PRIVATEVALUE1 = string.IsNullOrEmpty(txtCableStart.Text) ? 0 : (double)txtCableStart.EditValue; stockDetail.STOCKDETAIL_PRIVATEVALUE2 = string.IsNullOrEmpty(txtCableEnd.Text) ? 0 : (double)txtCableEnd.EditValue; stockDetail.STOCKDETAIL_REF_ID = _projectId; stockDetail.STOCKDETAIL_REF_LINK = "ProjectOutput"; dbContext.StockDetail.Add(stockDetail); txtQuantity.EditValue = ""; txtCableStart.EditValue = ""; txtCableEnd.EditValue = ""; lueActiveStockDetail.EditValue = null; dbContext.SaveChanges(); LoadData(); } }