public static void Insert(PINNstock3 data, SqlConnection conn)
{
var sql = @"INSERT INTO [dbo].[PINN_stock3](
origin,warehouse,product,long_description,exvat_price,Disc_Code,orig_analysis,remap_anal,prod_range,key_core_slow,abc_category,LCM_xref,salekey,
Supplier,SuppCurr,AdminType,StockType,[3monthsales],reorder_days,economic_reorder_q,bin_number,weight,dimensions,finish,type,current_cost)
VALUES (@origin,@warehouse,@product,@long_description,@exvat_price,@Disc_Code,@orig_analysis,@remap_anal,@prod_range,@key_core_slow,
@abc_category,@LCM_xref,@salekey,@Supplier,@SuppCurr,@AdminType,@StockType,@3monthsales,@reorder_days,@economic_reorder_q,@bin_number,@weight,@dimensions,@finish,@type,@current_cost)" ;
using (var cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@origin", data.origin);
cmd.Parameters.AddWithValue("@warehouse", data.warehouse);
cmd.Parameters.AddWithValue("@product", data.product);
cmd.Parameters.AddWithValue("@long_description", data.long_description);
cmd.Parameters.AddWithValue("@exvat_price", data.exvat_price);
cmd.Parameters.AddWithValue("@Disc_Code", data.Disc_Code);
cmd.Parameters.AddWithValue("@orig_analysis", (object)data.orig_analysis ?? DBNull.Value);
cmd.Parameters.AddWithValue("@remap_anal", (object)data.remap_anal ?? DBNull.Value);
cmd.Parameters.AddWithValue("@prod_range", data.prod_range);
cmd.Parameters.AddWithValue("@key_core_slow", (object)data.key_core_slow ?? DBNull.Value);
cmd.Parameters.AddWithValue("@abc_category", data.abc_category);
cmd.Parameters.AddWithValue("@LCM_xref", data.LCM_xref);
cmd.Parameters.AddWithValue("@salekey", data.salekey);
cmd.Parameters.AddWithValue("@Supplier", data.Supplier);
cmd.Parameters.AddWithValue("@SuppCurr", data.SuppCurr);
cmd.Parameters.AddWithValue("@AdminType", data.AdminType);
cmd.Parameters.AddWithValue("@StockType", (object)data.StockType ?? DBNull.Value);
cmd.Parameters.AddWithValue("@3monthsales", data.Threemonthsales);
cmd.Parameters.AddWithValue("@reorder_days", data.reorder_days);
cmd.Parameters.AddWithValue("@economic_reorder_q", data.economic_reorder_q);
cmd.Parameters.AddWithValue("@bin_number", data.bin_number);
cmd.Parameters.AddWithValue("@weight", data.weight);
cmd.Parameters.AddWithValue("@dimensions", (object)data.dimensions ?? DBNull.Value);
cmd.Parameters.AddWithValue("@finish", data.finish);
cmd.Parameters.AddWithValue("@type", (object)data.type ?? DBNull.Value);
cmd.Parameters.AddWithValue("@current_cost", data.current_cost);
cmd.ExecuteNonQuery();
}
}
private void Initialize(IList <Mpcportalprodlist> mpcData, IList <PINNstock3> pinnStock3Data = null, IList <poheadm> poHeaders = null, IList <podetm> poDetails = null)
{
using (var conn = GetAndOpenConnection())
{
CleanTables(conn);
foreach (var mpc in mpcData)
{
Mpcportalprodlist.Insert(mpc, conn);
}
if (pinnStock3Data != null)
{
foreach (var pd in pinnStock3Data)
{
PINNstock3.Insert(pd, conn);
}
}
if (poHeaders != null)
{
foreach (var h in poHeaders)
{
poheadm.Insert(h, conn);
}
}
if (poDetails != null)
{
foreach (var d in poDetails)
{
podetm.Insert(d, conn);
}
}
}
}