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