// 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["DeviceIid"]) , MainClass.ToInt(TableName, myDataReader["BtnBoardNbr"]) , MainClass.ToInt(TableName, myDataReader["LatchBoardNbr"])); }
public JsonResult guardarPartido(string nomePartido) { SAConnection conn = new SAConnection("Data Source=eleicoes_conn"); try { conn.Open(); SACommand cmd = new SACommand("CALL guardarPartido(\"nomePartido\" = ?)", conn); cmd.CommandType = CommandType.Text; SAParameter param = cmd.CreateParameter(); param.SADbType = SADbType.Text; param.Direction = ParameterDirection.Input; param.Value = nomePartido; cmd.Parameters.Add(param); SADataReader reader = cmd.ExecuteReader(); reader.Close(); conn.Close(); return(Json(true)); } catch (SAException ex) { //Console.WriteLine(ex.Errors[0].Source + " : " + ex.Errors[0].Message + " (" + ex.Errors[0].NativeError.ToString() + ")", "Failed to connect"); conn.Close(); return(Json(false)); } }
// 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["SubUnitIid"]) , myDataReader["SubUnitName"].ToString() , MainClass.ToDate(TableName, myDataReader["Last_modified"])); }
public JsonResult listarCaderno() { SAConnection conn = new SAConnection("Data Source=eleicoes_conn"); try { conn.Open(); SACommand cmd = new SACommand("listarCaderno", conn); cmd.CommandType = CommandType.StoredProcedure; SADataReader reader = cmd.ExecuteReader(); List <cadernoEleitoral> cadernoEleitorals = new List <cadernoEleitoral>(); while (reader.Read()) { cadernoEleitorals.Add(new cadernoEleitoral { id = Int32.Parse(reader.GetString(0)), periodo = reader.GetString(1) }); } reader.Close(); conn.Close(); return(Json(cadernoEleitorals)); } catch (SAException ex) { conn.Close(); return(Json(false)); } }
public JsonResult mostrarListaPartidos() { SAConnection conn = new SAConnection("Data Source=eleicoes_conn"); try { conn.Open(); SACommand cmd = new SACommand("listarPartidos", conn); cmd.CommandType = CommandType.StoredProcedure; SADataReader reader = cmd.ExecuteReader(); List <Partido> listaPartidos = new List <Partido>(); while (reader.Read()) { listaPartidos.Add(new Partido { id = reader.GetInt32(0), nome = reader.GetString(1) }); } reader.Close(); conn.Close(); return(Json(listaPartidos)); } catch (SAException ex) { conn.Close(); return(Json(false)); } }
// Execute a SQL select statement using an existing DB connection internal static bool ExecuteSelect(SAConnection _conn, string SqlStatement, bool ErrMsg, string table, string CallingClass, string CallingFunction, out SADataReader myDataReader) { bool RetVal = true; myDataReader = null; try { SACommand cmd = new SACommand(SqlStatement, _conn); myDataReader = cmd.ExecuteReader(); } catch (Exception ex) { RetVal = false; if (ErrMsg) { string err = String.Format(StringTable.GetString("DatabaseError"), table, ex.Message.ToString() + "(" + SqlStatement + ")"); ServiceMessages.InsertRec(MainClass.AppName, CallingClass, CallingFunction, err); } } return(RetVal); }
static void MakeEmailDataRec(SADataReader myDataReader, out emailUserData data) { data = new emailUserData( myDataReader["name"].ToString(), myDataReader["address"].ToString(), MainClass.ToInt(TableName, myDataReader["emailId"])); }
// 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["PtIid"]) , MainClass.ToDate(TableName, myDataReader["AddedTime"])); }
// 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["PktSNIid"]) , MainClass.ToInt(TableName, myDataReader["CabinetId"]) , MainClass.ToInt(TableName, myDataReader["MicroId"]) , MainClass.ToInt(TableName, myDataReader["Drawer"]) , MainClass.ToInt(TableName, myDataReader["SubDrawer"]) , myDataReader["PktDescriptor"].ToString() , MainClass.ToInt(TableName, myDataReader["PktState"]) , MainClass.ToInt(TableName, myDataReader["PktNumber"]) , MainClass.ToInt(TableName, myDataReader["ItemIid"]) , MainClass.ToInt(TableName, myDataReader["PktPhysMaxQty"]) , MainClass.ToInt(TableName, myDataReader["PktParQty"]) , MainClass.ToInt(TableName, myDataReader["PktRefillPoint"]) , MainClass.ToInt(TableName, myDataReader["PktCurQty"]) , MainClass.ToInt(TableName, myDataReader["PktCritLow"]) , MainClass.ToInt(TableName, myDataReader["ItemIsStandard"]) , MainClass.ToInt(TableName, myDataReader["ItemIsChargeable"]) , MainClass.ToDate(TableName, myDataReader["LastVend"]) , MainClass.ToDate(TableName, myDataReader["LastRefill"]) , MainClass.ToDate(TableName, myDataReader["LastStockOut"]) , MainClass.ToDate(TableName, myDataReader["LastInventory"]) , myDataReader["PocketUnitOfIssue"].ToString() , MainClass.ToInt(TableName, myDataReader["PocketUOIRatio"]) , MainClass.ToInt(TableName, myDataReader["PktPosLo"]) , MainClass.ToInt(TableName, myDataReader["PktPosHi"]) , MainClass.ToInt(TableName, myDataReader["IncludeInDOP"])); }
// 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["ListIid"]) , myDataReader["Description"].ToString(), MainClass.ToInt(TableName, myDataReader["ListType"])); }
// 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.ToDate(TableName, myDataReader["EffectTime"]) , MainClass.ToInt(TableName, myDataReader["UserHistIid"]) , MainClass.ToInt(TableName, myDataReader["Action"]) , myDataReader["UserName"].ToString() , myDataReader["UserId"].ToString() , myDataReader["PassWord"].ToString() , MainClass.ToInt(TableName, myDataReader["AllAreas"]) , MainClass.ToDate(TableName, myDataReader["UserExpires"]) , MainClass.ToDate(TableName, myDataReader["PwExpired"]) , myDataReader["CardReaderId"].ToString() , myDataReader["SourceDev"].ToString() , myDataReader["CreatorId"].ToString() , myDataReader["CreatorName"].ToString() , MainClass.ToInt(TableName, myDataReader["StnPriv"]) , MainClass.ToInt(TableName, myDataReader["RxPriv"]) , myDataReader["AccessType"].ToString() , myDataReader["AdminRightsMask"].ToString() , myDataReader["StockRightsMask"].ToString() , MainClass.ToInt(TableName, myDataReader["HasBeenArchived"]) , MainClass.ToInt(TableName, myDataReader["TempUser"])); }
// 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["Lcid"]) , MainClass.ToInt(TableName, myDataReader["MsgNbr"]) , myDataReader["MsgText"].ToString()); }
// 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["ProcedureIid"]) , myDataReader["ProcedureName"].ToString() , myDataReader["ProcedureCode"].ToString()); }
// 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["ReasonIid"]) , myDataReader["ReasonId"].ToString() , myDataReader["ReasonText"].ToString()); }
// 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["UserName"].ToString() , myDataReader["UserId"].ToString() , MainClass.ToInt(TableName, myDataReader["UserType"]) , myDataReader["DeviceName"].ToString() , MainClass.ToInt(TableName, myDataReader["DeviceType"]) , MainClass.ToInt(TableName, myDataReader["ProcedureStation"]) , MainClass.ToInt(TableName, myDataReader["ActivityType"]) , myDataReader["AreaName"].ToString() , MainClass.ToDate(TableName, myDataReader["LoginTime"]) , MainClass.ToDate(TableName, myDataReader["LogoutTime"]) , MainClass.ToInt(TableName, myDataReader["DiscrepancyCount"]) , MainClass.ToInt(TableName, myDataReader["OutsideExpectedUsage"]) , MainClass.ToInt(TableName, myDataReader["DisruptSec"]) , MainClass.ToInt(TableName, myDataReader["DoorNumber"]) , MainClass.ToInt(TableName, myDataReader["IsDoorOpenedStartState"]) , MainClass.ToDate(TableName, myDataReader["DoorOpenedTime"]) , MainClass.ToInt(TableName, myDataReader["DoorDurationSec"]) , MainClass.ToInt(TableName, myDataReader["IsDoorClosedEndState"]) , MainClass.ToDate(TableName, myDataReader["DoorClosedTime"]) , MainClass.ToInt(TableName, myDataReader["DoorTransactionCount"]) , MainClass.ToInt(TableName, myDataReader["DoorComplianceType"]) , myDataReader["SessionID"].ToString() , MainClass.ToInt(TableName, myDataReader["SessionContext"]) , MainClass.ToInt(TableName, myDataReader["AnchorPage"])); }
// 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["MpIid"]) , MainClass.ToDate(TableName, myDataReader["MergeDateTime"]) , myDataReader["PermPtLastName"].ToString() , myDataReader["PermPtFirstName"].ToString() , myDataReader["PermPtMiddleName"].ToString() , myDataReader["PermPtId"].ToString() , myDataReader["PermPtAltId1"].ToString() , myDataReader["PermPtAltId2"].ToString() , myDataReader["PermRoom"].ToString() , myDataReader["PermBed"].ToString() , MainClass.ToDate(TableName, myDataReader["PermFirstPtActivityTime"]) , MainClass.ToDate(TableName, myDataReader["PermAdmitTime"]) , myDataReader["PermSourceDevName"].ToString() , MainClass.ToInt(TableName, myDataReader["PermNurseUnitIid"]) , myDataReader["TempPtLastName"].ToString() , myDataReader["TempPtFirstName"].ToString() , myDataReader["TempPtMiddleName"].ToString() , myDataReader["TempPtId"].ToString() , myDataReader["TempPtAltId1"].ToString() , myDataReader["TempPtAltId2"].ToString() , myDataReader["TempRoom"].ToString() , myDataReader["TempBed"].ToString() , MainClass.ToDate(TableName, myDataReader["TempFirstPtActivityTime"]) , MainClass.ToDate(TableName, myDataReader["TempLastPtActivityTime"]) , MainClass.ToDate(TableName, myDataReader["TempAdmitTime"]) , myDataReader["TempSourceDevName"].ToString() , MainClass.ToInt(TableName, myDataReader["TempNurseUnitIid"]) , myDataReader["MergeUserId"].ToString() , myDataReader["MergeUserName"].ToString() , myDataReader["FacilityCode"].ToString()); }
// make a TableData object from a SADataReader record #if !NO_ASA static void MakeDataRec(SADataReader myDataReader, out TableData data) { data = new TableData( myDataReader["ParLocationName"].ToString() , myDataReader["StorageUnitName"].ToString() , myDataReader["SubUnitName"].ToString() , MainClass.ToInt(TableName, myDataReader["BinNumber"]) , MainClass.ToDate(TableName, myDataReader["DayOfMonth"]) , MainClass.ToInt(TableName, myDataReader["PktIid"]) , MainClass.ToInt(TableName, myDataReader["PktParQty"]) , MainClass.ToInt(TableName, myDataReader["PktRefillPoint"]) , MainClass.ToInt(TableName, myDataReader["PktCritLow"]) , MainClass.ToInt(TableName, myDataReader["PktCurQty"]) , myDataReader["ItemId"].ToString() , myDataReader["ItemName"].ToString() , myDataReader["ItemAltId"].ToString() , myDataReader["ItemAltId2"].ToString() , MainClass.ToInt(TableName, myDataReader["UOIperUOR"]) , MainClass.ToInt(TableName, myDataReader["UOIperUOO"]) , MainClass.ToInt(TableName, myDataReader["NetUseQty"]) , MainClass.ToDate(TableName, myDataReader["LoadDate"]) , MainClass.ToInt(TableName, myDataReader["CritLowCounter"]) , MainClass.ToInt(TableName, myDataReader["RefillCounter"]) , MainClass.ToInt(TableName, myDataReader["RefillTotalQty"]) , MainClass.ToInt(TableName, myDataReader["InventoryCounter"]) , MainClass.ToInt(TableName, myDataReader["AddedToMonthly"]) , MainClass.ToInt(TableName, myDataReader["StockOutCounter"]) , MainClass.ToInt(TableName, myDataReader["StillLoaded"])); }
// 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["DefaultStorageIid"]) , myDataReader["DefaultStorageName"].ToString() , MainClass.ToInt(TableName, myDataReader["StorageTable"])); }
// 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"]) , myDataReader["UserName"].ToString() , myDataReader["UserId"].ToString() , myDataReader["PassWord"].ToString() , MainClass.ToInt(TableName, myDataReader["AllAreas"]) , MainClass.ToDate(TableName, myDataReader["UserExpires"]) , MainClass.ToDate(TableName, myDataReader["PwExpired"]) , MainClass.ToDate(TableName, myDataReader["LastUserActTime"]) , myDataReader["CardReaderId"].ToString() , myDataReader["UserDescription"].ToString() , myDataReader["SourceDevName"].ToString() , myDataReader["CreatorId"].ToString() , myDataReader["CreatorName"].ToString() , myDataReader["UserCredentials"].ToString() , MainClass.ToInt(TableName, myDataReader["AccessTypeIid"]) , MainClass.ToInt(TableName, myDataReader["TempUser"]) , myDataReader["AdminRightsMask"].ToString() , myDataReader["StockRightsMask"].ToString() , MainClass.ToInt(TableName, myDataReader["TemplateUser"]) , MainClass.ToInt(TableName, myDataReader["StnPriv"]) , MainClass.ToInt(TableName, myDataReader["RxPriv"]) , MainClass.ToInt(TableName, myDataReader["NoBioID"]) , MainClass.ToInt(TableName, myDataReader["Owner"]) , MainClass.ToDate(TableName, myDataReader["Last_modified"]) , MainClass.ToInt(TableName, myDataReader["EmailId"]) , myDataReader["PasswordSalt"].ToString() , MainClass.ToInt(TableName, myDataReader["DomainIid"]) , myDataReader["DomainUserName"].ToString() , myDataReader["EncryptedBlock"].ToString() , MainClass.ToInt(TableName, myDataReader["ActiveDirectory"])); }
// 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["CabinetId"]) , myDataReader["CabinetName"].ToString() , MainClass.ToInt(TableName, myDataReader["PylonIid"])); }
public ActionResult electionMain() { if (Session["UserID"] != null) { SAConnection conn = new SAConnection("Data Source=eleicoes_conn"); conn.Open(); SACommand cmd = new SACommand("listarCandidatos", conn); cmd.CommandType = CommandType.StoredProcedure; SADataReader reader = cmd.ExecuteReader(); List <Candidato> listaCandidatos = new List <Candidato>(); while (reader.Read()) { listaCandidatos.Add(new Candidato { id = reader.GetInt32(0), nomeCandidato = reader.GetString(1), nomePartido = reader.GetString(2) }); } reader.Close(); conn.Close(); ViewBag.listaCandidatos = listaCandidatos; return(View()); } else { return(RedirectToAction("Login")); } }
// make a TableData object from a SADataReader record #if !NO_ASA static void MakeDataRec(SADataReader myDataReader, out TableData data) { data = new TableData( myDataReader["ConsoleName"].ToString() , MainClass.ToInt(TableName, myDataReader["LogComm"]) , MainClass.ToInt(TableName, myDataReader["LogTaskSched"]) , MainClass.ToInt(TableName, myDataReader["PtDischInactiveDays"]) , MainClass.ToInt(TableName, myDataReader["PtNotDischInactiveDays"]) , MainClass.ToInt(TableName, myDataReader["DiscrepKeepDays"]) , MainClass.ToInt(TableName, myDataReader["TrxKeepDays"]) , MainClass.ToInt(TableName, myDataReader["UserHistKeepDays"]) , MainClass.ToInt(TableName, myDataReader["PtHistKeepDays"]) , MainClass.ToInt(TableName, myDataReader["SvcMsgKeepDays"]) , MainClass.ToInt(TableName, myDataReader["RefillTblKeepHours"]) , MainClass.ToInt(TableName, myDataReader["itemHistKeepDays"]) , myDataReader["DbServerName"].ToString() , myDataReader["ConsoleToken0"].ToString() , myDataReader["SoftwareVersion"].ToString() , MainClass.ToInt(TableName, myDataReader["ParsePatientName"]) , MainClass.ToInt(TableName, myDataReader["StnMaxTrxKeepDays"]) , MainClass.ToInt(TableName, myDataReader["MaxItemAliases"]) , MainClass.ToInt(TableName, myDataReader["SummaryTblKeepDays"]) , MainClass.ToInt(TableName, myDataReader["TimeBias"]) , myDataReader["MyDeviceName"].ToString() , MainClass.ToInt(TableName, myDataReader["ArchiveKeepDays"]) , MainClass.ToInt(TableName, myDataReader["HandheldNonCommHours"]) , MainClass.ToInt(TableName, myDataReader["CaseKeepDays"]) , MainClass.ToInt(TableName, myDataReader["SavedReportKeepDays"]) , MainClass.ToBool(TableName, myDataReader["LogService"]) , MainClass.ToInt(TableName, myDataReader["MaxPVSClients"]) , MainClass.ToInt(TableName, myDataReader["TempTransactionKeepDays"]) , MainClass.ToInt(TableName, myDataReader["MyCaseListKeepDays"])); }
public bool inserirCandidatoEleicao(int idEleicao, int idCandidato) { SAConnection conn = new SAConnection("Data Source=eleicoes_conn"); try { conn.Open(); SACommand cmd = new SACommand("CALL inserirCandidatoEleicao(\"idCandidato\" = ?, \"idEleicao\"= ? )", conn); cmd.CommandType = CommandType.Text; SAParameter param1 = cmd.CreateParameter(); param1.SADbType = SADbType.Integer; param1.Direction = ParameterDirection.Input; param1.Value = idCandidato; cmd.Parameters.Add(param1); SAParameter param2 = cmd.CreateParameter(); param2.SADbType = SADbType.Integer; param2.Direction = ParameterDirection.Input; param2.Value = idEleicao; cmd.Parameters.Add(param2); SADataReader reader = cmd.ExecuteReader(); return(true); } catch (Exception ex) { conn.Close(); return(false); } }
// 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["ListIid"]), MainClass.ToInt(TableName, myDataReader["emailId"]), MainClass.ToInt(TableName, myDataReader["emailType"])); }
public JsonResult apagarEleicao(int idEleicao) { // CALL "dev"."listarEleitores"("idCaderno" = 4) SAConnection conn = new SAConnection("Data Source=eleicoes_conn"); try { conn.Open(); SACommand cmd = new SACommand("CALL apagarEleicao(\"idEleicao\" = ?)", conn); cmd.CommandType = CommandType.Text; SAParameter param = cmd.CreateParameter(); param.SADbType = SADbType.Integer; param.Direction = ParameterDirection.Input; param.Value = idEleicao; cmd.Parameters.Add(param); SADataReader reader = cmd.ExecuteReader(); reader.Close(); conn.Close(); return(Json(true)); } catch (SAException ex) { conn.Close(); //Console.WriteLine(ex.Errors[0].Source + " : " + ex.Errors[0].Message + " (" + ex.Errors[0].NativeError.ToString() + ")", "Failed to connect"); return(Json(false)); } }
// make a TableData object from a SADataReader record #if !NO_ASA static void MakeDataRec(SADataReader myDataReader, out TableData data) { data = new TableData( myDataReader["MedID"].ToString() , myDataReader["Scancode"].ToString() , MainClass.ToDate(TableName, myDataReader["Last_modified"])); }
// 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["PtIid"]) , MainClass.ToDate(TableName, myDataReader["EffectTime"]) , MainClass.ToInt(TableName, myDataReader["PtHistIid"]) , MainClass.ToInt(TableName, myDataReader["Action"]) , myDataReader["PtLastName"].ToString() , myDataReader["PtFirstName"].ToString() , myDataReader["PtMiddleName"].ToString() , myDataReader["PtId"].ToString() , myDataReader["PtMergeId"].ToString() , myDataReader["PtAltId1"].ToString() , myDataReader["PtAltId2"].ToString() , myDataReader["Room"].ToString() , myDataReader["Bed"].ToString() , MainClass.ToInt(TableName, myDataReader["PtType"]) , MainClass.ToInt(TableName, myDataReader["TempPatient"]) , MainClass.ToDate(TableName, myDataReader["FirstPtActivityTime"]) , MainClass.ToDate(TableName, myDataReader["LastPtActivityTime"]) , MainClass.ToDate(TableName, myDataReader["AdmitTime"]) , MainClass.ToDate(TableName, myDataReader["PtAutoDischargeDate"]) , MainClass.ToDate(TableName, myDataReader["PtDischargeDate"]) , myDataReader["AdmitDrName"].ToString() , myDataReader["AttendDrName"].ToString() , myDataReader["SourceDev"].ToString() , myDataReader["CreatorId"].ToString() , myDataReader["CreatorName"].ToString() , myDataReader["NUnitName"].ToString() , myDataReader["FacilityCode"].ToString() , MainClass.ToInt(TableName, myDataReader["Private"]) , MainClass.ToInt(TableName, myDataReader["HasBeenArchived"])); }
// 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["PktIid"]) , MainClass.ToInt(TableName, myDataReader["DeviceIid"]) , MainClass.ToInt(TableName, myDataReader["BtnBoardNbr"]) , MainClass.ToInt(TableName, myDataReader["BtnDoorNbr"]) , MainClass.ToInt(TableName, myDataReader["BtnBoardSeq"]) , MainClass.ToInt(TableName, myDataReader["SubDrawer"]) , myDataReader["PktDescriptor"].ToString() , MainClass.ToInt(TableName, myDataReader["PktState"]) , MainClass.ToInt(TableName, myDataReader["BtnPocketNbr"]) , MainClass.ToInt(TableName, myDataReader["ItemIid"]) , MainClass.ToInt(TableName, myDataReader["PktPhysMaxQty"]) , MainClass.ToInt(TableName, myDataReader["PktParQty"]) , MainClass.ToInt(TableName, myDataReader["PktRefillPoint"]) , MainClass.ToInt(TableName, myDataReader["PktCurQty"]) , MainClass.ToInt(TableName, myDataReader["PktCritLow"]) , MainClass.ToInt(TableName, myDataReader["ItemIsStandard"]) , MainClass.ToInt(TableName, myDataReader["ItemIsChargeable"]) , MainClass.ToInt(TableName, myDataReader["ItemIsPerishable"]) , MainClass.ToDate(TableName, myDataReader["NextExpireTime"]) , MainClass.ToDate(TableName, myDataReader["LastVend"]) , MainClass.ToDate(TableName, myDataReader["LastRefill"]) , MainClass.ToDate(TableName, myDataReader["LastStockOut"]) , MainClass.ToDate(TableName, myDataReader["LastInventory"]) , MainClass.ToInt(TableName, myDataReader["DefaultVendUOM"]) , MainClass.ToInt(TableName, myDataReader["DefaultRefillUOM"]) , MainClass.ToInt(TableName, myDataReader["IncludeInDOP"]) , myDataReader["PocketUnitOfIssue"].ToString() , MainClass.ToInt(TableName, myDataReader["PocketUOIRatio"]) , MainClass.ToInt(TableName, myDataReader["Shared"]) , MainClass.ToInt(TableName, myDataReader["CycleCountType"]) , MainClass.ToInt(TableName, myDataReader["ToBeCycleCounted"])); }
// 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["UserPrefId"]) , MainClass.ToInt(TableName, myDataReader["UserPrefValue"])); }
// make a TableData object from a SADataReader record #if !NO_ASA static void MakeDataRec(SADataReader myDataReader, out TableData data) { data = new TableData( myDataReader["DeviceName"].ToString() , MainClass.ToDate(TableName, myDataReader["PurgeDate"]) , MainClass.ToInt(TableName, myDataReader["SystemType"])); }