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 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 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 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 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 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 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 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 AutomaticPostPNDTCousellingUpdate()
{
try
{
var stProc = UpdatePostPNDTCounsellingByAutomatic;
var pList = new List <SqlParameter>();
UtilityDL.ExecuteNonQuery(stProc, pList);
}
catch (Exception ex)
{
throw ex;
}
}
public void subjectPrimary(PrimaryDetailRequest sprData)
{
try
{
string stProc = AddPrimaryDetail;
var pList = new List <SqlParameter>
{
new SqlParameter("@SubjectTypeID", Convert.ToInt32(sprData.subjectTypeId)),
new SqlParameter("@ChildSubjectTypeID", Convert.ToInt32(sprData.childSubjectTypeId)),
new SqlParameter("@UniqueSubjectID", sprData.uniqueSubjectId ?? sprData.uniqueSubjectId),
new SqlParameter("@DistrictID", Convert.ToInt32(sprData.districtId)),
new SqlParameter("@CHCID", Convert.ToInt32(sprData.chcId)),
new SqlParameter("@PHCID", Convert.ToInt32(sprData.phcId)),
new SqlParameter("@SCID", Convert.ToInt32(sprData.scId)),
new SqlParameter("@RIID", Convert.ToInt32(sprData.riId)),
new SqlParameter("@SubjectTitle", sprData.subjectTitle.ToCheckNull()),
new SqlParameter("@FirstName", sprData.firstName ?? sprData.firstName),
new SqlParameter("@MiddleName", sprData.middleName.ToCheckNull()),
new SqlParameter("@LastName", sprData.lastName.ToCheckNull()),
new SqlParameter("@DOB", sprData.dob.ToCheckNull()),
new SqlParameter("@Age", Convert.ToInt32(sprData.age)),
new SqlParameter("@Gender", sprData.gender.ToCheckNull()),
new SqlParameter("@MaritalStatus", sprData.maritalStatus ?? sprData.maritalStatus),
new SqlParameter("@MobileNo", sprData.mobileNo.ToCheckNull()),
new SqlParameter("@EmailId", sprData.emailId.ToCheckNull()),
new SqlParameter("@GovIdType_ID", Convert.ToInt32(sprData.govIdTypeId)),
new SqlParameter("@GovIdDetail", sprData.govIdDetail.ToCheckNull()),
new SqlParameter("@SpouseSubjectID", sprData.spouseSubjectId.ToCheckNull()),
new SqlParameter("@Spouse_FirstName", sprData.spouseFirstName.ToCheckNull()),
new SqlParameter("@Spouse_MiddleName", sprData.spouseMiddleName.ToCheckNull()),
new SqlParameter("@Spouse_LastName", sprData.spouseLastName.ToCheckNull()),
new SqlParameter("@Spouse_ContactNo", sprData.spouseContactNo.ToCheckNull()),
new SqlParameter("@Spouse_GovIdType_ID", Convert.ToInt32(sprData.spouseGovIdTypeId)),
new SqlParameter("@Spouse_GovIdDetail", sprData.spouseGovIdDetail.ToCheckNull()),
new SqlParameter("@AssignANM_ID", Convert.ToInt32(sprData.assignANMId)),
new SqlParameter("@DateofRegister", sprData.dateOfRegister.ToCheckNull()),
new SqlParameter("@RegisteredFrom", Convert.ToInt32(sprData.registeredFrom)),
new SqlParameter("@Isactive", sprData.isActive),
new SqlParameter("@Createdby", Convert.ToInt32(sprData.createdBy)),
new SqlParameter("@Updatedby", Convert.ToInt32(sprData.updatedBy)),
new SqlParameter("@Source", sprData.source),
new SqlParameter("@SpouseWillingness", sprData.spouseWillingness ?? true),
};
UtilityDL.ExecuteNonQuery(stProc, pList);
}
catch (Exception e)
{
throw e;
}
}
public void SubjectParent(ParentDetailRequest spaData)
{
try
{
var stProc = AddSubjectParentDetail;
var retVal = new SqlParameter("@SCOPE_OUTPUT", 1)
{
Direction = ParameterDirection.Output
};
var pList = new List <SqlParameter>()
{
new SqlParameter("@UniqueSubjectID", spaData.uniqueSubjectId ?? spaData.uniqueSubjectId),
new SqlParameter("@Mother_FirstName", spaData.motherFirstName.ToCheckNull()),
new SqlParameter("@Mother_MiddleName", spaData.motherMiddleName.ToCheckNull()),
new SqlParameter("@Mother_LastName", spaData.motherLastName.ToCheckNull()),
new SqlParameter("@Mother_GovIdType_ID", Convert.ToInt32(spaData.motherGovIdTypeId)),
new SqlParameter("@Mother_GovIdDetail", spaData.motherGovIdDetail.ToCheckNull()),
new SqlParameter("@Mother_ContactNo", spaData.motherContactNo.ToCheckNull()),
new SqlParameter("@Father_FirstName", spaData.fatherFirstName.ToCheckNull()),
new SqlParameter("@Father_MiddleName", spaData.fatherMiddleName.ToCheckNull()),
new SqlParameter("@Father_LastName", spaData.fatherLastName.ToCheckNull()),
new SqlParameter("@Father_GovIdType_ID", Convert.ToInt32(spaData.fatherGovIdTypeId)),
new SqlParameter("@Father_GovIdDetail", spaData.fatherGovIdDetail.ToCheckNull()),
new SqlParameter("@Father_ContactNo", spaData.fatherContactNo.ToCheckNull()),
new SqlParameter("@Gaurdian_FirstName", spaData.gaurdianFirstName.ToCheckNull()),
new SqlParameter("@Gaurdian_MiddleName", spaData.gaurdianMiddleName.ToCheckNull()),
new SqlParameter("@Gaurdian_LastName", spaData.gaurdianLastName.ToCheckNull()),
new SqlParameter("@Guardian_GovIdType_ID", Convert.ToInt32(spaData.gaurdianGovIdTypeId)),
new SqlParameter("@Guardian_GovIdDetail", spaData.gaurdianGovIdDetail.ToCheckNull()),
new SqlParameter("@Gaurdian_ContactNo", spaData.gaurdianContactNo.ToCheckNull()),
new SqlParameter("@RBSKId", spaData.rbskId.ToCheckNull()),
new SqlParameter("@SchoolName", spaData.schoolName.ToCheckNull()),
new SqlParameter("@SchoolAddress1", spaData.schoolAddress1.ToCheckNull()),
new SqlParameter("@SchoolAddress2", spaData.schoolAddress2.ToCheckNull()),
new SqlParameter("@SchoolAddress3", spaData.schoolAddress3.ToCheckNull()),
new SqlParameter("@SchoolPincode", spaData.schoolPincode.ToCheckNull()),
new SqlParameter("@SchoolCity", spaData.schoolCity.ToCheckNull()),
new SqlParameter("@SchoolState", spaData.schoolState.ToCheckNull()),
new SqlParameter("@Standard", spaData.standard.ToCheckNull()),
new SqlParameter("@Section", spaData.section.ToCheckNull()),
new SqlParameter("@RollNo", spaData.rollNo.ToCheckNull()),
new SqlParameter("@UpdatedBy", Convert.ToInt32(spaData.updatedBy)),
retVal
};
UtilityDL.ExecuteNonQuery(stProc, pList);
}
catch (Exception ex)
{
throw ex;
}
}
public void AddCHCSamplesAcknowledgement(string barcodeNo)
{
try
{
var stProc = AddCHCSampleAcknowledgement;
var pList = new List <SqlParameter>()
{
new SqlParameter("@BarcodeNo", barcodeNo ?? barcodeNo),
};
UtilityDL.ExecuteNonQuery(stProc, pList);
}
catch (Exception ex)
{
throw ex;
}
}
public void AddCHCSubAcknowledgement(string uniqueSubjectId)
{
try
{
var stProc = AddCHCSubjectAcknowledgement;
var pList = new List <SqlParameter>()
{
new SqlParameter("@UniqueSubjectId", uniqueSubjectId ?? uniqueSubjectId),
};
UtilityDL.ExecuteNonQuery(stProc, pList);
}
catch (Exception ex)
{
throw ex;
}
}
public void AutomaticHPLCDiagnosisUpdate(int centralLabId)
{
try
{
var stProc = AddHPLCDiagnosisResultByAutomatic;
var pList = new List <SqlParameter>()
{
new SqlParameter("@CentralLabId", centralLabId),
};
UtilityDL.ExecuteNonQuery(stProc, pList);
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdatePrePostPNDTMTPAcknowledgement(AddPNDTMTPAckRequest aData)
{
try
{
var stProc = AddPrePostPNDTMTPAcknowledgement;
var pList = new List <SqlParameter>()
{
new SqlParameter("@UniqueSubjectId", aData.uniqueSubjectId ?? aData.uniqueSubjectId),
new SqlParameter("@Request", aData.inputRequest),
};
UtilityDL.ExecuteNonQuery(stProc, pList);
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdateMTPReferalStatus(MobileReferalRequest rData)
{
try
{
var stProc = UpdateStatusANMMobileNotificationMTPReferal;
var pList = new List <SqlParameter>()
{
new SqlParameter("@ANWSubjectId", rData.uniqueSubjectId ?? rData.uniqueSubjectId),
new SqlParameter("@ANMID", rData.userId),
};
UtilityDL.ExecuteNonQuery(stProc, pList);
}
catch (Exception ex)
{
throw ex;
}
}
public void AddTimeoutExpiry(MobileAddExpiryRequest meData)
{
try
{
var stProc = MoveTimeoutExpiry;
var pList = new List <SqlParameter>()
{
new SqlParameter("@BarcodeNo", meData.barcodeNo ?? meData.barcodeNo),
new SqlParameter("@ANMID", meData.userId),
};
UtilityDL.ExecuteNonQuery(stProc, pList);
}
catch (Exception ex)
{
throw ex;
}
}
public string UpdateSampleStatus(NotificationUpdateStatusRequest usData)
{
try
{
string stProc = UpdateStatusANMNotificationSamples;
var pList = new List <SqlParameter>
{
new SqlParameter("@BarcodeNo", usData.barcodeNo ?? usData.barcodeNo),
new SqlParameter("@ANMID", usData.anmId),
};
UtilityDL.ExecuteNonQuery(stProc, pList);
return("Sample status updated successfully");
}
catch (Exception e)
{
throw e;
}
}
public void UpdatePositiveSubjectStatus(UpdateStatusRequest usData)
{
try
{
var stProc = UpdateStatusPositiveSubjects;
var pList = new List <SqlParameter>()
{
new SqlParameter("@BarcodeNo", usData.barcodeNo ?? usData.barcodeNo),
new SqlParameter("@ANMID", usData.userId),
new SqlParameter("@NotifiedOn", usData.notifiedOn ?? usData.notifiedOn),
};
UtilityDL.ExecuteNonQuery(stProc, pList);
}
catch (Exception ex)
{
throw ex;
}
}
public string UpdateMTPFollowUpStatus(AddPostMTPRequest rData)
{
try
{
string stProc = UpdateStatusDCPostMTPFollowUp;
var pList = new List <SqlParameter>
{
new SqlParameter("@MTPID", rData.mtpId ?? rData.mtpId),
new SqlParameter("@UserId", rData.userId),
};
UtilityDL.ExecuteNonQuery(stProc, pList);
return("MTP followup status updated successfully");
}
catch (Exception e)
{
throw e;
}
}
public string UpdatePNDTReferalStatus(ReferalDCRequest rData)
{
try
{
string stProc = UpdateStatusDCNotificationPNDTReferal;
var pList = new List <SqlParameter>
{
new SqlParameter("@PNDTReferalId", rData.referalId ?? rData.referalId),
new SqlParameter("@UserId", rData.userId),
};
UtilityDL.ExecuteNonQuery(stProc, pList);
return("PNDT referal status updated successfully");
}
catch (Exception e)
{
throw e;
}
}
public string UpdateSampleStatus(NotificationDCRequest nData)
{
try
{
string stProc = UpdateStatusDCNotificationSamples;
var pList = new List <SqlParameter>
{
new SqlParameter("@BarcodeNo", nData.barcodeNo ?? nData.barcodeNo),
new SqlParameter("@UserId", nData.userId),
};
UtilityDL.ExecuteNonQuery(stProc, pList);
return("Positive subject status updated successfully");
}
catch (Exception e)
{
throw e;
}
}
public string AddTimeoutExpiry(CHCNotificationTimeoutRequest cnData)
{
try
{
string stProc = MoveTimeoutExpiry;
var pList = new List <SqlParameter>
{
new SqlParameter("@BarcodeNo", cnData.barcodeNo ?? cnData.barcodeNo),
new SqlParameter("@UserId", cnData.userId),
};
UtilityDL.ExecuteNonQuery(stProc, pList);
return("Samples successfully moved to timeout expiry");
}
catch (Exception e)
{
throw e;
}
}
public string AddTimeoutExpiry(NotificationUpdateStatusRequest usData)
{
try
{
string stProc = MoveTimeoutExpiry;
var pList = new List <SqlParameter>
{
new SqlParameter("@BarcodeNo", usData.barcodeNo ?? usData.barcodeNo),
new SqlParameter("@ANMID", usData.anmId),
};
UtilityDL.ExecuteNonQuery(stProc, pList);
return("Samples successfully moved to timeout expiry");
}
catch (Exception e)
{
throw e;
}
}
public void UpdatePostMTPFollowupStatus(AddUpdateFollowupStatusRequest fData)
{
try
{
string stProc = UpdateMobilePostMTPFollowUpStatus;
var pList = new List <SqlParameter>
{
new SqlParameter("@UniqueSubjectId", fData.uniqueSubjectId),
new SqlParameter("@FollowUpNo", fData.followUpNo),
new SqlParameter("@FollowUpStatusId", fData.followUpStatusId),
new SqlParameter("@FollowUpStatusDetail", fData.followUpStatusDetail.ToCheckNull()),
new SqlParameter("@UserId", fData.userId),
};
UtilityDL.ExecuteNonQuery(stProc, pList);
}
catch (Exception e)
{
throw e;
}
}
public void AddSSTest(AddSSTestRequest ssData)
{
try
{
var stProc = AddSSTests;
var pList = new List <SqlParameter>()
{
new SqlParameter("@UniqueSubjectId", ssData.subjectId ?? ssData.subjectId),
new SqlParameter("@Barcode", ssData.barcodeNo ?? ssData.barcodeNo),
new SqlParameter("@TestingCHCId", Convert.ToInt32(ssData.testingCHCId)),
new SqlParameter("@IsPositive", ssData.isPositive),
new SqlParameter("@CreatedBy", Convert.ToInt32(ssData.createdBy)),
};
UtilityDL.ExecuteNonQuery(stProc, pList);
}
catch (Exception ex)
{
throw ex;
}
}
public void AddReceivedSpecimenShipment(AddMolLabSpecimenReceiptRequest mrData)
{
try
{
var stProc = AddMolecularLabSpecimenReceipt;
var pList = new List <SqlParameter>()
{
new SqlParameter("@ShipmentId", mrData.shipmentId ?? mrData.shipmentId),
new SqlParameter("@ReceivedDate", mrData.receivedDateTime ?? mrData.receivedDateTime),
new SqlParameter("@SampleDamaged", mrData.sampleDamaged),
new SqlParameter("@BarcodeDamaged", mrData.barcodeDamaged),
new SqlParameter("@IsAccept", mrData.isAccept),
new SqlParameter("@PNDTFoetusId", mrData.pndtFoetusId),
new SqlParameter("@UpdatedBy", mrData.userId),
};
UtilityDL.ExecuteNonQuery(stProc, pList);
}
catch (Exception ex)
{
throw ex;
}
}
public string UpdateMTPFollowUpStatus(AddFollowUpStatus fData)
{
try
{
string stProc = UpdatePostMTPFollowUpStatus;
var pList = new List <SqlParameter>
{
new SqlParameter("@MTPID", fData.mtpId),
new SqlParameter("@FollowUpNo", fData.followUpNo),
new SqlParameter("@FollowUpStatusId", fData.followUpStatusId),
new SqlParameter("@FollowUpStatusDetail", fData.followUpStatusDetail.ToCheckNull()),
new SqlParameter("@UserId", fData.userId),
};
UtilityDL.ExecuteNonQuery(stProc, pList);
return("Follow up status updated successfully");
}
catch (Exception e)
{
throw e;
}
}
public async Task <int> AddNewUserAsync(AddUserRequest addUser, string password)
{
var recInsert = 0;
try
{
var stProc = AddUser;
var retVal = new SqlParameter("@SCOPE_OUTPUT", 1)
{
Direction = ParameterDirection.Output
};
var pList = new List <SqlParameter>()
{
new SqlParameter("@UserRoleId", addUser.userRoleId),
new SqlParameter("@HospitalId", addUser.hospitalId),
new SqlParameter("@FirstName", addUser.firstName ?? addUser.firstName),
new SqlParameter("@MiddleName", addUser.middleName.ToCheckNull()),
new SqlParameter("@LastName", addUser.lastName.ToCheckNull()),
new SqlParameter("@Email", addUser.email.ToCheckNull()),
new SqlParameter("@ContactNo", addUser.contactNo.ToCheckNull()),
new SqlParameter("@Address", addUser.address.ToCheckNull()),
new SqlParameter("@Pincode", addUser.pincode.ToCheckNull()),
new SqlParameter("@StateID", addUser.stateId),
new SqlParameter("@DistrictID", addUser.districtId),
new SqlParameter("@UserName", addUser.userName),
new SqlParameter("@Password", password),
new SqlParameter("@CreatedBy", addUser.createdBy),
new SqlParameter("@Comments", addUser.comments ?? string.Empty),
retVal
};
recInsert = Convert.ToInt32(UtilityDL.ExecuteNonQuery(stProc, pList, true));
return(recInsert);
}
catch (Exception ex)
{
throw ex;
}
}
public string AddMolecularResult(AddMolecularResultRequest mrData)
{
try
{
var stProc = AddMolecularTestResult;
var pList = new List <SqlParameter>()
{
new SqlParameter("@UniqueSubjectId", mrData.uniqueSubjectId ?? mrData.uniqueSubjectId),
new SqlParameter("@Barcode", mrData.barcodeNo ?? mrData.barcodeNo),
new SqlParameter("@DiagnosisId", mrData.diagnosisId),
new SqlParameter("@ResultId", mrData.resultId),
new SqlParameter("@UpdatedBy", mrData.userId),
new SqlParameter("@IsProcessed", mrData.processSample),
new SqlParameter("@Remarks", mrData.remarks.ToCheckNull()),
};
UtilityDL.ExecuteNonQuery(stProc, pList);
return($"Molecular test result updated successfully");
}
catch (Exception ex)
{
throw ex;
}
}