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);
                    }
                }
            }
        }
Exemple #2
0
        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);
                    }
                }
            }
        }
Exemple #3
0
        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);
                    }
                }
            }
        }