/*For Global*/
public TenderDetailInfo GetAllSearchGlobalTenderList(int searchType, string searchText, string countryIds = "",
int?tenderStatus = null, int start = 0, int limit = 20, bool isSearchWithCount = true,
string productIds = "", string agencyIds = "", int?tenderType = null,
DateTime?subDateFrom = null, DateTime?subDateTo = null, DateTime?opDateFrom = null, DateTime?opDateTo = null,
int?ourRefNo = null, string WithinSearchText = null, string OtherSearchText = null)
{
List <SearchTenaderInfoWithAllDetail> tenderList = new List <SearchTenaderInfoWithAllDetail>();
List <TenderCount> tenderCount = new List <TenderCount>();
var resultData = _db.Proc_TA_SearchGlobalTenderList(searchType, searchText, countryIds, tenderStatus, start, limit, productIds, agencyIds, tenderType,
subDateFrom, subDateTo, opDateFrom, opDateTo, ourRefNo, WithinSearchText);
Utility.ToList(resultData, tenderList);
if (isSearchWithCount)
{
var resultCount = _db.Proc_TA_SearchGlobalTenderCount(searchType, searchText, countryIds, productIds, agencyIds, tenderType,
subDateFrom, subDateTo, opDateFrom, opDateTo, ourRefNo, WithinSearchText);
Utility.ToList(resultCount, tenderCount);
}
TenderDetailInfo tenders = new TenderDetailInfo()
{
TenaderDetailSearch = tenderList,
TenaderDetailCount = tenderCount
};
return(tenders);
}
/*For User*/
public TenderDetailInfo GetAllSearchTenderInfo_Client(int?permissionId, int?start, int?limit, int?tenderStatusFlag,
DateTime?enterDate, string searchText, int?OurRefNo, string ownershipId, string sectorId, string agencyId, string indSub, string loc,
string keyword1, string keyword2, string keyword3, string otherKeywords, string notUsedKeywords,
string documentType, string isIcbncb, string tenderValue, decimal?tenderValueFrom, decimal?tenderValueTo, Boolean indianGlobal,
Boolean IsOnlyCount, string WithinSearchText = "",
DateTime?subDateFrom = null, DateTime?subDateTo = null, DateTime?opDateFrom = null, DateTime?opDateTo = null, string globalCountryIds = "")//int? orderByType = null
{
List <SearchTenaderInfoWithAllDetail> tenderList = new List <SearchTenaderInfoWithAllDetail>();
List <TenderCount> tenderCount = new List <TenderCount>();
var resultData = _db.Proc_TA_ClientTenderList(permissionId, start, limit, tenderStatusFlag == null ? "" : tenderStatusFlag.Value.ToString(), enterDate, searchText, OurRefNo, ownershipId, sectorId, agencyId, indSub, loc,
keyword1, keyword2, keyword3, otherKeywords, notUsedKeywords, documentType, isIcbncb, tenderValue, tenderValueFrom, tenderValueTo, indianGlobal, WithinSearchText,
subDateFrom, subDateTo, opDateFrom, opDateTo, globalCountryIds);
Utility.ToList(resultData, tenderList);
if (IsOnlyCount)
{
var resultCount = _db.Proc_TA_ClientTenderCount(permissionId, start, limit, tenderStatusFlag == null ? "" : tenderStatusFlag.Value.ToString(), enterDate, searchText, OurRefNo, ownershipId, sectorId, agencyId, indSub, loc,
keyword1, keyword2, keyword3, otherKeywords, notUsedKeywords, documentType, isIcbncb, tenderValue, tenderValueFrom, tenderValueTo, indianGlobal, WithinSearchText,
subDateFrom, subDateTo, opDateFrom, opDateTo, globalCountryIds);
Utility.ToList(resultCount, tenderCount);
}
TenderDetailInfo tenders = new TenderDetailInfo()
{
TenaderDetailSearch = tenderList,
TenaderDetailCount = tenderCount
};
return(tenders);
}
public TenderDetailInfo GetAllSearchIndianTenderList(int tenderBy, int searchType, string searchText,
string productIds = "", string locationIds = "", string indSubindIds = "", string agencyIds = "", string sectorIds = "", string ownershipIds = "", string refIds = "",
int?tenderStatus = null, int start = 0, int limit = 20, bool isSearchWithCount = true, string tenderYear = null, int?tenderType = null,
int?TenderValueType = null, DateTime?subDateFrom = null, DateTime?subDateTo = null, DateTime?opDateFrom = null, DateTime?opDateTo = null,
int?ourRefNo = null, bool?icbNcb = null, string OtherSearchText = null, string WithinSearchText = null, int?orderByType = null)
{
List <SearchTenaderInfoWithAllDetail> tenderList = new List <SearchTenaderInfoWithAllDetail>();
List <TenderCount> tenderCount = new List <TenderCount>();
if (orderByType == null)
{
orderByType = 3;
}
var resultData = _db.Proc_TA_SearchIndianTenderList(tenderBy, searchType, searchText, productIds, locationIds, indSubindIds, agencyIds, sectorIds, ownershipIds, refIds,
tenderStatus, start, limit, false, tenderYear, tenderType, TenderValueType, subDateFrom, subDateTo, opDateFrom, opDateTo, ourRefNo, icbNcb,
OtherSearchText, WithinSearchText, orderByType);
Utility.ToList(resultData, tenderList);
if (isSearchWithCount)
{
var resultCount = _db.Proc_TA_SearchIndianTenderCount(tenderBy, searchType, searchText, productIds, locationIds, indSubindIds, agencyIds, sectorIds, ownershipIds, refIds,
tenderStatus, start, limit, true, tenderYear, tenderType, TenderValueType, subDateFrom, subDateTo, opDateFrom, opDateTo, ourRefNo, icbNcb,
OtherSearchText, WithinSearchText);
Utility.ToList(resultCount, tenderCount);
}
TenderDetailInfo tenders = new TenderDetailInfo()
{
TenaderDetailSearch = tenderList,
TenaderDetailCount = tenderCount
};
return(tenders);
}
public TenderDetailInfo GetAllSearchTenderInfo_Client_SampleTender(int?permissionId, int?start, int?limit, int?tenderStatusFlag, bool?iscount,
ref string ownershipId, ref string ownershipIdNotUsedIn, ref string sectorId, ref string sectorIdNotUsedIn,
ref string agencyId, ref string agencyIdNotUsedIn, ref string indSub, ref string indSubNotUsedIn,
ref string loc, ref string locNotUsedIn, ref string keyword1, ref string keyword2, ref string keyword3,
ref string otherKeywords, ref string notUsedKeywords, ref string documentType, ref string isIcbncb,
ref string tenderValue, ref double tenderValueFrom, ref double tenderValueTo,
ref Boolean indianGlobal, ref string finalSearchText, string tenderyear, string OrderBys, string AscDesc, bool IsOnlyCount = false)//int? orderByType = null
{
List <SearchTenaderInfoWithAllDetail> tenderList = new List <SearchTenaderInfoWithAllDetail>();
List <TenderCount> tenderCount = new List <TenderCount>();
var resultData = _dblocal.Proc_TA_ClientSampleTender_List(permissionId, start, limit,
tenderStatusFlag == null ? "" : tenderStatusFlag.Value.ToString(),
new System.Data.Entity.Core.Objects.ObjectParameter("OwnershipID", ownershipId),
new System.Data.Entity.Core.Objects.ObjectParameter("OwnershipIDNotUsedIn", ownershipIdNotUsedIn),
new System.Data.Entity.Core.Objects.ObjectParameter("SectorID", sectorId),
new System.Data.Entity.Core.Objects.ObjectParameter("SectorIDNotUsedIn", sectorIdNotUsedIn),
new System.Data.Entity.Core.Objects.ObjectParameter("AgencyID", agencyId),
new System.Data.Entity.Core.Objects.ObjectParameter("AgencyIDNotUsedIn", agencyIdNotUsedIn),
new System.Data.Entity.Core.Objects.ObjectParameter("IndSub", indSub),
new System.Data.Entity.Core.Objects.ObjectParameter("IndSubNotUsedIn", indSubNotUsedIn),
new System.Data.Entity.Core.Objects.ObjectParameter("Loc", loc),
new System.Data.Entity.Core.Objects.ObjectParameter("LocNotUsedIn", locNotUsedIn),
new System.Data.Entity.Core.Objects.ObjectParameter("Keyword1", keyword1),
new System.Data.Entity.Core.Objects.ObjectParameter("Keyword2", keyword2),
new System.Data.Entity.Core.Objects.ObjectParameter("Keyword3", keyword3),
new System.Data.Entity.Core.Objects.ObjectParameter("OtherKeywords", otherKeywords),
new System.Data.Entity.Core.Objects.ObjectParameter("NotUsedKeywords", notUsedKeywords),
new System.Data.Entity.Core.Objects.ObjectParameter("DocumentType", documentType),
new System.Data.Entity.Core.Objects.ObjectParameter("IsICBNCB", isIcbncb == null ? "" : isIcbncb),
new System.Data.Entity.Core.Objects.ObjectParameter("bitTenderAmount", tenderValue),
new System.Data.Entity.Core.Objects.ObjectParameter("TenderValueFrom", tenderValueFrom),
new System.Data.Entity.Core.Objects.ObjectParameter("TenderValueTo", tenderValueTo),
new System.Data.Entity.Core.Objects.ObjectParameter("IndianGlobal", indianGlobal),
new System.Data.Entity.Core.Objects.ObjectParameter("finalSearchText", finalSearchText),
tenderyear, OrderBys, AscDesc);
Utility.ToList(resultData, tenderList);
if (iscount.Value)
{
var resultCount = _dblocal.Proc_TA_ClientSampleTender_Count(permissionId, start, limit,
tenderStatusFlag == null ? "" : tenderStatusFlag.Value.ToString(),
new System.Data.Entity.Core.Objects.ObjectParameter("OwnershipID", ownershipId),
new System.Data.Entity.Core.Objects.ObjectParameter("OwnershipIDNotUsedIn", ownershipIdNotUsedIn),
new System.Data.Entity.Core.Objects.ObjectParameter("SectorID", sectorId),
new System.Data.Entity.Core.Objects.ObjectParameter("SectorIDNotUsedIn", sectorIdNotUsedIn),
new System.Data.Entity.Core.Objects.ObjectParameter("AgencyID", agencyId),
new System.Data.Entity.Core.Objects.ObjectParameter("AgencyIDNotUsedIn", agencyIdNotUsedIn),
new System.Data.Entity.Core.Objects.ObjectParameter("IndSub", indSub),
new System.Data.Entity.Core.Objects.ObjectParameter("IndSubNotUsedIn", indSubNotUsedIn),
new System.Data.Entity.Core.Objects.ObjectParameter("Loc", loc),
new System.Data.Entity.Core.Objects.ObjectParameter("LocNotUsedIn", locNotUsedIn),
new System.Data.Entity.Core.Objects.ObjectParameter("Keyword1", keyword1),
new System.Data.Entity.Core.Objects.ObjectParameter("Keyword2", keyword2),
new System.Data.Entity.Core.Objects.ObjectParameter("Keyword3", keyword3),
new System.Data.Entity.Core.Objects.ObjectParameter("OtherKeywords", otherKeywords),
new System.Data.Entity.Core.Objects.ObjectParameter("NotUsedKeywords", notUsedKeywords),
new System.Data.Entity.Core.Objects.ObjectParameter("DocumentType", documentType),
new System.Data.Entity.Core.Objects.ObjectParameter("IsICBNCB", isIcbncb == null ? "" : isIcbncb),
new System.Data.Entity.Core.Objects.ObjectParameter("bitTenderAmount", tenderValue),
new System.Data.Entity.Core.Objects.ObjectParameter("TenderValueFrom", tenderValueFrom),
new System.Data.Entity.Core.Objects.ObjectParameter("TenderValueTo", tenderValueTo),
new System.Data.Entity.Core.Objects.ObjectParameter("IndianGlobal", indianGlobal),
new System.Data.Entity.Core.Objects.ObjectParameter("finalSearchText", finalSearchText),
tenderyear, OrderBys, AscDesc);
Utility.ToList(resultCount, tenderCount);
}
TenderDetailInfo tenders = new TenderDetailInfo()
{
TenaderDetailSearch = tenderList,
TenaderDetailCount = tenderCount
};
return(tenders);
}
