// 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"]));
}
