public QRInfoAndBidDomain InfoGetByBidId(int BidId)
{
QRInfoAndBidDomain SingleQrBid = null;
try
{
DataProvider.ExecuteCmd(GetConnection, "dbo.QRandQRIandCompanyandBidInfo_GetByBidId"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@bidId", BidId);
}, map : delegate(IDataReader reader, short set)
{
int startingIndex = 0; //startingOrdinal
SingleQrBid = new QRInfoAndBidDomain();
SingleQrBid.BidId = reader.GetSafeInt32(startingIndex++);
SingleQrBid.BidAmount = reader.GetSafeDecimal(startingIndex++);
SingleQrBid.BidContractId = reader.GetSafeInt32(startingIndex++);
SingleQrBid.BidSubmittingCompanyId = reader.GetSafeInt32(startingIndex++);
SingleQrBid.BidReceivingCompanyId = reader.GetSafeInt32(startingIndex++);
SingleQrBid.BidCreatedDate = reader.GetSafeDateTime(startingIndex++);
SingleQrBid.BidUpdatedDate = reader.GetSafeDateTime(startingIndex++);
SingleQrBid.BidShippingAddressId = reader.GetSafeInt32(startingIndex++);
SingleQrBid.BidReceivingAddressId = reader.GetSafeInt32(startingIndex++);
SingleQrBid.BidExpirationDate = reader.GetSafeDateTime(startingIndex++);
SingleQrBid.BidStatusId = reader.GetSafeInt32(startingIndex++);
SingleQrBid.BidAddress1 = reader.GetSafeString(startingIndex++);
SingleQrBid.BidCity = reader.GetSafeString(startingIndex++);
SingleQrBid.BidState = reader.GetSafeString(startingIndex++);
SingleQrBid.BidZipCode = reader.GetSafeString(startingIndex++);
SingleQrBid.QRId = reader.GetSafeInt32(startingIndex++);
SingleQrBid.QuoteRequestName = reader.GetSafeString(startingIndex++);
SingleQrBid.QuoteRequestDueDate = reader.GetSafeDateTime(startingIndex++);
SingleQrBid.Address1 = reader.GetSafeString(startingIndex++);
SingleQrBid.City = reader.GetSafeString(startingIndex++);
SingleQrBid.State = reader.GetSafeString(startingIndex++);
SingleQrBid.ZipCode = reader.GetSafeString(startingIndex++);
SingleQrBid.QriUniqueId = reader.GetSafeInt32(startingIndex++);
SingleQrBid.QuoteRequestItemId = reader.GetSafeInt32(startingIndex++);
SingleQrBid.QuoteRequestItemName = reader.GetSafeString(startingIndex++);
SingleQrBid.Quantity = reader.GetSafeInt32(startingIndex++);
SingleQrBid.Unit = reader.GetSafeString(startingIndex++);
SingleQrBid.CompanyName = reader.GetSafeString(startingIndex++);
}
);
}
catch (Exception ex)
{
throw ex;
}
return(SingleQrBid);
}
public HttpResponseMessage GetInfoByBidId(int BidId)
{
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
QRInfoAndBidDomain bidInfo = _QuoteService.InfoGetByBidId(BidId);
ItemResponse <QRInfoAndBidDomain> response = new ItemResponse <QRInfoAndBidDomain>();
response.Item = bidInfo;
return(Request.CreateResponse(HttpStatusCode.OK, response));
}
