public PNDTMsg AddPNDTest(AddPNDTestRequest aData)
{
string stProc = AddPNDTestData;
var pList = new List <SqlParameter>()
{
new SqlParameter("@PrePNDTCounsellingId", aData.prePNDTCounsellingId),
new SqlParameter("@ANWSubjectId", aData.anwsubjectId ?? aData.anwsubjectId),
new SqlParameter("@SpouseSubjectId", aData.spouseSubjectId ?? aData.spouseSubjectId),
new SqlParameter("@PNDTDateTime", aData.pndtDateTime ?? aData.pndtDateTime),
new SqlParameter("@CounsellorId", aData.counsellorId),
new SqlParameter("@ObstetricianId", aData.obstetricianId),
new SqlParameter("@ClinicalHistory", aData.clinicalHistory ?? aData.clinicalHistory),
new SqlParameter("@Examination", aData.examination ?? aData.examination),
new SqlParameter("@ProcedureOfTestingId", aData.procedureOfTestingId),
new SqlParameter("@OthersPOT", aData.othersProcedureofTesting ?? aData.othersProcedureofTesting),
new SqlParameter("@PNDTComplecationsId", aData.pndtComplecationsId ?? aData.pndtComplecationsId),
new SqlParameter("@OthersComplecations", aData.othersComplecations ?? aData.othersComplecations),
new SqlParameter("@PNDTDiagnosisId", aData.pndtDiagnosisId),
new SqlParameter("@PNDTResultId", aData.pndtResultId),
new SqlParameter("@MotherVoided", aData.motherVoided ?? aData.motherVoided),
new SqlParameter("@MotherVitalStable", aData.motherVitalStable ?? aData.motherVitalStable),
new SqlParameter("@FoetalHeartRateDocumentScan", aData.foetalHeartRateDocumentScan ?? aData.foetalHeartRateDocumentScan),
new SqlParameter("@PlanForPregnencyContinue", aData.planForPregnencyContinue ?? aData.planForPregnencyContinue),
new SqlParameter("@IsCompletePNDT", aData.isCompletePNDT),
new SqlParameter("@CreatedBy", aData.userId),
};
var schedulingData = UtilityDL.FillEntity <PNDTMsg>(stProc, pList);
return(schedulingData);
}
public SubjectRegDetail MobileSubjectRegDetail(int userId)
{
string stProc = FetchMobileSubjectsDetail;
string stProc1 = FetchANMMobilePrePNDTCounselling;
string stProc2 = FetchANMMobilePNDTesting;
string stProc3 = FetchANMMobilePostPNDTCounselling;
string stProc4 = FetchANMMobileMTPService;
var pList = new List <SqlParameter>()
{
new SqlParameter("@UserId", userId)
};
var allPrimaryData = UtilityDL.FillData <SubjectPrimary>(stProc, pList);
var allAddressData = UtilityDL.FillData <SubjectAddress>(stProc, pList);
var allPregnancyData = UtilityDL.FillData <SubjectPregnancy>(stProc, pList);
var allParentData = UtilityDL.FillData <SubjectParent>(stProc, pList);
var allResults = UtilityDL.FillData <TestResult>(stProc, pList);
var allPrPC = UtilityDL.FillData <MobilePrePNDTCounselling>(stProc1, pList);
var allPNDTTest = UtilityDL.FillData <MobilePNDTesting>(stProc2, pList);
var allPoPC = UtilityDL.FillData <MobilePostPNDTCounselling>(stProc3, pList);
var allMTP = UtilityDL.FillData <MobileMTPService>(stProc4, pList);
var subDetail = new SubjectRegDetail();
subDetail.PrimarySubjectList = allPrimaryData;
subDetail.AddressSubjectList = allAddressData;
subDetail.PregnancySubjectList = allPregnancyData;
subDetail.ParentSubjectList = allParentData;
subDetail.Results = allResults;
subDetail.prePndtCounselling = allPrPC;
subDetail.pndtTesting = allPNDTTest;
subDetail.postPndtCounselling = allPoPC;
subDetail.mtpService = allMTP;
return(subDetail);
}
public MobileChartDetail FetchMobileChartDetail(int userId)
{
string stProc = FetchMobileChartSubjectCount;
string stProc1 = FetchMobileChartSampleCollectionCount;
string stProc2 = FetchMobileChartCHCPositiveCount;
string stProc3 = FetchMobileChartHPLCPositiveCount;
string stProc4 = FetchMobileChartPNDTAcceptedCount;
string stProc5 = FetchMobileChartPNDTCompletedCount;
string stProc6 = FetchMobileChartMTPAcceptedCount;
string stProc7 = FetchMobileChartMTPCompletedCount;
var pList = new List <SqlParameter>()
{
new SqlParameter("@UserId", userId)
};
var registrations = UtilityDL.FillData <MobileCharts>(stProc, pList);
var samples = UtilityDL.FillData <MobileCharts>(stProc1, pList);
var chc = UtilityDL.FillData <MobileCharts>(stProc2, pList);
var hplc = UtilityDL.FillData <MobileCharts>(stProc3, pList);
var pndtAccepted = UtilityDL.FillData <MobileCharts>(stProc4, pList);
var pndtCompleted = UtilityDL.FillData <MobileCharts>(stProc5, pList);
var mtpAccepted = UtilityDL.FillData <MobileCharts>(stProc6, pList);
var mtpCompleted = UtilityDL.FillData <MobileCharts>(stProc7, pList);
var allCharts = new MobileChartDetail();
allCharts.registration = registrations;
allCharts.sampleCollection = samples;
allCharts.chcsstPositive = chc;
allCharts.hplcPositive = hplc;
allCharts.pndtAccepted = pndtAccepted;
allCharts.pndtCompleted = pndtCompleted;
allCharts.mtpReffered = mtpAccepted;
allCharts.mtpCompleted = mtpCompleted;
return(allCharts);
}
public void SubjectAddress(AddressDetailRequest saData)
{
try
{
var stProc = AddSubjectAddressDetail;
var retVal = new SqlParameter("@SCOPE_OUTPUT", 1)
{
Direction = ParameterDirection.Output
};
var pList = new List <SqlParameter>()
{
new SqlParameter("@UniqueSubjectID", saData.uniqueSubjectId ?? saData.uniqueSubjectId),
new SqlParameter("@Religion_Id", Convert.ToInt32(saData.religionId)),
new SqlParameter("@Caste_Id", Convert.ToInt32(saData.casteId)),
new SqlParameter("@Community_Id", Convert.ToInt32(saData.communityId)),
new SqlParameter("@Address1", saData.address1.ToCheckNull()),
new SqlParameter("@Address2", saData.address2.ToCheckNull()),
new SqlParameter("@Address3", saData.address3.ToCheckNull()),
new SqlParameter("@Pincode", saData.pincode.ToCheckNull()),
new SqlParameter("@StateName", saData.stateName.ToCheckNull()),
new SqlParameter("@UpdatedBy", Convert.ToInt32(saData.updatedBy)),
retVal
};
UtilityDL.ExecuteNonQuery(stProc, pList);
}
catch (Exception ex)
{
throw ex;
}
}
public void SampleColection(SampleCollectionsRequest ssData)
{
try
{
var stProc = AddSampleCollection;
var retVal = new SqlParameter("@SCOPE_OUTPUT", 1)
{
Direction = ParameterDirection.Output
};
var pList = new List <SqlParameter>()
{
new SqlParameter("@UniqueSubjectID", ssData.uniqueSubjectId ?? ssData.uniqueSubjectId),
new SqlParameter("@BarcodeNo", ssData.barcodeNo ?? ssData.barcodeNo),
new SqlParameter("@SampleCollectionDate", ssData.sampleCollectionDate ?? ssData.sampleCollectionDate),
new SqlParameter("@SampleCollectionTime", ssData.sampleCollectionTime ?? ssData.sampleCollectionTime),
new SqlParameter("@Reason", ssData.reason ?? ssData.reason),
new SqlParameter("@CollectionFrom", ssData.collectionFrom),
new SqlParameter("@CollectedBy", ssData.collectedBy),
retVal
};
UtilityDL.ExecuteNonQuery(stProc, pList);
}
catch (Exception ex)
{
throw ex;
}
}
public List <CentralLabShipmentId> AddCentralLabShipment(AddCentralLabShipmentRequest csData)
{
try
{
string stProc = AddCentralLabShipments;
var pList = new List <SqlParameter>
{
new SqlParameter("@BarcodeNo", csData.barcodeNo ?? csData.barcodeNo),
new SqlParameter("@LabTechnicianName", csData.labTechnicianName ?? csData.labTechnicianName),
new SqlParameter("@CentralLabUserId", csData.centralLabUserId),
new SqlParameter("@CentralLabId", csData.centralLabId),
new SqlParameter("@CentralLabLocation", csData.centralLabLocation ?? csData.centralLabLocation),
new SqlParameter("@ReceivingMolecularLabId", csData.receivingMolecularLabId),
new SqlParameter("@LogisticsProviderName", csData.logisticsProviderName ?? csData.logisticsProviderName),
new SqlParameter("@DeliveryExecutiveName", csData.deliveryExecutiveName ?? csData.deliveryExecutiveName),
new SqlParameter("@ExecutiveContactNo", csData.executiveContactNo ?? csData.executiveContactNo),
new SqlParameter("@DateofShipment", csData.dateOfShipment ?? csData.dateOfShipment),
new SqlParameter("@TimeofShipment", csData.timeOfShipment ?? csData.timeOfShipment),
new SqlParameter("@Source", csData.source ?? csData.source),
};
var allData = UtilityDL.FillData <CentralLabShipmentId>(stProc, pList);
return(allData);
}
catch (Exception e)
{
throw e;
}
}
public BabyReturnDetail UpdateBaby(UpdateBabyRequest brData)
{
try
{
string stProc = UpdateBabyProfile;
var pList = new List <SqlParameter>
{
new SqlParameter("@BabySubjectId", brData.babySubjectId),
new SqlParameter("@HospitalNo", brData.hospitalNo ?? brData.hospitalNo),
new SqlParameter("@BabyFirstName", brData.babyFirstName.ToCheckNull()),
new SqlParameter("@BabyLastName", brData.babyLastName.ToCheckNull()),
new SqlParameter("@Gender", brData.gender.ToCheckNull()),
new SqlParameter("@BirthWeight", brData.birthWeight ?? brData.birthWeight),
new SqlParameter("@DeliveryDateTime", brData.deliveryDateTime ?? brData.deliveryDateTime),
new SqlParameter("@StatusofBirth", brData.statusOfBirth),
new SqlParameter("@UserId", brData.userId),
};
var babyDetail = UtilityDL.FillEntity <BabyReturnDetail>(stProc, pList);
return(babyDetail);
}
catch (Exception e)
{
throw e;
}
}
public AddUpdateMaster UpdateRIDetail(UpdateRISiteRequest data)
{
try
{
string stProc = UpdateRISite;
var pList = new List <SqlParameter>
{
new SqlParameter("@ID", data.id),
new SqlParameter("@CHCID", data.chcId),
new SqlParameter("@PHCID", data.phcId),
new SqlParameter("@SCID", data.scId),
new SqlParameter("@TestingCHCId", data.testingCHCId),
new SqlParameter("@RI_gov_code", data.riGovCode),
new SqlParameter("@RISite", data.name ?? data.name),
new SqlParameter("@Pincode", data.pincode.ToCheckNull()),
new SqlParameter("@ILRId", data.ilrId),
new SqlParameter("@IsActive", data.isActive),
new SqlParameter("@Latitude", data.latitude.ToCheckNull()),
new SqlParameter("@Longitude", data.longitude.ToCheckNull()),
new SqlParameter("@Comments", data.comments.ToCheckNull()),
new SqlParameter("@UserId", data.userId),
};
var returnData = UtilityDL.FillEntity <AddUpdateMaster>(stProc, pList);
return(returnData);
}
catch (Exception e)
{
throw e;
}
}
public ANMCreation AddNewANM(AddANMRequest addUser, string password)
{
try
{
var stProc = AddANMUser;
var pList = new List <SqlParameter>()
{
new SqlParameter("@User_gov_code", addUser.userGovCode),
new SqlParameter("@Password", password),
new SqlParameter("@DistrictID", addUser.districtId),
new SqlParameter("@BlockID", addUser.blockId),
new SqlParameter("@CHCID", addUser.chcId),
new SqlParameter("@PHCID", addUser.phcId),
new SqlParameter("@SCID", addUser.scId),
new SqlParameter("@RIID", addUser.riId ?? addUser.riId),
new SqlParameter("@FirstName", addUser.firstName ?? addUser.firstName),
new SqlParameter("@MiddleName", addUser.middleName.ToCheckNull()),
new SqlParameter("@LastName", addUser.lastName.ToCheckNull()),
new SqlParameter("@ContactNo1", addUser.contactNo1 ?? addUser.contactNo1),
new SqlParameter("@ContactNo2", addUser.contactNo2.ToCheckNull()),
new SqlParameter("@Email", addUser.email.ToCheckNull()),
new SqlParameter("@GovIDType_ID", addUser.govIdTypeId),
new SqlParameter("@GovIDDetails", addUser.govIdDetails.ToCheckNull()),
new SqlParameter("@Address", addUser.address.ToCheckNull()),
new SqlParameter("@Pincode", addUser.pincode.ToCheckNull()),
new SqlParameter("@UserId", addUser.userId),
};
var allData = UtilityDL.FillEntity <ANMCreation>(stProc, pList);
return(allData);
}
catch (Exception ex)
{
throw ex;
}
}
public AddUpdateMaster UpdateCHCDetail(UpdateCHCRequest data)
{
try
{
string stProc = UpdateCHC;
var pList = new List <SqlParameter>
{
new SqlParameter("@Id", data.id),
new SqlParameter("@BlockID", data.blockId),
new SqlParameter("@DistrictID", data.districtId),
new SqlParameter("@HNIN_ID", data.hninId ?? data.hninId),
new SqlParameter("@CHC_gov_code", data.chcGovCode),
new SqlParameter("@CHCname", data.name ?? data.name),
new SqlParameter("@Istestingfacility", data.isTestingFacility),
new SqlParameter("@TestingCHCID", data.testingCHCId),
new SqlParameter("@CentralLabId", data.centralLabId),
new SqlParameter("@IsActive", data.isActive),
new SqlParameter("@Pincode", data.pincode.ToCheckNull()),
new SqlParameter("@Latitude", data.latitude.ToCheckNull()),
new SqlParameter("@Longitude", data.longitude.ToCheckNull()),
new SqlParameter("@Comments", data.comments.ToCheckNull()),
new SqlParameter("@UserId", data.userId),
};
var returnData = UtilityDL.FillEntity <AddUpdateMaster>(stProc, pList);
return(returnData);
}
catch (Exception e)
{
throw e;
}
}
public AddUpdateMaster UpdateSCDetail(UpdateSCRequest data)
{
try
{
string stProc = UpdateSC;
var pList = new List <SqlParameter>
{
new SqlParameter("@ID", data.id),
new SqlParameter("@CHCID", data.chcId),
new SqlParameter("@PHCID", data.phcId),
new SqlParameter("@SC_gov_code", data.scGovCode),
new SqlParameter("@SCname", data.name ?? data.name),
new SqlParameter("@HNIN_ID", data.hninId ?? data.hninId),
new SqlParameter("@Pincode", data.pincode.ToCheckNull()),
new SqlParameter("@SCAddress", data.scAddress.ToCheckNull()),
new SqlParameter("@IsActive", data.isActive),
new SqlParameter("@Latitude", data.latitude.ToCheckNull()),
new SqlParameter("@Longitude", data.longitude.ToCheckNull()),
new SqlParameter("@Comments", data.comments.ToCheckNull()),
new SqlParameter("@UserId", data.userId),
};
var returnData = UtilityDL.FillEntity <AddUpdateMaster>(stProc, pList);
return(returnData);
}
catch (Exception e)
{
throw e;
}
}
public string AddSampleRecollection(SampleRecollectionRequest srData)
{
try
{
string stProc = AddANMSampleRecollection;
var retVal = new SqlParameter("@Scope_output", 1);
retVal.Direction = ParameterDirection.Output;
var pList = new List <SqlParameter>
{
new SqlParameter("@UniqueSubjectID", srData.uniqueSubjectId ?? srData.uniqueSubjectId),
new SqlParameter("@BarcodeNo", srData.barcodeNo ?? srData.barcodeNo),
new SqlParameter("@SampleCollectionDate", srData.sampleCollectionDate ?? srData.sampleCollectionDate),
new SqlParameter("@SampleCollectionTime", srData.sampleCollectionTime ?? srData.sampleCollectionTime),
new SqlParameter("@Reason", srData.reason ?? srData.reason),
new SqlParameter("@CollectionFrom", srData.collectionFrom),
new SqlParameter("@CollectedBy", srData.collectedBy),
retVal
};
UtilityDL.ExecuteNonQuery(stProc, pList);
return($"Sample recollected successfully");
}
catch (Exception e)
{
throw e;
}
}
public List <ANMCHCShipmentID> AddANMCHCShipment(AddShipmentANMCHCRequest asData)
{
try
{
string stProc = AddShipment;
var pList = new List <SqlParameter>
{
new SqlParameter("@BarcodeNo", asData.barcodeNo ?? asData.barcodeNo),
new SqlParameter("@ShipmentFrom", asData.shipmentFrom),
new SqlParameter("@ANM_ID", asData.anmId),
new SqlParameter("@RIID", asData.riId),
new SqlParameter("@ILR_ID", asData.ilrId),
new SqlParameter("@AVDID", asData.avdId),
new SqlParameter("@AVDContactNo", asData.avdContactNo ?? asData.avdContactNo),
new SqlParameter("@AlternateAVD", asData.alternateAVD.ToCheckNull()),
new SqlParameter("@AlternateAVDContactNo", asData.alternateAVDContactNo.ToCheckNull()),
new SqlParameter("@TestingCHCID", asData.testingCHCId),
new SqlParameter("@DateofShipment", asData.dateOfShipment ?? asData.dateOfShipment),
new SqlParameter("@TimeofShipment", asData.timeOfShipment ?? asData.timeOfShipment),
new SqlParameter("@Createdby", asData.createdBy),
new SqlParameter("@Source", asData.source ?? asData.source),
};
var allData = UtilityDL.FillData <ANMCHCShipmentID>(stProc, pList);
return(allData);
}
catch (Exception e)
{
throw e;
}
}
public PNDTMsg AddPNDTestNew(AddPNDTRequest aData)
{
string stProc = AddPNDT;
var pList = new List <SqlParameter>()
{
new SqlParameter("@PrePNDTCounsellingId", aData.prePNDTCounsellingId),
new SqlParameter("@ANWSubjectId", aData.anwsubjectId ?? aData.anwsubjectId),
new SqlParameter("@SpouseSubjectId", aData.spouseSubjectId ?? aData.spouseSubjectId),
new SqlParameter("@PNDTDateTime", aData.pndtDateTime ?? aData.pndtDateTime),
new SqlParameter("@CounsellorId", aData.counsellorId),
new SqlParameter("@ObstetricianId", aData.obstetricianId),
new SqlParameter("@ClinicalHistory", aData.clinicalHistory ?? aData.clinicalHistory),
new SqlParameter("@Examination", aData.examination ?? aData.examination),
new SqlParameter("@ProcedureOfTestingId", aData.procedureOfTestingId),
new SqlParameter("@OthersPOT", aData.othersProcedureofTesting ?? aData.othersProcedureofTesting),
new SqlParameter("@PNDTComplecationsId", aData.pndtComplecationsId ?? aData.pndtComplecationsId),
new SqlParameter("@OthersComplecations", aData.othersComplecations ?? aData.othersComplecations),
new SqlParameter("@MotherVoided", aData.motherVoided),
new SqlParameter("@MotherVitalStable", aData.motherVitalStable),
new SqlParameter("@FoetalHeartRateDocumentScan", aData.foetalHeartRateDocumentScan),
new SqlParameter("@UserId", aData.userId),
new SqlParameter("@PregnancyType", aData.pregnancyType),
new SqlParameter("@SampleRefId", aData.sampleRefId ?? aData.sampleRefId),
new SqlParameter("@FoetusName", aData.foetusName ?? aData.foetusName),
new SqlParameter("@CVSSampleRefId", aData.cvsSampleRefId ?? aData.cvsSampleRefId),
new SqlParameter("@PNDTLocationId", aData.pndtLocationId),
new SqlParameter("@AssistedBy", aData.assistedBy ?? aData.assistedBy),
};
var pndtTest = UtilityDL.FillEntity <PNDTMsg>(stProc, pList);
return(pndtTest);
}
public List <CHCShipmentID> AddCHCShipment(AddCHCShipmentRequest csData)
{
try
{
string stProc = AddCHCShipments;
var pList = new List <SqlParameter>
{
new SqlParameter("@BarcodeNo", csData.barcodeNo ?? csData.barcodeNo),
new SqlParameter("@LabTechnicianName", csData.labTechnicianName ?? csData.labTechnicianName),
new SqlParameter("@CHCUserID", csData.chcUserId),
new SqlParameter("@TestingCHCID", csData.testingCHCId),
new SqlParameter("@ReceivingCentralLabId", csData.receivingCentralLabId),
new SqlParameter("@LogicsProviderID", csData.logisticsProviderId),
new SqlParameter("@DeliveryExecutiveName", csData.deliveryExecutiveName ?? csData.deliveryExecutiveName),
new SqlParameter("@ExecutiveContactNo", csData.executiveContactNo ?? csData.executiveContactNo),
new SqlParameter("@DateofShipment", csData.dateOfShipment ?? csData.dateOfShipment),
new SqlParameter("@TimeofShipment", csData.timeOfShipment ?? csData.timeOfShipment),
new SqlParameter("@Createdby", csData.createdBy),
new SqlParameter("@Source", csData.source ?? csData.source),
};
var allData = UtilityDL.FillData <CHCShipmentID>(stProc, pList);
return(allData);
}
catch (Exception e)
{
throw e;
}
}
public BabyRegistration AddBabyDetail(AddBabyRequest brData)
{
try
{
string stProc = AddBabysDetail;
var pList = new List <SqlParameter>
{
new SqlParameter("@MothersSubjectId", brData.mothersSubjectId ?? brData.mothersSubjectId),
new SqlParameter("@TypeofBaby", brData.typeofBaby),
new SqlParameter("@BabySubjectId", brData.babySubjectId.ToCheckNull()),
new SqlParameter("@DateOfRegistration", brData.dateOfRegisteration ?? brData.dateOfRegisteration),
new SqlParameter("@HospitalId", brData.hospitalId),
new SqlParameter("@HospitalNo", brData.hospitalNo ?? brData.hospitalNo),
new SqlParameter("@BabyName", brData.babyName ?? brData.babyName),
new SqlParameter("@Gender", brData.gender.ToCheckNull()),
new SqlParameter("@BirthWeight", brData.birthWeight ?? brData.birthWeight),
new SqlParameter("@DeliveryDateTime", brData.deliveryDateTime ?? brData.deliveryDateTime),
new SqlParameter("@StatusofBirth", brData.statusOfBirth),
new SqlParameter("@CreatedBy", brData.userId),
};
var babyDetail = UtilityDL.FillEntity <BabyRegistration>(stProc, pList);
return(babyDetail);
}
catch (Exception e)
{
throw e;
}
}
public void AddReceivedShipment(AddReceivedShipmentRequest rsData)
{
try
{
var stProc = AddCHCReceipt;
var pList = new List <SqlParameter>()
{
new SqlParameter("@ShipmentId", rsData.shipmentId ?? rsData.shipmentId),
new SqlParameter("@ReceivedDate", rsData.receivedDate ?? rsData.receivedDate),
new SqlParameter("@ProcessingDateTime", rsData.proceesingDateTime ?? rsData.proceesingDateTime),
new SqlParameter("@ILRInDateTime", rsData.ilrInDateTime ?? rsData.ilrInDateTime),
new SqlParameter("@ILROutDateTime", rsData.ilrOutDateTime ?? rsData.ilrOutDateTime),
new SqlParameter("@SampleDamaged", rsData.sampleDamaged),
new SqlParameter("@SampleTimeout", rsData.sampleTimeout),
new SqlParameter("@BarcodeDamaged", rsData.barcodeDamaged),
new SqlParameter("@IsAccept", rsData.isAccept),
new SqlParameter("@Barcode", rsData.barcodeNo ?? rsData.barcodeNo),
new SqlParameter("@UpdatedBy", rsData.updatedBy),
};
UtilityDL.ExecuteNonQuery(stProc, pList);
}
catch (Exception ex)
{
throw ex;
}
}
public void SubjectPregnancy(PregnancyDetailRequest spData)
{
try
{
var stProc = AddSubjectPregnancyDetail;
var retVal = new SqlParameter("@SCOPE_OUTPUT", 1)
{
Direction = ParameterDirection.Output
};
var pList = new List <SqlParameter>()
{
new SqlParameter("@UniqueSubjectID", spData.uniqueSubjectId ?? spData.uniqueSubjectId),
new SqlParameter("@RCHID", spData.rchId.ToCheckNull()),
new SqlParameter("@ECNumber", spData.ecNumber.ToCheckNull()),
new SqlParameter("@LMP_Date", spData.lmpDate.ToCheckNull()),
new SqlParameter("@G", Convert.ToInt32(spData.g)),
new SqlParameter("@P", Convert.ToInt32(spData.p)),
new SqlParameter("@L", Convert.ToInt32(spData.l)),
new SqlParameter("@A", Convert.ToInt32(spData.a)),
new SqlParameter("@UpdatedBy", Convert.ToInt32(spData.updatedBy)),
retVal
};
UtilityDL.ExecuteNonQuery(stProc, pList);
}
catch (Exception ex)
{
throw ex;
}
}
public void AddHPLCTest(AddHPLCTestRequest hplcData)
{
try
{
var stProc = AddHPLCTests;
var pList = new List <SqlParameter>()
{
new SqlParameter("@UniqueSubjectId", hplcData.subjectId ?? hplcData.subjectId),
new SqlParameter("@BarcodeNo", hplcData.barcodeNo ?? hplcData.barcodeNo),
new SqlParameter("@CentralLabId", Convert.ToInt32(hplcData.centralLabId)),
new SqlParameter("@HbF", Convert.ToDecimal(hplcData.HbF)),
new SqlParameter("@HbA0", Convert.ToDecimal(hplcData.HbA0)),
new SqlParameter("@HbA2", Convert.ToDecimal(hplcData.HbA2)),
new SqlParameter("@HbS", Convert.ToDecimal(hplcData.HbS)),
new SqlParameter("@HbC", Convert.ToDecimal(hplcData.HbC)),
new SqlParameter("@HbD", Convert.ToDecimal(hplcData.HbD)),
new SqlParameter("@TestCompleteOn", hplcData.testCompleteOn ?? hplcData.testCompleteOn),
new SqlParameter("@CreatedBy", Convert.ToInt32(hplcData.createdBy)),
};
UtilityDL.ExecuteNonQuery(stProc, pList);
}
catch (Exception ex)
{
throw ex;
}
}
public void AddShipment(MobileShipmentRequest msData)
{
try
{
string stProc = AddShipments;
var pList = new List <SqlParameter>
{
new SqlParameter("@GeneratedShipmentId", msData.shipmentId ?? msData.shipmentId),
new SqlParameter("@BarcodeNo", msData.barcodeNo ?? msData.barcodeNo),
new SqlParameter("@ShipmentFrom", msData.shipmentFrom),
new SqlParameter("@ANM_ID", msData.anmId),
new SqlParameter("@RIID", msData.riId),
new SqlParameter("@ILR_ID", msData.ilrId),
new SqlParameter("@AVDID", msData.avdId),
new SqlParameter("@AVDContactNo", msData.avdContactNo.ToCheckNull()),
new SqlParameter("@AlternateAVD", msData.alternateAVD.ToCheckNull()),
new SqlParameter("@AlternateAVDContactNo", msData.alternateAVDContactNo.ToCheckNull()),
new SqlParameter("@TestingCHCID", msData.testingCHCId),
new SqlParameter("@DateofShipment", msData.dateOfShipment ?? msData.dateOfShipment),
new SqlParameter("@TimeofShipment", msData.timeOfShipment ?? msData.timeOfShipment),
new SqlParameter("@Createdby", msData.createdBy),
new SqlParameter("@Source", msData.source ?? msData.source),
};
UtilityDL.ExecuteNonQuery(stProc, pList);
}
catch (Exception e)
{
throw e;
}
}
public string AddHPLCDiagnosisResult(AddHPLCDiagnosisResultRequest aData)
{
try
{
var stProc = AddHPLCDiagnosisResults;
var pList = new List <SqlParameter>()
{
new SqlParameter("@UniqueSubjectId", aData.uniqueSubjectId ?? aData.uniqueSubjectId),
new SqlParameter("@CentralLabId", aData.centralLabId),
new SqlParameter("@BarcodeNo", aData.barcodeNo ?? aData.barcodeNo),
new SqlParameter("@HPLCTestResultId", aData.hplcTestResultId),
new SqlParameter("@ClinicalDiagnosisId", aData.clinicalDiagnosisId ?? aData.clinicalDiagnosisId),
new SqlParameter("@HPLCResultMasterId", aData.hplcResultMasterId ?? aData.hplcResultMasterId),
new SqlParameter("@IsNormal", aData.isNormal),
new SqlParameter("@DiagnosisSummary", aData.diagnosisSummary ?? aData.diagnosisSummary),
new SqlParameter("@IsConsultSeniorPathologist", aData.isConsultSeniorPathologist),
new SqlParameter("@SeniorPathologistName", aData.seniorPathologistName ?? aData.seniorPathologistName),
new SqlParameter("@SeniorPathologistRemarks", aData.seniorPathologistRemarks ?? aData.seniorPathologistRemarks),
new SqlParameter("@CreatedBy", aData.userId),
new SqlParameter("@IsDiagnosisComplete", aData.isDiagnosisComplete),
new SqlParameter("@OthersResult", aData.othersResult.ToCheckNull()),
new SqlParameter("@OthersDiagnosis", aData.othersDiagnosis.ToCheckNull()),
};
UtilityDL.ExecuteNonQuery(stProc, pList);
return($"HPLC diagnosis result updated successfully");
}
catch (Exception ex)
{
throw ex;
}
}
public List <LoadCommunity> RetrieveCommunity()
{
string stProc = FetchAllCommunity;
var pList = new List <SqlParameter>();
var allData = UtilityDL.FillData <LoadCommunity>(stProc, pList);
return(allData);
}
public List <LoadGovIdType> RetrieveGovIDType()
{
string stProc = FetchAllGovIdType;
var pList = new List <SqlParameter>();
var allData = UtilityDL.FillData <LoadGovIdType>(stProc, pList);
return(allData);
}
public List <LoadCommonMaster> GetAllMutuation()
{
string stProc = FetchAllMutation;
var pList = new List <SqlParameter>();
var allData = UtilityDL.FillData <LoadCommonMaster>(stProc, pList);
return(allData);
}
public List <LoadCaste> RetrieveCaste()
{
string stProc = FetchAllCaste;
var pList = new List <SqlParameter>();
var allData = UtilityDL.FillData <LoadCaste>(stProc, pList);
return(allData);
}
public List <LoadCommonMaster> RetrieveResults()
{
string stProc = FetchMolecularResultMaster;
var pList = new List <SqlParameter>();
var allData = UtilityDL.FillData <LoadCommonMaster>(stProc, pList);
return(allData);
}
public List <LoadCommonMaster> RetrieveDiagnosis()
{
string stProc = FetchDiagnosis;
var pList = new List <SqlParameter>();
var allData = UtilityDL.FillData <LoadCommonMaster>(stProc, pList);
return(allData);
}
public List <LoadMolecularLab> RetrieveMolecularLab()
{
string stProc = FetchMolecularLab;
var pList = new List <SqlParameter>();
var allData = UtilityDL.FillData <LoadMolecularLab>(stProc, pList);
return(allData);
}
public List <LoadBirthStatus> RetrieveBirthStatus()
{
string stProc = FetchAllBirthStatus;
var pList = new List <SqlParameter>();
var allData = UtilityDL.FillData <LoadBirthStatus>(stProc, pList);
return(allData);
}
public List <LoadReligion> RetrieveReligion()
{
string stProc = FetchAllReligion;
var pList = new List <SqlParameter>();
var allData = UtilityDL.FillData <LoadReligion>(stProc, pList);
return(allData);
}
