Example #1
0
        private static void Populate(System.Data.SqlClient.SqlDataReader dr, Vare rec)
        {
            var with_1 = rec;

            with_1.VareGrpID         = System.Convert.ToInt32(dr.DBtoInt("VareGrpID"));
            with_1.VareNr            = dr.DBtoString("VareNr");
            with_1.Navn              = dr.DBtoString("Navn");
            with_1.Beskrivelse       = dr.DBtoString("Beskrivelse");
            with_1._CurrencyID       = System.Convert.ToInt32(dr.DBtoInt("CurrencyID"));
            with_1._CurrencyRate     = System.Convert.ToDecimal(dr.DBtoDecimal("CurrencyRate"));
            with_1._Indkobspris      = System.Convert.ToDecimal(dr.DBtoDecimal("Indkobspris"));
            with_1._FragtPct         = System.Convert.ToDecimal(dr.DBtoDecimal("FragtPct"));
            with_1._Fragt            = System.Convert.ToDecimal(dr.DBtoDecimal("Fragt"));
            with_1._KostprisCurrency = System.Convert.ToDecimal(dr.DBtoDecimal("KostprisCurrency"));
            with_1._KostprisDKK      = System.Convert.ToDecimal(dr.DBtoDecimal("KostprisDKK"));
            with_1._DaekningsBidrag  = System.Convert.ToDecimal(dr.DBtoDecimal("DaekningsBidrag"));
            with_1._DaekningsGrad    = System.Convert.ToDecimal(dr.DBtoDecimal("DaekningsGrad"));
            with_1._SalgsPris        = System.Convert.ToDecimal(dr.DBtoDecimal("SalgsPris"));
            with_1.Status            = (RescueTekniq.BOL.VareStatusEnum)(dr.DBtoInt("Status"));
            with_1.FragtID           = System.Convert.ToInt32(dr.DBtoInt("FragtID"));
            with_1.FaktaArkPath      = dr.DBtoString("FaktaArkPath");
            with_1.SupplierItemNo    = dr.DBtoString("SupplierItemNo");
            with_1.SupplierItemName  = dr.DBtoString("SupplierItemName");
            PopulateStandard(dr, rec);
        }
Example #2
0
        private static void Populate(System.Data.SqlClient.SqlDataReader dr, Invoiceline c)
        {
            var with_1 = c;

            with_1.InvoiceID = System.Convert.ToInt32(dr.DBtoInt("InvoiceID"));
            with_1.Pos       = System.Convert.ToInt32(dr.DBtoInt("Pos"));
            with_1.Status    = (RescueTekniq.BOL.Invoiceline_StatusEnum)(dr.DBtoInt("Status"));

            with_1.ItemID    = System.Convert.ToInt32(dr.DBtoInt("ItemID"));
            with_1._ItemNo   = dr.DBtoString("ItemNo");
            with_1._ItemName = dr.DBtoString("ItemName");

            with_1.LineText = dr.DBtoString("LineText");
            with_1.SerialNo = dr.DBtoString("SerialNo");

            with_1.ItemPrice  = System.Convert.ToDecimal(dr.DBtoDecimal("ItemPrice"));
            with_1.Discount   = System.Convert.ToDecimal(dr.DBtoDecimal("Discount"));
            with_1.SalesPrice = System.Convert.ToDecimal(dr.DBtoDecimal("SalesPrice"));
            with_1.Quantity   = System.Convert.ToDecimal(dr.DBtoDecimal("Quantity"));
            with_1.LineTotal  = System.Convert.ToDecimal(dr.DBtoDecimal("LineTotal"));

            with_1.VAT     = System.Convert.ToBoolean(dr.DBtoBoolean("VAT"));
            with_1.Freight = System.Convert.ToDecimal(dr.DBtoDecimal("Freight"));

            with_1.Provision     = System.Convert.ToDecimal(dr.DBtoDecimal("Provision"));
            with_1.ProvisionRate = System.Convert.ToDecimal(dr.DBtoDecimal("ProvisionRate"));
            with_1.LineProvision = System.Convert.ToDecimal(dr.DBtoDecimal("LineProvision"));

            with_1.CompanyID       = System.Convert.ToInt32(dr.DBtoInt("CompanyID"));
            with_1.InvoiceDate     = System.Convert.ToDateTime(dr.DBtoDateTime("InvoiceDate"));
            with_1.InvoiceStatus   = (RescueTekniq.BOL.Invoice_StatusEnum)(dr.DBtoInt("InvoiceStatus"));
            with_1.InvoicePaid     = System.Convert.ToBoolean(dr.DBtoBoolean("InvoicePaid"));
            with_1.InvoicePaidDate = System.Convert.ToDateTime(dr.DBtoDateTime("InvoicePaidDate"));

            PopulateStandard(dr, c);
        }