public SpecialHandlingCode GetRecordSpecialHandlingCode(string recordID, string UserSNo)
{
SqlDataReader dr = null;
try
{
SpecialHandlingCode g = new SpecialHandlingCode();
SqlParameter[] Parameters = { new SqlParameter("@SNo", Convert.ToInt32(recordID)), new SqlParameter("@UserID", Convert.ToInt32(UserSNo)) };
dr = SqlHelper.ExecuteReader(ReadConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "GetRecordSPHC", Parameters);
if (dr.Read())
{
g.SNo = Convert.ToInt32(dr["SNo"]);
g.Code = dr["Code"].ToString().ToString().ToUpper();
g.IsDGR = Convert.ToBoolean(dr["IsDGR"]);
g.DGR = dr["DGR"].ToString().ToUpper();
g.Description = dr["Description"].ToString().ToUpper();
g.IsShownInNOTOC = Convert.ToBoolean(dr["IsShownInNOTOC"].ToString());
g.ShownInNOTOC = dr["ShownInNOTOC"].ToString().ToUpper();
g.IsHeavyWeightExempt = Convert.ToBoolean(dr["IsHeavyWeightExempt"].ToString());
g.HeavyWeightExempt = dr["HeavyWeightExempt"].ToString().ToUpper();
g.IsExpress = Convert.ToBoolean(dr["IsExpress"].ToString());
g.Express = dr["Express"].ToString().ToUpper();
g.Priority = Decimal.Parse(dr["Priority"].ToString()); //Convert.ToDecimal("10.00");
g.IsActive = Convert.ToBoolean(dr["IsActive"].ToString());
g.Active = dr["Active"].ToString().ToUpper();
g.IsTemperatureControlled = Convert.ToBoolean(dr["IsTemperatureControlled"].ToString());
g.TemperatureControlled = dr["TemperatureControlled"].ToString().ToUpper();
g.ExpressDelivery = dr["IsExpressDelivery"].ToString() == "No" ? "NO" : "YES";
g.IsExpressDelivery = Convert.ToBoolean(dr["ExpressDelivery"]) == false ? false : true;
g.DGClass = dr["DGClass"] == DBNull.Value ? 0 : Convert.ToInt32(dr["DGClass"]);
g.Divisions = dr["Division"].ToString().ToUpper();
g.Text_DGClass = dr["Text_DGClass"].ToString().ToUpper();
g.Text_Divisions = dr["Text_Division"].ToString().ToUpper();
g.SHCStatement = dr["SHCStatement"].ToString().ToUpper();
g.MandatoryStatement = dr["MandatoryStatement"].ToString().ToUpper();
g.StatementLabel = dr["StatementLabel"].ToString().ToUpper();
g.PackingInstructionLabel = dr["PackingInstructionLabel"].ToString().ToUpper();
g.IsAllowLateAcceptance = Convert.ToBoolean(dr["IsAllowLateAcceptance"].ToString());
g.AllowLateAcceptance = dr["AllowLateAcceptance"].ToString().ToUpper();
g.UpdatedBy = dr["UpdatedUser"].ToString();
g.CreatedBy = dr["CreatedUser"].ToString();
}
dr.Close();
return(g);
}
catch (Exception ex)//
{
dr.Close();
throw ex;
}
}
/// <inheritdoc/>
public string ToDelimitedString()
{
CultureInfo culture = CultureInfo.CurrentCulture;
return(string.Format(
culture,
StringHelper.StringFormatSequence(0, 39, Configuration.FieldSeparator),
Id,
ItemIdentifier?.ToDelimitedString(),
ItemDescription,
ItemStatus?.ToDelimitedString(),
ItemType?.ToDelimitedString(),
ItemCategory?.ToDelimitedString(),
SubjectToExpirationIndicator?.ToDelimitedString(),
ManufacturerIdentifier?.ToDelimitedString(),
ManufacturerName,
ManufacturerCatalogNumber,
ManufacturerLabelerIdentificationCode?.ToDelimitedString(),
PatientChargeableIndicator?.ToDelimitedString(),
TransactionCode?.ToDelimitedString(),
TransactionAmountUnit?.ToDelimitedString(),
StockedItemIndicator?.ToDelimitedString(),
SupplyRiskCodes?.ToDelimitedString(),
ApprovingRegulatoryAgency != null ? string.Join(Configuration.FieldRepeatSeparator, ApprovingRegulatoryAgency.Select(x => x.ToDelimitedString())) : null,
LatexIndicator?.ToDelimitedString(),
RulingAct != null ? string.Join(Configuration.FieldRepeatSeparator, RulingAct.Select(x => x.ToDelimitedString())) : null,
ItemNaturalAccountCode?.ToDelimitedString(),
ApprovedToBuyQuantity.HasValue ? ApprovedToBuyQuantity.Value.ToString(Consts.NumericFormat, culture) : null,
ApprovedToBuyPrice?.ToDelimitedString(),
TaxableItemIndicator?.ToDelimitedString(),
FreightChargeIndicator?.ToDelimitedString(),
ItemSetIndicator?.ToDelimitedString(),
ItemSetIdentifier?.ToDelimitedString(),
TrackDepartmentUsageIndicator?.ToDelimitedString(),
ProcedureCode?.ToDelimitedString(),
ProcedureCodeModifier != null ? string.Join(Configuration.FieldRepeatSeparator, ProcedureCodeModifier.Select(x => x.ToDelimitedString())) : null,
SpecialHandlingCode?.ToDelimitedString(),
HazardousIndicator?.ToDelimitedString(),
SterileIndicator?.ToDelimitedString(),
MaterialDataSafetySheetNumber?.ToDelimitedString(),
UnitedNationsStandardProductsAndServicesCode?.ToDelimitedString(),
ContractDate?.ToDelimitedString(),
ManufacturerContactName?.ToDelimitedString(),
ManufacturerContactInformation?.ToDelimitedString(),
ClassOfTrade,
FieldLevelEventCode
).TrimEnd(Configuration.FieldSeparator.ToCharArray()));
}
/// <inheritdoc/>
public string ToDelimitedString()
{
CultureInfo culture = CultureInfo.CurrentCulture;
return(string.Format(
culture,
StringHelper.StringFormatSequence(0, 45, Configuration.FieldSeparator),
Id,
ExternalAccessionIdentifier?.ToDelimitedString(),
AccessionIdentifier?.ToDelimitedString(),
ContainerIdentifier?.ToDelimitedString(),
PrimaryParentContainerIdentifier?.ToDelimitedString(),
EquipmentContainerIdentifier?.ToDelimitedString(),
SpecimenSource?.ToDelimitedString(),
RegistrationDateTime.HasValue ? RegistrationDateTime.Value.ToString(Consts.DateTimeFormatPrecisionSecond, culture) : null,
ContainerStatus?.ToDelimitedString(),
CarrierType?.ToDelimitedString(),
CarrierIdentifier?.ToDelimitedString(),
PositionInCarrier?.ToDelimitedString(),
TrayTypeSac?.ToDelimitedString(),
TrayIdentifier?.ToDelimitedString(),
PositionInTray?.ToDelimitedString(),
Location != null ? string.Join(Configuration.FieldRepeatSeparator, Location.Select(x => x.ToDelimitedString())) : null,
ContainerHeight.HasValue ? ContainerHeight.Value.ToString(Consts.NumericFormat, culture) : null,
ContainerDiameter.HasValue ? ContainerDiameter.Value.ToString(Consts.NumericFormat, culture) : null,
BarrierDelta.HasValue ? BarrierDelta.Value.ToString(Consts.NumericFormat, culture) : null,
BottomDelta.HasValue ? BottomDelta.Value.ToString(Consts.NumericFormat, culture) : null,
ContainerHeightDiameterDeltaUnits?.ToDelimitedString(),
ContainerVolume.HasValue ? ContainerVolume.Value.ToString(Consts.NumericFormat, culture) : null,
AvailableSpecimenVolume.HasValue ? AvailableSpecimenVolume.Value.ToString(Consts.NumericFormat, culture) : null,
InitialSpecimenVolume.HasValue ? InitialSpecimenVolume.Value.ToString(Consts.NumericFormat, culture) : null,
VolumeUnits?.ToDelimitedString(),
SeparatorType?.ToDelimitedString(),
CapType?.ToDelimitedString(),
Additive != null ? string.Join(Configuration.FieldRepeatSeparator, Additive.Select(x => x.ToDelimitedString())) : null,
SpecimenComponent?.ToDelimitedString(),
DilutionFactor?.ToDelimitedString(),
Treatment?.ToDelimitedString(),
Temperature?.ToDelimitedString(),
HemolysisIndex.HasValue ? HemolysisIndex.Value.ToString(Consts.NumericFormat, culture) : null,
HemolysisIndexUnits?.ToDelimitedString(),
LipemiaIndex.HasValue ? LipemiaIndex.Value.ToString(Consts.NumericFormat, culture) : null,
LipemiaIndexUnits?.ToDelimitedString(),
IcterusIndex.HasValue ? IcterusIndex.Value.ToString(Consts.NumericFormat, culture) : null,
IcterusIndexUnits?.ToDelimitedString(),
FibrinIndex.HasValue ? FibrinIndex.Value.ToString(Consts.NumericFormat, culture) : null,
FibrinIndexUnits?.ToDelimitedString(),
SystemInducedContaminants != null ? string.Join(Configuration.FieldRepeatSeparator, SystemInducedContaminants.Select(x => x.ToDelimitedString())) : null,
DrugInterference != null ? string.Join(Configuration.FieldRepeatSeparator, DrugInterference.Select(x => x.ToDelimitedString())) : null,
ArtificialBlood?.ToDelimitedString(),
SpecialHandlingCode != null ? string.Join(Configuration.FieldRepeatSeparator, SpecialHandlingCode.Select(x => x.ToDelimitedString())) : null,
OtherEnvironmentalFactors != null ? string.Join(Configuration.FieldRepeatSeparator, OtherEnvironmentalFactors.Select(x => x.ToDelimitedString())) : null
).TrimEnd(Configuration.FieldSeparator.ToCharArray()));
}