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);
}