public List<UserRole> Retrieve()
{
string stProc = FetchUserRoles;
var pList = new List<SqlParameter>();
var allData = UtilityDL.FillData<UserRole>(stProc, pList);
return allData;
}
public List<UserRole> Retrieve(int code)
{
string stProc = FetchUserRole;
var pList = new List<SqlParameter>() { new SqlParameter("@ID", code) };
var allData = UtilityDL.FillData<UserRole>(stProc, pList);
return allData; throw new NotImplementedException();
}
public List <Patient> GetPatients()
{
string stProc = GetAllpatients;
var pList = new List <SqlParameter>();
var allData = UtilityDL.FillData <Patient>(stProc, pList);
return(allData);
}
public List <Religion> Retrieve()
{
string stProc = FetchReligions;
var pList = new List <SqlParameter>();
var allData = UtilityDL.FillData <Religion>(stProc, pList);
return(allData);
}
public List <District> Retrieve()
{
string stProc = FetchDistricts;
var pList = new List <SqlParameter>();
var allData = UtilityDL.FillData <District>(stProc, pList);
return(allData);
}
public List <ClinicalDiagnosis> Retrieve()
{
string stProc = FetchAllClinicalDiagnosis;
var pList = new List <SqlParameter>();
var allData = UtilityDL.FillData <ClinicalDiagnosis>(stProc, pList);
return(allData);
}
public List <SubjectType> Retrieve()
{
string stProc = FetchSubjectTypes;
var pList = new List <SqlParameter>();
var allData = UtilityDL.FillData <SubjectType>(stProc, pList);
return(allData);
}
public List <Community> Retrieve()
{
string stProc = FetchCommunities;
var pList = new List <SqlParameter>();
var allData = UtilityDL.FillData <Community>(stProc, pList);
return(allData);
}
public List <Threshold> Retrieve()
{
string stProc = FetchThresholdValues;
var pList = new List <SqlParameter>();
var allData = UtilityDL.FillData <Threshold>(stProc, pList);
return(allData);
}
public List <Block> Retrieve()
{
string stProc = FetchAllBlocks;
var pList = new List <SqlParameter>();
var allData = UtilityDL.FillData <Block>(stProc, pList);
return(allData);
}
public List <User> RetrieveByEmail(string email)
{
string stProc = FetchUserByEmail;
var pList = new List <SqlParameter>()
{
new SqlParameter("@Email", email)
};
var allData = UtilityDL.FillData <User>(stProc, pList);
return(allData);
}
public async Task <List <User> > FindByUsernameAsync(string userName)
{
var stProc = FetchUserByUsername;
var pList = new List <SqlParameter>()
{
new SqlParameter("@Username", userName)
};
var userDetail = UtilityDL.FillData <User>(stProc, pList);
return(userDetail);
}
public async Task <List <User> > FindByEmailAsync(string email)
{
var stProc = FetchUserByEmail;
var pList = new List <SqlParameter>()
{
new SqlParameter("@Email", email)
};
var userDetail = UtilityDL.FillData <User>(stProc, pList);
return(userDetail);
}
public List <User> RetrieveByUsername(string username)
{
string stProc = FetchUserByUsername;
var pList = new List <SqlParameter>()
{
new SqlParameter("@Username", username)
};
var allData = UtilityDL.FillData <User>(stProc, pList);
return(allData);
}
public List <Block> Retrieve(int code)
{
string stProc = FetchBlock;
var pList = new List <SqlParameter>()
{
new SqlParameter("@ID", code)
};
var allData = UtilityDL.FillData <Block>(stProc, pList);
return(allData);
}
public List <Threshold> Retrieve(int code)
{
string stProc = FetchThresholdValue;
var pList = new List <SqlParameter>()
{
new SqlParameter("@ID", code)
};
var allData = UtilityDL.FillData <Threshold>(stProc, pList);
return(allData);
}
public async Task <List <UserModel> > FindByEmailAsync(string email)
{
var stProc = FindUserByEmail;
var pList = new List <SqlParameter>()
{
new SqlParameter("@USEREMAIL", email)
};
var user = UtilityDL.FillData <UserModel>(stProc, pList);
return(user);
}
public List <BarcodeSample> FetchBarcode(string barcodeNo)
{
string stProc = FetchBarcodeSample;
var pList = new List <SqlParameter>()
{
new SqlParameter("@Barcode", barcodeNo),
};
var allData = UtilityDL.FillData <BarcodeSample>(stProc, pList);
return(allData);
}
public List <ClinicalDiagnosis> Retrieve(int code)
{
string stProc = FetchClinicalDiagnosis;
var pList = new List <SqlParameter>()
{
new SqlParameter("@ID", code)
};
var allData = UtilityDL.FillData <ClinicalDiagnosis>(stProc, pList);
return(allData);
}
public List <Patient> GetPatient(int pId)
{
//changes 18 march
string stProc = Fetchpatient;
var pList = new List <SqlParameter>()
{
new SqlParameter("@GID", pId)
};
var allData = UtilityDL.FillData <Patient>(stProc, pList);
return(allData);
}
public List <ANWSubjectDetail> RetrieveANWDetail(ANWSubjectRequest asData)
{
string stProc = FetchANWSubjectDetail;
var pList = new List <SqlParameter>()
{
new SqlParameter("@ANMID", asData.anmId),
new SqlParameter("@FromDate", asData.fromDate ?? asData.fromDate),
new SqlParameter("@ToDate", asData.toDate ?? asData.toDate),
};
var allData = UtilityDL.FillData <ANWSubjectDetail>(stProc, pList);
return(allData);
}
public List <CHCANWSubjectDetail> RetrieveCHCANWDetail(CHCANWSubjectRequest casData)
{
string stProc = FetchCHCANWSubjectDetail;
var pList = new List <SqlParameter>()
{
new SqlParameter("@CHCId", casData.chcId),
new SqlParameter("@FromDate", casData.fromDate ?? casData.fromDate),
new SqlParameter("@ToDate", casData.toDate ?? casData.toDate),
new SqlParameter("@RegisteredFrom", casData.registeredFrom),
};
var allData = UtilityDL.FillData <CHCANWSubjectDetail>(stProc, pList);
return(allData);
}
public List <SubjectSamples> Retrieve(SubjectSampleRequest ssData)
{
string stProc = FetchSubjectNotSampleCollected;
var pList = new List <SqlParameter>()
{
new SqlParameter("@UserID", ssData.userId),
new SqlParameter("@FromDate", ssData.fromDate ?? ssData.fromDate),
new SqlParameter("@ToDate", ssData.toDate ?? ssData.toDate),
new SqlParameter("@SubjectType", ssData.subjectType),
new SqlParameter("@RegisteredFrom", ssData.registeredFrom),
};
var allData = UtilityDL.FillData <SubjectSamples>(stProc, pList);
return(allData);
}
public async Task <List <UserPassword> > CheckPasswordAsync(UserModel userModel)
{
try
{
var stProc = FindUserByEmail;
var pList = new List <SqlParameter>()
{
new SqlParameter("@USEREMAIL", userModel.Email)
};
var userPassword = UtilityDL.FillData <UserPassword>(stProc, pList);
return(userPassword);
}
catch (Exception e)
{
throw e;
}
}
public async Task <List <UsersPassword> > CheckPasswordAsync(User user)
{
try
{
var stProc = FetchUserByUsername;
var pList = new List <SqlParameter>()
{
new SqlParameter("@Username", user.userName)
};
var userPassword = UtilityDL.FillData <UsersPassword>(stProc, pList);
return(userPassword);
}
catch (Exception e)
{
throw e;
}
}
public SubjectDetails RetrieveSubjectDetail(SubjectDetailRequest sdData)
{
string stProc = FetchAllSubjectDetailByANM;
string stProc1 = FetchSubjectANMPrePC;
string stProc2 = FetchSubjectANMPNDTesting;
string stProc3 = FetchSubjectANMPostPC;
string stProc4 = FetchANMMTPService;
var pList = new List <SqlParameter>()
{
new SqlParameter("@UserId", sdData.userId),
new SqlParameter("@FromDate", sdData.fromDate.ToCheckNull()),
new SqlParameter("@ToDate", sdData.toDate.ToCheckNull())
};
var allPrimaryData = UtilityDL.FillData <SubjectPrimaryDetail>(stProc, pList);
var allAddressData = UtilityDL.FillData <SubjectAddresDetail>(stProc, pList);
var allPregnancyData = UtilityDL.FillData <SubjectPregnancyDetail>(stProc, pList);
var allParentData = UtilityDL.FillData <SubjectParentDetail>(stProc, pList);
var pList1 = new List <SqlParameter>()
{
new SqlParameter("@UserId", sdData.userId),
};
var allPrPC = UtilityDL.FillData <SubjectPrePNDTCounselling>(stProc1, pList1);
var allPNDTTest = UtilityDL.FillData <SubjectPNDTTesting>(stProc2, pList1);
var allPoPC = UtilityDL.FillData <SubjectPostPNDTCounselling>(stProc3, pList1);
var allMTP = UtilityDL.FillData <SubjectMTPService>(stProc4, pList1);
var subDetail = new SubjectDetails();
subDetail.PrimarySubjectList = allPrimaryData;
subDetail.AddressSubjectList = allAddressData;
subDetail.PregnancySubjectList = allPregnancyData;
subDetail.ParentSubjectList = allParentData;
subDetail.prePndtCounselling = allPrPC;
subDetail.pndtTesting = allPNDTTest;
subDetail.postPndtCounselling = allPoPC;
subDetail.mtpService = allMTP;
return(subDetail);
}
public SubjectDetails RetrieveParticularCHCSubjectDetail(SubjectsDetailRequest sdData)
{
string stProc = FetchCHCParticularSubjectDetail;
string stProc1 = FetchSubjectCHCPrePC;
string stProc2 = FetchSubjectCHCPNDTesting;
string stProc3 = FetchSubjectCHCPostPC;
string stProc4 = FetchCHCMTPService;
var pList = new List <SqlParameter>()
{
new SqlParameter("@UserId", sdData.userId),
new SqlParameter("@UniqueSubjectID", sdData.userInput ?? sdData.userInput),
};
var allPrimaryData = UtilityDL.FillData <SubjectPrimaryDetail>(stProc, pList);
var allAddressData = UtilityDL.FillData <SubjectAddresDetail>(stProc, pList);
var allPregnancyData = UtilityDL.FillData <SubjectPregnancyDetail>(stProc, pList);
var allParentData = UtilityDL.FillData <SubjectParentDetail>(stProc, pList);
var pList1 = new List <SqlParameter>()
{
new SqlParameter("@UserId", sdData.userId),
};
var allPrPC = UtilityDL.FillData <SubjectPrePNDTCounselling>(stProc1, pList1);
var allPNDTTest = UtilityDL.FillData <SubjectPNDTTesting>(stProc2, pList1);
var allPoPC = UtilityDL.FillData <SubjectPostPNDTCounselling>(stProc3, pList1);
var allMTP = UtilityDL.FillData <SubjectMTPService>(stProc4, pList1);
var subDetail = new SubjectDetails();
subDetail.PrimarySubjectList = allPrimaryData;
subDetail.AddressSubjectList = allAddressData;
subDetail.PregnancySubjectList = allPregnancyData;
subDetail.ParentSubjectList = allParentData;
subDetail.prePndtCounselling = allPrPC;
subDetail.pndtTesting = allPNDTTest;
subDetail.postPndtCounselling = allPoPC;
subDetail.mtpService = allMTP;
return(subDetail);
}