// 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());
}
// 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);
}
// 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);
}
// 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"]));
}
// 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);
}
// 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);
}
// 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);
}
// 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);
}
// 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);
}
// 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);
}
// 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);
}
// 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);
}
// 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());
}
// 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);
}
// 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());
}
// 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);
}
// 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);
}
// 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);
}
// 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);
}
static void MakeEmailRec(SADataReader myDataReader, out EmailData data)
{
data = new EmailData(MainClass.ToInt(TableName, myDataReader["emailId"]),
myDataReader["Description"].ToString(),
myDataReader["emailAddress"].ToString());
}
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);
}
// 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);
}
// 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);
}
// 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);
}
// 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);
}
// 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);
}
// 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);
}
// 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());
}
// 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"])
);
}
