public static void Insert(Mpcportalprodlist data, SqlConnection conn) { var sql = @"INSERT INTO [dbo].[mpcportalprodlist]( warehouse,product,description,long_description,supersession,discount,exvat_price,remap_anal,prod_range,key_core_slow,free_stock) VALUES (@warehouse,@product,@description,@long_description,@supersession,@discount,@exvat_price,@remap_anal,@prod_range,@key_core_slow,@free_stock)" ; using (var cmd = new SqlCommand(sql, conn)) { cmd.Parameters.AddWithValue("@warehouse", data.warehouse); cmd.Parameters.AddWithValue("@product", data.product); cmd.Parameters.AddWithValue("@description", data.description); cmd.Parameters.AddWithValue("@long_description", data.long_description); cmd.Parameters.AddWithValue("@supersession", data.supersession); cmd.Parameters.AddWithValue("@discount", data.discount); cmd.Parameters.AddWithValue("@exvat_price", data.exvat_price); 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("@free_stock", (object)data.free_stock ?? DBNull.Value); cmd.ExecuteNonQuery(); } }
private void Initialize(IList <slcustm> custData, IList <Mpcportalprodlist> mpcData, IList <oplistm> oplistData = null, IList <opdscntm> opdscData = null) { using (var conn = GetAndOpenConnection()) { CleanTables(conn); foreach (var mpc in mpcData) { Mpcportalprodlist.Insert(mpc, conn); } if (custData != null) { foreach (var c in custData) { slcustm.Insert(c, conn); } } if (oplistData != null) { foreach (var d in oplistData) { oplistm.Insert(d, conn); } } if (opdscData != null) { foreach (var d in opdscData) { opdscntm.Insert(d, conn); } } } }
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); } } } }
public StockTablesData(Mpcportalprodlist mpc) { Initialize(new List <Mpcportalprodlist> { mpc }); }
private void Initialize(IList <Mpcportalprodlist> mpcData, IList <opheadm> headers, IList <opdetm> details, IList <opaudm> audits, IList <poheadm> poHeaders = null, IList <podetm> poDetails = null, IList <cevatm> cevatmList = null, IList <slcustm> customers = null) { using (var conn = GetAndOpenConnection()) { CleanTables(conn); if (mpcData != null) { foreach (var mpc in mpcData) { Mpcportalprodlist.Insert(mpc, conn); } } if (headers != null) { foreach (var h in headers) { opheadm.Insert(h, conn); } } if (details != null) { foreach (var d in details) { opdetm.Insert(d, conn); } } if (audits != null) { foreach (var a in audits) { opaudm.Insert(a, 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); } } if (cevatmList != null) { foreach (var c in cevatmList) { cevatm.Insert(c, conn); } } if (customers != null) { foreach (var c in customers) { slcustm.Insert(c, conn); } } } }