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();
}
}
