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 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 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 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 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 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 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 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 MobileAlert RetrieveAlert()
{
string stProc = FetchMobileAppAlert;
var pList = new List <SqlParameter>();
var msg = UtilityDL.FillEntity <MobileAlert>(stProc, pList);
return(msg);
}
public MobileMetricSummaryMessage RetrieveResponseMsg()
{
string stProc = FetchMobileMetricsReportMessage;
var pList = new List <SqlParameter>();
var msg = UtilityDL.FillEntity <MobileMetricSummaryMessage>(stProc, pList);
return(msg);
}
public MobileMetricsDetail FetchMobileMetricsDetail(int userId)
{
string stProc = FetchMobileFieldMetricsAndGA;
string stProcPNDT = FetchMobilePNDTObsMetrics;
string stProcMTP = FetchMobileMTPObsMetrics;
string stProcPostMTP = FetchMobilePostMTPMetrics;
string stProcHPLCTest = FetchMobileHPLCTestMetrics;
var pList = new List <SqlParameter>()
{
new SqlParameter("@UserId", userId)
};
var pList1 = new List <SqlParameter>()
{
new SqlParameter("@UserId", userId)
};
var pList2 = new List <SqlParameter>()
{
new SqlParameter("@UserId", userId)
};
var pList3 = new List <SqlParameter>()
{
new SqlParameter("@UserId", userId)
};
var pList4 = new List <SqlParameter>()
{
new SqlParameter("@UserId", userId)
};
var pList5 = new List <SqlParameter>()
{
new SqlParameter("@UserId", userId)
};
var pList6 = new List <SqlParameter>()
{
new SqlParameter("@UserId", userId)
};
var fieldMetrics = UtilityDL.FillEntity <MobileFieldMetrics>(stProc, pList);
var gaAtReg = UtilityDL.FillEntity <MobileGAatReg>(stProc, pList1);
var criticalGA = UtilityDL.FillEntity <MobileCurrentGA>(stProc, pList2);
var pndtObsMetrics = UtilityDL.FillEntity <MobilePNDTObsMetrics>(stProcPNDT, pList3);
var mtpObsMetrics = UtilityDL.FillEntity <MobileMTPObsMetrics>(stProcMTP, pList4);
var postMTPMetrics = UtilityDL.FillEntity <MobilePostMTPMetrics>(stProcPostMTP, pList5);
var testMetrics = UtilityDL.FillEntity <MobileTestMetrics>(stProcHPLCTest, pList6);
var allMetrics = new MobileMetricsDetail();
allMetrics.fieldMetrics = fieldMetrics;
allMetrics.gaAtReg = gaAtReg;
allMetrics.testMetrics = testMetrics;
allMetrics.criticalGA = criticalGA;
allMetrics.pndtObsMetrics = pndtObsMetrics;
allMetrics.mtpObsMetrics = mtpObsMetrics;
allMetrics.postMTPMetrics = postMTPMetrics;
return(allMetrics);
}
public TrackingSubjects RetrieveSubjectsForTracking(string uniqueSubjectId)
{
string stProc = FetchTrackingSubjectReport;
var pList = new List <SqlParameter>()
{
new SqlParameter("@UniqueSubjectId", uniqueSubjectId)
};
var allData = UtilityDL.FillEntity <TrackingSubjects>(stProc, pList);
return(allData);
}
public LastIds FindLastId(int userId)
{
string stProc = FetchLastId;
var pList = new List <SqlParameter>()
{
new SqlParameter("@ANMId", userId)
};
var allData = UtilityDL.FillEntity <LastIds>(stProc, pList);
return(allData);
}
public BarcodeErrorDetail FetchBarcodeExist(string barcodeNo)
{
string stProc = FetchBarcodeExists;
var pList = new List <SqlParameter>()
{
new SqlParameter("@BarcodeNo", barcodeNo)
};
var allData = UtilityDL.FillEntity <BarcodeErrorDetail>(stProc, pList);
return(allData);
}
public Device CheckDevice(int userId, string deviceId)
{
string stProc = CheckValidDevice;
var pList = new List <SqlParameter>()
{
new SqlParameter("@ANMId", userId),
new SqlParameter("@DeviceId", deviceId),
};
var allData = UtilityDL.FillEntity <Device>(stProc, pList);
return(allData);
}
public UpdateRCHIDMsg UpdateRCHId(UpdateRCHIDRequest rData)
{
string stProc = UpdateRCHIdDetail;
var pList = new List <SqlParameter>()
{
new SqlParameter("@OldRCHId", rData.rchId),
new SqlParameter("@NewRCHId", rData.revisedRCHID),
new SqlParameter("@UserId", rData.userId),
};
var allData = UtilityDL.FillEntity <UpdateRCHIDMsg>(stProc, pList);
return(allData);
}
public UpdateBarcodeMsg UpdateErrorBarcode(UpdateBarcodeRequest bData)
{
string stProc = UpdateErrorBarcodeDetail;
var pList = new List <SqlParameter>()
{
new SqlParameter("@OldBarcode", bData.barcodeNo),
new SqlParameter("@NewBarcode", bData.revisedBarcodeNo),
new SqlParameter("@UserId", bData.userId),
};
var allData = UtilityDL.FillEntity <UpdateBarcodeMsg>(stProc, pList);
return(allData);
}
public MotherRegistration AddMotherDetail(AddMotherRequest mrData)
{
try
{
string stProc = AddMothersDetail;
var pList = new List <SqlParameter>
{
new SqlParameter("@MotherSubjectId", mrData.motherSubjectId.ToCheckNull()),
new SqlParameter("@DateofRegistration", mrData.dateofRegistration),
new SqlParameter("@DistrictID", mrData.districtId),
new SqlParameter("@HospitalId", mrData.hospitalId),
new SqlParameter("@HospitalNo", mrData.hospitalNo ?? mrData.hospitalNo),
new SqlParameter("@CollectionSiteId", mrData.collectionSiteId),
new SqlParameter("@MotherFirstName", mrData.motherFirstName),
new SqlParameter("@MotherLastName", mrData.motherLastName.ToCheckNull()),
new SqlParameter("@DOB", mrData.dob.ToCheckNull()),
new SqlParameter("@Age", mrData.age),
new SqlParameter("@RCHID", mrData.rchId),
new SqlParameter("@MotherGovIdTypeId", mrData.motherGovIdTypeId),
new SqlParameter("@MotherGovIdDetail", mrData.motherGovIdDetail.ToCheckNull()),
new SqlParameter("@MotherContactNo", mrData.motherContactNo.ToCheckNull()),
new SqlParameter("@G", mrData.g),
new SqlParameter("@P", mrData.p),
new SqlParameter("@L", mrData.l),
new SqlParameter("@A", mrData.a),
new SqlParameter("@ECNumber", mrData.ecNumber.ToCheckNull()),
new SqlParameter("@Address1", mrData.address1.ToCheckNull()),
new SqlParameter("@Address2", mrData.address2.ToCheckNull()),
new SqlParameter("@Address3", mrData.address3.ToCheckNull()),
new SqlParameter("@StateId", mrData.stateId),
new SqlParameter("@Pincode", mrData.pincode.ToCheckNull()),
new SqlParameter("@ReligionId", mrData.religionId),
new SqlParameter("@CasteId", mrData.casteId),
new SqlParameter("@CommunityId", mrData.communityId),
new SqlParameter("@FatherFirstName", mrData.fatherFirstName.ToCheckNull()),
new SqlParameter("@FatherLastName", mrData.fatherLastName.ToCheckNull()),
new SqlParameter("@FatherContactNo", mrData.fatherContactNo.ToCheckNull()),
new SqlParameter("@GuardianFirstName", mrData.guardianFirstName.ToCheckNull()),
new SqlParameter("@GuardianLastName", mrData.guardianLastName.ToCheckNull()),
new SqlParameter("@GuardianContactNo", mrData.guardianContactNo.ToCheckNull()),
new SqlParameter("@UserId", mrData.userId),
};
var motherDet = UtilityDL.FillEntity <MotherRegistration>(stProc, pList);
return(motherDet);
}
catch (Exception e)
{
throw e;
}
}
public CVSSampleRefIdDetail AddDecision(PregnancyDecisionRequest pdData)
{
string stProc = UpdatePregnancyDecisionPNDT;
var pList = new List <SqlParameter>()
{
new SqlParameter("@PNDTestId", pdData.pndTestId),
new SqlParameter("@PNDTFoetusId", pdData.pndtFoetusId),
new SqlParameter("@PlanForPregnencyContinue", pdData.planForPregnencyContinue),
new SqlParameter("@UserId", pdData.userId),
};
var allData = UtilityDL.FillEntity <CVSSampleRefIdDetail>(stProc, pList);
return(allData);
}
public CounsellingDateTime AddPostPNDTScheduling(AddSchedulingRequest asData)
{
string stProc = AddPostPNDTsScheduling;
var pList = new List <SqlParameter>()
{
new SqlParameter("@ANWSubjectId", asData.anwsubjectId ?? asData.anwsubjectId),
new SqlParameter("@SpouseSubjectId", asData.spouseSubjectId ?? asData.spouseSubjectId),
new SqlParameter("@CounsellorId", asData.counsellorId),
new SqlParameter("@CounsellingDateTime", asData.counsellingDateTime ?? asData.counsellingDateTime),
new SqlParameter("@CreatedBy", asData.userId),
};
var schedulingData = UtilityDL.FillEntity <CounsellingDateTime>(stProc, pList);
return(schedulingData);
}
public ErrorMsgDetail UpdateErrorLMP(UpdateLMPRequest bData)
{
string stProc = UpdateLMPDetail;
var pList = new List <SqlParameter>()
{
new SqlParameter("@SubjectId", bData.subjectId),
new SqlParameter("@OldLMP", bData.oldLMP),
new SqlParameter("@NewLMP", bData.newLMP),
new SqlParameter("@Remarks", bData.remarks),
new SqlParameter("@UserId", bData.userId),
};
var allData = UtilityDL.FillEntity <ErrorMsgDetail>(stProc, pList);
return(allData);
}
public ErrorBarcodeSMSDetail ErrorSMSTrigger(int getId)
{
try
{
var stProc = FetchErrorBarcodeDetailForSMS;
var pList = new List <SqlParameter>()
{
new SqlParameter("@Id", getId),
};
var smsDetail = UtilityDL.FillEntity <ErrorBarcodeSMSDetail>(stProc, pList);
return(smsDetail);
}
catch (Exception ex)
{
throw ex;
}
}
public ErrorMsgDetail UpdateErrorSST(UpdateSSTRequest bData)
{
string stProc = UpdateSSTDetail;
var pList = new List <SqlParameter>()
{
new SqlParameter("@SSTID", bData.sstId),
new SqlParameter("@SubjectId", bData.subjectId),
new SqlParameter("@Barcode", bData.barcode),
new SqlParameter("@OldSST", bData.oldSST),
new SqlParameter("@NewSST", bData.newSST),
new SqlParameter("@Remarks", bData.remarks),
new SqlParameter("@UserId", bData.userId),
};
var allData = UtilityDL.FillEntity <ErrorMsgDetail>(stProc, pList);
return(allData);
}
public DCSPCDetails FetchDCSPCDetails(int anmId, int existANMId)
{
try
{
var stProc = FetchSCDCDetail;
var pList = new List <SqlParameter>()
{
new SqlParameter("@ANMId", anmId),
new SqlParameter("@ExistANMId", existANMId),
};
var smsDetail = UtilityDL.FillEntity <DCSPCDetails>(stProc, pList);
return(smsDetail);
}
catch (Exception ex)
{
throw ex;
}
}
public MsgDetail SendOTP(string userName, string otp)
{
try
{
var stProc = AddNewOTP;
var pList = new List <SqlParameter>()
{
new SqlParameter("@Username", userName ?? userName),
new SqlParameter("@OTP", otp ?? otp),
};
var msgDet = UtilityDL.FillEntity <MsgDetail>(stProc, pList);
return(msgDet);
}
catch (Exception ex)
{
throw ex;
}
}
public MsgDetail ChangePassword(string userName, string password)
{
try
{
var stProc = passwordChange;
var pList = new List <SqlParameter>()
{
new SqlParameter("@Username", userName ?? userName),
new SqlParameter("@Password", password ?? password),
};
var msgDet = UtilityDL.FillEntity <MsgDetail>(stProc, pList);
return(msgDet);
}
catch (Exception ex)
{
throw ex;
}
}
public MsgDetail ValidateOTP(OTPRequest oData)
{
try
{
var stProc = VerifyOTP;
var pList = new List <SqlParameter>()
{
new SqlParameter("@Username", oData.userName ?? oData.userName),
new SqlParameter("@OTP", oData.otp ?? oData.otp),
};
var msgDet = UtilityDL.FillEntity <MsgDetail>(stProc, pList);
return(msgDet);
}
catch (Exception ex)
{
throw ex;
}
}
public MotherReturnDetail UpdateMother(MotherUpdateRequest mrData)
{
try
{
string stProc = UpdateMotherProfile;
var pList = new List <SqlParameter>
{
new SqlParameter("@MotherSubjectId", mrData.motherSubjectId.ToCheckNull()),
new SqlParameter("@MotherFirstName", mrData.motherFirstName),
new SqlParameter("@MotherLastName", mrData.motherLastName.ToCheckNull()),
new SqlParameter("@DOB", mrData.dob.ToCheckNull()),
new SqlParameter("@Age", mrData.age),
new SqlParameter("@G", mrData.g),
new SqlParameter("@P", mrData.p),
new SqlParameter("@L", mrData.l),
new SqlParameter("@A", mrData.a),
new SqlParameter("@RCHID", mrData.rchId),
new SqlParameter("@MotherGovIdTypeId", mrData.motherGovIdTypeId),
new SqlParameter("@MotherGovIdDetail", mrData.motherGovIdDetail.ToCheckNull()),
new SqlParameter("@MotherContactNo", mrData.motherContactNo.ToCheckNull()),
new SqlParameter("@ECNumber", mrData.ecNumber.ToCheckNull()),
new SqlParameter("@Address1", mrData.address1.ToCheckNull()),
new SqlParameter("@Address2", mrData.address2.ToCheckNull()),
new SqlParameter("@Address3", mrData.address3.ToCheckNull()),
new SqlParameter("@StateId", mrData.stateId),
new SqlParameter("@Pincode", mrData.pincode.ToCheckNull()),
new SqlParameter("@FatherFirstName", mrData.fatherFirstName.ToCheckNull()),
new SqlParameter("@FatherLastName", mrData.fatherLastName.ToCheckNull()),
new SqlParameter("@FatherContactNo", mrData.fatherContactNo.ToCheckNull()),
new SqlParameter("@GuardianFirstName", mrData.guardianFirstName.ToCheckNull()),
new SqlParameter("@GuardianLastName", mrData.guardianLastName.ToCheckNull()),
new SqlParameter("@GuardianContactNo", mrData.guardianContactNo.ToCheckNull()),
new SqlParameter("@UserId", mrData.userId),
};
var motherDet = UtilityDL.FillEntity <MotherReturnDetail>(stProc, pList);
return(motherDet);
}
catch (Exception e)
{
throw e;
}
}
public HPLCResultMsg AddHPLCTestResult(AddHPLCTestResultRequest hplcData)
{
try
{
var stProc = AddHPLCTestResults;
var pList = new List <SqlParameter>()
{
new SqlParameter("@UniqueSubjectId", hplcData.subjectId ?? hplcData.subjectId),
new SqlParameter("@CentralLabId", Convert.ToInt32(hplcData.centralLabId)),
new SqlParameter("@HPLCTestId", hplcData.testId),
new SqlParameter("@CreatedBy", Convert.ToInt32(hplcData.userId)),
};
var hplcResult = UtilityDL.FillEntity <HPLCResultMsg>(stProc, pList);
return(hplcResult);
}
catch (Exception ex)
{
throw ex;
}
}
public CBCResultMsg AddCBCTestResult(AddCBCTestResultRequest cbcData)
{
try
{
var stProc = AddCBCTestResults;
var pList = new List <SqlParameter>()
{
new SqlParameter("@UniqueSubjectId", cbcData.subjectId ?? cbcData.subjectId),
new SqlParameter("@ConfirmStatus", Convert.ToInt32(cbcData.confirmStatus)),
new SqlParameter("@TestingCHCId", Convert.ToInt32(cbcData.testingCHCId)),
new SqlParameter("@TestedId", Convert.ToInt32(cbcData.testedId)),
new SqlParameter("@CreatedBy", Convert.ToInt32(cbcData.userId)),
};
var msg = UtilityDL.FillEntity <CBCResultMsg>(stProc, pList);
return(msg);
}
catch (Exception ex)
{
throw ex;
}
}