Example #1
0
        public bool confirmDeliveryDate(DeliveryOrder deliveryOrder)
        {
            PurchaseOrderItem po = new PurchaseOrderItem();

            string        connectionString = null;
            SqlConnection connection;
            SqlCommand    command;
            string        sql = null;
            SqlDataReader dataReader;

            connectionString = "Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=\"C:\\Users\\PUA\\Desktop\\FYP test\\FYP test\\fypDB.mdf\";Integrated Security=True";
            sql        = "select * from POItems where PONo = @PONo";
            connection = new SqlConnection(connectionString);

            try
            {
                connection.Open();
                command = new SqlCommand(sql, connection);
                command.Parameters.AddWithValue("@PONo", deliveryOrder.getPONo());
                dataReader = command.ExecuteReader();
                while (dataReader.Read())
                {
                    po.setLineNO(dataReader["LineNo"].ToString());
                    po.setPONo(dataReader["PONo"].ToString());
                    po.setDescriptionNO(dataReader["DescriptionNo"].ToString());
                    po.setETADate(dataReader["ETADate"].ToString());
                }
                connection.Close();
            }
            catch (Exception ex)
            {
            }

            DateTime poETADate = DateTime.Parse(po.getETADate());
            DateTime doDate    = DateTime.Parse(deliveryOrder.getDeliveryDate());

            if (doDate <= poETADate)
            {
                return(false);
            }
            else
            {
                return(true);
            }
        }
Example #2
0
        public bool Validate(DeliveryOrder deliveryOrder)
        {
            PurchaseOrderItem po = new PurchaseOrderItem();

            //var con = ConfigurationManager.ConnectionStrings["Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=\"C: \\Users\\PUA\\Desktop\\FYP test\\FYP test\\fypDB.mdf\";Integrated Security=True"] .ConnectionString;
            //SqlConnection myConnection = new SqlConnection(con);
            //string queryString = "select * from PurchaseOrder where PONo = @PONo";
            //SqlCommand query = new SqlCommand(queryString, myConnection);
            //query.Parameters.AddWithValue("@PONo", deliveryOrder.getPONo());
            //}
            //myConnection.Open();


            //using (SqlDataReader oReader = query.ExecuteReader())
            //{
            //    while (oReader.Read())
            //    {
            //        po.setLineNO(oReader["LineNo"].ToString());
            //        po.setPONo(oReader["PONo"].ToString());
            //        po.setDescriptionNO(oReader["DescriptionNo"].ToString());
            //        po.setETADate(oReader["ETADate"].ToString());
            //    }
            //}

            string        connectionString = null;
            SqlConnection connection;
            SqlCommand    command;
            string        sql = null;
            SqlDataReader dataReader;

            connectionString = "Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=\"C:\\Users\\PUA\\Desktop\\FYP test\\FYP test\\fypDB.mdf\";Integrated Security=True";
            sql        = "select * from POItems where PONo = @PONo";
            connection = new SqlConnection(connectionString);

            try
            {
                connection.Open();
                command = new SqlCommand(sql, connection);
                command.Parameters.AddWithValue("@PONo", deliveryOrder.getPONo());
                dataReader = command.ExecuteReader();
                while (dataReader.Read())
                {
                    po.setLineNO(dataReader["LineNo"].ToString());
                    po.setPONo(dataReader["PONo"].ToString());
                    po.setDescriptionNO(dataReader["DescriptionNo"].ToString());
                    po.setETADate(dataReader["ETADate"].ToString());
                }
            }catch (Exception ex)
            {
            }


            if (deliveryOrder.getPONo().Equals(po.getPoNo()))
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }