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; } }