public ArrayList GetBidDetails(string connstring, string vBidRefNo) { ArrayList biditemdetails = new ArrayList(); SqlParameter[] sqlParams = new SqlParameter[1]; sqlParams[0] = new SqlParameter("@bidRefNo", SqlDbType.Int); sqlParams[0].Value = Int32.Parse(vBidRefNo); DataSet bidDetailData = SqlHelper.ExecuteDataset(connstring, CommandType.StoredProcedure, "s3p_EBid_GetBidDetails", sqlParams); foreach (DataTable table in bidDetailData.Tables) { foreach (DataRow row in table.Rows) { BidItemDetail bidItem = new BidItemDetail(); bidItem.BidDetailNo = Int32.Parse(row["BidDetailNo"].ToString().Trim()); bidItem.BidRefNo = Int32.Parse(row["BidRefNo"].ToString().Trim()); bidItem.DetailDesc = row["DetailDesc"].ToString(); bidItem.EstItemValue = Double.Parse(row["EstItemValue"].ToString().Trim()); bidItem.UnitPrice = Double.Parse(row["UnitPrice"].ToString().Trim()); bidItem.Qty = Int32.Parse(row["Qty"].ToString().Trim()); bidItem.DeliveryDate = row["DeliveryDate"].ToString(); bidItem.Item = row["Item"].ToString(); bidItem.UnitOfMeasure = row["UnitOfMeasure"].ToString().Trim(); bidItem.DeliveryDateMonth = row["DeliveryDateMonth"].ToString().Trim(); bidItem.DeliveryDateDay = row["DeliveryDateDay"].ToString().Trim(); bidItem.DeliveryDateYear = row["DeliveryDateYear"].ToString().Trim(); biditemdetails.Add(bidItem); } } return(biditemdetails); }
public BidItemDetail GetBidItemDetailsByRefNo(string connstring, int bidRefNo) { BidItemDetail bidDetail = new BidItemDetail(); try { SqlParameter[] sqlParams = new SqlParameter[1]; sqlParams[0] = new SqlParameter("@bidRefNo", SqlDbType.Int); sqlParams[0].Value = bidRefNo; DataSet bidData = SqlHelper.ExecuteDataset(connstring, CommandType.StoredProcedure, "s3p_EBid_GetItemDetailsByRefNo", sqlParams); if (bidData.Tables[0].Rows.Count > 0) { DataRow row = bidData.Tables[0].Rows[0]; bidDetail.BidDetailNo = Int32.Parse(row["BidDetailNo"].ToString()); bidDetail.BidRefNo = Int32.Parse(row["BidRefNo"].ToString()); bidDetail.CategoryId = row["CategoryId"].ToString(); bidDetail.DeliveryDate = row["DeliveryDate"].ToString(); bidDetail.DetailDesc = row["DetailDesc"].ToString(); bidDetail.EstItemValue = Double.Parse(row["EstItemValue"].ToString()); bidDetail.Item = row["Item"].ToString(); bidDetail.Qty = Int32.Parse(row["Qty"].ToString()); bidDetail.UnitOfMeasure = row["UnitOfMeasure"].ToString(); } } catch { } return(bidDetail); }