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);
}
