public int InsertEMSPersonnelImmunizations()
{
//Insert Record into EMSPersonnelImmunizations table
int result = 0;
DbCommand oCmd = UpgradeHelpers.DB.AdoFactoryManager.GetFactory().CreateCommand();
ADORecordSetHelper oRec = null;
string SqlString = "";
try
{
result = -1;
oCmd.Connection = modGlobal.oConn;
oCmd.CommandType = CommandType.Text;
SqlString = "";
SqlString = "spInsert_EMSPersonnelImmunizations '" + cEMSEmployeeID + "', ";
SqlString = SqlString + cEMSImmunizeID.ToString() + ", ";
if (cEMSImmunizeDate == "")
{
SqlString = SqlString + "NULL, '";
}
else
{
SqlString = SqlString + "'" + cEMSImmunizeDate + "', '";
}
SqlString = SqlString + cEMSCreatedDate + "', '" + cEMSCreatedBy + "', ";
if (cEMSResultflag == "")
{
SqlString = SqlString + "NULL, ";
}
else
{
SqlString = SqlString + "'" + cEMSResultflag + "', ";
}
if (cEMSComments == "")
{
SqlString = SqlString + "NULL ";
}
else
{
SqlString = SqlString + "'" + cEMSComments + "' ";
}
oCmd.CommandText = SqlString;
oRec = ADORecordSetHelper.Open(oCmd, "");
//UPGRADE_WARNING: (2065) ADODB.Recordset method oRec.NextRecordset has a new behavior. More Information: http://www.vbtonet.com/ewis/ewi2065.aspx
oRec = oRec.NextRecordSet();
if (!oRec.EOF)
{
cEMSPerImmunizeID = Convert.ToInt32(oRec[0]);
}
}
catch
{
result = 0;
//UPGRADE_TODO: (1065) Error handling statement (Resume Next) could not be converted. More Information: http://www.vbtonet.com/ewis/ewi1065.aspx
UpgradeHelpers.Helpers.NotUpgradedHelper.NotifyNotUpgradedElement("Resume Next Statement");
}
return result;
}