Example #1
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);
        }
        protected static void Populate(System.Data.SqlClient.SqlDataReader dr, PageContent c)
        {
            PopulateStandard(dr, c);
            var with_1 = c;

            with_1.Status = (RescueTekniq.BOL.PageContentStatusType)(dr.DBtoInt("Status"));

            with_1.IsActive = System.Convert.ToBoolean(dr.DBtoBoolean("IsActive"));

            with_1.PageType       = System.Convert.ToInt32(dr.DBtoInt("PageType"));
            with_1.LocalCultureID = System.Convert.ToInt32(dr.DBtoInt("LocalCultureID"));

            with_1.Title     = dr.DBtoString("Title");
            with_1.Alias     = dr.DBtoString("Alias");
            with_1.ShowTitle = System.Convert.ToBoolean(dr.DBtoBoolean("ShowTitle"));

            with_1.SubTitle    = dr.DBtoString("SubTitle");
            with_1.Description = dr.DBtoString("Description");
            with_1.KeyWords    = dr.DBtoString("KeyWords");

            with_1.Content     = dr.DBtoString("Content");
            with_1.PublishDate = System.Convert.ToDateTime(dr.DBtoDate("PublishDate"));
            with_1.ExpiredDate = System.Convert.ToDateTime(dr.DBtoDate("ExpiredDate"));
        }
Example #3
0
        private static void Populate(System.Data.SqlClient.SqlDataReader dr, FAB c)
        {
            var with_1 = c;

            with_1.Status    = (RescueTekniq.BOL.FAB_StatusEnum)(dr.DBtoInt("Status"));
            with_1.CompanyID = System.Convert.ToInt32(dr.DBtoInt("CompanyID"));

            with_1.ModelID  = System.Convert.ToInt32(dr.DBtoInt("ModelID"));
            with_1.SerialNo = dr.DBtoString("SerialNo");

            with_1.DeleveryDate      = System.Convert.ToDateTime(dr.DBtoDate("DeleveryDate"));
            with_1.WarencyExpireDate = System.Convert.ToDateTime(dr.DBtoDate("WarencyExpireDate"));
            with_1.DecommissionDate  = System.Convert.ToDateTime(dr.DBtoDate("DecommissionDate"));
            with_1.EmailSendt        = System.Convert.ToDateTime(dr.DBtoDate("EmailSendt"));

            with_1.BilagStatus       = (RescueTekniq.BOL.FAB_BilagStatus)(dr.DBtoInt("BilagStatus"));
            with_1.BilagSendtDato    = System.Convert.ToDateTime(dr.DBtoDate("BilagSendtDato"));
            with_1.BilagModtagetDato = System.Convert.ToDateTime(dr.DBtoDate("BilagModtagetDato"));

            with_1.ResponsibleName  = dr.DBtoString("ResponsibleName");
            with_1.ResponsiblePhone = dr.DBtoString("ResponsiblePhone");
            with_1.ResponsibleEmail = dr.DBtoString("ResponsibleEmail");

            with_1.LocationAdresse    = dr.DBtoString("LocationAdresse");
            with_1.LocationPostnr     = dr.DBtoString("LocationPostnr");
            with_1.LocationBy         = dr.DBtoString("LocationBy");
            with_1.LocationState      = dr.DBtoString("LocationState");
            with_1.LocationLandID     = System.Convert.ToInt32(dr.DBtoInt("LocationLandID"));
            with_1.Location           = dr.DBtoString("Location");
            with_1.LocationBuildingNo = dr.DBtoString("LocationBuildingNo");

            with_1.ServiceDate       = System.Convert.ToInt32(dr.DBtoInt("ServiceDate"));
            with_1.ServiceDateEmail  = System.Convert.ToDateTime(dr.DBtoDate("ServiceDateEmail"));
            with_1.VisibleRescueinfo = System.Convert.ToBoolean(dr.DBtoBoolean("VisibleRescueinfo"));
            with_1.RegisterretAF     = dr.DBtoString("RegisterretAF");

            with_1.Note = dr.DBtoString("Note");

            PopulateStandard(dr, c);
        }