Пример #1
0
        // make a TableData object from a SADataReader record
#if !NO_ASA
        static void MakeDataRec(SADataReader myDataReader, out TableData data)
        {
            data = new TableData(
                MainClass.ToInt(TableName, myDataReader["UserIsTemp"])
                , myDataReader["UserIsTempText"].ToString());
        }
Пример #2
0
        // insert record and return its primary key
        public static bool InsertRecord(TableData data, out int NewIid)
        {
            bool Retval = false;

            NewIid = -1;
            string SqlStatement = "INSERT INTO SITE (SiteId, SiteName, Address1, Address2, City, State, ZipCode, Country, Contact, Phone, DiagLine, Fax, Description, Notes, FacilityCode, PreExpPw, ArchiveId, PwExpDelta, UserIdExpireDelta, TempUserExpDays, PwLen, PtIdFormat, ConLogOffTimeOut, RptSortByItemId, Voice, Version, ArchiveYearFormat, DbMachineName, PrintStockOut, PrintCriticalLow, PrintADTconflict, PrintIncomingDiscrep, PrintCommDown, PermitGlobalPatientList, HomeFax, HomeEmail, ClientServerSystem, ORFeatures, DodWarning, CopyReports, EmailReports, UserDoorAccessPerItem, TechDoorAccessPerItem, Ticci, PwEnableComplex, PwComplexRegex, PwComplexDesc, PwMaxLen, PwHistory, PwHistoryClamp, ORISInterface, SmtpHost, SmptPort, SmtpUserSSL, SmtpUserName, SmtpPassword, pwEnableExtended, upgrade, siteGUID, allowGLCodeTransactions, allowORISTempToTempCaseTransfer,allowAssociator, allowAutoCaseToPatientXfer, holdRFIDTxForCase, activeDirectoryOnly, logVerbosity, logMsgFormat, logServerIP, logServerPort, logEnableRemote, pwMinAge, pwMinChg) VALUES ("
                                  + "'" + MainClass.FixStringForSingleQuote(data.SiteId) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.SiteName) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.Address1)
                                  + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.Address2) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.City) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.State)
                                  + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.ZipCode) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.Country) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.Contact)
                                  + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.Phone) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.DiagLine) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.Fax)
                                  + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.Description) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.Notes) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.FacilityCode)
                                  + "'" + ", " + (int)data.PreExpPw + ", " + "'" + MainClass.FixStringForSingleQuote(data.ArchiveId) + "'" + ", " + (int)data.PwExpDelta + ", " + (int)data.UserIdExpireDelta + ", " + (int)data.TempUserExpDays + ", "
                                  + (int)data.PwLen + ", " + "'" + MainClass.FixStringForSingleQuote(data.PtIdFormat) + "'" + ", " + (int)data.ConLogOffTimeOut + ", " + (int)data.RptSortByItemId + ", " + (int)data.Voice + ", " + "'" + MainClass.FixStringForSingleQuote(data.Version)
                                  + "'" + ", " + (int)data.ArchiveYearFormat + ", " + "'" + MainClass.FixStringForSingleQuote(data.DbMachineName) + "'" + ", " + (int)data.PrintStockOut + ", " + (int)data.PrintCriticalLow + ", " + (int)data.PrintADTconflict + ", "
                                  + (int)data.PrintIncomingDiscrep + ", " + (int)data.PrintCommDown + ", " + (int)data.PermitGlobalPatientList + ", " + "'" + MainClass.FixStringForSingleQuote(data.HomeFax) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.HomeEmail)
                                  + "'" + ", " + (int)data.ClientServerSystem + ", " + (int)data.ORFeatures + ", " + (int)data.DodWarning + ", " + (bool)data.CopyReports + ", " + (bool)data.EmailReports + ", " + (int)data.UserDoorAccessPerItem + ", "
                                  + (int)data.TechDoorAccessPerItem + ", " + (int)data.Ticci + ", " + (int)data.PwEnableComplex + ", " + "'" + MainClass.FixStringForSingleQuote(data.PwComplexRegex) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.PwComplexDesc)
                                  + "'" + ", " + (int)data.PwMaxLen + ", " + (int)data.PwHistory + ", " + (int)data.PwHistoryClamp + ", " + (int)data.ORISInterface + ", " + "'" + MainClass.FixStringForSingleQuote(data.SmtpHost) + "'" + ", " + (int)data.SmtpPort
                                  + ", " + (bool)data.SmtpUseSSL + ", " + "'" + MainClass.FixStringForSingleQuote(data.SmtpUsername) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(ConvertToUnsecureString(data.SmtpPassword)) + "'"
                                  + ", " + (bool)data.pwEnableExtended + ", " + (bool)data.upgrade + ", " + "'" + MainClass.FixStringForSingleQuote(data.siteGUID) + "'" + ", " + (int)data.allowGLCodeTransactions
                                  + ", " + (int)data.AllowORISTempToTempCaseTransfer
                                  + ", " + (int)data.allowAssociator
                                  + ", " + (int)data.allowAutoCaseToPatientXfer
                                  + ", " + (int)data.HoldRFIDTxForCase
                                  + ", " + (int)data.ActiveDirectoryOnly
                                  + ", " + (int)data.logSeverity + ", " + MainClass.FixStringForSingleQuote(data.logMsgFormat) + ", " + MainClass.FixStringForSingleQuote(data.logServerIP) + ", " + MainClass.FixStringForSingleQuote(data.logServerPort)
                                  + ", " + (int)data.logEnableRemote
                                  + ", " + (int)data.PwMinAge + ", " + (int)data.PwMinChg
                                  + ")";

            Retval = MainClass.ExecuteSql(SqlStatement, true, TableName, "Site", "InsertRecord", out NewIid);
            return(Retval);
        }
Пример #3
0
        // return record given its primary keys
        public static bool GetRecord(string ImportFileName, DateTime ImportTime, out TableData data)
        {
            bool Retval = true;

            data = null;

#if !NO_ASA
            SAConnection _conn;
            SADataReader myDataReader;
            string       SqlStatement = string.Format("SELECT * from D_S_IMPORT_REGISTRY WHERE ImportFileName='{0}' AND ImportTime='{1}'",
                                                      MainClass.FixStringForSingleQuote(ImportFileName), MainClass.DateTimeToTimestamp(ImportTime));
            if (MainClass.ExecuteSelect(SqlStatement, true, TableName, "DSImportRegistry", "GetRecord", out _conn, out myDataReader))
            {
                try
                {
                    if (myDataReader.Read())
                    {
                        MakeDataRec(myDataReader, out data);
                    }
                }
                catch (Exception ex)
                {
                    Retval = false;
                    string err = String.Format(MainClass.StringTable.GetString("DatabaseError"), TableName, ex.Message.ToString() + "(" + SqlStatement + ")");
                    ServiceMessages.InsertRec(MainClass.AppName, TableName, "GetRecord", err);
                }
                finally
                {
                    if (myDataReader != null)
                    {
                        myDataReader.Close();
                        myDataReader.Dispose();
                        myDataReader = null;
                    }
                    if (_conn != null)
                    {
                        _conn.Close();
                        _conn.Dispose();
                        _conn = null;
                    }
                }
            }
#endif
            return(Retval);
        }
Пример #4
0
        // make a TableData object from a SADataReader record
#if !NO_ASA
        static void MakeDataRec(SADataReader myDataReader, out TableData data)
        {
            data = new TableData(
                MainClass.ToInt(TableName, myDataReader["UserIid"])
                , MainClass.ToInt(TableName, myDataReader["AreaIid"]));
        }
Пример #5
0
        // insert record and return its primary key
        public static bool InsertRecord(TableData data, out int NewIid)
        {
            bool Retval = false;

            NewIid = -1;

            string SqlStatement = "INSERT INTO NURSE_UNIT (NUnitName, FacilityCode, DischargeDeltaTime) VALUES ("
                                  + "'" + MainClass.FixStringForSingleQuote(data.NUnitName) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.FacilityCode) + "'" + ", " + (int)data.DischargeDeltaTime + ")";

            Retval = MainClass.ExecuteSql(SqlStatement, true, TableName, "NurseUnit", "InsertRecord", out NewIid);
            return(Retval);
        }
Пример #6
0
        // insert record given all TableData fields
        public static bool InsertRecord(TableData data)
        {
            bool Retval = false;

            string SqlStatement = "INSERT INTO SN_DRAWER (CabinetId, MicroId, DrawerName, Drawer, SubDrawer, BtnBoardNbr, BtnBoardType, MaxPockets) VALUES ("
                                  + (int)data.CabinetId + ", " + (int)data.MicroId + ", " + "'" + MainClass.FixStringForSingleQuote(data.DrawerName) + "'" + ", " + (int)data.Drawer + ", " + (int)data.SubDrawer + ", " + (int)data.BtnBoardNbr + ", " + (int)data.BtnBoardType + ", " + (int)data.MaxPockets + ")";

            Retval = MainClass.ExecuteSql(SqlStatement, true, TableName, "SNDrawer", "InsertRecord");
            return(Retval);
        }
Пример #7
0
        // insert record given all TableData fields
        public static bool InsertRecord(TableData data)
        {
            bool Retval = false;

            string SqlStatement = "INSERT INTO MESSAGE_STRINGS (Lcid, MsgNbr, MsgText) VALUES ("
                                  + (int)data.Lcid + ", " + (int)data.MsgNbr + ", " + "'" + MainClass.FixStringForSingleQuote(data.MsgText) + "'" + ")";

            Retval = MainClass.ExecuteSql(SqlStatement, true, TableName, "MessageStrings", "InsertRecord");
            return(Retval);
        }
Пример #8
0
        // insert record and return its primary key
        public static bool InsertRecord(TableData data, out int NewIid)
        {
            bool Retval = false;

            NewIid = -1;

            string SqlStatement = "INSERT INTO USER_HIST (UserIid, EffectTime, Action, UserName, UserId, PassWord, AllAreas, UserExpires, PwExpired, CardReaderId, SourceDev, CreatorId, CreatorName, StnPriv, RxPriv, AccessType, AdminRightsMask, StockRightsMask, HasBeenArchived, TempUser) VALUES ("
                                  + (int)data.UserIid + ", " + MainClass.DateTimeToTimestamp(data.EffectTime) + ", " + (int)data.Action + ", " + "'" + MainClass.FixStringForSingleQuote(data.UserName) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.UserId) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.EncryptedPass) + "'" + ", " + (int)data.AllAreas + ", " + MainClass.DateTimeToTimestamp(data.UserExpires) + ", " + MainClass.DateTimeToTimestamp(data.PwExpired) + ", " + "'" + MainClass.FixStringForSingleQuote(data.CardReaderId) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.SourceDev) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.CreatorId) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.CreatorName) + "'" + ", " + (int)data.StnPriv + ", " + (int)data.RxPriv + ", " + "'" + MainClass.FixStringForSingleQuote(data.AccessType) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.AdminRightsMask) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.StockRightsMask) + "'" + ", " + (int)data.HasBeenArchived + ", " + (int)data.TempUser + ")";

            Retval = MainClass.ExecuteSql(SqlStatement, true, TableName, "UserHist", "InsertRecord", out NewIid);
            return(Retval);
        }
Пример #9
0
        // insert record and return its primary key
        public static bool InsertRecord(TableData data, out int NewIid)
        {
            bool Retval = false;

            NewIid = -1;

            string SqlStatement = "INSERT INTO COMM_LOG (Message_time, Destination, Source, Q_message, ProcessBox, MsgInOut) VALUES ("
                                  + MainClass.DateTimeToTimestamp(data.Message_time) + ", " + "'" + MainClass.FixStringForSingleQuote(data.Destination) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.Source) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.Q_message) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.ProcessBox) + "'" + ", " + (int)data.MsgInOut + ")";

            Retval = MainClass.ExecuteSql(SqlStatement, true, TableName, "CommLog", "InsertRecord", out NewIid);
            return(Retval);
        }
Пример #10
0
        // insert record and return its primary key
        public static bool InsertRecord(TableData data, out int NewIid)
        {
            bool Retval = false;

            NewIid = -1;

            string SqlStatement = "INSERT INTO PROC_MGMT_PROCEDURE (ProcedureName, ProcedureCode) VALUES ("
                                  + "'" + MainClass.FixStringForSingleQuote(data.ProcedureName) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.ProcedureCode) + "'" + ")";

            Retval = MainClass.ExecuteSql(SqlStatement, true, TableName, "ProcMgmtProcedure", "InsertRecord", out NewIid);
            return(Retval);
        }
Пример #11
0
        // insert record and return its primary key
        public static bool InsertRecord(TableData data, out int NewIid)
        {
            bool Retval = false;

            NewIid = -1;

            string SqlStatement = "INSERT INTO STATION_EVENT (DeviceName, ShutdownType, StationStopTime, StationStartTime, EventMsg) VALUES ("
                                  + "'" + MainClass.FixStringForSingleQuote(data.DeviceName) + "'" + ", " + (int)data.ShutdownType + ", " + MainClass.DateTimeToTimestamp(data.StationStopTime) + ", " + MainClass.DateTimeToTimestamp(data.StationStartTime) + ", " + "'" + MainClass.FixStringForSingleQuote(data.EventMsg) + "'" + ")";

            Retval = MainClass.ExecuteSql(SqlStatement, true, TableName, "StationEvent", "InsertRecord", out NewIid);
            return(Retval);
        }
Пример #12
0
        // insert record and return its primary key
        public static bool InsertRecord(TableData data, out int NewIid)
        {
            bool Retval = false;

            NewIid = -1;

            string SqlStatement = "INSERT INTO POCKET_ACCESS (DeviceName, TxTime, BtnDoorNbr, BtnBoardNbr, BtnBoardSeq, SubDrawer, PktDescriptor, ChassisSeqNbr, BtnColumnNbr, MsgTypeId, ItemName, ItemShortDesc, ItemAlias, ItemId, ItemAltId, ItemAltId2, ItemClass, ItemClassName, ItemType, ExpBeginCount, ActualBeginCount, TrxQty, PktPhysMaxQty, PktParQty, PktRefillPoint, PktCritLow, StnTotal, PostDateTime, LotNumber, SerialNumber, VendorName, UserName, UserId, TempUser, WitnName, WitnId, PtLastName, PtFirstName, PtMiddleName, PtId, PtAltId1, PtAltId2, PtComment1, PtComment2, NUnitName, Room, Bed, PtType, EADT, TempPatient, Waste, PtMergeId, HasBeenArchived, NextExpireTime, CostPerIssue, CostPerUnitRefill, CostPerUnitOrder, AreaName, ItemUnitOfIssue, ItemUnitOfRefill, ItemUnitOfOrder, TrxUOM, AdmitDrName, AttendDrName, KitId, FacilityCode, OrigVendSeq, OrigVendDate, IsBillable, CostCenter, VendorPartNumber, TimeBias, ItemIsChargeable, ItemStock, RefillId, RefillOrderedQty, RefillShippedQty, BtnPocketNbr, XfrToStation, ProcedureName, ProcedureCode, ServiceName, PhysicianName, PocketUnitOfIssue, PocketUOIRatio, TxCost, ItemBillOnly, SystemType, CabinetId, Drawer, PktPosLo, PktPosHi, StorageUnitName, SubUnitName, BinNumber, CaseId, CaseName, CaseCart, NewLotSerial, OverRideText, OverRideReason, SellPrice, CDM, SessionID, OrderNum, FloorStock, CaseProcId, isGLCode,OriginalTakeStation) VALUES ("
                                  + "'" + MainClass.FixStringForSingleQuote(data.DeviceName) + "'" + ", " + MainClass.DateTimeToTimestamp(data.TxTime) + ", " + (int)data.BtnDoorNbr + ", " + (int)data.BtnBoardNbr + ", " + (int)data.BtnBoardSeq + ", " + (int)data.SubDrawer + ", " + "'" + MainClass.FixStringForSingleQuote(data.PktDescriptor) + "'" + ", " + (int)data.ChassisSeqNbr + ", " + (int)data.BtnColumnNbr + ", " + (int)data.MsgTypeId + ", " + "'" + MainClass.FixStringForSingleQuote(data.ItemName) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.ItemShortDesc) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.ItemAlias) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.ItemId) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.ItemAltId) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.ItemAltId2) + "'" + ", " + (int)data.ItemClass + ", " + "'" + MainClass.FixStringForSingleQuote(data.ItemClassName) + "'" + ", " + (int)data.ItemType + ", " + (int)data.ExpBeginCount + ", " + (int)data.ActualBeginCount + ", " + (int)data.TrxQty + ", " + (int)data.PktPhysMaxQty + ", " + (int)data.PktParQty + ", " + (int)data.PktRefillPoint + ", " + (int)data.PktCritLow + ", " + (int)data.StnTotal + ", " + MainClass.DateTimeToTimestamp(data.PostDateTime) + ", " + "'" + MainClass.FixStringForSingleQuote(data.LotNumber) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.SerialNumber) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.VendorName) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.UserName) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.UserId) + "'" + ", " + (int)data.TempUser + ", " + "'" + MainClass.FixStringForSingleQuote(data.WitnName) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.WitnId) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.PtLastName) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.PtFirstName) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.PtMiddleName) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.PtId) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.PtAltId1) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.PtAltId2) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.PtComment1) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.PtComment2) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.NUnitName) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.Room) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.Bed) + "'" + ", " + (int)data.PtType + ", " + (int)data.EADT + ", " + (int)data.TempPatient + ", " + "'" + MainClass.FixStringForSingleQuote(data.Waste) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.PtMergeId) + "'" + ", " + (int)data.HasBeenArchived + ", " + MainClass.DateTimeToTimestamp(data.NextExpireTime) + ", " + data.CostPerIssue + ", " + data.CostPerUnitRefill + ", " + data.CostPerUnitOrder + ", " + "'" + MainClass.FixStringForSingleQuote(data.AreaName) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.ItemUnitOfIssue) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.ItemUnitOfRefill) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.ItemUnitOfOrder) + "'" + ", " + (int)data.TrxUOM + ", " + "'" + MainClass.FixStringForSingleQuote(data.AdmitDrName) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.AttendDrName) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.KitId) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.FacilityCode) + "'" + ", " + (int)data.OrigVendSeq + ", " + MainClass.DateTimeToTimestamp(data.OrigVendDate) + ", " + (int)data.IsBillable + ", " + "'" + MainClass.FixStringForSingleQuote(data.CostCenter) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.VendorPartNumber) + "'" + ", " + (int)data.TimeBias + ", " + (int)data.ItemIsChargeable + ", " + (int)data.ItemStock + ", " + "'" + MainClass.FixStringForSingleQuote(data.RefillId) + "'" + ", " + (int)data.RefillOrderedQty + ", " + (int)data.RefillShippedQty + ", " + (int)data.BtnPocketNbr + ", " + "'" + MainClass.FixStringForSingleQuote(data.XfrToStation) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.ProcedureName) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.ProcedureCode) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.ServiceName) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.PhysicianName) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.PocketUnitOfIssue) + "'" + ", " + (int)data.PocketUOIRatio + ", " + data.TxCost + ", " + (int)data.ItemBillOnly + ", " + (int)data.SystemType + ", " + (int)data.CabinetId + ", " + (int)data.Drawer + ", " + (int)data.PktPosLo + ", " + (int)data.PktPosHi + ", " + "'" + MainClass.FixStringForSingleQuote(data.StorageUnitName) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.SubUnitName) + "'" + ", " + (int)data.BinNumber + ", " + "'" + MainClass.FixStringForSingleQuote(data.CaseId) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.CaseName) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.CaseCart) + "'" + ", " + (int)data.NewLotSerial + ", " + "'" + MainClass.FixStringForSingleQuote(data.OverRideText) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.OverRideReason) + "'" + ", " + data.SellPrice + ", " + (int)data.CDM + ", " + "'" + MainClass.FixStringForSingleQuote(data.SessionID) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.OrderNum) + "'" + ", " + (int)data.FloorStock + ", " + "'" + MainClass.FixStringForSingleQuote(data.CaseProcId) + "'" + ", " + (int)data.isGLCode + ", " + "'" + MainClass.FixStringForSingleQuote(data.OriginalTakeStation) + "'" + ")";

            Retval = MainClass.ExecuteSql(SqlStatement, true, TableName, "PocketAccess", "InsertRecord", out NewIid);
            return(Retval);
        }
Пример #13
0
        // make a TableData object from a SADataReader record
#if !NO_ASA
        static void MakeDataRec(SADataReader myDataReader, out TableData data)
        {
            data = new TableData(
                MainClass.ToInt(TableName, myDataReader["PktAccIid"])
                , myDataReader["DeviceName"].ToString()
                , MainClass.ToDate(TableName, myDataReader["TxTime"])
                , MainClass.ToInt(TableName, myDataReader["BtnDoorNbr"])
                , MainClass.ToInt(TableName, myDataReader["BtnBoardNbr"])
                , MainClass.ToInt(TableName, myDataReader["BtnBoardSeq"])
                , MainClass.ToInt(TableName, myDataReader["SubDrawer"])
                , myDataReader["PktDescriptor"].ToString()
                , MainClass.ToInt(TableName, myDataReader["TrxSeq"])
                , MainClass.ToInt(TableName, myDataReader["ChassisSeqNbr"])
                , MainClass.ToInt(TableName, myDataReader["BtnColumnNbr"])
                , MainClass.ToInt(TableName, myDataReader["MsgTypeId"])
                , myDataReader["ItemName"].ToString()
                , myDataReader["ItemShortDesc"].ToString()
                , myDataReader["ItemAlias"].ToString()
                , myDataReader["ItemId"].ToString()
                , myDataReader["ItemAltId"].ToString()
                , myDataReader["ItemAltId2"].ToString()
                , MainClass.ToInt(TableName, myDataReader["ItemClass"])
                , myDataReader["ItemClassName"].ToString()
                , MainClass.ToInt(TableName, myDataReader["ItemType"])
                , MainClass.ToInt(TableName, myDataReader["ExpBeginCount"])
                , MainClass.ToInt(TableName, myDataReader["ActualBeginCount"])
                , MainClass.ToInt(TableName, myDataReader["TrxQty"])
                , MainClass.ToInt(TableName, myDataReader["PktPhysMaxQty"])
                , MainClass.ToInt(TableName, myDataReader["PktParQty"])
                , MainClass.ToInt(TableName, myDataReader["PktRefillPoint"])
                , MainClass.ToInt(TableName, myDataReader["PktCritLow"])
                , MainClass.ToInt(TableName, myDataReader["StnTotal"])
                , MainClass.ToDate(TableName, myDataReader["PostDateTime"])
                , myDataReader["LotNumber"].ToString()
                , myDataReader["SerialNumber"].ToString()
                , myDataReader["VendorName"].ToString()
                , myDataReader["UserName"].ToString()
                , myDataReader["UserId"].ToString()
                , MainClass.ToInt(TableName, myDataReader["TempUser"])
                , myDataReader["WitnName"].ToString()
                , myDataReader["WitnId"].ToString()
                , myDataReader["PtLastName"].ToString()
                , myDataReader["PtFirstName"].ToString()
                , myDataReader["PtMiddleName"].ToString()
                , myDataReader["PtId"].ToString()
                , myDataReader["PtAltId1"].ToString()
                , myDataReader["PtAltId2"].ToString()
                , myDataReader["PtComment1"].ToString()
                , myDataReader["PtComment2"].ToString()
                , myDataReader["NUnitName"].ToString()
                , myDataReader["Room"].ToString()
                , myDataReader["Bed"].ToString()
                , MainClass.ToInt(TableName, myDataReader["PtType"])
                , MainClass.ToInt(TableName, myDataReader["EADT"])
                , MainClass.ToInt(TableName, myDataReader["TempPatient"])
                , myDataReader["Waste"].ToString()
                , myDataReader["PtMergeId"].ToString()
                , MainClass.ToInt(TableName, myDataReader["HasBeenArchived"])
                , MainClass.ToDate(TableName, myDataReader["NextExpireTime"])
                , MainClass.ToDecimal(TableName, myDataReader["CostPerIssue"])
                , MainClass.ToDecimal(TableName, myDataReader["CostPerUnitRefill"])
                , MainClass.ToDecimal(TableName, myDataReader["CostPerUnitOrder"])
                , myDataReader["AreaName"].ToString()
                , myDataReader["ItemUnitOfIssue"].ToString()
                , myDataReader["ItemUnitOfRefill"].ToString()
                , myDataReader["ItemUnitOfOrder"].ToString()
                , MainClass.ToInt(TableName, myDataReader["TrxUOM"])
                , myDataReader["AdmitDrName"].ToString()
                , myDataReader["AttendDrName"].ToString()
                , myDataReader["KitId"].ToString()
                , myDataReader["FacilityCode"].ToString()
                , MainClass.ToInt(TableName, myDataReader["OrigVendSeq"])
                , MainClass.ToDate(TableName, myDataReader["OrigVendDate"])
                , MainClass.ToInt(TableName, myDataReader["IsBillable"])
                , myDataReader["CostCenter"].ToString()
                , myDataReader["VendorPartNumber"].ToString()
                , MainClass.ToInt(TableName, myDataReader["TimeBias"])
                , MainClass.ToInt(TableName, myDataReader["ItemIsChargeable"])
                , MainClass.ToInt(TableName, myDataReader["ItemStock"])
                , myDataReader["RefillId"].ToString()
                , MainClass.ToInt(TableName, myDataReader["RefillOrderedQty"])
                , MainClass.ToInt(TableName, myDataReader["RefillShippedQty"])
                , MainClass.ToInt(TableName, myDataReader["BtnPocketNbr"])
                , myDataReader["XfrToStation"].ToString()
                , myDataReader["ProcedureName"].ToString()
                , myDataReader["ProcedureCode"].ToString()
                , myDataReader["ServiceName"].ToString()
                , myDataReader["PhysicianName"].ToString()
                , myDataReader["PocketUnitOfIssue"].ToString()
                , MainClass.ToInt(TableName, myDataReader["PocketUOIRatio"])
                , MainClass.ToDecimal(TableName, myDataReader["TxCost"])
                , MainClass.ToInt(TableName, myDataReader["ItemBillOnly"])
                , MainClass.ToInt(TableName, myDataReader["SystemType"])
                , MainClass.ToInt(TableName, myDataReader["CabinetId"])
                , MainClass.ToInt(TableName, myDataReader["Drawer"])
                , MainClass.ToInt(TableName, myDataReader["PktPosLo"])
                , MainClass.ToInt(TableName, myDataReader["PktPosHi"])
                , myDataReader["StorageUnitName"].ToString()
                , myDataReader["SubUnitName"].ToString()
                , MainClass.ToInt(TableName, myDataReader["BinNumber"])
                , myDataReader["CaseId"].ToString()
                , myDataReader["CaseName"].ToString()
                , myDataReader["CaseCart"].ToString()
                , MainClass.ToInt(TableName, myDataReader["NewLotSerial"])
                , myDataReader["OverRideText"].ToString()
                , myDataReader["OverRideReason"].ToString()
                , MainClass.ToDecimal(TableName, myDataReader["SellPrice"])
                , MainClass.ToInt(TableName, myDataReader["CDM"])
                , myDataReader["SessionID"].ToString()
                , myDataReader["OrderNum"].ToString()
                , MainClass.ToInt(TableName, myDataReader["FloorStock"])
                , myDataReader["CaseProcId"].ToString()
                , MainClass.ToInt(TableName, myDataReader["isGLCode"])
                , myDataReader["OriginalTakeStation"].ToString());
        }
Пример #14
0
        // delete record given its primary keys
        public static bool DeleteRecord(string UserName, string DeviceName, DateTime LoginTime)
        {
            bool   Retval       = true;
            string SqlStatement = string.Format("DELETE USER_EVENT WHERE UserName='******' AND DeviceName='{1}' AND LoginTime='{2}'",
                                                MainClass.FixStringForSingleQuote(UserName), MainClass.FixStringForSingleQuote(DeviceName), MainClass.DateTimeToTimestamp(LoginTime));

            Retval = MainClass.ExecuteSql(SqlStatement, true, TableName, "UserEvent", "DeleteRecord");
            return(Retval);
        }
Пример #15
0
        // make a TableData object from a SADataReader record
#if !NO_ASA
        static void MakeDataRec(SADataReader myDataReader, out TableData data)
        {
            data = new TableData(
                MainClass.ToInt(TableName, myDataReader["EventIid"])
                , myDataReader["EventName"].ToString());
        }
Пример #16
0
        // insert record given all TableData fields
        public static bool InsertRecord(TableData data)
        {
            bool   Retval       = false;
            string SqlStatement = "INSERT INTO LOT_SERIAL (ItemIid, DeviceIid, PktIid, LotNbr, SerialNbr, CreateTime, State, RefillId, Expiration, tagID, tagIDDisplay, tagState, tagLastTrx, tagLastTrxTime, tagResync, itemResync, TIMId, udi) VALUES ("
                                  + (int)data.ItemIid + ", " + (int)data.DeviceIid + ", " + (int)data.PktIid + ", " + "'"
                                  + MainClass.FixStringForSingleQuote(data.LotNbr) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.SerialNbr)
                                  + "'" + ", " + MainClass.DateTimeToTimestamp(data.CreateTime) + ", " + (int)data.State + ", " + "'"
                                  + MainClass.FixStringForSingleQuote(data.RefillId) + "'" + ", " + MainClass.DateTimeToTimestamp(data.Expiration) + ", "
                                  + data.TagId + ", " + "'" + MainClass.FixStringForSingleQuote(data.TagIdDisplay) + "'" + ", "
                                  + data.TagState + ", "
                                  + data.TagLastTrx + ", "
                                  + MainClass.DateTimeToTimestamp(data.TagLastTrxTime) + ", "
                                  + data.TagResync + ", "
                                  + data.ItemResync + ", "
                                  + "'" + MainClass.FixStringForSingleQuote(data.TIMId) + "', "
                                  + "'" + MainClass.FixStringForSingleQuote(data.UDI) + "'"
                                  + ")";

            Retval = MainClass.ExecuteSql(SqlStatement, true, TableName, "LotSerial", "InsertRecord");
            return(Retval);
        }
Пример #17
0
        // delete record given its primary keys
        public static bool DeleteRecord(string ItemId, DateTime EffectTime)
        {
            bool   Retval       = true;
            string SqlStatement = string.Format("DELETE ITEM_COST WHERE ItemId='{0}' AND EffectTime='{1}'",
                                                MainClass.FixStringForSingleQuote(ItemId), MainClass.DateTimeToTimestamp(EffectTime));

            Retval = MainClass.ExecuteSql(SqlStatement, true, TableName, "ItemCost", "DeleteRecord");
            return(Retval);
        }
Пример #18
0
        // insert record and return its primary key
        public static bool InsertRecord(TableData data, out int NewIid)
        {
            bool Retval = false;

            NewIid = -1;

            string SqlStatement = "INSERT INTO SN_POCKET (CabinetId, MicroId, Drawer, SubDrawer, PktDescriptor, PktState, PktNumber, ItemIid, PktPhysMaxQty, PktParQty, PktRefillPoint, PktCurQty, PktCritLow, ItemIsStandard, ItemIsChargeable, LastVend, LastRefill, LastStockOut, LastInventory, PocketUnitOfIssue, PocketUOIRatio, PktPosLo, PktPosHi, IncludeInDOP) VALUES ("
                                  + (int)data.CabinetId + ", " + (int)data.MicroId + ", " + (int)data.Drawer + ", " + (int)data.SubDrawer + ", " + "'" + MainClass.FixStringForSingleQuote(data.PktDescriptor) + "'" + ", " + (int)data.PktState + ", " + (int)data.PktNumber + ", " + (int)data.ItemIid + ", " + (int)data.PktPhysMaxQty + ", " + (int)data.PktParQty + ", " + (int)data.PktRefillPoint + ", " + (int)data.PktCurQty + ", " + (int)data.PktCritLow + ", " + (int)data.ItemIsStandard + ", " + (int)data.ItemIsChargeable + ", " + MainClass.DateTimeToTimestamp(data.LastVend) + ", " + MainClass.DateTimeToTimestamp(data.LastRefill) + ", " + MainClass.DateTimeToTimestamp(data.LastStockOut) + ", " + MainClass.DateTimeToTimestamp(data.LastInventory) + ", " + "'" + MainClass.FixStringForSingleQuote(data.PocketUnitOfIssue) + "'" + ", " + (int)data.PocketUOIRatio + ", " + (int)data.PktPosLo + ", " + (int)data.PktPosHi + ", " + (int)data.IncludeInDOP + ")";

            Retval = MainClass.ExecuteSql(SqlStatement, true, TableName, "SNPocket", "InsertRecord", out NewIid);
            return(Retval);
        }
Пример #19
0
        // insert record given all TableData fields
        public static bool InsertRecord(TableData data)
        {
            bool Retval = false;

            string SqlStatement = "INSERT INTO ITEM_COST (ItemId, EffectTime, CostPerIssue, CostPerUnitOrder) VALUES ("
                                  + "'" + MainClass.FixStringForSingleQuote(data.ItemId) + "'" + ", " + MainClass.DateTimeToTimestamp(data.EffectTime) + ", " + data.CostPerIssue + ", " + data.CostPerUnitOrder + ")";

            Retval = MainClass.ExecuteSql(SqlStatement, true, TableName, "ItemCost", "InsertRecord");
            return(Retval);
        }
Пример #20
0
 static void MakeEmailRec(SADataReader myDataReader, out EmailData data)
 {
     data = new EmailData(MainClass.ToInt(TableName, myDataReader["emailId"]),
                          myDataReader["Description"].ToString(),
                          myDataReader["emailAddress"].ToString());
 }
Пример #21
0
        public static int FindNotices(string message, DateTime timeframe)
        {
            int count = 0;

#if !NO_ASA
            SAConnection _conn;
            SADataReader myDataReader;
            string       SqlStatement = string.Format("SELECT * from ATTENTION WHERE attnMsg = '{0}' AND Message_time > {1}",
                                                      MainClass.FixStringForSingleQuote(message), MainClass.DateTimeToTimestamp(timeframe));

            if (MainClass.ExecuteSelect(SqlStatement, true, TableName, "Attention", "FindNotices", out _conn, out myDataReader))
            {
                try
                {
                    while (myDataReader.Read())
                    {
                        ++count;
                    }
                }
                catch (Exception ex)
                {
                    string err = String.Format(MainClass.StringTable.GetString("DatabaseError"), TableName, ex.Message.ToString() + "(" + SqlStatement + ")");
                    ServiceMessages.InsertRec(MainClass.AppName, TableName, "GetRecord", err);
                }
                finally
                {
                    if (myDataReader != null)
                    {
                        myDataReader.Close();
                    }
                    if (_conn != null)
                    {
                        _conn.Close();
                    }
                }
            }
#endif
            return(count);
        }
Пример #22
0
        // delete record given its primary keys
        public static bool DeleteRecord(string ImportFileName, DateTime ImportTime)
        {
            bool   Retval       = true;
            string SqlStatement = string.Format("DELETE D_S_IMPORT_REGISTRY WHERE ImportFileName='{0}' AND ImportTime='{1}'",
                                                MainClass.FixStringForSingleQuote(ImportFileName), MainClass.DateTimeToTimestamp(ImportTime));

            Retval = MainClass.ExecuteSql(SqlStatement, true, TableName, "DSImportRegistry", "DeleteRecord");
            return(Retval);
        }
Пример #23
0
        // return record given its primary keys
        public static bool GetRecord(int AttnIid, int AttnCategory, DateTime Message_time, out TableData data)
        {
            bool Retval = true;

            data = null;

#if !NO_ASA
            SAConnection _conn;
            SADataReader myDataReader;
            string       SqlStatement = string.Format("SELECT * from ATTENTION WHERE AttnIid='{0}' AND AttnCategory='{1}' AND Message_time='{2}'",
                                                      (int)AttnIid, (int)AttnCategory, MainClass.DateTimeToTimestamp(Message_time));
            if (MainClass.ExecuteSelect(SqlStatement, true, TableName, "Attention", "GetRecord", out _conn, out myDataReader))
            {
                try
                {
                    if (myDataReader.Read())
                    {
                        MakeDataRec(myDataReader, out data);
                    }
                }
                catch (Exception ex)
                {
                    Retval = false;
                    string err = String.Format(MainClass.StringTable.GetString("DatabaseError"), TableName, ex.Message.ToString() + "(" + SqlStatement + ")");
                    ServiceMessages.InsertRec(MainClass.AppName, TableName, "GetRecord", err);
                }
                finally
                {
                    if (myDataReader != null)
                    {
                        myDataReader.Close();
                    }
                    if (_conn != null)
                    {
                        _conn.Close();
                    }
                }
            }
#endif
            return(Retval);
        }
Пример #24
0
        // insert record given all TableData fields
        public static bool InsertRecord(TableData data)
        {
            bool Retval = false;

            string SqlStatement = "INSERT INTO D_S_IMPORT_REGISTRY (ImportFileName, ImportTime, ImportStatus, LastKeyLine, ImportHeader) VALUES ("
                                  + "'" + MainClass.FixStringForSingleQuote(data.ImportFileName) + "'" + ", " + MainClass.DateTimeToTimestamp(data.ImportTime) + ", " + "'" + MainClass.FixStringForSingleQuote(data.ImportStatus) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.LastKeyLine) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.ImportHeader) + "'" + ")";

            Retval = MainClass.ExecuteSql(SqlStatement, true, TableName, "DSImportRegistry", "InsertRecord");
            return(Retval);
        }
Пример #25
0
        // insert record and return its primary key
        public static bool InsertRecord(TableData data, out int NewIid)
        {
            bool Retval = false;

            NewIid = -1;

            string SqlStatement = "INSERT INTO ATTENTION (AttnCategory, Message_time, AttnAction, Source, AttnMsg, Printed, ProcessBox) VALUES ("
                                  + (int)data.AttnCategory + ", " + MainClass.DateTimeToTimestamp(data.Message_time) + ", " + (int)data.AttnAction + ", " + "'" + MainClass.FixStringForSingleQuote(data.Source) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.AttnMsg) + "'" + ", " + (int)data.Printed + ", " + "'" + MainClass.FixStringForSingleQuote(data.ProcessBox) + "'" + ")";

            Retval = MainClass.ExecuteSql(SqlStatement, true, TableName, "Attention", "InsertRecord", out NewIid);
            return(Retval);
        }
Пример #26
0
        // insert record and return its primary key
        public static bool InsertRecord(TableData data, out int NewIid)
        {
            bool Retval = false;

            NewIid = -1;

            string SqlStatement = "INSERT INTO ITEMS (ItemName, ItemShortDesc, ItemId, ItemAltId, ItemAltId2, ItemClass, ItemConsign, ItemStock, ItemTrackLot, ItemTrackSerial, ItemBillOnly, ItemType, ItemUnitOfIssue, ItemUnitOfRefill, ItemUnitOfOrder, ItemReOrderRatio, ItemRefillRatio, UOIPerUOO, UOIPerUOR, AutoResolveDiscrep, CostPerIssue, CostPerUnitRefill, CostPerUnitOrder, ItemIsChargeable, LeadTime, OrderCycle, SafetyDays, InclusionDays, tempItem, isPerishable) VALUES ("
                                  + "'" + MainClass.FixStringForSingleQuote(data.ItemName) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.ItemShortDesc) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.ItemId) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.ItemAltId) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.ItemAltId2) + "'" + ", " + (int)data.ItemClass + ", " + (int)data.ItemConsign + ", " + (int)data.ItemStock + ", " + (int)data.ItemTrackLot + ", " + (int)data.ItemTrackSerial + ", " + (int)data.ItemBillOnly + ", " + (int)data.ItemType + ", " + "'" + MainClass.FixStringForSingleQuote(data.ItemUnitOfIssue) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.ItemUnitOfRefill) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.ItemUnitOfOrder) + "'" + ", " + (int)data.ItemReOrderRatio + ", " + (int)data.ItemRefillRatio + ", " + (int)data.UOIPerUOO + ", " + (int)data.UOIPerUOR + ", " + (int)data.AutoResolveDiscrep + ", " + data.CostPerIssue + ", " + data.CostPerUnitRefill + ", " + data.CostPerUnitOrder + ", " + (int)data.ItemIsChargeable + ", " + (int)data.LeadTime + ", " + (int)data.OrderCycle + ", " + (int)data.SafetyDays + ", " + (int)data.InclusionDays + ", " + (int)data.TempItem + ", " + (int)data.IsPerishable + ")";

            Retval = MainClass.ExecuteSql(SqlStatement, true, TableName, "Items", "InsertRecord", out NewIid);
            return(Retval);
        }
Пример #27
0
        // insert record and return its primary key
        public static bool InsertRecord(TableData data, out int NewIid)
        {
            bool Retval = false;

            NewIid = -1;

            string SqlStatement = "INSERT INTO USER_EVENT (UserName, UserId, StockRightsMask, DeviceName, LoginTime, LogoutTime, DurationSec) VALUES ("
                                  + "'" + MainClass.FixStringForSingleQuote(data.UserName) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.UserId) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.StockRightsMask) + "'" + ", " + "'" + MainClass.FixStringForSingleQuote(data.DeviceName) + "'" + ", " + MainClass.DateTimeToTimestamp(data.LoginTime) + ", " + MainClass.DateTimeToTimestamp(data.LogoutTime) + ", " + (int)data.DurationSec + ")";

            Retval = MainClass.ExecuteSql(SqlStatement, true, TableName, "UserEvent", "InsertRecord", out NewIid);
            return(Retval);
        }
Пример #28
0
        // make a TableData object from a SADataReader record
#if !NO_ASA
        static void MakeDataRec(SADataReader myDataReader, out TableData data)
        {
            data = new TableData(
                MainClass.ToInt(TableName, myDataReader["CategoryIid"])
                , myDataReader["CategoryDesc"].ToString());
        }
Пример #29
0
        // make a TableData object from a SADataReader record
#if !NO_ASA
        static void MakeDataRec(SADataReader myDataReader, out TableData data)
        {
            SecureString secureSmtpPass = new SecureString();

            char[] smtpPass = myDataReader["SmtpPassword"].ToString().ToCharArray();
            foreach (char c in smtpPass)
            {
                secureSmtpPass.AppendChar(c);
            }
            Array.Clear(smtpPass, 0, smtpPass.Length);

            data = new TableData(
                MainClass.ToInt(TableName, myDataReader["SIid"])
                , myDataReader["SiteId"].ToString()
                , myDataReader["SiteName"].ToString()
                , myDataReader["Address1"].ToString()
                , myDataReader["Address2"].ToString()
                , myDataReader["City"].ToString()
                , myDataReader["State"].ToString()
                , myDataReader["ZipCode"].ToString()
                , myDataReader["Country"].ToString()
                , myDataReader["Contact"].ToString()
                , myDataReader["Phone"].ToString()
                , myDataReader["DiagLine"].ToString()
                , myDataReader["Fax"].ToString()
                , myDataReader["Description"].ToString()
                , myDataReader["Notes"].ToString()
                , myDataReader["FacilityCode"].ToString()
                , MainClass.ToInt(TableName, myDataReader["PreExpPw"])
                , myDataReader["ArchiveId"].ToString()
                , MainClass.ToInt(TableName, myDataReader["PwExpDelta"])
                , MainClass.ToInt(TableName, myDataReader["UserIdExpireDelta"])
                , MainClass.ToInt(TableName, myDataReader["TempUserExpDays"])
                , MainClass.ToInt(TableName, myDataReader["PwLen"])
                , myDataReader["PtIdFormat"].ToString()
                , MainClass.ToInt(TableName, myDataReader["ConLogOffTimeOut"])
                , MainClass.ToInt(TableName, myDataReader["RptSortByItemId"])
                , MainClass.ToInt(TableName, myDataReader["Voice"])
                , myDataReader["Version"].ToString()
                , MainClass.ToInt(TableName, myDataReader["ArchiveYearFormat"])
                , myDataReader["DbMachineName"].ToString()
                , MainClass.ToInt(TableName, myDataReader["PrintStockOut"])
                , MainClass.ToInt(TableName, myDataReader["PrintCriticalLow"])
                , MainClass.ToInt(TableName, myDataReader["PrintADTconflict"])
                , MainClass.ToInt(TableName, myDataReader["PrintIncomingDiscrep"])
                , MainClass.ToInt(TableName, myDataReader["PrintCommDown"])
                , MainClass.ToInt(TableName, myDataReader["PermitGlobalPatientList"])
                , myDataReader["HomeFax"].ToString()
                , myDataReader["HomeEmail"].ToString()
                , MainClass.ToInt(TableName, myDataReader["ClientServerSystem"])
                , MainClass.ToInt(TableName, myDataReader["ORFeatures"])
                , MainClass.ToInt(TableName, myDataReader["DodWarning"])
                , MainClass.ToBool(TableName, myDataReader["CopyReports"])
                , MainClass.ToBool(TableName, myDataReader["EmailReports"])
                , MainClass.ToInt(TableName, myDataReader["UserDoorAccessPerItem"])
                , MainClass.ToInt(TableName, myDataReader["TechDoorAccessPerItem"])
                , MainClass.ToInt(TableName, myDataReader["Ticci"])
                , MainClass.ToInt(TableName, myDataReader["PwEnableComplex"])
                , myDataReader["PwComplexRegex"].ToString()
                , myDataReader["PwComplexDesc"].ToString()
                , MainClass.ToInt(TableName, myDataReader["PwMaxLen"])
                , MainClass.ToInt(TableName, myDataReader["PwHistory"])
                , MainClass.ToInt(TableName, myDataReader["PwHistoryClamp"])
                , MainClass.ToInt(TableName, myDataReader["ORISInterface"])
                , myDataReader["SmtpHost"].ToString()
                , MainClass.ToInt(TableName, myDataReader["SmtpPort"])
                , MainClass.ToBool(TableName, myDataReader["SmtpUseSSL"])
                , myDataReader["SmtpUsername"].ToString()
                , secureSmtpPass
                , MainClass.ToBool(TableName, myDataReader["pwEnableExtended"])
                , MainClass.ToBool(TableName, myDataReader["upgrade"])
                , myDataReader["siteGUID"].ToString()
                , MainClass.ToInt(TableName, myDataReader["allowGLCodeTransactions"])
                , MainClass.ToInt(TableName, myDataReader["AllowORISTempToTempCaseTransfer"])
                , MainClass.ToInt(TableName, myDataReader["allowAssociator"])
                , MainClass.ToInt(TableName, myDataReader["allowAutoCaseToPatientXfer"])
                , MainClass.ToInt(TableName, myDataReader["holdRFIDTxForCase"])
                , MainClass.ToInt(TableName, myDataReader["activeDirectoryOnly"])
                , MainClass.ToInt(TableName, myDataReader["logVerbosity"])
                , myDataReader["logMsgFormat"].ToString()
                , myDataReader["logServerIP"].ToString()

                , myDataReader["logServerPort"].ToString()
                , MainClass.ToInt(TableName, myDataReader["logEnableRemote"])
                , MainClass.ToInt(TableName, myDataReader["PwMinAge"])
                , MainClass.ToInt(TableName, myDataReader["PwMinChg"])
                );
        }