protected override bool SaveData() { bsBarCode.EndEdit(); DS_Barcode.SP_GetBarcodeDataTable table = DataSetHelper.PackAlternationTypedDataTable <DS_Barcode.SP_GetBarcodeDataTable>(ds_Barcode.SP_GetBarcode); DataSetHelper.RemoveColumns(table, true, table.BarcodeColumn, table.ActionColumn); var ds = new DataSet("root"); ds.Tables.Add(table); var id = ProductionManager.AddOrEditProduct(ProductID, ds_Product.SP_GetProduct[0].PurchaseOrderDetailID, MedicamentID, Quantity, StandardCost, ListPrice, DealerPrice, ProductCurrencyCode, DiscountPct, TaxRate, ValidDate, CountryCode, BrandID, Serie, BaseGlobalVariable.UserID, BaseGlobalVariable.ServerDateTime, DatabaseAction.Edit, DataSetHelper.InnerBytesData(ds)); if (id > 0) { ds_Product.AcceptChanges(); ds_Barcode.AcceptChanges(); } return(id > 0); }
public bool IsValidBarCodes() { DS_Barcode.SP_GetBarcodeDataTable table = DataSetHelper.PackAlternationTypedDataTable <DS_Barcode.SP_GetBarcodeDataTable>(ds_Barcode.SP_GetBarcode, DataRowState.Added); table.PrimaryKey = null; for (var i = 0; i < table.Columns.Count; i++) { if (table.Columns[i].ColumnName == table.BarcodeColumn.ColumnName || table.Columns[i].ColumnName == table.ActionColumn.ColumnName) { continue; } table.Columns.Remove(table.Columns[i]); i--; } var ds = new DataSet("root"); ds.Tables.Add(table); var invalid = ProductionManager.IsValidBarcode(string.Empty, 0, DataSetHelper.InnerBytesData(ds)); if (invalid.Count > 0) { var error = new StringBuilder("შტრიხ-კოდები დუბლირებულია:" + Environment.NewLine); for (var i = 0; i < invalid.Count; i++) { error.AppendLine(invalid[i].Barcode); if (i > 15) { error.Append("..."); break; } } XtraMessageBox.Show(this, error.ToString(), "შეცდომა", MessageBoxButtons.OK, MessageBoxIcon.Warning); return(false); } return(true); }