public static void Main(System.String[] args)
{
try
{
System.Data.OleDb.OleDbConnection conn = NormativeDatabase.Instance.Connection;
System.Data.OleDb.OleDbCommand stmt = SupportClass.TransactionManager.manager.CreateStatement(conn);
System.Data.OleDb.OleDbCommand temp_OleDbCommand;
temp_OleDbCommand = stmt;
temp_OleDbCommand.CommandText = "select * from TableValues";
System.Data.OleDb.OleDbDataReader rs = temp_OleDbCommand.ExecuteReader();
while (rs.Read())
{
System.Object tabNum = rs.GetValue(1 - 1);
System.Object val = rs.GetValue(3 - 1);
System.Object desc = rs.GetValue(4 - 1);
System.Console.Out.WriteLine("Table: " + tabNum + " Value: " + val + " Description: " + desc);
}
}
catch (System.Data.OleDb.OleDbException e)
{
log.Error("test msg!!", e);
}
catch (System.Exception e)
{
log.Error("test msg!!", e);
}
}
/*
* selectAccount selects the account from the database using the current object accountnumber
*/
public void selectAccount()
{
String query = "SELECT * FROM Accounts WHERE AcctNo = '" + AccountNumber + "'";
dr = db.SelectCommand(query);
dr.Read();
accountNumber = AccountNumber;
CustomerID = (dr.GetValue(1) + "");
Type = (dr.GetValue(2) + "");
Balance = (Double.Parse(dr.GetValue(3) + ""));
db.DBClose();
}
/*
* uses the db object to query the db and select the customer info based on customerid
*/
public void selectCustomer()
{
String query = "SELECT * FROM Customers WHERE CustID = '" + CustomerID + "'";
dr = db.SelectCommand(query);
dr.Read();
customerID = CustomerID;
Password = (dr.GetValue(1) + "");
FirstName = (dr.GetValue(2) + "");
LastName = (dr.GetValue(3) + "");
Address = (dr.GetValue(4) + "");
Email = (dr.GetValue(5) + "");
db.DBClose();
}
public static string FetchGivenNamefromExcel(string TestName)
{
DirectoryInfo currentDir = new DirectoryInfo(Directory.GetCurrentDirectory());
path = Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().Location).Replace("\\bin\\Debug", "") + "\\Input Files\\TestData.xlsx";
System.Data.OleDb.OleDbConnection MyConnection;
string sqlTest = null;
MyConnection = new System.Data.OleDb.OleDbConnection("provider=Microsoft.ACE.OLEDB.12.0;Data Source='" + path + "'; Extended Properties='Excel 12.0; HDR = YES'");
MyConnection.Open();
sqlTest = "select * from [" + ObjectRepository.ProjectName + "$] where TestCasesName =\"" + TestName + "\"";
System.Data.OleDb.OleDbCommand TestCommand = new System.Data.OleDb.OleDbCommand(sqlTest, MyConnection);
System.Data.OleDb.OleDbDataReader TestReader = TestCommand.ExecuteReader();
GetGivenName = new Dictionary <int, string>();
while (TestReader.Read())
{
int i = 1;
for (int Row = 1; Row < TestReader.FieldCount; Row++)
{
GetGivenName.Add(i, TestReader.GetValue(Row).ToString().Trim());
i++;
}
}
TestReader.Close();
return(GetGivenName[2].ToString());
}
/*
* findAccounts creates a arraylist of all accounts connected to the current customer id
*/
public void findAccounts()
{
String query = "SELECT * FROM Accounts WHERE Cid = '" + CustomerID + "'";
Account tempAccount;
acctList.emptylist();
dr = db.SelectCommand(query);
while (dr.Read())
{
tempAccount = new Account();
tempAccount.AccountNumber = dr.GetValue(0) + "";
tempAccount.CustomerID = dr.GetValue(1) + "";
tempAccount.Type = dr.GetValue(2) + "";
tempAccount.Balance = Double.Parse(dr.GetValue(3) + "");
acctList.addAccount(tempAccount);
}
db.DBClose();
}
//METHODS()
public void SelectDB(string acctNo)
{
DBSetup(); //objects created & connection established
cmd = "SELECT * FROM Accounts WHERE AcctNo = " + "\"" + acctNo + "\""; //String of SQL command
//cmd = "SELECT * FROM Accounts WHERE Cid = " + "\"" + acctNo + "\""; //String of SQL command
OleDbDataAdapter2.SelectCommand.CommandText = cmd; //The CommandText gets the cmd string
OleDbDataAdapter2.SelectCommand.Connection = OleDbConnection2; //Connection established
Console.WriteLine(cmd); //Write the cmd string to the Console
try
{
OleDbConnection2.Open(); //Open the connection
System.Data.OleDb.OleDbDataReader dr = OleDbDataAdapter2.SelectCommand.ExecuteReader(); //Assigns "dr" to read the Customers table
dr.Read();
//Setting all the data retrieved from the table to the C# classes
acctNum = acctNo; //Value (0) to get acctNo, the primary key for this table
c.setCustID(dr.GetValue(1) + "");
setType(dr.GetValue(2) + "");
setBalance(Double.Parse(dr.GetValue(3) + ""));
}
catch (Exception ex) { Console.WriteLine(ex); } //If an exception is thrown, it goes to the console
finally { OleDbConnection2.Close(); } //Closes the connection after everything is done
} //end of SELECT
public static void Main(System.String[] args)
{
try
{
//UPGRADE_TODO: The differences in the format of parameters for method 'java.lang.Class.forName' may cause compilation errors. "ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?index='!DefaultContextWindowIndex'&keyword='jlca1092'"
System.Type.GetType("sun.jdbc.odbc.JdbcOdbcDriver");
//UPGRADE_ISSUE: Method 'java.lang.System.setProperty' was not converted. "ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?index='!DefaultContextWindowIndex'&keyword='jlca1000_javalangSystem'"
//System_Renamed.setProperty("ca.on.uhn.hl7.database.url", "jdbc:odbc:hl7v25");
// Above line not supported...
//UPGRADE_NOTE: There are other database providers or managers under System.Data namespace which can be used optionally to better fit the application requirements. "ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?index='!DefaultContextWindowIndex'&keyword='jlca1208'"
System.Data.OleDb.OleDbConnection conn = NormativeDatabase.Instance.Connection;
//UPGRADE_TODO: Method 'java.sql.Connection.createStatement' was converted to 'SupportClass.TransactionManager.manager.CreateStatement' which has a different behavior. "ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?index='!DefaultContextWindowIndex'&keyword='jlca1073_javasqlConnectioncreateStatement'"
System.Data.OleDb.OleDbCommand stmt = SupportClass.TransactionManager.manager.CreateStatement(conn);
//UPGRADE_TODO: Interface 'java.sql.ResultSet' was converted to 'System.Data.OleDb.OleDbDataReader' which has a different behavior. "ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?index='!DefaultContextWindowIndex'&keyword='jlca1073_javasqlResultSet'"
System.Data.OleDb.OleDbCommand temp_OleDbCommand;
temp_OleDbCommand = stmt;
temp_OleDbCommand.CommandText = "select * from TableValues";
System.Data.OleDb.OleDbDataReader rs = temp_OleDbCommand.ExecuteReader();
while (rs.Read())
{
System.Object tabNum = rs.GetValue(1 - 1);
System.Object val = rs.GetValue(3 - 1);
System.Object desc = rs.GetValue(4 - 1);
//UPGRADE_TODO: The equivalent in .NET for method 'java.lang.Object.toString' may return a different value. "ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?index='!DefaultContextWindowIndex'&keyword='jlca1043'"
System.Console.Out.WriteLine("Table: " + tabNum + " Value: " + val + " Description: " + desc);
}
}
catch (System.Data.OleDb.OleDbException e)
{
log.error("test msg!!", e);
}
//UPGRADE_NOTE: Exception 'java.lang.ClassNotFoundException' was converted to 'System.Exception' which has different behavior. "ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?index='!DefaultContextWindowIndex'&keyword='jlca1100'"
catch (System.Exception e)
{
log.error("test msg!!", e);
}
}
//METHODS()
public void SelectDB(string id)
{
DBSetup(); //objects created & connection established
cmd = "SELECT * FROM Customers WHERE CustID = " + "\"" + id + "\""; //String of SQL command
OleDbDataAdapter2.SelectCommand.CommandText = cmd; //The CommandText gets the cmd string
OleDbDataAdapter2.SelectCommand.Connection = OleDbConnection2; //Connection established
Console.WriteLine(cmd); //Write the cmd string to the Console
try
{
OleDbConnection2.Open(); //Open the connection
System.Data.OleDb.OleDbDataReader dr = OleDbDataAdapter2.SelectCommand.ExecuteReader(); //Assigns "dr" to read the Customers table
dr.Read();
//Setting all the data retrieved from the table to the C# classes
cid = id; //Value (0) to get CustID
setPassword(dr.GetValue(1) + "");
setFname(dr.GetValue(2) + "");
setLname(dr.GetValue(3) + "");
addr.setState(dr.GetValue(4) + "");
setEmail(dr.GetValue(5) + "");
}
catch (Exception ex) { Console.WriteLine(ex); } //If an exception is thrown, it goes to the console
finally { OleDbConnection2.Close(); } //Closes the connection after everything is done
} //end of SELECT
/// <summary> Returns the Java source code for a class that represents the specified segment.</summary>
public static System.String makeSegment(System.String name, System.String version)
{
Console.WriteLine("Making segment " + name);
System.Text.StringBuilder source = new System.Text.StringBuilder();
try
{
//UPGRADE_NOTE: There are other database providers or managers under System.Data namespace which can be used optionally to better fit the application requirements. "ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?index='!DefaultContextWindowIndex'&keyword='jlca1208'"
System.Collections.ArrayList elements = new System.Collections.ArrayList();
SegmentElement se;
System.String segDesc = null;
using (System.Data.OleDb.OleDbConnection conn = NormativeDatabase.Instance.Connection)
{
System.Text.StringBuilder sql = new System.Text.StringBuilder();
sql.Append("SELECT HL7SegmentDataElements.seg_code, HL7SegmentDataElements.seq_no, ");
sql.Append("HL7SegmentDataElements.repetitional, HL7SegmentDataElements.repetitions, ");
sql.Append("HL7DataElements.description, HL7DataElements.length, HL7DataElements.table_id, ");
sql.Append("HL7SegmentDataElements.req_opt, HL7Segments.description, HL7DataElements.data_structure ");
sql.Append("FROM HL7Versions RIGHT JOIN (HL7Segments INNER JOIN (HL7DataElements INNER JOIN HL7SegmentDataElements ");
sql.Append("ON (HL7DataElements.version_id = HL7SegmentDataElements.version_id) ");
sql.Append("AND (HL7DataElements.data_item = HL7SegmentDataElements.data_item)) ");
sql.Append("ON (HL7Segments.version_id = HL7SegmentDataElements.version_id) ");
sql.Append("AND (HL7Segments.seg_code = HL7SegmentDataElements.seg_code)) ");
sql.Append("ON (HL7Versions.version_id = HL7Segments.version_id) ");
sql.Append("WHERE HL7SegmentDataElements.seg_code = '");
sql.Append(name);
sql.Append("' and HL7Versions.hl7_version = '");
sql.Append(version);
sql.Append("' ORDER BY HL7SegmentDataElements.seg_code, HL7SegmentDataElements.seq_no;");
//System.out.println(sql.toString()); //for debugging
//UPGRADE_TODO: Method 'java.sql.Connection.createStatement' was converted to 'SupportClass.TransactionManager.manager.CreateStatement' which has a different behavior. "ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?index='!DefaultContextWindowIndex'&keyword='jlca1073_javasqlConnectioncreateStatement'"
System.Data.OleDb.OleDbCommand stmt = SupportClass.TransactionManager.manager.CreateStatement(conn);
//UPGRADE_TODO: Interface 'java.sql.ResultSet' was converted to 'System.Data.OleDb.OleDbDataReader' which has a different behavior. "ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?index='!DefaultContextWindowIndex'&keyword='jlca1073_javasqlResultSet'"
System.Data.OleDb.OleDbCommand temp_OleDbCommand;
temp_OleDbCommand = stmt;
temp_OleDbCommand.CommandText = sql.ToString();
System.Data.OleDb.OleDbDataReader rs = temp_OleDbCommand.ExecuteReader();
while (rs.Read())
{
if (segDesc == null)
{
segDesc = System.Convert.ToString(rs[9 - 1]);
}
se = new SegmentElement();
se.field = Convert.ToInt32(rs.GetValue(2 - 1));
se.rep = System.Convert.ToString(rs[3 - 1]);
if (rs.IsDBNull(4 - 1))
{
se.repetitions = 0;
}
else
{
se.repetitions = Convert.ToInt32(rs.GetValue(4 - 1));
}
if (se.repetitions == 0)
{
if (se.rep == null || !se.rep.ToUpper().Equals("Y".ToUpper()))
{
se.repetitions = 1;
}
}
se.desc = System.Convert.ToString(rs[5 - 1]);
if (!rs.IsDBNull(6 - 1))
{
se.length = Convert.ToInt32(rs.GetValue(6 - 1));
}
se.table = Convert.ToInt32(rs.GetValue(7 - 1));
se.opt = System.Convert.ToString(rs[8 - 1]);
se.type = System.Convert.ToString(rs[10 - 1]);
//shorten CE_x to CE
if (se.type.StartsWith("CE"))
{
se.type = "CE";
}
elements.Add(se);
/*System.out.println("Segment: " + name + " Field: " + se.field + " Rep: " + se.rep +
* " Repetitions: " + se.repetitions + " Desc: " + se.desc + " Length: " + se.length +
* " Table: " + se.table + " Segment Desc: " + segDesc);*/
}
rs.Close();
//UPGRADE_ISSUE: Method 'java.sql.Statement.close' was not converted. "ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?index='!DefaultContextWindowIndex'&keyword='jlca1000_javasqlStatementclose'"
stmt.Dispose();
NormativeDatabase.Instance.returnConnection(conn);
}
//write imports, class documentation, etc ...
source.Append("using System;\r\n");
source.Append("using ca.uhn.hl7v2.model;\r\n");
source.Append("using ");
source.Append(SourceGenerator.getVersionPackageName(version));
source.Append("datatype;\r\n\r\n");
source.Append("using ca.uhn.log;\r\n");
source.Append("using ca.uhn.hl7v2.parser;\r\n");
source.Append("using ca.uhn.hl7v2;\r\n\r\n");
source.Append("namespace ");
source.Append(SourceGenerator.getVersionPackageName(version));
source.Append("segment{\r\n\r\n");
source.Append("/**\r\n");
source.Append(" * <p>Represents an HL7 ");
source.Append(name);
source.Append(" message segment. \r\n");
source.Append(" * This segment has the following fields:</p><p>\r\n");
for (int i = 0; i < elements.Count; i++)
{
se = (SegmentElement)elements[i];
source.Append(" * ");
source.Append(name);
source.Append("-");
source.Append(se.field);
source.Append(": ");
source.Append(se.desc);
source.Append(" (");
source.Append(se.type);
source.Append(")<br> \r\n");
}
source.Append(" * </p><p>The get...() methods return data from individual fields. These methods \r\n");
source.Append(" * do not throw exceptions and may therefore have to handle exceptions internally. \r\n");
source.Append(" * If an exception is handled internally, it is logged and null is returned. \r\n");
source.Append(" * This is not expected to happen - if it does happen this indicates not so much \r\n");
source.Append(" * an exceptional circumstance as a bug in the code for this class.</p> \r\n");
source.Append(" */\r\n");
source.Append("[Serializable]\r\n");
source.Append("public class ");
source.Append(name);
source.Append(" : AbstractSegment ");
//implement interface from model.control package if required
/*Class correspondingControlInterface = Control.getInterfaceImplementedBy(name);
* if (correspondingControlInterface != null) {
* source.append("implements ");
* source.append(correspondingControlInterface.getName());
* } */
source.Append(" {\r\n\r\n");
source.Append(" /**\r\n");
source.Append(" * Creates a ");
source.Append(name);
source.Append(" (");
source.Append(segDesc);
source.Append(") segment object that belongs to the given \r\n");
source.Append(" * message. \r\n");
source.Append(" */\r\n");
//write constructor
source.Append(" public ");
source.Append(name);
source.Append("(Group parent, ModelClassFactory factory) : base(parent,factory) {\r\n");
source.Append(" Message message = Message;\r\n");
if (elements.Count > 0)
{
source.Append(" try {\r\n");
for (int i = 0; i < elements.Count; i++)
{
se = (SegmentElement)elements[i];
System.String type = SourceGenerator.getAlternateType(se.type, version);
source.Append(" this.add(");
source.Append("typeof(" + type + ")");
// if (type.equalsIgnoreCase("Varies")) {
// } else {
// source.append("factory.getTypeClass(\"");
// source.append(type);
// source.append("\", \"");
// source.append(version);
// source.append("\")");
// }
source.Append(", ");
if (se.opt == null)
{
source.Append("false");
}
else
{
if (se.opt.ToUpper().Equals("R".ToUpper()))
{
source.Append("true");
}
else
{
source.Append("false");
}
}
source.Append(", ");
source.Append(se.repetitions);
source.Append(", ");
source.Append(se.length);
source.Append(", ");
if (se.type.Equals("ID") || se.type.Equals("IS"))
{
source.Append("new System.Object[]{message, ");
source.Append(se.table);
source.Append("}");
}
else
{
source.Append("new System.Object[]{message}");
}
if (se.desc != null && se.desc.Trim().Length > 0)
{
source.Append(", ");
source.Append("\"" + se.GetDescriptionWithoutSpecialCharacters() + "\"");
}
source.Append(");\r\n");
}
source.Append(" } catch (HL7Exception he) {\r\n");
source.Append(" HapiLogFactory.getHapiLog(GetType()).error(\"Can't instantiate \" + this.getStructureName(), he);\r\n");
source.Append(" }\r\n");
}
source.Append(" }\r\n\r\n");
//write a datatype-specific accessor for each field
for (int i = 0; i < elements.Count; i++)
{
se = (SegmentElement)elements[i];
if (!se.desc.ToUpper().Equals("UNUSED".ToUpper()))
{
//some entries in 2.1 DB say "unused"
System.String type = SourceGenerator.getAlternateType(se.type, version);
source.Append("\t/**\r\n");
source.Append("\t* Returns ");
if (se.repetitions != 1)
{
source.Append("a single repetition of ");
}
source.Append(se.desc);
source.Append("(");
source.Append(name);
source.Append("-");
source.Append(se.field);
source.Append(").\r\n");
if (se.repetitions != 1)
{
source.Append("\t* @param rep the repetition number (this is a repeating field)\r\n");
source.Append("\t* @throws HL7Exception if the repetition number is invalid.\r\n");
}
source.Append("\t*/\r\n");
source.Append("\tpublic ");
source.Append(type);
source.Append(" ");
source.Append(SourceGenerator.makeAccessorNameCSharp(se.desc, se.repetitions));
if (se.repetitions != 1)
{
source.Append("(int rep)");
}
source.Append("\n\t{\r\n");
if (se.repetitions == 1)
{
source.Append("\t\tget{\r\n");
}
source.Append("\t\t\t");
source.Append(type);
source.Append(" ret = null;\r\n");
source.Append("\t\t\ttry\n\t\t\t{\r\n");
source.Append("\t\t\tType t = this.getField(");
source.Append(se.field);
source.Append(", ");
if (se.repetitions == 1)
{
source.Append("0");
}
else
{
source.Append("rep");
}
source.Append(");\r\n");
source.Append("\t\t\t\tret = (");
source.Append(type);
source.Append(")t;\r\n");
if (se.repetitions == 1)
{
source.Append("\t\t\t}\n\t\t\t catch (HL7Exception he) {\r\n");
source.Append("\t\t\tHapiLogFactory.getHapiLog(GetType()).error(\"Unexpected problem obtaining field value. This is a bug.\", he);\r\n");
source.Append("\t\t\t\tthrow new System.Exception(\"An unexpected error ocurred\", he);\r\n");
}
source.Append("\t\t} catch (System.Exception ex) {\r\n");
source.Append("\t\t\tHapiLogFactory.getHapiLog(GetType()).error(\"Unexpected problem obtaining field value. This is a bug.\", ex);\r\n");
source.Append("\t\t\t\tthrow new System.Exception(\"An unexpected error ocurred\", ex);\r\n");
source.Append(" }\r\n");
source.Append("\t\t\treturn ret;\r\n");
if (se.repetitions == 1)
{
source.Append("\t}\r\n"); //End get
}
source.Append(" }\r\n\r\n");
//add an array accessor as well for repeating fields
if (se.repetitions != 1)
{
source.Append(" /**\r\n");
source.Append(" * Returns all repetitions of ");
source.Append(se.desc);
source.Append(" (");
source.Append(name);
source.Append("-");
source.Append(se.field);
source.Append(").\r\n");
source.Append(" */\r\n");
source.Append(" public ");
source.Append(type);
source.Append("[] ");
source.Append(SourceGenerator.makeAccessorName(se.desc));
source.Append("() {\r\n");
source.Append(" ");
source.Append(type);
source.Append("[] ret = null;\r\n");
source.Append(" try {\r\n");
source.Append(" Type[] t = this.getField(");
source.Append(se.field);
source.Append("); \r\n");
source.Append(" ret = new ");
source.Append(type);
source.Append("[t.Length];\r\n");
source.Append(" for (int i = 0; i < ret.Length; i++) {\r\n");
source.Append(" ret[i] = (");
source.Append(type);
source.Append(")t[i];\r\n");
source.Append(" }\r\n");
source.Append(" } catch (HL7Exception he) {\r\n");
source.Append(" HapiLogFactory.getHapiLog(this.GetType()).error(\"Unexpected problem obtaining field value. This is a bug.\", he);\r\n");
source.Append(" throw new System.Exception(\"An unexpected error ocurred\", he);\r\n");
source.Append(" } catch (System.Exception cce) {\r\n");
source.Append(" HapiLogFactory.getHapiLog(GetType()).error(\"Unexpected problem obtaining field value. This is a bug.\", cce);\r\n");
source.Append(" throw new System.Exception(\"An unexpected error ocurred\", cce);\r\n");
source.Append(" }\r\n");
source.Append(" return ret;\r\n");
source.Append("}\r\n\r\n");
}
}
}
//add adapter method code for control package if it exists
//source.append(Control.getImplementation(correspondingControlInterface, version));
source.Append("\n}");
}
catch (System.Data.OleDb.OleDbException sqle)
{
SupportClass.WriteStackTrace(sqle, Console.Error);
}
return(source.ToString());
}
public object GetObject(System.Data.OleDb.OleDbDataReader reader, int i)
{
return(reader.GetValue(i));
}
/// <summary> Returns the Java source code for a class that represents the specified segment.</summary>
public static System.String makeSegment(System.String name, System.String version)
{
Console.WriteLine("Making segment " + name);
System.Text.StringBuilder source = new System.Text.StringBuilder();
try
{
System.Collections.ArrayList elements = new System.Collections.ArrayList();
SegmentElement se;
System.String segDesc = null;
using (System.Data.OleDb.OleDbConnection conn = NormativeDatabase.Instance.Connection)
{
System.Text.StringBuilder sql = new System.Text.StringBuilder();
sql.Append("SELECT HL7SegmentDataElements.seg_code, HL7SegmentDataElements.seq_no, ");
sql.Append("HL7SegmentDataElements.repetitional, HL7SegmentDataElements.repetitions, ");
sql.Append("HL7DataElements.description, HL7DataElements.length, HL7DataElements.table_id, ");
sql.Append("HL7SegmentDataElements.req_opt, HL7Segments.description, HL7DataElements.data_structure ");
sql.Append("FROM HL7Versions RIGHT JOIN (HL7Segments INNER JOIN (HL7DataElements INNER JOIN HL7SegmentDataElements ");
sql.Append("ON (HL7DataElements.version_id = HL7SegmentDataElements.version_id) ");
sql.Append("AND (HL7DataElements.data_item = HL7SegmentDataElements.data_item)) ");
sql.Append("ON (HL7Segments.version_id = HL7SegmentDataElements.version_id) ");
sql.Append("AND (HL7Segments.seg_code = HL7SegmentDataElements.seg_code)) ");
sql.Append("ON (HL7Versions.version_id = HL7Segments.version_id) ");
sql.Append("WHERE HL7SegmentDataElements.seg_code = '");
sql.Append(name);
sql.Append("' and HL7Versions.hl7_version = '");
sql.Append(version);
sql.Append("' ORDER BY HL7SegmentDataElements.seg_code, HL7SegmentDataElements.seq_no;");
System.Data.OleDb.OleDbCommand stmt = SupportClass.TransactionManager.manager.CreateStatement(conn);
System.Data.OleDb.OleDbCommand temp_OleDbCommand;
temp_OleDbCommand = stmt;
temp_OleDbCommand.CommandText = sql.ToString();
System.Data.OleDb.OleDbDataReader rs = temp_OleDbCommand.ExecuteReader();
while (rs.Read())
{
if (segDesc == null)
{
segDesc = System.Convert.ToString(rs[9 - 1]);
}
se = new SegmentElement();
se.field = Convert.ToInt32(rs.GetValue(2 - 1));
se.rep = System.Convert.ToString(rs[3 - 1]);
if (rs.IsDBNull(4 - 1))
{
se.repetitions = 0;
}
else
{
se.repetitions = Convert.ToInt32(rs.GetValue(4 - 1));
}
if (se.repetitions == 0)
{
if (se.rep == null || !se.rep.ToUpper().Equals("Y".ToUpper()))
{
se.repetitions = 1;
}
}
se.desc = System.Convert.ToString(rs[5 - 1]);
if (!rs.IsDBNull(6 - 1))
{
se.length = Convert.ToInt32(rs.GetValue(6 - 1));
}
se.table = Convert.ToInt32(rs.GetValue(7 - 1));
se.opt = System.Convert.ToString(rs[8 - 1]);
se.type = System.Convert.ToString(rs[10 - 1]);
//shorten CE_x to CE
if (se.type.StartsWith("CE"))
{
se.type = "CE";
}
elements.Add(se);
/*System.out.println("Segment: " + name + " Field: " + se.field + " Rep: " + se.rep +
* " Repetitions: " + se.repetitions + " Desc: " + se.desc + " Length: " + se.length +
* " Table: " + se.table + " Segment Desc: " + segDesc);*/
}
rs.Close();
stmt.Dispose();
NormativeDatabase.Instance.returnConnection(conn);
}
//write imports, class documentation, etc ...
source.Append("using System;\r\n");
source.Append("using NHapi.Base;\r\n");
source.Append("using NHapi.Base.Parser;\r\n");
source.Append("using NHapi.Base.Model;\r\n");
source.Append("using ");
source.Append(PackageManager.GetVersionPackageName(version));
source.Append("Datatype;\r\n");
source.Append("using NHapi.Base.Log;\r\n\r\n");
source.Append("namespace ");
source.Append(PackageManager.GetVersionPackageName(version));
source.Append("Segment{\r\n\r\n");
source.Append("///<summary>\r\n");
source.Append("/// Represents an HL7 ");
source.Append(name);
source.Append(" message segment. \r\n");
source.Append("/// This segment has the following fields:<ol>\r\n");
for (int i = 0; i < elements.Count; i++)
{
se = (SegmentElement)elements[i];
source.Append("///");
source.Append("<li>");
source.Append(name);
source.Append("-");
source.Append(se.field);
source.Append(": ");
source.Append(se.GetDescriptionWithoutSpecialCharacters());
source.Append(" (");
source.Append(se.type);
source.Append(")</li>\r\n");
}
source.Append("///</ol>\r\n");
source.Append("/// The get...() methods return data from individual fields. These methods \r\n");
source.Append("/// do not throw exceptions and may therefore have to handle exceptions internally. \r\n");
source.Append("/// If an exception is handled internally, it is logged and null is returned. \r\n");
source.Append("/// This is not expected to happen - if it does happen this indicates not so much \r\n");
source.Append("/// an exceptional circumstance as a bug in the code for this class.\r\n");
source.Append("///</summary>\r\n");
source.Append("[Serializable]\r\n");
source.Append("public class ");
source.Append(name);
source.Append(" : AbstractSegment ");
//implement interface from Model.control package if required
/*Class correspondingControlInterface = Control.getInterfaceImplementedBy(name);
* if (correspondingControlInterface != null) {
* source.append("implements ");
* source.append(correspondingControlInterface.getName());
* } */
source.Append(" {\r\n\r\n");
source.Append(" /**\r\n");
source.Append(" * Creates a ");
source.Append(name);
source.Append(" (");
source.Append(segDesc);
source.Append(") segment object that belongs to the given \r\n");
source.Append(" * message. \r\n");
source.Append(" */\r\n");
//write constructor
source.Append("\tpublic ");
source.Append(name);
source.Append("(IGroup parent, IModelClassFactory factory) : base(parent,factory) {\r\n");
source.Append("\tIMessage message = Message;\r\n");
if (elements.Count > 0)
{
source.Append(" try {\r\n");
for (int i = 0; i < elements.Count; i++)
{
se = (SegmentElement)elements[i];
System.String type = SourceGenerator.getAlternateType(se.type, version);
source.Append(" this.add(");
source.Append("typeof(" + type + ")");
// if (type.equalsIgnoreCase("Varies")) {
// } else {
// source.append("factory.getTypeClass(\"");
// source.append(type);
// source.append("\", \"");
// source.append(version);
// source.append("\")");
// }
source.Append(", ");
if (se.opt == null)
{
source.Append("false");
}
else
{
if (se.opt.ToUpper().Equals("R".ToUpper()))
{
source.Append("true");
}
else
{
source.Append("false");
}
}
source.Append(", ");
source.Append(se.repetitions);
source.Append(", ");
source.Append(se.length);
source.Append(", ");
if (se.type.Equals("ID") || se.type.Equals("IS"))
{
source.Append("new System.Object[]{message, ");
source.Append(se.table);
source.Append("}");
}
else
{
source.Append("new System.Object[]{message}");
}
if (se.desc != null && se.desc.Trim().Length > 0)
{
source.Append(", ");
source.Append("\"" + se.GetDescriptionWithoutSpecialCharacters() + "\"");
}
source.Append(");\r\n");
}
source.Append(" } catch (HL7Exception he) {\r\n");
source.Append(" HapiLogFactory.GetHapiLog(GetType()).Error(\"Can't instantiate \" + GetType().Name, he);\r\n");
source.Append(" }\r\n");
}
source.Append(" }\r\n\r\n");
//write a datatype-specific accessor for each field
for (int i = 0; i < elements.Count; i++)
{
se = (SegmentElement)elements[i];
if (!se.desc.ToUpper().Equals("UNUSED".ToUpper()))
{
//some entries in 2.1 DB say "unused"
System.String type = SourceGenerator.getAlternateType(se.type, version);
source.Append("\t///<summary>\r\n");
source.Append("\t/// Returns ");
if (se.repetitions != 1)
{
source.Append("a single repetition of ");
}
source.Append(se.GetDescriptionWithoutSpecialCharacters());
source.Append("(");
source.Append(name);
source.Append("-");
source.Append(se.field);
source.Append(").\r\n");
if (se.repetitions != 1)
{
source.Append("\t/// throws HL7Exception if the repetition number is invalid.\r\n");
source.Append("\t/// <param name=\"rep\">The repetition number (this is a repeating field)</param>\r\n");
}
source.Append("\t///</summary>\r\n");
source.Append("\tpublic ");
source.Append(type);
source.Append(" ");
source.Append(SourceGenerator.MakeAccessorName(se.desc, se.repetitions));
if (se.repetitions != 1)
{
source.Append("(int rep)");
}
source.Append("\n\t{\r\n");
if (se.repetitions == 1)
{
source.Append("\t\tget{\r\n");
}
source.Append("\t\t\t");
source.Append(type);
source.Append(" ret = null;\r\n");
source.Append("\t\t\ttry\n\t\t\t{\r\n");
source.Append("\t\t\tIType t = this.GetField(");
source.Append(se.field);
source.Append(", ");
if (se.repetitions == 1)
{
source.Append("0");
}
else
{
source.Append("rep");
}
source.Append(");\r\n");
source.Append("\t\t\t\tret = (");
source.Append(type);
source.Append(")t;\r\n");
if (se.repetitions == 1)
{
source.Append("\t\t\t}\n\t\t\t catch (HL7Exception he) {\r\n");
source.Append("\t\t\tHapiLogFactory.GetHapiLog(GetType()).Error(\"Unexpected problem obtaining field value. This is a bug.\", he);\r\n");
source.Append("\t\t\t\tthrow new System.Exception(\"An unexpected error ocurred\", he);\r\n");
}
source.Append("\t\t} catch (System.Exception ex) {\r\n");
source.Append("\t\t\tHapiLogFactory.GetHapiLog(GetType()).Error(\"Unexpected problem obtaining field value. This is a bug.\", ex);\r\n");
source.Append("\t\t\t\tthrow new System.Exception(\"An unexpected error ocurred\", ex);\r\n");
source.Append(" }\r\n");
source.Append("\t\t\treturn ret;\r\n");
if (se.repetitions == 1)
{
source.Append("\t}\r\n"); //End get
}
source.Append(" }\r\n\r\n");
//add an array accessor as well for repeating fields
if (se.repetitions != 1)
{
source.Append(" ///<summary>\r\n");
source.Append(" /// Returns all repetitions of ");
source.Append(se.GetDescriptionWithoutSpecialCharacters());
source.Append(" (");
source.Append(name);
source.Append("-");
source.Append(se.field);
source.Append(").\r\n");
source.Append(" ///</summary>\r\n");
source.Append(" public ");
source.Append(type);
source.Append("[] Get");
source.Append(SourceGenerator.MakeAccessorName(se.desc));
source.Append("() {\r\n");
source.Append(" ");
source.Append(type);
source.Append("[] ret = null;\r\n");
source.Append(" try {\r\n");
source.Append(" IType[] t = this.GetField(");
source.Append(se.field);
source.Append("); \r\n");
source.Append(" ret = new ");
source.Append(type);
source.Append("[t.Length];\r\n");
source.Append(" for (int i = 0; i < ret.Length; i++) {\r\n");
source.Append(" ret[i] = (");
source.Append(type);
source.Append(")t[i];\r\n");
source.Append(" }\r\n");
source.Append(" } catch (HL7Exception he) {\r\n");
source.Append(" HapiLogFactory.GetHapiLog(this.GetType()).Error(\"Unexpected problem obtaining field value. This is a bug.\", he);\r\n");
source.Append(" throw new System.Exception(\"An unexpected error ocurred\", he);\r\n");
source.Append(" } catch (System.Exception cce) {\r\n");
source.Append(" HapiLogFactory.GetHapiLog(GetType()).Error(\"Unexpected problem obtaining field value. This is a bug.\", cce);\r\n");
source.Append(" throw new System.Exception(\"An unexpected error ocurred\", cce);\r\n");
source.Append(" }\r\n");
source.Append(" return ret;\r\n");
source.Append("}\r\n\r\n");
//Add property for the total repetitions of this object
source.Append(" ///<summary>\r\n");
source.Append(" /// Returns the total repetitions of ");
source.Append(se.GetDescriptionWithoutSpecialCharacters());
source.Append(" (");
source.Append(name);
source.Append("-");
source.Append(se.field);
source.Append(").\r\n");
source.Append(" ///</summary>\r\n");
source.Append(" public int ");
source.Append(SourceGenerator.MakeName(se.desc));
source.Append("RepetitionsUsed\r\n");
source.Append("{\r\n");
source.Append("get{\r\n");
source.Append(" try {\r\n");
source.Append("\treturn GetTotalFieldRepetitionsUsed(" + se.field + ");\r\n");
source.Append(" }\r\n");
source.Append("catch (HL7Exception he) {\r\n");
source.Append(" HapiLogFactory.GetHapiLog(this.GetType()).Error(\"Unexpected problem obtaining field value. This is a bug.\", he);\r\n");
source.Append(" throw new System.Exception(\"An unexpected error ocurred\", he);\r\n");
source.Append("} catch (System.Exception cce) {\r\n");
source.Append(" HapiLogFactory.GetHapiLog(GetType()).Error(\"Unexpected problem obtaining field value. This is a bug.\", cce);\r\n");
source.Append(" throw new System.Exception(\"An unexpected error ocurred\", cce);\r\n");
source.Append("}\r\n");
source.Append("}\r\n");
source.Append("}\r\n");
}
}
}
//add adapter method code for control package if it exists
//source.append(Control.getImplementation(correspondingControlInterface, version));
source.Append("\n}");
}
catch (System.Data.OleDb.OleDbException sqle)
{
SupportClass.WriteStackTrace(sqle, Console.Error);
}
return(source.ToString());
}
protected CalendarEvent _CreateEventFromData(System.Data.OleDb.OleDbDataReader pEventData, Boolean bRException)
{
try
{
CalendarEvent pEvent = null;
int nEventID;
if (pEventData.IsClosed /*|| !pEventData.HasRows*/)
{
return(null);
}
nEventID = pEventData.GetInt32(pEventData.GetOrdinal("EventID"));
pEvent = m_pCalendar.DataProvider.CreateEventEx(nEventID);
if (pEvent == null)
{
return(null);
}
pEvent.Subject = pEventData.GetString(pEventData.GetOrdinal("Subject"));
pEvent.Location = pEventData.GetString(pEventData.GetOrdinal("Location"));
pEvent.Body = pEventData.GetString(pEventData.GetOrdinal("Body"));
pEvent.MeetingFlag = ToBool(pEventData.GetInt32(pEventData.GetOrdinal("IsMeeting")));
pEvent.PrivateFlag = ToBool(pEventData.GetInt32(pEventData.GetOrdinal("IsPrivate")));
pEvent.Label = pEventData.GetInt32(pEventData.GetOrdinal("LabelID"));
pEvent.BusyStatus = (CalendarEventBusyStatus)pEventData.GetInt32(pEventData.GetOrdinal("BusyStatus"));
pEvent.Importance = (CalendarEventImportance)pEventData.GetInt32(pEventData.GetOrdinal("ImportanceLevel"));
pEvent.StartTime = pEventData.GetDateTime(pEventData.GetOrdinal("StartDateTime"));
pEvent.EndTime = pEventData.GetDateTime(pEventData.GetOrdinal("EndDateTime"));
pEvent.AllDayEvent = ToBool(pEventData.GetInt32(pEventData.GetOrdinal("IsAllDayEvent")));
pEvent.Reminder = ToBool(pEventData.GetInt32(pEventData.GetOrdinal("IsReminder")));
pEvent.ReminderMinutesBeforeStart = pEventData.GetInt32(pEventData.GetOrdinal("ReminderMinutesBeforeStart"));
pEvent.ReminderSoundFile = pEventData.GetString(pEventData.GetOrdinal("RemainderSoundFile"));
pEvent.CustomProperties.LoadFromString(pEventData.GetString(pEventData.GetOrdinal("CustomPropertiesXMLData")));
pEvent.CustomIcons.LoadFromString(pEventData.GetString(pEventData.GetOrdinal("CustomIconsIDs")));
pEvent.ScheduleID = pEventData.GetInt32(pEventData.GetOrdinal("ScheduleID"));
if (bRException)
{
pEvent.MakeAsRException();
pEvent.RExceptionStartTimeOrig = pEventData.GetDateTime(pEventData.GetOrdinal("RExceptionStartTimeOrig"));
pEvent.RExceptionEndTimeOrig = pEventData.GetDateTime(pEventData.GetOrdinal("RExceptionEndTimeOrig"));
pEvent.RExceptionDeleted = ToBool(pEventData.GetInt32(pEventData.GetOrdinal("ISRecurrenceExceptionDeleted")));
}
if (!bRException)
{
// "process_RecurrenceState" and "process_RecurrencePatternID" properties
// are used to process master events.
//
// If they are set and RecurrenceStaie is Master Data provider will
// fier DoReadRPattern event and make event as Master.
// And it will also generate occurrences for RetrieveDayEvents method.
//
// These properties are temporary and they will be removed by data provider.
//
// If these properties are not set data provider expect that master event
// is already compleated - CreateRecurrence method is called and
// Recurrence pattern is set.
//
// This mechanism is useful for DB data providers, when events and patterns
// are stored separately (in tables).
// But if events stored in some memory collection or array
// it should not be used because master event store recurrence pattern inside.
pEvent.CustomProperties["process_RecurrenceState"] = pEventData.GetValue(pEventData.GetOrdinal("RecurrenceState"));
pEvent.CustomProperties["process_RecurrencePatternID"] = pEventData.GetValue(pEventData.GetOrdinal("RecurrencePatternID"));
}
return(pEvent);
}
catch (System.Exception e)
{
System.Diagnostics.Debug.WriteLine("EXCEPTION! SQLDataHelper.CreateEventFromRS: " + e.Message);
}
return(null);
}
