private static List <CrossRefInfo> GetCrossRefInfoFromTableOnReactionID(DataTable crossRefData, int reactionID)
{
List <CrossRefInfo> lstCrossRef = null;
try
{
if (crossRefData != null && crossRefData.Rows.Count > 0 && reactionID > 0)
{
EnumerableRowCollection <DataRow> rows = from row in crossRefData.AsEnumerable()
where row.Field <Int64>("REACTION_ID") == reactionID
select row;
lstCrossRef = new List <CrossRefInfo>();
//int crossRefIndx = 0;
foreach (DataRow drow in rows)
{
//crossRefIndx++;
CrossRefInfo crossRef = new CrossRefInfo();
crossRef.ReactionID = reactionID;
//crossRef.CrossRefID = Convert.ToInt32(drow["CR_ID"]);
//crossRef.CrossRefNo = crossRefIndx;
crossRef.PrevReactionNo = drow["PRECEEDING"].ToString();
crossRef.SuccReactionNo = drow["SUCCEEDING"].ToString();
lstCrossRef.Add(crossRef);
}
}
}
catch (Exception ex)
{
ErrorHandling.WriteErrorLog(ex.ToString());
}
return(lstCrossRef);
}
public static bool SaveCrossReference(CrossRefInfo crossRef, out DataTable dtResult)
{
bool blStatus = false;
string strTemp = String.Empty;
DataTable dtCrossRef = new DataTable();
try
{
using (OracleConnection oraCon = ConnectionDB.GetOracleConnection())
{
using (OracleCommand oraCmd = new OracleCommand())
{
oraCmd.Connection = oraCon;
oraCmd.CommandText = "REACTION_ANALYSIS.DML_CROSS_REFERENCES";
oraCmd.CommandType = CommandType.StoredProcedure;
oraCmd.Parameters.Add("PIN_CR_ID", OracleDbType.Int32).Value = crossRef.CrossRefID;
oraCmd.Parameters.Add("PIN_REACTION_ID", OracleDbType.Int32).Value = crossRef.ReactionID;
oraCmd.Parameters.Add("PIN_PRE_RXN_SNO", OracleDbType.Int32).Value = crossRef.PrevReactionNo;
oraCmd.Parameters.Add("PIN_SUCC_RXN_SNO", OracleDbType.Int32).Value = crossRef.SuccReactionNo;
oraCmd.Parameters.Add("PIC_OPTION", OracleDbType.Varchar2).Value = crossRef.Option;
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_CROSS_REACTIONS", 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(dtCrossRef);
}
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 = dtCrossRef;
return(blStatus);
}
}
}
catch (Exception)
{
throw;
}
dtResult = dtCrossRef;
return(blStatus);
}
private static List <CrossRefInfo> GetCrossRefInfoFromTableOnReactionID(DataTable crossRefData, int reactionID)
{
List <CrossRefInfo> lstCrossRef = null;
try
{
if (crossRefData != null)
{
EnumerableRowCollection <DataRow> rows = from row in crossRefData.AsEnumerable()
where row.Field <Int64>("REACTION_ID") == reactionID
select row;
lstCrossRef = new List <CrossRefInfo>();
//int crossRefIndx = 0;
foreach (DataRow drow in rows)
{
//crossRefIndx++;
//Manual Export - Code commented on 22nd Nov 2014
//CrossRefInfo crossRef = new CrossRefInfo();
//crossRef.ReactionID = reactionID;
//crossRef.CrossRefID = Convert.ToInt32(drow["CR_ID"]);
////crossRef.CrossRefNo = crossRefIndx;
//crossRef.PrevReactionNo = !string.IsNullOrEmpty(drow["PRE_RXN_SNO"].ToString()) ? Convert.ToInt32(drow["PRE_RXN_SNO"]) : 0;
//crossRef.SuccReactionNo = !string.IsNullOrEmpty(drow["SUCC_RXN_SNO"].ToString()) ? Convert.ToInt32(drow["SUCC_RXN_SNO"]) : 0;
//lstCrossRef.Add(crossRef);
//Automated Export
string[] saPreceeding = drow["PRECEEDING"].ToString().Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
if (saPreceeding != null)
{
foreach (string prerxn in saPreceeding)
{
if (!string.IsNullOrEmpty(prerxn.Trim()))
{
CrossRefInfo crossRef = new CrossRefInfo();
crossRef.ReactionID = reactionID;
crossRef.PrevReactionNo = prerxn.Trim();
//crossRef.CrossRefType = "PRE";
lstCrossRef.Add(crossRef);
}
}
}
string[] saSucceeding = drow["SUCCEEDING"].ToString().Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
if (saSucceeding != null)
{
foreach (string succrxn in saSucceeding)
{
if (!string.IsNullOrEmpty(succrxn.Trim()))
{
CrossRefInfo crossRef = new CrossRefInfo();
crossRef.ReactionID = reactionID;
crossRef.SuccReactionNo = succrxn.Trim();
//crossRef.CrossRefType = "SUC";
lstCrossRef.Add(crossRef);
}
}
}
}
}
}
catch (Exception ex)
{
ErrorHandling.WriteErrorLog(ex.ToString());
}
return(lstCrossRef);
}
