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 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 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 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 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);
}
public SubjectPrimaryDetail subjectPrimary(SubjectPrimaryDetailRequest sprData)
{
try
{
string stProc = AddSubjectPrimaryDetail;
var pList = new List <SqlParameter>
{
new SqlParameter("@SubjectTypeID", Convert.ToInt32(sprData.subjectTypeId)),
new SqlParameter("@ChildSubjectTypeID", Convert.ToInt32(sprData.childSubjectTypeId)),
new SqlParameter("@UniqueSubjectID", sprData.uniqueSubjectId.ToCheckNull()),
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("@Createdby", Convert.ToInt32(sprData.createdBy)),
new SqlParameter("@Source", sprData.source),
// new SqlParameter("@SpouseWillingness", sprData.spouseWillingness ?? true),
};
var subPrimary = UtilityDL.FillEntity <SubjectPrimaryDetail>(stProc, pList);
return(subPrimary);
}
catch (Exception e)
{
throw e;
}
}
public async Task <MobileLogin> ResetLogin(string userName)
{
try
{
var stProc = ResetANMLogin;
var pList = new List <SqlParameter>()
{
new SqlParameter("@UserName", userName),
};
var allData = UtilityDL.FillEntity <MobileLogin>(stProc, pList);
return(allData);
}
catch (Exception e)
{
throw e;
}
}
public async Task <MobileLogin> Logout(int anmId)
{
try
{
var stProc = LogoutUser;
var pList = new List <SqlParameter>()
{
new SqlParameter("@ANMId", anmId),
};
var allData = UtilityDL.FillEntity <MobileLogin>(stProc, pList);
return(allData);
}
catch (Exception e)
{
throw e;
}
}
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 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 async Task <WebLogin> CheckWebLogin(int userId, string userName)
{
try
{
var stProc = FetchWebLoginStatus;
var pList = new List <SqlParameter>()
{
new SqlParameter("@ANMId", userId),
new SqlParameter("@UserName", userName),
};
var allData = UtilityDL.FillEntity <WebLogin>(stProc, pList);
return(allData);
}
catch (Exception e)
{
throw e;
}
}
public AddEditMasters Add(ClinicalDiagnosisRequest cdData)
{
try
{
string stProc = AddClinicalDiagnosis;
var pList = new List <SqlParameter>
{
new SqlParameter("@Diagnosisname", cdData.diagnosisName ?? cdData.diagnosisName),
new SqlParameter("@Isactive", cdData.isActive ?? cdData.isActive),
new SqlParameter("@Comments", cdData.comments ?? cdData.comments),
new SqlParameter("@Createdby", cdData.createdBy),
new SqlParameter("@Updatedby", cdData.updatedBy),
};
var returnData = UtilityDL.FillEntity <AddEditMasters>(stProc, pList);
return(returnData);
}
catch (Exception e)
{
throw e;
}
}
public AddEditMasters Add(GovIDTypeRequest gtData)
{
try
{
string stProc = AddGovIDType;
var pList = new List <SqlParameter>
{
new SqlParameter("@GovIDType", gtData.govIdTypeName ?? gtData.govIdTypeName),
new SqlParameter("@Isactive", gtData.isActive ?? gtData.isActive),
new SqlParameter("@Comments", gtData.comments ?? gtData.comments),
new SqlParameter("@Createdby", gtData.createdBy),
new SqlParameter("@Updatedby", gtData.updatedBy),
};
var returnData = UtilityDL.FillEntity <AddEditMasters>(stProc, pList);
return(returnData);
}
catch (Exception e)
{
throw e;
}
}
public AddEditMasters Add(CommunityRequest cData)
{
try
{
string stProc = AddCommunity;
var pList = new List <SqlParameter>
{
new SqlParameter("@CasteID", cData.casteId),
new SqlParameter("@Communityname", cData.communityName ?? cData.communityName),
new SqlParameter("@Isactive", cData.isActive ?? cData.isActive),
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 AddEditMasters Add(UserRoleRequest urData)
{
try
{
string stProc = AddUserRole;
var pList = new List<SqlParameter>
{
new SqlParameter("@UserTypeID", urData.userTypeId),
new SqlParameter("@Userrolename", urData.userRoleName ?? urData.userRoleName),
new SqlParameter("@Isactive", urData.isActive ?? urData.isActive),
new SqlParameter("@Comments", urData.comments ?? urData.comments),
new SqlParameter("@Createdby", urData.createdBy),
new SqlParameter("@Updatedby", urData.updatedBy),
};
var returnData = UtilityDL.FillEntity<AddEditMasters>(stProc, pList);
return returnData;
}
catch (Exception e)
{
throw e;
}
}
public AddEditMasters AddBlock(BlockRequest bData)
{
try
{
string stProc = AddBlocks;
var pList = new List <SqlParameter>
{
new SqlParameter("@Block_gov_code", bData.blockGovCode),
new SqlParameter("@DistrictID", bData.districtId),
new SqlParameter("@Blockname", bData.blockName ?? bData.blockName),
new SqlParameter("@Isactive", bData.isActive ?? bData.isActive),
new SqlParameter("@Comments", bData.comments ?? bData.comments),
new SqlParameter("@Createdby", bData.createdBy),
new SqlParameter("@Updatedby", bData.updatedBy),
};
var returnData = UtilityDL.FillEntity <AddEditMasters>(stProc, pList);
return(returnData);
}
catch (Exception e)
{
throw e;
}
}
public AddEditMasters Add(SubjectTypeRequest stData)
{
try
{
string stProc = AddSubjectType;
var retVal = new SqlParameter("@Scope_output", 1);
retVal.Direction = ParameterDirection.Output;
var pList = new List <SqlParameter>
{
new SqlParameter("@SubjectType", stData.subectTypeName ?? stData.subectTypeName),
new SqlParameter("@Isactive", stData.isActive ?? stData.isActive),
new SqlParameter("@Comments", stData.comments ?? stData.comments),
new SqlParameter("@Createdby", stData.createdBy),
new SqlParameter("@Updatedby", stData.updatedBy),
};
var returnData = UtilityDL.FillEntity <AddEditMasters>(stProc, pList);
return(returnData);
}
catch (Exception e)
{
throw e;
}
}
public AddEditMasters Add(StateRequest state)
{
try
{
string stProc = AddState;
var pList = new List <SqlParameter>
{
new SqlParameter("@State_gov_code", state.stateGovCode ?? state.stateGovCode),
new SqlParameter("@Statename", state.stateName ?? state.stateName),
new SqlParameter("@Shortname", state.shortName ?? state.shortName),
new SqlParameter("@Isactive", state.isActive ?? state.isActive),
new SqlParameter("@Comments", state.comments ?? state.comments),
new SqlParameter("@Createdby", state.createdBy),
new SqlParameter("@Updatedby", state.updatedBy),
};
var returnData = UtilityDL.FillEntity <AddEditMasters>(stProc, pList);
return(returnData);
}
catch (Exception e)
{
throw e;
}
}
public AddEditMasters Add(DistrictRequest dData)
{
try
{
string stProc = AddDistrict;
var pList = new List <SqlParameter>
{
new SqlParameter("@District_gov_code", dData.districtGovCode),
new SqlParameter("@StateID", dData.stateId),
new SqlParameter("@Districtname", dData.districtName ?? dData.districtName),
new SqlParameter("@Isactive", dData.isActive ?? dData.isActive),
new SqlParameter("@Comments", dData.comments ?? dData.comments),
new SqlParameter("@Createdby", dData.createdBy),
new SqlParameter("@Updatedby", dData.updatedBy),
};
var returnData = UtilityDL.FillEntity <AddEditMasters>(stProc, pList);
return(returnData);
}
catch (Exception e)
{
throw e;
}
}