Esempio n. 1
0
        /// <summary>
        /// Creates a new instance of the Sol_WS_Carriers class and populates it with data from the specified SqlDataReader.
        /// </summary>
        protected virtual Sol_WS_Carrier MakeSol_WS_Carrier(SqlDataReader dataReader)
        {
            Sol_WS_Carrier sol_WS_Carrier = new Sol_WS_Carrier();

            sol_WS_Carrier.CarrierID = SqlClientUtility.GetInt32(dataReader, "CarrierID", 0);
            sol_WS_Carrier.Carrier   = SqlClientUtility.GetString(dataReader, "Carrier", String.Empty);

            return(sol_WS_Carrier);
        }
Esempio n. 2
0
        /// <summary>
        /// Updates a record in the Sol_WS_Carriers table.
        /// </summary>
        public virtual void Update(Sol_WS_Carrier sol_WS_Carrier)
        {
            ValidationUtility.ValidateArgument("sol_WS_Carrier", sol_WS_Carrier);

            SqlParameter[] parameters = new SqlParameter[]
            {
                new SqlParameter("@CarrierID", sol_WS_Carrier.CarrierID),
                new SqlParameter("@Carrier", sol_WS_Carrier.Carrier)
            };

            SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "Sol_WS_Carriers_Update", parameters);
        }
Esempio n. 3
0
        /// <summary>
        /// Selects all records from the Sol_WS_Carriers table.
        /// </summary>
        public virtual List <Sol_WS_Carrier> SelectAll()
        {
            using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(connectionStringName, CommandType.StoredProcedure, "Sol_WS_Carriers_SelectAll"))
            {
                List <Sol_WS_Carrier> sol_WS_CarrierList = new List <Sol_WS_Carrier>();
                while (dataReader.Read())
                {
                    Sol_WS_Carrier sol_WS_Carrier = MakeSol_WS_Carrier(dataReader);
                    sol_WS_CarrierList.Add(sol_WS_Carrier);
                }

                return(sol_WS_CarrierList);
            }
        }
Esempio n. 4
0
        private void buttonPrintRBill_Click(object sender, EventArgs e)
        {
            dataGridViewCurrentShipment.Focus();

            if (dataGridViewCurrentShipment.SelectedRows.Count < 1)
            {
                MessageBox.Show("Please select a Shipment to print", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }

            RBillNumber = dataGridViewCurrentShipment.SelectedRows[0].Cells[0].Value.ToString();
            string status        = dataGridViewCurrentShipment.SelectedRows[0].Cells[3].Value.ToString();
            string strShipmentId = dataGridViewCurrentShipment.SelectedRows[0].Cells[5].Value.ToString();
            string agencyName    = dataGridViewCurrentShipment.SelectedRows[0].Cells[1].Value.ToString();
            string rBillDate     = dataGridViewCurrentShipment.SelectedRows[0].Cells[2].Value.ToString();

            if (status != "S")
            {
                MessageBox.Show("Only shipped Shipments can be printed.", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }


            this.Cursor = Cursors.WaitCursor;

            if (agencyName.Trim().ToLower() == "abcrc")
            {
                int shipmentId = 0;
                Int32.TryParse(strShipmentId, out shipmentId);

                if (sol_Shipment_Sp == null)
                {
                    sol_Shipment_Sp = new Sol_Shipment_Sp(Properties.Settings.Default.WsirDbConnectionString);
                }
                sol_Shipment = sol_Shipment_Sp.Select(shipmentId);

                if (sol_WS_Carrier_Sp == null)
                {
                    sol_WS_Carrier_Sp = new Sol_WS_Carrier_Sp(Properties.Settings.Default.WsirDbConnectionString);
                }
                sol_WS_Carrier = sol_WS_Carrier_Sp.Select(sol_Shipment.CarrierID);
                if (sol_WS_Carrier == null)
                {
                    sol_WS_Carrier           = new Sol_WS_Carrier();
                    sol_WS_Carrier.CarrierID = 0;
                    sol_WS_Carrier.Carrier   = String.Empty;
                }

                ShippingShipments.UpdateDataSetBol2(shipmentId, RBillNumber);

                ShippingShipments.PrintBol2(
                    shipmentId,
                    RBillNumber,
                    sol_Shipment.ShippedDate.ToString(),
                    sol_WS_Carrier.Carrier,
                    sol_Shipment.TrailerNumber,
                    sol_Shipment.ProBillNumber
                    );
            }
            else
            {
                ShippingShipments.PrintRBill(strShipmentId);
            }

            this.Cursor = Cursors.Default;
        }