public List <InstructionDetail> GetPreTracers(string referenceNumber)
{
InstructionDetail model = new InstructionDetail {
FilterReferenceNumber = referenceNumber
};
List <InstructionDetail> result = new List <InstructionDetail>();
try
{
result = Shared.da.ExecuteQuery <InstructionDetail>("sp_SpotsInstructions_PreTracers", model);
}
catch (SqlException sqlexp)
{
if (log.IsErrorEnabled)
{
log.Error(sqlexp.ToString());
}
}
catch (Exception exp)
{
if (log.IsErrorEnabled)
{
log.Error(exp.ToString());
}
}
return(result);
}
public List <InstructionDetail> ShowDetails(string referenceNumber)
{
InstructionDetail searchInstruction = new InstructionDetail {
FilterReferenceNumber = referenceNumber
};
List <InstructionDetail> result = null;
try
{
result = Shared.da.ExecuteQuery <InstructionDetail>("sp_SPOTS_Instructions_ShowDetails", searchInstruction);
}
catch (SqlException sqlexp)
{
if (log.IsErrorEnabled)
{
log.Error(sqlexp.ToString());
}
}
catch (Exception exp)
{
if (log.IsErrorEnabled)
{
log.Error(exp.ToString());
}
}
return(result);
}
