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 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 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 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 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 List <PMMaster> GetAllProcedureofTesting()
{
string stProc = FetchAllProcedureOfTesting;
var pList = new List <SqlParameter>();
var potData = UtilityDL.FillData <PMMaster>(stProc, pList);
return(potData);
}
public List <PMMaster> GetAllPNDTResultMaster()
{
string stProc = FetchAllPNDTResultMaster;
var pList = new List <SqlParameter>();
var districtData = UtilityDL.FillData <PMMaster>(stProc, pList);
return(districtData);
}
public List <StateDetails> RetrieveAllStates()
{
string stProc = FetchAllStates;
var pList = new List <SqlParameter>();
var allData = UtilityDL.FillData <StateDetails>(stProc, pList);
return(allData);
}
public List <LoadCommunity> RetrieveCommunity()
{
string stProc = FetchAllCommunity;
var pList = new List <SqlParameter>();
var allData = UtilityDL.FillData <LoadCommunity>(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 <LoadCommonMaster> RetrieveDiagnosis()
{
string stProc = FetchDiagnosis;
var pList = new List <SqlParameter>();
var allData = UtilityDL.FillData <LoadCommonMaster>(stProc, pList);
return(allData);
}
public List <MTPSummary> GetMTPSummary()
{
string stProc = FetchSubjectsMTPSummary;
var pList = new List <SqlParameter>();
var summaryData = UtilityDL.FillData <MTPSummary>(stProc, pList);
return(summaryData);
}
public List <MobileMenu> RetrieveMobileMenu()
{
string stProc = FetchMobileAppLeftSideMenu;
var pList = new List <SqlParameter>();
var menus = UtilityDL.FillData <MobileMenu>(stProc, pList);
return(menus);
}
public List <LoadFollowUps> RetrieveFollowups()
{
string stProc = FetchAllPostMTPFollowup;
var pList = new List <SqlParameter>();
var allData = UtilityDL.FillData <LoadFollowUps>(stProc, pList);
return(allData);
}
public List <LoadConstantValues> RetrieveConstantValues()
{
string stProc = FetchConstantValues;
var pList = new List <SqlParameter>();
var allData = UtilityDL.FillData <LoadConstantValues>(stProc, pList);
return(allData);
}
public List <BarcodeErrorDetail> FetchErrorBarcodeDetails()
{
string stProc = FetchErrorBarcodeCorrection;
var pList = new List <SqlParameter>();
var allData = UtilityDL.FillData <BarcodeErrorDetail>(stProc, pList);
return(allData);
}
public List <LoadLogisticsProvider> RetrieveLogisticsProvider()
{
string stProc = FetchLogisticsProvider;
var pList = new List <SqlParameter>();
var allData = UtilityDL.FillData <LoadLogisticsProvider>(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 <LoadCommon> GetAllZygosity()
{
string stProc = FetchAllZygosity;
var pList = new List <SqlParameter>();
var allData = UtilityDL.FillData <LoadCommon>(stProc, pList);
return(allData);
}
public List <RISiteDetail> RetrieveAllRI()
{
string stProc = FetchAllRI;
var pList = new List <SqlParameter>();
var allData = UtilityDL.FillData <RISiteDetail>(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);
}
public List <PMMaster> GetCounsellor()
{
string stProc = FetchAllCounsellor;
var pList = new List <SqlParameter>();
var counsellorData = UtilityDL.FillData <PMMaster>(stProc, pList);
return(counsellorData);
}
public List <LoadMolecularLab> RetrieveMolecularLab()
{
string stProc = FetchMolecularLab;
var pList = new List <SqlParameter>();
var allData = UtilityDL.FillData <LoadMolecularLab>(stProc, pList);
return(allData);
}
public List <PMMaster> GetAllPostMTPFollowUp()
{
string stProc = FetchAllPostMTPFollowup;
var pList = new List <SqlParameter>();
var followUpData = UtilityDL.FillData <PMMaster>(stProc, pList);
return(followUpData);
}
public List <LoadCommonMaster> RetrieveResults()
{
string stProc = FetchMolecularResultMaster;
var pList = new List <SqlParameter>();
var allData = UtilityDL.FillData <LoadCommonMaster>(stProc, pList);
return(allData);
}
public List <PMMaster> GetMTPObstetrician()
{
string stProc = FetchAllMTPObstetrician;
var pList = new List <SqlParameter>();
var pndtObsData = UtilityDL.FillData <PMMaster>(stProc, pList);
return(pndtObsData);
}
public List <LoadCaste> RetrieveCaste()
{
string stProc = FetchAllCaste;
var pList = new List <SqlParameter>();
var allData = UtilityDL.FillData <LoadCaste>(stProc, pList);
return(allData);
}
public List <PMMaster> GetAllMTPDischargeCondition()
{
string stProc = FetchAllMTPDischarge;
var pList = new List <SqlParameter>();
var districtData = UtilityDL.FillData <PMMaster>(stProc, pList);
return(districtData);
}
public List <LoadGovIdType> RetrieveGovIDType()
{
string stProc = FetchAllGovIdType;
var pList = new List <SqlParameter>();
var allData = UtilityDL.FillData <LoadGovIdType>(stProc, pList);
return(allData);
}
public List <PMMaster> GetAllMTPComplications()
{
string stProc = FetchAllMTPComplecations;
var pList = new List <SqlParameter>();
var districtData = UtilityDL.FillData <PMMaster>(stProc, pList);
return(districtData);
}