public async Task <int> CreateUserAsync(UserModel userModel, string password)
{
var recInsert = 0;
try
{
var stProc = CreateUser;
var retVal = new SqlParameter("@SCOPE_OUTPUT", 10)
{
Direction = ParameterDirection.Output
};
var pList = new List <SqlParameter>()
{
new SqlParameter("@USEREMAIL", userModel.Email),
new SqlParameter("@PASSWORD", password),
new SqlParameter("@FIRSTNAME", userModel.FirstName ?? string.Empty),
new SqlParameter("@LASTNAME", userModel.LastName ?? string.Empty),
retVal
};
recInsert = Convert.ToInt32(UtilityDL.ExecuteNonQuery(stProc, pList, true));
return(recInsert);
}
catch (Exception ex)
{
throw ex;
}
}
public AddEditMasters Add(PHCRequest pData)
{
try
{
string stProc = AddPHC;
var pList = new List <SqlParameter>
{
new SqlParameter("@CHCID", pData.chcId),
new SqlParameter("@HNIN_ID", pData.hninId ?? pData.hninId),
new SqlParameter("@PHC_gov_code", pData.phcGovCode),
new SqlParameter("@PHCname", pData.phcName ?? pData.phcName),
new SqlParameter("@Pincode", pData.pincode ?? pData.pincode),
new SqlParameter("@Isactive", pData.isActive ?? pData.isActive),
new SqlParameter("@Latitude", pData.latitude ?? pData.latitude),
new SqlParameter("@Longitude", pData.longitude ?? pData.longitude),
new SqlParameter("@Comments", pData.comments ?? pData.comments),
new SqlParameter("@Createdby", pData.createdBy),
new SqlParameter("@Updatedby", pData.updatedBy),
};
var returnData = UtilityDL.FillEntity <AddEditMasters>(stProc, pList);
return(returnData);
}
catch (Exception e)
{
throw e;
}
}
public string AddSample(AddSubjectSampleRequest ssData)
{
try
{
string stProc = AddSampleCollection;
var retVal = new SqlParameter("@Scope_output", 1);
retVal.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);
return($"Sample collected successfully");
}
catch (Exception e)
{
throw e;
}
}
public AddEditMasters Add(CHCRequest cData)
{
try
{
string stProc = AddCHC;
var pList = new List <SqlParameter>
{
new SqlParameter("@BlockID", cData.blockId),
new SqlParameter("@DistrictID", cData.districtId),
new SqlParameter("@HNIN_ID", cData.hninId ?? cData.hninId),
new SqlParameter("@CHC_gov_code", cData.chcGovCode),
new SqlParameter("@CHCname", cData.chcName ?? cData.chcName),
new SqlParameter("@Istestingfacility", cData.isTestingFacility ?? cData.isTestingFacility),
new SqlParameter("@TestingCHCID", cData.testingCHCId),
new SqlParameter("@CentralLabId", cData.centralLabId),
new SqlParameter("@Pincode", cData.pincode ?? cData.pincode),
new SqlParameter("@Isactive", cData.isActive ?? cData.isActive),
new SqlParameter("@Latitude", cData.latitude ?? cData.latitude),
new SqlParameter("@Longitude", cData.longitude ?? cData.longitude),
new SqlParameter("@Comments", cData.comments ?? cData.comments),
new SqlParameter("@Createdby", cData.createdBy),
new SqlParameter("@Updatedby", cData.updatedBy),
};
var returnData = UtilityDL.FillEntity <AddEditMasters>(stProc, pList);
return(returnData);
}
catch (Exception e)
{
throw e;
}
}
public void SubjectPregnancy(SubjectPregnancyDetailRequest spData, string uniqueSubID)
{
try
{
var stProc = AddSubjectPregnancyDetail;
var retVal = new SqlParameter("@SCOPE_OUTPUT", 1)
{
Direction = ParameterDirection.Output
};
var pList = new List <SqlParameter>()
{
new SqlParameter("@UniqueSubjectID", uniqueSubID),
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 string Add(TestTypeRequest ttData)
{
try
{
string stProc = AddTestType;
var retVal = new SqlParameter("@Scope_output", 1);
retVal.Direction = ParameterDirection.Output;
var pList = new List <SqlParameter>
{
new SqlParameter("@TestType", ttData.testTypeName ?? ttData.testTypeName),
new SqlParameter("@Isactive", ttData.isactive ?? ttData.isactive),
new SqlParameter("@Comments", ttData.comments ?? ttData.comments),
new SqlParameter("@Createdby", ttData.createdby),
new SqlParameter("@Updatedby", ttData.updatedby),
retVal
};
UtilityDL.ExecuteNonQuery(stProc, pList);
return("Test type added successfully");
}
catch (Exception e)
{
throw e;
}
}
public List<UserRole> Retrieve()
{
string stProc = FetchUserRoles;
var pList = new List<SqlParameter>();
var allData = UtilityDL.FillData<UserRole>(stProc, pList);
return allData;
}
public void SubjectAddress(SubjectAddressDetailRequest saData, string uniqueSubId)
{
try
{
var stProc = AddSubjectAddressDetail;
var retVal = new SqlParameter("@SCOPE_OUTPUT", 1)
{
Direction = ParameterDirection.Output
};
var pList = new List <SqlParameter>()
{
new SqlParameter("@UniqueSubjectID", uniqueSubId),
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 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 string Add(Patient patient)
{
try
{
string stProc = AddPatient;
var retVal = new SqlParameter("@SCOPE_OUTPUT", 1)
{
Direction = ParameterDirection.Output
};
var pList = new List <SqlParameter>
{
new SqlParameter("@GID", patient.GovtId),
new SqlParameter("@FIRSTNAME", patient.FirstName ?? patient.FirstName),
new SqlParameter("@LASTNAME", patient.LastName ?? patient.LastName),
new SqlParameter("@LOCATION", patient.Location ?? patient.Location),
retVal
};
UtilityDL.ExecuteNonQuery(stProc, pList);
return("Patient added successfully");
}
catch (Exception e)
{
throw e;
}
}
public AddEditMasters Add(RIRequest rData)
{
try
{
string stProc = AddRI;
var pList = new List <SqlParameter>
{
new SqlParameter("@TestingCHCID", rData.testingCHCId),
new SqlParameter("@CHCID", rData.chcId),
new SqlParameter("@PHCID", rData.phcId),
new SqlParameter("@SCID", rData.scId),
new SqlParameter("@RI_gov_code", rData.riGovCode),
new SqlParameter("@RIsite", rData.riSite ?? rData.riSite),
new SqlParameter("@Pincode", rData.pincode ?? rData.pincode),
new SqlParameter("@ILRID", rData.ilrId),
new SqlParameter("@Isactive", rData.isActive ?? rData.isActive),
new SqlParameter("@Latitude", rData.latitude ?? rData.latitude),
new SqlParameter("@Longitude", rData.longitude ?? rData.longitude),
new SqlParameter("@Comments", rData.comments ?? rData.comments),
new SqlParameter("@Createdby", rData.createdBy),
new SqlParameter("@Updatedby", rData.updatedBy),
};
var returnData = UtilityDL.FillEntity <AddEditMasters>(stProc, pList);
return(returnData);
}
catch (Exception e)
{
throw e;
}
}
public List <Patient> GetPatients()
{
string stProc = GetAllpatients;
var pList = new List <SqlParameter>();
var allData = UtilityDL.FillData <Patient>(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 <ClinicalDiagnosis> Retrieve()
{
string stProc = FetchAllClinicalDiagnosis;
var pList = new List <SqlParameter>();
var allData = UtilityDL.FillData <ClinicalDiagnosis>(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 <SubjectType> Retrieve()
{
string stProc = FetchSubjectTypes;
var pList = new List <SqlParameter>();
var allData = UtilityDL.FillData <SubjectType>(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 <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 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 SMSSamplesDetails FetchSMSSamplesByBarcode(string barcodeNo)
{
string stProc = FetchSampleDetailsForSMSbyBarcode;
var pList = new List <SqlParameter>()
{
new SqlParameter("@Barcode", barcodeNo),
};
var allData = UtilityDL.FillEntity <SMSSamplesDetails>(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 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 <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 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 <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 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 <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 SMSSamplesDetails FetchSMSSamples(string barcodeNo, string subjectId)
{
string stProc = FetchSMSSample;
var pList = new List <SqlParameter>()
{
new SqlParameter("@Barcode", barcodeNo),
new SqlParameter("@SubjectId", subjectId),
};
var allData = UtilityDL.FillEntity <SMSSamplesDetails>(stProc, pList);
return(allData);
}
