Пример #1
0
        /// <summary>
        /// Creates a new instance of the sol_Products class and populates it with data from the specified SqlDataReader.
        /// </summary>
        protected virtual Sol_Product MakeSol_Product(SqlDataReader dataReader)
        {
            Sol_Product sol_Product = new Sol_Product();

            sol_Product.ProductID           = SqlClientUtility.GetInt32(dataReader, "ProductID", 0);
            sol_Product.ProName             = SqlClientUtility.GetString(dataReader, "ProName", String.Empty);
            sol_Product.ProDescription      = SqlClientUtility.GetString(dataReader, "ProDescription", String.Empty);
            sol_Product.ProShortDescription = SqlClientUtility.GetString(dataReader, "ProShortDescription", String.Empty);
            sol_Product.ProImage            = SqlClientUtility.GetBytes(dataReader, "ProImage", new byte[0]);
            sol_Product.AgencyID            = SqlClientUtility.GetInt32(dataReader, "AgencyID", 0);
            sol_Product.MenuOrder           = SqlClientUtility.GetInt32(dataReader, "MenuOrder", 0);
            sol_Product.IsActive            = SqlClientUtility.GetBoolean(dataReader, "IsActive", false);
            sol_Product.Price                    = SqlClientUtility.GetDecimal(dataReader, "Price", Decimal.Zero);
            sol_Product.CategoryID               = SqlClientUtility.GetInt32(dataReader, "CategoryID", 0);
            sol_Product.RefundAmount             = SqlClientUtility.GetDecimal(dataReader, "RefundAmount", Decimal.Zero);
            sol_Product.HandlingCommissionAmount = SqlClientUtility.GetDecimal(dataReader, "HandlingCommissionAmount", Decimal.Zero);
            sol_Product.CommissionUnit           = SqlClientUtility.GetInt32(dataReader, "CommissionUnit", 0);
            sol_Product.VafAmount                = SqlClientUtility.GetDecimal(dataReader, "VafAmount", Decimal.Zero);
            sol_Product.FeeUnit                  = SqlClientUtility.GetInt32(dataReader, "FeeUnit", 0);
            sol_Product.ContainerID              = SqlClientUtility.GetInt32(dataReader, "ContainerID", 0);
            sol_Product.StandardDozenID          = SqlClientUtility.GetInt32(dataReader, "StandardDozenID", 0);
            sol_Product.UPC             = SqlClientUtility.GetString(dataReader, "UPC", String.Empty);
            sol_Product.ProductCode     = SqlClientUtility.GetString(dataReader, "ProductCode", String.Empty);
            sol_Product.TypeId          = SqlClientUtility.GetByte(dataReader, "TypeId", 0x00);
            sol_Product.Tax1Exempt      = SqlClientUtility.GetBoolean(dataReader, "Tax1Exempt", false);
            sol_Product.Tax2Exempt      = SqlClientUtility.GetBoolean(dataReader, "Tax2Exempt", false);
            sol_Product.MasterProductID = SqlClientUtility.GetInt32(dataReader, "MasterProductID", 0);
            sol_Product.Weight          = SqlClientUtility.GetDecimal(dataReader, "Weight", Decimal.Zero);
            sol_Product.Volume          = SqlClientUtility.GetDecimal(dataReader, "Volume", Decimal.Zero);
            sol_Product.TargetQuantity  = SqlClientUtility.GetInt32(dataReader, "TargetQuantity", 0);

            return(sol_Product);
        }
Пример #2
0
        /// <summary>
        /// Creates a new instance of the sol_CategoryButtons class and populates it with data from the specified SqlDataReader.
        /// </summary>
        protected virtual Sol_CategoryButton MakeSol_CategoryButton(SqlDataReader dataReader)
        {
            Sol_CategoryButton sol_CategoryButton = new Sol_CategoryButton();

            sol_CategoryButton.CategoryButtonID      = SqlClientUtility.GetInt32(dataReader, "CategoryButtonID", 0);
            sol_CategoryButton.WorkStationID         = SqlClientUtility.GetInt32(dataReader, "WorkStationID", 0);
            sol_CategoryButton.ControlType           = SqlClientUtility.GetByte(dataReader, "ControlType", 0x00);
            sol_CategoryButton.Description           = SqlClientUtility.GetString(dataReader, "Description", String.Empty);
            sol_CategoryButton.DefaultQuantity       = SqlClientUtility.GetInt32(dataReader, "DefaultQuantity", 0);
            sol_CategoryButton.CategoryID            = SqlClientUtility.GetInt32(dataReader, "CategoryID", 0);
            sol_CategoryButton.LocationX             = SqlClientUtility.GetInt32(dataReader, "LocationX", 0);
            sol_CategoryButton.LocationY             = SqlClientUtility.GetInt32(dataReader, "LocationY", 0);
            sol_CategoryButton.Width                 = SqlClientUtility.GetInt32(dataReader, "Width", 0);
            sol_CategoryButton.Height                = SqlClientUtility.GetInt32(dataReader, "Height", 0);
            sol_CategoryButton.Font                  = SqlClientUtility.GetString(dataReader, "Font", String.Empty);
            sol_CategoryButton.FontStyle             = SqlClientUtility.GetString(dataReader, "FontStyle", String.Empty);
            sol_CategoryButton.ForeColor             = SqlClientUtility.GetString(dataReader, "ForeColor", String.Empty);
            sol_CategoryButton.BackColor             = SqlClientUtility.GetString(dataReader, "BackColor", String.Empty);
            sol_CategoryButton.ImageIndex            = SqlClientUtility.GetInt32(dataReader, "ImageIndex", 0);
            sol_CategoryButton.ImagePath             = SqlClientUtility.GetString(dataReader, "ImagePath", String.Empty);
            sol_CategoryButton.SubContainerMaxCount  = SqlClientUtility.GetInt32(dataReader, "SubContainerMaxCount", 0);
            sol_CategoryButton.SubContainerCounter   = SqlClientUtility.GetInt32(dataReader, "SubContainerCounter", 0);
            sol_CategoryButton.ImageSize             = SqlClientUtility.GetByte(dataReader, "ImageSize", 0x00);
            sol_CategoryButton.SubContainerCountDown = SqlClientUtility.GetBoolean(dataReader, "SubContainerCountDown", false);
            sol_CategoryButton.MaxCountPerLine       = SqlClientUtility.GetInt32(dataReader, "MaxCountPerLine", 0);
            try
            {
                sol_CategoryButton.ForeColorArgb = SqlClientUtility.GetInt32(dataReader, "ForeColorArgb", 0);
                sol_CategoryButton.BackColorArgb = SqlClientUtility.GetInt32(dataReader, "BackColorArgb", 0);
            }
            catch { }

            return(sol_CategoryButton);
        }
Пример #3
0
        /// <summary>
        /// Creates a new instance of the Sac_Money class and populates it with data from the specified SqlDataReader.
        /// </summary>
        protected virtual Sac_Money MakeSac_Money(SqlDataReader dataReader)
        {
            Sac_Money sac_Money = new Sac_Money();

            sac_Money.MoneyID     = SqlClientUtility.GetInt32(dataReader, "MoneyID", 0);
            sac_Money.Name        = SqlClientUtility.GetString(dataReader, "Name", String.Empty);
            sac_Money.TypeID      = SqlClientUtility.GetByte(dataReader, "TypeID", 0x00);
            sac_Money.DollarValue = SqlClientUtility.GetDecimal(dataReader, "DollarValue", Decimal.Zero);
            sac_Money.CountryCode = SqlClientUtility.GetString(dataReader, "CountryCode", String.Empty);

            return(sac_Money);
        }
Пример #4
0
        /// <summary>
        /// Creates a new instance of the sol_CashDenominations class and populates it with data from the specified SqlDataReader.
        /// </summary>
        protected virtual Sol_CashDenomination MakeSol_CashDenomination(SqlDataReader dataReader)
        {
            Sol_CashDenomination sol_CashDenomination = new Sol_CashDenomination();

            sol_CashDenomination.CashID        = SqlClientUtility.GetInt32(dataReader, "CashID", 0);
            sol_CashDenomination.CashType      = SqlClientUtility.GetByte(dataReader, "CashType", 0x00);
            sol_CashDenomination.CashValue     = SqlClientUtility.GetDecimal(dataReader, "CashValue", Decimal.Zero);
            sol_CashDenomination.Description   = SqlClientUtility.GetString(dataReader, "Description", String.Empty);
            sol_CashDenomination.OrderValue    = SqlClientUtility.GetInt16(dataReader, "OrderValue", 0);
            sol_CashDenomination.CashItemValue = SqlClientUtility.GetDecimal(dataReader, "CashItemValue", Decimal.Zero);
            sol_CashDenomination.Quantity      = SqlClientUtility.GetInt32(dataReader, "Quantity", 0);
            sol_CashDenomination.MoneyID       = SqlClientUtility.GetInt32(dataReader, "MoneyID", 0);

            return(sol_CashDenomination);
        }
Пример #5
0
        /// <summary>
        /// Creates a new instance of the Sac_Charity class and populates it with data from the specified SqlDataReader.
        /// </summary>
        protected virtual Sac_Charity MakeSac_Charity(SqlDataReader dataReader)
        {
            Sac_Charity sac_Charity = new Sac_Charity();

            sac_Charity.CharityID          = SqlClientUtility.GetInt32(dataReader, "CharityID", 0);
            sac_Charity.CustomerID         = SqlClientUtility.GetInt32(dataReader, "CustomerID", 0);
            sac_Charity.ShortName          = SqlClientUtility.GetString(dataReader, "ShortName", String.Empty);
            sac_Charity.CharityDescription = SqlClientUtility.GetString(dataReader, "CharityDescription", String.Empty);
            sac_Charity.CharityTypeID      = SqlClientUtility.GetInt32(dataReader, "CharityTypeID", 0);
            sac_Charity.RegistrationNumber = SqlClientUtility.GetString(dataReader, "RegistrationNumber", String.Empty);
            sac_Charity.IsActive           = SqlClientUtility.GetBoolean(dataReader, "IsActive", false);
            sac_Charity.ButtonPosition     = SqlClientUtility.GetByte(dataReader, "ButtonPosition", 0x00);
            sac_Charity.Logo = SqlClientUtility.GetBytes(dataReader, "Logo", new byte[0]);

            return(sac_Charity);
        }
Пример #6
0
        /// <summary>
        /// Creates a new instance of the Sol_Employees class and populates it with data from the specified SqlDataReader.
        /// </summary>
        protected virtual Sol_Employee MakeSol_Employee(SqlDataReader dataReader)
        {
            Sol_Employee sol_Employee = new Sol_Employee();

            sol_Employee.UserId             = SqlClientUtility.GetGuid(dataReader, "UserId", Guid.Empty);
            sol_Employee.FirstName          = SqlClientUtility.GetString(dataReader, "FirstName", String.Empty);
            sol_Employee.LastName           = SqlClientUtility.GetString(dataReader, "LastName", String.Empty);
            sol_Employee.MiddleName         = SqlClientUtility.GetString(dataReader, "MiddleName", String.Empty);
            sol_Employee.BirthDate          = SqlClientUtility.GetDateTime(dataReader, "BirthDate", new DateTime(0));
            sol_Employee.HireDate           = SqlClientUtility.GetDateTime(dataReader, "HireDate", new DateTime(0));
            sol_Employee.EmployeeNotes      = SqlClientUtility.GetString(dataReader, "EmployeeNotes", String.Empty);
            sol_Employee.SIN                = SqlClientUtility.GetString(dataReader, "SIN", String.Empty);
            sol_Employee.Gender             = SqlClientUtility.GetByte(dataReader, "Gender", 0x00);
            sol_Employee.EmployeeNumber     = SqlClientUtility.GetString(dataReader, "EmployeeNumber", String.Empty);
            sol_Employee.PayrollNumber      = SqlClientUtility.GetString(dataReader, "PayrollNumber", String.Empty);
            sol_Employee.CompensationAmount = SqlClientUtility.GetDecimal(dataReader, "CompensationAmount", Decimal.Zero);
            sol_Employee.CompensationType   = SqlClientUtility.GetByte(dataReader, "CompensationType", 0x00);

            return(sol_Employee);
        }
Пример #7
0
        /// <summary>
        /// Creates a new instance of the sol_QuantityButtons class and populates it with data from the specified SqlDataReader.
        /// </summary>
        protected virtual Sol_QuantityButton MakeSol_QuantityButton(SqlDataReader dataReader)
        {
            Sol_QuantityButton sol_QuantityButton = new Sol_QuantityButton();

            sol_QuantityButton.QuantityButtonID = SqlClientUtility.GetInt32(dataReader, "QuantityButtonID", 0);
            sol_QuantityButton.WorkStationID    = SqlClientUtility.GetInt32(dataReader, "WorkStationID", 0);
            sol_QuantityButton.ControlType      = SqlClientUtility.GetByte(dataReader, "ControlType", 0x00);
            sol_QuantityButton.Description      = SqlClientUtility.GetString(dataReader, "Description", String.Empty);
            sol_QuantityButton.DefaultQuantity  = SqlClientUtility.GetInt32(dataReader, "DefaultQuantity", 0);
            sol_QuantityButton.CategoryID       = SqlClientUtility.GetInt32(dataReader, "CategoryID", 0);
            sol_QuantityButton.LocationX        = SqlClientUtility.GetInt32(dataReader, "LocationX", 0);
            sol_QuantityButton.LocationY        = SqlClientUtility.GetInt32(dataReader, "LocationY", 0);
            sol_QuantityButton.Width            = SqlClientUtility.GetInt32(dataReader, "Width", 0);
            sol_QuantityButton.Height           = SqlClientUtility.GetInt32(dataReader, "Height", 0);
            sol_QuantityButton.Font             = SqlClientUtility.GetString(dataReader, "Font", String.Empty);
            sol_QuantityButton.FontStyle        = SqlClientUtility.GetString(dataReader, "FontStyle", String.Empty);
            sol_QuantityButton.ForeColor        = SqlClientUtility.GetString(dataReader, "ForeColor", String.Empty);
            sol_QuantityButton.BackColor        = SqlClientUtility.GetString(dataReader, "BackColor", String.Empty);

            return(sol_QuantityButton);
        }
Пример #8
0
        /// <summary>
        /// Creates a new instance of the sol_Orders class and populates it with data from the specified SqlDataReader.
        /// </summary>
        protected virtual Sol_Order MakeSol_Order(SqlDataReader dataReader)
        {
            Sol_Order sol_Order = new Sol_Order();

            sol_Order.OrderID       = SqlClientUtility.GetInt32(dataReader, "OrderID", 0);
            sol_Order.OrderType     = SqlClientUtility.GetString(dataReader, "OrderType", String.Empty);
            sol_Order.WorkStationID = SqlClientUtility.GetInt32(dataReader, "WorkStationID", 0);
            sol_Order.ComputerName  = SqlClientUtility.GetString(dataReader, "ComputerName", String.Empty);
            sol_Order.UserID        = SqlClientUtility.GetGuid(dataReader, "UserID", Guid.Empty);
            sol_Order.UserName      = SqlClientUtility.GetString(dataReader, "UserName", String.Empty);
            sol_Order.Date          = SqlClientUtility.GetDateTime(dataReader, "Date", new DateTime(0));
            sol_Order.CashTrayID    = SqlClientUtility.GetInt32(dataReader, "CashTrayID", 0);
            sol_Order.CustomerID    = SqlClientUtility.GetInt32(dataReader, "CustomerID", 0);
            sol_Order.Name          = SqlClientUtility.GetString(dataReader, "Name", String.Empty);
            sol_Order.Address1      = SqlClientUtility.GetString(dataReader, "Address1", String.Empty);
            sol_Order.Address2      = SqlClientUtility.GetString(dataReader, "Address2", String.Empty);
            sol_Order.City          = SqlClientUtility.GetString(dataReader, "City", String.Empty);
            sol_Order.Province      = SqlClientUtility.GetString(dataReader, "Province", String.Empty);
            sol_Order.Country       = SqlClientUtility.GetString(dataReader, "Country", String.Empty);
            sol_Order.PostalCode    = SqlClientUtility.GetString(dataReader, "PostalCode", String.Empty);
            sol_Order.TotalAmount   = SqlClientUtility.GetDecimal(dataReader, "TotalAmount", Decimal.Zero);
            sol_Order.DateClosed    = SqlClientUtility.GetDateTime(dataReader, "DateClosed", new DateTime(0));
            sol_Order.DatePaid      = SqlClientUtility.GetDateTime(dataReader, "DatePaid", new DateTime(0));
            sol_Order.FeeID         = SqlClientUtility.GetInt32(dataReader, "FeeID", 0);
            sol_Order.FeeAmount     = SqlClientUtility.GetDecimal(dataReader, "FeeAmount", Decimal.Zero);
            sol_Order.Tax1Amount    = SqlClientUtility.GetDecimal(dataReader, "Tax1Amount", Decimal.Zero);
            sol_Order.Tax2Amount    = SqlClientUtility.GetDecimal(dataReader, "Tax2Amount", Decimal.Zero);
            sol_Order.Status        = SqlClientUtility.GetString(dataReader, "Status", String.Empty);
            sol_Order.Reference     = SqlClientUtility.GetString(dataReader, "Reference", String.Empty);
            sol_Order.PaymentTypeID = SqlClientUtility.GetByte(dataReader, "PaymentTypeID", 0x00);
            sol_Order.SecurityCode  = SqlClientUtility.GetString(dataReader, "SecurityCode", String.Empty);
            sol_Order.Comments      = SqlClientUtility.GetString(dataReader, "Comments", String.Empty);
            //sol_Order.IsNew = SqlClientUtility.GetBoolean(dataReader, "IsNew", false);

            return(sol_Order);
        }
Пример #9
0
        /// <summary>
        /// Creates a new instance of the sol_Control class and populates it with data from the specified SqlDataReader.
        /// </summary>
        protected virtual Sol_Control MakeSol_Control(SqlDataReader dataReader)
        {
            Sol_Control sol_Control = new Sol_Control();

            sol_Control.ControlID                   = SqlClientUtility.GetInt32(dataReader, "ControlID", 0);
            sol_Control.BusinessName                = SqlClientUtility.GetString(dataReader, "BusinessName", String.Empty);
            sol_Control.LegalName                   = SqlClientUtility.GetString(dataReader, "LegalName", String.Empty);
            sol_Control.StoreNumber                 = SqlClientUtility.GetInt32(dataReader, "StoreNumber", 0);
            sol_Control.Address                     = SqlClientUtility.GetString(dataReader, "Address", String.Empty);
            sol_Control.City                        = SqlClientUtility.GetString(dataReader, "City", String.Empty);
            sol_Control.State                       = SqlClientUtility.GetString(dataReader, "State", String.Empty);
            sol_Control.Country                     = SqlClientUtility.GetString(dataReader, "Country", String.Empty);
            sol_Control.PhoneNumber                 = SqlClientUtility.GetString(dataReader, "PhoneNumber", String.Empty);
            sol_Control.BusinessHoursFrom           = SqlClientUtility.GetDateTime(dataReader, "BusinessHoursFrom", new DateTime(0));
            sol_Control.BusinessHoursTo             = SqlClientUtility.GetDateTime(dataReader, "BusinessHoursTo", new DateTime(0));
            sol_Control.IdFiscal1Name               = SqlClientUtility.GetString(dataReader, "IdFiscal1Name", String.Empty);
            sol_Control.IdFiscal1Value              = SqlClientUtility.GetString(dataReader, "IdFiscal1Value", String.Empty);
            sol_Control.IdFiscal2Name               = SqlClientUtility.GetString(dataReader, "IdFiscal2Name", String.Empty);
            sol_Control.IdFiscal2Value              = SqlClientUtility.GetString(dataReader, "IdFiscal2Value", String.Empty);
            sol_Control.WorkStationID               = SqlClientUtility.GetInt32(dataReader, "WorkStationID", 0);
            sol_Control.CustomerScreenMessageID     = SqlClientUtility.GetInt32(dataReader, "CustomerScreenMessageID", 0);
            sol_Control.FrontStationMessageID       = SqlClientUtility.GetInt32(dataReader, "FrontStationMessageID", 0);
            sol_Control.CashierRoutineMessageID     = SqlClientUtility.GetInt32(dataReader, "CashierRoutineMessageID", 0);
            sol_Control.ReturnStationMessageID      = SqlClientUtility.GetInt32(dataReader, "ReturnStationMessageID", 0);
            sol_Control.CashierStationMessageID     = SqlClientUtility.GetInt32(dataReader, "CashierStationMessageID", 0);
            sol_Control.ShippingStationMessageID    = SqlClientUtility.GetInt32(dataReader, "ShippingStationMessageID", 0);
            sol_Control.ReceiptMessageID            = SqlClientUtility.GetInt32(dataReader, "ReceiptMessageID", 0);
            sol_Control.SMTPServer                  = SqlClientUtility.GetString(dataReader, "SMTPServer", String.Empty);
            sol_Control.SMTPPort                    = SqlClientUtility.GetInt32(dataReader, "SMTPPort", 0);
            sol_Control.EmailAccount                = SqlClientUtility.GetString(dataReader, "EmailAccount", String.Empty);
            sol_Control.EmailPassword               = SqlClientUtility.GetString(dataReader, "EmailPassword", String.Empty);
            sol_Control.HistoryYears                = SqlClientUtility.GetByte(dataReader, "HistoryYears", 0x00);
            sol_Control.FiscalYearInitialMonth      = SqlClientUtility.GetByte(dataReader, "FiscalYearInitialMonth", 0x00);
            sol_Control.NumericKeyPadOn             = SqlClientUtility.GetBoolean(dataReader, "NumericKeyPadOn", false);
            sol_Control.NumericKeyPadPosition       = SqlClientUtility.GetByte(dataReader, "NumericKeyPadPosition", 0x00);
            sol_Control.ReturnButtonExtra           = SqlClientUtility.GetByte(dataReader, "ReturnButtonExtra", 0x00);
            sol_Control.Tax1Name                    = SqlClientUtility.GetString(dataReader, "Tax1Name", String.Empty);
            sol_Control.Tax1Rate                    = SqlClientUtility.GetDecimal(dataReader, "Tax1Rate", Decimal.Zero);
            sol_Control.Tax2Name                    = SqlClientUtility.GetString(dataReader, "Tax2Name", String.Empty);
            sol_Control.Tax2Rate                    = SqlClientUtility.GetDecimal(dataReader, "Tax2Rate", Decimal.Zero);
            sol_Control.DatabaseVersion             = SqlClientUtility.GetDecimal(dataReader, "DatabaseVersion", Decimal.Zero);
            sol_Control.Status                      = SqlClientUtility.GetString(dataReader, "Status", String.Empty);
            sol_Control.EmployeesListRefresh        = SqlClientUtility.GetInt32(dataReader, "EmployeesListRefresh", 0);
            sol_Control.WebBrowserUrl               = SqlClientUtility.GetString(dataReader, "WebBrowserUrl", String.Empty);
            sol_Control.AutoGenerateTagNumber       = SqlClientUtility.GetBoolean(dataReader, "AutoGenerateTagNumber", false);
            sol_Control.AutoGenerateRBillNumber     = SqlClientUtility.GetBoolean(dataReader, "AutoGenerateRBillNumber", false);
            sol_Control.DefaultAgencyID             = SqlClientUtility.GetInt32(dataReader, "DefaultAgencyID", 0);
            sol_Control.ChitTicketComplete          = SqlClientUtility.GetByte(dataReader, "ChitTicketComplete", 0x00);
            sol_Control.ChitTicketIncludeBarcode    = SqlClientUtility.GetBoolean(dataReader, "ChitTicketIncludeBarcode", false);
            sol_Control.CashOutPrintingOverride     = SqlClientUtility.GetBoolean(dataReader, "CashOutPrintingOverride", false);
            sol_Control.WhiteBagID                  = SqlClientUtility.GetInt32(dataReader, "WhiteBagID", 0);
            sol_Control.BlueBagID                   = SqlClientUtility.GetInt32(dataReader, "BlueBagID", 0);
            sol_Control.OneWayBagID                 = SqlClientUtility.GetInt32(dataReader, "OneWayBagID", 0);
            sol_Control.ABCRCPalletsID              = SqlClientUtility.GetInt32(dataReader, "ABCRCPalletsID", 0);
            sol_Control.CustomerScreenMonitor       = SqlClientUtility.GetByte(dataReader, "CustomerScreenMonitor", 0x00);
            sol_Control.CategoryButtonsPanelBgColor = SqlClientUtility.GetInt32(dataReader, "CategoryButtonsPanelBgColor", 0);
            sol_Control.CategoryButtonsSnapToGrid   = SqlClientUtility.GetBoolean(dataReader, "CategoryButtonsSnapToGrid", false);
            sol_Control.BusinessHoursFromTue        = SqlClientUtility.GetDateTime(dataReader, "BusinessHoursFromTue", new DateTime(0));
            sol_Control.BusinessHoursToTue          = SqlClientUtility.GetDateTime(dataReader, "BusinessHoursToTue", new DateTime(0));
            sol_Control.BusinessHoursFromWed        = SqlClientUtility.GetDateTime(dataReader, "BusinessHoursFromWed", new DateTime(0));
            sol_Control.BusinessHoursToWed          = SqlClientUtility.GetDateTime(dataReader, "BusinessHoursToWed", new DateTime(0));
            sol_Control.BusinessHoursFromThu        = SqlClientUtility.GetDateTime(dataReader, "BusinessHoursFromThu", new DateTime(0));
            sol_Control.BusinessHoursToThu          = SqlClientUtility.GetDateTime(dataReader, "BusinessHoursToThu", new DateTime(0));
            sol_Control.BusinessHoursFromFri        = SqlClientUtility.GetDateTime(dataReader, "BusinessHoursFromFri", new DateTime(0));
            sol_Control.BusinessHoursToFri          = SqlClientUtility.GetDateTime(dataReader, "BusinessHoursToFri", new DateTime(0));
            sol_Control.BusinessHoursFromSat        = SqlClientUtility.GetDateTime(dataReader, "BusinessHoursFromSat", new DateTime(0));
            sol_Control.BusinessHoursToSat          = SqlClientUtility.GetDateTime(dataReader, "BusinessHoursToSat", new DateTime(0));
            sol_Control.BusinessHoursFromSun        = SqlClientUtility.GetDateTime(dataReader, "BusinessHoursFromSun", new DateTime(0));
            sol_Control.BusinessHoursToSun          = SqlClientUtility.GetDateTime(dataReader, "BusinessHoursToSun", new DateTime(0));
            sol_Control.ReturnsMaxQuantity          = SqlClientUtility.GetInt32(dataReader, "ReturnsMaxQuantity", 0);
            sol_Control.WebBrowserUpdateHistoryUrl  = SqlClientUtility.GetString(dataReader, "WebBrowserUpdateHistoryUrl", String.Empty);
            sol_Control.CashierMaxAmount            = SqlClientUtility.GetDecimal(dataReader, "CashierMaxAmount", Decimal.Zero);
            sol_Control.ComputerRole                = SqlClientUtility.GetByte(dataReader, "ComputerRole", 0x00);
            sol_Control.SqlServerDate               = SqlClientUtility.GetBoolean(dataReader, "SqlServerDate", false);
            sol_Control.VendorID                    = SqlClientUtility.GetInt32(dataReader, "VendorID", 0);
            sol_Control.DefaultPlantID              = SqlClientUtility.GetInt32(dataReader, "DefaultPlantID", 0);
            sol_Control.DefaultCarrierID            = SqlClientUtility.GetInt32(dataReader, "DefaultCarrierID", 0);
            sol_Control.ABCRCUserName               = SqlClientUtility.GetString(dataReader, "ABCRCUserName", String.Empty);
            sol_Control.ABCRCPassword               = SqlClientUtility.GetString(dataReader, "ABCRCPassword", String.Empty);
            sol_Control.ReceiptAmountBarcode        = SqlClientUtility.GetBoolean(dataReader, "ReceiptAmountBarcode", false);
            sol_Control.IncludeSecurityCode         = SqlClientUtility.GetBoolean(dataReader, "IncludeSecurityCode", false);
            sol_Control.RBillNumberBarcode          = SqlClientUtility.GetBoolean(dataReader, "RBillNumberBarcode", false);
            sol_Control.SacCashTrayID               = SqlClientUtility.GetInt32(dataReader, "SacCashTrayID", 0);

            return(sol_Control);
        }