public List<TaxonRankName> GetOrderedRanks()
{
var mapper = new GenericMapperBuilder<TaxonRankName>().build();
return StoredProcToList<TaxonRankName>("spBiotaRankList", mapper);
}
public SiteGroup GetSiteGroup(int siteGroupId)
{
SiteGroup result = null;
var mapper = new GenericMapperBuilder<SiteGroup>().build();
SQLReaderForEach("SELECT * FROM tblSiteGroup where intSiteGroupID = @groupId", (reader) => {
result = mapper.Map(reader);
}, _P("groupId", siteGroupId));
return result;
}
public List<SiteExplorerNode> GetSiteVisitTemplates()
{
var mapper = new GenericMapperBuilder<SiteExplorerNode>().PostMapAction((n) => {
n.IsTemplate = true;
}).build();
return StoredProcToList("spSiteVisitListTemplates", mapper);
}
public List<RDEMaterial> GetRDEMaterial(int[] idlist, RDEObjectType idType=RDEObjectType.Material)
{
string type = GetRDEObjectTypeStr(idType);
var mapper = new GenericMapperBuilder<RDEMaterial>().Override(new IntToBoolConvertingMapper("Locked")).build();
return StoredProcToList("spMaterialGetRDEFromIDList", mapper, _P("vchrType", type), _P("txtIDList", idlist.Join(",")));
}
public List<RDESiteVisit> GetRDESiteVisits(int[] siteVisitIDs, RDEObjectType idType=RDEObjectType.SiteVisit)
{
string type = GetRDEObjectTypeStr(idType);
var mapper = new GenericMapperBuilder<RDESiteVisit>().Override(new IntToBoolConvertingMapper("Locked")).build();
var ids = siteVisitIDs.Join(",");
return StoredProcToList("spSiteVisitGetRDEFromIDList", mapper, _P("vchrType", type), _P("txtIDList", ids));
}
public Material GetMaterial(int materialID)
{
var mapper = new GenericMapperBuilder<Material>().Override(new TintToBoolConvertingMapper("tintTemplate")).build();
Material result = null;
StoredProcReaderFirst("spMaterialGet", (reader) => {
result = mapper.Map(reader);
}, _P("intMaterialID", materialID));
return result;
}
public List<MaterialPart> GetMaterialParts(int materialID)
{
var mapper = new GenericMapperBuilder<MaterialPart>().build();
return StoredProcToList("spMaterialPartGet", mapper, _P("intMaterialID", materialID));
}
public List<LoanCorrespondence> GetLoanCorrespondence(int loanId)
{
var mapper = new GenericMapperBuilder<LoanCorrespondence>().build();
return StoredProcToList("spLoanCorrList", mapper, _P("intLoanID", loanId));
}
public List<LoanMaterial> GetLoanMaterial(int loanId)
{
var mapper = new GenericMapperBuilder<LoanMaterial>().build();
return StoredProcToList("spLoanMaterialList", mapper, _P("intLoanID", loanId));
}
public List<Loan> FindLoansByTaxon(string taxon, bool findOpenLoansOnly)
{
taxon = EscapeSearchTerm(taxon, true);
var sql = @"SELECT DISTINCT L.*, REQ.vchrTitle AS [RequestorTitle], REQ.vchrGivenName AS [RequestorGivenName], REQ.vchrName AS [RequestorName],
REC.vchrTitle AS [ReceiverTitle], REC.vchrGivenName AS [ReceiverGivenName], REC.vchrName AS [ReceiverName],
ORIG.vchrTitle AS [OriginatorTitle], ORIG.vchrGivenName AS [OriginatorGivenName], ORIG.vchrName AS [OriginatorName]
FROM ((((tblLoan L INNER JOIN tblLoanMaterial LM ON L.intLoanID = LM.intLoanID)
LEFT OUTER JOIN tblContact REQ ON L.intRequestorID = REQ.intContactID)
LEFT OUTER JOIN tblContact REC ON L.intReceiverID = REC.intContactID)
LEFT OUTER JOIN tblContact ORIG ON L.intOriginatorID = ORIG.intContactID)
WHERE (LM.vchrTaxonName like @taxonName or LM.vchrMaterialDescription like @taxonName)";
if (findOpenLoansOnly) {
sql += " AND L.bitLoanClosed = 0";
}
var mapper = new GenericMapperBuilder<Loan>().build();
var list = new List<Loan>();
SQLReaderForEach(sql, (reader) => {
list.Add(mapper.Map(reader));
}, _P("@taxonName", taxon));
return list;
}
public Loan GetLoan(int loanID)
{
var mapper = new GenericMapperBuilder<Loan>().build();
return StoredProcGetOne("spLoanGet", mapper, _P("intLoanID", loanID));
}
public List<Loan> FindLoans(string filter, string what, bool findOpenLoansOnly)
{
filter = filter.Replace("*", "%");
if (what.Equals("t", StringComparison.CurrentCultureIgnoreCase)) {
return FindLoansByTaxon(filter, findOpenLoansOnly);
}
var mapper = new GenericMapperBuilder<Loan>().build();
var list = StoredProcToList("spLoanFind", mapper, _P("vchrFieldType", what), _P("vchrFieldValue", filter), _P("bitOnlyActiveLoans", findOpenLoansOnly));
return list;
}
public SpeciesAvailableName GetSpeciesAvailableName(int taxonId)
{
var mapper = new GenericMapperBuilder<SpeciesAvailableName>().build();
SpeciesAvailableName result = null;
StoredProcReaderFirst("spSANGet", (reader)=> {
result = mapper.Map(reader);
}, _P("intBiotaID", taxonId));
return result;
}
public List<SANTypeData> GetSANTypeData(int taxonId)
{
var mapper = new GenericMapperBuilder<SANTypeData>().Map("vchrAccessionNum", "AccessionNumber").build();
return StoredProcToList("spSANTypeDataGet", mapper, _P("intBiotaID", taxonId));
}
public List<CurationEvent> GetCurationEvents(int materialID)
{
var mapper = new GenericMapperBuilder<CurationEvent>().build();
return StoredProcToList("spCurationEventGet", mapper, _P("intMaterialID", materialID));
}
public List<LoanReminder> GetLoanReminders(int loanId)
{
var mapper = new GenericMapperBuilder<LoanReminder>().build();
return StoredProcToList("spLoanReminderList", mapper, _P("intLoanID", loanId));
}
public List<SiteExplorerNode> GetExplorerElementsForParent(int parentID, string parentElemType)
{
var mapper = new GenericMapperBuilder<SiteExplorerNode>().build();
return StoredProcToList<SiteExplorerNode>("spSiteExplorerList",
mapper,
_P("intParentID", parentID),
_P("vchrParentType", parentElemType)
);
}
public List<LoanReminderEx> GetRemindersDue(DateTime dateTime)
{
var mapper = new GenericMapperBuilder<LoanReminderEx>().build();
return StoredProcToList("spLoanReminderDue", mapper, _P("dtDueByDate", dateTime));
}
public List<MaterialIdentification> GetMaterialIdentification(int materialID)
{
var mapper = new GenericMapperBuilder<MaterialIdentification>().build();
return StoredProcToList("spMaterialIDGet", mapper, _P("intMaterialID", materialID));
}
public LoanMaterial GetSingleLoanMaterial(int loanMaterialID)
{
var mapper = new GenericMapperBuilder<LoanMaterial>().build();
return StoredProcGetOne("spLoanMaterialGet", mapper, _P("intLoanMaterialID", loanMaterialID));
}
public List<MaterialPart> GetMaterialParts(params int[] materialIds)
{
var mapper = new GenericMapperBuilder<MaterialPart>().build();
var ids = materialIds.Join(",");
return StoredProcToList("spMaterialPartGetRDEFromIDList", mapper, _P("txtMaterialIDList", ids));
}
public List<Contact> ListContactsRange(string from, string to)
{
var strWhere = "left(vchrName," + from.Length + ") between '" + from + "' and '" + to + "'";
var mapper = new GenericMapperBuilder<Contact>().build();
return StoredProcToList("spContactListRange", mapper, _P("vchrWhere", strWhere));
}
public List<RDESite> GetRDESites(params int[] siteIds)
{
var mapper = new GenericMapperBuilder<RDESite>().Override(new IntToBoolConvertingMapper("Locked")).build();
string siteIdList = siteIds.Join(",");
return StoredProcToList("spSiteGetRDEFromIDList", mapper, _P("vchrSiteIDList", siteIdList));
}
public List<Loan> ListLoansForContact(int contactID)
{
var mapper = new GenericMapperBuilder<Loan>().build();
return StoredProcToList("spLoanListForContact", mapper, _P("intContactID", contactID));
}
public Region GetRegion(int regionID)
{
var mapper = new GenericMapperBuilder<Region>().build();
Region result = null;
StoredProcReaderFirst("spRegionGet", (reader) => {
result = mapper.Map(reader);
}, _P("intRegionID", regionID));
return result;
}
public List<SiteExplorerNode> FindNodesByName(string searchTerm, string limitations)
{
searchTerm = EscapeSearchTerm(searchTerm, true);
var mapper = new GenericMapperBuilder<SiteExplorerNode>().build();
return StoredProcToList<SiteExplorerNode>("spSiteFindByName",
mapper,
_P("vchrLimitations", limitations),
_P("vchrSiteToFind", searchTerm)
);
}
public SiteVisit GetSiteVisit(int siteVisitID)
{
var mapper = new GenericMapperBuilder<SiteVisit>().Override(new TintToBoolConvertingMapper("tintTemplate")).build();
SiteVisit result = null;
StoredProcReaderFirst("spSiteVisitGet", (reader) => {
result = mapper.Map(reader);
}, _P("intSiteVisitID", siteVisitID));
return result;
}
public List<RegionSearchResult> FindRegions(string searchTerm)
{
searchTerm = EscapeSearchTerm(searchTerm, true);
var mapper = new GenericMapperBuilder<RegionSearchResult>().build();
return StoredProcToList("spRegionFind", mapper, _P("vchrRegionToFind", searchTerm));
}
public Trap GetTrap(int trapID)
{
Trap trap = null;
var mapper = new GenericMapperBuilder<Trap>().build();
StoredProcReaderFirst("spTrapGet", (reader) => {
trap = mapper.Map(reader);
}, _P("intTrapID", trapID));
return trap;
}
public List<GANIncludedSpecies> GetGenusAvailableNameIncludedSpecies(int taxonId)
{
var mapper = new GenericMapperBuilder<GANIncludedSpecies>().build();
return StoredProcToList("spGANIncludedSpeciesGet", mapper, _P("intBiotaID", taxonId));
}
