public void InsertQAOCRData(DataTable dt) { SOQ_DETAILS soq = new SOQ_DETAILS(); try { foreach (DataRow eachRow in dt.Rows) { soq.ADDENDA_NBR = eachRow["ADDENDA_NBR"].ToString(); soq.DODGE_PROJ_NBR = eachRow["DODGE_PROJ_NBR"].ToString(); soq.PDF_FILE_SIZE_BYTES = eachRow["PDF_FILE_SIZE_BYTES"].ToString(); soq.QUEUE_TIMESTAMP = eachRow["QUEUE_TIMESTAMP"].ToString(); soq.SBP_OCR_XML = eachRow["SBP_OCR_XML"].ToString(); soq.TITLE_CODE = eachRow["TITLE_CODE"].ToString(); soq.VER_NBR = eachRow["VER_NBR"].ToString(); OracleHelper helper = new OracleHelper(); helper.InsertQAOCRData(soq); XElement statusXML = XElement.Load(string.Format(@"{0}\StatusXML\status.xml", Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().Location))); statusXML.XPathSelectElement("//last-queue-timestamp").SetValue((eachRow["QUEUE_TIMESTAMP"].ToString())); statusXML.Save(string.Format(@"{0}\StatusXML\status.xml", Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().Location))); } } catch (Exception) { throw; } }
public bool InsertQAOCRData(SOQ_DETAILS soqdetails) { string queryPath = string.Format(@"{0}\Query\INSERT_QA_SOQ_QUERY.sql", Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().Location)); string query = File.ReadAllText(queryPath); bool isInserted = true; try { query = String.Format(query, soqdetails.DODGE_PROJ_NBR, soqdetails.TITLE_CODE, soqdetails.ADDENDA_NBR, soqdetails.VER_NBR, soqdetails.SBP_OCR_XML, "TO_DATE ('" + Convert.ToDateTime(soqdetails.QUEUE_TIMESTAMP).ToString("yyyyMMddHHmmss") + "','YYYYMMDDHH24MISS')", soqdetails.PDF_FILE_SIZE_BYTES); using (oraconnection = new OracleConnection(ConfigurationManager.AppSettings["DSN_PNRQ"])) { try { oraconnection.Open(); oracommand = new OracleCommand(query, oraconnection); oracommand.CommandType = CommandType.Text; int value = oracommand.ExecuteNonQuery(); } catch (Exception) { mhcLogger.Info("Tailed to Insert. Script " + query, ""); } finally { oraconnection.Close(); } } } catch (Exception) { throw; } return isInserted; }