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 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 GenusAvailableName GetGenusAvailableName(int taxonId)
{
var mapper = new GenericMapperBuilder <GenusAvailableName>().build();
GenusAvailableName result = null;
StoredProcReaderFirst("spGANGet", (reader) => {
result = mapper.Map(reader);
}, _P("intBiotaID", taxonId));
return(result);
}
public XMLIOMultimedia GetMultimedia(int mediaId)
{
var mapper = new GenericMapperBuilder <XMLIOMultimedia>().build();
XMLIOMultimedia ret = null;
StoredProcReaderFirst("spXMLExportMultimediaGet", (reader) => {
ret = mapper.Map(reader);
}, _P("intMultimediaID", mediaId));
return(ret);
}
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 bool UpdateTaxon(XMLImportTaxon taxon)
{
string strRankCode;
string strKingdomCode;
bool bRankAdded;
bool bKingdomAdded;
if (!GetRankCodeFromName(taxon.Rank, out strRankCode, out bRankAdded))
{
Logger.Debug("Failed to get rank code for taxon: RankName={0}, TaxonGUID={1}", taxon.Rank, taxon.GUID);
return(false);
}
if (!GetKingdomCodeFromName(taxon.Kingdom, out strKingdomCode, out bKingdomAdded))
{
Logger.Debug("Failed to get kingdom code for taxon: KingdomName={0}, TaxonGUID={1}", taxon.Kingdom, taxon.GUID);
}
var UpdateStr = taxon.UpdateClause + ", chrElemType='" + strRankCode + "'";
var mapper = new GenericMapperBuilder <XMLImportTaxon>().build();
bool succeeded = false;
StoredProcReaderFirst("spXMLImportBiotaUpdate", (reader) => {
mapper.Map(reader, taxon);
succeeded = true;
}, _P("vchrBiotaID", taxon.ID), _P("txtUpdateSetClause", UpdateStr));
if (!succeeded)
{
// ErrorMsg = "[BIXMLIOServer.TaxonUpdate()] Failed to update Biota details! (TaxonID=" & TaxonID & ",UpdateStr='" & UpdateStr & "') - " & user.LastError
return(false);
}
else
{
return(true);
}
}
public List <XMLIOMaterialID> GetMaterialForTaxon(int biotaId)
{
var mapper = new GenericMapperBuilder <XMLIOMaterialID>().build();
return(StoredProcToList("spMaterialIDListForTaxon", mapper, _P("intBiotaID", biotaId)));
}
public List <StorageLocation> GetStorageLocations(int taxonId)
{
var mapper = new GenericMapperBuilder <StorageLocation>().build();
return(StoredProcToList("spBiotaLocationGet", mapper, _P("intBiotaID", taxonId)));
}
public List <TaxonDistribution> GetDistribution(int?TaxonID)
{
var mapper = new GenericMapperBuilder <TaxonDistribution>().build();
return(StoredProcToList("spBiotaDistGet", mapper, _P("intBiotaID", TaxonID.Value)));
}
public List <CommonName> GetCommonNames(int taxonId)
{
var mapper = new GenericMapperBuilder <CommonName>().Map("CommonName", "Name").build();
return(StoredProcToList("spCommonNameGet", mapper, _P("intBiotaID", taxonId)));
}
public List <GANIncludedSpecies> GetGenusAvailableNameIncludedSpecies(int taxonId)
{
var mapper = new GenericMapperBuilder <GANIncludedSpecies>().build();
return(StoredProcToList("spGANIncludedSpeciesGet", mapper, _P("intBiotaID", taxonId)));
}
public Loan GetLoan(int loanID)
{
var mapper = new GenericMapperBuilder <Loan>().build();
return(StoredProcGetOne("spLoanGet", mapper, _P("intLoanID", loanID)));
}
public XMLIORegion GetRegion(int regionId)
{
var mapper = new GenericMapperBuilder <XMLIORegion>().build();
return(StoredProcGetOne("spExportRegionGet", mapper, _P("intRegionID", regionId)));
}
public List <LoanReminderEx> GetRemindersDue(DateTime dateTime)
{
var mapper = new GenericMapperBuilder <LoanReminderEx>().build();
return(StoredProcToList("spLoanReminderDue", mapper, _P("dtDueByDate", dateTime)));
}
public List <LoanReminder> GetLoanReminders(int loanId)
{
var mapper = new GenericMapperBuilder <LoanReminder>().build();
return(StoredProcToList("spLoanReminderList", 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 <LoanCorrespondence> GetLoanCorrespondence(int loanId)
{
var mapper = new GenericMapperBuilder <LoanCorrespondence>().build();
return(StoredProcToList("spLoanCorrList", mapper, _P("intLoanID", loanId)));
}
public LoanMaterial GetSingleLoanMaterial(int loanMaterialID)
{
var mapper = new GenericMapperBuilder <LoanMaterial>().build();
return(StoredProcGetOne("spLoanMaterialGet", mapper, _P("intLoanMaterialID", loanMaterialID)));
}
public List <XMLIOMultimediaLink> GetExportMultimediaLinks(string category, int intraCatId)
{
var mapper = new GenericMapperBuilder <XMLIOMultimediaLink>().build();
return(StoredProcToList("spXMLExportMultimediaList", mapper, _P("vchrCategory", category), _P("intIntraCatID", intraCatId)));
}
public List <TaxonRankName> GetOrderedRanks()
{
var mapper = new GenericMapperBuilder <TaxonRankName>().build();
return(StoredProcToList <TaxonRankName>("spBiotaRankList", mapper));
}
public XMLIOMaterial GetMaterial(int materialId)
{
var mapper = new GenericMapperBuilder <XMLIOMaterial>().Override(new ByteToBoolConvertingMapper("tintTemplate")).build();
return(StoredProcGetOne("spExportMaterialGet", mapper, _P("intMaterialID", materialId)));
}
public List <SANTypeData> GetSANTypeData(int taxonId)
{
var mapper = new GenericMapperBuilder <SANTypeData>().Map("vchrAccessionNum", "AccessionNumber").build();
return(StoredProcToList("spSANTypeDataGet", mapper, _P("intBiotaID", taxonId)));
}
public XMLIOSiteVisit GetSiteVisit(int siteVisitId)
{
var mapper = new GenericMapperBuilder <XMLIOSiteVisit>().Override(new ByteToBoolConvertingMapper("tintTemplate")).build();
return(StoredProcGetOne("spExportSiteVisitGet", mapper, _P("intVisitID", siteVisitId)));
}
public List <Loan> ListLoansForContact(int contactID)
{
var mapper = new GenericMapperBuilder <Loan>().build();
return(StoredProcToList("spLoanListForContact", mapper, _P("intContactID", contactID)));
}
