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);
}
public static bool SaveTaskPrepation(TaskPreparation objTaskPrep, string files)
{
string strTemp = null;
bool blStatus = false;
try
{
using (OracleConnection oraCon = ConnectionDB.GetOracleConnection())
{
using (OracleCommand oCmd = new OracleCommand())
{
oCmd.CommandText = "SHIPMENT_MANAGEMENT.SAVE_SHIPMENT_REFERENCE";
oCmd.CommandType = CommandType.StoredProcedure;
oCmd.Connection = oraCon;
oCmd.Parameters.Add("PIN_SHIPMENT_REF_ID", OracleDbType.Int32).Value = objTaskPrep.ShipmentRefID;
oCmd.Parameters.Add("PIC_ABSTRACT_REF_NO", OracleDbType.Varchar2).Value = objTaskPrep.AbstractRefNo;
oCmd.Parameters.Add("PIC_JOURNAL_NAME", OracleDbType.Varchar2).Value = objTaskPrep.JournalName;
oCmd.Parameters.Add("PIC_DOI", OracleDbType.Varchar2, 4000).Value = objTaskPrep.DOI;
oCmd.Parameters.Add("PIC_ZERO_RXN_STATUS", OracleDbType.Char, 1).Value = objTaskPrep.IsNoReaction ? 'Y' : 'N';
oCmd.Parameters.Add("PIC_FILE_NAME", OracleDbType.Varchar2).Value = objTaskPrep.AbstractRefNo;
oCmd.Parameters.Add("PIC_FILE_TYPE", OracleDbType.Varchar2).Value = objTaskPrep.FileType;
oCmd.Parameters.Add("PIC_REF_FILE_NAMES", OracleDbType.Varchar2).Value = files;
oCmd.Parameters.Add("PIC_SYS_NO", OracleDbType.Varchar2).Value = objTaskPrep.SysNo;
oCmd.Parameters.Add("PIC_SYS_TEXT", OracleDbType.Varchar2).Value = objTaskPrep.SysText;
oCmd.Parameters.Add("PIC_SYS_CLASS_TYPE", OracleDbType.Varchar2).Value = objTaskPrep.SysNoClassType;
OracleParameter paramStatus = new OracleParameter();
paramStatus.ParameterName = "POC_STATUS";
paramStatus.Direction = ParameterDirection.Output;
paramStatus.OracleDbType = OracleDbType.Varchar2;
paramStatus.Size = 200;
oCmd.Parameters.Add(paramStatus);
oCmd.Parameters.Add("PORC_SHIPMENT_REFS", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
oraCon.Open();
oCmd.ExecuteNonQuery();
oraCon.Close();
if (paramStatus.Value != null)
{
if (paramStatus.Value.ToString().Length > 0)
{
strTemp = Convert.ToString(oCmd.Parameters["POC_STATUS"].Value);
if (strTemp.ToUpper() == "UPDATE SUCCESS")
{
blStatus = true;
}
else
{
blStatus = false;
}
}
}
return(blStatus);
}
}
}
catch (Exception)
{
throw;
}
return(blStatus);
}
public static bool SaveReactionParticipants(ParticipantInfo rxnPartpnt, 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_PARTICIPANTS";
oraCmd.CommandType = CommandType.StoredProcedure;
oraCmd.Parameters.Add("PIN_PRPNT_ID", OracleDbType.Int32).Value = rxnPartpnt.ParticipantID;
oraCmd.Parameters.Add("PIN_REACTION_ID", OracleDbType.Int32).Value = rxnPartpnt.ReactionID;
oraCmd.Parameters.Add("PIN_RXN_STEP_ID", OracleDbType.Int32).Value = rxnPartpnt.RxnStepID;
oraCmd.Parameters.Add("PIC_PRPNT_TYPE", OracleDbType.Varchar2).Value = rxnPartpnt.ParticipantType;
oraCmd.Parameters.Add("PIC_PRPNT_STRUCTURE", OracleDbType.Clob).Value = rxnPartpnt.Structure;
oraCmd.Parameters.Add("PIC_INCHI_KEY", OracleDbType.Varchar2).Value = rxnPartpnt.InchiKey;
oraCmd.Parameters.Add("PIC_PRPNT_NAME", OracleDbType.Varchar2).Value = rxnPartpnt.ParticipantName;
oraCmd.Parameters.Add("PIC_STRUCTURE_NO", OracleDbType.Varchar2).Value = rxnPartpnt.StructureNo;
oraCmd.Parameters.Add("PIC_GRADE", OracleDbType.Varchar2).Value = rxnPartpnt.Grade;
oraCmd.Parameters.Add("PIC_OPTION", OracleDbType.Varchar2).Value = rxnPartpnt.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_PARITCIPANTS", 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);
}
public static bool UpdateReactionsQCCompleteStatus(int shipmentRefID, List <int> lstSelRxnIDs, int UrId)
{
bool blStatus = false;
try
{
using (OracleConnection oraCon = ConnectionDB.GetOracleConnection())
{
using (OracleCommand oraCmd = new OracleCommand())
{
oraCmd.Connection = oraCon;
oraCmd.CommandText = "REACTION_ANALYSIS.UPDATE_QC_COMPLETED_STATUS";
oraCmd.CommandType = CommandType.StoredProcedure;
oraCmd.Parameters.Add("PIN_DOC_ID", OracleDbType.Int32, 30).Value = shipmentRefID;
OracleParameter opRefIDs = new OracleParameter();
opRefIDs.OracleDbType = OracleDbType.Int32;
opRefIDs.CollectionType = OracleCollectionType.PLSQLAssociativeArray;
opRefIDs.ParameterName = "PINA_RXN_IDS";
opRefIDs.Direction = ParameterDirection.Input;
if (lstSelRxnIDs.Count == 0)
{
opRefIDs.Size = 0;
opRefIDs.Value = new string[1] {
""
};
}
else
{
opRefIDs.Size = lstSelRxnIDs.Count;
opRefIDs.Value = lstSelRxnIDs.ToArray();
}
oraCmd.Parameters.Add(opRefIDs);
oraCmd.Parameters.Add("PIN_UR_ID", OracleDbType.Int32, 30).Value = UrId;
OracleParameter paramStatus = new OracleParameter();
paramStatus.ParameterName = "POC_STATUS";
paramStatus.Direction = ParameterDirection.Output;
paramStatus.OracleDbType = OracleDbType.Varchar2;
paramStatus.Size = 200;
oraCmd.Parameters.Add(paramStatus);
oraCon.Open();
oraCmd.ExecuteNonQuery();
oraCon.Close();
if (paramStatus.Value != null)
{
if (paramStatus.Value.ToString().Length > 0)
{
string strTemp = Convert.ToString(oraCmd.Parameters["POC_STATUS"].Value);
if (strTemp.ToUpper() == "SUCCESS")
{
blStatus = true;
}
else
{
blStatus = false;
}
}
}
return(blStatus);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool SaveReactionConditions(ConditionInfo rxnCond, out DataTable dtResult)
{
bool blStatus = false;
string strTemp = String.Empty;
DataTable dtRxnConds = new DataTable();
try
{
using (OracleConnection oraCon = ConnectionDB.GetOracleConnection())
{
using (OracleCommand oraCmd = new OracleCommand())
{
oraCmd.Connection = oraCon;
oraCmd.CommandText = "REACTION_ANALYSIS.DML_CONDITIONS";
oraCmd.CommandType = CommandType.StoredProcedure;
oraCmd.Parameters.Add("PIN_CONDITION_ID", OracleDbType.Int32).Value = rxnCond.ConditionID;
oraCmd.Parameters.Add("PIN_REACTION_ID", OracleDbType.Int32).Value = rxnCond.ReactionID;
oraCmd.Parameters.Add("PIN_RXN_STEP_ID", OracleDbType.Int32).Value = rxnCond.RxnStepID;
oraCmd.Parameters.Add("PIC_COND_TIME", OracleDbType.Varchar2).Value = rxnCond.Time;
oraCmd.Parameters.Add("PIC_TEMPERATURE", OracleDbType.Varchar2).Value = rxnCond.Temperature;
oraCmd.Parameters.Add("PIC_PRESSURE", OracleDbType.Varchar2).Value = rxnCond.Pressure;
oraCmd.Parameters.Add("PIC_PH", OracleDbType.Varchar2).Value = rxnCond.PH;
oraCmd.Parameters.Add("PIC_IS_WARMUP", OracleDbType.Char).Value = rxnCond.WarmUp ? 'Y' : 'N';
oraCmd.Parameters.Add("PIC_IS_COOL_DOWN", OracleDbType.Char).Value = rxnCond.CoolDown ? 'Y' : 'N';
oraCmd.Parameters.Add("PIC_IS_REFLUX", OracleDbType.Char).Value = rxnCond.Reflux ? 'Y' : 'N';
oraCmd.Parameters.Add("PIC_OTHER_CONDITIONS", OracleDbType.Varchar2).Value = rxnCond.Other;
oraCmd.Parameters.Add("PIC_OPERATION", OracleDbType.Varchar2).Value = rxnCond.Operation;
oraCmd.Parameters.Add("PIC_OPTION", OracleDbType.Varchar2).Value = rxnCond.Option.ToString();
oraCmd.Parameters.Add("PIC_COND_TIME_UNIT", OracleDbType.Varchar2).Value = rxnCond.TimeUnits;
oraCmd.Parameters.Add("PIC_TEMPERATURE_UNIT", OracleDbType.Varchar2).Value = rxnCond.TempUnits;
oraCmd.Parameters.Add("PIC_PRESSURE_UNIT", OracleDbType.Varchar2).Value = rxnCond.PressureUnits;
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_CONDITIONS", 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(dtRxnConds);
}
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 = dtRxnConds;
return(blStatus);
}
}
}
catch (Exception)
{
throw;
}
dtResult = dtRxnConds;
return(blStatus);
}
public static bool SaveReactionStepsInfo(DmlOperations dmlEnum, StepInfo rxnStep, 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_STEPS";
oraCmd.CommandType = CommandType.StoredProcedure;
oraCmd.Parameters.Add("PIN_RXN_STEP_ID", OracleDbType.Int32).Value = rxnStep.StepID;
oraCmd.Parameters.Add("PIN_REACTION_ID", OracleDbType.Int32).Value = rxnStep.ReactionID;
oraCmd.Parameters.Add("PIN_RXN_STEP_SNO", OracleDbType.Int32).Value = rxnStep.SerialNo;
oraCmd.Parameters.Add("PIN_YIELD", OracleDbType.Varchar2).Value = rxnStep.StepYield;
oraCmd.Parameters.Add("PIC_OPTION", OracleDbType.Varchar2).Value = dmlEnum.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_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(dtReactions);
}
if (paramStatus.Value != null)
{
strTemp = Convert.ToString(oraCmd.Parameters["POC_STATUS"].Value);
if (strTemp.ToUpper() == "UPDATE SUCCESS" && dmlEnum == DmlOperations.UPDATE)
{
blStatus = true;
}
else if (strTemp.ToUpper() == "INSERT SUCCESS" && dmlEnum == DmlOperations.INSERT)
{
blStatus = true;
}
else if (strTemp.ToUpper() == "DELETE SUCCESS" && dmlEnum == DmlOperations.DELETE)
{
blStatus = true;
}
}
dtResult = dtReactions;
return(blStatus);
}
}
}
catch (Exception)
{
throw;
}
dtResult = dtReactions;
return(blStatus);
}
public static bool SaveReactionInfo(DmlOperations dmlEnum, ReactionInfo rxnInfo, 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_REACTIONS";
oraCmd.CommandType = CommandType.StoredProcedure;
oraCmd.Parameters.Add("PIN_REACTION_ID", OracleDbType.Int32).Value = rxnInfo.ReactionID;
oraCmd.Parameters.Add("PIN_DOC_ID", OracleDbType.Int32).Value = rxnInfo.ShipmentRefID;
oraCmd.Parameters.Add("PIC_REACTION_SCHEME", OracleDbType.Clob).Value = rxnInfo.ReactionScheme;
oraCmd.Parameters.Add("PIN_REACTION_SNO", OracleDbType.Int32).Value = rxnInfo.ReactionSNo;
oraCmd.Parameters.Add("PIC_OPTION", OracleDbType.Varchar2).Value = dmlEnum.ToString();
oraCmd.Parameters.Add("PIC_RXN_COMMENTS", OracleDbType.Varchar2).Value = rxnInfo.RxnComments;
oraCmd.Parameters.Add("PIC_RXN_MAPPING_TYPE", OracleDbType.Varchar2).Value = rxnInfo.AtomMappingType;
oraCmd.Parameters.Add("PIC_COMPLETED_STATUS", OracleDbType.Varchar2).Value = rxnInfo.RxnCompleteStatus;
oraCmd.Parameters.Add("PIC_ROLE_NAME", OracleDbType.Varchar2).Value = rxnInfo.RoleName;
oraCmd.Parameters.Add("PIC_IS_IMPORTANT", OracleDbType.Varchar2).Value = rxnInfo.IsImportantRxn;
oraCmd.Parameters.Add("PIN_UR_ID", OracleDbType.Int32).Value = rxnInfo.UR_ID;
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_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(dtReactions);
}
if (paramStatus.Value != null)
{
if (paramStatus.Value.ToString().Length > 0)
{
strTemp = Convert.ToString(oraCmd.Parameters["POC_STATUS"].Value);
if (strTemp.ToUpper() == "UPDATE SUCCESS" && dmlEnum == DmlOperations.UPDATE)
{
blStatus = true;
}
else if (strTemp.ToUpper() == "INSERT SUCCESS" && dmlEnum == DmlOperations.INSERT)
{
blStatus = true;
}
else if (strTemp.ToUpper() == "DELETE SUCCESS" && dmlEnum == DmlOperations.DELETE)
{
blStatus = true;
}
}
}
dtResult = dtReactions;
return(blStatus);
}
}
}
catch (Exception)
{
throw;
}
return(blStatus);
}
public static bool SaveReactionProduct(ProductInfo prodInfo, 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_PRODUCTS";
oraCmd.CommandType = CommandType.StoredProcedure;
oraCmd.Parameters.Add("PIN_PRODUCT_ID", OracleDbType.Int32).Value = prodInfo.ProductID;
oraCmd.Parameters.Add("PIN_REACTION_ID", OracleDbType.Int32).Value = prodInfo.ReactionID;
oraCmd.Parameters.Add("PIC_PROD_STRUCTURE", OracleDbType.Clob).Value = prodInfo.Structure;
oraCmd.Parameters.Add("PIC_INCHI_KEY", OracleDbType.Varchar2).Value = prodInfo.InchiKey;
oraCmd.Parameters.Add("PIC_PRODUCT_NAME", OracleDbType.Varchar2).Value = prodInfo.ProductName;
oraCmd.Parameters.Add("PIC_STRUCTURE_NO", OracleDbType.Varchar2).Value = prodInfo.StructureNo;
oraCmd.Parameters.Add("PIC_YIELD", OracleDbType.Varchar2).Value = prodInfo.Yield;
oraCmd.Parameters.Add("PIC_CHEMO_SELECTIVITY", OracleDbType.Varchar2).Value = prodInfo.CS;
oraCmd.Parameters.Add("PIC_DIASTEREO_SELECTIVITY", OracleDbType.Varchar2).Value = prodInfo.DS;
oraCmd.Parameters.Add("PIC_DIASTEREOMERIC_EXCESS", OracleDbType.Varchar2).Value = prodInfo.DE;
oraCmd.Parameters.Add("PIC_ENANTIOMERIC_EXCESS", OracleDbType.Varchar2).Value = prodInfo.EE;
oraCmd.Parameters.Add("PIC_GRADE", OracleDbType.Varchar2).Value = prodInfo.ProductGrade;
oraCmd.Parameters.Add("PIC_OPTION", OracleDbType.Varchar2).Value = prodInfo.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_PROUCTS", 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);
}
public static bool SaveDeliveryDetails(Delivery delivery, out DataTable deliveryMasterTbl)
{
bool blStatus = false;
DataTable dtDeliveryMaster = null;
try
{
using (OracleCommand oraCmd = new OracleCommand())
{
oraCmd.Connection = ConnectionDB.GetOracleConnection();
oraCmd.CommandText = "DELIVERY_PKG.DELIVERY_INSERTS";
oraCmd.CommandType = CommandType.StoredProcedure;
oraCmd.Parameters.Add("PIC_DELIVERY_NAME", OracleDbType.Varchar2, 100).Value = delivery.DeliveryName;
oraCmd.Parameters.Add("PIN_DELIVERED_REFS_CNT", OracleDbType.Int32).Value = delivery.DeliveryRefCount;
oraCmd.Parameters.Add("PIN_DELIVERED_REACTION_CNT", OracleDbType.Int32).Value = delivery.DeliveryRxnCount;
oraCmd.Parameters.Add("PIN_MDL_START_NO", OracleDbType.Int32).Value = delivery.MDLStartNo;
oraCmd.Parameters.Add("PIN_MDL_END_NO", OracleDbType.Int32).Value = delivery.MDLEndNo;
OracleParameter opRefIDs = new OracleParameter();
opRefIDs.OracleDbType = OracleDbType.Int32;
opRefIDs.CollectionType = OracleCollectionType.PLSQLAssociativeArray;
opRefIDs.ParameterName = "PINA_SHIPMENT_REF_ID";
opRefIDs.Direction = ParameterDirection.Input;
if (delivery.DeliveryRefsList.Count == 0)
{
opRefIDs.Size = 0;
opRefIDs.Value = new string[1] {
""
};
}
else
{
opRefIDs.Size = delivery.DeliveryRefsList.Count;
opRefIDs.Value = delivery.DeliveryRefsList.ToArray();
}
oraCmd.Parameters.Add(opRefIDs);
OracleParameter opRefMdlStart = new OracleParameter();
opRefMdlStart.OracleDbType = OracleDbType.Int32;
opRefMdlStart.CollectionType = OracleCollectionType.PLSQLAssociativeArray;
opRefMdlStart.ParameterName = "PINA_MDL_START_NO";
opRefMdlStart.Direction = ParameterDirection.Input;
if (delivery.RefMdlStartNoList.Count == 0)
{
opRefMdlStart.Size = 0;
opRefMdlStart.Value = new string[1] {
""
};
}
else
{
opRefMdlStart.Size = delivery.RefMdlStartNoList.Count;
opRefMdlStart.Value = delivery.RefMdlStartNoList.ToArray();
}
oraCmd.Parameters.Add(opRefMdlStart);
OracleParameter opRefMdlEnd = new OracleParameter();
opRefMdlEnd.OracleDbType = OracleDbType.Int32;
opRefMdlEnd.CollectionType = OracleCollectionType.PLSQLAssociativeArray;
opRefMdlEnd.ParameterName = "PINA_MDL_END_NO";
opRefMdlEnd.Direction = ParameterDirection.Input;
if (delivery.RefMdlEndNoList.Count == 0)
{
opRefMdlEnd.Size = 0;
opRefMdlEnd.Value = new string[1] {
""
};
}
else
{
opRefMdlEnd.Size = delivery.RefMdlEndNoList.Count;
opRefMdlEnd.Value = delivery.RefMdlEndNoList.ToArray();
}
oraCmd.Parameters.Add(opRefMdlEnd);
oraCmd.Parameters.Add("PIN_UR_ID", OracleDbType.Int32).Value = delivery.Urid;
OracleParameter paramStatus = new OracleParameter();
paramStatus.ParameterName = "POC_STATUS";
paramStatus.Direction = ParameterDirection.Output;
paramStatus.OracleDbType = OracleDbType.Varchar2;
paramStatus.Size = 300;
oraCmd.Parameters.Add(paramStatus);
oraCmd.Parameters.Add("PORC_DELIVERIES", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
dtDeliveryMaster = new DataTable();
OracleDataAdapter oraAdpt = new OracleDataAdapter(oraCmd);
oraAdpt.Fill(dtDeliveryMaster);
if (paramStatus.Value != null)
{
if (!string.IsNullOrEmpty(paramStatus.Value.ToString()))
{
if (paramStatus.Value.ToString().ToUpper() == "SUCCESS")
{
blStatus = true;
}
else
{
blStatus = false;
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
deliveryMasterTbl = dtDeliveryMaster;
return(blStatus);
}
