/// <summary>
/// Gets the tender detail object from the client.
/// </summary>
/// <param name="context">The request context.</param>
/// <param name="tenderDetail">The tender detail object from client.</param>
/// <returns>The tender detail object to be saved on channel database.</returns>
internal static TenderDetail ConvertToTenderDetail(RequestContext context, TenderDetail tenderDetail)
{
var tender = new TenderDetail
{
BankBagNumber = tenderDetail.BankBagNumber, // bankbag number
TenderTypeId = tenderDetail.TenderTypeId, // tender type identifier
Amount = tenderDetail.Amount // amount in channel currency
};
string channelCurrency = context.GetChannelConfiguration().Currency;
string foreignCurrency = string.IsNullOrWhiteSpace(tenderDetail.ForeignCurrency) ? channelCurrency : tenderDetail.ForeignCurrency;
// Check if the foreign currency of the transaction is in channel currency
if (foreignCurrency.Equals(channelCurrency, StringComparison.OrdinalIgnoreCase))
{
tender.ForeignCurrency = channelCurrency; // foreign currency code is same as store currency code
tender.AmountInForeignCurrency = tenderDetail.Amount; // foreign amount is same as store amount
tender.ForeignCurrencyExchangeRate = 1m; // foreign to channel currency exchange rate is 1
}
else
{
tender.ForeignCurrency = foreignCurrency; // foreign currency code
tender.AmountInForeignCurrency = tenderDetail.AmountInForeignCurrency; // foreign amount
tender.ForeignCurrencyExchangeRate = tenderDetail.ForeignCurrencyExchangeRate; // foreign to channel currency exchange rate
}
// Retrieve the amount in company currency with the exchange rate between foreign and company currency
Tuple <decimal, decimal> companyCurrencyValues = StoreOperationServiceHelper.GetCompanyCurrencyValues(context, tender.AmountInForeignCurrency, tender.ForeignCurrency);
tender.AmountInCompanyCurrency = companyCurrencyValues.Item1; // amount MST
tender.CompanyCurrencyExchangeRate = companyCurrencyValues.Item2; // exchange rate MST
return(tender);
}
public ActionResult Thanks(string email)
{
var tenderDetail = new TenderDetail();
ViewBag.EmailId = email;
return(View(tenderDetail));
}
public int updateTenderDetail(TenderDetail tenderDetail)
{
using (EntityModel em = new EntityModel())
{
em.Entry(tenderDetail).State = EntityState.Modified;
return(em.SaveChanges());
}
}
public int addTenderDetail(TenderDetail tenderDetail)
{
using (EntityModel em = new EntityModel())
{
em.TenderDetails.Add(tenderDetail);
return(em.SaveChanges());
}
}
private TenderDetail GetTenderResult(int regionId, int page, string sessionKeyName, AdvanceSearchParameter advanceSearch, int searchId = 0,
bool isSearchWithCount = true, bool isSearchTextChanged = false)
{
TenderDetail tenderDetail = null;
Session["AdvanceSearchGlobalParams"] = advanceSearch;
var pagecnt = page != 0 ? page - 1 : 0;
var newpagecnt = (pagecnt * PageSize);
if (Session[sessionKeyName] != null)
{
tenderDetail = (TenderDetail)Session[sessionKeyName];
var fieldid = tenderDetail.FieldId;
var fieldname = tenderDetail.FieldName;
if (tenderDetail.Newpagecnt != newpagecnt || isSearchTextChanged)
{
tenderDetail = GetSearchTenderResult(regionId, newpagecnt, tenderDetail.DisplayText, tenderDetail.SearchType, advanceSearch, tenderDetail.SearchProuctId,
isSearchWithCount, tenderDetail.OrderBy, WithinSearchWords);
tenderDetail.FieldId = fieldid;
tenderDetail.FieldName = fieldname;
Session[sessionKeyName] = tenderDetail;
}
}
else
{
tenderDetail = searchId == 0
? GetSearchTenderResult(regionId, newpagecnt, "", 2, advanceSearch, 0, isSearchWithCount, 0, WithinSearchWords)
: GetSearchTenderResult(regionId, newpagecnt, "", 1, advanceSearch, 0, isSearchWithCount, 0, WithinSearchWords);
Session[sessionKeyName] = tenderDetail;
}
if (isSearchWithCount)
{
Session["TotalSearchedGlobalTenders"] = tenderDetail.Total.ToString(CultureInfo.InvariantCulture);
Session["TotalGlobalLiveTenders"] = tenderDetail.TotalLive.ToString(CultureInfo.InvariantCulture);
Session["TotalGlobalFreshTenders"] = tenderDetail.TotalFresh.ToString(CultureInfo.InvariantCulture);
Session["TotalGlobalClosedTenders"] = tenderDetail.TotalClosed.ToString(CultureInfo.InvariantCulture);
}
tenderDetail.Total = Convert.ToInt64(Session["TotalSearchedGlobalTenders"]);
tenderDetail.TotalLive = Convert.ToInt64(Session["TotalGlobalLiveTenders"]);
tenderDetail.TotalFresh = Convert.ToInt64(Session["TotalGlobalFreshTenders"]);
tenderDetail.TotalClosed = Convert.ToInt64(Session["TotalGlobalClosedTenders"]);
if (advanceSearch != null)
{
Session["AdvanceSearchGlobalParams"] = advanceSearch;
}
return(tenderDetail);
}
public TenderDetail LoadCountryByRegionIdList(int regionId, int totalDisplay)
{
var countrylist = _tenderInfo.ListCountrybyRegion(regionId).OrderBy(x => (new Random()).Next()).Take(totalDisplay).ToList();
var tenderDetail = new TenderDetail
{
TotalDisplay = totalDisplay,
AllCountryList = countrylist,
RegionId = regionId
};
return(tenderDetail);
}
public static void Main(String[] args)
{
TestTenderDetailsDAO testDAO = new TestTenderDetailsDAO();
TenderDetail td1 = new TenderDetail();
td1.TenderCode = "1235";
td1.ItemCode = "C001";
td1.Price = 100;
//testDAO.AddTender(td1);
Console.WriteLine("\nGet Tender Detail");
Console.WriteLine(testDAO.getTenderDetail("1235", "c001").TenderCode);
Console.WriteLine("\nGet all Tender Details");
foreach (TenderDetail td in testDAO.ListAllTenderDetails())
{
Console.WriteLine(td.ItemCode);
}
Console.WriteLine("\nGet Tender Details by item code");
foreach (TenderDetail td in testDAO.ListTendersByItemCode("c001"))
{
Console.WriteLine(td.ItemCode);
}
Console.WriteLine("\nGet Tender Details by Tender Code");
foreach (TenderDetail td in testDAO.ListTendersByTenderCode("1235"))
{
Console.WriteLine(td.ItemCode);
}
Console.WriteLine("\nGet Tender Details by price");
foreach (TenderDetail td in testDAO.ListTendersByPrice(1000))
{
Console.WriteLine(td.ItemCode);
}
Console.WriteLine("\nGet Tender Details by price range");
foreach (TenderDetail td in testDAO.ListTendersByPrice(1, 999))
{
Console.WriteLine(td.ItemCode);
}
Console.WriteLine("\nUpdate Tender Details");
TenderDetail td2 = testDAO.getTenderDetail("1235", "c001");
td2.Price = 888;
testDAO.UpdateTender(td2);
Console.WriteLine(testDAO.getTenderDetail("1235", "c001").TenderCode);
}
public ActionResult result()
{
var tenderDetail = new TenderDetail
{
StateList = _getListItems.StateList(),
CityList = _getListItems.CityList(0),
Subscribetype = SubscribType.result,
DownloadTenderRefNo = 0,
FormTitle = SubscribTypeDisplsyText.Result,
FormType = FormType.OtherForms
};
return(View("InquiryForm", tenderDetail));
}
public ActionResult GlobalTenders()
{
var tenderDetail = new TenderDetail
{
CountryList = _getListItems.CountryList(),
StateList = _getListItems.StateList(),
CityList = _getListItems.CityList(0),
Subscribetype = SubscribType.GlobalTender,
DownloadTenderRefNo = 0,
FormTitle = SubscribTypeDisplsyText.GlobalTender,
FormType = FormType.RegistrationForm
};
return(View("InquiryForm", tenderDetail));
}
/// <summary>
/// Gets the object of tender drop and declare operation.
/// </summary>
/// <param name="request">The SaveDropAndDeclareServiceRequest object.</param>
/// <returns>The tender drop and declare operation object.</returns>
internal static DropAndDeclareTransaction ConvertTenderDropAndDeclareTransaction(SaveDropAndDeclareServiceRequest request)
{
RequestContext context = request.RequestContext;
var transaction = new DropAndDeclareTransaction
{
Id = request.TransactionId,
ShiftId = request.ShiftId,
ShiftTerminalId = string.IsNullOrWhiteSpace(request.ShiftTerminalId) ? context.GetPrincipal().ShiftTerminalId : request.ShiftTerminalId,
TransactionType = request.TransactionType,
ChannelCurrencyExchangeRate = StoreOperationServiceHelper.GetExchangeRate(context),
StoreId = context.GetOrgUnit().OrgUnitNumber,
StaffId = context.GetPrincipal().UserId,
TerminalId = context.GetTerminal().TerminalId,
ChannelCurrency = context.GetChannelConfiguration().Currency, // channel currency code
Description = request.Description
};
transaction.TenderDetails = new Collection <TenderDetail>();
foreach (var tenderDetail in request.TenderDetails)
{
TenderDetail tender = ConvertToTenderDetail(context, tenderDetail);
transaction.TenderDetails.Add(tender);
}
if (request.ReasonCodeLines != null && request.ReasonCodeLines.Any())
{
// Read reason code details from request for [Tender Declaration] store operation
transaction.ReasonCodeLines = new Collection <ReasonCodeLine>();
foreach (var reasonCodeLine in request.ReasonCodeLines)
{
transaction.ReasonCodeLines.Add(reasonCodeLine);
}
}
return(transaction);
}
public ActionResult TenderNotice(string refno)
{
var globalTenderInformation = _tenderInfo.GetGlobalTenderInfoById(refno);
ViewBag.Location = "";
ViewBag.LocationForLink = "";
var statename = "";
var city = "";
var country = "";
var location = "";
int tenderStatus = 0;// 1:ACTIVE, 2:NEW, 3:CLOSE
ViewBag.DocType = "";
const string searchdesiplaytext = "";
if (globalTenderInformation != null)
{
country = _tenderInfo.GetCountry(globalTenderInformation.CountryId).CountryName;
statename = _tenderInfo.GetState(globalTenderInformation.StateId).StateName;
city = _tenderInfo.GetCity(globalTenderInformation.LocId).Location;
ViewBag.Location = location = country;
if (globalTenderInformation.dt != null)
{
var dt = globalTenderInformation.dt.Value;
var submDate = globalTenderInformation.SubmDate;
if (dt.ToString("MM/dd/yyyy") == DateTime.Today.AddDays(-1).ToString("MM/dd/yyyy") && submDate >= DateTime.Today)
{
tenderStatus = 2;
}
else if (submDate >= DateTime.Today)
{
tenderStatus = 1;
}
else if (submDate < DateTime.Today)
{
tenderStatus = 3;
}
}
}
city = new CultureInfo("en-US", false).TextInfo.ToTitleCase(city.ToLower());
statename = new CultureInfo("en-US", false).TextInfo.ToTitleCase(statename.ToLower());
int refNo = refno == "" ? 0 : Convert.ToInt32(refno);
var searchtype = new SearchType();
if (globalTenderInformation != null)
{
var duedate = globalTenderInformation.SubmDate.ToString("dd MMM, yyyy");
var detail = globalTenderInformation.WorkDesc;
var tenderMetaData = _common.GetTenderMetaDataGlobal(TenderTypeList.GlobalDetailPage);
var Title = tenderMetaData.Title;
Title = Title.Replace(TenderMetaReplaceName.TenderDescription, detail.Replace("-", " "));
Title = Title.Replace(TenderMetaReplaceName.CityName, location.Replace("-", " "));
var Description = tenderMetaData.Description;
Description = Description.Replace(TenderMetaReplaceName.TenderDescription, detail);
Description = Description.Replace(TenderMetaReplaceName.TenderDueDate, duedate);
Description = Description.Replace(TenderMetaReplaceName.TenderLocation, location.Replace("-", " "));
Description = Description.Replace(TenderMetaReplaceName.TenderOurrefNo, globalTenderInformation.OurRefNo.ToString());
string displayKeyword = "";
string[] keywordList = null;
if (!string.IsNullOrEmpty(detail))
{
keywordList = Regex.Split(detail, " ");
}
if (keywordList != null)
{
displayKeyword =
keywordList.Where(
item =>
item.Length > 2 && !item.ToLower().Trim().Contains("and") &&
!item.ToLower().Trim().Contains("but") && !item.ToLower().Trim().Contains("before") &&
!item.ToLower().Trim().Contains("after") && !item.ToLower().Trim().Contains("above") &&
!item.ToLower().Trim().Contains("via") && !item.ToLower().Trim().Contains("from") &&
!item.ToLower().Trim().Contains("length") && !item.ToLower().Trim().Contains("height") &&
!item.ToLower().Trim().Contains("weight"))
.Aggregate(displayKeyword,
(current, item) => current == "" ? item + " Tenders" : current + ", " + item + " Tenders");
}
ViewBag.Title = Title;
ViewBag.description = Description;
ViewBag.keywords = tenderMetaData.Keyword.Replace(TenderMetaReplaceName.KeywordName, displayKeyword);
}
var tenderDetail = new TenderDetail
{
TenderDetails = globalTenderInformation,
StateList = _getListItems.StateList(),
CityList = _getListItems.CityList(0),
OurRefNo = globalTenderInformation.OurRefNo,
TenderStatus = tenderStatus,
DisplayText3 = searchdesiplaytext,
IdVal = 0,
Subscribetype = SubscribType.DownloadTender,
DownloadTenderRefNo = Convert.ToInt32(refno),
FormTitle = SubscribTypeDisplsyText.DownloadTender,
FormType = FormType.PopupForms,
IsGlobalTender = true
};
return(View("TenderNotice", tenderDetail));
}
private void SetTenderDetails(int regionId, string withinSearchText, int fieldId, string fieldName, ref TenderDetail tenderDetail)
{
string sessionKeyName = "";
var shoecurrentpage = (tenderDetail.Newpagecnt / 10) + 1;
ViewBag.DisplayCurrentPage = shoecurrentpage;
ViewBag.CurrentPage = shoecurrentpage;
ViewBag.PageSize = tenderDetail.PageSize;
ViewBag.TotalPage = Math.Ceiling((double)tenderDetail.Total / tenderDetail.PageSize);
ViewBag.SearchText = withinSearchText;
tenderDetail.TendersBy = regionId;
var paggingUrl = "";
var replaceName = "";
bool linkListPage = false;
tenderDetail.FieldId = fieldId;
tenderDetail.FieldName = fieldName.Replace(" ", "-");
var displayFieldName = fieldName.Replace("-", " ");
replaceName = TenderMetaReplaceName.GlobalCountryName;
switch (regionId)
{
default:
case TenderTypeList.SearchTender:
sessionKeyName = "SearhGlobalTenderResult";
paggingUrl = ConfigurationManager.AppSettings["GlobalTenderKeywordUrl"] + TenderWordNameList.KeywordWord + fieldName.Replace(" ", "-");
break;
case TenderTypeList.MiddleEastCountryRegion:
sessionKeyName = "SearhMiddleEastCountryTenderResult";
paggingUrl = ConfigurationManager.AppSettings["TenderByMiddleEastCountryUrl"] + TenderWordNameList.GlobalCountryWord + fieldName.Replace(" ", "-");
break;
case TenderTypeList.EuropeanCountryRegion:
sessionKeyName = "SearhEuropeanCountryTenderResult";
paggingUrl = ConfigurationManager.AppSettings["TenderByEuropeanCountryUrl"] + TenderWordNameList.GlobalCountryWord + fieldName.Replace(" ", "-");
break;
case TenderTypeList.AfricanCountryRegion:
sessionKeyName = "SearhAfricanCountryTenderResult";
paggingUrl = ConfigurationManager.AppSettings["TenderByAfricanCountryUrl"] + TenderWordNameList.GlobalCountryWord + fieldName.Replace(" ", "-");
break;
case TenderTypeList.AsianCountryRegion:
sessionKeyName = "SearhAsianCountryTenderResult";
paggingUrl = ConfigurationManager.AppSettings["TenderByAsianCountryUrl"] + TenderWordNameList.GlobalCountryWord + fieldName.Replace(" ", "-");
break;
case TenderTypeList.SaarCountryRegion:
sessionKeyName = "SearhSAARCountryTenderResult";
paggingUrl = ConfigurationManager.AppSettings["TenderBySAARCountryUrl"] + TenderWordNameList.GlobalCountryWord + fieldName.Replace(" ", "-");
break;
case TenderTypeList.AustraliaOceaniaCountryRegion:
paggingUrl = ConfigurationManager.AppSettings["TenderByAustraliaOceaniaCountryUrl"] + TenderWordNameList.GlobalCountryWord + fieldName.Replace(" ", "-");
sessionKeyName = "SearhAustraliaOceaniaCountryTenderResult";
break;
case TenderTypeList.SouthAmericaCountryRegion:
paggingUrl = ConfigurationManager.AppSettings["TenderBySouthAmericaCountryUrl"] + TenderWordNameList.GlobalCountryWord + fieldName.Replace(" ", "-");
sessionKeyName = "SearhSouthAmericaCountryTenderResult";
break;
case TenderTypeList.NorthAmericaCountryRegion:
paggingUrl = ConfigurationManager.AppSettings["TenderByNorthAmericaCountryUrl"] + TenderWordNameList.GlobalCountryWord + fieldName.Replace(" ", "-");
sessionKeyName = "SearhNorthAmericaCountryTenderResult";
break;
}
var countryNm = "";
if (regionId != 0)
{
var countrylist = _tenderInfo.ListCountrybyRegion(regionId).Select(x => x.CountryName).ToList();
if (countrylist.Any())
{
countryNm = String.Join(" Tenders ,", countrylist.ToArray());
}
}
tenderDetail.PaggingUrl = paggingUrl;
var tenderMetaData = _common.GetTenderMetaDataGlobal(regionId, linkListPage);
ViewBag.Title = tenderMetaData.Title.Replace(replaceName, countryNm);
ViewBag.Description = tenderMetaData.Description.Replace(replaceName, countryNm);
ViewBag.Keywords = tenderMetaData.Keyword.Replace(replaceName, countryNm);
//tenderDetail.DisplaySearchTextDetail = tenderMetaData.Content.Replace(replaceName, countryNm);
OtherValues();
tenderDetail.StateList = _getListItems.StateList();
tenderDetail.CityList = _getListItems.CityList(0);
tenderDetail.IdVal = 0;
tenderDetail.Subscribetype = SubscribType.DownloadTender;
tenderDetail.DownloadTenderRefNo = 0;
tenderDetail.FormTitle = SubscribTypeDisplsyText.DownloadTender;
tenderDetail.FormType = FormType.PopupForms;
tenderDetail.IsGlobalTender = true;
Session[sessionKeyName] = tenderDetail;
}
public ActionResult GetTenderFromTenderStatus(int tenderBy, int tenderStatus = 0)
{
int page = 1;
ViewBag.IsEndOfRecords = false;
TenderDetail tenderDetail = null;
int searchId = 0;
string sessionKeyName = "";
if (Request.IsAjaxRequest())
{
var advanceSearchPara = new AdvanceSearchParameter();
if (Session["AdvanceSearchGlobalParams"] != null)
{
advanceSearchPara = (AdvanceSearchParameter)Session["AdvanceSearchGlobalParams"];
}
advanceSearchPara.TenderStatusFlag = tenderStatus;
switch (tenderBy)
{
default: //SEARCH
sessionKeyName = "SearhGlobalTenderResult";
break;
case TenderTypeList.MiddleEastCountryRegion:
sessionKeyName = "SearhMiddleEastCountryTenderResult";
break;
case TenderTypeList.EuropeanCountryRegion:
sessionKeyName = "SearhEuropeanCountryTenderResult";
break;
case TenderTypeList.AfricanCountryRegion:
sessionKeyName = "SearhAfricanCountryTenderResult";
break;
case TenderTypeList.AsianCountryRegion:
sessionKeyName = "SearhAsianCountryTenderResult";
break;
case TenderTypeList.SaarCountryRegion:
sessionKeyName = "SearhSAARCountryTenderResult";
break;
case TenderTypeList.AustraliaOceaniaCountryRegion:
sessionKeyName = "SearhAustraliaOceaniaCountryTenderResult";
break;
case TenderTypeList.SouthAmericaCountryRegion:
sessionKeyName = "SearhSouthAmericaCountryTenderResult";
break;
case TenderTypeList.NorthAmericaCountryRegion:
sessionKeyName = "SearhNorthAmericaCountryTenderResult";
break;
}
FillWithinSearchWords(Session["WithinSearchGlobalText"] == null ? "" : Session["WithinSearchGlobalText"].ToString());
tenderDetail = GetTenderResult(tenderBy, page, sessionKeyName, advanceSearchPara, searchId, true, true);
if (advanceSearchPara != null)
{
Session["AdvanceSearchGlobalParams"] = advanceSearchPara;
}
var total = tenderDetail.Total;
switch (tenderStatus)
{
case (int)TenderStatusFlags.AllTenders:
total = tenderDetail.Total;
break;
case (int)TenderStatusFlags.LiveTenders:
total = tenderDetail.TotalLive;
break;
case (int)TenderStatusFlags.NewTenders:
total = tenderDetail.TotalFresh;
break;
case (int)TenderStatusFlags.ClosedTenders:
total = tenderDetail.TotalClosed;
break;
}
ViewBag.TotalPage = Math.Ceiling((double)total / tenderDetail.PageSize);
ViewBag.CurrentPage = (page + 1);
ViewBag.IsEndOfRecords = (tenderDetail.AllSearchTenaderInfoWithAllDetail.Any());
return(PartialView(Url.Content("~/Views/GlobalTenders/Partial/partialSearchResultData.cshtml"), tenderDetail));
}
return(null);
}
private TenderDetail CountryRegion(int regionId)
{
ResetTotalCountSession_Global();
ClearSession_Global();
SearchedWordsClear();
string displayName = "";
switch (regionId)
{
case Utility.TenderTypeList.MiddleEastCountryRegion:
displayName = Utility.TenderTypeDisplayText.DisplayMiddleEastCountryName;
break;
case Utility.TenderTypeList.EuropeanCountryRegion:
displayName = Utility.TenderTypeDisplayText.DisplayEuropeanCountryName;
break;
case Utility.TenderTypeList.AfricanCountryRegion:
displayName = Utility.TenderTypeDisplayText.DisplayAfricanCountryName;
break;
case Utility.TenderTypeList.AsianCountryRegion:
displayName = Utility.TenderTypeDisplayText.DisplayAsianCountryName;
break;
case Utility.TenderTypeList.SaarCountryRegion:
displayName = Utility.TenderTypeDisplayText.DisplaySaarCountryName;
break;
case Utility.TenderTypeList.AustraliaOceaniaCountryRegion:
displayName = Utility.TenderTypeDisplayText.DisplayAustraliaOceaniaCountryName;
break;
case Utility.TenderTypeList.SouthAmericaCountryRegion:
displayName = Utility.TenderTypeDisplayText.DisplaySouthAmericaCountryName;
break;
case Utility.TenderTypeList.NorthAmericaCountryRegion:
displayName = Utility.TenderTypeDisplayText.DisplayNorthAmericaCountryName;
break;
}
var rnd = new Random();
var listAllCountry = _tenderInfo.ListCountrybyRegion(regionId).ToList();
var listAllCountrytext = string.Join(" Tenders, ", listAllCountry.Select(x => x.CountryName).ToArray());
listAllCountrytext += " Tenders";
var tenderMetaData = _common.GetTenderMetaDataGlobal(regionId);
ViewBag.Title = tenderMetaData.Title.Replace(TenderMetaReplaceName.GlobalCountryName, displayName);
ViewBag.description = tenderMetaData.Description;
ViewBag.keywords = tenderMetaData.Keyword.Replace(TenderMetaReplaceName.GlobalCountryName, displayName + "-" + listAllCountrytext);
var tenderDetail = new TenderDetail
{
RegionId = regionId,
AllCountryList = listAllCountry,
FormTitle = displayName,
IsGlobalTender = true
};
return(tenderDetail);
}
private int UpdateTender(TenderDetail tender)
{
return(new TenderDetailsDAO().updateTenderDetail(tender));
}
private int AddTender(TenderDetail tender)
{
return(new TenderDetailsDAO().addTenderDetail(tender));
}
