private static List <ReactionRefInfo> GetRxnRefInfoFromTableOnReactionID(DataTable rxnRefData, int reactionID) { List <ReactionRefInfo> lstRxnRef = null; try { if (rxnRefData != null && rxnRefData.Rows.Count > 0) { EnumerableRowCollection <DataRow> rows = from row in rxnRefData.AsEnumerable() where row.Field <Int64>("REACTION_ID") == reactionID select row; lstRxnRef = new List <ReactionRefInfo>(); foreach (DataRow drow in rows) { ReactionRefInfo rxnRef = new ReactionRefInfo(); rxnRef.ReactionID = reactionID; //rxnRef.ReactionRefId = Convert.ToInt32(drow["RR_ID"]); rxnRef.ExtRegNo = Convert.ToInt32(drow["EXT_REG_NO"]); rxnRef.Step = drow["STEP"].ToString(); rxnRef.RefPath = drow["PATH_LETTER"].ToString(); lstRxnRef.Add(rxnRef); } } } catch (Exception ex) { ErrorHandling.WriteErrorLog(ex.ToString()); } return(lstRxnRef); }
public static bool SaveReactionReference(ReactionRefInfo rxnRef, out DataTable dtResult) { bool blStatus = false; string strTemp = String.Empty; DataTable dtReactions = new DataTable(); try { using (OracleConnection oraCon = ConnectionDB.GetOracleConnection()) { using (OracleCommand oraCmd = new OracleCommand()) { oraCmd.Connection = oraCon; oraCmd.CommandText = "REACTION_ANALYSIS.DML_REACTION_REFERENCE"; oraCmd.CommandType = CommandType.StoredProcedure; oraCmd.Parameters.Add("PIN_RR_ID", OracleDbType.Int32).Value = rxnRef.ReactionRefId; oraCmd.Parameters.Add("PIN_REACTION_ID", OracleDbType.Int32).Value = rxnRef.ReactionID; oraCmd.Parameters.Add("PIC_EXTREG_ID", OracleDbType.Int32).Value = rxnRef.ExtRegNo; oraCmd.Parameters.Add("PIC_RR_PATH", OracleDbType.Varchar2).Value = rxnRef.RefPath; oraCmd.Parameters.Add("PIC_STEP", OracleDbType.Varchar2).Value = rxnRef.Step; oraCmd.Parameters.Add("PIC_OPTION", OracleDbType.Varchar2).Value = rxnRef.Option.ToString(); OracleParameter paramStatus = new OracleParameter(); paramStatus.ParameterName = "POC_STATUS"; paramStatus.Direction = ParameterDirection.Output; paramStatus.OracleDbType = OracleDbType.Varchar2; paramStatus.Size = 200; oraCmd.Parameters.Add(paramStatus); oraCmd.Parameters.Add("PORC_REACT_REFERECNCES", OracleDbType.RefCursor).Direction = ParameterDirection.Output; //TODO: Need to discuss with sairam to add UR_ID. // oraCmd.Parameters.Add("PIN_UR_ID", OracleDbType.Int32).Value = usrInfo.UserID; using (OracleDataAdapter dataAdapter = new OracleDataAdapter(oraCmd)) { dataAdapter.Fill(dtReactions); } if (paramStatus.Value != null) { if (paramStatus.Value.ToString().Length > 0) { strTemp = Convert.ToString(oraCmd.Parameters["POC_STATUS"].Value); if (strTemp.ToUpper() == "UPDATE SUCCESS" || strTemp.ToUpper() == "INSERT SUCCESS" || strTemp.ToUpper() == "DELETE SUCCESS") { blStatus = true; } } } dtResult = dtReactions; return(blStatus); } } } catch (Exception) { throw; } dtResult = dtReactions; return(blStatus); }