Esempio n. 1
0
        public BidTender QueryLowestAndHighestBidTender(string BidDetailNo)
        {
            SqlParameter[] sqlparams = new SqlParameter[1];
            sqlparams[0]       = new SqlParameter("@bidDetailNo", SqlDbType.Int);
            sqlparams[0].Value = Int32.Parse(BidDetailNo);

            DataSet   bidData = SqlHelper.ExecuteDataset(connstring, CommandType.StoredProcedure, "s3p_EBid_GetOrderOfBidTenderAmounts", sqlparams);
            DataTable dtMin   = new DataTable();
            DataTable dtMax   = new DataTable();
            BidTender bt      = new BidTender();

            //initial amount in case no vendor is returned
            bt.VendorWithLowestAmt  = "-1";
            bt.VendorWithHighestAmt = "-1";
            if (bidData.Tables.Count > 0)
            {
                dtMin = bidData.Tables[0];
                if (dtMin.Rows.Count > 0)
                {
                    bt.VendorWithLowestAmt = dtMin.Rows[0]["VendorId"].ToString().Trim();
                }
                if (bidData.Tables.Count > 1)
                {
                    dtMax = bidData.Tables[1];
                    if (dtMax.Rows.Count > 0)
                    {
                        bt.VendorWithHighestAmt = dtMax.Rows[0]["VendorId"].ToString().Trim();
                    }
                }
            }
            return(bt);
        }
Esempio n. 2
0
        public ArrayList GetBidItemTenders(string refNo, int userId)
        {
            ArrayList arrBidItemTenders = new ArrayList();

            SqlParameter[] sqlparams = new SqlParameter[2];
            sqlparams[0]       = new SqlParameter("@refNo", SqlDbType.Int);
            sqlparams[0].Value = Int32.Parse(refNo);
            sqlparams[1]       = new SqlParameter("@userId", SqlDbType.Int);
            sqlparams[1].Value = userId;

            DataSet bidData = SqlHelper.ExecuteDataset(connstring, CommandType.StoredProcedure, "s3p_EBid_GetBidTendersNos", sqlparams);

            if (bidData.Tables[0].Rows.Count > 0)
            {
                BidTender bidTender = new BidTender();
                foreach (DataTable table in bidData.Tables)
                {
                    foreach (DataRow row in table.Rows)
                    {
                        arrBidItemTenders.Add(GetBidTender(Int32.Parse(row["BidTenderNo"].ToString())));
                    }
                }
            }

            return(arrBidItemTenders);
        }
Esempio n. 3
0
        public BidTender GetBidTender(int bidTenderNo)
        {
            BidTender bidTender = new BidTender();

            SqlParameter[] sqlParams = new SqlParameter[1];
            sqlParams[0]       = new SqlParameter("@BidTenderNo", SqlDbType.Int);
            sqlParams[0].Value = bidTenderNo;

            DataSet   ds = SqlHelper.ExecuteDataset(connstring, CommandType.StoredProcedure, "[s3p_EBid_GetBidTender]", sqlParams);
            DataTable dt = new DataTable();

            if (ds.Tables.Count > 0)
            {
                dt = ds.Tables[0];
                if (dt.Rows.Count > 0)
                {
                    DataRow row = dt.Rows[0];
                    bidTender.Amount      = Double.Parse(row["Amount"].ToString());
                    bidTender.BidDetailNo = Int32.Parse(row["BidDetailNo"].ToString());
                    bidTender.BidItem     = row["Item"].ToString();
                    bidTender.BidTenderNo = Int32.Parse(row["BidTenderNo"].ToString());
                    bidTender.DetailDesc  = row["DetailDesc"].ToString();
                    bidTender.Status      = Int32.Parse(row["Status"].ToString());
                    bidTender.TenderDate  = row["TenderDate"].ToString();
                    bidTender.VendorID    = Int32.Parse(row["VendorID"].ToString());
                }
                else
                {
                    bidTender.Amount      = 0;
                    bidTender.BidDetailNo = -1;
                    bidTender.BidItem     = "";
                    bidTender.BidTenderNo = -1;
                    bidTender.DetailDesc  = "";
                    bidTender.Status      = -1;
                    bidTender.TenderDate  = "";
                    bidTender.VendorID    = -1;
                }
            }

            else
            {
                bidTender.Amount      = 0;
                bidTender.BidDetailNo = -1;
                bidTender.BidItem     = "";
                bidTender.BidTenderNo = -1;
                bidTender.DetailDesc  = "";
                bidTender.Status      = -1;
                bidTender.TenderDate  = "";
                bidTender.VendorID    = -1;
            }
            return(bidTender);
        }
Esempio n. 4
0
        public void SaveBidTender(BidTender bidTender)
        {
            SqlParameter[] sqlparams = new SqlParameter[5];
            sqlparams[0]       = new SqlParameter("@BidDetailNo", SqlDbType.Int);
            sqlparams[0].Value = bidTender.BidDetailNo;
            sqlparams[1]       = new SqlParameter("@Amount", SqlDbType.Float);
            sqlparams[1].Value = bidTender.Amount;
            sqlparams[2]       = new SqlParameter("@TenderDate", SqlDbType.DateTime);
            sqlparams[2].Value = bidTender.TenderDate;
            sqlparams[3]       = new SqlParameter("@VendorID", SqlDbType.Int);
            sqlparams[3].Value = bidTender.VendorID;
            sqlparams[4]       = new SqlParameter("@Status", SqlDbType.Int);
            sqlparams[4].Value = bidTender.Status;

            SqlHelper.ExecuteNonQuery(connstring, CommandType.StoredProcedure, "[s3p_EBid_SaveBidTender]", sqlparams);
        }
Esempio n. 5
0
        public BidTender QueryBidTenderAmount(string BidDetailNo, string VendorId)
        {
            SqlParameter[] sqlparams = new SqlParameter[2];
            sqlparams[0]       = new SqlParameter("@bidDetailNo", SqlDbType.Int);
            sqlparams[0].Value = Int32.Parse(BidDetailNo);
            sqlparams[1]       = new SqlParameter("@vendorId", SqlDbType.Int);
            sqlparams[1].Value = Int32.Parse(VendorId);

            DataSet bidData = SqlHelper.ExecuteDataset(connstring, CommandType.StoredProcedure, "s3p_EBid_QueryBidTenderAmount", sqlparams);

            BidTender bt = new BidTender();

            if (bidData.Tables[0].Rows.Count > 0)
            {
                bt.Amount      = Convert.ToDouble(bidData.Tables[0].Rows[0]["TotalItemCost"].ToString().Trim());
                bt.BidTenderNo = Int32.Parse(bidData.Tables[0].Rows[0]["BidTenderNo"].ToString().Trim());
            }
            else
            {
                bt.Amount      = 0;
                bt.BidTenderNo = 0;
            }
            return(bt);
        }