private void GetBarcodeData()
{
try
{
if (string.IsNullOrEmpty(barcodeTextEdit.Text.Trim()))
{
MessageBox.Show("Invalid Barcode");
barcodeTextEdit.Focus();
return;
}
using (var _db = new KontoContext())
{
var bd = new BarcodeTransDto();
_bc = _db.Barcodes.Include("Product").Include("Acc").FirstOrDefault(p => p.BarcodeNo == barcodeTextEdit.Text);
if (_bc == null)
{
MessageBox.Show("Invalid Barcode..");
ResetPage();
barcodeTextEdit.Focus();
return;
}
//check for layer qc entry
var btdata = _db.BarcodeTrans.FirstOrDefault(p => p.BarcodeId == _bc.Id && p.TransType == 1 && p.QcPassed);
if (btdata == null)
{
MessageBox.Show("Barcode not found in layer QC");
ResetPage();
barcodeTextEdit.Focus();
_bc = null;
return;
}
// check for generated Barcode...
var sum = _db.Barcodes.Where(x => x.RefBarcodeId == _bc.Id).Count();
if (sum == _bc.Qty)
{
MessageBox.Show("Barcode Already Generated");
ResetPage();
barcodeTextEdit.Focus();
_bc = null;
return;
}
qtySpinEdit.Value = _bc.Qty - sum;
if (_bc.Acc != null)
{
partyLabelControl.Text = _bc.Acc.AccName;
}
productLabelControl.Text = _bc.Product.ProductName;
stockLabelControl.Text = (_bc.Qty - sum).ToString();
qtySpinEdit.Focus();
}
}
catch (Exception ex)
{
Log.Error(ex, "Barcode find");
MessageBox.Show(ex.ToString());
}
}
private void UpdateBarcodeData(BarcodeModel bcm)
{
int divid = Convert.ToInt32(divLookUpEdit.EditValue.ToString());
using (var db = new KontoContext())
{
using (var tr = db.Database.BeginTransaction())
{
try
{
var bt = new BarcodeTrans()
{
BarcodeId = bcm.Id,
DivId = divid,
EmpId = Convert.ToInt32(empLookup1.SelectedValue),
IsActive = true,
IsDeleted = false,
BarcodeNo = bcm.BarcodeNo,
CompId = KontoGlobals.CompanyId,
YearId = KontoGlobals.YearId,
ProductId = bcm.ProductId,
Qty = Convert.ToDecimal(qtyTextEdit.EditValue),
TransType = 2, Remarks = RemarkTextEdit1.Text.Trim(),
VoucherDate = Convert.ToInt32(voucherDateEdit.DateTime.ToString("yyyyMMdd")),
};
db.BarcodeTrans.Add(bt);
db.SaveChanges();
var bts = new BarcodeStock()
{
BarcodeId = Convert.ToInt32(bt.BarcodeId),
BarcodeNo = bt.BarcodeNo,
CompId = bt.CompId,
DivId = bt.DivId,
EmpId = bt.EmpId,
IsActive = true,
IsDeleted = false,
Qty = -1 * bt.Qty,
VoucherDate = bt.VoucherDate,
YearId = bt.YearId,
ProductId = bt.ProductId, RefId = bt.Id
};
db.BarcodeStocks.Add(bts);
db.SaveChanges();
tr.Commit();
var btDto = new BarcodeTransDto()
{
BarcodeId = bt.BarcodeId, BarcodeNo = bt.BarcodeNo, DivId = bt.DivId, DivName = divLookUpEdit.Text,
EmpId = bt.EmpId, EmpName = empLookup1.SelectedText, Id = bt.Id,
ProductId = bt.ProductId, ProductName = bcm.Product.ProductName, Qty = bt.Qty, TrnasType = 2, VoucherDate = bt.VoucherDate,
Remarks = bt.Remarks
};
barcodelist.Add(btDto);
barcodeTransModelBindingSource.DataSource = barcodelist;
gridControl1.RefreshDataSource();
barcode = null;
barcodeNoTextEdit.Text = string.Empty;
barcodeNoTextEdit.Focus();
stockTextEdit.Text = string.Empty;
qtyTextEdit.Text = string.Empty;
}
catch (Exception ex)
{
tr.Rollback();
MessageBox.Show(ex.ToString());
Log.Error(ex, "barcode Scan Inward");
}
}
}
}
private void SaveSimpleButton_Click(object sender, EventArgs e)
{
if (!ValidateData()) return;
if (Convert.ToBoolean(radioGroup1.EditValue) == false && string.IsNullOrEmpty(remarkLookUpEdit.Text))
{
MessageBox.Show("Please Select Remark.");
remarkLookUpEdit.Focus();
return;
}
if (barcode == null) return;
int divid = Convert.ToInt32(divLookUpEdit.EditValue.ToString());
using (var db = new KontoContext())
{
using (var tr = db.Database.BeginTransaction())
{
try
{
var bt = new BarcodeTrans()
{
BarcodeId = barcode.Id,
DivId = divid,
EmpId = Convert.ToInt32(empLookup1.SelectedValue),
IsActive = true,
IsDeleted = false,
BarcodeNo = barcode.BarcodeNo,
CompId = KontoGlobals.CompanyId,
YearId = KontoGlobals.YearId,
ProductId = barcode.ProductId,
Qty = barcode.Qty,
TransType = 1,
Remarks = remarkLookUpEdit.Text,
VoucherDate = Convert.ToInt32(voucherDateEdit.DateTime.ToString("yyyyMMdd")),
QcPassed = Convert.ToBoolean(radioGroup1.EditValue)
};
db.BarcodeTrans.Add(bt);
db.SaveChanges();
if (bt.QcPassed && Convert.ToBoolean(divLookUpEdit.GetColumnValue("IsQcOut")))
{
var bts = new BarcodeStock()
{
BarcodeId = Convert.ToInt32(bt.BarcodeId),
BarcodeNo = bt.BarcodeNo,
CompId = bt.CompId,
DivId = bt.DivId,
EmpId = bt.EmpId,
IsActive = true,
IsDeleted = false,
Qty = -1*bt.Qty,
VoucherDate = bt.VoucherDate,
YearId = bt.YearId,
ProductId = bt.ProductId,
RefId = bt.Id
};
db.BarcodeStocks.Add(bts);
db.SaveChanges();
}
tr.Commit();
var btDto = new BarcodeTransDto()
{
BarcodeId = bt.BarcodeId,
BarcodeNo = bt.BarcodeNo,
DivId = bt.DivId,
DivName = divLookUpEdit.Text,
EmpId = bt.EmpId,
EmpName = empLookup1.SelectedText,
Id = bt.Id,
ProductId = bt.ProductId,
ProductName = barcode.Product.ProductName,
Qty = bt.Qty,
TrnasType = 1,
QcPassed = bt.QcPassed,
Remarks = bt.Remarks
};
barcodelist.Add(btDto);
barcodeTransModelBindingSource.DataSource = barcodelist;
gridControl1.RefreshDataSource();
barcode = null;
remarkLookUpEdit.EditValue = "NA";
barcodeNoTextEdit.Text = string.Empty;
barcodeNoTextEdit.Focus();
}
catch (Exception ex)
{
tr.Rollback();
Log.Error(ex, "qc saved");
}
}
}
}
