private void InsertLabelDataIntoDatabase(int BatchNumber)
{
var sqlConnection = new SqlConn(DbConnectionString());
// DataTable dt = _butcherLabelsTable;
foreach (DataRow dr in _butcherLabelsTable.Rows)
{
var insert = new InsertCommand(sqlConnection.GetSqlConnection());
insert.ProductionDate = (DateTime)(dateEdit_ProdDate.EditValue);
insert.ProdCode = lookUpEdit_Product.GetColumnValue("ProdCode").ToString();
insert.ProdDescription = lookUpEdit_Product.Text;
insert.Customer = lookUpEdit_Customer.Text;
insert.Shift = lookUpEdit_Shift.Text;
insert.LabelDescription = lookUpEdit_Product.GetColumnValue("LabelType").ToString();
insert.RawMaterialCode = dr["product"].ToString();
insert.RawMaterialDescription = dr["description"].ToString();
switch (_batchOrPallet)
{
case SqlQueryBatchPallet.PalletBatchField.palletid:
insert.PalletId = dr["PalletNumber"].ToString();
break;
case SqlQueryBatchPallet.PalletBatchField.batchno:
insert.BatchNumber = dr["PalletNumber"].ToString();
break;
default:
break;
}
insert.Udf2 = dr["udf2"].ToString();
insert.Udf3 = dr["udf3"].ToString();
insert.Udf4 = dr["udf4"].ToString();
insert.KillDate = (DateTime)(dr["killdate"]);
insert.Lot = dr["lot"].ToString();
insert.LabelBatchNumber = BatchNumber;
insert.Weight = (decimal)(dr["Weight"]);
insert.FactoryId = Properties.Settings.Default.Factory;
insert.ExecuteInsertLabel();
dataForPrintLabel = insert;
}
}